protected void LoadLedger()
{
clsGeneralFunctions gf = new clsGeneralFunctions();
string strValues = "";
char chr = Convert.ToChar(130);
ListItem li = new ListItem("Select", "0");
strValues = Session["CompanyID"].ToString() + chr.ToString();
strValues += Session["FinYrID"].ToString() + chr.ToString();
strValues += Session["BranchID"].ToString() + chr.ToString();
strValues += Session["DataFlow"].ToString();
gf.BindAjaxDropDownColumnsBySP(ddlLedger, "spSelect_MstGeneralLedgerFull", strValues);
ddlLedger.Items.Insert(0, li);
}
protected void LoadCashBankLedger()
{
clsGeneralFunctions gf = new clsGeneralFunctions();
char chr = Convert.ToChar(130);
ListItem li = new ListItem("Select", "0");
string strParams = "";
strParams = Session["CompanyId"].ToString() + chr.ToString();
strParams += Session["FinYrID"].ToString() + chr.ToString();
strParams += Session["BranchId"].ToString() + chr.ToString();
strParams += Session["DataFlow"].ToString();
DataTable dt = gf.GetDropDownColumnsBySP("spSelect_MstGeneralLedgerBNKandCASH", strParams);
if (dt != null)
{
ddlCashBankLedger.DataSource = dt;
ddlCashBankLedger.DataBind();
}
ddlCashBankLedger.Items.Insert(0, li);
}
protected void Page_Load(object sender, EventArgs e)
{
clsGeneralFunctions gf = new clsGeneralFunctions();
char chr = Convert.ToChar(130);
string strValues = "";
if (!IsPostBack)
{
if (Request.QueryString["id"] != null && Request.QueryString["id"].Trim().Length > 0)
{
BusinessLayer.Accounts.TrnDebitNoteHeader ObjTrnDebitNoteHeader = new TrnDebitNoteHeader();
int intID = Convert.ToInt32(Request.QueryString["id"].Trim());
strValues = Session["CompanyID"].ToString();
strValues += chr.ToString() + intID.ToString();
DataTable DT = ObjTrnDebitNoteHeader.GetAll(intID);
dgvReceipt.DataSource = DT;
dgvReceipt.DataBind();
string CommanyId = Session["CompanyId"].ToString();
//LoadDetails(ds1.Tables[0]);
//LoadFooterRow(ds.Tables[0]);
LoadFooterRow(DT);
LoadHeader(DT);
LoadSignature();
if (CommanyId == "2")
{
img.ImageUrl = "../Images/ReportHeader.png";
}
else if (CommanyId == "4")
{
img.ImageUrl = "../Images/DiplomaHeader.jpg";
}
else if (CommanyId == "1")
{
img.ImageUrl = "../Images/Management.png";
}
}
}
}
protected void btnSentSMS_Click(object sender, EventArgs e)
{
string strValues = Session["FinYrID"].ToString();
clsGeneralFunctions genObj = new clsGeneralFunctions();
DataSet ds = genObj.ExecuteSelectSP("spSelect_MstFinancialYearForSelection", strValues);
string startdate = "";
string enddate = "";
if (ds.Tables[0].Rows.Count > 0)
{
startdate = ds.Tables[0].Rows[0]["StartYear"].ToString();
startdate += "-04-01";
enddate = ds.Tables[0].Rows[0]["EndYear"].ToString();
enddate += "-03-31";
}
if (!(System.DateTime.Now >= Convert.ToDateTime(startdate) && System.DateTime.Now <= Convert.ToDateTime(enddate)))
{
Message.IsSuccess = false;
Message.Text = "Please select current financial year to send SMS";
Message.Show = true;
return;
}
string mobiles = "";
string message = FitMessage(txtMessageBody.Text.Trim());
BusinessLayer.Common.SMSTrigger objTrigger = new BusinessLayer.Common.SMSTrigger();
string ROUTE_1 = System.Configuration.ConfigurationSettings.AppSettings["ROUTE_1"];
string ROUTE_2 = System.Configuration.ConfigurationSettings.AppSettings["ROUTE_2"];
API_INDEX = ROUTE_1;
string strUrl;
string dataString;
int MobNoCount = 0;
try
{
if (txtMobiles.Text.Trim().Length > 0)
{
string[] Arrmob = txtMobiles.Text.Trim().Split(',');
for (int i = 0; i < Arrmob.Length; i++)
{
if (Arrmob[i].Length == 10)
{
if (API_INDEX == "1")
{
mobiles += "91" + Arrmob[i].Trim() + ",";
}
else if (API_INDEX == "2" || API_INDEX == "3" || API_INDEX == "4")
{
mobiles += Arrmob[i].Trim() + ",";
}
}
else if (Arrmob[i].Length == 12)
{
if (API_INDEX == "1")
{
mobiles += Arrmob[i].Trim() + ",";
}
else if (API_INDEX == "2" || API_INDEX == "3" || API_INDEX == "4")
{
mobiles += Arrmob[i].Trim().Substring(2) + ",";
}
}
}
if (mobiles.Trim().Length > 0)
{
mobiles = mobiles.Trim().Substring(0, mobiles.Length - 1).Trim();
strUrl = GetHTTPAPI(mobiles, message);
WebRequest request1 = HttpWebRequest.Create(strUrl);
HttpWebResponse response1 = (HttpWebResponse)request1.GetResponse();
Stream s1 = (Stream)response1.GetResponseStream();
StreamReader readStream1 = new StreamReader(s1);
dataString = readStream1.ReadToEnd();
response1.Close();
s1.Close();
readStream1.Close();
}
}
else
{
DataSet Ds = new DataSet();
DataTable DTMobNos = getMobileNumbers();//Fetch mobile numbers from Member tables based on MemberType(pritam)
DataView Dv;
Dv = new DataView(DTMobNos);
Dv.RowFilter = "IsPriority = 0"; //Route 1
Ds.Tables.Add(Dv.ToTable("TBL_PRIORITY_0"));
Dv = new DataView(DTMobNos);
Dv.RowFilter = "IsPriority = 1"; //Route 2
Ds.Tables.Add(Dv.ToTable("TBL_PRIORITY_1"));
// foreach (DataTable DT in Ds.Tables)
// {
// if (DT.Rows.Count > 0)
// {
// if (DT.Rows[0]["IsPriority"].ToString().Equals("0"))
// API_INDEX = ROUTE_1;
// else if (DT.Rows[0]["IsPriority"].ToString().Equals("1"))
// API_INDEX = ROUTE_2;
// int counter = 0;
// mobiles = "";
// foreach (DataRow DR in DT.Rows)
// {
// if (API_INDEX == "1")
// mobiles += "91" + DR["MobileNo"].ToString() + ",";
// else if (API_INDEX == "2" || API_INDEX == "3" || API_INDEX == "4")
// mobiles += DR["MobileNo"].ToString() + ",";
// MobNoCount++;
// counter++;
// if (counter == smsPerTrans)
// {
// mobiles = mobiles.Trim().Substring(0, mobiles.Length - 1).Trim();
// strUrl = GetHTTPAPI(mobiles, message);
// WebRequest request = HttpWebRequest.Create(strUrl);
// HttpWebResponse response = (HttpWebResponse)request.GetResponse();
// Stream s = (Stream)response.GetResponseStream();
// StreamReader readStream = new StreamReader(s);
// dataString = readStream.ReadToEnd();
// response.Close();
// s.Close();
// readStream.Close();
// counter = 0;
// mobiles = "";
// }
// }
// if (mobiles.Trim().Length > 0)
// {
// mobiles = mobiles.Trim().Substring(0, mobiles.Length - 1).Trim();
// strUrl = GetHTTPAPI(mobiles, message);
// WebRequest request1 = HttpWebRequest.Create(strUrl);
// HttpWebResponse response1 = (HttpWebResponse)request1.GetResponse();
// Stream s1 = (Stream)response1.GetResponseStream();
// StreamReader readStream1 = new StreamReader(s1);
// dataString = readStream1.ReadToEnd();
// response1.Close();
// s1.Close();
// readStream1.Close();
// }
// }
// }
}
Message.IsSuccess = true;
Message.Text = "Message Send Successfully";
}
catch (Exception ex)
{
Message.IsSuccess = false;
Message.Text = ex.Message;
}
finally
{
if (txtMobiles.Text.Trim().Length == 0)
{
if (MobNoCount > 0)
{
objTrigger.Save(MobNoCount);
Hidden1.Value = "1";
btnSentSMS.Style.Add("display", "none");
}
}
Message.Show = true;
}
}
