public void EditMenuAccess(MenuAccessViewModel menuAccess)
{
using (MarcommEntities db = new MarcommEntities())
{
m_menu_access menu_access = new m_menu_access();
menu_access.m_role_id = menuAccess.mRoleId;
menu_access.is_delete = menuAccess.isDelete;
var menu_is_already_exist = (from p in db.m_menu_access
where p.m_role_id.Equals(menu_access.m_role_id) && !p.is_delete
select p).ToList();
foreach (var menu_id in menuAccess.selectedMenus)
{
if (!menu_is_already_exist.Any(x => x.m_menu_id.Equals(int.Parse(menu_id))))
{
menu_access.m_menu_id = int.Parse(menu_id);
menu_access.is_delete = false;
menu_access.created_by = menuAccess.createdBy;
menu_access.created_date = menuAccess.createdDate;
db.m_menu_access.Add(menu_access);
db.SaveChanges();
}
else
{
menu_access = menu_is_already_exist.Where(x => x.m_menu_id.Equals(int.Parse(menu_id))).SingleOrDefault();
menu_access.is_delete = true;
menu_access.updated_by = menuAccess.updateBy;
menu_access.updated_date = menuAccess.updatedDate;
db.Entry(menu_access).State = EntityState.Modified;
db.SaveChanges();
}
}
}
}
public void UpdateSettlementSouvenirRequest(SouvenirRequestViewModel souvenirItem)
{
using (MarcommEntities db = new MarcommEntities())
{
var dictSouvenirItem = souvenirItem.listId.Zip(souvenirItem.listQtySettlement, (id, qty) => new { id, qty })
.ToDictionary(x => x.id, x => x.qty);
var souvenir_items = (from p in db.t_souvenir_item
where souvenirItem.listId.ToList().Contains(p.id) && !p.is_delete
select p)
.ToList();
foreach (var souvenir_item in souvenir_items)
{
souvenir_item.qty_settlement = dictSouvenirItem[souvenir_item.id];
souvenir_item.updated_by = souvenirItem.updatedBy;
souvenir_item.updated_date = DateTime.Now;
souvenir_item.t_souvenir.status = 4;
souvenir_item.t_souvenir.settlement_by = Convert.ToInt32(souvenirItem.updatedBy);
souvenir_item.t_souvenir.settlement_date = DateTime.Now;
souvenir_item.t_souvenir.update_by = souvenirItem.updatedBy;
souvenir_item.t_souvenir.update_date = DateTime.Now;
db.Entry(souvenir_item).State = EntityState.Modified;
db.SaveChanges();
}
}
}
public void CloseSettlementSouvenirRequest(SouvenirStockViewModel Souvenir)
{
using (MarcommEntities db = new MarcommEntities())
{
var souvenir = (from p in db.t_souvenir where p.id.Equals(Souvenir.id) select p).SingleOrDefault();
souvenir.status = 6;
souvenir.update_by = Souvenir.updateBy;
souvenir.update_date = DateTime.Now;
db.Entry(souvenir).State = EntityState.Modified;
db.SaveChanges();
}
}
public void ApprovalSettlementSouvenirRequest(SouvenirStockViewModel Souvenir)
{
using (MarcommEntities db = new MarcommEntities())
{
var souvenir = (from p in db.t_souvenir where p.id.Equals(Souvenir.id) select p).SingleOrDefault();
souvenir.status = Souvenir.status;
souvenir.settlement_approved_by = Souvenir.settlementApprovedBy;
souvenir.settlement_approved_date = Souvenir.settlementApprovedDate;
souvenir.reject_reason = Souvenir.rejectReason;
souvenir.update_by = Souvenir.updateBy;
souvenir.update_date = DateTime.Now;
db.Entry(souvenir).State = EntityState.Modified;
db.SaveChanges();
}
}
public void CreateMenuAccess(MenuAccessViewModel menuAccess)
{
using (MarcommEntities db = new MarcommEntities())
{
m_menu_access menu_access = new m_menu_access();
menu_access.m_role_id = menuAccess.mRoleId;
menu_access.is_delete = false;
menu_access.created_by = menuAccess.createdBy;
menu_access.created_date = DateTime.Now;
foreach (var menu_id in menuAccess.selectedMenus)
{
menu_access.m_menu_id = int.Parse(menu_id);
db.m_menu_access.Add(menu_access);
db.SaveChanges();
}
}
}
public void DeleteMenuAccess(MenuAccessViewModel menuAccess)
{
using (MarcommEntities db = new MarcommEntities())
{
var menu_is_already_exist = (from p in db.m_menu_access
where p.m_role_id.Equals(menuAccess.mRoleId) && !p.is_delete
select p).ToList();
foreach (var menu in menu_is_already_exist)
{
m_menu_access menu_access = menu;
menu_access.is_delete = true;
menu_access.updated_by = menuAccess.updateBy;
menu_access.updated_date = DateTime.Now;
db.Entry(menu_access).State = EntityState.Modified;
db.SaveChanges();
}
}
}