public ActionResult Index()
{
MEsCreditLimitModel model = new MEsCreditLimitModel();
model.MEsCreditLimitList = MEcCLP.GetAllCreditLimitList();
return(View(model));
}
public ActionResult Edit(int id)
{
MEsCreditLimitModel model = MEcCLP.GetAllCreditLimitList().Where(x => x.MEsCreditLimitId == id).FirstOrDefault();
model.CurrencyList = new SelectList(MEcCLP.GetCurrency(), "CurrencyId", "CurrencyCode");
model.MEsList = new SelectList(MEcCLP.GetMEsList(), "AppUserId", "FullName");
return(View(model));
}
public ActionResult Create()
{
MEsCreditLimitModel model = new MEsCreditLimitModel();
model.CurrencyList = new SelectList(MEcCLP.GetCurrency(), "CurrencyId", "CurrencyCode");
model.MEsList = new SelectList(MEcCLP.GetMEsList(), "AppUserId", "FullName");
return(View(model));
}
public ActionResult Edit(int id, MEsCreditLimitModel model)
{
TravelSession obj = (TravelSession)Session["TravelPortalSessionInfo"];
if (ModelState.IsValid)
{
MEcCLP.Insert(model, obj.AppUserId);
return(RedirectToAction("Index"));
}
model.CurrencyList = new SelectList(MEcCLP.GetCurrency(), "CurrencyId", "CurrencyCode");
model.MEsList = new SelectList(MEcCLP.GetMEsList(), "AppUserId", "FullName");
return(View(model));
}
public void Insert(MEsCreditLimitModel model, int AppUserId)
{
ResetIsActive(model.MEsID, model.CurrencyID);
var objToSave = new MEsCreditLimits()
{
CurrencyId = model.CurrencyID,
EffectiveFrom = model.EffictiveFrom,
Amount = model.Amount ?? 0,
ExpireOn = model.ExpireOn,
MEsId = model.MEsID,
CreatedBy = AppUserId,
CreatedDate = DateTime.UtcNow,
isActive = true
};
Entity_Model.MEsCreditLimits.AddObject(objToSave);
Entity_Model.SaveChanges();
}
public List <MEsCreditLimitModel> GetAllCreditLimitList()
{
List <MEsCreditLimitModel> model = new List <MEsCreditLimitModel>();
var Data = Entity_Model.MEsCreditLimits.Where(x => x.isActive == true).OrderByDescending(c => c.MEsCreditLimitId);
foreach (var item in Data)
{
MEsCreditLimitModel data = new MEsCreditLimitModel()
{
CurrencyID = item.CurrencyId,
EffictiveFrom = item.EffectiveFrom,
Amount = item.Amount,
ExpireOn = item.ExpireOn,
MEsID = item.MEsId,
MEsCreditLimitId = item.MEsCreditLimitId,
MEsName = item.UsersDetails.FullName,
CurrencyCode = item.Currencies.CurrencyCode
};
model.Add(data);
}
return(model);
}
