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"; } }
public static int Save(Entity.SMS.GeneralMember generalMember) { using (DataManager oDm = new DataManager()) { oDm.Add("@MemberId", SqlDbType.Int, generalMember.MemberId); oDm.Add("@Name", SqlDbType.VarChar, generalMember.Name); oDm.Add("@CompanyName", SqlDbType.VarChar, generalMember.CompanyName); oDm.Add("@Village", SqlDbType.VarChar, generalMember.Village); oDm.Add("@PostOffice", SqlDbType.VarChar, generalMember.PostOffice); oDm.Add("@PoliceStation", SqlDbType.VarChar, generalMember.PoliceStation); oDm.Add("@PinCode", SqlDbType.VarChar, generalMember.PinCode); oDm.Add("@BlockName", SqlDbType.VarChar, generalMember.BlockName); oDm.Add("@DistrictName", SqlDbType.VarChar, generalMember.DistrictName); oDm.Add("@StateName", SqlDbType.VarChar, generalMember.StateName); oDm.Add("@Code", SqlDbType.VarChar, generalMember.Code); oDm.Add("@MobileNo", SqlDbType.VarChar, generalMember.MobileNo); oDm.Add("@PhoneNo", SqlDbType.VarChar, generalMember.PhoneNo); oDm.Add("@CategoryId", SqlDbType.Int, generalMember.CategoryId); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteNonQuery("usp_GeneralMember_Save")); } }
public int Save(Entity.SMS.GeneralMember generalMember) { return(DataAccess.SMS.GeneralMember.Save(generalMember)); }