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