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));
}
