public void DeleteBank(int BankId) { Banks model = _ent.Banks.First(x => x.BankId == BankId); _ent.DeleteObject(model); _ent.SaveChanges(); }
/// <summary> /// For Deleting Message supply the MessageBoardId /// </summary> /// <param name="Id"></param> public ActionResponse Delete(int?id) { if (id != null) { AgentMessageBoards obj = _ent.AgentMessageBoards.First(m => m.MessageBoardId == id); if (obj != null) { _ent.DeleteObject(obj); _ent.SaveChanges(); _res.ActionMessage = String.Format(Resources.Message.SuccessfullyDeleted, "Message"); _res.ErrNumber = 0; _res.ErrSource = "DataBase"; _res.ErrType = "App"; _res.ResponseStatus = true; } else { _res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Message"); _res.ErrNumber = 2000; _res.ErrSource = "DataBase"; _res.ErrType = "App"; _res.ResponseStatus = true; } } else { _res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Message"); _res.ErrNumber = 2000; _res.ErrSource = "DataBase"; _res.ErrType = "App"; _res.ResponseStatus = true; } return(_res); }
public BusMessageModel Delete(long?Pid) { if (Pid != null) { var obj = _ent.Bus_Schedules.Where(x => x.ScheduleId == Pid).FirstOrDefault(); if (obj != null) { _ent.DeleteObject(obj); _ent.SaveChanges(); _res.ActionMessage = String.Format(Resources.Message.SuccessfullyCreated, "Bus Schedule "); _res.MsgNumber = 0; _res.MsgStatus = true; } else { _res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Bus Schedule "); _res.MsgNumber = 1005; _res.ErrSource = "DataBase"; _res.MsgType = 3; _res.MsgStatus = true; } } else { _res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Bus Schedule "); _res.MsgNumber = 1005; _res.ErrSource = "DataBase"; _res.MsgType = 3; _res.MsgStatus = true; } return(_res); }
public ActionResponse Delete(int?id, int ModifiedBy, DateTime ModifiedDate) { if (id != null) { var obj = _ent.MRC_CardValue.First(m => m.CardValueId == id); if (obj != null) { _ent.DeleteObject(obj); _ent.SaveChanges(); _res.ActionMessage = String.Format(Resources.Message.SuccessfullyDeleted, "Card Value"); _res.ErrNumber = 0; _res.ResponseStatus = true; } else { _res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Card Value"); _res.ErrNumber = 1005; _res.ErrSource = "DataBase"; _res.ErrType = "App"; _res.ResponseStatus = true; } } else { _res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Card Value"); _res.ErrNumber = 1005; _res.ErrSource = "DataBase"; _res.ErrType = "App"; _res.ResponseStatus = true; } return(_res); }
///////////////////////////////////////////////////////////////////////////////////////////////////////////// //for delete public void DeleteLedgerMaster(int LedgerMasterId) { GL_Ledgers result = ent.GL_Ledgers.Where(x => x.LedgerId == LedgerMasterId).FirstOrDefault(); ent.DeleteObject(result); ent.SaveChanges(); }
//for delete public void BankDelete(int BankId) { Banks result = ent.Banks.Where(x => x.BankId == BankId).FirstOrDefault(); ent.DeleteObject(result); ent.SaveChanges(); }
public bool Delete(int pId) { var result = _entity.Air_OffLineAirlineSettings.Where(x => x.OfflineAirlineSettingId == pId).FirstOrDefault(); if (result != null) { _entity.DeleteObject(result); _entity.SaveChanges(); return(true); } return(false); }
//for delete public ActionResponse Delete(int id) { Core_AdminBanks result = _ent.Core_AdminBanks.Where(x => x.AdminBankId == id).FirstOrDefault(); _ent.DeleteObject(result); _ent.SaveChanges(); _res.ActionMessage = String.Format(Resources.Message.SuccessfullyDeleted, "My bank"); _res.ErrNumber = 1005; _res.ErrSource = "DataBase"; _res.ErrType = "App"; _res.ResponseStatus = true; return(_res); }
public void DeleteDistributorAgentSetting(int agentid) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); try { var filteredSettings = ent.AgentSettings.Where(x => x.AgentId == agentid && (x.AgentSettingId == 5 || x.AgentSettingId == 6)); foreach (AgentSettings agentSetting in filteredSettings) { ent.DeleteObject(agentSetting); } ent.SaveChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool SaveAgentClassDeal(int?agentClassId, int?masterDealId, int?hotelMasterDealId, int appUserId) { if (masterDealId != null) { if (!IsAirlineDealInserted(agentClassId)) { AgentClassDeals obj = new AgentClassDeals { AgentClassId = agentClassId ?? 0, DealMasterId = masterDealId ?? 0, CreatedBy = appUserId, CreatedDate = DateTime.Now }; ent.AddToAgentClassDeals(obj); } else { if (!IsSameMasterDealAlreadyExists(agentClassId, masterDealId)) { var objToDelete = ent.AgentClassDeals.Where(z => z.AgentClassId == agentClassId); foreach (var delete in objToDelete) { int productId = GetProductIdByMasterDealId(delete.DealMasterId); if (productId == 1) { ent.DeleteObject(delete); } } AgentClassDeals obj = new AgentClassDeals { AgentClassId = agentClassId ?? 0, DealMasterId = masterDealId ?? 0, CreatedBy = appUserId, CreatedDate = DateTime.Now }; ent.AddToAgentClassDeals(obj); } } } else { var objToDelete = ent.AgentClassDeals.Where(z => z.AgentClassId == agentClassId); foreach (var delete in objToDelete) { int productId = GetProductIdByMasterDealId(delete.DealMasterId); if (productId == 1) { ent.DeleteObject(delete); } } } if (hotelMasterDealId != null) { if (!IsHotelDealInserted(agentClassId)) { AgentClassDeals obj = new AgentClassDeals { AgentClassId = agentClassId ?? 0, DealMasterId = hotelMasterDealId ?? 0, CreatedBy = appUserId, CreatedDate = DateTime.Now }; ent.AddToAgentClassDeals(obj); } else { if (!IsSameMasterDealAlreadyExists(agentClassId, hotelMasterDealId)) { var objToDelete = ent.AgentClassDeals.Where(z => z.AgentClassId == agentClassId); foreach (var delete in objToDelete) { int productId = GetProductIdByMasterDealId(delete.DealMasterId); if (productId == 2) { ent.DeleteObject(delete); } } AgentClassDeals obj = new AgentClassDeals { AgentClassId = agentClassId ?? 0, DealMasterId = hotelMasterDealId ?? 0, CreatedBy = appUserId, CreatedDate = DateTime.Now }; ent.AddToAgentClassDeals(obj); } } } else { var objToDelete = ent.AgentClassDeals.Where(z => z.AgentClassId == agentClassId); foreach (var delete in objToDelete) { int productId = GetProductIdByMasterDealId(delete.DealMasterId); if (productId == 2) { ent.DeleteObject(delete); } } } ent.SaveChanges(); return(true); }