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