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 dgvMember_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int Id = Convert.ToInt32(dgvMember.DataKeys[e.RowIndex].Value);
BusinessLayer.SMS.Member ObjMember = new BusinessLayer.SMS.Member();
ObjMember.Delete(Id);
LoadMemberList();
}
protected void dgvMember_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Activate"))
{
int Id = Convert.ToInt32(e.CommandArgument.ToString());
BusinessLayer.SMS.Member ObjMember = new BusinessLayer.SMS.Member();
ObjMember.QuickUpdate(Id);
dgvMember.PageIndex = CurrentPageIndex;
LoadMemberList();
}
}
private DataTable getMobileNumbers(int type)
{
BusinessLayer.SMS.Member ObjMember = new BusinessLayer.SMS.Member();
DataView DV = new DataView(ObjMember.getMobileNumbers(type));
if (ChkIncludeGovtMembers.Checked == false)
{
DV.RowFilter = "RegistrationType <> 4";
}
return(DV.ToTable());
}
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";
}
}
protected void ChkPriority_CheckedChanged(object sender, EventArgs e)
{
GridViewRow row = ((GridViewRow)((CheckBox)sender).NamingContainer);
int MemberId = Convert.ToInt32(dgvMember.DataKeys[row.RowIndex].Value);
CheckBox ChkPriority = (CheckBox)dgvMember.Rows[row.RowIndex].FindControl("ChkPriority");
int Priority;
if (ChkPriority.Checked)
{
Priority = 1;
}
else
{
Priority = 0;
}
BusinessLayer.SMS.Member objMember = new BusinessLayer.SMS.Member();
objMember.ChangePriority(MemberId, Priority);
}
protected void LoadMemberList()
{
BusinessLayer.SMS.Member ObjMember = new BusinessLayer.SMS.Member();
string MemberName = txtSearchName.Text.Trim();
string MobNo = txtSearchMob.Text.Trim();
int RegistrationType = Convert.ToInt32(ddlRegTypeSearch.SelectedValue.Trim());
string ExpirationDate = txtExpirationDate.Text.Trim();
if (ExpirationDate.Length != 0)
{
string[] Arr = ExpirationDate.Split('/');
ExpirationDate = Arr[1].Trim() + "/" + Arr[0].Trim() + "/" + Arr[2].Trim() + " 00:00:00";
}
int SearchType = Convert.ToInt32(ddlExpiration.SelectedValue.Trim());
DataTable dtMember = ObjMember.GetAll(MemberName, MobNo, RegistrationType, ExpirationDate, SearchType);
if (dtMember != null)
{
dgvMember.DataSource = dtMember;
dgvMember.DataBind();
}
}
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();
}
}
protected void btnDownload_Click(object sender, EventArgs e)
{
BusinessLayer.SMS.Member ObjMember = new BusinessLayer.SMS.Member();
string MemberName = txtSearchName.Text.Trim();
string MobNo = txtSearchMob.Text.Trim();
int RegistrationType = Convert.ToInt32(ddlRegTypeSearch.SelectedValue.Trim());
string ExpirationDate = txtExpirationDate.Text.Trim();
if (ExpirationDate.Length != 0)
{
string[] Arr = ExpirationDate.Split('/');
ExpirationDate = Arr[1].Trim() + "/" + Arr[0].Trim() + "/" + Arr[2].Trim() + " 00:00:00";
}
int SearchType = Convert.ToInt32(ddlExpiration.SelectedValue.Trim());
DataTable dt = ObjMember.GetAll(MemberName, MobNo, RegistrationType, ExpirationDate, SearchType);
//string path = Server.MapPath(@"Report\MemberList.xls");
//FileInfo fn = new FileInfo(path);
//if (fn.Exists)
//{
// fn.Delete();
//}
//FileStream stream = new FileStream(path, FileMode.Create);
//BusinessLayer.ExcelWriter writer = new BusinessLayer.ExcelWriter(stream);
//writer.BeginWrite();
//writer.WriteCell(0, 0, "Sl");
//writer.WriteCell(0, 1, "Member Name");
//writer.WriteCell(0, 2, "Location");
//writer.WriteCell(0, 3, "Start Date");
//writer.WriteCell(0, 4, "End Date");
//writer.WriteCell(0, 5, "Mobile No");
//writer.WriteCell(0, 6, "Registration Type");
//writer.WriteCell(0, 7, "Registration No");
//writer.WriteCell(0, 8, "Voucher");
//writer.WriteCell(0, 9, "Expired");
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// writer.WriteCell(i + 1, 0, i + 1);
// writer.WriteCell(i + 1, 1, dt.Rows[i]["MemberName"].ToString());
// writer.WriteCell(i + 1, 2, dt.Rows[i]["Location"].ToString());
// writer.WriteCell(i + 1, 3, Convert.ToDateTime(dt.Rows[i]["StartDate"].ToString()).ToString("dd/MM/yyyy"));
// writer.WriteCell(i + 1, 4, Convert.ToDateTime(dt.Rows[i]["EndDate"].ToString()).ToString("dd/MM/yyyy"));
// writer.WriteCell(i + 1, 5, Convert.ToDouble(dt.Rows[i]["MobileNo"].ToString()));
// writer.WriteCell(i + 1, 6, dt.Rows[i]["RegistrationType"].ToString());
// writer.WriteCell(i + 1, 7, dt.Rows[i]["RegistrationNo"].ToString());
// writer.WriteCell(i + 1, 8, dt.Rows[i]["VoucherDetails"].ToString());
// writer.WriteCell(i + 1, 9, dt.Rows[i]["IsExpired"].ToString());
//}
//writer.EndWrite();
//stream.Close();
//Response.ContentType = "application/vnd.ms-excel";
//Response.AppendHeader("Content-Disposition", "attachment; filename=MemberList_" + DateTime.Now.ToString("dd_MM_yyyy") + ".xls");
//Response.TransmitFile(path);
//Response.End();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "MemberList"));
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
Table table = new Table();
TableRow row;
TableCell cell;
row = new TableRow();
cell = new TableCell();
cell.Text = "Sl";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "Member Name";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "Location";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "Start Date";
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "End Date";
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "Mobile No";
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "Registration Type";
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "Registration No";
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "Voucher";
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "Expired";
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
table.Rows.Add(row);
for (int i = 0; i < dt.Rows.Count; i++)
{
row = new TableRow();
cell = new TableCell();
cell.Text = (i + 1).ToString();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = dt.Rows[i]["MemberName"].ToString();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = dt.Rows[i]["Location"].ToString();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = Convert.ToDateTime(dt.Rows[i]["StartDate"].ToString()).ToString("dd/MM/yyyy");
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = Convert.ToDateTime(dt.Rows[i]["EndDate"].ToString()).ToString("dd/MM/yyyy");
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = dt.Rows[i]["MobileNo"].ToString();
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = dt.Rows[i]["RegistrationType"].ToString();
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = dt.Rows[i]["RegistrationNo"].ToString();
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = dt.Rows[i]["VoucherDetails"].ToString();
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = dt.Rows[i]["IsExpired"].ToString();
cell.HorizontalAlign = HorizontalAlign.Center;
row.Cells.Add(cell);
table.Rows.Add(row);
}
table.GridLines = GridLines.Both;
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
table.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
