public ActionResult Save(EXP_LCRetirement dataSet) { _userId = Convert.ToInt32(Session["UserID"]); objValMssg = objDalEXPLCRetirement.SaveLCM_LCRetirement(dataSet, _userId, "EXPLCRetirement/EXPLCRetirement"); return(Json(new { msg = objValMssg })); }
public ActionResult GetLcmRetirementByLCRetirementID(string LCRetirementID) { int id = Convert.ToInt32(LCRetirementID); EXP_LCRetirement dataSet = objRepository.EXPLCRetirementRepository.GetByID(id); EXPLCRetirement ob = new EXPLCRetirement(); ob.LCNo = dataSet.LCNo == null ? "" : dataSet.LCNo;//dataSet.LCNo; ob.LCID = Convert.ToInt32(dataSet.LCID); ob.LCRetirementID = dataSet.LCRetirementID; ob.LCRetirementNo = dataSet.LCRetirementNo; ob.LCRetirementDate = Convert.ToDateTime(dataSet.LCRetirementDate).ToString("dd/MM/yyyy"); ob.BillValue = Convert.ToInt32(dataSet.BillValue); int lcId = Convert.ToInt32(dataSet.LCID); var temp = objRepository.LcmBankDebitVoucherRpository.GetByID(dataSet.LCID); if (temp == null) { ob.LCMargin = '0'; } else { ob.LCMargin = Convert.ToDecimal(temp); } ob.LCRCurrency = (byte)dataSet.LCRCurrency; //ob.ExchangeRate = (byte)dataSet.ExchangeRate; if (ob.ExchangeRate == null) { dataSet.ExchangeRate = 0; } else { ob.ExchangeRate = (byte)dataSet.ExchangeRate; } ob.ExchangeValue = (decimal)dataSet.ExchangeValue; ob.ExchangeCurrency = (byte)dataSet.ExchangeCurrency; ob.BankCommissionAmt = (decimal)dataSet.BankCommissionAmt; ob.OtherCharge = (decimal)dataSet.OtherCharge; ob.SwiftCharge = (decimal)dataSet.SwiftCharge; ob.InterestPersent = (byte)dataSet.InterestPersent; ob.InterestAmount = (decimal)dataSet.InterestAmount; ob.TotalAmount = (decimal)dataSet.TotalAmount; ob.RecordStatus = dataSet.RecordStatus; ob.Remarks = dataSet.Remarks; return(Json(ob, JsonRequestBehavior.AllowGet)); }
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); }