public PositionTransferDetailViewModel GetDetailByID(int?id)
{
PositionTransferDetailViewModel model = new PositionTransferDetailViewModel();
try
{
using (SATEntities db = new SATEntities())
{
model = db.vw_Move_Man_Power_Detail.Where(x => x.MopID == id).Select(s => new PositionTransferDetailViewModel
{
MopID = s.MopID,
UserID = s.UserID,
CurMpID = s.CurMpID,
MovMpID = s.MovMpID,
AgentMpID = s.AgentMpID,
AgentPoTID = s.AgentPoTID,
CurrentPo = s.CurPoName,
MovePo = s.MovPoName,
AgentPo = s.AgentPoName,
MovRemark = s.MovRemark
}).FirstOrDefault();
}
}
catch (Exception)
{
throw;
}
return(model);
}
public List <PositionTransferDetailViewModel> GetDetail(int?id)
{
var list = new List <PositionTransferDetailViewModel>();
try
{
using (SATEntities db = new SATEntities())
{
int index = 1;
var detail = db.vw_Move_Man_Power_Detail.Where(x => x.MopID == id).ToList();
foreach (var item in detail)
{
PositionTransferDetailViewModel model = new PositionTransferDetailViewModel();
model.RowNumber = index++;
model.MopID = item.MopID;
model.UserID = item.UserID;
model.FullName = item.FullName;
model.CurMpID = item.CurMpID;
model.CurPoName = item.CurPoName;
model.MovMpID = item.MovMpID;
model.MovPoName = item.MovPoName;
model.AgentPoTID = item.AgentPoTID;
model.AgentPoTName = item.AgentPoTName;
model.AgentMpID = item.AgentMpID;
model.AgentPoName = item.AgentPoName;
model.MovRemark = item.MovRemark;
model.CurrentPo = "(" + item.CurMpID + ") " + item.CurPoName;
model.MovePo = "(" + item.MovMpID + ") " + item.MovPoName;
model.AgentPo = "(" + item.AgentMpID + ") " + item.AgentPoName;
model.AgentPo = item.AgentPoTName + " (" + item.AgentMpID + ") " + item.AgentPoName;
model.BelongTo = item.DivName + " / " + item.DepName + " / " + item.SecName;
list.Add(model);
}
}
}
catch (Exception)
{
throw;
}
return(list);
}
