public static Entity.SMS.Member GetAllById(int MemberId)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@pMemberId", SqlDbType.Int, ParameterDirection.Input, MemberId);
SqlDataReader dr = oDm.ExecuteReader("usp_Member_GetAllById");
Entity.SMS.Member EntityMember = new Entity.SMS.Member();
if (dr.HasRows)
{
while (dr.Read())
{
EntityMember.MemberId = MemberId;
EntityMember.MemberName = (dr[1] == DBNull.Value) ? "" : dr[1].ToString();
EntityMember.Location = (dr[2] == DBNull.Value) ? "" : dr[2].ToString();
EntityMember.StartDate = (dr[3] == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr[3].ToString());
EntityMember.EndDate = (dr[4] == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr[4].ToString());
EntityMember.MobileNo = (dr[5] == DBNull.Value) ? "" : dr[5].ToString();
EntityMember.RegistrationType = (dr[7] == DBNull.Value) ? 2 : int.Parse(dr[7].ToString());
EntityMember.RegistrationNo = (dr[8] == DBNull.Value) ? "" : dr[8].ToString();
EntityMember.VoucherDetails = (dr[9] == DBNull.Value) ? "" : dr[9].ToString();
}
}
return(EntityMember);
}
}
protected void LoadMemberDetailsByMobNo()
{
BusinessLayer.SMS.Member ObjMember = new BusinessLayer.SMS.Member();
Entity.SMS.Member EntityMember = new Entity.SMS.Member();
EntityMember = ObjMember.GetAllByMobNo(MobNo);
if (EntityMember != null)
{
MemberId = EntityMember.MemberId;
txtName.Text = EntityMember.MemberName;
txtLocation.Text = EntityMember.Location;
txtMobNo.Text = EntityMember.MobileNo;
txtStartDate.Text = EntityMember.StartDate.ToString("dd/MM/yyyy");
txtEndDate.Text = EntityMember.EndDate.ToString("dd/MM/yyyy");
ddlRegType.SelectedValue = EntityMember.RegistrationType.ToString();
txtRegNo.Text = EntityMember.RegistrationNo.ToString();
txtVoucherDetails.Text = EntityMember.VoucherDetails;
}
if (MemberId != 0)
{
btnSave.Text = "Update";
txtSearchMob.Text = MobNo;
txtSearchName.Text = "";
ddlRegTypeSearch.SelectedValue = "1";
txtExpirationDate.Text = "";
ddlExpiration.SelectedValue = "1";
LoadMemberList();
}
else
{
btnSave.Text = "Save";
ShowMsg(MobNo + " does not exists");
}
}
protected void LoadMemberDetails()
{
BusinessLayer.SMS.Member ObjMember = new BusinessLayer.SMS.Member();
Entity.SMS.Member EntityMember = new Entity.SMS.Member();
EntityMember = ObjMember.GetAllById(MemberId);
if (EntityMember != null)
{
txtName.Text = EntityMember.MemberName;
txtLocation.Text = EntityMember.Location;
txtMobNo.Text = EntityMember.MobileNo;
txtStartDate.Text = EntityMember.StartDate.ToString("dd/MM/yyyy");
txtEndDate.Text = EntityMember.EndDate.ToString("dd/MM/yyyy");
ddlRegType.SelectedValue = EntityMember.RegistrationType.ToString();
txtRegNo.Text = EntityMember.RegistrationNo.ToString();
txtVoucherDetails.Text = EntityMember.VoucherDetails;
btnSave.Text = "Update";
}
}
public static int Save(Entity.SMS.Member EntityMember)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pMemberId", SqlDbType.Int, ParameterDirection.InputOutput, EntityMember.MemberId);
oDm.Add("@pMemberName", SqlDbType.VarChar, 50, EntityMember.MemberName);
oDm.Add("@pLocation", SqlDbType.VarChar, 50, EntityMember.Location);
oDm.Add("@pStartDate", SqlDbType.DateTime, EntityMember.StartDate);
oDm.Add("@pEndDate", SqlDbType.DateTime, EntityMember.EndDate);
oDm.Add("@pMobileNo", SqlDbType.VarChar, 50, EntityMember.MobileNo);
oDm.Add("@pRegistrationType", SqlDbType.Int, EntityMember.RegistrationType);
oDm.Add("@pRegistrationNo", SqlDbType.VarChar, 50, EntityMember.RegistrationNo);
oDm.Add("@pVoucherDetails", SqlDbType.VarChar, 8000, EntityMember.VoucherDetails);
oDm.CommandType = CommandType.StoredProcedure;
int i = oDm.ExecuteNonQuery("usp_Member_Save");
EntityMember.MemberId = (int)oDm["@pMemberId"].Value;
return(i);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
BusinessLayer.SMS.Member ObjMember = new BusinessLayer.SMS.Member();
Entity.SMS.Member EntityMember = new Entity.SMS.Member();
EntityMember.MemberId = MemberId;
EntityMember.MemberName = txtName.Text.Trim();
EntityMember.Location = txtLocation.Text.Trim();
EntityMember.MobileNo = txtMobNo.Text.Trim();
EntityMember.RegistrationType = int.Parse(ddlRegType.SelectedValue.Trim());
EntityMember.RegistrationNo = (txtRegNo.Text.Trim().Length == 0) ? "" : txtRegNo.Text.Trim();
EntityMember.VoucherDetails = txtVoucherDetails.Text;
string[] SDate = txtStartDate.Text.Trim().Split('/');
EntityMember.StartDate = Convert.ToDateTime(SDate[1].Trim() + "/" + SDate[0].Trim() + "/" + SDate[2].Trim());
string[] EDate = txtEndDate.Text.Trim().Split('/');
EntityMember.EndDate = Convert.ToDateTime(EDate[1].Trim() + "/" + EDate[0].Trim() + "/" + EDate[2].Trim());
int RowsUpdated = ObjMember.Save(EntityMember);
if (RowsUpdated == -1)
{
ltrMsg.Text = "CAN NOT ADD. A SAME MOBILE NUMBER EXISTS";
}
else
{
ltrMsg.Text = "DATA SAVED SUCCESSFULLY";
if (MemberId == 0)
{
CurrentPageIndex = 0;
}
dgvMember.PageIndex = CurrentPageIndex;
LoadMemberList();
ClearControls();
}
}
public int Save(Entity.SMS.Member EntityMember)
{
return(DataAccess.SMS.Member.Save(EntityMember));
}
