using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml; using System.Data.SqlClient; using System.Data.SqlTypes; public partial class Administrator_UserEdit : System.Web.UI.Page { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString); DataSet ds = new DataSet(); SqlCommand cmd; FillDD objFillDD = new FillDD(); Dashboard objDash = new Dashboard(); protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Fill_GridUser(); } } private void Fill_GridUser() { try { SqlDataAdapter adp = new SqlDataAdapter("SELECT tbl_UserAccount.*, tbl_Department.Department FROM tbl_UserAccount INNER JOIN tbl_Department ON tbl_UserAccount.DeptId = tbl_Department.DeptId Order By Id Desc ", con); adp.Fill(ds, "User2"); adp.Dispose(); GVUser.DataSource = ds.Tables["User2"]; GVUser.DataBind(); if (GVUser.Rows.Count < 1) { lblDgErr.Text = "Alert! : Zero Records in Database"; } else { lblDGCount.Text = GVUser.Rows.Count.ToString(); objDash.Count_Total(ref lblDGCount, "Id", "tbl_UserAccount", "", ref lblDgErr); } } catch (Exception ex) { lblDgErr.Text = ("GV Alert! : " + ex.Message); } } protected void GVMenuItem_PageIndexChanging(object sender, GridViewPageEventArgs e) { lblDgErr.Text = ""; try { GVUser.PageIndex = e.NewPageIndex; Fill_GridUser(); } catch (Exception exp) { lblDgErr.Text = ("GV Paging Alert! : " + exp.Message); } } protected void GVUser_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { try { lblDgErr.Text = ""; GVUser.EditIndex = -1; Fill_GridUser(); } catch (Exception exp) { lblDgErr.Text = ("GV Cancel Alert! : " + exp.Message); } } protected void GVUser_RowDataBound(object sender, GridViewRowEventArgs e) { } protected void GVUser_RowEditing(object sender, GridViewEditEventArgs e) { try { lblDgErr.Text = ""; int row = e.NewEditIndex; Label lblDeptId = (Label)GVUser.Rows[row].FindControl("lblDgDeptId"); Label lblStatus = (Label)GVUser.Rows[row].FindControl("lblDgStatus"); GVUser.EditIndex = e.NewEditIndex; Fill_GridUser(); DropDownList ddl = (DropDownList)GVUser.Rows[row].FindControl("DgDDDept"); SqlDataAdapter adp = new SqlDataAdapter("SELECT DeptId, Department from tbl_Department", con); DataSet ds1 = new DataSet(); adp.Fill(ds, "DepId"); adp.Dispose(); ddl.DataSource = ds.Tables["DepId"]; ddl.DataTextField = "Department"; ddl.DataValueField = "DeptId"; ddl.DataBind(); ListItem li = default(ListItem); li = ddl.Items.FindByValue(lblDeptId.Text); if ((li != null)) li.Selected = true; DropDownList ddlStat = (DropDownList)GVUser.Rows[row].FindControl("DgDDStatus"); ListItem li2 = default(ListItem); li2 = ddlStat.Items.FindByText(lblStatus.Text.Trim()); if ((li2 != null)) li2.Selected = true; } catch (Exception exp) { lblDgErr.Text = ("GV Edit Alert! : " + exp.Message); } } protected void GVUser_RowUpdating(object sender, GridViewUpdateEventArgs e) { lblDgErr.Text = ""; String Dgid; int row = e.RowIndex; try { Dgid = ((Label)(GVUser.Rows[row].FindControl("lblDgId"))).Text; TextBox txtDGFName1 = (TextBox)GVUser.Rows[row].FindControl("txtDgFName"); TextBox txtDGLName1 = (TextBox)GVUser.Rows[row].FindControl("txtDgLName"); TextBox txtDGEmail1 = (TextBox)GVUser.Rows[row].FindControl("txtDGEmail"); TextBox txtDGPass1 = (TextBox)GVUser.Rows[row].FindControl("txtDGPass"); TextBox txtDGMobile1= (TextBox)GVUser.Rows[row].FindControl("txtDGMobile"); DropDownList ddDgDept = (DropDownList)GVUser.Rows[row].FindControl("DgDDDept"); DropDownList ddDgStatus = (DropDownList)GVUser.Rows[row].FindControl("DgDDStatus"); if (txtDGEmail1.Text == "") { lblDgErr.Text = "Plese Enter Email"; txtDGEmail1.Focus(); } else { objDash.Check_UniqueGv("Id", "Email", "tbl_UserAccount", txtDGEmail1.Text, Dgid, ref lblDgErr); if (lblDgErr.Text == "Yes") { lblDgErr.Text = ""; SqlCommand cmd = new SqlCommand("SpUpdateUser", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Id", Dgid)); cmd.Parameters.Add(new SqlParameter("@FName", txtDGFName1.Text)); cmd.Parameters.Add(new SqlParameter("@LName", txtDGLName1.Text)); cmd.Parameters.Add(new SqlParameter("@Email", txtDGEmail1.Text)); cmd.Parameters.Add(new SqlParameter("@Pass", txtDGPass1.Text)); cmd.Parameters.Add(new SqlParameter("@Mobile", txtDGMobile1.Text)); cmd.Parameters.Add(new SqlParameter("@Dept", ddDgDept.SelectedItem.Value)); cmd.Parameters.Add(new SqlParameter("@Status", ddDgStatus.SelectedItem.Text)); cmd.Parameters.Add(new SqlParameter("@EntryBy", Session["AdminAuth"])); cmd.Parameters.Add(new SqlParameter("@EntryDt", DateTime.Today)); con.Open(); cmd.ExecuteNonQuery(); lblDgErr.Text = "Data Updated Successfully"; GVUser.EditIndex = -1; } } } catch (Exception exp) { lblDgErr.Text = "GV Update Alert : " + exp.Message; } finally { con.Close(); Fill_GridUser(); } } }