public App_Class.ServiceResponse Delete(int PId)
{
Core_PackagesInquiries result = _ent.Core_PackagesInquiries.Where(x => x.PackagesInquiryId == PId).FirstOrDefault();
try
{
_ent.DeleteObject(result);
_ent.SaveChanges();
_response = new ServiceResponse("Successfully deleted!!", MessageType.Success, true, "Delete");
return(_response);
}
catch (SqlException ex)
{
_response = new ServiceResponse(ServiceResponsesProvider.SqlExceptionMessage(ex), MessageType.SqlException, false);
}
catch (Exception ex)
{
_response = new ServiceResponse(ex.Message, MessageType.Exception, false, "Delete");
}
return(_response);
}
public ServiceResponse Save(AirPackageInquiryModel model)
{
try
{
using (var ts = new TransactionScope(TransactionScopeOption.Required))
{
Core_PackagesInquiries obj = new Core_PackagesInquiries
{
AgentId = model.AgentId,
PackageId = model.PackageId,
Title = model.Title,
TravelDate = model.TravelDate,
Name = model.Name,
EmailAddress = model.EmailAddress,
NoOfAdult = model.NoOfAdult,
NoOfChild = model.NoOfChild,
ContactNo = model.ContactNo,
Remark = model.Remark,
CreatedBy = model.CreatedBy,
CreatedDate = model.CreatedDate,
};
_ent.AddToCore_PackagesInquiries(obj);
_ent.SaveChanges();
ts.Complete();
_response = new ServiceResponse("Record successfully created!!", MessageType.Success, true, "Edit");
return(_response);
}
}
catch (SqlException ex)
{
_response = new ServiceResponse(ServiceResponsesProvider.SqlExceptionMessage(ex), MessageType.SqlException, false);
}
catch (Exception ex)
{
_response = new ServiceResponse(ex.Message, MessageType.Exception, false, "Edit");
}
return(_response);
}