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);
}
