public int InsertPurchaseOrder(EntityIssueMaterial entInvoice, List <EntityIssueMaterialDetails> lstInvoice)
{
try
{
int?PO_ID = 0;
objData.STP_InsertIssueMaterial(Convert.ToDateTime(entInvoice.IssueDate), ref PO_ID, Convert.ToInt32(entInvoice.PatientId), Convert.ToDecimal(entInvoice.TotalAmount), Convert.ToInt32(entInvoice.EmpId));
foreach (EntityIssueMaterialDetails entPurchaseDetails in lstInvoice)
{
tblIssueDetail obj = new tblIssueDetail()
{
IssueId = PO_ID,
ProductId = Convert.ToInt32(entPurchaseDetails.ProductId),
Quantity = entPurchaseDetails.Quantity,
Rate = entPurchaseDetails.Rate,
Total = Convert.ToDecimal(entPurchaseDetails.Total),
IsDelete = false,
BatchNo = entPurchaseDetails.BatchNo,
ExpiryDate = entPurchaseDetails.ExpiryDate
};
objData.tblIssueDetails.InsertOnSubmit(obj);
tblStockDetail stock = new tblStockDetail()
{
ProductId = Convert.ToInt32(entPurchaseDetails.ProductId),
OpeningQty = 0,
InwardQty = 0,
InwardPrice = 0,
InwardAmount = 0,
BatchNo = entPurchaseDetails.BatchNo,
ExpiryDate = entPurchaseDetails.ExpiryDate,
OutwardQty = entPurchaseDetails.Quantity,
OutwardPrice = entPurchaseDetails.Rate,
OutwardAmount = entPurchaseDetails.Total,
TransactionType = "Issue",
DocumentNo = PO_ID,
};
objData.tblStockDetails.InsertOnSubmit(stock);
}
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public int UpdateMaterialIssueDetails(EntityIssueMaterial lstEdited, List <EntityIssueMaterialDetails> lstUpdate)
{
try
{
tblIssueMaster objTest = (from tbl in objData.tblIssueMasters
where tbl.IsDelete == false &&
tbl.IssueId == lstEdited.IssueId
select tbl).FirstOrDefault();
if (objTest != null)
{
objTest.IssueId = Convert.ToInt32(lstEdited.IssueId);
objTest.TotalAmount = lstEdited.TotalAmount;
objTest.PatientId = lstEdited.PatientId;
objTest.EmpId = lstEdited.EmpId;
objTest.IssueDate = lstEdited.IssueDate;
}
foreach (EntityIssueMaterialDetails item in lstUpdate)
{
if (item.SR_No == 0)
{
tblIssueDetail objNewAdded = new tblIssueDetail()
{
IssueId = Convert.ToInt32(lstEdited.IssueId),
ProductId = Convert.ToInt32(item.ProductId),
Quantity = item.Quantity,
Rate = item.Rate,
Total = Convert.ToDecimal(item.Total),
IsDelete = false,
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
};
objData.tblIssueDetails.InsertOnSubmit(objNewAdded);
tblStockDetail stock = new tblStockDetail()
{
ProductId = Convert.ToInt32(item.ProductId),
OpeningQty = 0,
InwardQty = 0,
InwardPrice = 0,
InwardAmount = 0,
BatchNo = item.BatchNo,
ExpiryDate = item.ExpiryDate,
OutwardQty = item.Quantity,
OutwardPrice = item.Rate,
OutwardAmount = item.Total,
TransactionType = "Issue",
IsDelete = false,
};
objData.tblStockDetails.InsertOnSubmit(stock);
}
else
{
tblIssueDetail cnt = (from tbl in objData.tblIssueDetails
where tbl.IsDelete == false &&
tbl.SR_No == item.SR_No
select tbl).FirstOrDefault();
if (cnt != null)
{
cnt.IssueId = Convert.ToInt32(item.IssueId);
cnt.BatchNo = item.BatchNo;
cnt.ExpiryDate = item.ExpiryDate;
cnt.ProductId = Convert.ToInt32(item.ProductId);
cnt.Quantity = item.Quantity;
cnt.Rate = item.Rate;
cnt.Total = Convert.ToDecimal(item.Total);
cnt.IsDelete = item.IsDelete;
}
tblStockDetail stock = (from tbl in objData.tblStockDetails
where tbl.IsDelete == false &&
tbl.DocumentNo == lstEdited.IssueId &&
tbl.ProductId == item.ProductId &&
tbl.TransactionType.Equals("Issue")
select tbl).FirstOrDefault();
if (stock != null)
{
stock.ProductId = Convert.ToInt32(item.ProductId);
stock.OpeningQty = 0;
stock.InwardQty = 0;
stock.InwardPrice = 0;
stock.InwardAmount = 0;
stock.BatchNo = item.BatchNo;
stock.ExpiryDate = item.ExpiryDate;
stock.OutwardQty = item.Quantity;
stock.OutwardPrice = item.Rate;
stock.OutwardAmount = item.Total;
stock.IsDelete = item.IsDelete;
}
}
}
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
