public ActionResult ActionSaveUpdate(AirPackageInquiryModel model, string tranMode)
{
int id = model.PId;
string saveMode = string.Empty;
GetViewModel(id, tranMode, true);
string viewPagePath = string.Empty;
string vucPagePath = "VUC_Add";
if (ModelState.IsValid)
{
try
{
_response = _provider.ActionSaveUpdate(model, tranMode);
}
catch (Exception ex)
{
_response = new ServiceResponse(ex.Message, MessageType.Exception, false);
}
}
else
{
_response = new ServiceResponse("Invalid Fields. Please fill mandatory fields!!", MessageType.Error, false);
}
TempData["ActionResponse"] = _response;
if (Request.IsAjaxRequest())
{
return(PartialView(vucPagePath, _modObj));
}
else
{
return(View(viewPagePath, _modObj));
}
}
private AirPackageInquiryModel GetViewModel(int id, string tranMode, bool isPost = false)
{
///tranMode = "N" , "U", "L", "V"
if (id != 0 && isPost == false)
{
_modObj = _provider.GetDetails(id);
}
_modObj.packageDetail = new ATLTravelPortal.Repository.PackageProvider().GetDetail(_modObj.PackageId);
SetUpFormParams(tranMode);
return(_modObj);
}
public ActionResult Add(AirPackageInquiryModel model)
{
//return ActionSaveUpdate(model, "N");
ActionSaveUpdate(model, "N");
if (_response.ResponseStatus == true)
{
return(RedirectToAction("Index"));
}
else
{
return(View("Add", _modObj));
}
}
public ServiceResponse Edit(AirPackageInquiryModel model)
{
try
{
using (var ts = new TransactionScope(TransactionScopeOption.Required))
{
var result = _ent.Core_PackagesInquiries.Where(x => x.PackagesInquiryId == model.PId).FirstOrDefault();
if (result != null)
{
result.PackagesInquiryId = model.PId;
result.AgentId = model.AgentId;
result.PackageId = model.PackageId;
result.Title = model.Title;
result.TravelDate = model.TravelDate;
result.Name = model.Name;
result.EmailAddress = model.EmailAddress;
result.NoOfAdult = model.NoOfAdult;
result.NoOfChild = model.NoOfChild;
result.ContactNo = model.ContactNo;
result.Remark = model.Remark;
result.CreatedBy = model.CreatedBy;
result.CreatedDate = model.CreatedDate;
_ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
_ent.SaveChanges();
}
ts.Complete();
_response = new ServiceResponse("Record successfully updated!!", MessageType.Success, true, "Edit");
}
}
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);
}
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);
}
public AirPackageInquiryModel GetDetails(int PId)
{
var result = _ent.Core_PackagesInquiries.Where(x => x.PackagesInquiryId == PId).FirstOrDefault();
AirPackageInquiryModel obj = new AirPackageInquiryModel
{
PId = result.PackagesInquiryId,
AgentId = result.AgentId,
PackageId = result.PackageId,
PackageName = result.PackageId == -1?result.PackageName : result.Air_Packages.Name,
Title = result.Title,
TravelDate = result.TravelDate,
Name = result.Name,
EmailAddress = result.EmailAddress,
NoOfAdult = result.NoOfAdult,
NoOfChild = result.NoOfChild,
ContactNo = result.ContactNo,
Remark = result.Remark,
CreatedBy = result.CreatedBy,
CreatedDate = result.CreatedDate,
};
return(obj);
}
public IEnumerable <AirPackageInquiryModel> GetList()
{
int sno = 0;
List <AirPackageInquiryModel> model = new List <AirPackageInquiryModel>();
var result = (from a in _ent.Core_PackagesInquiries
join b in _ent.Air_Packages on a.PackageId equals b.PackageId
select new{ a, PackageName = b.Name }
)
.OrderBy(x => x.PackageName).OrderByDescending(x => x.a.CreatedDate);
foreach (var item in result)
{
sno++;
AirPackageInquiryModel obj = new AirPackageInquiryModel
{
SNO = sno,
PId = item.a.PackagesInquiryId,
AgentId = item.a.AgentId,
PackageId = item.a.PackageId,
//PackageName = item.PackageName,
PackageName = item.a.PackageId == -1? item.a.PackageName : item.a.Air_Packages.Name,
Title = item.a.Title,
TravelDate = item.a.TravelDate,
Name = item.a.Name,
EmailAddress = item.a.EmailAddress,
NoOfAdult = item.a.NoOfAdult,
NoOfChild = item.a.NoOfChild,
ContactNo = item.a.ContactNo,
Remark = item.a.Remark,
CreatedBy = item.a.CreatedBy,
CreatedDate = item.a.CreatedDate,
};
model.Add(obj);
}
return(model.AsEnumerable());
}
public ServiceResponse ActionSaveUpdate(AirPackageInquiryModel model, string tranMode)
{
try
{
if (tranMode == "N")
{
return(Save(model));
}
else if (tranMode == "U")
{
return(Edit(model));
}
}
catch (SqlException ex)
{
_response = new ServiceResponse(ServiceResponsesProvider.SqlExceptionMessage(ex), MessageType.SqlException, false);
}
catch (Exception ex)
{
_response = new ServiceResponse(ex.Message, MessageType.Exception, false);
}
return(_response);
}
public ActionResult Edit(int id, AirPackageInquiryModel model)
{
model.PId = id;
return(ActionSaveUpdate(model, "U"));
}
public ActionResult Page(int?page, string extraParams)
{
_modObj = GetViewModelList(page);
return(View("Index", _modObj));
}
