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 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 string PurchaseIDBySupplierID(PrqSelectionReport data)
{
string dd = "";
DateTime DateFrom = DalCommon.SetDate(data.DateFrom);
DateTime DateTo = DalCommon.SetDate(data.DateTo);
var storeLocationList = repository.PrqPurchaseRepository.Get(filter: ob => ob.SupplierID == data.SupllierId && (ob.PurchaseDate >= DateFrom && ob.PurchaseDate <= DateTo)).OrderByDescending(o => o.PurchaseID);
dd = "<option value='all'>All Purchase Summary</option>";
if (storeLocationList.Count() > 0)
{
dd += "<option value='alldetails'>All Purchase Details</option>";
foreach (var item in storeLocationList)
{
dd += "<option value='" + item.PurchaseID + "'> " + item.PurchaseNo + " (" + item.PurchaseDate.ToString("dd/MM/yyyy") + ") </option>";
}
}
return(dd);
}
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 ActionResult Save(LCM_Insurence dataSet)
{
try
{
LCM_Insurence obInsurance = new LCM_Insurence();
obInsurance.InsuranceChallanNo = dataSet.InsuranceChallanNo;
obInsurance.InsuranceCompany = dataSet.InsuranceCompany;
if (!string.IsNullOrEmpty(dataSet.LCNo))
{
obInsurance.LCNo = dataSet.LCNo;
obInsurance.LCID = Convert.ToInt32(dataSet.LCID);
}
obInsurance.InsuranceNo = dataSet.InsuranceNo;
obInsurance.CoverNoteDate = dataSet.CoverNoteDate.ToString();
obInsurance.MoneyReceiptNo = dataSet.MoneyReceiptNo;
obInsurance.MoneyReceiptDate = DalCommon.SetDate(Convert.ToDateTime(dataSet.MoneyReceiptDate).ToString("dd/MM/yyyy"));
obInsurance.ClauseEndorsement = dataSet.ClauseEndorsement;
obInsurance.InsuranceChallanNo = dataSet.InsuranceChallanNo;
obInsurance.InsurancChallanDate = DalCommon.SetDate(Convert.ToDateTime(dataSet.InsurancChallanDate).ToString("dd/MM/yyyy"));
obInsurance.PolicyNo = dataSet.PolicyNo;
obInsurance.PolicyDate = DalCommon.SetDate(Convert.ToDateTime(dataSet.PolicyDate).ToString("dd/MM/yyyy"));
obInsurance.InvoiceAmount = dataSet.InvoiceAmount;
if (dataSet.InvouceCurrency != 0)
{
obInsurance.InvouceCurrency = dataSet.InvouceCurrency;
}
obInsurance.IncreasePercent = (decimal)dataSet.IncreasePercent;
obInsurance.IncreaseAmount = (decimal)dataSet.IncreaseAmount;
obInsurance.SumInsured = (decimal)dataSet.SumInsured;
obInsurance.ExchangeRate = (decimal)dataSet.ExchangeRate;
obInsurance.ExchangeRateCurrency = (byte)dataSet.ExchangeRateCurrency;
obInsurance.ExchangedSumInsured = (decimal)dataSet.ExchangedSumInsured;
obInsurance.MarinePremiumPercent = (decimal)dataSet.MarinePremiumPercent;
obInsurance.MarinePremiumAmount = (decimal)dataSet.MarinePremiumAmount;
obInsurance.DiscountPercent = (decimal)dataSet.DiscountPercent;
obInsurance.DiscountAmount = (decimal)dataSet.DiscountAmount;
obInsurance.WarSRCCPercent = (decimal)dataSet.WarSRCCPercent;
obInsurance.WarSRCCPercentAmount = (decimal)dataSet.WarSRCCPercentAmount;
obInsurance.NetPremium = (decimal)dataSet.NetPremium;
obInsurance.VatPercent = (decimal)dataSet.VatPercent;
obInsurance.VatAmount = (decimal)dataSet.VatAmount;
//obInsurance.StampDutyRetio = (decimal)dataSet.StampDutyRetio;
obInsurance.StampDutyAmount = (decimal)dataSet.StampDutyAmount;
obInsurance.GrandPremium = (decimal)dataSet.GrandPremium;
obInsurance.RefundPercent = (decimal)dataSet.RefundPercent;
obInsurance.RefundAmount = (decimal)dataSet.RefundAmount;
obInsurance.PaidAmount = (decimal)dataSet.PaidAmount;
obInsurance.RevisionNo = dataSet.RevisionNo;
obInsurance.RevisionDate = DalCommon.SetDate(Convert.ToDateTime(dataSet.RevisionDate).ToString("dd/MM/yyyy"));
obInsurance.RunningStatus = dataSet.RunningStatus;
obInsurance.RecordStatus = "NCF";
obInsurance.SetOn = DateTime.Now;
obInsurance.SetBy = Convert.ToInt32(Session["UserID"]);
obInsurance.ModifiedOn = DateTime.Now;
obInsurance.ModifiedBy = Convert.ToInt32(Session["UserID"]);
obInsurance.IPAddress = GetIPAddress.LocalIPAddress();
if (!string.IsNullOrEmpty(dataSet.PIID.ToString()))
{
obInsurance.PIID = Convert.ToInt32(dataSet.PIID);
}
if (!string.IsNullOrEmpty(dataSet.CIID.ToString()))
{
obInsurance.CIID = Convert.ToInt32(dataSet.CIID);
}
obInsurance.CINo = dataSet.CINo;
repo.LcmInsuranceRpository.Insert(obInsurance);
int flag = repo.Save(); // obEntity.SaveChanges();
if (flag == 1)
{
_vmMsg.ReturnId = obInsurance.InsuranceID;
_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(Json(new { msg = _vmMsg }));
}
public ActionResult Update(Lcm_Insurence dataSet)
{
try
{
LCM_Insurence obInsurance = repo.LcmInsuranceRpository.GetByID(Convert.ToInt32(dataSet.InsuranceID));
if (!obInsurance.RecordStatus.Equals("CNF"))
{
obInsurance.InsuranceChallanNo = dataSet.InsuranceChallanNo;
obInsurance.InsuranceCompany = dataSet.InsuranceCompany;
obInsurance.LCID = dataSet.LCID;
obInsurance.LCNo = dataSet.LCNo;
obInsurance.InsuranceNo = dataSet.InsuranceNo;
obInsurance.CoverNoteDate = dataSet.CoverNoteDate == null?"": dataSet.CoverNoteDate.ToString();
obInsurance.MoneyReceiptNo = dataSet.MoneyReceiptNo;
obInsurance.MoneyReceiptDate = DalCommon.SetDate(dataSet.MoneyReceiptDate == null?"":dataSet.MoneyReceiptDate.ToString());
obInsurance.ClauseEndorsement = dataSet.ClauseEndorsement;
obInsurance.InsuranceChallanNo = dataSet.InsuranceChallanNo;
obInsurance.InsurancChallanDate = DalCommon.SetDate(dataSet.InsurancChallanDate == null?"": dataSet.InsurancChallanDate.ToString());
obInsurance.PolicyNo = dataSet.PolicyNo;
obInsurance.PolicyDate = DalCommon.SetDate(dataSet.PolicyDate == null?"": dataSet.PolicyDate.ToString());
obInsurance.InvoiceAmount = dataSet.InvoiceAmount;
if (dataSet.InvouceCurrency != 0)
{
obInsurance.InvouceCurrency = dataSet.InvouceCurrency;
}
obInsurance.IncreasePercent = (decimal)dataSet.IncreasePercent;
obInsurance.IncreaseAmount = (decimal)dataSet.IncreaseAmount;
obInsurance.SumInsured = (decimal)dataSet.SumInsured;
obInsurance.ExchangeRate = (decimal)dataSet.ExchangeRate;
obInsurance.ExchangeRateCurrency = (byte)dataSet.ExchangeRateCurrency;
obInsurance.ExchangedSumInsured = (decimal)dataSet.ExchangedSumInsured;
obInsurance.MarinePremiumPercent = (decimal)dataSet.MarinePremiumPercent;
obInsurance.MarinePremiumAmount = (decimal)dataSet.MarinePremiumAmount;
obInsurance.DiscountPercent = (decimal)dataSet.DiscountPercent;
obInsurance.DiscountAmount = (decimal)dataSet.DiscountAmount;
obInsurance.WarSRCCPercent = (decimal)dataSet.WarSRCCPercent;
obInsurance.WarSRCCPercentAmount = (decimal)dataSet.WarSRCCPercentAmount;
obInsurance.NetPremium = (decimal)dataSet.NetPremium;
obInsurance.VatPercent = (decimal)dataSet.VatPercent;
obInsurance.VatAmount = (decimal)dataSet.VatAmount;
obInsurance.StampDutyAmount = (decimal)dataSet.StampDutyAmount;
obInsurance.GrandPremium = (decimal)dataSet.GrandPremium;
obInsurance.RefundPercent = (decimal)dataSet.RefundPercent;
obInsurance.RefundAmount = (decimal)dataSet.RefundAmount;
obInsurance.PaidAmount = (decimal)dataSet.PaidAmount;
obInsurance.RevisionNo = dataSet.RevisionNo;
obInsurance.RevisionDate = DalCommon.SetDate(dataSet.RevisionDate == null?"": dataSet.RevisionDate.ToString());
obInsurance.ModifiedBy = Convert.ToInt32(Session["UserID"]);
obInsurance.ApprovalAdvice = dataSet.ApprovalAdvice;
if (dataSet.CIID != 0)
{
obInsurance.CIID = Convert.ToInt32(dataSet.CIID);
}
obInsurance.CINo = dataSet.CINo;
if (!string.IsNullOrEmpty(dataSet.PIID))
{
obInsurance.PIID = Convert.ToInt32(dataSet.PIID);
}
repo.LcmInsuranceRpository.Update(obInsurance);
int flag = repo.Save();
if (flag == 1)
{
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Updated Successfully.";
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Updated 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(Json(new { msg = _vmMsg }));
}
public ActionResult Save(TransRequest dataSet)
{
try
{
//######################################
// Session["UserID"] = 1;
if (dataSet.RequestID == 0)
{
INV_TransRequest ob = new INV_TransRequest();
if (dataSet.RequestType == "LNIR")
{
ob.RequestNo = DalCommon.GetPreDefineNextCodeByUrl("LoanRequest/LoanIssueRequest");
ob.FromSource = dataSet.ToSource;
//ob.ToSource = "STR";
}
else if (dataSet.RequestType == "LNRR")
{
ob.RequestNo = DalCommon.GetPreDefineNextCodeByUrl("LoanRequest/Index");
//ob.FromSource = "STR";
ob.ToSource = dataSet.ToSource;
}
else
{
}
ob.RequestDate = DalCommon.SetDate(dataSet.RequestDate);
ob.RequestType = dataSet.RequestType;
ob.RequestFrom = dataSet.RequestFrom.ToString();
ob.RequestTo = dataSet.RequestTo.ToString();
ob.ReturnMethod = dataSet.ReturnMethod;
ob.ExpectetReturnTime = Convert.ToByte(dataSet.ExpectetReturnTime);
ob.RecordStatus = "NCF";
ob.SetOn = DateTime.Now;
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 = ob.RequestID;
obRef.ReturnMethod = dataSet.ReturnMethod;
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.ChemicalSelectedList != null)
{
foreach (var item in dataSet.ChemicalSelectedList)
{
INV_TransRequestItem obReqItem = new INV_TransRequestItem();
obReqItem.RequestID = ob.RequestID;
obReqItem.ReturnMethod = dataSet.ReturnMethod;
obReqItem.TransRequestRefID = obRef.TransRequestRefID;
if (item.ItemID > 0)
{
obReqItem.ItemID = Convert.ToInt32(item.ItemID);
}
if (Convert.ToByte(item.PackSize) > 0)
{
obReqItem.PackSize = Convert.ToByte(item.PackSize);
}
obReqItem.PackQty = Convert.ToInt32(item.PackQty);
if (Convert.ToByte(item.SizeUnit) > 0)
{
obReqItem.SizeUnit = Convert.ToByte(item.SizeUnit);
}
if (obReqItem.PackQty != null && item.PackSize != null)
{
obReqItem.TransQty = obReqItem.PackQty * ((Convert.ToByte(repository.SysSizeRepository.GetByID(Convert.ToInt32(item.PackSize)).SizeName)));
}
if (Convert.ToByte(item.ReferenceUnit) > 0)
{
obReqItem.TransUnit = Convert.ToByte(item.ReferenceUnit);
}
if (item.RefSupplierID > 0)
{
obReqItem.RefSupplierID = Convert.ToInt32(item.RefSupplierID);
}
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 = repository.InvTransRequestRepository.Get().Last().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);
ob.RequestFrom = dataSet.RequestFrom.ToString();
ob.RequestTo = dataSet.RequestTo.ToString();
ob.ReturnMethod = dataSet.ReturnMethod;
ob.ExpectetReturnTime = Convert.ToByte(dataSet.ExpectetReturnTime);
ob.ModifiedOn = DateTime.Now;
ob.ModifiedBy = Convert.ToInt32(Session["UserID"]);
ob.FromSource = "STR";
if (ob.RequestType == "LNIR")
{
ob.FromSource = dataSet.ToSource;
}
else if (ob.RequestType == "LNRR")
{
ob.ToSource = dataSet.ToSource;
}
else
{
}
//ob.ToSource = dataSet.ToSource;
ob.IPAddress = GetIPAddress.LocalIPAddress();
repository.InvTransRequestRepository.Update(ob);
INV_TransRequestRef obRef = repository.InvTransRequestRefRepository.Get(filter: o => o.RequestID == dataSet.RequestID).FirstOrDefault();
obRef.ReturnMethod = dataSet.ReturnMethod;
obRef.ModifiedBy = Convert.ToInt32(Session["UserID"]);
obRef.ModifiedOn = DateTime.Now;
obRef.IPAddress = GetIPAddress.LocalIPAddress();
repository.InvTransRequestRefRepository.Update(obRef);
if (dataSet.ChemicalSelectedList != null)
{
foreach (var item in dataSet.ChemicalSelectedList)
{
if (item.TransRequestItemID == 0)
{
INV_TransRequestItem obReqItem = new INV_TransRequestItem();
obReqItem.RequestID = ob.RequestID;
obReqItem.TransRequestRefID = obRef.TransRequestRefID;
obReqItem.ReturnMethod = dataSet.ReturnMethod;
if (Convert.ToInt32(item.ItemID) > 0)
{
obReqItem.ItemID = Convert.ToInt32(item.ItemID);
}
if (Convert.ToByte(item.PackSize) > 0)
{
obReqItem.PackSize = Convert.ToByte(item.PackSize);
}
else
{
obReqItem.PackSize = 0;
}
obReqItem.PackQty = Convert.ToInt32(item.PackQty);
if (Convert.ToByte(item.SizeUnit) > 0)
{
obReqItem.SizeUnit = Convert.ToByte(item.SizeUnit);
}
if (obReqItem.PackQty > 0 && item.PackSize != null)
{
obReqItem.TransQty = obReqItem.PackQty * ((Convert.ToByte(repository.SysSizeRepository.GetByID(Convert.ToInt32(item.PackSize)).SizeName)));//Convert.ToDecimal(item.ReferenceQty);
}
else
{
obReqItem.TransQty = Convert.ToDecimal(item.ReferenceQty);
}
if (Convert.ToByte(item.ReferenceUnit) > 0)
{
obReqItem.TransUnit = Convert.ToByte(item.ReferenceUnit);
}
if (Convert.ToInt32(item.RefSupplierID) > 0)
{
obReqItem.RefSupplierID = Convert.ToInt32(item.RefSupplierID);
}
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);
}
else
{
INV_TransRequestItem obReqItem = repository.InvTransRequestItemRepository.GetByID(item.TransRequestItemID);
if (Convert.ToInt32(item.ItemID) > 0)
{
obReqItem.ItemID = Convert.ToInt32(item.ItemID);
}
if (Convert.ToByte(item.PackSize) > 0)
{
obReqItem.PackSize = Convert.ToByte(item.PackSize);
}
else
{
obReqItem.PackSize = 0;
}
obReqItem.PackQty = Convert.ToInt32(item.PackQty);
obReqItem.ReturnMethod = dataSet.ReturnMethod;
if (Convert.ToByte(item.SizeUnit) > 0)
{
obReqItem.SizeUnit = Convert.ToByte(item.SizeUnit);
}
if (obReqItem.PackQty > 0 && item.PackSize != null)
{
obReqItem.TransQty = obReqItem.PackQty * (Convert.ToByte(repository.SysSizeRepository.GetByID(Convert.ToInt32(item.PackSize)).SizeName)); //Convert.ToDecimal(item.ReferenceQty);
}
else
{
obReqItem.TransQty = Convert.ToDecimal(item.ReferenceQty);
}
if (Convert.ToByte(item.ReferenceUnit) > 0)
{
obReqItem.TransUnit = Convert.ToByte(item.ReferenceUnit);
}
if (Convert.ToInt32(item.RefSupplierID) > 0)
{
obReqItem.RefSupplierID = Convert.ToInt32(item.RefSupplierID);
}
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 (Exception x)
{
_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(Json(new { msg = _vmMsg }));
}
