private void BindGrid() { string connection = Request.Cookies["Company"].Value; DataSet ds = new DataSet(); BusinessLogic bl = new BusinessLogic(); object usernam = Session["LoggedUserName"]; string txtSearch = string.Empty; ds = bl.ListUsers(txtSearch, connection); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { GrdViewCust.DataSource = ds.Tables[0].DefaultView; GrdViewCust.DataBind(); } } else { GrdViewCust.DataSource = null; GrdViewCust.DataBind(); } }
private void FillUserGrid(DataView dvuserData) { GrdViewCust.DataSource = dvuserData; GrdViewCust.DataBind(); if (dvuserData.Count == 0) { errordisplay1.AddItem("No customer found for the Search Criteria.", DisplayIcons.Information, false); } }
protected void cmdSave_Click(object sender, EventArgs e) { try { DataSet ds; DataTable dt; DataRow drNew; DataColumn dc; ds = new DataSet(); dt = new DataTable(); dc = new DataColumn("UserName"); dt.Columns.Add(dc); dc = new DataColumn("Role"); dt.Columns.Add(dc); dc = new DataColumn("RoleDesc"); dt.Columns.Add(dc); dc = new DataColumn("Section"); dt.Columns.Add(dc); dc = new DataColumn("Area"); dt.Columns.Add(dc); dc = new DataColumn("Orderno"); dt.Columns.Add(dc); dc = new DataColumn("Add"); dt.Columns.Add(dc); dc = new DataColumn("Edit"); dt.Columns.Add(dc); dc = new DataColumn("Delete"); dt.Columns.Add(dc); dc = new DataColumn("View"); dt.Columns.Add(dc); ds.Tables.Add(dt); bool Add = false; bool Edit = false; bool Delete = false; bool Views = false; Label lblDebtorID = null; for (int vLoop = 0; vLoop < GrdViewItem.Rows.Count; vLoop++) { CheckBox txt = (CheckBox)GrdViewItem.Rows[vLoop].FindControl("chkboxAdd"); if (txt.Checked) { Add = txt.Checked; } else { Add = false; } CheckBox txttt = (CheckBox)GrdViewItem.Rows[vLoop].FindControl("chkboxEdit"); if (txttt.Checked) { Edit = txttt.Checked; } else { Edit = false; } CheckBox txth = (CheckBox)GrdViewItem.Rows[vLoop].FindControl("chkboxDel"); if (txth.Checked) { Delete = txth.Checked; } else { Delete = false; } CheckBox txthh = (CheckBox)GrdViewItem.Rows[vLoop].FindControl("chkboxView"); if (txthh.Checked) { Views = txthh.Checked; } else { Views = false; } drNew = dt.NewRow(); drNew["UserName"] = txtUser.Text; drNew["Role"] = GrdViewItem.Rows[vLoop].Cells[3].Text; drNew["RoleDesc"] = GrdViewItem.Rows[vLoop].Cells[2].Text; drNew["Section"] = GrdViewItem.Rows[vLoop].Cells[1].Text; drNew["Area"] = GrdViewItem.Rows[vLoop].Cells[0].Text; lblDebtorID = (Label)GrdViewItem.Rows[vLoop].FindControl("lblDebtorID"); drNew["Orderno"] = lblDebtorID.Text; drNew["Add"] = Add; drNew["Edit"] = Edit; drNew["Delete"] = Delete; drNew["View"] = Views; ds.Tables[0].Rows.Add(drNew); } string Userna = Request.Cookies["LoggedUserName"].Value; string userName = string.Empty; string Email = string.Empty; string connection = string.Empty; bool Locked = chkAccLocked.Checked; bool DateLock = chkboxdatelock.Checked; if (txtUser.Text != string.Empty) { userName = txtUser.Text; } if (txtEmail.Text != string.Empty) { Email = txtEmail.Text; } if (Request.Cookies["Company"] != null) { connection = Request.Cookies["Company"].Value; } string UserGroup = string.Empty; bool DateLoc = true; DataSet dsd = new DataSet(); DataSet dsbranch = new DataSet(); int EmpNo = 0; if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { BusinessLogic objBL = new BusinessLogic(); objBL = new BusinessLogic(ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString()); if (Session["Show"] == "Add New") { if (objBL.InsertUserOptions(ds, Userna, userName, Email, Locked, DateLock, dsd, "", EmpNo, UserGroup, DateLoc, dsbranch, false, "", false, "")) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('User And their Options Saved Successfully');", true); //BindGrid(); } else { ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('User already exists. Please try again.');", true); return; } } else if (Session["Show"] == "Edit") { objBL.UpdateUserOptions(connection, ds, Userna, userName, Email, Locked, DateLock, dsd, "", EmpNo, UserGroup, DateLoc, dsbranch, false, "", false, ""); ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('User And their Options Updated Successfully');", true); //BindGrid(); } } else { } } ModalPopupGet.Hide(); GrdViewCust.DataBind(); UpdatePanelPage.Update(); } catch (Exception ex) { TroyLiteExceptionManager.HandleException(ex); } }