public CommonOutput savebp1edit(savebp1model req) { CommonOutput output = new CommonOutput(); try { using (var objDB = new AdityamineralsEntities()) { SqlParameter state = new SqlParameter("@state", req.state); SqlParameter statecode = new SqlParameter("@statecode", req.statecode); SqlParameter date = new SqlParameter("@date", req.date); SqlParameter bpname = new SqlParameter("@bpname", req.bpname); SqlParameter bpaddress = new SqlParameter("@bpaddress", req.bpaddress); SqlParameter bpgstin = new SqlParameter("@bpgstin", req.bpgstin); SqlParameter bpstate = new SqlParameter("@bpstate", req.bpstate); SqlParameter bpstatecode = new SqlParameter("@bpstatecode", req.bpstatecode); SqlParameter spname = new SqlParameter("@spname", req.spname); SqlParameter spaddress = new SqlParameter("@spaddress", req.spaddress); SqlParameter spgstin = new SqlParameter("@spgstin", req.spgstin); SqlParameter spstate = new SqlParameter("@spstate", req.spstate); SqlParameter spstatecode = new SqlParameter("@spstatecode", req.spstatecode); output = objDB.Database.SqlQuery <CommonOutput>("[dbo].[ADM_SAVEBP1EDIT] @state,@statecode,@date,@bpname,@bpaddress,@bpgstin,@bpstate,@bpstatecode,@spname,@spaddress,@spgstin,@spstate,@spstatecode", state, statecode, date, bpname, bpaddress, bpgstin, bpstate, bpstatecode, spname, spaddress, spgstin, spstate, spstatecode).FirstOrDefault(); } } catch (Exception ex) { output.StatusCode = 500; output.Message = ex.Message; } return(output); }
public CommonOutput CheckLogin(logindata data) { CommonOutput co = new CommonOutput(); try { using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { var count = objDB.ADM_M_USER.Where(c => c.UserName == data.UserName && c.Password == data.Password).Count(); if (count > 0) { co.StatusCode = 200; co.Message = "Welcome! " + data.UserName; } else { co.StatusCode = 201; co.Message = "User Not Found OR Wrong Creds"; } } } catch (Exception ex) { co.StatusCode = 500; co.Message = ex.Message; } return(co); }
public CommonOutput savebp2(savebp2model req) { CommonOutput output = new CommonOutput(); try { using (var objDB = new AdityamineralsEntities()) { var proddesc = objDB.ADM_M_BILLINGPRODUCTS.Where(c => c.Sno == req.prodid).FirstOrDefault(); SqlParameter InvoiceNo = new SqlParameter("@InvoiceNo", Convert.ToInt32(req.invoiceno)); SqlParameter ProductionDescription_VC = new SqlParameter("@proddesc", proddesc.ProductDescription); SqlParameter HSNCODE_VC = new SqlParameter("@hsncode", req.hsncode); SqlParameter UOM_VC = new SqlParameter("@uom", req.uom); SqlParameter QTY = new SqlParameter("@qty", req.qty); SqlParameter Rate = new SqlParameter("@rate", req.rate); SqlParameter Amount = new SqlParameter("@amount", req.amount); SqlParameter Discount = new SqlParameter("@discount", req.discount); SqlParameter ValueofSupply = new SqlParameter("@valueofsupply", req.valueofsupply); SqlParameter Sno = new SqlParameter("@prodid", req.prodid); output = objDB.Database.SqlQuery <CommonOutput>("[dbo].[ADM_SAVEBP2] @InvoiceNo,@proddesc,@hsncode,@uom,@qty,@rate,@amount,@discount,@valueofsupply,@prodid", InvoiceNo, ProductionDescription_VC, HSNCODE_VC, UOM_VC, QTY, Rate, Amount, Discount, ValueofSupply, Sno).FirstOrDefault(); } } catch (Exception ex) { output.StatusCode = 500; output.Message = ex.Message; } return(output); }
public CommonOutput addeditbillingprod(billingprodedit data) { CommonOutput output = new CommonOutput(); try { if (data.sno == null || data.sno == 0) { data.sno = -1; } using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { SqlParameter uomid = new SqlParameter("@sno", data.sno); SqlParameter uomname = new SqlParameter("@name", data.productname); SqlParameter uomdesc = new SqlParameter("@uomid", data.uomid); output = objDB.Database.SqlQuery <CommonOutput>("[dbo].[ADM_ADDEDITBILLINGPRODUCTS] @sno,@name,@uomid", uomid, uomname, uomdesc).FirstOrDefault(); } } catch (Exception ex) { output.StatusCode = 500; output.Message = "ERROR"; } return(output); }
public dynamic deleteprod(billingprodedit bp) { if (Session["UserName"] != null) { CommonOutput co = new CommonOutput(); using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { var count = objDB.ADM_L_BILLINGPART2.Where(c => c.Sno == bp.sno).Count(); if (count > 0) { co.Message = "Cannot delete this product-Its already mapped with different billing invoice"; co.StatusCode = 200; } else { SqlParameter invoice = new SqlParameter("@sno", Convert.ToInt32(bp.sno)); co = objDB.Database.SqlQuery <CommonOutput>("[dbo].[ADM_DELPROD] @sno", invoice).FirstOrDefault(); } } return(Json(co, JsonRequestBehavior.AllowGet)); } else { return(RedirectToAction("Login", "Login")); } }
public CommonOutput deletesubbill(string invono, string id) { CommonOutput output = new CommonOutput(); try { if (invono == null) { output.StatusCode = 500; output.Message = "ERROR - CONTACT PAVAN"; return(output); } using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { SqlParameter invoice = new SqlParameter("@invoiceid", Convert.ToInt32(invono)); SqlParameter ida = new SqlParameter("@id", Convert.ToInt32(id)); output = objDB.Database.SqlQuery <CommonOutput>("[dbo].[ADM_DELSUBINVOICE] @invoiceid,@id", invoice, ida).FirstOrDefault(); } } catch (Exception ex) { output.StatusCode = 500; output.Message = ex.Message; } return(output); }
public ActionResult billgenerator() { List <ADM_M_BILLINGPRODUCTS> output1 = new List <ADM_M_BILLINGPRODUCTS>(); if (Session["UserName"] != null) { AdityamineralsEntities dbObj = new AdityamineralsEntities(); var output = dbObj.ADM_L_BILLINGPART1.Count(); if (output == 0) { DashboardBL obj = new DashboardBL(); output1 = obj.getproductslist(); ViewBag.invoiceno = 1; } else { var op = dbObj.ADM_L_BILLINGPART1.Select(c => c.InvoiceNo).DefaultIfEmpty(0).Max(); ViewBag.invoiceno = op + 1; DashboardBL obj = new DashboardBL(); output1 = obj.getproductslist(); } return(View(output1)); } else { return(RedirectToAction("Login", "Login")); } }
public dynamic uomlist() { AdityamineralsEntities objDB = new AdityamineralsEntities(); var list = objDB.ADM_M_UOM.ToList(); var jsonresult = list.Select(x => new { id = x.UOM_ID, text = x.UOMName_VC + "-(" + x.UOMDesc_VC + ")" }); return(Json(jsonresult, JsonRequestBehavior.AllowGet)); }
public ActionResult editbillslist(int invoiceno) { if (Session["UserName"] != null) { List <ADM_L_BILLINGPART2> obj = new List <ADM_L_BILLINGPART2>(); AdityamineralsEntities objDB = new AdityamineralsEntities(); obj = objDB.ADM_L_BILLINGPART2.Where(c => c.InvoiceNo == invoiceno).ToList(); return(PartialView("_productsedit", obj)); } else { return(RedirectToAction("Login", "Login")); } }
public List <ADM_M_BILLINGPRODUCTS> getproductslist() { List <ADM_M_BILLINGPRODUCTS> obj = new List <ADM_M_BILLINGPRODUCTS>(); try { using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { obj = objDB.ADM_M_BILLINGPRODUCTS.ToList(); } } catch (Exception ex) { } return(obj); }
public List <ADM_M_UOM> UOMListdl() { List <ADM_M_UOM> output = new List <ADM_M_UOM>(); try { using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { output = objDB.ADM_M_UOM.ToList(); } } catch (Exception ex) { } return(output); }
public ActionResult billingproducts() { if (Session["UserName"] != null) { List <ADM_M_BILLINGPRODUCTS> output = new List <ADM_M_BILLINGPRODUCTS>(); using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { output = objDB.ADM_M_BILLINGPRODUCTS.ToList(); } return(View(output)); } else { return(RedirectToAction("Login", "Login")); } }
public ActionResult billslist() { if (Session["UserName"] != null) { List <ADM_L_BILLINGPART1> obj = new List <ADM_L_BILLINGPART1>(); using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { obj = objDB.ADM_L_BILLINGPART1.ToList(); } ViewBag.data = obj; return(View()); } else { return(RedirectToAction("Login", "Login")); } }
public billeditmain editbill(int bill) { billeditmain output = new billeditmain(); try { using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { output.BP1 = objDB.ADM_L_BILLINGPART1.Where(c => c.InvoiceNo == bill).FirstOrDefault(); output.BP2 = objDB.ADM_L_BILLINGPART2.Where(c => c.InvoiceNo == bill).ToList(); output.BP3 = objDB.ADM_M_BILLINGPRODUCTS.ToList(); } } catch (Exception ex) { } return(output); }
public dynamic Reportpdf(int Invoiceno) { reportmodel output = new reportmodel(); try { using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { output.bp = objDB.ADM_M_BILLINGPRODUCTS.ToList(); output.bp1 = objDB.ADM_L_BILLINGPART1.Where(c => c.InvoiceNo == Invoiceno).FirstOrDefault(); output.bp2 = objDB.ADM_L_BILLINGPART2.Where(c => c.InvoiceNo == Invoiceno).ToList(); } return(output); } catch (Exception ex) { return(output); } }
public dynamic graph1() { if (Session["UserName"] != null) { using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { var output = objDB.Database.SqlQuery <graph1>("[dbo].[ADM_CHART1]").ToList(); var output1 = objDB.Database.SqlQuery <graph1>("[dbo].[ADM_CHART1]").Count(); op ob = new op(); ob.output = output; ob.output1 = Convert.ToString(output1); return(Json(ob, JsonRequestBehavior.AllowGet)); } } else { return(RedirectToAction("Login", "Login")); } }
public CommonOutput ADDUOM(ADM_M_UOM uomdata) { CommonOutput output = new CommonOutput(); try { using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { SqlParameter uomid = new SqlParameter("@uomid", uomdata.UOM_ID); SqlParameter uomname = new SqlParameter("@uomname", uomdata.UOMName_VC); SqlParameter uomdesc = new SqlParameter("@uomdesc", uomdata.UOMDesc_VC); SqlParameter singleqty = new SqlParameter("@singleqty", uomdata.SINGLEQTY); output = objDB.Database.SqlQuery <CommonOutput>("[dbo].[ADM_ADDEDITUOM] @uomid,@uomname,@uomdesc,@singleqty", uomid, uomname, uomdesc, singleqty).FirstOrDefault(); } } catch (Exception ex) { output.StatusCode = 500; output.Message = "ERROR"; } return(output); }
public ActionResult savebp1(req req) { if (Session["UserName"] != null) { using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { req.uom = objDB.ADM_M_BILLINGPRODUCTS.Where(v => v.Sno == req.prodid).Select(c => c.UOM_Name).FirstOrDefault(); int count = objDB.ADM_L_BILLINGPART2.Where(c => c.InvoiceNo == req.invoiceno && c.Sno == req.prodid).Count(); if (count > 0) { req.bp2 = objDB.ADM_L_BILLINGPART2.Where(c => c.InvoiceNo == req.invoiceno && c.Sno == req.prodid).FirstOrDefault(); return(PartialView("_editbillprod", req)); } else { return(PartialView("_editbillprodA", req)); } } } else { return(RedirectToAction("Login", "Login")); } }