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(); } } }