public ActionResult SaveUpdateBill(Com_Bill_DTO billData)
{
Com_Bill_DTO item = new Com_Bill_DTO();
CustomerMst cust;
if (User.IsInRole("Admin"))
{
cust = _db.CustomerMsts.FirstOrDefault(a => a.pk_Custid == billData.CustomerMst.pk_Custid);
}
else
{
cust = _db.CustomerMsts.FirstOrDefault(a => a.pk_Custid == billData.CustomerMst.pk_Custid && a.Username == User.Identity.Name);
}
billData.CustomerMst = cust;
ProductListForBill productDetail = new ProductListForBill();
productDetail.username = User.Identity.Name;
productDetail.fk_custId = billData.CustomerMst.pk_Custid;
productDetail.Fk_ProductId = billData.Fk_ProductId;
productDetail.productQuantity = billData.prodQuantity;
productDetail.price = billData.price;
_db.ProductListForBills.Add(productDetail);
_db.SaveChanges();
item = GetPageData();
billData.ProductList = item.ProductList;
return(View(billData));
}
public Com_Bill_DTO GetPageData()
{
Com_Bill_DTO comBill = new Com_Bill_DTO();
if (User.IsInRole("Admin"))
{
var prodList = from productList in _db.ProductMsts
select new ProductDDD_DTO
{
productId = productList.pk_ProductId,
ProductName = productList.ProductName
};
comBill.ProductList = prodList.ToList();
}
else
{
var prodList = from productList in _db.ProductMsts
where productList.username == User.Identity.Name
select new ProductDDD_DTO
{
productId = productList.pk_ProductId,
ProductName = productList.ProductName
};
comBill.ProductList = prodList.ToList();
}
return(comBill);
}
public ActionResult SaveUpdateBill(Com_Bill_DTO billData)
{
ProductListForBill productDetail = new ProductListForBill();
productDetail.username = User.Identity.Name;
productDetail.fk_custId = billData.CustomerMst.pk_Custid;
productDetail.Fk_ProductId = billData.Fk_ProductId;
productDetail.productQuantity = billData.prodQuantity;
productDetail.price = billData.price;
_db.ProductListForBills.Add(productDetail);
_db.SaveChanges();
return(View());
}
public ActionResult SaveUpdateBill(int id)
{
Com_Bill_DTO item = new Com_Bill_DTO();
CustomerMst cust;
if (User.IsInRole("Admin"))
{
cust = _db.CustomerMsts.FirstOrDefault(a => a.pk_Custid == id);
}
else
{
cust = _db.CustomerMsts.FirstOrDefault(a => a.pk_Custid == id && a.Username == User.Identity.Name);
}
item = GetPageData();
item.CustomerMst = cust;
return(View(item));
}
public Com_Bill_DTO GetPageData()
{
Com_Bill_DTO comBill = new Com_Bill_DTO();
IEnumerable <ProductListDTO> ProductList;
var products = Session["PRODUCTMSTS"];
//var paymentTypesList = new List<PaymentTypes>();
if (products != null)
{
ProductList = (IEnumerable <ProductListDTO>)products;
}
else
{
ProductList = from a in _db.ProductMsts
join b in _db.ProductTypeMsts on a.fk_prodtypeid equals b.pk_prodtypeid
select new ProductListDTO
{
pk_ProductId = a.pk_ProductId,
ProductName = a.ProductName,
productTypeId = a.fk_prodtypeid,
};
Session["PRODUCTMSTS"] = ProductList;
}
var prodList = from productList in ProductList
select new ProductDDD_DTO
{
productId = productList.pk_ProductId,
ProductName = productList.ProductName,
ProductTypeId = productList.productTypeId
};
comBill.ProductList = prodList.ToList();
var paymentTypes = _db.PaymentTypes;
comBill.PaymentTypes = paymentTypes.ToList();
return(comBill);
}
public Com_Bill_DTO GetPageData()
{
Com_Bill_DTO comBill = new Com_Bill_DTO();
ProductMst pmst;
if (User.IsInRole("Admin"))
{
var prodList = from productList in _db.ProductMsts
select new ProductDDL_DTO
{
productId = productList.pk_ProductId,
ProductName = productList.ProductName
};
comBill.ProductList = prodList.ToList();
}
else if (User.IsInRole("General Store"))
{
var prodList = from productList in _db.ProductMsts.Where(a => a.username == User.Identity.Name)
select new ProductDDL_DTO
{
productId = productList.pk_ProductId,
ProductName = productList.ProductName
};
comBill.ProductList = prodList.ToList();
}
else
{
var prodList = from productList in _db.ProductMsts.Where(a => a.username == User.Identity.Name)
select new ProductDDL_DTO
{
productId = productList.pk_ProductId,
ProductName = productList.ProductName
};
comBill.ProductList = prodList.ToList();
}
return(comBill);
}
