public int Update(INVStoreTrans model, int userId)
{
try
{
using (TransactionScope transaction = new TransactionScope())
{
using (_context)
{
#region Transaction_Informaiton_Update
var CurrentTransaction = (from p in _context.INV_StoreTrans
where p.TransactionID == model.TransactionID
select p).FirstOrDefault();
CurrentTransaction.TransactionDate = DalCommon.SetDate(model.TransactionDate);
CurrentTransaction.Remarks = model.Remark;
CurrentTransaction.ModifiedBy = userId;
CurrentTransaction.ModifiedOn = DateTime.Now;
//_context.SaveChanges();
#endregion
#region Update Requisition ItemList
if (model.TransactionItemList != null)
{
foreach (var item in model.TransactionItemList)
{
var checkRequisitionItem = (from i in _context.INV_StoreTransItem
where i.TransItemID == item.TransItemID
select i).Any();
#region New_Item_Insertion
if (!checkRequisitionItem)
{
INV_StoreTransItem objItem = new INV_StoreTransItem();
objItem.TransactionID = model.TransactionID;
objItem.ItemID = item.ItemID;
objItem.SupplierID = item.SupplierID;
objItem.TransactionQty = item.IssueQty;
objItem.TransactionUnit = DalCommon.GetUnitCode(item.IssueUnitName);
objItem.PackSize = DalCommon.GetSizeCode(item.IssuePackSizeName);
objItem.SizeUnit = DalCommon.GetUnitCode(item.IssueSizeUnitName);
objItem.PackQty = item.IssuePackQty;
objItem.SetOn = DateTime.Now;
objItem.SetBy = userId;
_context.INV_StoreTransItem.Add(objItem);
//_context.SaveChanges();
}
#endregion
#region Existing_Item_Update
else
{
var FoundItem = (from i in _context.INV_StoreTransItem
where i.TransItemID == item.TransItemID
select i).FirstOrDefault();
FoundItem.ItemID = item.ItemID;
FoundItem.SupplierID = item.SupplierID;
FoundItem.TransactionQty = item.IssueQty;
FoundItem.TransactionUnit = DalCommon.GetUnitCode(item.IssueUnitName);
FoundItem.PackSize = DalCommon.GetSizeCode(item.IssuePackSizeName);
FoundItem.SizeUnit = DalCommon.GetUnitCode(item.IssueSizeUnitName);
FoundItem.PackQty = item.IssuePackQty;
FoundItem.ModifiedOn = DateTime.Now;
FoundItem.ModifiedBy = userId;
//_context.SaveChanges();
}
#endregion
}
}
#endregion
_context.SaveChanges();
}
transaction.Complete();
}
return(1);
}
catch (Exception e)
{
return(0);
}
}
public int Update(INVStoreTrans model, int userId)
{
try
{
using (TransactionScope transaction = new TransactionScope())
{
using (_context)
{
#region Transaction_Informaiton_Update
var CurrentTransaction = (from p in _context.INV_StoreTrans
where p.TransactionID == model.TransactionID
select p).FirstOrDefault();
if (model.AdjustmentType == "Addition")
{
CurrentTransaction.TransactionCategory = "RCV";
}
else
{
CurrentTransaction.TransactionCategory = "ISU";
}
if (model.PageName == "Adjustment")
{
CurrentTransaction.TransactionType = "ADI";
}
else if (model.PageName == "InventoryAdjustment" & model.AdjustmentType == "Addition")
{
CurrentTransaction.TransactionType = "ADR";
}
else if (model.PageName == "InventoryAdjustment" & model.AdjustmentType == "Subtraction")
{
CurrentTransaction.TransactionType = "ADI";
}
else
{
CurrentTransaction.TransactionType = "ITP";
CurrentTransaction.TransactionTo = model.TransactionTo;
}
CurrentTransaction.Remarks = model.Remark;
CurrentTransaction.TransactionDate = DalCommon.SetDate(model.TransactionDate);
CurrentTransaction.ModifiedBy = userId;
CurrentTransaction.ModifiedOn = DateTime.Now;
//_context.SaveChanges();
#endregion
#region Request Infromation Update
if (model.PageName != "InventoryAdjustment")
{
if (model.PageName == "Adjustment")
{
var CurrentRequest = (from r in _context.INV_StoreTransRequest
where r.TransactionID == model.TransactionID
select r).FirstOrDefault();
CurrentRequest.ReqFromDate = DalCommon.SetDate(model.ReqFromDate);
CurrentRequest.ReqToDate = DalCommon.SetDate(model.ReqToDate);
CurrentRequest.ModifiedBy = userId;
CurrentRequest.ModifiedOn = DateTime.Now;
CurrentRequest.Remark = model.Remark;
}
else
{
var CurrentRequest = (from r in _context.INV_StoreTransRequest
where r.TransactionID == model.TransactionID &&
r.RequisitionID == model.RefTransactionID
select r).FirstOrDefault();
CurrentRequest.Remark = model.Remark;
CurrentRequest.ModifiedBy = userId;
CurrentRequest.ModifiedOn = DateTime.Now;
}
}
#endregion
#region Update Requisition ItemList
if (model.InvStoreTransItemList != null)
{
foreach (var item in model.InvStoreTransItemList)
{
var checkRequisitionItem = (from i in _context.INV_StoreTransItem
where i.TransItemID == item.TransItemID
select i).Any();
#region New_Item_Insertion
if (!checkRequisitionItem)
{
INV_StoreTransItem objItem = new INV_StoreTransItem();
objItem.TransactionID = model.TransactionID;
objItem.ItemID = item.ItemID;
if (item.SupplierID == 0)
{
objItem.SupplierID = null;
}
else
{
objItem.SupplierID = item.SupplierID;
}
objItem.TransactionQty = item.TransactionQty;
objItem.TransactionUnit = DalCommon.GetUnitCode(item.TransactionUnitName);
if (item.PackSizeName != null)
{
objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
}
if (item.SizeUnitName != null)
{
objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName);
}
objItem.PackQty = item.PackQty;
objItem.ItemSource = DalCommon.ReturnItemSource(item.ItemSource);
objItem.SetOn = DateTime.Now;
objItem.SetBy = userId;
_context.INV_StoreTransItem.Add(objItem);
//_context.SaveChanges();
}
#endregion
#region Existing_Item_Update
else
{
var FoundItem = (from i in _context.INV_StoreTransItem
where i.TransItemID == item.TransItemID
select i).FirstOrDefault();
FoundItem.ItemID = item.ItemID;
if (item.SupplierID == 0)
{
FoundItem.SupplierID = null;
}
else
{
FoundItem.SupplierID = item.SupplierID;
}
FoundItem.TransactionQty = item.TransactionQty;
FoundItem.TransactionUnit = DalCommon.GetUnitCode(item.TransactionUnitName);
if (item.PackSizeName != null)
{
FoundItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
}
if (item.SizeUnitName != null)
{
FoundItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName);
}
FoundItem.PackQty = item.PackQty;
FoundItem.ModifiedBy = userId;
FoundItem.ModifiedOn = DateTime.Now;
//_context.SaveChanges();
}
#endregion
}
}
#endregion
_context.SaveChanges();
}
transaction.Complete();
}
return(1);
}
catch (Exception e)
{
return(0);
}
}
public long Save(INVStoreTrans model, int userId, string pageUrl)
{
long CurrentTransactionID = 0;
try
{
using (TransactionScope transaction = new TransactionScope())
{
using (_context)
{
var GetTransactionNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
if (GetTransactionNo != null)
{
#region New_Transaction_Insert
INV_StoreTrans objIssue = new INV_StoreTrans();
objIssue.TransactionNo = GetTransactionNo;
objIssue.TransactionDate = DalCommon.SetDate(model.TransactionDate);
objIssue.TransactionCategory = "ISU";
objIssue.TransactionType = "STI";
objIssue.TransactionFrom = model.IssueFrom;
objIssue.TransactionTo = model.IssueTo;
objIssue.TransactionStatus = "TRI";
objIssue.RecordStatus = "NCF";
objIssue.SetBy = userId;
objIssue.SetOn = DateTime.Now;
_context.INV_StoreTrans.Add(objIssue);
_context.SaveChanges();
CurrentTransactionID = objIssue.TransactionID;
#endregion
#region Item Insert
if (model.TransactionItemList != null)
{
foreach (var item in model.TransactionItemList)
{
INV_StoreTransItem objItem = new INV_StoreTransItem();
objItem.TransactionID = CurrentTransactionID;
objItem.ItemID = item.ItemID;
objItem.SupplierID = item.SupplierID;
objItem.TransactionQty = item.IssueQty;
objItem.TransactionUnit = DalCommon.GetUnitCode(item.IssueUnitName);
objItem.PackSize = DalCommon.GetSizeCode(item.IssuePackSizeName);
objItem.SizeUnit = DalCommon.GetUnitCode(item.IssueSizeUnitName);
objItem.PackQty = item.IssuePackQty;
//objItem.ItemSource = DalCommon.ReturnItemSource(item.ItemSource);
objItem.SetOn = DateTime.Now;
objItem.SetBy = userId;
_context.INV_StoreTransItem.Add(objItem);
//_context.SaveChanges();
}
}
#endregion
}
_context.SaveChanges();
}
transaction.Complete();
}
return(CurrentTransactionID);
}
catch (Exception e)
{
return(0);
}
}
public long Save(INVStoreTrans model, int userId, string pageUrl)
{
long CurrentTransactionID = 0;
long CurrentRequestID = 0;
using (TransactionScope transaction = new TransactionScope())
{
try
{
using (_context)
{
string GetTransactionNo;
if (model.PageName == "Adjustment")
{
GetTransactionNo = DalCommon.GetPreDefineNextCodeByUrl("ChemicalStockAdjustment/ChemicalStockAdjustment");
}
else if (model.PageName == "InventoryAdjustment")
{
//Need Attention
GetTransactionNo = DalCommon.GetPreDefineNextCodeByUrl("ChemicalStockAdjustment/ChemicalStockAdjustment");
}
else
{
GetTransactionNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
}
if (GetTransactionNo != null)
{
#region New_Transaction_Insert
INV_StoreTrans objIssue = new INV_StoreTrans();
objIssue.TransactionNo = GetTransactionNo;
objIssue.TransactionDate = DalCommon.SetDate(model.TransactionDate);
if (model.AdjustmentType == "Addition")
{
objIssue.TransactionCategory = "RCV";
}
else
{
objIssue.TransactionCategory = "ISU";
}
objIssue.TransactionFrom = model.TransactionFrom;
if (model.PageName == "Adjustment")
{
objIssue.TransactionType = "ADI";
}
else if (model.PageName == "InventoryAdjustment" & model.AdjustmentType == "Addition")
{
objIssue.TransactionType = "ADR";
}
else if (model.PageName == "InventoryAdjustment" & model.AdjustmentType == "Subtraction")
{
objIssue.TransactionType = "ADI";
}
else
{
objIssue.TransactionType = "ITP";
objIssue.TransactionTo = model.TransactionTo;
}
objIssue.RecordStatus = "NCF";
objIssue.TransactionState = "RNG";
objIssue.TransactionStatus = "TRI";
objIssue.SetBy = userId;
objIssue.SetOn = DateTime.Now;
_context.INV_StoreTrans.Add(objIssue);
_context.SaveChanges();
CurrentTransactionID = objIssue.TransactionID;
#endregion
#region New Transaction Request Insert
if (model.PageName != "InventoryAdjustment")
{
var objRequest = new INV_StoreTransRequest();
objRequest.TransRequestNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
objRequest.TransactionID = CurrentTransactionID;
if (model.PageName == "Adjustment")
{
objRequest.ReqFromDate = DalCommon.SetDate(model.ReqFromDate);
objRequest.ReqToDate = DalCommon.SetDate(model.ReqToDate);
}
else
{
objRequest.RequisitionID = Convert.ToInt32(model.RefTransactionID);
objRequest.RequestNo = model.RefTransactionNo;
}
objRequest.Remark = model.Remark;
objRequest.SetBy = userId;
objRequest.SetOn = DateTime.Now;
_context.INV_StoreTransRequest.Add(objRequest);
_context.SaveChanges();
CurrentRequestID = objRequest.TransRequestID;
}
#endregion
#region Item Insert
if (model.InvStoreTransItemList != null)
{
foreach (var item in model.InvStoreTransItemList)
{
INV_StoreTransItem objItem = new INV_StoreTransItem();
objItem.TransactionID = CurrentTransactionID;
if (model.PageName != "InventoryAdjustment")
{
objItem.TransRequestID = CurrentRequestID;
}
objItem.ItemID = item.ItemID;
if (item.SupplierID == 0)
{
objItem.SupplierID = null;
}
else
{
objItem.SupplierID = item.SupplierID;
}
objItem.TransactionQty = item.TransactionQty;
objItem.TransactionUnit = DalCommon.GetUnitCode(item.TransactionUnitName);
if (item.PackSizeName != null)
{
objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
}
if (item.SizeUnitName != null)
{
objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName);
}
objItem.PackQty = item.PackQty;
objItem.SetOn = DateTime.Now;
objItem.SetBy = userId;
_context.INV_StoreTransItem.Add(objItem);
//_context.SaveChanges();
}
}
#endregion
}
_context.SaveChanges();
}
transaction.Complete();
}
catch (Exception e)
{
CurrentTransactionID = 0;
return(CurrentTransactionID);
}
}
return(CurrentTransactionID);
}
