public void InsertTempTrans()
{
try
{
var obj = lstSales;
MemberItemSale temp = new MemberItemSale();
if (obj == null)
{
obj = new List <MemberItemSale>();
}
ItemId = Convert.ToInt64(drpItems.SelectedValue);
//MemberId = Convert.ToInt64(drpMembers.SelectedValue);
//To check whether same item is already sold to this customer
if (lstSales != null && lstSales.Count > 0)
{
if (lstSales.FirstOrDefault(x => x.isDeleted == false && x.itemId == ItemId) == null)
{
temp.itemId = ItemId;
ItemMaster objItem = ProductSalesController.GetItemsById(ItemId);
temp.ItemMaster = objItem;
temp.quantity = Convert.ToInt32(txtQty.Text);
temp.amount = Convert.ToDecimal(txtMRP.Text);
decimal total = 0;
total = temp.quantity * temp.amount;
temp.totalAmount = total;
temp.memberId = MemberId;
obj.Add(temp);
lstSales = obj;
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "err_msg", "MessageBox('Error','This Item is already Sold to this Member')", true);
}
}
else
{
temp.itemId = ItemId;
ItemMaster objItem = ProductSalesController.GetItemsById(ItemId);
temp.ItemMaster = objItem;
temp.quantity = Convert.ToInt32(txtQty.Text);
temp.amount = Convert.ToDecimal(txtMRP.Text);
decimal total = 0;
total = temp.quantity * temp.amount;
temp.totalAmount = total;
temp.memberId = MemberId;
obj.Add(temp);
lstSales = obj;
}
}
catch (Exception ex)
{
throw ex;
}
}
public MemberItemSale InsertProductSale(MemberItemSale objSales)
{
try
{
objSales.insertDate = DateTime.Now;
objSales.isDeleted = false;
using (var context = new FitnessCenterEntities())
{
context.MemberItemSales.AddObject(objSales);
context.SaveChanges();
return(objSales);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertTrans()
{
try
{
decimal totalAmount = 0;
long qty = 0, itemID = 0;
totalAmount = Convert.ToDecimal(ShowTotal());
MemberItemTotalSale objTotalSale = new MemberItemTotalSale();
objTotalSale.totalAmount = totalAmount;
objTotalSale.discount = Convert.ToDecimal(txtDis.Text);
objTotalSale.finalAmount = Convert.ToDecimal(txtFinalAmt.Text);
objTotalSale.memberId = MemberId;
objTotalSale.isPaid = false;
objTotalSale = new ProductSalesController().InsertTotalSales(objTotalSale);
foreach (var obj in lstSales)
{
MemberItemSale objsale = new MemberItemSale();
objsale.memberId = obj.memberId;
objsale.itemId = obj.itemId;
itemID = obj.itemId;
objsale.amount = obj.amount;
qty = obj.quantity;
objsale.quantity = obj.quantity;
objsale.totalAmount = obj.totalAmount;
objsale.memberFinalSaleID = objTotalSale.ID;
new ProductSalesController().InsertProductSale(objsale);
}
ItemMaster objItem = ItemController.GetItemsById(itemID);
//var Inventory = new FitnessCenterEntities().ItemMasters.FirstOrDefault(x => x.isDeleted == false && x.ID == itemID);
objItem.Inventory = objItem.Inventory - qty;
objItem = new ItemController().UpdateItems(objItem);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "err_msg", "MessageBox('Success','Items Sold Successfully')", true);
}
catch (Exception ex)
{
throw ex;
}
}
