private void LoadMemberDetails() { BusinessLayer.SMS.GeneralMember objGeneralMember = new BusinessLayer.SMS.GeneralMember(); DataTable DT = objGeneralMember.GetAllById(MemberId); if (DT.Rows.Count > 0) { txtName.Text = DT.Rows[0]["Name"].ToString(); txtCompanyName.Text = DT.Rows[0]["CompanyName"].ToString(); txtVillage.Text = DT.Rows[0]["Village"].ToString(); txtPostOffice.Text = DT.Rows[0]["PostOffice"].ToString(); txtPoliceStation.Text = DT.Rows[0]["PoliceStation"].ToString(); txtPinCode.Text = DT.Rows[0]["PinCode"].ToString(); txtBlockName.Text = DT.Rows[0]["BlockName"].ToString(); txtDistrictName.Text = DT.Rows[0]["DistrictName"].ToString(); txtStateName.Text = DT.Rows[0]["StateName"].ToString(); txtCode.Text = DT.Rows[0]["Code"].ToString(); txtMobileNo.Text = DT.Rows[0]["MobileNo"].ToString(); txtPhoneNo.Text = DT.Rows[0]["PhoneNo"].ToString(); ddlCategory.SelectedValue = DT.Rows[0]["CategoryId"].ToString(); lblMsg.Text = ""; btnSave.Text = "Edit"; } }
protected void btnSave_Click(object sender, EventArgs e) { BusinessLayer.SMS.GeneralMember objGeneralMember = new BusinessLayer.SMS.GeneralMember(); Entity.SMS.GeneralMember generalMember = new Entity.SMS.GeneralMember(); generalMember.MemberId = MemberId; generalMember.Name = txtName.Text.Trim(); generalMember.CompanyName = txtCompanyName.Text.Trim(); generalMember.Village = txtVillage.Text.Trim(); generalMember.PostOffice = txtPostOffice.Text.Trim(); generalMember.PoliceStation = txtPoliceStation.Text.Trim(); generalMember.PinCode = txtPinCode.Text.Trim(); generalMember.BlockName = txtBlockName.Text.Trim(); generalMember.DistrictName = txtDistrictName.Text.Trim(); generalMember.StateName = txtStateName.Text.Trim(); generalMember.Code = txtCode.Text.Trim(); generalMember.MobileNo = txtMobileNo.Text.Trim(); generalMember.PhoneNo = txtPhoneNo.Text.Trim(); generalMember.CategoryId = Convert.ToInt32(ddlCategory.SelectedValue); int RowsAffected = objGeneralMember.Save(generalMember); if (RowsAffected > 0) { ClearControls(); LoadMemberList(); lblMsg.Text = "Saved Successfully"; } else { lblMsg.Text = "Can Not Save. Mobile No Already Exists"; } }
private void LoadMemberList() { string Name = txtSearchName.Text; string Mobile = txtSearchMob.Text; BusinessLayer.SMS.GeneralMember objGeneralMember = new BusinessLayer.SMS.GeneralMember(); DataTable DT = objGeneralMember.GetAll(Name, Mobile); dgvGeneralMember.DataSource = DT; dgvGeneralMember.DataBind(); }
protected void dgvGeneralMember_RowDeleting(object sender, GridViewDeleteEventArgs e) { BusinessLayer.SMS.GeneralMember objGeneralMember = new BusinessLayer.SMS.GeneralMember(); objGeneralMember.Delete(Convert.ToInt32(dgvGeneralMember.DataKeys[e.RowIndex].Value)); LoadMemberList(); }