PageRenderTime 43ms CodeModel.GetById 19ms RepoModel.GetById 1ms app.codeStats 0ms

/outbox.aspx.cs

https://bitbucket.org/xpertech/paycell
C# | 247 lines | 219 code | 5 blank | 23 comment | 25 complexity | d9e8283497d439f8a3c693ca6309162b MD5 | raw file
  1. using System;
  2. using System.Collections;
  3. using System.Configuration;
  4. using System.Data;
  5. using System.Linq;
  6. using System.Web;
  7. using System.Web.Security;
  8. using System.Web.UI;
  9. using System.Web.UI.HtmlControls;
  10. using System.Web.UI.WebControls;
  11. using System.Web.UI.WebControls.WebParts;
  12. using System.Xml.Linq;
  13. public partial class outbox : System.Web.UI.Page
  14. {
  15. static int userid;
  16. static int groupid;
  17. static int FlagDel = 0;
  18. static string sentto = "";
  19. static DataTable dtreplies;
  20. protected void Page_Load(object sender, EventArgs e)
  21. {
  22. if (!IsPostBack)
  23. {
  24. bindGrid();
  25. }
  26. }
  27. protected void ImgBtnDelete_Click(object sender, ImageClickEventArgs e)
  28. {
  29. GridViewRow row = (GridViewRow)(sender as Control).Parent.Parent;
  30. int index = row.RowIndex;
  31. Label lblmsgid = GridViewSentMessages.Rows[index].FindControl("LblMsgID") as Label;
  32. SqlHelper.ExecuteNonQuery(GlobalVariable.con, CommandType.Text, "delete from tbl_SentMessages where msgid='" + Convert.ToInt32(lblmsgid.Text) + "'");
  33. DataTable dt = SqlHelper.ExecuteDatatable(GlobalVariable.con, CommandType.Text, "select MsgId,MsgFrom,MsgTo,MsgText,MsgStatus,SentDateTime,ScheduleDateTime,smsDeliveryTime from tbl_SentMessages");
  34. GridViewSentMessages.DataSource = dt;
  35. GridViewSentMessages.DataBind();
  36. if (GridViewSentMessages.Rows.Count > 0)
  37. {
  38. BtnDeleteAll.Visible = true;
  39. }
  40. else
  41. {
  42. BtnDeleteAll.Visible = false;
  43. }
  44. }
  45. protected void BtnDeleteAll_Click(object sender, EventArgs e)
  46. {
  47. for (int i = 0; i <= GridViewSentMessages.Rows.Count - 1; i++)
  48. {
  49. CheckBox chkboxselect = GridViewSentMessages.Rows[i].FindControl("ChkBoxSelect") as CheckBox;
  50. Label lblmsgid = GridViewSentMessages.Rows[i].FindControl("LblMsgID") as Label;
  51. if (chkboxselect.Checked)
  52. {
  53. SqlHelper.ExecuteNonQuery(GlobalVariable.con, CommandType.Text, "delete from tbl_SentMessages where msgid='" + Convert.ToInt32(lblmsgid.Text) + "'");
  54. }
  55. }
  56. bindGrid();
  57. //DataTable dt = SqlHelper.ExecuteDatatable(GlobalVariable.con, CommandType.Text, "select MsgId,MsgFrom,MsgTo,MsgText,MsgStatus,SentDateTime,ScheduleDateTime,smsDeliveryTime from tbl_SentMessages");
  58. //GridViewSentMessages.DataSource = dt;
  59. //GridViewSentMessages.DataBind();
  60. //if (GridViewSentMessages.Rows.Count > 0)
  61. //{ BtnDeleteAll.Visible = true; }
  62. //else
  63. //{
  64. // BtnDeleteAll.Visible = false;
  65. //}
  66. }
  67. protected void LnkBtnViewSentMessages_Click(object sender, EventArgs e)
  68. {
  69. Panelsentmessages.Visible = true;
  70. bindGrid();
  71. }
  72. protected void GridViewSentMessages_PageIndexChanging(object sender, GridViewPageEventArgs e)
  73. {
  74. GridViewSentMessages.PageIndex = e.NewPageIndex;
  75. bindGrid();
  76. }
  77. protected void HeaderLevelCheckBox_CheckedChanged(object sender, EventArgs e)
  78. {
  79. }
  80. protected void GridViewSentMessages_Sorting(object sender, GridViewSortEventArgs e)
  81. {
  82. if (e.SortExpression == ViewState["SentDateTime"].ToString())
  83. {
  84. if (ViewState["Sort_Order"].ToString() == "ASC")
  85. RebindData(e.SortExpression, "DESC");
  86. else
  87. RebindData(e.SortExpression, "ASC");
  88. }
  89. else
  90. RebindData(e.SortExpression, "ASC");
  91. }
  92. private void RebindData(string sColimnName, string sSortOrder)
  93. {
  94. DataTable dt = (DataTable)Cache["dt"];
  95. dt.DefaultView.Sort = sColimnName + " " + sSortOrder;
  96. GridViewSentMessages.DataSource = dt;
  97. GridViewSentMessages.DataBind();
  98. ViewState["SentDateTime"] = sColimnName;
  99. ViewState["Sort_Order"] = sSortOrder;
  100. }
  101. //protected void LnkBtnSndAgn_Click(object sender, EventArgs e)
  102. //{
  103. // Session[GlobalVariable.Session.MsgText.ToString()] = LblMsgText.Text;
  104. // Session[GlobalVariable.Session.MsgTo.ToString()] = sentto;
  105. // Response.Redirect("sendsms.aspx");
  106. //}
  107. public void bindGrid()
  108. {
  109. DataTable dt = SqlHelper.ExecuteDatatable(GlobalVariable.con, CommandType.Text, "select MsgId,MsgFrom,MsgTo,MsgText,MsgStatus,SentDateTime,ScheduleDateTime,smsDeliveryTime from tbl_SentMessages where MsgStatus<>'scheduled'");
  110. GridViewSentMessages.DataSource = dt;
  111. GridViewSentMessages.DataBind();
  112. Cache["dt"] = dt;
  113. ViewState["SentDateTime"] = "SentDateTime";
  114. ViewState["Sort_Order"] = "ASC";
  115. GridViewSentMessages.Sort("SentDateTime", SortDirection.Descending);
  116. if (GridViewSentMessages.Rows.Count > 0)
  117. { BtnDeleteAll.Visible = true; }
  118. else
  119. {
  120. BtnDeleteAll.Visible = false;
  121. }
  122. DataTable dtsch = SqlHelper.ExecuteDatatable(GlobalVariable.con, CommandType.Text, "select MsgId,MsgFrom,MsgTo,MsgText,MsgStatus,SentDateTime,ScheduleDateTime,smsDeliveryTime from tbl_SentMessages where MsgStatus='scheduled'");
  123. GridView1.DataSource = dtsch;
  124. GridView1.DataBind();
  125. Cache["dtsch"] = dtsch;
  126. ViewState["SentDateTime1"] = "SentDateTime";
  127. ViewState["Sort_Order1"] = "ASC";
  128. GridView1.Sort("SentDateTime", SortDirection.Descending);
  129. //if (GridView1.Rows.Count > 0)
  130. //{
  131. // btnDeleteScheduled.Visible = true;
  132. //}
  133. //else
  134. //{
  135. // btnDeleteScheduled.Visible = false;
  136. //}
  137. }
  138. protected void btnDeleteScheduled_Click(object sender, EventArgs e)
  139. {
  140. int deletednumbers = 0;
  141. for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
  142. {
  143. CheckBox chkboxselect = GridView1.Rows[i].FindControl("ChkBoxSelectSch") as CheckBox;
  144. Label lblmsgid = GridView1.Rows[i].FindControl("LblMsgIDSch") as Label;
  145. if (chkboxselect.Checked)
  146. {
  147. SqlHelper.ExecuteNonQuery(GlobalVariable.con, CommandType.Text, "delete from tbl_SentMessages where msgid='" + Convert.ToInt32(lblmsgid.Text) + "'");
  148. deletednumbers++;
  149. }
  150. }
  151. bindGrid();
  152. string SelectGroup = "" + deletednumbers + " messages deleted from list.";
  153. Page.Controls.Add(new LiteralControl("<script language='javascript'> window.alert('" + SelectGroup + "')</script>"));
  154. }
  155. protected void btnOptOutSelected_Click(object sender, EventArgs e)
  156. {
  157. int countopt = 0;
  158. int noop = 0;
  159. int totaln = 0;
  160. for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
  161. {
  162. CheckBox chkboxselect = GridView1.Rows[i].FindControl("ChkBoxSelectSch") as CheckBox;
  163. Label lblmsgid = GridView1.Rows[i].FindControl("LblMsgIDSch") as Label;
  164. Label lblMsgTo = GridView1.Rows[i].FindControl("lblMsgTo") as Label;
  165. if (chkboxselect.Checked)
  166. {
  167. totaln++;
  168. object nmbr = SqlHelper.ExecuteScalar(GlobalVariable.con, CommandType.Text, "Select ContactId from tbl_groupcontacts where MobileNumber='" + lblMsgTo.Text + "'");
  169. if (nmbr != null)
  170. {
  171. SqlHelper.ExecuteNonQuery(GlobalVariable.con, CommandType.Text, "update tbl_groupcontacts set Unsubscribed='true' where MobileNumber = '" + lblMsgTo.Text + "'");
  172. countopt++;
  173. }
  174. else
  175. {
  176. noop++;
  177. }
  178. }
  179. }
  180. bindGrid();
  181. string SelectGroup = "";
  182. if (noop == 0)
  183. {
  184. SelectGroup = "Total " + totaln + " contacts selected. " + countopt + " numbers opted out from database.";
  185. }
  186. else
  187. {
  188. SelectGroup = "Total " + totaln + " contacts selected. " + countopt + " numbers opted out from database.. " + noop + " contacts does not exist in database.";
  189. }
  190. Page.Controls.Add(new LiteralControl("<script language='javascript'> window.alert('" + SelectGroup + "')</script>"));
  191. }
  192. protected void ddlShowRecords_SelectedIndexChanged(object sender, EventArgs e)
  193. {
  194. if (ddlShowRecords.SelectedIndex > 0)
  195. {
  196. GridView1.PageSize = Convert.ToInt32(ddlShowRecords.SelectedValue);
  197. bindGrid();
  198. }
  199. }
  200. protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
  201. {
  202. if (e.SortExpression == ViewState["SentDateTime1"].ToString())
  203. {
  204. if (ViewState["Sort_Order1"].ToString() == "ASC")
  205. RebindData(e.SortExpression, "DESC");
  206. else
  207. RebindData(e.SortExpression, "ASC");
  208. }
  209. else
  210. RebindData(e.SortExpression, "ASC");
  211. }
  212. protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
  213. {
  214. GridView1.PageIndex = e.NewPageIndex;
  215. bindGrid();
  216. }
  217. protected void btnCancel_Click(object sender, EventArgs e)
  218. {
  219. int CanceledMessages = 0;
  220. for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
  221. {
  222. CheckBox chkboxselect = GridView1.Rows[i].FindControl("ChkBoxSelectSch") as CheckBox;
  223. Label lblmsgid = GridView1.Rows[i].FindControl("LblMsgIDSch") as Label;
  224. if (chkboxselect.Checked)
  225. {
  226. SqlHelper.ExecuteNonQuery(GlobalVariable.con, CommandType.Text, "update tbl_SentMessages set MsgStatus='" + GlobalVariable.MsgStatus.Canceled.ToString() + "' where msgid='" + Convert.ToInt32(lblmsgid.Text) + "'");
  227. CanceledMessages++;
  228. }
  229. }
  230. bindGrid();
  231. string SelectGroup = "" + CanceledMessages + " messages are canceled.";
  232. Page.Controls.Add(new LiteralControl("<script language='javascript'> window.alert('" + SelectGroup + "')</script>"));
  233. }
  234. protected void ddlRecords_SelectedIndexChanged(object sender, EventArgs e)
  235. {
  236. if (ddlRecords.SelectedIndex > 0)
  237. {
  238. GridViewSentMessages.PageSize = Convert.ToInt32(ddlRecords.SelectedValue);
  239. bindGrid();
  240. }
  241. }
  242. }