public static Entity.Common.SMSMember GetSMSMemberById(int sMSMemberId)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@pSMSMemberId", SqlDbType.Int, ParameterDirection.Input, sMSMemberId);
SqlDataReader dr = oDm.ExecuteReader("SMSMember_GetById");
Entity.Common.SMSMember sMSMember = new Entity.Common.SMSMember();
if (dr.HasRows)
{
while (dr.Read())
{
sMSMember.SMSMemberId = sMSMemberId;
sMSMember.ParentMemberId = (dr[1] == DBNull.Value) ? 0 : int.Parse(dr[1].ToString());
sMSMember.MemberName = (dr[2] == DBNull.Value) ? "" : dr[2].ToString();
sMSMember.MobileNo = (dr[3] == DBNull.Value) ? "" : dr[3].ToString();
sMSMember.Address = (dr[4] == DBNull.Value) ? "" : dr[4].ToString();
sMSMember.MemberType = (dr[5] == DBNull.Value) ? 0 : int.Parse(dr[5].ToString());
sMSMember.IsActive = (dr[6] == DBNull.Value) ? false : Convert.ToBoolean(dr[6]);
sMSMember.StartDate = (dr[7] == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr[7]);
sMSMember.EndDate = (dr[8] == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr[8]);
sMSMember.Remarks = (dr[9] == DBNull.Value) ? "" : dr[9].ToString();
sMSMember.IsNECCMember = (dr[10] == DBNull.Value) ? false : Convert.ToBoolean(dr[10]);
sMSMember.DistrictId = (dr[11] == DBNull.Value) ? 0 : Convert.ToInt32(dr[11]);
}
}
return(sMSMember);
}
}
protected void PopulateSMSMember()
{
BusinessLayer.Common.SMSMemberMaster objSMSMember = new BusinessLayer.Common.SMSMemberMaster();
Entity.Common.SMSMember sMSMember = new Entity.Common.SMSMember();
sMSMember = objSMSMember.GetSMSMemberById(SMSMemberId);
if (sMSMember != null)
{
SMSMemberId = sMSMember.SMSMemberId;
ddlMember.SelectedValue = sMSMember.ParentMemberId.ToString();
txtMemberName.Text = sMSMember.MemberName.ToString();
txtMobileNo.Text = sMSMember.MobileNo.ToString();
txtAddress.Text = sMSMember.Address.ToString();
ddlRegType.Text = sMSMember.MemberType.ToString();
chkIsActive.Checked = Convert.ToBoolean(sMSMember.IsActive);
txtStartDate.Text = sMSMember.StartDate.ToString("dd/MM/yyyy");
txtEndDate.Text = sMSMember.EndDate.ToString("dd/MM/yyyy");
txtRemarks.Text = sMSMember.Remarks.ToString();
chkIsNECCMember.Checked = Convert.ToBoolean(sMSMember.IsNECCMember);
ddlDistrict.SelectedValue = sMSMember.DistrictId.ToString();
//ddlMember.Enabled = false;
txtMemberName.Enabled = false;
btnSave.Text = "Update";
}
}
protected void PopulateSMSMember()
{
BusinessLayer.Common.SMSMemberMaster objSMSMember = new BusinessLayer.Common.SMSMemberMaster();
Entity.Common.SMSMember sMSMember = new Entity.Common.SMSMember();
sMSMember = objSMSMember.GetSMSMemberById(SMSMemberId);
if (sMSMember != null)
{
SMSMemberId = sMSMember.SMSMemberId;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DateTime StartDate = Convert.ToDateTime(txtStartDate.Text.Split('/')[2] + "-" + txtStartDate.Text.Split('/')[1] + "-" + txtStartDate.Text.Split('/')[0]);
DateTime EndDate = Convert.ToDateTime(txtEndDate.Text.Split('/')[2] + "-" + txtEndDate.Text.Split('/')[1] + "-" + txtEndDate.Text.Split('/')[0]);
BusinessLayer.Common.SMSMemberMaster objSMSMember = new BusinessLayer.Common.SMSMemberMaster();
Entity.Common.SMSMember sMSMember = new Entity.Common.SMSMember();
sMSMember.SMSMemberId = SMSMemberId;
sMSMember.ParentMemberId = Convert.ToInt32(ddlMember.SelectedValue);
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.IsNECCMember = chkIsNECCMember.Checked;
sMSMember.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue);
sMSMember.CreatedBy = Convert.ToInt32(Session["UserId"]);
int RowsUpdated = objSMSMember.Save(sMSMember, StartDate, EndDate, txtRemarks.Text.Trim());
if (RowsUpdated > 0)
{
LoadSMSMember();
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.SMSMember smsmember, DateTime StartDate, DateTime EndDate, string txtRemarks)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pSMSMemberId", SqlDbType.Int, ParameterDirection.InputOutput, smsmember.SMSMemberId);
oDm.Add("@pParentMemberId", SqlDbType.Int, smsmember.ParentMemberId);
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("@pMemberType", SqlDbType.Int, smsmember.MemberType);
oDm.Add("@pIsActive", SqlDbType.Bit, smsmember.IsActive);
oDm.Add("@pIsNECCMember", SqlDbType.Bit, smsmember.IsNECCMember);
oDm.Add("@pDistrictId", SqlDbType.Int, smsmember.DistrictId);
oDm.Add("@pStartDate", SqlDbType.DateTime, StartDate);
oDm.Add("@pEndDate", SqlDbType.DateTime, EndDate);
oDm.Add("@pRemarks", SqlDbType.VarChar, 500, txtRemarks);
oDm.Add("@pCreatedBy", SqlDbType.Int, smsmember.CreatedBy);
oDm.CommandType = CommandType.StoredProcedure;
return(oDm.ExecuteNonQuery("SMSMember_Save"));
}
}
public int Save(Entity.Common.SMSMember smsmember, DateTime StartDate, DateTime EndDate, string txtRemarks)
{
return(DataAccess.Common.SMSMemberMaster.Save(smsmember, StartDate, EndDate, txtRemarks));
}
