public ValidationMsg Create(SysArticle objSysArticle, int userid)
{
var vmMsg = new ValidationMsg();
try
{
var tblSysArticle = new Sys_Article
{
ArticleID = objSysArticle.ArticleID,
ArticleName = objSysArticle.ArticleName,
ArticleNo = objSysArticle.ArticleNo,
ArticleColor = objSysArticle.ArticleColor,
ArticleChallanNo = objSysArticle.ArticleChallanNo,
IsActive = objSysArticle.IsActive == "Active",
ArticleCategory = objSysArticle.ArticleCategory,
Remarks = objSysArticle.Remarks,
SetOn = DateTime.Now,
SetBy = userid,
IPAddress = GetIPAddress.LocalIPAddress()
};
_context.Sys_Article.Add(tblSysArticle);
_context.SaveChanges();
ArticleId = tblSysArticle.ArticleID;
vmMsg.Type = Enums.MessageType.Success;
vmMsg.Msg = "Saved Successfully.";
}
catch (Exception ex)
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to Save.";
}
return(vmMsg);
}
public EXP_BankDebitVoucher SetToModelObject(EXPBankDebitVoucher model, int userid)
{
EXP_BankDebitVoucher Entity = new EXP_BankDebitVoucher();
Entity.BankID = model.BankID;
//Entity.LCNo = model.LCNo.ToString();
//Entity.LCID = model.LCID;
Entity.BranchID = model.BranchID;
//Entity.LCID = model.LCID;
Entity.BDVNo = model.BDVNo;
Entity.BDVDate = DalCommon.SetDate(model.BDVDate);
Entity.ExchangeCurrency = model.ExchangeCurrency;
Entity.ExchangeRate = model.ExchangeRate;
Entity.ExchangeAmount = model.ExchangeAmount;
Entity.LCMargin = model.LCMargin;
Entity.Remarks = model.Remarks;
Entity.CommissionAmt = model.CommissionAmt;
Entity.PostageAmt = model.PostageAmt;
Entity.SwiftCharge = model.SwiftCharge;
Entity.SourceTaxAmt = model.SourceTaxAmt;
Entity.VatAmt = model.VatAmt;
Entity.StationaryExpense = model.StationaryExpense;
Entity.OtherCost = model.OtherCost;
Entity.TotalAmount = model.TotalAmount;
Entity.RecordStatus = "NCF";
Entity.SetOn = DateTime.Now;
Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
public Sys_Machine SetToModelObject(SysMachine model, int userid)
{
Sys_Machine Entity = new Sys_Machine();
Entity.MachineID = model.MachineID;
Entity.MachineNo = model.MachineNo;
Entity.MachineName = model.MachineName;
Entity.MachineCategory = model.MachineCategory;
Entity.MachineType = model.MachineType;
Entity.MachineCapacity = model.MachineCapacity;
Entity.CapacityUnit = model.CapacityUnit;
if (model.InstallationDate == null)
{
Entity.InstallationDate = null;
}
else
{
Entity.InstallationDate = DalCommon.SetDate(model.InstallationDate);
}
if (model.ExpiaryDate == null)
{
Entity.ExpiaryDate = null;
}
else
{
Entity.ExpiaryDate = DalCommon.SetDate(model.ExpiaryDate);
}
Entity.Remarks = model.Remarks;
Entity.IsActive = model.IsActive == "Active";
Entity.SetOn = DateTime.Now;
Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
public EXP_PLPI SetToModelObject(EXPPLPI model, int userid)
{
EXP_PLPI Entity = new EXP_PLPI();
Entity.PLPIID = model.PLPIID;
Entity.PLID = model.PLID;
Entity.PIID = model.PIID;
Entity.LCID = model.LCID;
Entity.BuyerOrderID = model.BuyerOrderID;
Entity.MeterPLPIQty = model.MeterPLPIQty;
Entity.FootPLPIQty = model.FootPLPIQty;
Entity.PLPIPcs = model.PLPIPcs;
Entity.PLPISide = model.PLPISide;
Entity.PLPINetWeight = model.PLPINetWeight;
Entity.NetWeightUnit = model.PLPINetWeightUnit;
Entity.PLPIGrossWeight = model.PLPIGrossWeight;
Entity.GrossWeightUnit = model.PLPIGrossWeightUnit;
Entity.RecordStatus = "NCF";
Entity.SetOn = DateTime.Now;
Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
public EXP_BankLoan SetToBankLoanEntityObject(EXPBankLoan model, int _userid)//int _userid
{
EXP_BankLoan entity = new EXP_BankLoan();
entity.BankLoanID = model.BankLoanID;
entity.BankLoanNo = model.BankLoanNo;
//entity.BankID = model.BankID;
//entity.BranchID = model.BranchID;
entity.LoanHead = model.LoanHead;
entity.RefACNo = model.RefACNo;
entity.RefACName = model.RefACName;
var GridloanRecieveDate = model.LoanReceiveDate.Contains("/") ? model.LoanReceiveDate : Convert.ToDateTime(model.LoanReceiveDate).ToString("dd/MM/yyyy");
entity.LoanReceiveDate = DalCommon.SetDate(GridloanRecieveDate);
entity.LoanAmt = model.LoanAmt;
entity.InterestPercent = model.InterestPercent;
entity.LoanLimit = model.LoanLimit;
entity.ReturnedAmt = model.ReturnedAmt;
entity.BalanceAmt = model.BalanceAmt;
entity.CIID = model.CIID;
entity.Remarks = model.Remarks;
entity.RecordStatus = "NCF";
entity.RunningStatus = "CLS";
entity.SetOn = DateTime.Now;
entity.SetBy = _userid;
entity.IPAddress = GetIPAddress.LocalIPAddress();
return(entity);
}
public EXP_PackingList SetToModelObject(EXPPackingList model, int userid)
{
EXP_PackingList Entity = new EXP_PackingList();
Entity.PLID = model.PLID;
Entity.PLNo = model.PLNo;
Entity.CIID = model.CIID;
Entity.PLDate = DalCommon.SetDate(model.PLDate);
Entity.BalesNo = model.BalesNo;
Entity.BaleQty = model.BaleQty;
Entity.TotalPcs = model.TotalPcs;
Entity.TotalSide = model.TotalSide;
Entity.MeterCIQty = model.MeterCIQty;
Entity.FootCIQty = model.FootCIQty;
Entity.PLNetWeight = model.PLNetWeight;
Entity.NetWeightUnit = model.NetWeightUnit;
Entity.PLGrossWeight = model.PLGrossWeight;
Entity.GrossWeightUnit = model.GrossWeightUnit;
Entity.PLMarks = model.PLMarks;
Entity.PLNote = model.PLNote;
Entity.RecordStatus = "NCF";
Entity.SetOn = DateTime.Now;
Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
public INV_FinishLeatherReceiveColor SetToReceiveColorModelObject(InvFinishLeatherReceiveColor model, int userid)
{
INV_FinishLeatherReceiveColor Entity = new INV_FinishLeatherReceiveColor();
//Entity.FNReceiveColorID = model.FNReceiveColorID;
Entity.FNReceiveItemID = model.FNReceiveItemID;
Entity.FNReceiveID = model.FNReceiveID;
Entity.FinishLeatherIssueID = model.FinishLeatherIssueID;
Entity.FinishLeatherIssueItemID = model.FinishLeatherIssueItemID;
Entity.FinishLeatherIssueColorID = model.FinishLeatherIssueColorID;
Entity.ColorID = model.ColorID == null ? 0 : model.ColorID;
Entity.GradeID = model.GradeID == null ? 0 : model.GradeID;
Entity.FinishQCLabel = model.FinishQCLabel == null ? "" : model.FinishQCLabel;
Entity.IssuePcs = model.IssuePcs == null ? 0 : model.IssuePcs;
Entity.IssueSide = model.IssueSide == null ? 0 : model.IssueSide;
Entity.IssueArea = model.IssueArea == null ? 0 : model.IssueArea;
Entity.SideArea = model.SideArea == null ? 0 : model.SideArea;
Entity.AreaUnit = model.AreaUnit == null ? 0 : model.AreaUnit;
Entity.ReceivePcs = model.ReceivePcs == null ? 0 : model.ReceivePcs;
Entity.ReceiveSide = model.ReceiveSide == null ? 0 : model.ReceiveSide;
Entity.ReceiveArea = model.ReceiveArea == null ? 0 : model.ReceiveArea;
Entity.ReceiveSideArea = model.ReceiveSideArea == null ? 0 : model.ReceiveSideArea;
// Entity.ArticleColorNo = model.ArticleColorNo == null ? 0 : model.ArticleColorNo;
// Entity.GradeRange = model.GradeRange == null ? "" : model.GradeRange;
Entity.SetOn = DateTime.Now;
Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
public INV_FinishLeatherReceiveItem SetToIssueItemModelObject(InvFinishLeatherReceiveItem model, int userid)
{
INV_FinishLeatherReceiveItem Entity = new INV_FinishLeatherReceiveItem();
Entity.FNReceiveID = model.FNReceiveID;
Entity.FNReceiveItemID = model.FNReceiveItemID;
Entity.FinishLeatherIssueID = model.FinishLeatherIssueID;
Entity.FinishLeatherIssueItemID = model.FinishLeatherIssueItemID;
Entity.BuyerID = model.BuyerID == null ? 0 : model.BuyerID;
Entity.BuyerOrderID = model.BuyerOrderID == null ? 0 : model.BuyerOrderID;
Entity.ArticleID = model.ArticleID == null ? 0 : model.ArticleID;
Entity.ArticleNo = model.ArticleNo == null ? "" : model.ArticleNo;
//Entity.ArticleChallanID = model.ArticleChallanID == null ? 0 : model.ArticleChallanID;
Entity.ArticleChallanNo = model.ArticleChallanNo == null ? "" : model.ArticleChallanNo;
Entity.LeatherStatusID = model.LeatherStatusID == null ? 0 : model.LeatherStatusID;
Entity.ItemTypeID = model.ItemTypeID == null ? 0 : model.ItemTypeID;
Entity.LeatherTypeID = model.LeatherTypeID == null ? 0 : model.LeatherTypeID;
//var _LeatherType = Convert.ToByte(_context.Sys_LeatherType.Where(m => m.LeatherTypeName == "Finish").FirstOrDefault().LeatherTypeID);
//Entity.LeatherStatusID = model.LeatherStatusID == null ? 0 : model.LeatherStatusID;
Entity.FinishQCLabel = model.FinishQCLabel == null ? "" : model.FinishQCLabel;
//Entity.RecordStatus = "NCF";
Entity.SetOn = DateTime.Now;
//Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
public EXP_AgentCommission SetToModelObject(EXPAgentCommission model, int userid)
{
EXP_AgentCommission Entity = new EXP_AgentCommission();
Entity.AgentComID = model.AgentComID;
Entity.AgentComNo = model.AgentComNo;
Entity.AgentComDate = DalCommon.SetDate(model.AgentComDate);
Entity.AgentComRef = model.AgentComRef;
Entity.BuyerID = Convert.ToInt32(model.BuyerID);
Entity.CIID = model.CIID;
Entity.CIAmount = model.CIAmount;
Entity.ComOnAmount = model.ComOnAmount;
Entity.CIDate = DalCommon.SetDate(model.CIDate);
Entity.InvoiceCurrency = model.InvoiceCurrency;
//Entity.LocalCurrency = model.LocalCurrency;
Entity.LocalCurrency = _context.Sys_Currency.Where(m => m.CurrencyName == "TK").FirstOrDefault().CurrencyID;
Entity.RecordStatus = "NCF";
Entity.SetOn = DateTime.Now;
Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
public EXP_AgentCommissionBuyerCI SetToModelObject(EXPAgentCommissionBuyerCI model, int userid)
{
EXP_AgentCommissionBuyerCI Entity = new EXP_AgentCommissionBuyerCI();
Entity.AgentComCIID = model.AgentComCIID;
Entity.AgentComID = model.AgentComID;
Entity.BuyerAgentID = model.BuyerAgentID;
Entity.AgentType = model.AgentType;
Entity.CIID = model.CIID;
Entity.RefPIID = model.PIID;
Entity.CommissionPercent = model.CommissionPercent;
Entity.CommissionAmount = model.CommissionAmount;
Entity.AITPercent = model.AITPercent;
Entity.AITAmount = model.AITAmount;
Entity.PayableAmount = model.PayableAmount;
if (string.IsNullOrEmpty(model.ExchangeCurrencyName))
{
Entity.ExchangeCurrency = null;
}
else
{
Entity.ExchangeCurrency = _context.Sys_Currency.Where(m => m.CurrencyName == model.ExchangeCurrencyName).FirstOrDefault().CurrencyID;
}
Entity.ExchangeRate = model.ExchangeRate;
Entity.ExchangeAmount = model.ExchangeAmount;
Entity.LocalCurrency = model.LocalCurrency;
Entity.LocalRate = model.LocalRate;
Entity.LocalAmount = model.LocalAmount;
Entity.RecordStatus = "NCF";
Entity.SetOn = DateTime.Now;
Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
public ValidationMsg SaveLcmLcFile(LcmLcFile model)
{
LCM_LCFile obLcFile = new LCM_LCFile();
obLcFile.LCFileNo = model.LCFileNo;
obLcFile.LCFileOpenDate = DateTime.Now;
obLcFile.LCFileStatus = model.LCFileStatus;
obLcFile.LCFileClosingDate = model.LCFileClosingDate;
obLcFile.LCID = Convert.ToInt32(model.LCID);
obLcFile.LCNo = model.LCNo;
obLcFile.Remarks = model.Remarks;
obLcFile.RecordStatus = model.RecordStatus;
if (model.CheckedBy != null)
{
obLcFile.CheckedBy = Convert.ToInt32(model.CheckedBy);
}
if (obLcFile.CheckDate != null)
{
obLcFile.CheckDate = Convert.ToDateTime(model.CheckDate);
}
obLcFile.CheckComments = model.CheckComments;
if (model.ApprovedBy != null)
{
obLcFile.ApprovedBy = Convert.ToInt32(model.ApprovedBy);
}
if (model.ApproveDate != null)
{
obLcFile.ApproveDate = Convert.ToDateTime(model.ApproveDate);
}
obLcFile.ApprovalComments = model.ApprovalComments;
if (model.SetOn != null)
{
obLcFile.SetOn = Convert.ToDateTime(model.SetOn);
}
if (model.SetBy != null)
{
obLcFile.SetBy = Convert.ToInt32(model.SetBy);
}
obLcFile.ModifiedOn = DateTime.Now;
obLcFile.ModifiedBy = model.ModifiedBy;
obLcFile.IPAddress = GetIPAddress.LocalIPAddress();
try
{
repository.LcmLcFileRepository.Insert(obLcFile);
//repository.Save();
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
catch (Exception ex)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Saved Faild.";
}
return(_vmMsg);
}
public override void OnResultExecuted(ResultExecutedContext filterContext)
{
SEC_UserLog _userLog = new SEC_UserLog();
RouteData route_data = filterContext.RouteData;
_userLog.ActionExecuteTime = (DateTime.Now - start_time).ToString();
_userLog.ActionUrl = (route_data.DataTokens["area"] as string) + "/" + (route_data.Values["controller"] as string) + "/" + route_data.Values["action"] as string;
_userLog.UserID = UserID;
_userLog.UsedIP = GetIPAddress.LocalIPAddress();
_userLog.UserAction = route_data.Values["action"] as string;
_userLog.ActionEventTime = DateTime.Now.ToString();
userAccessLogService.ManipulateUserAccessLog(_userLog);
}
public ValidationMsg Update(SysMachine objSysMachine, int userid)
{
var vmMsg = new ValidationMsg();
try
{
var sysMachine = _context.Sys_Machine.FirstOrDefault(s => s.MachineID == objSysMachine.MachineID);
if (sysMachine != null)
{
sysMachine.MachineNo = objSysMachine.MachineNo;
sysMachine.MachineName = objSysMachine.MachineName;
sysMachine.MachineCategory = objSysMachine.MachineCategory;
sysMachine.MachineType = objSysMachine.MachineType;
sysMachine.MachineCapacity = objSysMachine.MachineCapacity;
sysMachine.CapacityUnit = objSysMachine.CapacityUnit;
if (objSysMachine.InstallationDate == null)
{
sysMachine.InstallationDate = null;
}
else
{
sysMachine.InstallationDate = DalCommon.SetDate(objSysMachine.InstallationDate);
}
if (objSysMachine.ExpiaryDate == null)
{
sysMachine.ExpiaryDate = null;
}
else
{
sysMachine.ExpiaryDate = DalCommon.SetDate(objSysMachine.ExpiaryDate);
}
//sysMachine.InstallationDate = DalCommon.SetDate(objSysMachine.InstallationDate);
//sysMachine.ExpiaryDate = DalCommon.SetDate(objSysMachine.ExpiaryDate);
sysMachine.Remarks = objSysMachine.Remarks;
sysMachine.IsActive = objSysMachine.IsActive == "Active";// Convert.ToBoolean(objSysMachine.IsActive);
sysMachine.ModifiedOn = DateTime.Now;
sysMachine.ModifiedBy = userid;
sysMachine.IPAddress = GetIPAddress.LocalIPAddress();
}
_context.SaveChanges();
vmMsg.Type = Enums.MessageType.Update;
vmMsg.Msg = "Updated Successfully.";
}
catch (Exception ex)
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to Update.";
}
return(vmMsg);
}
public Sys_Comodity SetToModelObject(SysComodity model, int userid)
{
Sys_Comodity Entity = new Sys_Comodity();
Entity.ComodityID = model.ComodityID;
Entity.ComodityCode = model.ComodityCode;
Entity.ComodityName = model.ComodityName;
Entity.IsActive = model.IsActive == "Active";
Entity.SetOn = DateTime.Now;
Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
public EXP_DeliveryChallanCI SetToDeliveryChallanCIModelObject(EXPDeliveryChallanCI model, int _userid)
{
EXP_DeliveryChallanCI entity = new EXP_DeliveryChallanCI();
entity.DeliverChallanID = model.DeliverChallanID;
entity.CIID = model.CIID;
entity.PLID = model.PLID;
entity.RecordStatus = DalCommon.ReturnRecordStatus(model.RecordStatus);
entity.SetOn = DateTime.Now;
entity.SetBy = _userid;
entity.RecordStatus = "NCF";
entity.IPAddress = GetIPAddress.LocalIPAddress();
return(entity);
}
public Sys_Bank SetToBankModelObject(SysBank model, int _userid)//int _userid
{
Sys_Bank entity = new Sys_Bank();
entity.BankID = model.BankID;
entity.BankCode = model.BankCode;
entity.BankName = model.BankName;
entity.BankCategory = model.BankCategory;
entity.BankType = model.BankType;
entity.IsActive = model.IsActive == "Active";
entity.SetOn = DateTime.Now;
entity.SetBy = _userid;
entity.IPAddress = GetIPAddress.LocalIPAddress();
return(entity);
}
public EXP_PLPIItemColor SetToModelObject(EXPPLPIItemColor model, int userid)
{
EXP_PLPIItemColor Entity = new EXP_PLPIItemColor();
Entity.PLPIItemColorID = model.PLPIItemColorID;
Entity.PLPIID = model.PLPIID;
Entity.Commodity = model.Commodity;
Entity.ArticleID = model.ArticleID;
Entity.ArticleNo = model.ArticleNo;
Entity.ItemTypeID = model.ItemTypeID;
Entity.LeatherTypeID = model.LeatherTypeID;
Entity.LeatherStatusID = model.LeatherStatusID;
Entity.MaterialNo = model.MaterialNo;
Entity.AvgSize = model.AvgSize;
Entity.AvgSizeUnit = model.AvgSizeUnit;
//if (string.IsNullOrEmpty(model.AvgSizeUnitName))
// Entity.AvgSizeUnit = null;
//else
// Entity.AvgSizeUnit = Convert.ToByte(_context.Sys_Unit.Where(m => m.UnitName == model.AvgSizeUnitName).FirstOrDefault().UnitID);
Entity.SideDescription = model.SideDescription;
Entity.SelectionRange = model.SelectionRange;
Entity.Thickness = model.Thickness;
Entity.ThicknessUnit = model.ThicknessUnit;
//if (string.IsNullOrEmpty(model.ThicknessUnitName))
// Entity.ThicknessUnit = null;
//else
// Entity.ThicknessUnit = Convert.ToByte(_context.Sys_Unit.Where(m => m.UnitName == model.ThicknessUnitName).FirstOrDefault().UnitID);
Entity.ThicknessAt = model.ThicknessAt;
Entity.ColorID = model.ColorID;
Entity.MeterPLPIItemQty = model.MeterPLPIItemQty;
Entity.FootPLPIItemQty = model.FootPLPIItemQty;
Entity.PLPIItemWeight = model.PLPIItemWeight;
Entity.ItemWeightUnit = model.ItemWeightUnit;
//Entity.PackQty = model.PackQty;
//if (string.IsNullOrEmpty(model.PackUnitName))
// Entity.PackUnit = null;
//else
// Entity.PackUnit = Convert.ToByte(_context.Sys_Unit.Where(m => m.UnitName == model.PackUnitName).FirstOrDefault().UnitID);
Entity.RecordStatus = "NCF";
Entity.Remarks = model.Remarks;
Entity.SetOn = DateTime.Now;
Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
public EXP_DeliveryChallan SetTotblDeliveryChallanModelObject(EXPDeliveryChallan model, int _userid)//int _userid
{
EXP_DeliveryChallan entity = new EXP_DeliveryChallan();
entity.DeliverChallanID = model.DeliverChallanID;
entity.DeliverChallanNo = model.DeliverChallanNo == null ? "" : model.DeliverChallanNo;
entity.DeliverChallanRef = model.DeliverChallanRef == null ? "" : model.DeliverChallanRef;
entity.DeliveryChallanNote = model.DeliveryChallanNote == null ? "" : model.DeliveryChallanNote;
entity.DeliverChallanDate = model.DeliverChallanDate;
entity.TruckNo = model.TruckNo == null ? "" : model.TruckNo;
entity.RecordStatus = "NCF";
entity.SetOn = DateTime.Now;
entity.SetBy = _userid;
entity.IPAddress = GetIPAddress.LocalIPAddress();
return(entity);
}
// ########################################### END OF SAVE,UPDATE,DELETE,CONFIRM #######################################################################
//************************************************************ For Saving use Entity & Model Data Mapping **********************************
public INV_FinishLeatherReceive SetToModelObject(InvFinishLeatherReceive model, int userid)
{
INV_FinishLeatherReceive Entity = new INV_FinishLeatherReceive();
Entity.FNReceiveID = model.FNReceiveID;
Entity.FNReceiveNo = model.FNReceiveNo;
Entity.FNReceiveDate = DalCommon.SetDate(model.FNReceiveDate);
Entity.ReceiveCategory = "STTF";
Entity.ReceiveFor = model.ReceiveFor == null ? "" : model.ReceiveFor;
Entity.IssueFrom = model.IssueFrom == null ? 0 : model.IssueFrom;
Entity.ReceiveAt = model.ReceiveAt == null ? 0 : model.ReceiveAt;
Entity.ReceiveNote = model.ReceiveNote == null ? "" : model.ReceiveNote;
Entity.CheckNote = model.CheckNote == null ? "" : model.CheckNote;
Entity.RecordStatus = "NCF";
Entity.SetOn = DateTime.Now;
//Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
public async Task <dynamic> AddVersionDocumentInfo(DocumentsInfo _modelDocumentsInfo)
{
DSM_DocPropIdentify objDocPropIdentifies = new DSM_DocPropIdentify();
if (ModelState.IsValid)
{
action = "add";
_modelDocumentsInfo.SetBy = UserID;
_modelDocumentsInfo.ModifiedBy = _modelDocumentsInfo.SetBy;
_modelDocumentsInfo.UploaderIP = GetIPAddress.LocalIPAddress();
respStatus.Message = "Success";
respStatus = await Task.Run(() => _versioningOfOriginalDocService.AddVersionDocumentInfo(
_modelDocumentsInfo, action, out objDocPropIdentifies));
try
{
FolderGenerator.MakeFTPDir(objDocPropIdentifies.ServerIP,
objDocPropIdentifies.ServerPort,
objDocPropIdentifies.FileServerUrl,
objDocPropIdentifies.FtpUserName,
objDocPropIdentifies.FtpPassword);
}
catch (Exception e)
{
}
return(Json(new
{
Message = respStatus.Message,
result = objDocPropIdentifies,
//DistinctID = DistinctDocIDs
}, JsonRequestBehavior.AllowGet));
}
else
{
//var errors = ModelState.Values.SelectMany(v => v.Errors);
respStatus = new ValidationResult("E404", _localizationService.GetResource("E404"));
return(Json(new { Message = respStatus.Message, respStatus }, JsonRequestBehavior.AllowGet));
}
}
public EXP_PLPIItemColorBale SetToModelObject(EXPPLPIItemColorBale model, int userid)
{
EXP_PLPIItemColorBale Entity = new EXP_PLPIItemColorBale();
Entity.PLPIItemColorBaleID = model.PLPIItemColorBaleID;
Entity.PLPIItemColorBaleNo = model.PLPIItemColorBaleNo;
Entity.PLPIItemColorID = model.PLPIItemColorID;
Entity.PcsInBale = model.PcsInBale;
Entity.SideInBale = model.SideInBale;
Entity.MeterPLPIBaleQty = model.MeterPLPIBaleQty;
Entity.FootPLPIBaleQty = model.FootPLPIBaleQty;
Entity.PLPIBaleNetWeight = model.PLPIBaleNetWeight;
Entity.PLPIBGrossaleWeight = model.PLPIBGrossaleWeight;
if (string.IsNullOrEmpty(model.GradeName))
{
Entity.GradeID = null;
}
else
{
Entity.GradeID = _context.Sys_Grade.Where(m => m.GradeName == model.GradeName).FirstOrDefault().GradeID;
}
//if (string.IsNullOrEmpty(model.GrossBaleWeightUnitName))
//{
// Entity.NetWeightUnit = null;
// Entity.GrossBaleWeightUnit = null;
//}
//else
//{
//Entity.NetWeightUnit = _context.Sys_Unit.Where(m => m.UnitName == model.GrossBaleWeightUnitName).FirstOrDefault().UnitID;
//Entity.GrossBaleWeightUnit = _context.Sys_Unit.Where(m => m.UnitName == model.GrossBaleWeightUnitName).FirstOrDefault().UnitID;
//}
Entity.NetWeightUnit = _context.Sys_Unit.Where(m => m.UnitName == "KG").FirstOrDefault().UnitID;
Entity.GrossBaleWeightUnit = _context.Sys_Unit.Where(m => m.UnitName == "KG").FirstOrDefault().UnitID;
Entity.Remarks = model.Remarks;
Entity.SetOn = DateTime.Now;
Entity.SetBy = userid;
Entity.IPAddress = GetIPAddress.LocalIPAddress();
return(Entity);
}
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 ValidationMsg UpdateLCM_LCRetirement(EXP_LCRetirement dataSet, int _userId)
{
try
{
EXP_LCRetirement obLCRetirement = repository.EXPLCRetirementRepository.GetByID(Convert.ToInt32(dataSet.LCRetirementID));
obLCRetirement.LCRetirementNo = dataSet.LCRetirementNo;
obLCRetirement.LCRetirementDate = DalCommon.SetDate(dataSet.LCRetirementDate.ToString());
obLCRetirement.LCNo = dataSet.LCNo;
obLCRetirement.LCID = dataSet.LCID;
obLCRetirement.BillValue = (decimal)dataSet.BillValue;
obLCRetirement.InterestPersent = (decimal)dataSet.InterestPersent;
obLCRetirement.InterestAmount = (decimal)dataSet.InterestAmount;
obLCRetirement.BankCommissionAmt = dataSet.BankCommissionAmt == null ? 0 : (decimal)dataSet.BankCommissionAmt;
obLCRetirement.SwiftCharge = dataSet.SwiftCharge == null ? 0 : (decimal)dataSet.SwiftCharge;
obLCRetirement.OtherCharge = dataSet.OtherCharge == null ? 0 : (decimal)dataSet.OtherCharge;//(decimal)dataSet.BankCommissionAmt;
obLCRetirement.TotalAmount = (decimal)dataSet.TotalAmount;
obLCRetirement.LCRCurrency = (byte)dataSet.LCRCurrency;
obLCRetirement.Remarks = dataSet.Remarks;
obLCRetirement.RecordStatus = "NCF";
obLCRetirement.ExchangeRate = (decimal)dataSet.ExchangeRate == null ? 0 : (decimal)dataSet.ExchangeRate;
obLCRetirement.ExchangeCurrency = (byte)(dataSet.ExchangeCurrency);
obLCRetirement.ExchangeValue = dataSet.ExchangeValue == null ? 0 : (decimal)dataSet.ExchangeValue;//(decimal)dataSet.ExchangeValue;
obLCRetirement.ModifiedOn = DateTime.Now;
obLCRetirement.ModifiedBy = _userId;
obLCRetirement.IPAddress = GetIPAddress.LocalIPAddress();
repository.EXPLCRetirementRepository.Update(obLCRetirement);
int flag = repository.Save();
if (flag == 1)
{
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Updated Successfully.";
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Update Faild.";
}
//_vmMsg.Type = Enums.MessageType.Error;
//_vmMsg.Msg = "Data already confirmed. You can't update this.";
}
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 ValidationMsg Update(EXPBankLoan model, int _userid)
{
_vmMsg = new ValidationMsg();
try
{
#region Update
using (var tx = new TransactionScope())
{
using (_context)
{
#region Save NEW Data & Update Existing Crust Leather Transfer Data
if (model.expBankLoanList != null)
{
foreach (EXPBankLoan bankLoan in model.expBankLoanList)
{
bankLoan.BankID = model.BankID;
bankLoan.BranchID = model.BranchID;
bankLoan.ApprovalNote = model.ApprovalNote;
if (bankLoan.BankLoanID == 0)
{
EXP_BankLoan tblBankLoan = SetToBankLoanModelObject(bankLoan, _userid);
tblBankLoan.BankID = bankLoan.BankID;
tblBankLoan.BranchID = bankLoan.BranchID;
tblBankLoan.ApprovalNote = bankLoan.ApprovalNote;
_context.EXP_BankLoan.Add(tblBankLoan);
}
else
{
EXP_BankLoan bankLoanEntity = SetToBankLoanModelObject(bankLoan, _userid);
model.BankID = bankLoanEntity.BankID;
model.BranchID = bankLoanEntity.BranchID;
model.ApprovalNote = bankLoanEntity.ApprovalNote;
var obBankLoan = _context.EXP_BankLoan.First(m => m.BankLoanID == bankLoan.BankLoanID);
//obBankLoan.BankLoanID = model.BankLoanID;
obBankLoan.BankLoanNo = bankLoanEntity.BankLoanNo;
obBankLoan.CIID = bankLoanEntity.CIID;
obBankLoan.LoanHead = bankLoanEntity.LoanHead;
obBankLoan.RefACNo = bankLoanEntity.RefACNo;
obBankLoan.RefACName = bankLoanEntity.RefACName;
//var GridloanRecieveDate = bankLoanEntity.LoanReceiveDate.Contains("/") ? bankLoanEntity.LoanReceiveDate : Convert.ToDateTime(bankLoanEntity.LoanReceiveDate).ToString("dd/MM/yyyy");
//obBankLoan.LoanReceiveDate = DalCommon.SetDate(GridloanRecieveDate);
obBankLoan.LoanAmt = bankLoanEntity.LoanAmt;
obBankLoan.InterestPercent = bankLoanEntity.InterestPercent;
obBankLoan.LoanLimit = bankLoanEntity.LoanLimit;
obBankLoan.ReturnedAmt = bankLoanEntity.ReturnedAmt;
obBankLoan.BalanceAmt = bankLoanEntity.BalanceAmt;
obBankLoan.Remarks = bankLoanEntity.Remarks;
obBankLoan.RunningStatus = bankLoanEntity.RunningStatus;
obBankLoan.RecordStatus = "NCF";
obBankLoan.ModifiedOn = DateTime.Now;
obBankLoan.ModifiedBy = _userid;
obBankLoan.IPAddress = GetIPAddress.LocalIPAddress();
}
}
}
#endregion
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Update;
_vmMsg.Msg = "Updated Successfully.";
}
}
#endregion
}
catch (DbEntityValidationException e)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to Update.";
}
return(_vmMsg);
}
public ValidationMsg UpdateProductionRecipe(PrdRecipe recipeModel, int userId)
{
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
var objRecipe = _context.PRD_Recipe.FirstOrDefault(r => r.RecipeID == recipeModel.RecipeID);
if (objRecipe != null)
{
objRecipe.RecipeID = recipeModel.RecipeID;
objRecipe.RecipeName = recipeModel.RecipeName;
objRecipe.ArticleNo = recipeModel.ArticleNo ?? "";
objRecipe.ArticleChallanNo = recipeModel.ArticleChallanNo ?? "";
objRecipe.ArticleName = recipeModel.ArticleName ?? "";
objRecipe.ArticleColor = recipeModel.ArticleColor;
objRecipe.CalculationBase = recipeModel.CalculationBase;
objRecipe.BaseQuantity = recipeModel.BaseQuantity;
objRecipe.BaseUnit = recipeModel.BaseUnit;
objRecipe.ModifiedBy = userId;
objRecipe.ModifiedOn = DateTime.Now;
objRecipe.IPAddress = GetIPAddress.LocalIPAddress();
}
_context.SaveChanges();
if (recipeModel.RecipeItems != null)
{
foreach (var recipeItem in recipeModel.RecipeItems)
{
if (recipeItem.RecipeItemID == 0)
{
var objItem = new PRD_RecipeItem();
objItem.RecipeID = recipeModel.RecipeID;
objItem.ItemID = recipeItem.ItemID;
objItem.RequiredQty = recipeItem.RequiredQty;
objItem.UnitID = recipeItem.UnitID;
objItem.SetOn = DateTime.Now;
objItem.SetBy = userId;
_context.PRD_RecipeItem.Add(objItem);
}
else
{
var updateItem =
_context.PRD_RecipeItem.First(r => r.RecipeItemID == recipeItem.RecipeItemID);
updateItem.RequiredQty = recipeItem.RequiredQty;
updateItem.ItemID = recipeItem.ItemID;
updateItem.UnitID = recipeItem.UnitID;
updateItem.ModifiedOn = DateTime.Now;
updateItem.ModifiedBy = userId;
updateItem.IPAddress = GetIPAddress.LocalIPAddress();
}
}
_context.SaveChanges();
}
}
tx.Complete();
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Updated Successfully.";
_vmMsg.ReturnId = recipeModel.RecipeID;
}
}
catch (Exception)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to save.";
}
return(_vmMsg);
}
public ValidationMsg Update(SysBank model, int _userid)
{
vmMsg = new ValidationMsg();
try
{
#region Update
using (var tx = new TransactionScope())
{
using (_context)
{
#region Crust Leather Transfer
Sys_Bank bank = SetToBankModelObject(model, _userid);
var OriginalEntity = _context.Sys_Bank.First(m => m.BankID == model.BankID);
OriginalEntity.BankCode = bank.BankCode;
OriginalEntity.BankName = bank.BankName;
OriginalEntity.BankCategory = bank.BankCategory;
OriginalEntity.BankType = bank.BankType;
OriginalEntity.IsActive = bank.IsActive;
OriginalEntity.ModifiedOn = DateTime.Now;
OriginalEntity.ModifiedBy = _userid;
_context.SaveChanges();
#endregion
#region Save NEW Data & Update Existing Crust Leather Transfer Data
if (model.Branches != null)
{
foreach (SysBranch branch in model.Branches)
{
branch.BankID = model.BankID;
if (branch.BranchID == 0)
{
branch.BankID = bank.BankID;
Sys_Branch tblBranch = SetToBranchModelObject(branch, _userid);
_context.Sys_Branch.Add(tblBranch);
//INV_CLTransferTo tblQCSelection = SetToCLTransferToModelObject(objCLTransferToItem, userid);
//_context.INV_CLTransferTo.Add(tblQCSelection);
}
else
{
Sys_Branch branchEntity = SetToBranchModelObject(branch, _userid);
var OriginalIssueItemEntity = _context.Sys_Branch.First(m => m.BranchID == branch.BranchID);
OriginalIssueItemEntity.BranchID = branchEntity.BranchID;
OriginalIssueItemEntity.BankID = branchEntity.BankID;
OriginalIssueItemEntity.BanchCode = branchEntity.BanchCode;
OriginalIssueItemEntity.BranchName = branchEntity.BranchName;
OriginalIssueItemEntity.Address1 = branchEntity.Address1;
OriginalIssueItemEntity.Address2 = branchEntity.Address2;
OriginalIssueItemEntity.Address3 = branchEntity.Address3;
OriginalIssueItemEntity.LCBalance = branchEntity.LCBalance;
// OriginalIssueItemEntity.IsActive = branchEntity.IsActive == "Active";
OriginalIssueItemEntity.SetOn = branchEntity.SetOn;
OriginalIssueItemEntity.SetBy = branchEntity.SetBy;
OriginalIssueItemEntity.ModifiedBy = _userid;
OriginalIssueItemEntity.ModifiedOn = DateTime.Now;
OriginalIssueItemEntity.IPAddress = GetIPAddress.LocalIPAddress();
OriginalIssueItemEntity.SetOn = DateTime.Now;
OriginalIssueItemEntity.SetBy = _userid;
}
}
}
#endregion
_context.SaveChanges();
tx.Complete();
BankID = model.BankID;
//CLTransferNo = model.CLTransferNo;
vmMsg.Type = Enums.MessageType.Update;
vmMsg.Msg = "Updated Successfully.";
}
}
#endregion
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("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)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to Update.";
}
return(vmMsg);
}
public ValidationMsg UpdateLCOpeningInfo(LcmLcOpening dataSet, int UserID)
{
try
{
LCM_LCOpening obLcOpening = repository.LCOpeningRepository.GetByID(Convert.ToInt32(dataSet.LCID));
if (!obLcOpening.RecordStatus.Equals("CNF"))
{
obLcOpening.LCNo = dataSet.LCNo;
obLcOpening.LCDate = DalCommon.SetDate(dataSet.LCDate.ToString());
obLcOpening.LCAmount = dataSet.LCAmount;
obLcOpening.ExchangeRate = dataSet.ExchangeRate;
obLcOpening.ExchangeValue = Convert.ToDecimal(dataSet.LCAmount * dataSet.ExchangeRate);
if (dataSet.LCAmountCurrency > 0)
{
obLcOpening.LCCurrencyID = (byte)dataSet.LCAmountCurrency;
}
if (dataSet.ExchangeCurrency > 0)
{
obLcOpening.ExchangeCurrency = (byte)dataSet.ExchangeCurrency;
}
obLcOpening.IssueDate = Convert.ToDateTime(DalCommon.SetDate(dataSet.IssueDate));
obLcOpening.ExpiryDate = DalCommon.SetDate(dataSet.ExpiryDate);
obLcOpening.ExpiryPlace = dataSet.ExpiryPlace;
obLcOpening.NNDSendingTime = dataSet.NNDSendingTime;
obLcOpening.ApprovalAdvice = dataSet.ApprovalAdvice;
obLcOpening.LCANo = dataSet.LCANo;
obLcOpening.IRCNo = dataSet.IRCNo;
obLcOpening.VatRegNo = dataSet.VatRegNo;
obLcOpening.TINNo = dataSet.TINNo;
obLcOpening.BINNo = dataSet.BINNo;
obLcOpening.ICNNo = dataSet.ICNNo;
obLcOpening.ICNDate = DalCommon.SetDate(dataSet.ICNDate);
obLcOpening.LastShipmentDate = DalCommon.SetDate(dataSet.LastShipmentDate);
if (dataSet.BranchID > 0)
{
obLcOpening.LCOpeningBank = dataSet.BranchID;
}
if (dataSet.AdvisingBank > 0)
{
obLcOpening.AdvisingBank = dataSet.AdvisingBank;
}
if (!string.IsNullOrEmpty(dataSet.Beneficiary))
{
obLcOpening.Beneficiary = Convert.ToInt32(dataSet.Beneficiary);
}
if (!string.IsNullOrEmpty(dataSet.PINo))
{
obLcOpening.PIID = dataSet.PIID;
obLcOpening.PINo = dataSet.PINo;
}
obLcOpening.ModifiedOn = DateTime.Now;
obLcOpening.ModifiedBy = UserID;
obLcOpening.IPAddress = GetIPAddress.LocalIPAddress();
obLcOpening.LCMargin = dataSet.LCMargin;
// ############## "": "", "": "", "": "", "": "", "": "",
if (!string.IsNullOrEmpty(dataSet.InsuranceID.ToString()))
{
obLcOpening.InsuranceID = Convert.ToInt32(dataSet.InsuranceID);
}
if (!string.IsNullOrEmpty(dataSet.PICurrency.ToString()))
{
obLcOpening.PICurrency = (byte)dataSet.PICurrency;
}
obLcOpening.PaymentTerm = dataSet.PaymentTerm;
obLcOpening.PaymentMode = dataSet.PaymentMode;
obLcOpening.DeferredDays = dataSet.DeferredDays;
if (!string.IsNullOrEmpty(dataSet.CountryOforigin.ToString()))
{
obLcOpening.CountryOforigin = Convert.ToInt32(dataSet.CountryOforigin);
}
if (!string.IsNullOrEmpty(dataSet.BeneficiaryBank.ToString()))
{
obLcOpening.BeneficiaryBank = Convert.ToInt32(dataSet.BeneficiaryBank);
}
obLcOpening.DeliveryTerm = dataSet.DeliveryTerm;
if (!string.IsNullOrEmpty(dataSet.PortofDischarge.ToString()))
{
obLcOpening.PortofDischarge = Convert.ToInt32(dataSet.PortofDischarge);
}
obLcOpening.DeliveryMode = dataSet.DeliveryMode;
if (!string.IsNullOrEmpty(dataSet.PortofLoading.ToString()))
{
obLcOpening.PortofLoading = Convert.ToInt32(dataSet.PortofLoading);
}
obLcOpening.Transshipment = dataSet.Transshipment;
obLcOpening.PartialShipment = dataSet.PartialShipment;
obLcOpening.GoodDelivery = dataSet.GoodDelivery;
obLcOpening.ShippingMark = dataSet.ShippingMark;
if (!string.IsNullOrEmpty(dataSet.ExpectedShipmentTime))
{
obLcOpening.ExpectedShipmentTime = Convert.ToInt32(dataSet.ExpectedShipmentTime);
}
obLcOpening.Packing = dataSet.Packing;
obLcOpening.PreShipmentIns = dataSet.PreShipmentIns;
if (!string.IsNullOrEmpty(dataSet.OfferValidityDays.ToString()))
{
obLcOpening.OfferValidityDays = Convert.ToInt32(dataSet.OfferValidityDays);
}
obLcOpening.PresentationDays = Convert.ToInt32(dataSet.PresentationDays);
obLcOpening.ConfirmStatus = dataSet.ConfirmStatus;
repository.LCOpeningRepository.Update(obLcOpening);
int flag = repository.Save();
if (flag == 1)
{
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Update Successfully.";
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Saved Faild.";
}
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Data already confirmed. You can't update this.";
}
}
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 ActionResult Save(LoanReturnIssue dataSet)
{
decimal RemainingQty = 0;
decimal ReturnQuantity = 0;
decimal TotalReturnQty = 0;
try
{
if (dataSet.RequestID == 0)
{
INV_TransRequest ob = new INV_TransRequest();
if (dataSet.RequestType == "RLRR")
{
ob.RequestNo = DalCommon.GetPreDefineNextCodeByUrl("LoanReturnRequest/LoanReturnIssue");
}
ob.RequestDate = DalCommon.SetDate(dataSet.RequestDate);
ob.RequestType = dataSet.RequestType;
ob.Remarks = dataSet.Remarks;
ob.RequestFrom = dataSet.RequestFrom.ToString();
ob.RequestTo = dataSet.RequestTo;
ob.ToSource = dataSet.ToSource;
ob.ExpectetReturnTime = Convert.ToByte(dataSet.ExpectetReturnTime);
ob.RecordStatus = "NCF";
ob.SetOn = DateTime.Now;
if (dataSet.ReturnMethod == "Exchange Other Item")
{
ob.ReturnMethod = "EOI";
}
else if (dataSet.ReturnMethod == "Doller to Doller")
{
ob.ReturnMethod = "DTD";
}
else if (dataSet.ReturnMethod == "Exchange Same Item")
{
ob.ReturnMethod = "ESI";
}
else
{
ob.ReturnMethod = dataSet.ReturnMethod;
}
ob.SetBy = Convert.ToInt32(Session["UserID"]);
ob.ModifiedBy = Convert.ToInt32(Session["UserID"]);
ob.ModifiedOn = DateTime.Now;
ob.IPAddress = GetIPAddress.LocalIPAddress();
repository.InvTransRequestRepository.Insert(ob);
INV_TransRequestRef obRef = new INV_TransRequestRef();
obRef.TransRequestRefNo = ob.RequestNo;
obRef.RequestID = ob.RequestID;
obRef.RefRequestID = Convert.ToInt64(dataSet.RefRequestID);
obRef.Remark = dataSet.Remarks;
obRef.SetOn = DateTime.Now;
obRef.SetBy = Convert.ToInt32(Session["UserID"]);
obRef.ModifiedBy = Convert.ToInt32(Session["UserID"]);
obRef.ModifiedOn = DateTime.Now;
obRef.IPAddress = GetIPAddress.LocalIPAddress();
repository.InvTransRequestRefRepository.Insert(obRef);
if (dataSet.lstLoanReturnIssueItems != null)
{
foreach (var item in dataSet.lstLoanReturnIssueItems)
{
TotalReturnQty = (item.RemainingQty * item.ReturnRate);
RemainingQty = item.RemainingQty == null ? 0 : Convert.ToDecimal(item.RemainingQty);
ReturnQuantity = item.ReturnQuantity == null ? 0 : Convert.ToDecimal(item.ReturnQuantity);
INV_TransRequestItem obReqItem = new INV_TransRequestItem();
obReqItem.RequestID = ob.RequestID;
obReqItem.TransRequestRefID = obRef.TransRequestRefID;
obReqItem.RefItemID = Convert.ToInt32(item.ItemID);
if (item.ReturnMethodID == "ESI")
{
obReqItem.ItemID = Convert.ToInt32(item.ItemID);
}
obReqItem.ReferenceQty = Convert.ToDecimal(item.ReferenceQty);
obReqItem.ReferenceUnit = Convert.ToByte(item.ReferenceUnit);
if (item.ReceiveCurrencyID != null)
{
obReqItem.ReferenceCurrency = Convert.ToByte(item.ReceiveCurrencyID);
}
obReqItem.ReferenceRate = Convert.ToDecimal(item.ReceiveRate);
obReqItem.ReferenceValue = Convert.ToDecimal(item.ReceiveValue);
obReqItem.ReturnMethod = item.ReturnMethodID == null ? "" : item.ReturnMethodID;
if (item.ReturnUnitID != null)
{
obReqItem.ReturnUnit = Convert.ToByte(item.ReturnUnitID);
}
if (item.ReturnItemID != null)
{
obReqItem.ItemID = Convert.ToInt32(item.ReturnItemID);
}
if (item.ReturnCurrencyID != null)
{
obReqItem.ReturnCurrency = Convert.ToByte(item.ReturnCurrencyID);
}
if (item.ReturnExchangeRate != null)
{
obReqItem.ExchangeRate = Convert.ToDecimal(item.ReturnExchangeRate);
}
if (item.ReturnRate != null)
{
obReqItem.ReturnRate = Convert.ToDecimal(item.ReturnRate);
}
obReqItem.RefItemDueQty = 0; //Math.Round(item.RemainingQty - ((item.ReturnQuantity * item.RemainingQty) / (TotalReturnQty == 0 ? 1 : TotalReturnQty)),2);
obReqItem.ReturnValue = Convert.ToDecimal(item.ReturnQuantity); //Math.Round(((item.ReturnQuantity * item.RemainingQty) / (TotalReturnQty == 0 ? 1 : TotalReturnQty)),2);
obReqItem.SetBy = Convert.ToInt32(Session["UserID"]);
obReqItem.SetOn = DateTime.Now;
obReqItem.ModifiedBy = Convert.ToInt32(Session["UserID"]);
obReqItem.ModifiedOn = DateTime.Now;
obReqItem.IPAddress = GetIPAddress.LocalIPAddress();
repository.InvTransRequestItemRepository.Insert(obReqItem);
}
}
try
{
repository.Save();
_vmMsg.ReturnCode = ob.RequestNo;
_vmMsg.ReturnId = ob.RequestID;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
catch (Exception ex)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Saved Faild.";
}
}
else
{ // Update
INV_TransRequest ob = repository.InvTransRequestRepository.GetByID(dataSet.RequestID);
ob.RequestDate = DalCommon.SetDate(dataSet.RequestDate);
if (dataSet.ReturnMethod == "Exchange Other Item")
{
ob.ReturnMethod = "EOI";
}
else if (dataSet.ReturnMethod == "Doller to Doller")
{
ob.ReturnMethod = "DTD";
}
else if (dataSet.ReturnMethod == "Exchange Same Item")
{
ob.ReturnMethod = "ESI";
}
else
{
ob.ReturnMethod = dataSet.ReturnMethod;
}
ob.RequestType = dataSet.RequestType;
ob.RequestFrom = dataSet.RequestFrom.ToString();
ob.RequestTo = dataSet.RequestTo;
ob.ToSource = dataSet.ToSource;
ob.ExpectetReturnTime = Convert.ToByte(dataSet.ExpectetReturnTime);
ob.Remarks = dataSet.Remarks;
ob.ModifiedOn = DateTime.Now;
ob.ModifiedBy = Convert.ToInt32(Session["UserID"]);
ob.IPAddress = GetIPAddress.LocalIPAddress();
repository.InvTransRequestRepository.Update(ob);
INV_TransRequestRef obRef = repository.InvTransRequestRefRepository.Get(filter: o => o.RequestID == dataSet.RequestID).FirstOrDefault();
obRef.Remark = dataSet.Remarks;
obRef.ModifiedBy = Convert.ToInt32(Session["UserID"]);
obRef.ModifiedOn = DateTime.Now;
obRef.IPAddress = GetIPAddress.LocalIPAddress();
repository.InvTransRequestRefRepository.Update(obRef);
if (dataSet.lstLoanReturnIssueItems != null)
{
foreach (var item in dataSet.lstLoanReturnIssueItems)
{
TotalReturnQty = (item.RemainingQty * item.ReturnRate);
RemainingQty = item.RemainingQty == null ? 0 : Convert.ToDecimal(item.RemainingQty);
ReturnQuantity = item.ReturnQuantity == null ? 0 : Convert.ToDecimal(item.ReturnQuantity);
INV_TransRequestItem obReqItem = repository.InvTransRequestItemRepository.GetByID(item.TransRequestItemID);
//obReqItem.TransRequestRefID = obRef.TransRequestRefID;
obReqItem.RefItemID = Convert.ToInt32(item.ItemID);
obReqItem.ReferenceQty = Convert.ToDecimal(item.ReferenceQty);
obReqItem.ReferenceUnit = Convert.ToByte(item.ReferenceUnit);
if (item.ReceiveCurrencyID != null)
{
obReqItem.ReferenceCurrency = Convert.ToByte(item.ReceiveCurrencyID);
}
if (item.ReturnMethodID == "ESI")
{
obReqItem.ItemID = Convert.ToInt32(item.ItemID);
}
obReqItem.ReferenceRate = Convert.ToDecimal(item.ReceiveRate);
obReqItem.ReferenceValue = Convert.ToDecimal(item.ReceiveValue);
obReqItem.ReturnMethod = item.ReturnMethodID == null ? "" : item.ReturnMethodID;
if (item.ReturnUnitID != null)
{
obReqItem.ReturnUnit = Convert.ToByte(item.ReturnUnitID);
}
if (item.ReturnItemID != null)
{
obReqItem.ItemID = Convert.ToInt32(item.ReturnItemID);
}
if (item.ReturnCurrencyID != null)
{
obReqItem.ReturnCurrency = Convert.ToByte(item.ReturnCurrencyID);
}
if (item.ReturnExchangeRate != null)
{
obReqItem.ExchangeRate = Convert.ToDecimal(item.ReturnExchangeRate);
}
if (item.ReturnRate != null)
{
obReqItem.ReturnRate = Convert.ToDecimal(item.ReturnRate);
}
obReqItem.RefItemDueQty = 0; //Math.Round((item.RemainingQty + (obReqItem.ReturnValue == null?0 : Convert.ToDecimal(obReqItem.ReturnValue))) - ((item.ReturnQuantity * item.RemainingQty) / (TotalReturnQty == 0 ? 1 : TotalReturnQty)), 2);
obReqItem.ReturnValue = Convert.ToDecimal(item.ReturnQuantity); //Math.Round(((item.ReturnQuantity * item.RemainingQty) / (TotalReturnQty == 0 ? 1 : TotalReturnQty)), 2);
obReqItem.SetBy = Convert.ToInt32(Session["UserID"]);
obReqItem.SetOn = DateTime.Now;
obReqItem.ModifiedBy = Convert.ToInt32(Session["UserID"]);
obReqItem.ModifiedOn = DateTime.Now;
obReqItem.IPAddress = GetIPAddress.LocalIPAddress();
repository.InvTransRequestItemRepository.Update(obReqItem);
}
}
try
{
repository.Save();
_vmMsg.ReturnCode = ob.RequestNo;
_vmMsg.ReturnId = dataSet.RequestID;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Updated Successfully.";
}
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));
}
}
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Saved Faild.";
throw new DbEntityValidationException(sb.ToString(), e);
}
}
}
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));
}
}
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Saved Faild.";
throw new DbEntityValidationException(sb.ToString(), e);
}
return(Json(new { msg = _vmMsg }));
}
public async Task <dynamic> AddDocumentInfo(DocumentsInfo _modelDocumentsInfo,
string _selectedPropID, List <DocMetaValue> _docMetaValues)
{
List <DSM_DocPropIdentify> objDocPropIdentifies = null;
if (ModelState.IsValid)
{
action = "add";
_modelDocumentsInfo.SetBy = UserID;
_modelDocumentsInfo.ModifiedBy = _modelDocumentsInfo.SetBy;
_modelDocumentsInfo.UploaderIP = GetIPAddress.LocalIPAddress();
respStatus.Message = "Success";
respStatus = await Task.Run(() => _multiDocScanService.AddDocumentInfo(_modelDocumentsInfo, _selectedPropID, _docMetaValues, action, out objDocPropIdentifies));
var DistinctDocIDs1 = (from s in objDocPropIdentifies
group s by new
{
s.DocumentID
}
into g
select new
{
DocPropID = g.Select(p => p.DocPropertyID).FirstOrDefault(),
DocumentID = g.Select(p => p.DocumentID).FirstOrDefault(),
FileServerUrl = g.Select(x => x.FileServerUrl).FirstOrDefault()
}).ToList();
List <DSM_DocProperty> proplList = new List <DSM_DocProperty>();
string[] docPropIDs = _selectedPropID.Split(',');
foreach (var item in docPropIDs)
{
DSM_DocProperty objDocProperty = new DSM_DocProperty();
objDocProperty.DocPropertyID = item;
proplList.Add(objDocProperty);
}
var DistinctDocIDs = (from p in proplList
join d in DistinctDocIDs1 on p.DocPropertyID equals d.DocPropID
select new
{
DocPropID = d.DocPropID,
DocumentID = d.DocumentID,
FileServerUrl = d.FileServerUrl
}).ToList();
foreach (var item in DistinctDocIDs)
{
try
{
FolderGenerator.MakeFTPDir(objDocPropIdentifies.FirstOrDefault().ServerIP,
objDocPropIdentifies.FirstOrDefault().ServerPort,
item.FileServerUrl,
objDocPropIdentifies.FirstOrDefault().FtpUserName,
objDocPropIdentifies.FirstOrDefault().FtpPassword);
}
catch (Exception e)
{
}
}
return(Json(new
{
Message = respStatus.Message,
result = objDocPropIdentifies,
DistinctID = DistinctDocIDs
}, JsonRequestBehavior.AllowGet));
}
else
{
//var errors = ModelState.Values.SelectMany(v => v.Errors);
respStatus = new ValidationResult("E404", _localizationService.GetResource("E404"));
return(Json(new { Message = respStatus.Message, respStatus }, JsonRequestBehavior.AllowGet));
}
}
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);
}
