/// <summary> /// Get Records For Edit/Update /// </summary> private void GetRecords() { DataTable table = BAL_AdminList.GetAdminList(Convert.ToInt32(lblMode.Text)); if (table != null && table.Rows.Count > 0) { txtFirstName.Text = Convert.ToString(table.Rows[0]["FirstName"]); txtLastName.Text = Convert.ToString(table.Rows[0]["LastName"]); txtEmail.Text = Convert.ToString(table.Rows[0]["Email"]); txtPhn.Text = Convert.ToString(table.Rows[0]["Mobile"]); // make password field to hidden means insert star into password textbox table.Rows[0]["Password"] = Convert.ToString(table.Rows[0]["Password"]); string strPass = string.Empty; for (int i = 0; i < Convert.ToString(table.Rows[0]["Password"]).Length; i++) { strPass = strPass + "*"; } if (!string.IsNullOrEmpty(strPass)) { table.Rows[0]["Password"] = strPass; txtPassword.Attributes.Add("value", Convert.ToString(table.Rows[0]["Password"])); txtConfirmPassword.Attributes.Add("value", Convert.ToString(table.Rows[0]["Password"])); } //txtPassword.Text = Convert.ToString(table.Rows[0]["Password"]); //txtConfirmPassword.Text = Convert.ToString(table.Rows[0]["Password"]); } }
private void FillRecords(int Id) { DataTable table = BAL_AdminList.GetAdminList(Id); if (table.Rows.Count > 0) { table.Rows[0]["Password"] = Convert.ToString(table.Rows[0]["Password"]); string strPass = string.Empty; for (int i = 0; i < Convert.ToString(table.Rows[0]["Password"]).Length; i++) { strPass = strPass + "*"; } if (!string.IsNullOrEmpty(strPass)) { table.Rows[0]["Password"] = strPass; } dvDetails.DataSource = table; dvDetails.DataBind(); } else { dvDetails.DataSource = table; dvDetails.DataBind(); } }
private void FillGrid(string FirstName, string LastName, string Email) { int TotalCount; gvAdminList.PageIndex = gvIndex; DataTable table = BAL_AdminList.GetAdminDetails(FirstName, LastName, Email, gvAdminList.PageIndex, gvAdminList.PageSize, gvAdminList.OrderBy, out TotalCount, "getadminlist", 1, 0); gvAdminList.VirtualItemCount = TotalCount; gvAdminList.DataSource = table; gvAdminList.DataBind(); DispHideControls(); }
/// <summary> /// Fetch the records and fill the grid /// </summary> private void FillGrid(string UserName, string Email) { UserName = Server.HtmlDecode(UserName); Email = Server.HtmlDecode(Email); int TotalCount; gvAdminList.PageIndex = gvIndex; DataTable table = BAL_AdminList.GetAdminList(UserName, Email, gvAdminList.PageIndex, gvAdminList.PageSize, out TotalCount); gvAdminList.VirtualItemCount = TotalCount; gvAdminList.DataSource = table; gvAdminList.DataBind(); HideDispGridCol(); }
protected void btnSave_Click(object sender, EventArgs e) { if (ValidationInput() == false) { Page.Validate("CheckAtSave"); if (Page.IsValid == true) { txtFirstName.Text = Server.HtmlEncode(txtFirstName.Text); txtLastName.Text = Server.HtmlEncode(txtLastName.Text); txtEmail.Text = Server.HtmlEncode(txtEmail.Text); txtPassword.Text = Server.HtmlEncode(txtPassword.Text); txtPhn.Text = Server.HtmlEncode(txtPhn.Text); if (BAL_AdminList.CheckAdminExist(txtEmail.Text.Trim(), Convert.ToInt32(lblMode.Text)) == false) { string _Sex = string.Empty; if (Convert.ToString(rdoSex.SelectedItem.Text).ToUpper() == "MALE") { _Sex = "M"; } else { _Sex = "F"; } if (!string.IsNullOrEmpty(lblMode.Text) && lblMode.Text != "0") { //update records InsertUpdateRecords(BAL_AdminList.UpdateAdminList(txtFirstName.Text, txtLastName.Text, _Sex, txtEmail.Text, txtPassword.Text, txtPhn.Text, Convert.ToInt32(lblMode.Text)), true); } else { //insert InsertUpdateRecords(BAL_AdminList.InsertAdminList(txtFirstName.Text, txtLastName.Text, _Sex, txtEmail.Text, txtPassword.Text, txtPhn.Text), true); } } else { ShowMessage("Admin with this email is already inserted!"); } } else { ShowMessage("Some Required Field Missing"); } } }
protected void btnInActive_Click(object sender, EventArgs e) { string str = UpdateDetails(); if (!string.IsNullOrEmpty(str)) { if (BAL_AdminList.UpdateStatusForAdmin(str, false)) { ShowMessage("Record Inactiveted Succefully."); FillGrid(); } else { ShowMessage("Error in record updatation."); } } }
protected void btnDelete_Click(object sender, EventArgs e) { string str = UpdateDetails(); if (!string.IsNullOrEmpty(str)) { if (BAL_AdminList.DeleteAdminList(str)) { ShowMessage("Record Deleted Succefully."); FillGrid(); } else { ShowMessage("Error in record updatation."); } } }