Insert values from Checkboxlist

Riddhi Valecha

9y838.NET

Hi all..

I have a page frmLocationMaster.aspx. ..

On this, I am having 2 checkboxlist controls -

1. checkboxlistusers

2. checkboxlistlocation

Uitlity -

Users must get access to specific locations only ..

Eg -

User Table

ID	User
1	A
2	B
3	C
4	D
5	E

ID	Location
1	UP
2	Bihar
3	Andhra Pradesh
4	Karnataka
5	Maharashtra
6	West Bengal
7	Gujarat
8	Rajasthan

Suppose, Users - A,B,C must have access to Location - UP, Rajasthan and Bihar.

Then, user will select - users -A,B,C From userscheckboxlist and Location - UP, Rajastahn,Bihar from LocationCheckboxlist.

On button click event - Following data must be inserted -

UserID	Location
A	UP
B	UP
C	UP
A	Rajasthan
B	Rajasthan
C	Rajasthan
A	Bihar
B	Bihar
C	Bihar

How to do this ??

Please guide ..

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Brijesh Rathor9y ago
Accepted answer
Hi,
Try like this,
for frontend : -
---------------------------------

for backend :-
--------------------------------------------
// Here i added user and location list for checkboxlist
public class users
{
public int id { get; set; }
public string Value { get; set; }
public bool isselected { get; set; }
}
public class USERS
{
public static List userList
{
get
{
List lst = new List();
lst.Add(new users() { id = 1, Value = "A" ,isselected = false});
lst.Add(new users() { id = 2, Value = "B" });
lst.Add(new users() { id = 3, Value = "C" });
lst.Add(new users() { id = 4, Value = "D" });
lst.Add(new users() { id = 5, Value = "E" });
return lst;
}
}
}
public class USERLOCATIONS
{
public static List userlocationList
{
get
{
List lst = new List();
lst.Add(new users() { id = 1, Value = "UP" , isselected = false });
lst.Add(new users() { id = 2, Value = "BIHAR" });
lst.Add(new users() { id = 3, Value = "ANDHRAPRADESH" });
lst.Add(new users() { id = 4, Value = "KARNATAKA" });
lst.Add(new users() { id = 5, Value = "MAHARASTRA" });
lst.Add(new users() { id = 6, Value = "WESTBENGAL" });
lst.Add(new users() { id = 7, Value = "GUJRAT" });
lst.Add(new users() { id = 8, Value = "RAJSTHAN" });
return lst;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
chkUserlist.DataSource = USERS.userList;
chkUserlist.DataTextField = "Value";
chkUserlist.DataValueField = "id";
chkUserlist.DataBind();
chkUserLocationslist.DataSource = USERLOCATIONS.userlocationList;
chkUserLocationslist.DataValueField = "id";
chkUserLocationslist.DataTextField = "Value";
chkUserLocationslist.DataBind();
}
}
protected void Submit_Details(object sender , EventArgs e)
{
int selectedUserCount = chkUserlist.Items.Cast().Count(li => li.Selected);
int selectedLocationCount = chkUserLocationslist.Items.Cast().Count(li => li.Selected);
List selectedusersarray = new List();
List selectedlocationarray = new List();
IEnumerable newuserid = new List();
IEnumerable newuserlocations = new List();
string items = string.Empty; string itemsuserlocations = string.Empty; string[] userid = new string[selectedUserCount]; string[] userlocation = new string[selectedLocationCount];
// Getting all checked userTexts
foreach (ListItem i in chkUserlist.Items)
{
if (i.Selected == true)
{
items += i.Text + ",";
}
}
// Getting all checked userLocationTexts
foreach (ListItem j in chkUserLocationslist.Items)
{
if (j.Selected == true)
{
itemsuserlocations += j.Text + ",";
}
}
// Converted usertext and userlocation into list
for (var i = 0; i < chkUserLocationslist.Items.Count; i++)
{
var data = chkUserLocationslist.Items[i];
if (data.Selected == true)
{
userid = items.Split(',');
userlocation = itemsuserlocations.Split(',');
newuserid = userid.Take(userid.Count() - 1);
newuserlocations = userlocation.Take(userlocation.Count() - 1);

}
}
// getting required usersids result

for (var k = 0; k < selectedLocationCount; k++)
{
selectedusersarray.AddRange(newuserid);
}

// getting required location result
for (var ki = 0; ki < chkUserLocationslist.Items.Count; ki++ )
{
if (chkUserLocationslist.Items[ki].Selected == true)
{
var dataresult = chkUserLocationslist.Items[ki];
for (var k = 0; k < selectedusersarray.Count; k++)
{
if(newuserid.Count() > k)
selectedlocationarray.Add(dataresult.Text);

}
}
}

Hope this will help u.
Mayank9y ago
Model Class:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace ValidationsMvc.Models
{
    public class CheckBoxClass
    {
        public List Usr { get; set; }
        public List Loc { get; set; }
        public string LocationList { get; set; }
        public string UserList { get; set; }
    }
    public class Users
    {
        public int Id { get; set; }
        public string UserName { get; set; }
    }
    public class Location
    {
        public int Id { get; set; }
        public string LocationName { get; set; }
    }
}

Controller code:

public ActionResult CheckBoxListSelection()
        {
            var user = new Users
            {
                Id= 1,
                UserName = "A"
            };
            var user2 = new Users
            {
                Id = 2,
                UserName = "B"
            };
            var user3 = new Users
            {
                Id = 3,
                UserName = "C"
            };

            List list = new List();
            list.Add(user);
            list.Add(user2);
            list.Add(user3);

            var loc = new Location
            {
                Id = 1,
                LocationName = "UP"
            };
            var loc2 = new Location
            {
                Id = 2,
                LocationName = "Delhi"
            };
            var loc3 = new Location
            {
                Id = 3,
                LocationName = "Bihar"
            };

            List lst = new List();
            lst.Add(loc);
            lst.Add(loc2);
            lst.Add(loc3);

            var model = new CheckBoxClass
            {
                Usr = list,
                Loc=lst
            };

            return View(model);
        }

        [HttpPost]
        public ActionResult CheckBoxListSelection(CheckBoxClass model)
        {
            //Here you will get the location and user in list u can split it by split function     and save in DB
            return RedirectToAction("CheckBoxListSelection");
        }

View:

@model   ValidationsMvc.Models.CheckBoxClass
@*~/Models/CheckBoxClass.cs*@

@{
    ViewBag.Title = "CheckBoxListSelection";
}

CheckBoxListSelection

@using (Html.BeginForm("CheckBoxListSelection", "Home", FormMethod.Post))
{

    @foreach (var items in Model.Usr as List
        )
    {










                    @items.UserName


    }
    @Html.HiddenFor(M => M.UserList, new { id = "userIdLst" })


    @foreach (var items in Model.Loc as List
        )
    {










                    @items.LocationName


    }
    @Html.HiddenFor(M => M.LocationList, new { id = "locIdLst" })



}

If this resolve your issue please mark as answer
Manas Mohapatra9y ago
Try with below code..
foreach (ListItem userItem in checkboxlistusers.Items)
{
    if (userItem.Selected)
    {
        foreach (ListItem locationItem in checkboxlistlocation.Items)
        {
            if (locationItem.Selected) {

                var locationName = locationItem.Value;
                var userName = userItem.Value;

                // insert locationName, userName into database..
            }
        }
    }
}
Suvendu Shekhar Giri9y ago
Share the relevant code you have tried so far.

Insert values from Checkboxlist

CheckBoxListSelection