private void LoadSMSMemberList()
{
BusinessLayer.Common.SMSMemberMaster objSMSMember = new BusinessLayer.Common.SMSMemberMaster();
DataTable dt = objSMSMember.GetAllMember("", "", 0, 0, 0);
if (dt != null && dt.Rows.Count > 0)
{
dt.AsEnumerable().ToList().ForEach(r => r["MemberName"] = r["MemberName"].ToString() + " [" + r["MemberCode"].ToString() + "] [" + r["MobileNo"].ToString() + "]");
}
DataView dv = new DataView(dt);
string DataViewFilter = "IsNull(IsActive,0) = 1 And MemberType = 'PAID'";
if (txtMobileNo.Text.Trim().Length > 0)
{
DataViewFilter = DataViewFilter + " And MobileNo = '" + txtMobileNo.Text.Trim() + "'";
}
if (Session["UserType"].ToString().Equals("Member"))
{
DataViewFilter += " AND ParentMemberId = " + Session["UserId"].ToString();
}
dv.RowFilter = DataViewFilter;
ddlSMSMember.DataSource = dv;
ddlSMSMember.DataBind();
ddlSMSMember.Items.Insert(0, new ListItem("--Select Member--", "0"));
}
private DataTable getAllDeviceIDForNotification()
{
BusinessLayer.Common.SMSMemberMaster objMember = new BusinessLayer.Common.SMSMemberMaster();
DataView DV = new DataView(objMember.GetAllDeviceIdForNotification());
return(DV.ToTable());
}
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 LoadSMSMemberLogDetails()
{
string MemberName = txtSearchMemberName.Text.Trim();
string MobileNo = txtSearchMobileNo.Text.Trim();
string FromDate1 = (txtFromDate.Text.ToString());
string ToDate1 = (txtToDate.Text.ToString());
DateTime FromDate, ToDate;
if (FromDate1 != "" && ToDate1 != "")
{
FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]);
ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]);
}
else
{
FromDate = DateTime.MinValue; ToDate = DateTime.MinValue;
}
BusinessLayer.Common.SMSMemberMaster objSMSMember = new BusinessLayer.Common.SMSMemberMaster();
DataTable dt = objSMSMember.GetAllMemberLogDetails(MemberName, MobileNo, FromDate, ToDate);
if (dt.Rows.Count > 0)
{
dgvSMSMemberLogDetails.DataSource = dt;
dgvSMSMemberLogDetails.DataBind();
}
}
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 dgvSMSMember_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
SMSMemberId = Convert.ToInt32(dgvSMSMember.DataKeys[e.RowIndex].Value);
BusinessLayer.Common.SMSMemberMaster objSMSMember = new BusinessLayer.Common.SMSMemberMaster();
objSMSMember.Delete(SMSMemberId);
Message.IsSuccess = true;
Message.Text = "Data Deleted Successfully.";
Message.Show = true;
LoadSMSMember();
}
protected void btnSentNotification_Click(object sender, EventArgs e)
{
BusinessLayer.Common.SMSMemberMaster objMember = new BusinessLayer.Common.SMSMemberMaster();
DataTable dtMembers = objMember.GetAllDeviceIdForNotification();
foreach (DataRow member in dtMembers.Rows)
{
if (member["DeviceId"] != null)
{
string ImageUrl = "http://api.wbpoultryfederation.org/Images/Poultry_LargeIcon.jpg";
var request = WebRequest.Create("https://onesignal.com/api/v1/notifications") as HttpWebRequest;
request.KeepAlive = true;
request.Method = "POST";
request.ContentType = "application/json; charset=utf-8";
request.Headers.Add("authorization", "OGYtYjE2NS00NDE4LThODdjNGUxlMTUtZmQ2ZjJkODg0ZGJl");
byte[] byteArray = Encoding.UTF8.GetBytes("{"
+ "\"app_id\": \"a4143c17-1b1b-42f3-bb2d-9a25295de246\","
+ "\"large_icon\" : \" " + ImageUrl + " \", "
+ "\"data\": {\"NotificationType\": \"Loading\"},"
+ "\"contents\": {\"en\": \"WBPF - Bird rate published for today.Please Login to APP and Check!!\"},"
+ "\"include_player_ids\": [\"" + member["DeviceId"].ToString() + "\"]}");
string responseContent = null;
try
{
using (var writer = request.GetRequestStream())
{
writer.Write(byteArray, 0, byteArray.Length);
}
using (var response = request.GetResponse() as HttpWebResponse)
{
using (var reader = new StreamReader(response.GetResponseStream()))
{
responseContent = reader.ReadToEnd();
}
}
ShowMsg("Notification Send Successfully");
}
catch (WebException ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
System.Diagnostics.Debug.WriteLine(new StreamReader(ex.Response.GetResponseStream()).ReadToEnd());
}
}
}
}
protected void LoadSMSMember()
{
string MemberName = txtSearchMemberName.Text.Trim();
string MobileNo = txtSearchMobileNo.Text.Trim();
int MemberType = Convert.ToInt32(ddlSearchRegType.SelectedValue);
int DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue);
BusinessLayer.Common.SMSMemberMaster objSMSMember = new BusinessLayer.Common.SMSMemberMaster();
DataTable dt = objSMSMember.GetAllMember(MemberName, MobileNo, MemberType, DistrictId, 0);
if (dt != null)
{
dgvSMSMember.DataSource = dt;
dgvSMSMember.DataBind();
}
}
protected void LoadSMSMemberList()
{
string MemberName = txtMemberName.Text.Trim();
string MobileNo = txtMobile.Text.Trim();
int DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue);
BusinessLayer.Common.SMSMemberMaster objSMSMember = new BusinessLayer.Common.SMSMemberMaster();
DataTable dt = objSMSMember.GetAllMember(MemberName, MobileNo, 0, DistrictId, 0);
DataView dv = new DataView(dt);
dv.RowFilter = "IsNull(IsActive,0) = 1 And MemberType = 'PAID'";
{
dgvMemberMaster.DataSource = dv.ToTable();
dgvMemberMaster.DataBind();
}
}
private DataTable getMobileNumbers(int type)
{
BusinessLayer.Common.SMSMemberMaster objMember = new BusinessLayer.Common.SMSMemberMaster();
DataView DV = new DataView(objMember.GetMobileNumbersForSMS());
//if (ChkIncludeGovtMembers.Checked == false)
// DV.RowFilter = "RegistrationType <> 4";
return(DV.ToTable());
//BusinessLayer.Common.MemberMaster ObjMember = new BusinessLayer.Common.MemberMaster();
//Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
//DataView DV = new DataView(ObjMember.MemberMaster_GetAll_ForSMS(int.Parse(Session["FinYrID"].ToString()), chkIsGovtMember.Checked, (ddlMemberSMSCategory.SelectedIndex == 0) ? 0 : int.Parse(ddlMemberSMSCategory.SelectedValue)));
////if (ChkIncludeGovtMembers.Checked == false)
//// DV.RowFilter = "RegistrationType <> 4";
//return DV.ToTable();
}
protected void LoadSMSMember()
{
string MemberName = txtSearchMemberName.Text.Trim();
string MobileNo = txtSearchMobileNo.Text.Trim();
int MemberType = Convert.ToInt32(ddlSearchRegType.SelectedValue);
//int DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue);
int DistrictId = Convert.ToInt32(ddlSearchDistrict.SelectedValue); // Change on 25.07.19 _ Sayantani (Ref. Search by district was not working)
int MemberCategoryId = Convert.ToInt32(ddlNECCOrNot.SelectedValue);
BusinessLayer.Common.SMSMemberMaster objSMSMember = new BusinessLayer.Common.SMSMemberMaster();
DataTable dt = objSMSMember.GetAllMember(MemberName, MobileNo, MemberType, DistrictId, MemberCategoryId);
if (dt != null)
{
dgvSMSMember.DataSource = dt;
dgvSMSMember.DataBind();
}
}
private void LoadSMSMemberList()
{
BusinessLayer.Common.SMSMemberMaster objSMSMember = new BusinessLayer.Common.SMSMemberMaster();
DataTable dt = objSMSMember.GetAllMember("", "", 0, 0, 0);
DataView dv = new DataView(dt);
string DataViewFilter = "IsNull(IsActive,0) = 1 And MemberType = 'PAID'";
if (Session["UserType"].ToString().Equals("Member"))
{
DataViewFilter += " AND ParentMemberId = " + Session["UserId"].ToString();
}
dv.RowFilter = DataViewFilter;
ddlSMSMember.DataSource = dv;
ddlSMSMember.DataBind();
ddlSMSMember.Items.Insert(0, new ListItem("--Any Member--", "0"));
}
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;
}
protected void LoadSMSMember()
{
string MemberName = txtSearchMemberName.Text.Trim();
string MobileNo = txtSearchMobileNo.Text.Trim();
int MemberType = Convert.ToInt32(ddlSearchRegType.SelectedValue);
//int DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue);
int DistrictId = 0; // Change on 25.07.19 _ Sayantani (Ref. Search by district was not working)
int MemberCategoryId = 2;
DateTime FromDate;
DateTime ToDate;
if (txtFromDate.Text == "")
{
FromDate = DateTime.MinValue;
}
else
{
FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]);
}
if (txtToDate.Text == "")
{
ToDate = DateTime.MinValue;
}
else
{
ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]);
}
BusinessLayer.Common.SMSMemberMaster objSMSMember = new BusinessLayer.Common.SMSMemberMaster();
DataTable dt = objSMSMember.GetAllMemberForExpireDetails(MemberName, MobileNo, MemberType, DistrictId, MemberCategoryId, FromDate, ToDate);
if (dt != null)
{
dgvSMSMember.DataSource = dt;
dgvSMSMember.DataBind();
}
}
