public ResponseData UpdateByEntity(PositionRateViewModel newdata)
{
using (SATEntities db = new SATEntities())
{
ResponseData result = new Models.ResponseData();
try
{
var model = db.tb_Man_Power.Single(x => x.MpID == newdata.MpID);
model.DivID = newdata.DivID;
model.DepID = newdata.DepID;
model.SecID = newdata.SecID;
model.PoID = newdata.PoID;
model.DisID = newdata.DisID;
model.UserID = newdata.UserID;
model.EduID = newdata.EduID;
model.ModifyBy = UtilityService.User.UserID;
model.ModifyDate = DateTime.Now;
db.SaveChanges();
}
catch (Exception ex)
{
result.MessageCode = "";
result.MessageText = ex.Message;
}
return(result);
}
}
public ResponseData AddByEntity(PositionRateViewModel data)
{
using (SATEntities db = new SATEntities())
{
ResponseData result = new Models.ResponseData();
try
{
int maxID = db.tb_Man_Power.Where(m => m.TypeID == data.TypeID).Max(m => (int)m.MpID);
tb_Man_Power model = new tb_Man_Power();
model.MpID = maxID;
model.TypeID = data.TypeID;
model.DivID = data.DivID;
model.DepID = data.DepID;
model.SecID = data.SecID;
model.PoID = data.PoID;
model.DisID = data.DisID;
model.UserID = data.UserID;
model.EduID = data.EduID;
model.CreateBy = UtilityService.User.UserID;
model.CreateDate = DateTime.Now;
model.ModifyBy = UtilityService.User.UserID;
model.ModifyDate = DateTime.Now;
db.tb_Man_Power.Add(model);
db.SaveChanges();
result.ID = model.MpID;
}
catch (Exception ex)
{
result.MessageCode = "";
result.MessageText = ex.Message;
}
return(result);
}
}
public List <PositionRateViewModel> GetPositionManPower(int?type, int?divid, int?depid, int?secid)
{
List <PositionRateViewModel> list = new List <PositionRateViewModel>();
using (SATEntities db = new SATEntities())
{
var position = db.vw_Man_Power.Where(m => m.TypeID == type && m.DivID == divid && m.DepID == depid && m.SecID == secid && !string.IsNullOrEmpty(m.PoName))
.GroupBy(item => item.PoID, (key, group) => new
{
PoID = key,
PoName = group.FirstOrDefault().PoName,
MpID = group.FirstOrDefault().MpID,
DivID = group.FirstOrDefault().DivID,
DepID = group.FirstOrDefault().DepID,
SecID = group.FirstOrDefault().SecID
}).OrderBy(o => o.PoName).ToList();
foreach (var item in position)
{
PositionRateViewModel model = new PositionRateViewModel();
model.MpID = item.MpID;
//model.MpCode = (type == 1) ? item.MpID.ToString().PadLeft(3, '0') : item.MpID.ToString().PadLeft(4, '0');
model.PoID = item.PoID;
model.PoName = item.PoName;
model.DivID = item.DivID;
model.DepID = item.DepID;
model.SecID = item.SecID;
list.Add(model);
}
}
return(list);
}
public List <PositionRateViewModel> GetDivisionManPower(int?type)
{
List <PositionRateViewModel> list = new List <PositionRateViewModel>();
using (SATEntities db = new SATEntities())
{
var deivision = db.vw_Man_Power.Where(m => m.TypeID == type && m.DivID != null)
.GroupBy(item => item.DivID, (key, group) => new
{
DivID = key,
DivName = group.FirstOrDefault().DivName,
MpID = group.FirstOrDefault().MpID
}).OrderBy(o => o.DivName).ToList();
foreach (var item in deivision)
{
PositionRateViewModel model = new PositionRateViewModel();
model.MpID = item.MpID;
//model.MpCode = (type == 1) ? item.MpID.ToString().PadLeft(3, '0') : item.MpID.ToString().PadLeft(4, '0');
model.DivID = item.DivID;
model.DivName = item.DivName;
list.Add(model);
}
}
return(list);
}
public PositionRateViewModel GetByID(int?id)
{
PositionRateViewModel model = new PositionRateViewModel();
try
{
using (SATEntities db = new SATEntities())
{
var data = db.vw_Man_Power.Where(x => x.MpID == id).FirstOrDefault();
if (data != null)
{
model.MpID = data.MpID;
//model.MpCode = data.TypeID == 1 ? data.MpID.ToString().PadLeft(3, '0') : data.MpID.ToString().PadLeft(4, '0');
model.DivID = data.DivID;
model.DepID = data.DepID;
model.SecID = data.SecID;
model.PoID = data.PoID;
model.DisID = data.DisID;
model.UserID = data.UserID;
model.FullNameTh = data.TiShortName + data.FullNameTh;
model.EduID = data.EduID;
model.TypeID = data.TypeID;
}
}
}
catch (Exception)
{
throw;
}
return(model);
}
public JsonResult SavePositionRate(PositionRateViewModel data)
{
ResponseData result = new Models.ResponseData();
if (data.MpID != 0)
{
result = new PositionRateRepository().UpdateByEntity(data);
}
else
{
result = new PositionRateRepository().AddByEntity(data);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public List <PositionRateViewModel> GetPositionRate(int?type)
{
using (SATEntities db = new SATEntities())
{
List <PositionRateViewModel> list = new List <PositionRateViewModel>();
var position = db.vw_Man_Power.Where(m => m.TypeID == type && !string.IsNullOrEmpty(m.PoName))
.GroupBy(item => item.PoID, (key, group) => new { PoID = key, MpID = group.FirstOrDefault().MpID, PoName = group.FirstOrDefault().PoName })
.OrderBy(o => o.MpID)
.ToList();
foreach (var item in position)
{
PositionRateViewModel model = new PositionRateViewModel();
model.MpID = item.MpID;
//model.MpCode = type == 1 ? item.MpID.ToString().PadLeft(3, '0') : item.MpID.ToString().PadLeft(4, '0');
model.PoName = item.PoName;
list.Add(model);
}
return(list);
}
}
