public long AddNewRequisitionDate(string _ScheduleID, string _RequiredDate)
{
try
{
using (_context)
{
PRD_YearMonthFinishReqDate obj = new PRD_YearMonthFinishReqDate();
obj.ScheduleID = Convert.ToInt64(_ScheduleID);
obj.RequiredDate = DalCommon.SetDate(_RequiredDate);
//Random r = new Random();
//obj.RequisitionNo = r.Next().ToString();
obj.RequisitionNo = DalCommon.GetPreDefineNextCodeByUrl("WBRequisitionForCrusting/WBRequisitionForCrusting");
obj.RecordStatus = "NCF";
_context.PRD_YearMonthFinishReqDate.Add(obj);
_context.SaveChanges();
return(obj.RequisitionDateID);
}
}
catch
{
return(0);
}
}
private LCM_PackingList ModelConversionPackingList(PackingListVM model, int userId, string url)
{
var entity = model.Plid == 0 ? new LCM_PackingList() : (from b in _context.LCM_PackingList.AsEnumerable()
where b.PLID == model.Plid
select b).FirstOrDefault();
entity.PLID = model.Plid;
entity.PLNo = model.Plid == 0 ? DalCommon.GetPreDefineNextCodeByUrl(url) : model.PlNo;
entity.PLDate = DalCommon.SetDate(model.PlDate);
entity.LCID = model.Lcid;
entity.LCNo = model.LcNo;
entity.CIID = model.Ciid;
entity.CINo = model.CiNo;
entity.PLNetWeight = model.NetWeight;
entity.NetWeightUnit = model.NetWeightUnit;
entity.PLGrossWeight = model.GrossWeight;
entity.GrossWeightUnit = model.GrossWeightUnit;
entity.PLNote = model.PlNote;
entity.RecordStatus = model.Plid == 0 ? "NCF" : model.RecordStatus;
entity.SetOn = model.Plid == 0 ? DateTime.Now : _unit.PackingListRepository.GetByID(model.Plid).SetOn;
entity.SetBy = model.Plid == 0 ? userId : _unit.PackingListRepository.GetByID(model.Plid).SetBy;
entity.ModifiedBy = model.Plid == 0 ? (int?)null : userId;
entity.ModifiedOn = model.Plid == 0 ? (DateTime?)null : DateTime.Now;
return(entity);
}
public ValidationMsg Save(EXPBankDebitVoucher model, int userid, string pageUrl)
{
_vmMsg = new ValidationMsg();
try
{
#region Save
using (var tx = new TransactionScope())
{
using (_context)
{
model.BDVNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);//DalCommon.GetPreDefineValue("1", "00045");
if (model.BDVNo != null)
{
EXP_BankDebitVoucher tblEXPCI = SetToModelObject(model, userid);
_context.EXP_BankDebitVoucher.Add(tblEXPCI);
_context.SaveChanges();
tx.Complete();
BDVID = tblEXPCI.BDVID;
BDVNo = model.BDVNo;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "BDVNo Predefine Value not Found.";
}
}
}
#endregion
}
catch (Exception ex)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to save.";
if (ex.InnerException.InnerException.Message.Contains("UNIQUE KEY"))
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Schedule Year,Month Combination Data Already Exit.";
}
}
return(_vmMsg);
}
private PRQ_ChemLocalPurcBill BillConversion(PrqChemLocalPurcBill model, int userId, string url)
{
var entity = model.BillId == 0
? new PRQ_ChemLocalPurcBill()
: (from b in _context.PRQ_ChemLocalPurcBill.AsEnumerable()
where b.BillID == model.BillId
select b).FirstOrDefault();
entity.BillID = model.BillId;
entity.BillNo = model.BillId == 0 ? DalCommon.GetPreDefineNextCodeByUrl(url) : model.BillNo;
entity.BillDate = DalCommon.SetDate(model.BillDate);
entity.PurchaseYear = model.PurchaseYear;
entity.SupplierID = model.SupplierId;
entity.SupplierAddressID = model.SupplierAddressId;
entity.SupplierBillNo = model.SupplierBillNo;
entity.SupBillDate = DalCommon.SetDate(model.SupBillDate);
entity.BillCategory = "Real";
entity.BillType = "Supplier";
entity.Currency = model.Currency;
entity.ExchangRate = model.ExchangRate;
entity.ExchangCurrency = model.ExchangCurrency;
entity.ExchangValue = model.ExchangValue;
entity.BillAmt = model.BillAmt;
entity.VatAmt = model.VatAmt;
entity.DiscountPercent = model.DiscountPercent;
entity.DiscountAmt = model.DiscountAmt;
entity.PayableAmt = model.PayableAmt;
entity.RecordStatus = model.BillId == 0 ? "NCF" : model.RecordStatus;
entity.SetBy = model.BillId == 0
? userId
: _unit.ChemicalLocalPurchaseBillRepository.GetByID(model.BillId).SetBy;
entity.SetOn = model.BillId == 0
? DateTime.Now
: _unit.ChemicalLocalPurchaseBillRepository.GetByID(model.BillId).SetOn;
entity.ModifiedBy = model.BillId == 0 ? (int?)null : userId;
entity.ModifiedOn = model.BillId == 0 ? (DateTime?)null : DateTime.Now;
return(entity);
}
private SLS_BuyerOrder ConvertOrder(SlsBuyerOrder model, int userId, string url)
{
var entity = model.BuyerOrderID == 0 ? new SLS_BuyerOrder() : (from b in _context.SLS_BuyerOrder.AsEnumerable()
where b.BuyerOrderID == model.BuyerOrderID
select b).FirstOrDefault();
entity.BuyerOrderID = model.BuyerOrderID;
entity.BuyerOrderNo = model.BuyerOrderNo ?? DalCommon.GetPreDefineNextCodeByUrl(url);
entity.OrderNo = model.OrderNo;
entity.BuyerOrderDate = model.BuyerOrderDate == null ? DateTime.Now : DalCommon.SetDate(model.BuyerOrderDate);
entity.OrderFrom = model.OrderFrom;
entity.BuyerOrderCategory = model.BuyerOrderCategory;
entity.BuyerID = model.BuyerID;
entity.BuyerAddressID = model.BuyerAddressID;
entity.BuyerLocalAgentID = model.BuyerLocalAgentID;
entity.BuyerForeignAgentID = model.BuyerForeignAgentID;
entity.BuyerRef = model.BuyerRef;
entity.ExpectedShipmentDate = model.ExpectedShipmentDate == null ? DateTime.Now : DalCommon.SetDate(model.ExpectedShipmentDate);
entity.RevisionNo = model.RevisionNo;
entity.RevisionDate = DalCommon.SetDate(model.RevisionDate);
entity.OrderCurrency = model.OrderCurrency;
entity.BuyerOrderStatus = model.BuyerOrderStatus == null ? "OD" : DalCommon.ReverseOrderStatus(model.BuyerOrderStatus);
entity.RecordStatus = model.BuyerOrderID == 0
? "NCF"
: _unit.SlsBuyerOrederRepository.GetByID(model.BuyerOrderID).RecordStatus;
entity.SetOn = model.BuyerOrderID == 0
? DateTime.Now
: _unit.SlsBuyerOrederRepository.GetByID(model.BuyerOrderID).SetOn;
entity.SetBy = model.BuyerOrderID == 0
? userId
: _unit.SlsBuyerOrederRepository.GetByID(model.BuyerOrderID).SetBy;
entity.ModifiedBy = model.BuyerOrderID == 0 ? (int?)null : userId;
entity.ModifiedOn = model.BuyerOrderID == 0 ? (DateTime?)null : DateTime.Now;
entity.OrderCurrency = model.OrderCurrency;
entity.TotalFootQty = model.TotalFootQty;
entity.TotalMeterQty = model.TotalMeterQty;
entity.PriceLevel = model.PriceLevel;
return(entity);
}
public ValidationMsg Save(EXPAgentCommission model, int userid, string pageUrl)
{
_vmMsg = new ValidationMsg();
try
{
#region Save
using (var tx = new TransactionScope())
{
using (_context)
{
model.AgentComNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);//DalCommon.GetPreDefineValue("1", "00045");
if (model.AgentComNo != null)
{
#region AgentCommission
EXP_AgentCommission tblEXPAgentCommission = SetToModelObject(model, userid);
_context.EXP_AgentCommission.Add(tblEXPAgentCommission);
_context.SaveChanges();
#endregion
#region CIPIItemColor
if (model.EXPAgentCommissionBuyerCIList != null)
{
foreach (EXPAgentCommissionBuyerCI objEXPAgentCommissionBuyerCI in model.EXPAgentCommissionBuyerCIList)
{
objEXPAgentCommissionBuyerCI.AgentComID = tblEXPAgentCommission.AgentComID;
objEXPAgentCommissionBuyerCI.LocalCurrency = model.LocalCurrency;
EXP_AgentCommissionBuyerCI tblEXPAgentCommissionBuyerCI = SetToModelObject(objEXPAgentCommissionBuyerCI, userid);
_context.EXP_AgentCommissionBuyerCI.Add(tblEXPAgentCommissionBuyerCI);
}
}
#endregion
_context.SaveChanges();
tx.Complete();
AgentComID = tblEXPAgentCommission.AgentComID;
AgentComNo = model.AgentComNo;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "AgentComNo Predefine Value not Found.";
}
}
}
#endregion
}
catch (Exception ex)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to save.";
if (ex.InnerException.InnerException.Message.Contains("UK_EXP_AgentCommission_AgentComNo"))
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Agent Com. No Already Exist.";
}
if (ex.InnerException.InnerException.Message.Contains("UK_EXP_AgentCommissionBuyerCI_BuyerAgentID_CIID"))
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Same Agent Already Exist.";
}
}
return(_vmMsg);
}
public ValidationMsg SaveLCM_LCRetirement(EXP_LCRetirement dataSet, int _userId, string url)
{
try
{
EXP_LCRetirement obLCRetirement = new EXP_LCRetirement();
obLCRetirement.LCRetirementID = dataSet.LCRetirementID;
obLCRetirement.LCRetirementNo = DalCommon.GetPreDefineNextCodeByUrl(url);
obLCRetirement.LCRetirementDate = dataSet.LCRetirementDate;
obLCRetirement.LCNo = dataSet.LCNo;
obLCRetirement.LCID = dataSet.LCID;
//obLCRetirement.BillValue = (decimal)dataSet.BillValue;
//EXP_CIPI ExchangeValueInvoice = repository.EXPCommercialInvoicePIRepository.Get(filter: dat => dat.LCID == dataSet.LCID).FirstOrDefault();
//EXP_CIPI ExchangeRateInvoice = repository.EXPCommercialInvoicePIRepository.Get(filter: dat => dat.LCID == dataSet.LCID).FirstOrDefault();
obLCRetirement.BillValue = dataSet.BillValue;//(ExchangeValueInvoice.ExchangeValue / ExchangeRateInvoice.ExchangeRate) == null ? 0 : (decimal)(ExchangeValueInvoice.ExchangeValue / ExchangeRateInvoice.ExchangeRate);
//obLcLimInfo.OtherCharges = dataSet.OtherCharges == null ? 0 : (decimal)dataSet.OtherCharges;
obLCRetirement.InterestPersent = dataSet.InterestPersent == null ? 0 : (decimal)dataSet.InterestPersent;
obLCRetirement.InterestAmount = dataSet.InterestAmount == null ? 0 : (decimal)dataSet.InterestAmount;
obLCRetirement.BankCommissionAmt = dataSet.BankCommissionAmt == null ? 0 : (decimal)dataSet.BankCommissionAmt;
obLCRetirement.OtherCharge = dataSet.OtherCharge == null ? 0 : (decimal)dataSet.OtherCharge;
obLCRetirement.SwiftCharge = dataSet.SwiftCharge == null ? 0 : (decimal)dataSet.SwiftCharge;
obLCRetirement.TotalAmount = dataSet.TotalAmount == null ? 0 : (decimal)dataSet.TotalAmount;
obLCRetirement.LCRCurrency = (byte)dataSet.LCRCurrency;
obLCRetirement.Remarks = dataSet.Remarks == null ? "" : dataSet.Remarks;
obLCRetirement.ExchangeCurrency = (byte)(dataSet.ExchangeCurrency);
//obLCRetirement.ExchangeRate = (decimal)dataSet.ExchangeRate == null ? 0 : (decimal)dataSet.ExchangeRate;
if (obLCRetirement.ExchangeRate == null)
{
dataSet.ExchangeRate = 0;
}
else
{
obLCRetirement.ExchangeRate = (decimal)dataSet.ExchangeRate;
}
obLCRetirement.ExchangeValue = (decimal)dataSet.ExchangeValue == null ? 0 : (decimal)dataSet.ExchangeValue;
obLCRetirement.RecordStatus = "NCF";
obLCRetirement.SetOn = DateTime.Now;
obLCRetirement.SetBy = _userId;
obLCRetirement.IPAddress = GetIPAddress.LocalIPAddress();
obEntity.EXP_LCRetirement.Add(obLCRetirement);
int flag = obEntity.SaveChanges();
if (flag == 1)
{
_vmMsg.ReturnId = repository.LcmRetirementRpository.Get().Last().LCRetirementID;
_vmMsg.ReturnCode = dataSet.LCRetirementNo;//repository.LcmRetirementRpository.GetByID(_vmMsg.ReturnId).LCRetirementNo;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Saved Faild.";
}
}
catch (DbEntityValidationException e)
{
StringBuilder sb = new StringBuilder();
foreach (var eve in e.EntityValidationErrors)
{
sb.AppendLine(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name,
eve.Entry.State));
foreach (var ve in eve.ValidationErrors)
{
sb.AppendLine(string.Format("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName,
ve.ErrorMessage));
}
}
throw new DbEntityValidationException(sb.ToString(), e);
}
return(_vmMsg);
}
public int Save(PRDChemProdReq model, int userId, string pageUrl)
{
int CurrentRequisitionID = 0;
try
{
using (TransactionScope transaction = new TransactionScope())
{
using (_context)
{
var GetRequisitionNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
if (GetRequisitionNo != null)
{
#region New_Requisition_Insert
PRD_ChemProdReq objRequisition = new PRD_ChemProdReq();
objRequisition.RequisitionNo = GetRequisitionNo;
objRequisition.RequisitionCategory = model.RequisitionCategory;
objRequisition.RequisitionType = model.RequisitionType;
objRequisition.RequisitionFrom = model.RequisitionFrom;
objRequisition.RequisitionTo = model.RequisitionTo;
objRequisition.RequiredByTime = model.RequiredByTime;
objRequisition.ReqRaisedBy = userId;
objRequisition.ReqRaisedOn = DalCommon.SetDate((model.ReqRaisedOn).ToString());
if (model.RecipeFor == 0)
{
objRequisition.RecipeFor = null;
}
else
{
objRequisition.RecipeFor = model.RecipeFor;
}
if (model.RecipeID == 0)
{
objRequisition.RecipeID = null;
}
else
{
objRequisition.RecipeID = model.RecipeID;
}
objRequisition.ArticleNo = model.ArticleNo;
objRequisition.Thickness = model.Thickness;
if (model.ThicknessUnit != null)
{
objRequisition.ThicknessUnit = model.ThicknessUnit;
}
objRequisition.LeatherSize = model.LeatherSize;
if (model.SizeUnit != null)
{
objRequisition.SizeUnit = model.SizeUnit;
}
objRequisition.Selection = model.Selection;
objRequisition.ProductionQty = model.ProductionQty;
objRequisition.RequisitionState = "RNG";
objRequisition.RequisitionStatus = "PND";
objRequisition.RecordStatus = "NCF";
objRequisition.SetBy = userId;
objRequisition.SetOn = DateTime.Now;
//if (model.BuyerAddressID == 0)
// objPI.BeneficiaryAddressID = null;
//else
// objPI.BeneficiaryAddressID = model.BuyerAddressID;
_context.PRD_ChemProdReq.Add(objRequisition);
_context.SaveChanges();
CurrentRequisitionID = objRequisition.RequisitionID;
#endregion
#region Item Insert
if (model.RequisitionItemList != null)
{
foreach (var item in model.RequisitionItemList)
{
PRD_ChemProdReqItem objItem = new PRD_ChemProdReqItem();
objItem.RequisitionID = CurrentRequisitionID;
objItem.ItemID = Convert.ToInt32(item.ItemID);
if (item.SupplierID == 0)
{
objItem.SupplierID = null;
}
else
{
objItem.SupplierID = item.SupplierID;
}
//objItem.SupplierID = item.SupplierID;
objItem.RequiredQty = item.RequiredQty;
if (item.RequiredUnitName == null)
{
objItem.RequiredUnit = null;
}
else
{
objItem.RequiredUnit = DalCommon.GetUnitCode(item.RequiredUnitName);
}
objItem.RequsitionQty = Convert.ToDecimal(item.RequsitionQty);
objItem.RequisitionUnit = DalCommon.GetUnitCode(item.RequisitionUnitName);
if (item.PackSizeName == null)
{
objItem.PackSize = null;
}
else
{
objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
}
//objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
if (item.SizeUnitName == null)
{
objItem.SizeUnit = null;
}
else
{
objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName);
}
//objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName);
objItem.PackQty = item.PackQty;
objItem.ApproveQty = item.ApproveQty;
objItem.ApproveUnit = DalCommon.GetUnitCode(item.ApproveUnitName);
//objItem.ManufacturerID = item.ManufacturerID;
objItem.ItemSource = DalCommon.ReturnItemSource(item.ItemSource);
objItem.SetOn = DateTime.Now;
objItem.SetBy = userId;
_context.PRD_ChemProdReqItem.Add(objItem);
_context.SaveChanges();
}
}
#endregion
}
}
transaction.Complete();
}
return(CurrentRequisitionID);
}
catch (Exception e)
{
return(0);
}
}
public long SavePurchaseInformation(PurchaseReceive model, int userId)
{
long CurrentPurchaseID = 0;
try
{
using (TransactionScope transaction = new TransactionScope())
{
#region New_Purchase_Insert
using (_context)
{
Prq_Purchase objPurchase = new Prq_Purchase();
//Random r = new Random();
//objPurchase.PurchaseNo = r.Next().ToString();
objPurchase.PurchaseNo = DalCommon.GetPreDefineNextCodeByUrl("Purchase/Purchase");
objPurchase.SupplierID = Convert.ToInt16(model.SupplierID);
objPurchase.SupplierAddressID = Convert.ToInt16(model.SupplierAddressID);
objPurchase.PurchaseCategory = model.PurchaseCategory;
objPurchase.PurchaseType = model.PurchaseType;
objPurchase.PurchaseYear = model.PurchaseYear;
objPurchase.PurchaseDate = DalCommon.SetDate(model.PurchaseDate);
objPurchase.PurchaseNote = model.PurchaseNote;
objPurchase.RecordStatus = "NCF";
objPurchase.SetOn = DateTime.Now;
objPurchase.SetBy = userId;
_context.Prq_Purchase.Add(objPurchase);
_context.SaveChanges();
CurrentPurchaseID = objPurchase.PurchaseID;
if (model.ChallanList != null)
{
Prq_PurchaseChallan objChallan = new Prq_PurchaseChallan();
objChallan.ChallanNo = model.ChallanList.FirstOrDefault().ChallanNo;
objChallan.PurchaseID = CurrentPurchaseID;
objChallan.SourceID = model.ChallanList.FirstOrDefault().SourceID;
objChallan.LocationID = model.ChallanList.FirstOrDefault().LocationID;
objChallan.ReceiveStore = DalCommon.GetStoreCode(model.ChallanList.FirstOrDefault().ReceiveStore);
objChallan.ChallanCategory = model.ChallanList.FirstOrDefault().ChallanCategory;
objChallan.ChallanNote = model.ChallanList.FirstOrDefault().ChallanNote;
objChallan.ChallanDate = Convert.ToDateTime(model.ChallanList.FirstOrDefault().ChallanDate);
objChallan.RecordStatus = "NCF";
objChallan.SetOn = DateTime.Now;
objChallan.SetBy = userId;
_context.Prq_PurchaseChallan.Add(objChallan);
_context.SaveChanges();
var CurrentChallanNo = objChallan.ChallanID;
if (model.ChallanItemList != null)
{
foreach (var ChallanItem in model.ChallanItemList)
{
Prq_PurchaseChallanItem objPurchaseChallanItem = new Prq_PurchaseChallanItem();
objPurchaseChallanItem.ChallanID = CurrentChallanNo;
objPurchaseChallanItem.ItemCategory = "Leather";
objPurchaseChallanItem.ItemTypeID = DalCommon.GetItemTypeCode(ChallanItem.ItemTypeID);
objPurchaseChallanItem.ItemSizeID = DalCommon.GetSizeCode(ChallanItem.ItemSizeID);
objPurchaseChallanItem.Description = ChallanItem.Description;
objPurchaseChallanItem.UnitID = DalCommon.GetUnitCode(ChallanItem.UnitID);
objPurchaseChallanItem.ChallanQty = ChallanItem.ChallanQty;
objPurchaseChallanItem.ReceiveQty = ChallanItem.ReceiveQty;
objPurchaseChallanItem.Remark = ChallanItem.Remark;
objPurchaseChallanItem.RecordStatus = "NCF";
objPurchaseChallanItem.SetBy = userId;
objPurchaseChallanItem.SetOn = DateTime.Now;
_context.Prq_PurchaseChallanItem.Add(objPurchaseChallanItem);
_context.SaveChanges();
}
}
}
}
#endregion
transaction.Complete();
}
return(CurrentPurchaseID);
}
catch (Exception e)
{
return(CurrentPurchaseID);
}
}
public ValidationMsg SaveProductionRecipe(PrdRecipe recipeModel, int userId, string pageUrl)
{
try
{
using (var tx = new TransactionScope())
{
var currentRecipeId = 0;
var currentCode = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
using (_context)
{
var recipe = new PRD_Recipe
{
RecipeName = recipeModel.RecipeName,
RecipeFor = recipeModel.RecipeFor,
RecipeNo = currentCode,
ArticleID = recipeModel.ArticleID,
ArticleNo = recipeModel.ArticleNo ?? "",
ArticleChallanNo = recipeModel.ArticleChallanNo ?? "",
ArticleName = recipeModel.ArticleName ?? "",
ArticleColor = recipeModel.ArticleColor,
CalculationBase = recipeModel.CalculationBase,
BaseQuantity = recipeModel.BaseQuantity,
BaseUnit = recipeModel.BaseUnit,
RecordStatus = "NCF",
SetOn = DateTime.Now,
SetBy = userId,
IPAddress = GetIPAddress.LocalIPAddress()
};
_context.PRD_Recipe.Add(recipe);
_context.SaveChanges();
currentRecipeId = recipe.RecipeID;
if (recipeModel.RecipeItems != null)
{
foreach (var recipeItem in recipeModel.RecipeItems.Select(item => new PRD_RecipeItem
{
RecipeID = currentRecipeId,
ItemID = item.ItemID,
RequiredQty = item.RequiredQty,
UnitID = item.UnitID,
SetOn = DateTime.Now,
SetBy = userId,
IPAddress = GetIPAddress.LocalIPAddress()
}))
{
_context.PRD_RecipeItem.Add(recipeItem);
_context.SaveChanges();
}
}
}
tx.Complete();
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
_vmMsg.ReturnId = currentRecipeId;
_vmMsg.ReturnCode = currentCode;
}
}
catch (Exception)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to save.";
}
return(_vmMsg);
}
public long Save(ExpBankVoucher model, int userId, string pageUrl)
{
long CurrentBVID = 0;
using (TransactionScope transaction = new TransactionScope())
{
try
{
using (_context)
{
var AutoBVNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
//Random r = new Random();
//var AutoBVNo = r.Next();
if (AutoBVNo != null)
{
#region New_Voucher_Insert
EXP_BankVoucher objVoucher = new EXP_BankVoucher();
objVoucher.BVNo = AutoBVNo.ToString();
objVoucher.RefBVNo = model.RefBVNo;
objVoucher.BVDate = DalCommon.SetDate(model.BVDate);
objVoucher.BVType = model.BVType;
objVoucher.BankID = model.BankID;
objVoucher.BranchID = model.BranchID;
objVoucher.ACName = model.ACName;
objVoucher.ACNo = model.ACNo;
objVoucher.Remarks = model.Remarks;
objVoucher.RecordStatus = "NCF";
objVoucher.SetBy = userId;
objVoucher.SetOn = DateTime.Now;
_context.EXP_BankVoucher.Add(objVoucher);
_context.SaveChanges();
CurrentBVID = objVoucher.BVID;
#endregion
}
#region Item Insert
if (model.EXPBankVoucherDtl != null)
{
foreach (var item in model.EXPBankVoucherDtl)
{
EXP_BankVoucherDtl objItem = new EXP_BankVoucherDtl();
objItem.BVID = CurrentBVID;
objItem.TransSL = item.TransSL;
objItem.Narration = item.Narration;
objItem.TransHead = item.TransHead;
objItem.BVCRAmt = item.BVCRAmt;
objItem.BVDRAmt = item.BVDRAmt;
if (item.CurrencyName != null)
{
objItem.Currency = DalCommon.GetCurrencyID(item.CurrencyName);
}
if (item.ExchangeCurrencyName != null)
{
objItem.ExchangeCurrency = DalCommon.GetCurrencyID(item.ExchangeCurrencyName);
}
objItem.ExchangeRate = item.ExchangeRate;
objItem.ExchangeAmount = item.ExchangeAmount;
objItem.CIID = item.CIID;
objItem.SetOn = DateTime.Now;
objItem.SetBy = userId;
_context.EXP_BankVoucherDtl.Add(objItem);
//_context.SaveChanges();
}
}
#endregion
_context.SaveChanges();
}
transaction.Complete();
}
catch (Exception e)
{
CurrentBVID = 0;
return(CurrentBVID);
}
}
return(CurrentBVID);
}
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);
}
}
private INV_CrustLeatherIssue ConvertIssue(InvCrustLeatherIssue model, int userId, string url)
{
var entity = model.CrustLeatherIssueID == 0 ? new INV_CrustLeatherIssue() : (from b in _context.INV_CrustLeatherIssue.AsEnumerable()
where b.CrustLeatherIssueID == model.CrustLeatherIssueID
select b).FirstOrDefault();
entity.CrustLeatherIssueID = model.CrustLeatherIssueID;
entity.CrustLeatherIssueNo = model.CrustLeatherIssueNo ?? DalCommon.GetPreDefineNextCodeByUrl(url);
entity.CrustLeatherIssueDate = model.CrustLeatherIssueDate == null ? DateTime.Now : DalCommon.SetDate(model.CrustLeatherIssueDate);
entity.IssueCategory = model.IssueCategory;
entity.IssueFor = model.IssueFor;
entity.IssueFrom = model.IssueFrom;
entity.IssueTo = model.IssueTo;
entity.RecordStatus = model.RecordStatus ?? "NCF";
entity.SetOn = model.CrustLeatherIssueID == 0
? DateTime.Now
: _unit.CrustLeatherIssue.GetByID(model.CrustLeatherIssueID).SetOn;
entity.SetBy = model.CrustLeatherIssueID == 0
? userId
: _unit.CrustLeatherIssue.GetByID(model.CrustLeatherIssueID).SetBy;
entity.ModifiedOn = model.CrustLeatherIssueID == 0 ? (DateTime?)null : DateTime.Now;
entity.ModifiedBy = model.CrustLeatherIssueID == 0 ? (int?)null : userId;
#region New Code
//var put = entity.INV_CrustLeatherReceiveItem;
//if (model.Items.Count > 0)
//{
// foreach (var item in model.Items)
// {
// put.CrustLeatherIssueItemID = item.CrustLeatherIssueItemID;
// put.CrustLeatherIssueID = entity.CrustLeatherIssueID;
// put.RequisitionDateID = item.RequisitionDateID ?? null;
// //entity.RequisitionNo = null;
// put.CrustQCLabel = item.CrustQCLabel ?? null;
// put.BuyerID = item.BuyerID;
// put.BuyerOrderID = item.BuyerOrderID;
// put.ArticleID = item.ArticleID;
// put.ArticleNo = item.ArticleNo;
// put.ArticleChallanID = item.ArticleChallanID;
// put.ArticleChallanNo = item.ArticleChallanNo;
// put.ItemTypeID = item.ItemTypeID;
// put.LeatherTypeID = item.LeatherTypeID;
// put.LeatherStatusID = item.LeatherStatusID;
// put.SetOn = item.CrustLeatherIssueItemID == 0
// ? DateTime.Now
// : _unit.CrustLeatherIssueItem.GetByID(item.CrustLeatherIssueItemID).SetOn;
// entity.SetBy = item.CrustLeatherIssueItemID == 0
// ? userId
// : _unit.CrustLeatherIssueItem.GetByID(item.CrustLeatherIssueItemID).SetBy;
// entity.ModifiedOn = item.CrustLeatherIssueItemID == 0 ? (DateTime?)null : DateTime.Now;
// entity.ModifiedBy = item.CrustLeatherIssueItemID == 0 ? (int?)null : userId;
// var col = new INV_CrustLeatherIssueColor();
// if (item.Colors.Count > 0)
// {
// foreach (var color in item.Colors)
// {
// entity.CrustLeatherIssueColorID = model.CrustLeatherIssueColorID;
// entity.CrustLeatherIssueItemID = itemId;
// entity.CrustLeatherIssueID = issueId;
// entity.ArticleColorNo = entity.ArticleColorNo;
// entity.ColorID = model.ColorID;
// entity.GradeID = model.GradeID;
// entity.GradeRange = model.GradeRange;
// entity.CrustQCLabel = model.CrustQCLabel;
// entity.IssuePcs = model.IssuePcs ?? 0;
// entity.IssueSide = model.IssueSide ?? 0;
// entity.IssueArea = model.IssueArea ?? 0;
// entity.SideArea = model.SideArea;
// entity.AreaUnit = model.AreaUnit;
// entity.SetOn = model.CrustLeatherIssueColorID == 0
// ? DateTime.Now
// : _unit.CrustLeatherIssueColor.GetByID(model.CrustLeatherIssueColorID).SetOn;
// entity.SetBy = model.CrustLeatherIssueColorID == 0
// ? userId
// : _unit.CrustLeatherIssueColor.GetByID(model.CrustLeatherIssueColorID).SetBy;
// entity.ModifiedBy = model.CrustLeatherIssueColorID == 0 ? (int?)null : userId;
// entity.ModifiedOn = model.CrustLeatherIssueColorID == 0 ? (DateTime?)null : DateTime.Now;
// return entity;
// }
// }
// }
//}
#endregion
return(entity);
}
public ValidationMsg Save(InvFinishLeatherReceive model, int userid, string pageUrl)
{
_vmMsg = new ValidationMsg();
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
model.FNReceiveNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);//DalCommon.GetPreDefineValue("1", "00045");
if (model.FNReceiveNo != null)
{
#region Save Finish Leather Receive Data
INV_FinishLeatherReceive tblFinishLeatherReceive = SetToModelObject(model, userid);
_context.INV_FinishLeatherReceive.Add(tblFinishLeatherReceive);
_context.SaveChanges();
#endregion
#region Save Finish Leather Receive Item Data
if (model.InvFinishLeatherReceiveItemList != null)
{
foreach (InvFinishLeatherReceiveItem objFinishLeatherReceiveItem in model.InvFinishLeatherReceiveItemList)
{
objFinishLeatherReceiveItem.FNReceiveID = tblFinishLeatherReceive.FNReceiveID;
INV_FinishLeatherReceiveItem tblFinishLeatherReceiveItem = SetToIssueItemModelObject(objFinishLeatherReceiveItem, userid);
_context.INV_FinishLeatherReceiveItem.Add(tblFinishLeatherReceiveItem);
_context.SaveChanges();
#region Save Finish Leather Receive Color Data
if (model.InvFinishLeatherReceiveColorList != null)
{
if (objFinishLeatherReceiveItem.FNReceiveItemID != null)
{
foreach (InvFinishLeatherReceiveColor objFinishLeatherReceiveColor in model.InvFinishLeatherReceiveColorList)
{
objFinishLeatherReceiveColor.FNReceiveID = tblFinishLeatherReceiveItem.FNReceiveID;
objFinishLeatherReceiveColor.FNReceiveItemID = tblFinishLeatherReceiveItem.FNReceiveItemID;
INV_FinishLeatherReceiveColor tblFinishLeatherReceiveColor = SetToReceiveColorModelObject(objFinishLeatherReceiveColor, userid);
_context.INV_FinishLeatherReceiveColor.Add(tblFinishLeatherReceiveColor);
_context.SaveChanges();
}
}
}
#endregion
}
}
#endregion
_context.SaveChanges();
tx.Complete();
//FNReceiveID = tblFinishLeatherReceive.FNReceiveID;
//FNReceiveNo = tblFinishLeatherReceive.FNReceiveNo;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Crust Leather No Predefine Value not Found.";
}
}
}
}
catch (Exception ex)
{
if (ex.InnerException.InnerException.Message.Contains("UNIQUE KEY"))
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Crust Leather No Data Already Exit.";
}
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to save.";
}
return(_vmMsg);
}
public ValidationMsg SaveLCM_CnFBill(CnFBill dataSet, int _userId, string pageUrl)
{
try
{
LCM_CnfBill obLcCnFBill = new LCM_CnfBill();
obLcCnFBill.LCID = dataSet.LCID;
obLcCnFBill.LCNo = dataSet.LCNo == null ? "" : dataSet.LCNo;//DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
obLcCnFBill.CIID = dataSet.CIID;
obLcCnFBill.CINo = dataSet.CINo == null ? "" : dataSet.CINo;
obLcCnFBill.CnfBillID = dataSet.CnfBillID;
//obLcCnFBill.CnfBillNo = dataSet.CnfBillNo==null?"":dataSet.CnfBillNo;
obLcCnFBill.CnfBillNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
obLcCnFBill.RefCnfBillNo = dataSet.RefCnfBillNo == null ? "" : dataSet.RefCnfBillNo;
obLcCnFBill.CnfBillDate = dataSet.CnfBillDate == null ? (DateTime?)null : DalCommon.SetDate(dataSet.CnfBillDate);
obLcCnFBill.CnfBillNote = dataSet.CnfBillNote == null ? "" : (string)dataSet.CnfBillNote;
obLcCnFBill.DutyAccountCharge = dataSet.DutyAccountCharge == null ? 0 : (decimal)dataSet.DutyAccountCharge;
obLcCnFBill.CnfAgentID = dataSet.CnfAgentID == null ? 0 : obEntity.Sys_Buyer.Where(m => m.BuyerID == dataSet.CnfAgentID).FirstOrDefault().BuyerID; //dataSet.CnfAgentID;
obLcCnFBill.PortCharge = dataSet.PortCharge == null ? 0 : (decimal)dataSet.PortCharge;
obLcCnFBill.NOCCharge = dataSet.NOCCharge == null ? 0 : (decimal)dataSet.NOCCharge;
obLcCnFBill.BerthOperatorCharge = dataSet.BerthOperatorCharge == null ? 0 : (decimal)dataSet.BerthOperatorCharge;
obLcCnFBill.AmendmentCharge = dataSet.AmendmentCharge == null ? 0 : (decimal)dataSet.AmendmentCharge;
obLcCnFBill.AgencyCommission = dataSet.AgencyCommission == null ? 0 : (decimal)dataSet.AgencyCommission;
obLcCnFBill.ChemicalTestCharge = dataSet.ChemicalTestCharge == null ? 0 : (decimal)dataSet.ChemicalTestCharge;
obLcCnFBill.ExamineCharge = dataSet.ExamineCharge == null ? 0 : (decimal)dataSet.ExamineCharge;
obLcCnFBill.SpecialDeliveryCharge = dataSet.SpecialDeliveryCharge == null ? 0 : (decimal)dataSet.SpecialDeliveryCharge;
obLcCnFBill.ShippingCharge = dataSet.ShippingCharge == null ? 0 : (decimal)dataSet.ShippingCharge;
obLcCnFBill.StampCharge = dataSet.StampCharge == null ? 0 : (decimal)dataSet.StampCharge;
obLcCnFBill.BLVerifyCharge = dataSet.BLVerifyCharge == null ? 0 : (decimal)dataSet.BLVerifyCharge; //OtherCharge
obLcCnFBill.OtherCharge = dataSet.OtherCharge == null ? 0 : (decimal)dataSet.OtherCharge; //
obLcCnFBill.TotalAmount = dataSet.TotalAmount == null ? 0 : (decimal)dataSet.TotalAmount; //(decimal)dataSet.TotalAmount;
obLcCnFBill.BillOfEntryNo = dataSet.BillOfEntryNo == null ? "" : dataSet.BillOfEntryNo;;
obLcCnFBill.BillOfEntryDate = dataSet.BillOfEntryDate == null ? (DateTime?)null : DalCommon.SetDate(dataSet.BillOfEntryDate);
obLcCnFBill.AssesmentValue = dataSet.AssesmentValue == null ? 0 : (decimal)dataSet.AssesmentValue;//Convert.ToDecimal(dataSet.AssesmentValue)==null? 0 :dataSet.AssesmentValue;
obLcCnFBill.CnfBillCurrency = dataSet.CnfBillCurrency == null ? 0 : dataSet.CnfBillCurrency;
obLcCnFBill.BillOfEntryNo = (string)dataSet.BillOfEntryNo == null ? "" : dataSet.BillOfEntryNo;
obLcCnFBill.ExchangeCurrency = (byte)(dataSet.ExchangeCurrency) == null ? 0 : dataSet.ExchangeCurrency;
obLcCnFBill.ExchangeRate = dataSet.ExchangeRate == null ? 0 : (decimal)dataSet.ExchangeRate;
obLcCnFBill.ExchangeValue = dataSet.ExchangeValue == null ? 0 : (decimal)dataSet.ExchangeValue;
obLcCnFBill.RecordStatus = "NCF";
obLcCnFBill.Remarks = dataSet.Remarks == null ? "" : dataSet.Remarks;
obLcCnFBill.SetOn = DateTime.Now;
obLcCnFBill.SetBy = 1;
obLcCnFBill.ModifiedOn = DateTime.Now;
obLcCnFBill.ModifiedBy = _userId;
obLcCnFBill.IPAddress = GetIPAddress.LocalIPAddress();
obEntity.LCM_CnfBill.Add(obLcCnFBill);
int flag = obEntity.SaveChanges();
if (flag == 1)
{
//_vmMsg.ReturnId = repository.LcmCnFBillRpository.Get().Last().CnfBillID;//dataSet.CnfBillID;
_vmMsg.ReturnCode = obLcCnFBill.CnfBillNo;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Saved Faild.";
}
}
catch (DbEntityValidationException e)
{
StringBuilder sb = new StringBuilder();
foreach (var eve in e.EntityValidationErrors)
{
sb.AppendLine(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name,
eve.Entry.State));
foreach (var ve in eve.ValidationErrors)
{
sb.AppendLine(string.Format("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName,
ve.ErrorMessage));
}
}
throw new DbEntityValidationException(sb.ToString(), e);
}
return(_vmMsg);
}
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);
}
private EXP_FreightBill CovertModel(ExpFreightBill model, int userId, string url)
{
var entity = model.FreightBillID == 0
? new EXP_FreightBill()
: (from b in _context.EXP_FreightBill.AsEnumerable()
where b.FreightBillID == model.FreightBillID
select b).FirstOrDefault();
entity.FreightBillID = model.FreightBillID;
entity.FreightBillNo = model.FreightBillNo ?? DalCommon.GetPreDefineNextCodeByUrl(url);
entity.FreightBillRef = model.FreightBillRef;
entity.FreightBillDate = model.FreightBillDate == null ? (DateTime?)null : DalCommon.SetDate(model.FreightBillDate);
entity.LCID = model.LCID;
entity.CIID = model.CIID;
entity.PIID = model.PIID;
entity.BLID = model.BLID;
entity.FreightAgentID = model.FreightAgentID;
//entity.NotifyTo = model.NotifyTo;
entity.MSNo = model.MSNo;
entity.MSDate = model.MSDate == null ? (DateTime?)null : DalCommon.SetDate(model.MSDate);
entity.ShipmentOf = model.ShipmentOf;
entity.ShipmentFrom = model.ShipmentFrom;
entity.ShipmentTo = model.ShipmentTo;
entity.WBNo = model.WBNo;
entity.WBDate = model.WBDate == null ? (DateTime?)null : DalCommon.SetDate(model.WBDate);
entity.FreightWeight = model.FreightWeight;
entity.FreightRate = model.FreightRate;
entity.FreightValue = model.FreightValue;
entity.FreightBillCurrency = model.FreightBillCurrency;
entity.ExchangeCurrency = model.ExchangeCurrency;
entity.ExchangeRate = model.ExchangeRate;
entity.ExchangeValue = model.ExchangeValue;
//entity.THCharge = model.THCharge;
entity.AirWayBill = model.AirWayBill;
entity.FCSMYCCharge = model.FCSMYCCharge;
entity.SSCMCCCharge = model.SSCMCCCharge;
entity.OtherCharge = model.OtherCharge;
entity.LocalCarringCharge = model.LocalCarringCharge;
entity.CustomCharge = model.CustomCharge;
entity.VATAsReceipt = model.VATAsReceipt;
entity.LoadUnloadCharge = model.LoadUnloadCharge;
//entity.GSPEXpence = model.GSPEXpence;
entity.AgencyCommision = model.AgencyCommision;
entity.SpecialDeliveryCharge = model.SpecialDeliveryCharge;
entity.TotalAmt = model.TotalAmt;
//entity.AdvanceAmt = model.AdvanceAmt;
//entity.NetFreightAmt = model.NetFreightAmt;
entity.TrminalCharge = model.TrminalCharge;
entity.ExamineCharge = model.ExamineCharge;
entity.AmendmentCharge = model.AmendmentCharge;
entity.RecordStatus = model.RecordStatus ?? "NCF";
entity.SetOn = model.FreightBillID == 0
? DateTime.Now
: _unit.FreightBillRepository.GetByID(model.FreightBillID).SetOn;
entity.SetBy = model.FreightBillID == 0
? userId
: _unit.FreightBillRepository.GetByID(model.FreightBillID).SetBy;
entity.ModifiedBy = model.FreightBillID == 0 ? (int?)null : userId;
entity.ModifiedOn = model.FreightBillID == 0 ? (DateTime?)null : DateTime.Now;
return(entity);
}
public ValidationMsg Save(EXPPackingList model, int userid, string pageUrl)
{
_vmMsg = new ValidationMsg();
try
{
#region Save
using (var tx = new TransactionScope())
{
using (_context)
{
model.PLNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);//DalCommon.GetPreDefineValue("1", "00045");
if (model.PLNo != null)
{
#region CI
EXP_PackingList tblEXPPackingList = SetToModelObject(model, userid);
_context.EXP_PackingList.Add(tblEXPPackingList);
_context.SaveChanges();
#endregion
#region CIPI
model.EXPPLPIList[0].PLID = tblEXPPackingList.PLID;
EXP_PLPI tblEXPPLPI = SetToModelObject(model.EXPPLPIList[0], userid);
_context.EXP_PLPI.Add(tblEXPPLPI);
_context.SaveChanges();
#endregion
#region CIPIItem
if (model.EXPPLPIItemColorList != null)
{
foreach (EXPPLPIItemColor objEXPPLPIItemColor in model.EXPPLPIItemColorList)
{
objEXPPLPIItemColor.PLPIID = tblEXPPLPI.PLPIID;
EXP_PLPIItemColor tblEXPCIPIItem = SetToModelObject(objEXPPLPIItemColor, userid);
_context.EXP_PLPIItemColor.Add(tblEXPCIPIItem);
_context.SaveChanges();
#region CIPIItemColor
if (model.EXPPLPIItemColorBaleList != null)
{
if ((objEXPPLPIItemColor.ArticleID == model.EXPPLPIItemColorBaleList[0].ArticleID) && (objEXPPLPIItemColor.ColorID == model.EXPPLPIItemColorBaleList[0].ColorID))
{
foreach (EXPPLPIItemColorBale objEXPCIPIItemColor in model.EXPPLPIItemColorBaleList)
{
objEXPCIPIItemColor.PLPIItemColorID = tblEXPCIPIItem.PLPIItemColorID;
EXP_PLPIItemColorBale tblEXPCIPIItemColor = SetToModelObject(objEXPCIPIItemColor, userid);
_context.EXP_PLPIItemColorBale.Add(tblEXPCIPIItemColor);
}
}
}
#endregion
}
}
#endregion
_context.SaveChanges();
tx.Complete();
PLID = tblEXPPackingList.PLID;
PLNo = model.PLNo;
PLPIID = tblEXPPLPI.PLPIID;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "PLNo Predefine Value not Found.";
}
}
}
//#region CIPIItemColor
//if (model.EXPPLPIItemColorBaleList != null)
//{
// //if ((objEXPPLPIItemColor.ArticleID == model.EXPPLPIItemColorBaleList[0].ArticleID) && (objEXPPLPIItemColor.ColorID == model.EXPPLPIItemColorBaleList[0].ColorID))
// //{
// foreach (EXPPLPIItemColorBale objEXPCIPIItemColor in model.EXPPLPIItemColorBaleList)
// {
// objEXPCIPIItemColor.PLPIItemColorID = 5;// tblEXPCIPIItem.PLPIItemColorID;
// objEXPCIPIItemColor.Remarks = "";// tblEXPCIPIItem.PLPIItemColorID;
// if (string.IsNullOrEmpty(objEXPCIPIItemColor.GradeName))
// objEXPCIPIItemColor.GradeID = null;
// else
// objEXPCIPIItemColor.GradeID = 5;// _context.Sys_Grade.Where(m => m.GradeName == objEXPCIPIItemColor.GradeName).FirstOrDefault().GradeID;
// if (string.IsNullOrEmpty(objEXPCIPIItemColor.GrossBaleWeightUnitName))
// {
// objEXPCIPIItemColor.NetWeightUnit = null;
// objEXPCIPIItemColor.GrossBaleWeightUnit = null;
// }
// else
// {
// objEXPCIPIItemColor.NetWeightUnit = 5;// _context.Sys_Unit.Where(m => m.UnitName == objEXPCIPIItemColor.GrossBaleWeightUnitName).FirstOrDefault().UnitID;
// objEXPCIPIItemColor.GrossBaleWeightUnit = 5;// objEXPCIPIItemColor.NetWeightUnit;// _context.Sys_Unit.Where(m => m.UnitName == objEXPCIPIItemColor.GrossBaleWeightUnitName).FirstOrDefault().UnitID;
// }
// SqlConnection con = new SqlConnection(_connString);
// //SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionDB"].ToString());
// con.Open();
// string query = "UspInsertPLColorBale"; //Stored Procedure name
// //cmd.Connection = conn;
// //cmd.CommandText = "UspConfirmWetBlueIssue";
// SqlCommand com = new SqlCommand(query, con); //creating SqlCommand object
// com.CommandType = CommandType.StoredProcedure; //here we declaring command type as stored Procedure
// com.Parameters.AddWithValue("@PLPIItemColorBaleNo", objEXPCIPIItemColor.PLPIItemColorBaleNo);
// com.Parameters.AddWithValue("@PLPIItemColorID", objEXPCIPIItemColor.PLPIItemColorID);
// com.Parameters.AddWithValue("@GradeID", objEXPCIPIItemColor.GradeID);
// com.Parameters.AddWithValue("@PcsInBale", objEXPCIPIItemColor.PcsInBale);
// com.Parameters.AddWithValue("@SideInBale", objEXPCIPIItemColor.SideInBale);
// com.Parameters.AddWithValue("@FootPLPIBaleQty", objEXPCIPIItemColor.FootPLPIBaleQty);
// com.Parameters.AddWithValue("@MeterPLPIBaleQty", objEXPCIPIItemColor.MeterPLPIBaleQty);
// com.Parameters.AddWithValue("@PLPIBaleNetWeight", objEXPCIPIItemColor.PLPIBaleNetWeight);
// com.Parameters.AddWithValue("@PLPIBGrossaleWeight", objEXPCIPIItemColor.PLPIBGrossaleWeight);
// com.Parameters.AddWithValue("@NetWeightUnit", objEXPCIPIItemColor.NetWeightUnit);
// com.Parameters.AddWithValue("@GrossBaleWeightUnit", objEXPCIPIItemColor.GrossBaleWeightUnit);
// com.Parameters.AddWithValue("@Remarks", objEXPCIPIItemColor.Remarks);
// com.ExecuteNonQuery();
// //EXP_PLPIItemColorBale tblEXPCIPIItemColor = SetToModelObject(objEXPCIPIItemColor, userid);
// //_context.EXP_PLPIItemColorBale.Add(tblEXPCIPIItemColor);
// }
// //}
//}
//#endregion
#endregion
}
catch (Exception ex)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to save.";
if (ex.InnerException.InnerException.Message.Contains("UNIQUE KEY"))
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Packinglist No Already Exit.";
}
}
return(_vmMsg);
}
public ValidationMsg SaveData(PrqChemPurcReq modelReq, int userId, string pageUrl)
{
try
{
using (var tx = new TransactionScope())
{
var currentRequisitionId = 0;
var currentRequisitionCode = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
//var currentRequisitionCode = DalCommon.GetPreDefineValue("1", "00051");
using (_context)
{
var chemPurcReq = new PRQ_ChemPurcReq
{
RequisitionNo = currentRequisitionCode,
RequisitionCategory = modelReq.RequisitionCategory,
RequisitionType = modelReq.RequisitionType,
ReqRaisedOn = DalCommon.SetDate(modelReq.ReqRaisedOn),
RequisitionFrom = modelReq.RequisitionFrom,
RequisitionTo = modelReq.RequisitionTo,
RequiredByTime = modelReq.RequiredByTime,
ReqRaisedBy = modelReq.ReqRaisedBy,
RecordStatus = "NCF",
RequisitionState = "RNG",
SetOn = DateTime.Now,
SetBy = userId,
IPAddress = GetIPAddress.LocalIPAddress()
};
_context.PRQ_ChemPurcReq.Add(chemPurcReq);
_context.SaveChanges();
currentRequisitionId = chemPurcReq.RequisitionID;
if (modelReq.ChemPurcReqItems != null)
{
foreach (var chemItem in modelReq.ChemPurcReqItems.Select(item => new PRQ_ChemPurcReqItem()
{
RequisitionID = currentRequisitionId,
ItemID = item.ItemID,
SupplierID = modelReq.RequisitionTo,
PackSize = item.SizeID,
SizeUnit = item.PackUnitID,
PackQty = item.PackQty,
RequsitionQty = item.RequisitionQty,
RequisitionUnit = item.RequisitionUnit,
ManufacturerID = item.ManufacturerID,
SetOn = DateTime.Now,
SetBy = userId
}))
{
_context.PRQ_ChemPurcReqItem.Add(chemItem);
_context.SaveChanges();
}
}
}
tx.Complete();
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
_vmMsg.ReturnId = currentRequisitionId;
_vmMsg.ReturnCode = currentRequisitionCode;
}
}
catch (Exception)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to save.";
}
return(_vmMsg);
}