public List<LevelTransferDetailViewModel> GetDetail(int? id)
{
var list = new List<LevelTransferDetailViewModel>();
try
{
using (SATEntities db = new SATEntities())
{
int index = 1;
var detail = db.vw_Move_Level_Detail.Where(x => x.MlID == id).ToList();
foreach (var item in detail)
{
LevelTransferDetailViewModel model = new LevelTransferDetailViewModel();
model.RowNumber = index++;
model.MlID = item.MlID;
model.UserID = item.UserID;
model.FullName = item.FullName;
model.MlLevelOld = item.MlLevelOld;
model.MlStepOld = item.MlStepOld;
model.MlSalaryOld = item.MlSalaryOld;
model.MlSalaryNew = item.MlSalaryNew;
model.MlLevelNew = item.MlLevelNew;
model.MlStepNew = item.MlStepNew;
list.Add(model);
}
}
}
catch (Exception)
{
throw;
}
return list;
}
public LevelTransferDetailViewModel GetDetailByID(int? id)
{
LevelTransferDetailViewModel model = new LevelTransferDetailViewModel();
try
{
using (SATEntities db = new SATEntities())
{
model = db.tb_Move_Level_Detail.Where(x => x.MlID == id).Select(s => new LevelTransferDetailViewModel
{
MlID = s.MlID,
UserID = s.UserID,
MlLevelOld = s.MlLevelOld,
MlStepOld = s.MlStepOld,
MlLevelNew = s.MlLevelNew,
MlStepNew = s.MlStepNew
}).FirstOrDefault();
}
}
catch (Exception)
{
throw;
}
return model;
}
