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