protected void Page_Load(object sender, EventArgs e)
{
if (Session["Employ_Sno"] != null)
{
string sno = Session["Employ_Sno"].ToString();
cmd = new SqlCommand("update employe_details set loginflag=@log where sno=@sno");
cmd.Parameters.Add("@log", "0");
cmd.Parameters.Add("@sno", sno);
vdm.Update(cmd);
DateTime ServerDateCurrentdate = SalesDBManager.GetTime(vdm.conn);
cmd = new SqlCommand("Select max(sno) as transno from logininfo where UserId=@userid AND UserName=@UserName");
cmd.Parameters.Add("@userid", Session["Employ_Sno"]);
cmd.Parameters.Add("@UserName", Session["UserName"]);
DataTable dttime = vdm.SelectQuery(cmd).Tables[0];
if (dttime.Rows.Count > 0)
{
string transno = dttime.Rows[0]["transno"].ToString();
cmd = new SqlCommand("UPDATE logininfo set logouttime=@logouttime where sno=@sno");
cmd.Parameters.Add("@logouttime", ServerDateCurrentdate);
cmd.Parameters.Add("@sno", transno);
vdm.Update(cmd);
}
}
else
{
cmd = new SqlCommand("update employe_details set loginflag=@log");
cmd.Parameters.Add("@log", "0");
vdm.Update(cmd);
}
Session.Clear();
Session.RemoveAll();
Session.Abandon();
Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(-1);
Response.Cookies["Employ_Sno"].Expires = DateTime.Now.AddDays(-1);
Response.Redirect("Default.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
DateTime ServerDateCurrentdate = SalesDBManager.GetTime(vdm.conn);
//cmd = new SqlCommand("Select max(sno) as transno from logininfo where UserId=@userid");
//cmd.Parameters.Add("@userid", Session["Employ_Sno"]);
//cmd.Parameters.Add("@UserName", Session["UserName"]);
if (Session["Employ_Sno"] != "" || Session["Employ_Sno"] != null || Session["Employ_Sno"] != "undefined")
{
string sno = Session["Employ_Sno"].ToString();
cmd = new SqlCommand("update employee_erp set loginstatus=@log where sno=@sno");
cmd.Parameters.Add("@log", "0");
cmd.Parameters.Add("@sno", sno);
vdm.Update(cmd);
cmd = new SqlCommand("Select max(sno) as transno from logininfo where UserId=@userid");
cmd.Parameters.Add("@userid", sno);
DataTable dttime = vdm.SelectQuery(cmd).Tables[0];
if (dttime.Rows.Count > 0)
{
string transno = dttime.Rows[0]["transno"].ToString();
cmd = new SqlCommand("UPDATE logininfo set logouttime=@logouttime,status=@status where sno=@sno");
cmd.Parameters.Add("@logouttime", ServerDateCurrentdate);
cmd.Parameters.Add("@status", "0");
cmd.Parameters.Add("@sno", transno);
vdm.Update(cmd);
}
}
ExpireAllCookies();
Session.Clear();
Session.RemoveAll();
Session.Abandon();
//window.localStorage.clear();
//ClearCache();
//clearchachelocalall();
Response.Redirect("login.aspx");
}
protected void btn_finalizeclick(object sender, EventArgs e)
{
DateTime ServerDateCurrentdate = SalesDBManager.GetTime(vdm.conn);
DataTable dtdetails = (DataTable)Session["finalize"];
if (dtdetails.Rows.Count > 0)
{
DateTime fromdate = DateTime.Now;
string[] datestrig = dtp_FromDate.Text.Split(' ');
if (datestrig.Length > 1)
{
if (datestrig[0].Split('-').Length > 0)
{
string[] dates = datestrig[0].Split('-');
string[] times = datestrig[1].Split(':');
fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0);
}
}
string date = fromdate.ToString("dd/MM/yyyy");
string[] data = date.Split('/');
string month = data[1].ToString();
string year = data[2].ToString();
string mainbranch = Session["Branch_ID"].ToString();
foreach (DataRow dr in dtdetails.Rows)
{
string productid = dr["ProductId"].ToString();
string packingcharge = dr["RATE PER LTR"].ToString();
cmd = new SqlCommand("Update packingcharges set rateperltr=@rateperltr where productid=@pid and month=@month and year=@yr and branchid=@bid");
cmd.Parameters.Add("@month", month);
cmd.Parameters.Add("@yr", year);
cmd.Parameters.Add("@pid", productid);
cmd.Parameters.Add("@rateperltr", packingcharge);
cmd.Parameters.Add("@bid", mainbranch);
if (vdm.Update(cmd) == 0)
{
cmd = new SqlCommand("INSERT INTO packingcharges(productid, rateperltr, month, year, branchid, doe) values (@productid, @rate, @mnth, @year, @branchid, @doe)");
cmd.Parameters.Add("@mnth", month);
cmd.Parameters.Add("@year", year);
cmd.Parameters.Add("@productid", productid);
cmd.Parameters.Add("@rate", packingcharge);
cmd.Parameters.Add("@branchid", mainbranch);
cmd.Parameters.Add("@doe", ServerDateCurrentdate);
vdm.insert(cmd);
}
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
SalesDBManager nvdm = new SalesDBManager();
DataTable dtconsumption = (DataTable)Session["xportdata"];
DateTime CreateDate = SalesDBManager.GetTime(nvdm.conn);
string createdby = Session["Employ_Sno"].ToString();
if (dtconsumption.Rows.Count > 0)
{
foreach (DataRow dr in dtconsumption.Rows)
{
string date = dr["Invoice Date"].ToString();
DateTime dt = Convert.ToDateTime(date);
string qty = dr["Qty"].ToString();
string vcehicleno = dr["Customer Name"].ToString();
string Rate = dr["Rate"].ToString();
string pid = "2285";
if (Convert.ToDouble(qty) > 0)
{
sqlcmd = new SqlCommand("Insert into diesel_consumptiondetails (productid, qty, doe, vehicleno, dieselcost, createdby, createddate, branchid, categoryid, subcategoryid) values (@productid, @qty, @doe, @vehicleno, @dieselcost, @createdby, @createddate,@branchid, @catid, @subcatid)");
sqlcmd.Parameters.Add("@productid", pid);
sqlcmd.Parameters.Add("@qty", qty);
sqlcmd.Parameters.Add("@doe", dt);
sqlcmd.Parameters.Add("@vehicleno", vcehicleno);
sqlcmd.Parameters.Add("@createdby", createdby);
sqlcmd.Parameters.Add("@createddate", CreateDate);
sqlcmd.Parameters.Add("@dieselcost", Rate);
sqlcmd.Parameters.Add("@branchid", "2");
sqlcmd.Parameters.Add("@catid", "8");
sqlcmd.Parameters.Add("@subcatid", "37");
nvdm.insert(sqlcmd);
sqlcmd = new SqlCommand("update productmoniter set qty=qty-@qty where productid='2285' AND branchid=@branchid");
sqlcmd.Parameters.Add("@branchid", "2");
sqlcmd.Parameters.Add("@qty", qty);
nvdm.Update(sqlcmd);
}
}
lblmsg.Text = "Successfuly Saved";
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSubmitt_Click(object sender, EventArgs e)
{
try
{
if (Session["Employ_Sno"] != null)
{
lblError.Text = "";
UserName = Session["Employ_Sno"].ToString();
vdm = new SalesDBManager();
cmd = new SqlCommand("SELECT Passward FROM employee_erp WHERE Sno = @Sno");
cmd.Parameters.Add("@Sno", UserName);
DataTable dt = vdm.SelectQuery(cmd).Tables[0];
if (dt.Rows.Count > 0)
{
if (txtNewPassWord.Text == txtConformPassWord.Text)
{
txtNewPassWord.Text = txtConformPassWord.Text;
cmd = new SqlCommand("Update employee_erp set Passward=@Password where Sno=@Sno ");
cmd.Parameters.Add("@Sno", UserName);
cmd.Parameters.Add("@Password", txtNewPassWord.Text.Trim());
vdm.Update(cmd);
lblMessage.Text = "Your Password has been Changed successfully";
Response.Redirect("Login.aspx", false);
}
else
{
lblError.Text = "Conform password not match";
}
}
else
{
lblError.Text = "Entered username is incorrect";
}
}
else
{
Response.Redirect("Login.aspx", false);
}
}
catch (Exception ex)
{
lblError.Text = "Password Changed Failed";
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
vdm = new SalesDBManager();
string dieselqty = Session["quantity"].ToString();
string branchid = Session["Po_BranchID"].ToString();
double qty = Convert.ToDouble(dieselqty);
cmd = new SqlCommand("update productmoniter set qty=qty-@qty where productid='2285' AND branchid=@branchid");
cmd.Parameters.Add("@branchid", branchid);
cmd.Parameters.Add("@qty", qty);
vdm.Update(cmd);
cmd = new SqlCommand("insert into diesellogs(Date,Route,VehicleNo,VehicleType,DieselFilled,DriverName,LoadType,StartReading,PumpReading,Token) values ()");
lblmsg.Text = "Successfuly Updated";
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
DataTable dt = (DataTable)Session["btnImport"];
int i = 1;
foreach (DataRow dr in dt.Rows)
{
vdm = new SalesDBManager();
string sup_name = dr["Software Name"].ToString();
cmd = new SqlCommand("update suppliersdetails set suppliercode=@sapcode,tsuppliername=@tallyname where name=@sup_name");
cmd.Parameters.Add("@sapcode", dr["Sap Code"].ToString());
cmd.Parameters.Add("@sup_name", sup_name);
cmd.Parameters.Add("@tallyname", dr["Tally Name"].ToString());
vdm.Update(cmd);
i++;
}
lblmsg.Text = i + "Records updated successfully";
}
catch
{
}
}
protected void btn_WIDB_Click(object sender, EventArgs e)
{
try
{
DataTable dt = (DataTable)Session["dtImport"];
int i = 1;
foreach (DataRow dr in dt.Rows)
{
vdm = new SalesDBManager();
string itemcode = dr["icode"].ToString();
string scc = dr["scode"].ToString();
string pcode = dr["mcode"].ToString();
cmd = new SqlCommand(" UPDATE productmaster SET productcode = @pcode, sub_cat_code = @scc where itemcode =@itemcode");
cmd.Parameters.Add("@itemcode", itemcode);
cmd.Parameters.Add("@pcode", pcode);
cmd.Parameters.Add("@scc", scc);
vdm.Update(cmd);
//cmd = new SqlCommand("update productmoniter set qty=@qty, price=@price where ProductId=@ProductId");
//cmd.Parameters.Add("@qty", ClosingQty);
//cmd.Parameters.Add("@price", ClosingPrice);
//cmd.Parameters.Add("@ProductId", ProductId);
//vdm.Update(cmd);
//cmd = new SqlCommand("update productmaster set availablestores=@qty, price=@price where ProductId=@ProductId");
//cmd.Parameters.Add("@qty", ClosingQty);
//cmd.Parameters.Add("@price", ClosingPrice);
//cmd.Parameters.Add("@ProductId", ProductId);
//vdm.Update(cmd);
i++;
}
lblmsg.Text = i + "Records updated successfully";
}
catch
{
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
DataTable dtmiss = new DataTable();
dtmiss.Columns.Add("sno");
dtmiss.Columns.Add("Itemcode");
dtmiss.Columns.Add("productname");
DataTable dt = (DataTable)Session["btnImport"];
int count = dt.Rows.Count;
int i = 1;
foreach (DataRow dr in dt.Rows)
{
vdm = new SalesDBManager();
//////string itemname = dr["MATERIAL"].ToString();
//////string catname = dr["Category Name"].ToString();
//////string subcatname = dr["Sub Category Name"].ToString();
//////string UOM = dr["UOM"].ToString();
//////string minstock = dr["MinStock"].ToString();
//////string maxstock = dr["MaxStock"].ToString();
//////string qty = dr["Avilable Stores"].ToString();
//////string price = dr["Price"].ToString();
//////string amt = dr["AMOUNT"].ToString();
//////string uomid = "";
//////cmd = new SqlCommand("insert into categorymaster(category, createdby, status,branchid) values(@productid,@qty,@price,@entryby,@doe,@branchid)");
//////cmd.Parameters.Add("@category", catname);
//////cmd.Parameters.Add("@status", "True");
//////cmd.Parameters.Add("@createdby", "03/26/2018");
//////cmd.Parameters.Add("@branchid", "1064");
//////vdm.insert(cmd);
//////cmd = new SqlCommand("SELECT MAX(categoryid) as categoryid FROM categorymaster");
//////DataTable dtcategory = vdm.SelectQuery(cmd).Tables[0];
//////string categoryid = dtcategory.Rows[0]["categoryid"].ToString();
//////cmd = new SqlCommand("insert into subcategorymaster(categoryid,subcategoryname,status,branchid) values (@categoryid, @subcategoryname, @scstatus, @scbranchid )");
//////cmd.Parameters.Add("@categoryid", categoryid);
//////cmd.Parameters.Add("@subcategoryname", subcatname);
//////cmd.Parameters.Add("@scstatus", "True");
//////cmd.Parameters.Add("@scbranchid", "1064");
//////vdm.insert(cmd);
//////cmd = new SqlCommand("select MAX(subcategoryid) as subcategoryid from subcategorymaster");
//////DataTable dtsubcategory = vdm.SelectQuery(cmd).Tables[0];
//////string subcategoryid = dtsubcategory.Rows[0]["subcategoryid"].ToString();
//////cmd = new SqlCommand("insert into productmaster(subcategoryid, productname, sku, price, availablestores, uim, categoryid, branchid, itemcode) values ()");
//////cmd.Parameters.Add("@productname", itemname);
//////cmd.Parameters.Add("@subcategoryid", subcategoryid);
//////cmd.Parameters.Add("@sku", "productid");
//////cmd.Parameters.Add("@price", price);
//////cmd.Parameters.Add("@availablestores", qty);
//////cmd.Parameters.Add("@uim", UOM);
//////cmd.Parameters.Add("@categoryid", categoryid);
//////cmd.Parameters.Add("@itemcode", itemname);
//////cmd.Parameters.Add("@branchid", "1064");
//////vdm.insert(cmd);
//////cmd = new SqlCommand("select MAX(productid) as productid from productmaster");
//////DataTable dtproduct = vdm.SelectQuery(cmd).Tables[0];
//////string productid = dtsubcategory.Rows[0]["productid"].ToString();
//////cmd = new SqlCommand("insert into productmoniter( productid, qty, price, branchid, minstock, maxstock) values (@productid, @mqty, @mprice,@mbranchid,@minstock,@maxstock)");
//////cmd.Parameters.Add("@productid", productid);
//////cmd.Parameters.Add("@mqty", qty);
//////cmd.Parameters.Add("@mprice", price);
//////cmd.Parameters.Add("@mbranchid", "1064");
//////cmd.Parameters.Add("@minstock", minstock);
//////cmd.Parameters.Add("@maxstock", maxstock);
//////vdm.insert(cmd);
//////string itemname = dr["MATERIAL"].ToString();
//////string catname = dr["Category Name"].ToString();
//////string subcatname = dr["Sub Category Name"].ToString();
//////string UOM = dr["UOM"].ToString();
//////string minstock = dr["MinStock"].ToString();
//////string maxstock = dr["MaxStock"].ToString();
//////string qty = dr["Avilable Stores"].ToString();
//////string price = dr["Price"].ToString();
//////string amt = dr["AMOUNT"].ToString();
//////string uomid = "";
string productname = dr["Particulars"].ToString();
string qty = dr["ERP"].ToString();
string days = dr["Day cons"].ToString();
cmd = new SqlCommand("SELECT productid FROM productmaster WHERE (productname=@productname)");
cmd.Parameters.Add("@productname", productname);
DataTable dtproducts = vdm.SelectQuery(cmd).Tables[0];
if (dtproducts.Rows.Count > 0)
{
cmd = new SqlCommand("update productmoniter SET qty=@qty, perdayconcsumption=@perdayconcsumption WHERE (productid=@productid) AND (branchid=@branchid)");
cmd.Parameters.Add("@productid", dtproducts.Rows[0]["productid"].ToString());
cmd.Parameters.Add("@qty", qty);
cmd.Parameters.Add("@branchid", "2");
if (days == "" || days == null)
{
days = "0";
}
cmd.Parameters.Add("@perdayconcsumption", days);
vdm.Update(cmd);
}
else
{
DataRow newrow = dtmiss.NewRow();
newrow["Itemcode"] = productname;
newrow["productname"] = productname;
dtmiss.Rows.Add(newrow);
}
i++;
}
grdmiss.DataSource = dtmiss;
grdmiss.DataBind();
Session["xportdata"] = dtmiss;
Session["filename"] = "report";
}
catch
{
}
lblmsg.Text = "Records inserted successfully";
}
protected void login_click(object sender, EventArgs e)
{
try
{
vdm = new SalesDBManager();
string userid = Usernme_txt.Text, password = Pass_pas.Text;
cmd = new SqlCommand("SELECT branchmaster.gstin, branchmaster.branchledgername, branchmapping.mainbranch, employe_details.sno, employe_details.loginflag, employe_details.employename, employe_details.userid, employe_details.password, employe_details.emailid, employe_details.phone, employe_details.branchtype, employe_details.leveltype, employe_details.departmentid, employe_details.branchid, branchmaster.branchid AS Expr1, branchmaster.branchname, branchmaster.address, branchmaster.branchcode, branchmaster.phone AS Expr2, branchmaster.tino, branchmaster.stno, branchmaster.cstno, branchmaster.emailid AS Expr3, branchmaster.statename FROM employe_details INNER JOIN branchmaster ON employe_details.branchid = branchmaster.branchid INNER JOIN departmentmaster ON departmentmaster.sno=employe_details.departmentid INNER JOIN branchmapping ON branchmaster.branchid=branchmapping.subbranch WHERE (employe_details.userid = @userid) AND (employe_details.password = @pwd)");
cmd.Parameters.Add("@pwd", password);
cmd.Parameters.Add("@userid", userid);
DataTable dt = vdm.SelectQuery(cmd).Tables[0];
if (dt.Rows.Count > 0)
{
string loginflag = dt.Rows[0]["loginflag"].ToString();
//if (loginflag == "False")
//{
string sno = dt.Rows[0]["sno"].ToString();
cmd = new SqlCommand("update employe_details set loginflag=@log where sno=@sno");
cmd.Parameters.Add("@log", "1");
cmd.Parameters.Add("@sno", sno);
vdm.Update(cmd);
Session["TinNo"] = "37921042267";
Session["mainbranch"] = dt.Rows[0]["mainbranch"].ToString();
Session["Employ_Sno"] = dt.Rows[0]["sno"].ToString();
Session["Po_BranchID"] = dt.Rows[0]["branchid"].ToString();
Session["stateid"] = dt.Rows[0]["statename"].ToString();
Session["TitleName"] = "SRI VYSHNAVI DAIRY SPECIALITIES (P) LTD";
string julydt = "07/01/2017 12:00:00 AM";
DateTime gst_dt = Convert.ToDateTime(julydt);
DateTime today = DateTime.Today;
//if (today > gst_dt)
//{
Session["Address"] = dt.Rows[0]["address"].ToString();
Session["gstin"] = dt.Rows[0]["gstin"].ToString();
//}
//else
//{
// Session["Address"] = "Survey No. 381-2, Punabaka Village, Pellakuru mandal SPSR Nellore (Dt) Pin - 524129, Andhra Pradesh,11. Email : [email protected] Phone: 7729995606; GSTIN NO: 37921042267.";
// // Session["Address"] = "Survey No. 381-2, Punabaka Village, Pellakuru mandal SPSR Nellore (Dt) Pin - 524129.Couriering address : No.45, Madhu apartments,Panagal-517640,Srikalahasthi,Chittoor(dt),AndhraPradesh. Email : [email protected];[email protected] Phone: 7729995606,7729995603,9382525913; GSTIN: 37921042267."; //dt.Rows[0]["address"].ToString();
//}
Session["BranchCode"] = dt.Rows[0]["branchcode"].ToString();
Session["TinNo"] = "37921042267";
Session["stno"] = dt.Rows[0]["stno"].ToString();
Session["cstno"] = dt.Rows[0]["cstno"].ToString();
Session["phone"] = dt.Rows[0]["phone"].ToString();
Session["emailid"] = dt.Rows[0]["emailid"].ToString();
Session["UserName"] = dt.Rows[0]["employename"].ToString();
Session["password"] = dt.Rows[0]["password"].ToString();
Session["BranchType"] = dt.Rows[0]["branchtype"].ToString();
Session["Department"] = dt.Rows[0]["departmentid"].ToString();
Session["leveltype"] = dt.Rows[0]["leveltype"].ToString();
Session["branchledgername"] = dt.Rows[0]["branchledgername"].ToString();
string branchtype = dt.Rows[0]["BranchType"].ToString();
string leveltype = dt.Rows[0]["leveltype"].ToString();
Response.Cookies["UserName"].Value = HttpUtility.UrlEncode("true");
Response.Cookies["UserName"].Path = "/";
Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(1);
Response.Cookies["Employ_Sno"].Value = HttpUtility.UrlEncode("true");
Response.Cookies["Employ_Sno"].Path = "/";
Response.Cookies["Employ_Sno"].Expires = DateTime.Now.AddDays(1);
//get ip address and device type
string ipaddress;
ipaddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (ipaddress == "" || ipaddress == null)
{
ipaddress = Request.ServerVariables["REMOTE_ADDR"];
}
DateTime ServerDateCurrentdate = SalesDBManager.GetTime(vdm.conn);
HttpBrowserCapabilities browser = Request.Browser;
string devicetype = "";
string userAgent = Request.ServerVariables["HTTP_USER_AGENT"];
Regex OS = new Regex(@"(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|mobile.+firefox|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows ce|xda|xiino", RegexOptions.IgnoreCase | RegexOptions.Multiline);
Regex device = new Regex(@"1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|le(no|xi)|lg( g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-", RegexOptions.IgnoreCase | RegexOptions.Multiline);
string device_info = string.Empty;
if (OS.IsMatch(userAgent))
{
device_info = OS.Match(userAgent).Groups[0].Value;
}
if (device.IsMatch(userAgent.Substring(0, 4)))
{
device_info += device.Match(userAgent).Groups[0].Value;
}
if (!string.IsNullOrEmpty(device_info))
{
devicetype = device_info;
string[] words = devicetype.Split(')');
devicetype = words[0].ToString();
}
else
{
devicetype = "Desktop";
}
//string alphabets = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
//string small_alphabets = "abcdefghijklmnopqrstuvwxyz";
//string numbers = "1234567890";
//string characters = numbers;
//characters += alphabets + small_alphabets + numbers;
//int length = 8;
//string otp = string.Empty;
//for (int i = 0; i < length; i++)
//{
// string character = string.Empty;
// do
// {
// int index = new Random().Next(0, characters.Length);
// character = characters.ToCharArray()[index].ToString();
// } while (otp.IndexOf(character) != -1);
// otp += character;
//}
cmd = new SqlCommand("INSERT INTO logininfo(userid, username, logintime, ipaddress, devicetype) values (@userid, @UserName, @logintime, @ipaddress, @device)");
cmd.Parameters.Add("@userid", dt.Rows[0]["sno"].ToString());
cmd.Parameters.Add("@UserName", Session["UserName"]);
cmd.Parameters.Add("@logintime", ServerDateCurrentdate);
cmd.Parameters.Add("@ipaddress", ipaddress);
cmd.Parameters.Add("@device", devicetype);
//cmd.Parameters.Add("@otp", otp);
vdm.insert(cmd);
// Session["leveltype"] = "Admin";
if (leveltype == "Admin ")
{
Response.Redirect("chartdashboard.aspx", false);
}
if (leveltype == "SuperAdmin")
{
Response.Redirect("chartdashboard.aspx", false);
}
if (leveltype == "User ")
{
Response.Redirect("InwardReport.aspx", false);
}
if (leveltype == "Operations")
{
Response.Redirect("PoDashBoard.aspx", false);
}
if (leveltype == "Issue ")
{
Response.Redirect("IssueDashBoard.aspx", false);
}
if (leveltype == "Receipt ")
{
Response.Redirect("InwardDashboard.aspx", false);
}
if (leveltype == "Section ")
{
Response.Redirect("IndentEntry.aspx", false);
}
//}
//else
//{
// lblMsg.Text = "Already Some one Login With This User Name";
//}
}
else
{
lblMsg.Text = "Invalid userId and Password";
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
void GetReport()
{
try
{
lblmsg.Text = "";
pnlHide.Visible = true;
Session["RouteName"] = ddlSalesOffice.SelectedItem.Text;
Session["IDate"] = DateTime.Now.AddDays(1).ToString("dd/MM/yyyy");
vdm = new SalesDBManager();
DateTime fromdate = DateTime.Now;
DateTime todate = DateTime.Now;
string[] dateFromstrig = txtFromdate.Text.Split(' ');
if (dateFromstrig.Length > 1)
{
if (dateFromstrig[0].Split('-').Length > 0)
{
string[] dates = dateFromstrig[0].Split('-');
string[] times = dateFromstrig[1].Split(':');
fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0);
}
}
dateFromstrig = dtp_Todate.Text.Split(' ');
if (dateFromstrig.Length > 1)
{
if (dateFromstrig[0].Split('-').Length > 0)
{
string[] dates = dateFromstrig[0].Split('-');
string[] times = dateFromstrig[1].Split(':');
todate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0);
}
}
DataTable Report = new DataTable();
Report.Columns.Add("DOE");
Report.Columns.Add("Ref Receipt");
Report.Columns.Add("Receipt");
Report.Columns.Add("Type");
Report.Columns.Add("Name");
Report.Columns.Add("Amount").DataType = typeof(Double);
lbl_selfromdate.Text = fromdate.ToString("dd/MM/yyyy");
lblRoutName.Text = ddlSalesOffice.SelectedItem.Text;
DateTime ReportDate = SalesDBManager.GetTime(vdm.conn);
DateTime dtapril = new DateTime();
DateTime dtmarch = new DateTime();
int currentyear = ReportDate.Year;
int nextyear = ReportDate.Year + 1;
if (ReportDate.Month > 3)
{
string apr = "4/1/" + currentyear;
dtapril = DateTime.Parse(apr);
string march = "3/31/" + nextyear;
dtmarch = DateTime.Parse(march);
}
if (ReportDate.Month <= 3)
{
string apr = "4/1/" + (currentyear - 1);
dtapril = DateTime.Parse(apr);
string march = "3/31/" + (nextyear - 1);
dtmarch = DateTime.Parse(march);
}
Session["xporttype"] = "TallyPayments";
string ledger = "";
Session["filename"] = ddlSalesOffice.SelectedItem.Text + " Tally Payments" + fromdate.ToString("dd/MM/yyyy");
cmd = new SqlCommand("SELECT cashpayables.DOE, cashpayables.VocherID, subpayable.vouchercode, cashpayables.Sno, subpayable.HeadSno, cashpayables.Remarks,cashpayables.Remarks AS Expr1, subpayable.sno AS Expr2, subpayable.Amount, accountheads.HeadName,accountheads.ledger_code, cashpayables.BranchID, Plant_Master.ladger_dr,Plant_Master.WHcode, Plant_Master.ladger_dr_code FROM cashpayables INNER JOIN subpayable ON cashpayables.Sno = subpayable.RefNo INNER JOIN accountheads ON subpayable.HeadSno = accountheads.Sno INNER JOIN Plant_Master ON cashpayables.BranchID = Plant_Master.Plant_Code WHERE (cashpayables.BranchID = @BranchID) AND (cashpayables.DOE BETWEEN @d1 AND @d2) AND (cashpayables.VoucherType = 'Debit') AND (cashpayables.Status = 'P')");
cmd.Parameters.Add("@BranchID", ddlSalesOffice.SelectedValue);
cmd.Parameters.Add("@d1", GetLowDate(fromdate));
cmd.Parameters.Add("@d2", GetHighDate(todate));
DataTable dtAgent = vdm.SelectQuery(cmd).Tables[0];
if (dtAgent.Rows.Count > 0)
{
DataView view = new DataView(dtAgent);
dtReport = new DataTable();
dtReport.Columns.Add("Voucher Date");
dtReport.Columns.Add("Voucher No");
dtReport.Columns.Add("Voucher Type");
dtReport.Columns.Add("whcode");
//dtReport.Columns.Add("ApprovedBy");
dtReport.Columns.Add("Credit Code");
dtReport.Columns.Add("Ledger (Cr)");
dtReport.Columns.Add("Debit Code");
dtReport.Columns.Add("Ledger (Dr)");
dtReport.Columns.Add("Amount");
dtReport.Columns.Add("Narration");
int i = 1;
foreach (DataRow branch in dtAgent.Rows)
{
string VoucherNo = "";
cmd = new SqlCommand("SELECT vouchercode,RefNo, HeadDesc, Amount, HeadSno, sno, branchid, paiddate FROM subpayable WHERE (branchid = @BranchID) AND (paiddate BETWEEN @d1 AND @d2)");
cmd.Parameters.Add("@BranchID", ddlSalesOffice.SelectedValue);
cmd.Parameters.Add("@d1", GetLowDate(fromdate));
cmd.Parameters.Add("@d2", GetLowDate(fromdate));
DataTable dtVoucher = vdm.SelectQuery(cmd).Tables[0];
if (dtVoucher.Rows.Count > 0)
{
DataRow[] drvoucher = dtVoucher.Select("branchid='" + ddlSalesOffice.SelectedValue + "' and RefNo='" + branch["sno"].ToString() + "' and HeadSno='" + branch["HeadSno"].ToString() + "'");
if (drvoucher.Length > 0)
{
foreach (DataRow drv in drvoucher)
{
VoucherNo = drv.ItemArray[0].ToString();
}
}
else
{
cmd = new SqlCommand("SELECT ISNULL(MAX(vouchercode), 0) + 1 AS Sno FROM subpayable WHERE (branchid = @branchid) AND (paiddate BETWEEN @d1 AND @d2)");
cmd.Parameters.Add("@branchid", ddlSalesOffice.SelectedValue);
cmd.Parameters.Add("@HeadSno", branch["HeadSno"].ToString());
cmd.Parameters.Add("@d1", GetLowDate(dtapril.AddDays(-1)));
cmd.Parameters.Add("@d2", GetHighDate(dtmarch.AddDays(-1)));
DataTable dtvoucherno = vdm.SelectQuery(cmd).Tables[0];
VoucherNo = dtvoucherno.Rows[0]["Sno"].ToString();
cmd = new SqlCommand("update subpayable set vouchercode=@vouchercode, paiddate=@paiddate,branchid=@branchid where (RefNo=@RefNo) AND (HeadSno = @HeadSno)");;
cmd.Parameters.Add("@vouchercode", VoucherNo);
cmd.Parameters.Add("@paiddate", fromdate);
cmd.Parameters.Add("@branchid", ddlSalesOffice.SelectedValue);
cmd.Parameters.Add("@RefNo", branch["sno"].ToString());
cmd.Parameters.Add("@HeadSno", branch["HeadSno"].ToString());
vdm.Update(cmd);
}
}
else
{
cmd = new SqlCommand("SELECT ISNULL(MAX(vouchercode), 0) + 1 AS Sno FROM subpayable WHERE (branchid = @branchid) AND (paiddate BETWEEN @d1 AND @d2)");
cmd.Parameters.Add("@branchid", ddlSalesOffice.SelectedValue);
cmd.Parameters.Add("@HeadSno", branch["HeadSno"].ToString());
cmd.Parameters.Add("@d1", GetLowDate(dtapril.AddDays(-1)));
cmd.Parameters.Add("@d2", GetHighDate(dtmarch.AddDays(-1)));
DataTable dtvoucherno = vdm.SelectQuery(cmd).Tables[0];
VoucherNo = dtvoucherno.Rows[0]["Sno"].ToString();
cmd = new SqlCommand("update subpayable set vouchercode=@vouchercode, paiddate=@paiddate,branchid=@branchid where (RefNo=@RefNo) AND (HeadSno = @HeadSno)");;
cmd.Parameters.Add("@vouchercode", VoucherNo);
cmd.Parameters.Add("@paiddate", fromdate);
cmd.Parameters.Add("@branchid", ddlSalesOffice.SelectedValue);
cmd.Parameters.Add("@RefNo", branch["sno"].ToString());
cmd.Parameters.Add("@HeadSno", branch["HeadSno"].ToString());
vdm.Update(cmd);
}
if (VoucherNo == "0")
{
cmd = new SqlCommand("SELECT IFNULL(MAX(vouchercode), 0) + 1 AS Sno FROM subpayable WHERE (branchid = @branchid) AND (paiddate BETWEEN @d1 AND @d2)");
cmd.Parameters.Add("@branchid", ddlSalesOffice.SelectedValue);
cmd.Parameters.Add("@HeadSno", branch["HeadSno"].ToString());
cmd.Parameters.Add("@d1", GetLowDate(dtapril.AddDays(-1)));
cmd.Parameters.Add("@d2", GetHighDate(dtmarch.AddDays(-1)));
DataTable dtvoucherno = vdm.SelectQuery(cmd).Tables[0];
VoucherNo = dtvoucherno.Rows[0]["Sno"].ToString();
cmd = new SqlCommand("update subpayable set vouchercode=@vouchercode, paiddate=@paiddate,branchid=@branchid where (RefNo=@RefNo) AND (HeadSno = @HeadSno)");;
cmd.Parameters.Add("@vouchercode", VoucherNo);
cmd.Parameters.Add("@paiddate", fromdate);
cmd.Parameters.Add("@branchid", ddlSalesOffice.SelectedValue);
cmd.Parameters.Add("@RefNo", branch["sno"].ToString());
cmd.Parameters.Add("@HeadSno", branch["HeadSno"].ToString());
vdm.Update(cmd);
}
string NewVoucherNo = "0";
int countdc = 0;
int.TryParse(VoucherNo, out countdc);
if (countdc <= 10)
{
NewVoucherNo = "000" + countdc;
}
if (countdc >= 10 && countdc <= 99)
{
NewVoucherNo = "00" + countdc;
}
if (countdc >= 99 && countdc <= 999)
{
NewVoucherNo = "0" + countdc;
}
DataRow newrow = dtReport.NewRow();
string Date = branch["DOE"].ToString();
DateTime from_date = Convert.ToDateTime(Date);
newrow["Voucher Date"] = from_date.ToString("dd-MMM-yyyy");
newrow["Voucher No"] = ddlSalesOffice.SelectedValue + dtapril.ToString("yy") + dtmarch.ToString("yy") + NewVoucherNo;
newrow["Voucher Type"] = "Cash Payment Import";
newrow["Ledger (Cr)"] = branch["ladger_dr"].ToString();
newrow["Debit Code"] = branch["ledger_code"].ToString();
newrow["Credit Code"] = branch["ladger_dr_code"].ToString();
newrow["Ledger (Dr)"] = branch["HeadName"].ToString();
newrow["Amount"] = branch["Amount"].ToString();
newrow["whcode"] = branch["WHcode"].ToString();
double invval = 0;
newrow["Narration"] = branch["Remarks"].ToString() + ",VoucherID " + VoucherNo + ",Emp Name " + Session["EmpName"].ToString();
dtReport.Rows.Add(newrow);
i++;
}
grdReports.DataSource = dtReport;
grdReports.DataBind();
Session["xportdata"] = dtReport;
}
else
{
pnlHide.Visible = false;
lblmsg.Text = "No Indent Found";
grdReports.DataSource = dtReport;
grdReports.DataBind();
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
grdReports.DataSource = dtReport;
grdReports.DataBind();
}
}
protected void login_click(object sender, EventArgs e)
{
try
{
username = Usernme_txt.Text;
password = Pass_pas.Text;
lbl_username.Text = username;
lbl_passwords.Text = password;
DateTime ServerDateCurrentdate = SalesDBManager.GetTime(vdm.conn);
//cmd = new SqlCommand("SELECT employee_erp.sno, employee_erp.leveltype,employee_erp.loginstatus, branch_info.venorid, employee_erp.empname, employee_erp.deptid, employee_erp.username, employee_erp.passward, employee_erp.emptype, employee_erp.branchid, branch_info.branchtype,branch_info.address,branch_info.branchname,branch_info.tinno FROM employee_erp INNER JOIN branch_info ON employee_erp.branchid = branch_info.sno WHERE (employee_erp.username = @UN) AND (employee_erp.passward = @Pwd)");
cmd = new SqlCommand("SELECT employee_erp.sno, employee_erp.leveltype,employee_erp.loginstatus, branch_info.venorid, branch_info.branchcode, employee_erp.empname, employee_erp.deptid, employee_erp.username, employee_erp.passward, employee_erp.emptype, employee_erp.branchid, branch_info.branchtype,branch_info.address,branch_info.branchname,branch_info.tinno, employee_erp.phoneno, employee_erp.otpstatus,employee_erp.empid FROM employee_erp INNER JOIN branch_info ON employee_erp.branchid = branch_info.sno WHERE (employee_erp.username = @UN) AND (employee_erp.passward = @Pwd)");
cmd.Parameters.Add("@Pwd", password);
cmd.Parameters.Add("@UN", username);
DataTable dt = vdm.SelectQuery(cmd).Tables[0];
if (dt.Rows.Count > 0)
{
string otpstatus = dt.Rows[0]["otpstatus"].ToString();
if (otpstatus == "1")
{
//session
string sno = dt.Rows[0]["sno"].ToString();
cmd = new SqlCommand("update employee_erp set loginstatus=@log where sno=@sno");
cmd.Parameters.Add("@log", "1");
cmd.Parameters.Add("@sno", sno);
vdm.Update(cmd);
Session["TitleName"] = dt.Rows[0]["branchname"].ToString(); // "SRI VYSHNAVI DAIRY SPECIALITIES (P) LTD";
Session["TinNo"] = dt.Rows[0]["tinno"].ToString();
Session["DeptID"] = dt.Rows[0]["deptid"].ToString();
Session["Employ_Sno"] = dt.Rows[0]["sno"].ToString();
Session["Branch_ID"] = dt.Rows[0]["branchid"].ToString();
Session["Emp_Type"] = dt.Rows[0]["emptype"].ToString();
Session["Address"] = dt.Rows[0]["address"].ToString(); //"R.S.No:381/2,Punabaka village Post,Pellakuru Mandal,Nellore District -524129., ANDRAPRADESH (State).Phone: 9440622077, Fax: 044 – 26177799. ";// dt.Rows[0]["brnch_address"].ToString();
Session["BranchType"] = dt.Rows[0]["branchtype"].ToString();
Session["leveltype"] = dt.Rows[0]["leveltype"].ToString();
Session["UserName"] = dt.Rows[0]["empname"].ToString();
Session["VendorID"] = dt.Rows[0]["venorid"].ToString();
Session["loginflag"] = dt.Rows[0]["loginstatus"].ToString();
Session["branchcode"] = dt.Rows[0]["branchcode"].ToString();
Session["HRMS_EmpId"] = dt.Rows[0]["empid"].ToString();
string hostName = Dns.GetHostName(); // Retrive the Name of HOST
//get ip address and device type
ipaddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (ipaddress == "" || ipaddress == null)
{
ipaddress = Request.ServerVariables["REMOTE_ADDR"];
}
HttpBrowserCapabilities browser = Request.Browser;
string devicetype = "";
string userAgent = Request.ServerVariables["HTTP_USER_AGENT"];
Regex OS = new Regex(@"(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|mobile.+firefox|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows ce|xda|xiino", RegexOptions.IgnoreCase | RegexOptions.Multiline);
Regex device = new Regex(@"1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|le(no|xi)|lg( g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-", RegexOptions.IgnoreCase | RegexOptions.Multiline);
string device_info = string.Empty;
if (OS.IsMatch(userAgent))
{
device_info = OS.Match(userAgent).Groups[0].Value;
}
if (device.IsMatch(userAgent.Substring(0, 4)))
{
device_info += device.Match(userAgent).Groups[0].Value;
}
if (!string.IsNullOrEmpty(device_info))
{
devicetype = device_info;
string[] words = devicetype.Split(')');
devicetype = words[0].ToString();
}
else
{
devicetype = "Desktop";
}
cmd = new SqlCommand("INSERT INTO logininfo(UserId, UserName, Logintime, IpAddress,devicetype,status) values (@userid, @UserName, @logintime, @ipaddress,@devicetype,@status)");
cmd.Parameters.Add("@userid", dt.Rows[0]["sno"].ToString());
cmd.Parameters.Add("@UserName", Session["UserName"]);
cmd.Parameters.Add("@logintime", ServerDateCurrentdate);
cmd.Parameters.Add("@ipaddress", ipaddress);
cmd.Parameters.Add("@devicetype", devicetype);
cmd.Parameters.Add("@status", "1");
vdm.insert(cmd);
//End
//otp
string Id = string.Empty;
string no = dt.Rows[0]["phoneno"].ToString();
string empid = dt.Rows[0]["sno"].ToString();
string numbers = "1234567890";
string characters = numbers;
int length = 6;
string otp = string.Empty;
for (int i = 0; i < length; i++)
{
string character = string.Empty;
do
{
int index = new Random().Next(0, characters.Length);
character = characters.ToCharArray()[index].ToString();
} while (otp.IndexOf(character) != -1);
otp += character;
}
DateTime sdt = SalesDBManager.GetTime(vdm.conn);
int h = Convert.ToInt32(sdt.ToString("HH"));
int m = 0;
string otpexptime = string.Empty;
string sss = string.Empty;
string mm = string.Empty;
m = Convert.ToInt32(sdt.ToString("mm")) + 3;
int ss = Convert.ToInt32(sdt.ToString("ss"));
if (ss > 60)
{
ss = ss - 60;
}
if (ss < 10)
{
sss = "0" + m.ToString();
}
if (m > 60)
{
m = m - 60;
}
if (m < 10)
{
if (ss < 10)
{
mm = "0" + m.ToString();
otpexptime = h.ToString() + ":" + mm.ToString() + ":" + sss.ToString();
}
else
{
mm = m.ToString();
otpexptime = h.ToString() + ":" + mm.ToString() + ":" + ss.ToString();
}
}
else
{
if (ss < 10)
{
otpexptime = h.ToString() + ":" + m.ToString() + ":" + sss.ToString();
}
else
{
otpexptime = h.ToString() + ":" + m.ToString() + ":" + ss.ToString();
}
}
Otpupdate(no, otp, otpexptime, empid);
Id = Encrypt(no.Trim());
string hyperlink = "otp.aspx?Id=" + Id.Trim();
string message1 = "OTP for " + empid + " Login : "******". Valid till " + otpexptime + " Do not share OTP for security reasons.";
string strUrl = "http://123.63.33.43/blank/sms/user/urlsms.php?username=vyshnavidairy&pass=vyshnavi@123&senderid=VYSAKG&dest_mobileno=" + no + "&message=" + message1 + "&response=Y";
//string strUrl = "http://103.16.101.52:8080/sendsms/bulksms?username=kapd-vyshnavi&password=vysavi&type=0&dlr=1&destination=" + no + "&source=VYSHRM&message=" + message1 + "";
WebRequest request = HttpWebRequest.Create(strUrl);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream s = (Stream)response.GetResponseStream();
StreamReader readStream = new StreamReader(s);
string dataString = readStream.ReadToEnd();
response.Close();
s.Close();
readStream.Close();
string msg = hyperlink;
Response.Redirect("otp.aspx?Id=" + Id.Trim());
}
else
{
fill_login_details();
}
}
else
{
lbl_validation.Text = "Check Your Username and password";
}
}
catch (Exception ex)
{
lbl_validation.Text = ex.Message;
}
}