//Get Create
//[CustomAuthorize(Roles = "Devision", AccessLevel = "W")]
public ActionResult Create()
{
//ViewBag.M_UnitList = new SelectList(T_SouvinerItemRepo.Get(), "Id", "Description");
T_SouvinerItemViewModel modelCode = new T_SouvinerItemViewModel();
modelCode.TransactionCode = T_SouvinerItemRepo.GetNewCode();
return(PartialView("_Create", modelCode));
}
public static T_SouvinerItemViewModel GetById(int Id)
{
T_SouvinerItemViewModel result = new T_SouvinerItemViewModel();
using (var db = new MarcomContext())
{
result = (from tsi in db.t_souvenir_item
join ts in db.t_souvenir on
tsi.t_souvenir_id equals ts.id
join ms in db.m_souvenir on
tsi.m_souvenir_id equals ms.id
join tev in db.t_event on
ts.id equals tev.id
where tsi.id == Id
select new T_SouvinerItemViewModel
{
Id = tsi.id,
TransactionCode = ts.code,
EvenCode = tev.code,
RequestBy = ts.request_by,
RequestDate = ts.request_date,
DueDate = ts.request_due_date,
Note = tsi.note,
SouvenirName = ms.name,
Qty = tsi.qty,
Note2 = ts.note,
QtySettlement = tsi.qty_settlement,
IsDelete = tsi.is_delete,
CreatedBy = tsi.created_by,
CreatedDate = tsi.created_date,
UpdatedBy = tsi.updated_by,
UpdatedDate = tsi.updated_date,
}).FirstOrDefault();
}
return(result);
}
