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