public int Insert(PurchaseCylinder obj)
{
PurchaseCylinder newPurchaseMaster = new PurchaseCylinder();
// LiveCylinderDetail livecylinder = new LiveCylinderDetail();
newPurchaseMaster.PurchaseDetail = obj.PurchaseDetail;
newPurchaseMaster.BillNo = obj.BillNo;
newPurchaseMaster.dealerName = obj.dealerName;
newPurchaseMaster.purchaseDate = obj.purchaseDate;
newPurchaseMaster.amount = obj.amount;
context.PurchaseCylinders.Add(newPurchaseMaster);
context.SaveChanges();
if (obj.PurchaseDetail != null)
{
foreach (var i in obj.PurchaseDetail)
{
PurchaseDetail newpurchaseDetail = new PurchaseDetail();
newpurchaseDetail.cylinder_Id = i.cylinder_Id;
newpurchaseDetail.cylinderType = i.cylinderType;
newpurchaseDetail.FilledCylinder = i.FilledCylinder;
var t = context.LiveCylinderDetails.Where(c => c.cylinder_Id == i.cylinder_Id);
var livecylinder = t.First();
if (t != null)
{
livecylinder.FilledCylinderCount = Convert.ToInt32(livecylinder.FilledCylinderCount) + i.FilledCylinder;
context.SaveChanges();
}
//var livecylinder = context.LiveCylinderDetails.Where(c => c.cylinder_Id == i.cylinder_Id).FirstOrDefault();
//if (livecylinder != null)
//{
// livecylinder.FilledCylinderCount= livecylinder.FilledCylinderCount + i.FilledCylinder;
// context.SaveChanges();
//}
//else
//{
// var livecylinderNew = new LiveCylinderDetail();
// livecylinderNew.cylinder_Id = i.cylinder_Id;
// livecylinderNew.CylinderTypeName = i.cylinderType;
// livecylinderNew.FilledCylinderCount = i.FilledCylinder;
// livecylinderNew.EmptyCylinderCount = 0;
// livecylinderNew.ReplacementCylinderCount = 0;
// context.LiveCylinderDetails.Add(livecylinderNew);
// context.SaveChanges();
//}
newpurchaseDetail.purchase_Id = newPurchaseMaster.ID;
context.PurchaseDetails.Add(newpurchaseDetail);
context.SaveChanges();
}
}
return(newPurchaseMaster.ID);
}
public void DeleteDetail(int id)
{
PurchaseDetail newPurchaseCylinder = context.PurchaseDetails.Where(obj => obj.ID == id).FirstOrDefault();
var t = context.LiveCylinderDetails.Where(c => c.cylinder_Id == newPurchaseCylinder.cylinder_Id);
var livecylinder = t.First();
if (t != null)
{
livecylinder.FilledCylinderCount = livecylinder.FilledCylinderCount - newPurchaseCylinder.FilledCylinder;
context.SaveChanges();
}
context.PurchaseDetails.Remove(newPurchaseCylinder);
context.SaveChanges();
}
public void Update(PurchaseCylinder obj)
{
PurchaseCylinder newPurchaseMaster = context.PurchaseCylinders.Where(obj1 => obj1.ID == obj.ID).FirstOrDefault();
PurchaseDetail newpurchaseDetail = new PurchaseDetail();
newPurchaseMaster.dealerName = obj.dealerName;
newPurchaseMaster.BillNo = obj.BillNo;
newPurchaseMaster.purchaseDate = obj.purchaseDate;
newPurchaseMaster.amount = obj.amount;
context.SaveChanges();
if (obj.PurchaseDetailForEdit != null)
{
foreach (var i in obj.PurchaseDetailForEdit)
{
newpurchaseDetail.cylinder_Id = i.cylinder_Id;
newpurchaseDetail.cylinderType = i.cylinderType;
newpurchaseDetail.FilledCylinder = i.FilledCylinder;
var livecylinder = context.LiveCylinderDetails.Where(c => c.cylinder_Id == i.cylinder_Id).FirstOrDefault();
if (livecylinder != null)
{
livecylinder.FilledCylinderCount = livecylinder.FilledCylinderCount + i.FilledCylinder;
context.SaveChanges();
}
else
{
var livecylinderNew = new LiveCylinderDetail();
livecylinderNew.cylinder_Id = i.cylinder_Id;
livecylinderNew.CylinderTypeName = i.cylinderType;
livecylinderNew.FilledCylinderCount = i.FilledCylinder;
livecylinderNew.EmptyCylinderCount = 0;
livecylinderNew.ReplacementCylinderCount = 0;
context.LiveCylinderDetails.Add(livecylinderNew);
context.SaveChanges();
}
newpurchaseDetail.purchase_Id = obj.ID;
context.PurchaseDetails.Add(newpurchaseDetail);
context.SaveChanges();
}
}
}