public static bool SendMsgForAlignDate(string Mobile, string msg) { try { WebClient objWebClient; string sBaseURL; Stream objStreamData; StreamReader objReader; string sResult; objWebClient = new WebClient(); DueAlignRepDAL obj = new DueAlignRepDAL(); var Comp = obj.SelectUserPref(); string UserName = Convert.ToString(DataBinder.Eval(Comp[0], "UserName")); string Password = Convert.ToString(DataBinder.Eval(Comp[0], "Password")); string SenderID = Convert.ToString(DataBinder.Eval(Comp[0], "SenderID")); string ProfileID = Convert.ToString(DataBinder.Eval(Comp[0], "ProfileID")); string AuthType = Convert.ToString(DataBinder.Eval(Comp[0], "AuthType")); string AuthKey = Convert.ToString(DataBinder.Eval(Comp[0], "AuthKey")); sBaseURL = "http://globesms.in/sendhttp.php?user="******"&password="******"&authkey=" + AuthKey + "&type=" + AuthType + "&mobiles=91" + Mobile + "&message=" + HttpUtility.UrlEncode(msg) + "&sender=" + SenderID + "&route=1"; objStreamData = objWebClient.OpenRead(sBaseURL); objReader = new StreamReader(objStreamData); sResult = objReader.ReadToEnd(); objStreamData.Close(); objReader.Close(); return(true); } catch (Exception ex) { return(false); } }
public bool SendSMS(string Mobile, string msg) { if (Mobile != String.Empty && msg != String.Empty) { try { WebClient objWebClient; string sBaseURL; Stream objStreamData; StreamReader objReader; string sResult; objWebClient = new WebClient(); DueAlignRepDAL obj = new DueAlignRepDAL(); var Comp = obj.SelectUserPref(); string UserName = Convert.ToString(DataBinder.Eval(Comp[0], "UserName")); string Password = Convert.ToString(DataBinder.Eval(Comp[0], "Password")); string SenderID = Convert.ToString(DataBinder.Eval(Comp[0], "SenderID")); string ProfileID = Convert.ToString(DataBinder.Eval(Comp[0], "ProfileID")); string AuthType = Convert.ToString(DataBinder.Eval(Comp[0], "AuthType")); string AuthKey = Convert.ToString(DataBinder.Eval(Comp[0], "AuthKey")); //string UserName = "******"; //string Password = "******";//This may vary api to api. like ite may be password, secrate key, hash etc //string SenderID = "Cogxim"; sBaseURL = "http://globesms.in/sendhttp.php?user="******"&password="******"&authkey=" + AuthKey + "&type=" + AuthType + "&mobiles=91" + Mobile + "&message=" + HttpUtility.UrlEncode(msg) + "&sender=" + SenderID + "&route=1"; objStreamData = objWebClient.OpenRead(sBaseURL); objReader = new StreamReader(objStreamData); sResult = objReader.ReadToEnd(); objStreamData.Close(); objReader.Close(); return(true); } catch (Exception ex) { return(false); } } else { return(false); } }
protected void lnkSendSMS_Click(object sender, EventArgs e) { DueAlignRepDAL obj = new DueAlignRepDAL(); Int64 value = 0; string Msg = ""; DateTime?alignDate = null; DateTime?PrevalignDate = null; string strMsg = ""; Int64 update = 0; for (int i = 0; i <= grdMain.Rows.Count - 1; i++) { CheckBox chk = (CheckBox)grdMain.Rows[i].FindControl("chkSave4SMS"); if (chk.Checked == true) { Label lblDt = (Label)grdMain.Rows[i].FindControl("lblAlignDt"); Label lblPrevDt = (Label)grdMain.Rows[i].FindControl("lblPrevAlignDt"); Label lorryNo = (Label)grdMain.Rows[i].FindControl("lblLorry"); Label lblPhone = (Label)grdMain.Rows[i].FindControl("lblPhone"); if (lblDt.Text != "") { alignDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(lblDt.Text.Trim().ToString())); } if (lblPrevDt.Text != "") { PrevalignDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(lblPrevDt.Text.Trim().ToString())); } if (lblPrevDt.Text == "") { Msg = "Dear Customer, Tyre alignment of your " + lorryNo.Text + " is due on " + lblDt.Text + ""; } else { Msg = "Dear Customer, Tyre alignment of your " + lorryNo.Text + " is due on " + lblDt.Text + ". Previously done on " + lblPrevDt.Text + ""; } value = obj.Insert(Msg, alignDate, PrevalignDate, lorryNo.Text.Trim()); string LorryNo = lorryNo.Text.Trim(); string PhoneNo = lblPhone.Text.Trim(); if (PhoneNo != "") { if (SendMsgForAlignDate(PhoneNo, Msg)) { update = obj.Update(alignDate, LorryNo); } if (update > 0) { strMsg = "Message sent successfully."; ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true); } } } } //To select Data from Table //var AlignSMS = obj.SelectData(); //DataTable dttemp1 = ApplicationFunction.CreateTable("tbl", // "SrNo", "String", // "Msg", "String", // "AlignDate", "String", // "LorryNo", "String" // ); //for (int j = 0; j < AlignSMS.Count; j++) //{ // DataRow dr = dttemp1.NewRow(); // dr["SrNo"] = Convert.ToString(j + 1); // dr["Msg"] = Convert.ToString(DataBinder.Eval(AlignSMS[i], "MSG")); // dr["AlignDate"] = Convert.ToString(Convert.ToDateTime(DataBinder.Eval(AlignSMS[i], "AlignDate")).ToString("dd-MM-yyyy")); // dr["LorryNo"] = Convert.ToString(DataBinder.Eval(AlignSMS[i], "LorryNo")); // dttemp1.Rows.Add(dr); // string message=Convert.ToString(DataBinder.Eval(AlignSMS[i], "MSG")); // if (SendMsgForAlignDate("8696666358", message)) // { // Int64 update = obj.Update(Convert.ToDateTime(dttemp1.Rows[j]["AlignDate"]), Convert.ToString(dttemp1.Rows[j]["LorryNo"])); // } //} }
private void BindGrid() { try { DueAlignRepDAL obj = new DueAlignRepDAL(); Int64 LorryIdno = (Convert.ToString(drpLorryNo.SelectedValue) == "" ? 0 : Convert.ToInt64(drpLorryNo.SelectedValue)); var DsGrdetail = obj.SelectForSearch(Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), LorryIdno); if ((DsGrdetail != null) && (DsGrdetail.Count > 0)) { grdMain.DataSource = DsGrdetail; grdMain.DataBind(); DataTable dttemp1 = ApplicationFunction.CreateTable("tbl", "SrNo", "String", "Date", "String", "LorryNo", "String", "ItemName", "String", "SerialNo", "String", "PrevAlignDate", "String", "AlignDate", "String", "PhoneNo", "String" ); for (int i = 0; i < DsGrdetail.Count; i++) { DataRow dr = dttemp1.NewRow(); dr["SrNo"] = Convert.ToString(i + 1); dr["Date"] = Convert.ToString(Convert.ToDateTime(DataBinder.Eval(DsGrdetail[i], "Date")).ToString("dd-MM-yyyy")); dr["LorryNo"] = Convert.ToString(DataBinder.Eval(DsGrdetail[i], "LorryNo")); dr["ItemName"] = Convert.ToString(DataBinder.Eval(DsGrdetail[i], "ItemName")); dr["SerialNo"] = Convert.ToString(DataBinder.Eval(DsGrdetail[i], "SerialNo")); dr["PrevAlignDate"] = Convert.ToString(Convert.ToDateTime(DataBinder.Eval(DsGrdetail[i], "PrevAlignDate")).ToString("dd-MM-yyyy")); dr["AlignDate"] = Convert.ToString(Convert.ToDateTime(DataBinder.Eval(DsGrdetail[i], "AlignDate")).ToString("dd-MM-yyyy")); dr["PhoneNo"] = Convert.ToString(DataBinder.Eval(DsGrdetail[i], "PhoneNo")); dttemp1.Rows.Add(dr); } ViewState["dtCSV"] = dttemp1; int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1; int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1; lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + DsGrdetail.Count.ToString(); lblcontant.Visible = true; divpaging.Visible = true; imgBtnExcel.Visible = true; lblTotalRecord.Text = "T. Record(s) :" + Convert.ToString(DsGrdetail.Count); } else { grdMain.DataSource = null; grdMain.DataBind(); lblTotalRecord.Text = "T. Record (s): 0 "; imgBtnExcel.Visible = false; } } catch (Exception Ex) { throw (Ex); } }