public static Entity.Common.NECCMemberMaster GetNECCMemberById(int NECCMemberId)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@pNECCMemberId", SqlDbType.Int, ParameterDirection.Input, NECCMemberId);
SqlDataReader dr = oDm.ExecuteReader("NECCMember_GetById");
Entity.Common.NECCMemberMaster NECCMember = new Entity.Common.NECCMemberMaster();
if (dr.HasRows)
{
while (dr.Read())
{
NECCMember.NECCMemberId = NECCMemberId;
NECCMember.DistrictId = (dr[1] == DBNull.Value) ? 0 : int.Parse(dr["DistrictId"].ToString());
NECCMember.MemberName = (dr[2] == DBNull.Value) ? "" : dr["MemberName"].ToString();
NECCMember.MobileNo = (dr[3] == DBNull.Value) ? "" : dr["MobileNo"].ToString();
NECCMember.Address = (dr[4] == DBNull.Value) ? "" : dr["Address"].ToString();
NECCMember.IsActive = (dr[5] == DBNull.Value) ? false : Convert.ToBoolean(dr["IsActive"]);
NECCMember.Remarks = (dr[6] == DBNull.Value) ? "" : dr["Remarks"].ToString();
}
}
return(NECCMember);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
BusinessLayer.Common.NECCMemberMaster objNECCMember = new BusinessLayer.Common.NECCMemberMaster();
Entity.Common.NECCMemberMaster sMSMember = new Entity.Common.NECCMemberMaster();
sMSMember.NECCMemberId = NECCMemberId;
sMSMember.MemberName = txtMemberName.Text.Trim();
sMSMember.MobileNo = txtMobileNo.Text.Trim();
sMSMember.Address = txtAddress.Text.Trim();
//sMSMember.MemberType = Convert.ToInt32(ddlRegType.SelectedValue);
sMSMember.IsActive = chkIsActive.Checked;
sMSMember.DistrictId = Convert.ToInt32(ddlDistrict2.SelectedValue);
int RowsUpdated = objNECCMember.Save(sMSMember, txtRemarks.Text.Trim());
if (RowsUpdated > 0)
{
LoadNECCMember();
Message.IsSuccess = true;
Message.Text = "Data Saved Successfully.";
ClearControl();
if (RedirectUrl != null && RedirectUrl.Length > 0)
{
Response.Redirect(RedirectUrl);
}
}
else
{
Message.IsSuccess = false;
Message.Text = "Can Not Save.";
}
Message.Show = true;
}
public static int Save(Entity.Common.NECCMemberMaster smsmember, string txtRemarks)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pNECCMemberId", SqlDbType.Int, ParameterDirection.InputOutput, smsmember.NECCMemberId);
oDm.Add("@pMemberName", SqlDbType.VarChar, 150, smsmember.MemberName);
oDm.Add("@pMobileNo", SqlDbType.VarChar, 20, smsmember.MobileNo);
oDm.Add("@pAddress", SqlDbType.VarChar, 500, smsmember.Address);
oDm.Add("@pIsActive", SqlDbType.Bit, smsmember.IsActive);
oDm.Add("@pRemarks", SqlDbType.VarChar, 500, txtRemarks);
oDm.Add("@pDistrictId", SqlDbType.Int, smsmember.DistrictId);
oDm.CommandType = CommandType.StoredProcedure;
return(oDm.ExecuteNonQuery("NECCMember_Save"));
}
}
protected void PopulateNECCMember()
{
BusinessLayer.Common.NECCMemberMaster objNECCMember = new BusinessLayer.Common.NECCMemberMaster();
Entity.Common.NECCMemberMaster sMSMember = new Entity.Common.NECCMemberMaster();
sMSMember = objNECCMember.GetNECCMemberById(NECCMemberId);
if (sMSMember != null)
{
NECCMemberId = sMSMember.NECCMemberId;
txtMemberName.Text = sMSMember.MemberName.ToString();
txtMobileNo.Text = sMSMember.MobileNo.ToString();
txtAddress.Text = sMSMember.Address.ToString();
chkIsActive.Checked = Convert.ToBoolean(sMSMember.IsActive);
ddlDistrict2.SelectedValue = sMSMember.DistrictId.ToString();
txtRemarks.Text = sMSMember.Remarks.ToString();
txtMemberName.Enabled = false;
btnSave.Text = "Update";
}
}
public int Save(Entity.Common.NECCMemberMaster neccmember, string txtRemarks)
{
return(DataAccess.Common.NECCMemberMaster.Save(neccmember, txtRemarks));
}
