public ValidationMsg ConfirmRecordStatus(string lcId, int userId)
{
try
{
EXP_LCOpening ob = repository.ExpLCOpening.GetByID(Convert.ToInt32(lcId));
if (lcId != "" && ob.RecordStatus == "NCF")
{
ob.RecordStatus = "CNF";
ob.LCStatus = "RNG";
ob.LCState = "ODDN";
ob.ApproveDate = DateTime.Now;
repository.ExpLCOpening.Update(ob);
int flag = repository.Save();
if (flag == 1)
{
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Confirmed Successfully.";
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Confirmed Faild.";
}
}
else
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Data Save First.";
}
}
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 GetLCDetailInfoByLCID(string LCID)
{
int id = Convert.ToInt32(LCID);
EXP_LCOpening dataSet = repository.ExpLCOpening.GetByID(id);
EXPLCOpening ob = new EXPLCOpening();
ob.LCNo = dataSet.LCNo == null ? "" : dataSet.LCNo;
ob.LCID = Convert.ToInt32(dataSet.LCID);
ob.LCDate = Convert.ToDateTime(dataSet.LCDate).ToString("dd/MM/yyyy");
ob.LCAmount = (decimal)dataSet.LCAmount == null ? 0 : (decimal)dataSet.LCAmount;
ob.LCCurrencyID = (byte)dataSet.LCCurrencyID;
ob.PIID = dataSet.PIID;
ob.PINo = repository.ExpLeatherPI.GetByID(dataSet.PIID == null ? 0 : dataSet.PIID).PINo;
ob.LastShipmentDate = Convert.ToDateTime(dataSet.LastShipmentDate).ToString("dd/MM/yyyy");
ob.ExpiryDate = Convert.ToDateTime(dataSet.ExpiryDate).ToString("dd/MM/yyyy");
ob.ExpiryPlace = dataSet.ExpiryPlace == null ? "" : dataSet.ExpiryPlace;
ob.RecordStatus = dataSet.RecordStatus;
ob.Remarks = dataSet.Remarks;
return(Json(ob, JsonRequestBehavior.AllowGet));
}
public ActionResult Update(EXP_LCOpening dataSet)
{
_userId = Convert.ToInt32(Session["UserID"]);
_vmMsg = objDalExpLCOpening.Update(dataSet, _userId);
return(Json(new { msg = _vmMsg }));
}
public ValidationMsg Update(EXP_LCOpening dataSet, int _userId)
{
try
{
EXP_LCOpening obLcOpening = repository.ExpLCOpening.GetByID(dataSet.LCID);
obLcOpening.LCID = dataSet.LCID;
obLcOpening.LCNo = dataSet.LCNo;
obLcOpening.LCDate = dataSet.LCDate;
obLcOpening.LCAmount = dataSet.LCAmount;
obLcOpening.LCCurrencyID = dataSet.LCCurrencyID;
obLcOpening.PIID = dataSet.PIID;
obLcOpening.ExpiryDate = dataSet.ExpiryDate;
obLcOpening.ExpiryPlace = dataSet.ExpiryPlace;
obLcOpening.LastShipmentDate = dataSet.LastShipmentDate;
obLcOpening.Remarks = dataSet.Remarks;
obLcOpening.RecordStatus = "NCF";
obLcOpening.RunningStatus = dataSet.RunningStatus == null ? "" : dataSet.RunningStatus;
obLcOpening.LCReviceDate = DateTime.Now;
obLcOpening.LCState = dataSet.LCState == null ? "" : dataSet.LCState;
obLcOpening.LCStatus = dataSet.LCStatus == null ? "" : dataSet.LCStatus;
obLcOpening.ModifiedOn = DateTime.Now;
obLcOpening.ModifiedBy = _userId;
obLcOpening.IPAddress = GetIPAddress.LocalIPAddress();
repository.ExpLCOpening.Update(obLcOpening);
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.";
}
}
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 Save(EXPLCOpening dataSet, int _userId)
{
try
{
EXP_LCOpening objLcOpening = new EXP_LCOpening();
objLcOpening.LCID = dataSet.LCID;
objLcOpening.LCNo = dataSet.LCNo;//DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
objLcOpening.LCAmount = dataSet.LCAmount;
objLcOpening.LCDate = DalCommon.SetDate(dataSet.LCDate);
objLcOpening.LCCurrencyID = dataSet.LCCurrencyID;
objLcOpening.PIID = dataSet.PIID == null ? 0 : dataSet.PIID;
objLcOpening.ExpiryDate = DalCommon.SetDate(dataSet.ExpiryDate);
objLcOpening.ExpiryPlace = dataSet.ExpiryPlace == null ? "" : dataSet.ExpiryPlace;
objLcOpening.LastShipmentDate = DalCommon.SetDate(dataSet.LastShipmentDate);
objLcOpening.Remarks = dataSet.Remarks;
objLcOpening.LCState = "LCOP";
objLcOpening.LCStatus = "GDSP";
objLcOpening.RecordStatus = "NCF";
objLcOpening.RunningStatus = "LCOP";
objLcOpening.SetOn = DateTime.Now;
objLcOpening.SetBy = _userId;
objLcOpening.IPAddress = GetIPAddress.LocalIPAddress();
//objLcOpening.RefLCNo = dataSet.RefLCNo == null ? "" : dataSet.RefLCNo;
//objLcOpening.IssueDate = DalCommon.SetDate(dataSet.IssueDate);
//objLcOpening.ExchangeCurrency = dataSet.ExchangeCurrency == null ? 0 : dataSet.ExchangeCurrency;
//objLcOpening.ExchangeRate = dataSet.ExchangeRate == null ? 0 : (decimal)dataSet.ExchangeRate;
//objLcOpening.ExchangeValue = dataSet.ExchangeValue == null ? 0 : (decimal)dataSet.ExchangeValue;
//objLcOpening.NNDSendingTime = dataSet.NNDSendingTime == null ? 0 : (int)dataSet.NNDSendingTime;
//objLcOpening.LCANo = dataSet.LCANo == null ? "" : dataSet.LCANo;
//objLcOpening.IRCNo = dataSet.IRCNo == null ? "" : dataSet.IRCNo;
//objLcOpening.VatRegNo = dataSet.VatRegNo == null ? "" : dataSet.VatRegNo;
//objLcOpening.BINNo = dataSet.BINNo == null ? "" : dataSet.BINNo;
//objLcOpening.ICNNo = dataSet.ICNNo == null ? "" : dataSet.ICNNo;
//objLcOpening.TINNo = dataSet.ICNNo == null ? "" : dataSet.TINNo;
//objLcOpening.ICNDate = DalCommon.SetDate(dataSet.ICNDate);
//if (dataSet.BranchID != 0)
//{
// objLcOpening.LCOpeningBank = dataSet.BranchID;
//}
//else
//{
// objLcOpening.LCOpeningBank = 0;
//}
//if (dataSet.AdvisingBank != 0)
//{
// objLcOpening.AdvisingBank = dataSet.AdvisingBank;
//}
//if (dataSet.Beneficiary != 0)
//{
// objLcOpening.Beneficiary = dataSet.PIBeneficiary;
//}
//if (dataSet.BeneficiaryAddressID != 0)
//{
// objLcOpening.BeneficiaryAddressID = dataSet.BeneficiaryAddressID;
//}
//objLcOpening.LCReviceNo = dataSet.LCReviceNo;
//objLcOpening.LCReviceDate = DateTime.Now;
obEntity.EXP_LCOpening.Add(objLcOpening);
int flag = obEntity.SaveChanges();
if (flag == 1)
{
_vmMsg.ReturnId = objLcOpening.LCID;
_vmMsg.ReturnCode = objLcOpening.LCNo;
_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);
}
