protected void finalize_stockclosing(object sender, EventArgs e) { vdm = new SalesDBManager(); DataTable dt = (DataTable)Session["xportdata"]; DateTime doe = SalesDBManager.GetTime(vdm.conn); DateTime closingdate = doe.AddDays(1); string entryby = Session["Employ_Sno"].ToString(); string branchid = Session["Po_BranchID"].ToString(); foreach (DataRow dr in dt.Rows) { try { string productname = dr["Product Name"].ToString(); if (productname != "Total") { string qty = dr["ClosingQty"].ToString(); if (qty != "0") { double price = Convert.ToDouble(dr["OpPrice"].ToString()); if (price > 1) { } else { price = Convert.ToDouble(dr["ReceiptPrice"].ToString()); } cmd = new SqlCommand("select productid from productmaster where productname = @productname"); cmd.Parameters.Add("@productname", productname); DataTable dt_productid = vdm.SelectQuery(cmd).Tables[0]; string productid = dt_productid.Rows[0]["productid"].ToString(); cmd = new SqlCommand("insert into stockclosingdetails (productid,qty,price,doe,entryby,branchid) values (@productid,@qty,@price,@doe,@entryby,@branchid)"); cmd.Parameters.Add("@productid", productid); cmd.Parameters.Add("@qty", qty); cmd.Parameters.Add("@price", price); cmd.Parameters.Add("@doe", closingdate); cmd.Parameters.Add("@entryby", entryby); cmd.Parameters.Add("@branchid", branchid); vdm.insert(cmd); } else { } } } catch (Exception ex) { string productname = dr["Product Name"].ToString(); } } lblmsg.Text = "Saved successfully"; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); }
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 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 itemcode = dr["Itemcode"].ToString(); string productname = dr["productname"].ToString(); cmd = new SqlCommand("SELECT productid FROM productmaster WHERE ((itemcode=@itemcode) OR (productname=@productname))"); cmd.Parameters.Add("@itemcode", itemcode); cmd.Parameters.Add("@productname", productname); DataTable dtproducts = vdm.SelectQuery(cmd).Tables[0]; if (dtproducts.Rows.Count > 0) { } else { cmd = new SqlCommand("insert into productmaster(productname,itemcode,createdby, branchid) values(@productname,@itemcode,@entryby,@branchid)"); cmd.Parameters.Add("@productname", productname); cmd.Parameters.Add("@itemcode", itemcode); cmd.Parameters.Add("@branchid", "2"); cmd.Parameters.Add("@entryby", Session["Employ_Sno"].ToString()); vdm.insert(cmd); } //cmd = new SqlCommand("update branchmaster set whcode=@whcode where branchname=@branchname"); //cmd.Parameters.Add("@whcode", dr["Center Code"].ToString()); //cmd.Parameters.Add("@branchname", branchname); ////cmd.Parameters.Add("@bin", dr["Bin No"].ToString()); //vdm.Update(cmd); i++; } lblmsg.Text = i + "Records updated successfully"; } catch { } }
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; } }
protected void BtnSave_Click(object sender, EventArgs e) { try { vdm = new SalesDBManager(); string totIOU = lblIou.Text; //string DenCash = Session["Cash"].ToString(); double IOU = 0; double.TryParse(totIOU, out IOU); //double Cash = 0; //double.TryParse(DenCash, out Cash); // double TotalAmount = 0; double Totalclosing = 0; //TotalAmount = Cash + IOU; //double diffamount = 0; //double.TryParse(lblDiffernce.Text, out diffamount); double.TryParse(lblhidden.Text, out Totalclosing); DataTable dt = (DataTable)Session["IOUReport"]; lblmsg.Text = ""; DateTime fromdate = new DateTime(); string[] datestrig = txtFromdate.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); } } fromdate = fromdate; DateTime ServerDateCurrentdate = SalesDBManager.GetTime(vdm.conn); string DenominationString = Session["DenominationString"].ToString(); cmd = new SqlCommand("SELECT BranchID FROM Collections 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", GetHighDate(fromdate)); DataTable dtCol = vdm.SelectQuery(cmd).Tables[0]; if (dtCol.Rows.Count > 0) { lblmsg.Text = "Cash Book already closed"; } else { /////////////////....................Ravindra.....................//////////////// //cmd = new SqlCommand("SELECT cashpayables.Sno, cashpayables.BranchID, cashpayables.CashTo,subpayable.HeadSno, cashpayables.DOE, cashpayables.VocherID, cashpayables.Remarks, SUM(cashpayables.ApprovedAmount) AS Amount, accountheads.HeadName FROM cashpayables INNER JOIN subpayable ON cashpayables.Sno = subpayable.RefNo INNER JOIN accountheads ON subpayable.HeadSno = accountheads.Sno WHERE (cashpayables.BranchID = @BranchID) AND (cashpayables.Status='P') AND (cashpayables.VoucherType = 'Credit') GROUP BY accountheads.Sno ORDER BY accountheads.HeadName"); cmd = new SqlCommand("SELECT cashpayables.Sno, cashpayables.BranchID, cashpayables.CashTo, subpayable.HeadSno, cashpayables.DOE, cashpayables.VocherID, cashpayables.Remarks, SUM(cashpayables.ApprovedAmount) AS Amount, accountheads.HeadName FROM cashpayables INNER JOIN subpayable ON cashpayables.Sno = subpayable.RefNo INNER JOIN accountheads ON subpayable.HeadSno = accountheads.Sno WHERE (cashpayables.BranchID = @BranchID) AND (cashpayables.Status = 'P') AND (cashpayables.VoucherType = 'Credit') GROUP BY cashpayables.Sno, cashpayables.BranchID, cashpayables.CashTo, subpayable.HeadSno, cashpayables.DOE, cashpayables.VocherID, cashpayables.Remarks, cashpayables.Amount, accountheads.HeadName ORDER BY accountheads.HeadName"); cmd.Parameters.Add("@BranchID", ddlSalesOffice.SelectedValue); DataTable dtCredit = vdm.SelectQuery(cmd).Tables[0]; /////////////////....................Ravindra.....................//////////////// //cmd = new SqlCommand("SELECT cashpayables.onNameof,cashpayables.CashTo, SUM(cashpayables.ApprovedAmount) AS Amount, subpayable.HeadSno, accountheads.HeadName FROM cashpayables INNER JOIN subpayable ON cashpayables.Sno = subpayable.RefNo INNER JOIN accountheads ON subpayable.HeadSno = accountheads.Sno WHERE (cashpayables.BranchID = @BranchID) AND (cashpayables.VoucherType = 'Due') AND (cashpayables.Status<> 'C') AND (cashpayables.Status='P') GROUP BY accountheads.HeadName ORDER BY accountheads.HeadName"); cmd = new SqlCommand("SELECT cashpayables.onNameof, cashpayables.CashTo, SUM(cashpayables.ApprovedAmount) AS Amount, subpayable.HeadSno, accountheads.HeadName FROM cashpayables INNER JOIN subpayable ON cashpayables.Sno = subpayable.RefNo INNER JOIN accountheads ON subpayable.HeadSno = accountheads.Sno WHERE (cashpayables.BranchID = @BranchID) AND (cashpayables.VoucherType = 'Due') AND (cashpayables.Status <> 'C') AND (cashpayables.Status = 'P') GROUP BY cashpayables.onNameof, cashpayables.CashTo, cashpayables.Amount, subpayable.HeadSno, accountheads.HeadName ORDER BY accountheads.HeadName"); cmd.Parameters.Add("@BranchID", ddlSalesOffice.SelectedValue); DataTable dtDebit = vdm.SelectQuery(cmd).Tables[0]; foreach (DataRow dr in dtDebit.Rows) { string IouName = dr["HeadName"].ToString(); double iouamtdebit = 0; double iouamtcredit = 0; double TotIouBal = 0; double.TryParse(dr["Amount"].ToString(), out iouamtdebit); foreach (DataRow drcredit in dtCredit.Select("HeadSno='" + dr["HeadSno"].ToString() + "'")) { double.TryParse(drcredit["Amount"].ToString(), out iouamtcredit); } TotIouBal = iouamtdebit - iouamtcredit; if (TotIouBal == 0) { } else { cmd = new SqlCommand("Insert into ioutable (BranchID,IOU,Amount,DOE) values(@BranchID,@IOU,@Amount,@DOE)"); cmd.Parameters.Add("@BranchID", ddlSalesOffice.SelectedValue); cmd.Parameters.Add("@Amount", TotIouBal); cmd.Parameters.Add("@IOU", IouName); cmd.Parameters.Add("@DOE", fromdate); vdm.insert(cmd); } } cmd = new SqlCommand("Insert into Collections (BranchID,AmountPaid,UserData_sno,PaidDate,PaymentType,Denominations,EmpID,VarifyDate) values(@BranchID,@AmountPaid,@UserData_sno,@PaidDate,@PaymentType,@Denominations,@EmpID,@VarifyDate)"); cmd.Parameters.Add("@BranchID", ddlSalesOffice.SelectedValue); //cmd.Parameters.Add("@AmountPaid", TotalAmount); cmd.Parameters.Add("@AmountPaid", Math.Round(Totalclosing, 2)); cmd.Parameters.Add("@Denominations", DenominationString); cmd.Parameters.Add("@UserData_sno", "1"); cmd.Parameters.Add("@PaidDate", fromdate); cmd.Parameters.Add("@VarifyDate", ServerDateCurrentdate); cmd.Parameters.Add("@PaymentType", "Cash"); cmd.Parameters.Add("@EmpID", Session["UserSno"].ToString()); vdm.insert(cmd); lblmsg.Text = "Cash Book saved successfully"; GetReport(); } } catch (Exception ex) { lblmsg.Text = ex.Message; } }
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; } }
protected void btnSave_Click(object sender, EventArgs e) { try { DataTable dtmiss = new DataTable(); dtmiss.Columns.Add("Itemcode"); dtmiss.Columns.Add("productname"); DataTable dt = (DataTable)Session["btnImport"]; int i = 1; foreach (DataRow dr in dt.Rows) { vdm = new SalesDBManager(); //string productid = dr["productid"].ToString(); //string qty = dr["qty"].ToString(); //string price = dr["price"].ToString(); //string branchid = dr["branchid"].ToString(); //string minstock = dr["minstock"].ToString(); //string maxsstock = dr["maxsstock"].ToString(); string itemname = dr["SWEETNAME"].ToString(); string BILLINGPRICE = dr["MRP"].ToString(); string MRP = dr["MRP"].ToString(); string Categoryid = dr["Categoryid"].ToString(); string Subcategoryid = dr["Subcategoryid"].ToString(); string UOM = dr["uom"].ToString(); string GST = dr["GST"].ToString(); string IGST = dr["IGST"].ToString(); string CGST = dr["CGST"].ToString(); string SGST = dr["SGST"].ToString(); cmd = new SqlCommand("insert into productmaster(subcategoryid, categoryid, productname, price, billingprice, uim, gsttaxcategory, igst, cgst, sgst,status) values (@subcategoryid, @categoryid, @productname, @price, @billingprice, @uim, @gsttaxcategory, @igst, @cgst, @sgst, @status)"); cmd.Parameters.Add("@subcategoryid", Subcategoryid); cmd.Parameters.Add("@categoryid", Categoryid); cmd.Parameters.Add("@productname", itemname); cmd.Parameters.Add("@price", MRP); cmd.Parameters.Add("@billingprice", BILLINGPRICE); cmd.Parameters.Add("@uim", UOM); cmd.Parameters.Add("@gsttaxcategory", GST); cmd.Parameters.Add("@igst", IGST); cmd.Parameters.Add("@cgst", CGST); cmd.Parameters.Add("@sgst", SGST); cmd.Parameters.Add("@status", "Active"); vdm.insert(cmd); cmd = new SqlCommand("select MAX(productid) as productid from productmaster"); DataTable dtproduct = vdm.SelectQuery(cmd).Tables[0]; string productid = dtproduct.Rows[0]["productid"].ToString(); cmd = new SqlCommand("insert into productmoniter( productid, qty, price, branchid, minstock, maxsstock) values (@productid, @mqty, @mprice,@mbranchid,@minstock,@maxstock)"); cmd.Parameters.Add("@productid", productid); cmd.Parameters.Add("@mqty", "0"); cmd.Parameters.Add("@mprice", MRP); cmd.Parameters.Add("@mbranchid", "1"); cmd.Parameters.Add("@minstock", "1"); cmd.Parameters.Add("@maxstock", "100"); vdm.insert(cmd); cmd = new SqlCommand("insert into productmoniter( productid, qty, price, branchid, minstock, maxsstock) values (@productid, @mqty, @mprice,@mbranchid,@minstock,@maxstock)"); cmd.Parameters.Add("@productid", productid); cmd.Parameters.Add("@mqty", "0"); cmd.Parameters.Add("@mprice", MRP); cmd.Parameters.Add("@mbranchid", "2"); cmd.Parameters.Add("@minstock", "1"); cmd.Parameters.Add("@maxstock", "100"); vdm.insert(cmd); cmd = new SqlCommand("insert into productmoniter( productid, qty, price, branchid, minstock, maxsstock) values (@productid, @mqty, @mprice,@mbranchid,@minstock,@maxstock)"); cmd.Parameters.Add("@productid", productid); cmd.Parameters.Add("@mqty", "0"); cmd.Parameters.Add("@mprice", MRP); cmd.Parameters.Add("@mbranchid", "3"); cmd.Parameters.Add("@minstock", "1"); cmd.Parameters.Add("@maxstock", "100"); vdm.insert(cmd); cmd = new SqlCommand("insert into productmoniter( productid, qty, price, branchid, minstock, maxsstock) values (@productid, @mqty, @mprice,@mbranchid,@minstock,@maxstock)"); cmd.Parameters.Add("@productid", productid); cmd.Parameters.Add("@mqty", "0"); cmd.Parameters.Add("@mprice", MRP); cmd.Parameters.Add("@mbranchid", "4"); cmd.Parameters.Add("@minstock", "1"); cmd.Parameters.Add("@maxstock", "100"); vdm.insert(cmd); i++; } grdmiss.DataSource = dtmiss; grdmiss.DataBind(); Session["xportdata"] = dtmiss; Session["filename"] = "Branch Transfer report"; } catch { } lblmsg.Text = "Records inserted successfully"; }