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 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 CommonOutput addeditbillingprod(billingprodedit data) { CommonOutput output = new CommonOutput(); try { DashbordDL obj = new DashbordDL(); output = obj.addeditbillingprod(data); } catch (Exception ex) { } return(output); }
public dynamic addeditbillingprod(billingprodedit data) { if (Session["UserName"] != null) { CommonOutput output = new CommonOutput(); DashboardBL obj = new DashboardBL(); output = obj.addeditbillingprod(data); return(Json(output, JsonRequestBehavior.AllowGet)); } else { return(RedirectToAction("Login", "Login")); } }