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(); } }