public ActionResult Index(int?page, BusPNRModel _model)
{
UnIssuedTicketRepository _rep = new UnIssuedTicketRepository();
BusGeneralRepository.SetRequestPageRow();
try
{
var ts = (TravelSession)Session["TravelPortalSessionInfo"];
_model.FromDate = Session["FromDate"] == null?DateTime.Now.AddDays(-15) : Convert.ToDateTime(Session["FromDate"]);
_model.ToDate = Session["ToDate"] == null ? DateTime.Now : Convert.ToDateTime(Session["ToDate"]);
ViewData["AgentList"] = new SelectList(defaultProvider.GetAgentList(), "AgentId", "AgentName");
_model.TabularList = _rep.GetPagedIssueList(page, _model.FromDate, _model.ToDate, ts.LoginTypeId);
if (BusGeneralRepository.ActionMessage != null)
{
_res = BusGeneralRepository.ActionMessage;
}
}
catch (Exception ex)
{
_res = BusGeneralRepository.CatchException(ex);
}
_model.Message = _res;
return(View(_model));
}
public BusMessageModel Edit(BusMasterModel model)
{
string _imageName = "";
if (model.LogoImage != null)
{
_res = UploadFileMaster(model.LogoImage, out _imageName);
}
if (_res.MsgNumber > 0)
{
return(_res);
}
if (IsExists(model.BusMasterId, model.BusMasterName) == false)
{
var obj = _ent.Bus_Master.Where(x => x.BusMasterId == model.BusMasterId).FirstOrDefault();
if (obj != null)
{
obj.BusMasterName = model.BusMasterName;
obj.ContactAddress = model.ContactAddress;
obj.ContactPerson = model.ContactPerson;
obj.UpdateBy = ATLTravelPortal.Repository.GeneralRepository.LogedUserId();
obj.UpdateDate = ATLTravelPortal.Repository.GeneralRepository.CurrentDate();
obj.Mobile = model.Mobile;
obj.Phone = model.Phone;
if (!string.IsNullOrEmpty(_imageName.ToString()))
{
obj.LogoUrl = _imageName;
}
_ent.ApplyCurrentValues(obj.EntityKey.EntitySetName, obj);
_ent.SaveChanges();
_res.ActionMessage = String.Format(Resources.Message.SuccessfullyUpdated, "Bus Category ");
_res.MsgNumber = 0;
_res.MsgStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Bus Category ");
_res.MsgNumber = 1005;
_res.ErrSource = "DataBase";
_res.MsgType = 3;
_res.MsgStatus = true;
}
}
else
{
_res.ActionMessage = String.Format(Resources.Message.AlreadyExist, "Bus Category ");
_res.MsgNumber = 1001;
_res.ErrSource = "DataBase";
_res.MsgType = 3;
_res.MsgStatus = true;
}
return(_res);
}
public static BusMessageModel CatchException(Exception ex = null)
{
BusMessageModel _res = new BusMessageModel();
if (ex != null)
{
if (ex.InnerException != null)
{
if (ex.InnerException.Source != null)
{
if (ex.InnerException.Source == ".Net SqlClient Data Provider")
{
SqlException sql = (SqlException)ex.InnerException;
_res.MsgNumber = sql.Number;
_res.ActionMessage = SqlErrorMessage(sql);
_res.MsgType = 2;
_res.MsgStatus = true;
}
else
{
_res.MsgNumber = 50000;
_res.ActionMessage = Resources.SQLErrorMessage.Error;
_res.MsgType = 3;
_res.MsgStatus = true;
}
}
else
{
_res.MsgNumber = 50000;
_res.ActionMessage = Resources.SQLErrorMessage.Error;
_res.MsgType = 3;
_res.MsgStatus = true;
}
}
else
{
_res.MsgNumber = 50000;
_res.ActionMessage = Resources.SQLErrorMessage.Error;
_res.MsgType = 3;
_res.MsgStatus = true;
}
}
else
{
_res.MsgNumber = 1005;
_res.ActionMessage = Resources.Message.UnCompleteForm;
_res.MsgType = 3;
_res.MsgStatus = true;
}
return(_res);
}
public BusMessageModel Create(BusMasterModel model)
{
string _imageName = "";
_res = UploadFileMaster(model.LogoImage, out _imageName);
if (_res.MsgNumber > 0)
{
return(_res);
}
if (IsExists(model.BusMasterId, model.BusMasterName) == false)
{
TravelPortalEntity.Bus_Master obj = new TravelPortalEntity.Bus_Master
{
BusMasterName = model.BusMasterName,
ContactAddress = model.ContactAddress,
ContactPerson = model.ContactPerson,
CreatedBy = ATLTravelPortal.Repository.GeneralRepository.LogedUserId(),
CreatedDate = ATLTravelPortal.Repository.GeneralRepository.CurrentDate(),
Mobile = model.Mobile,
Phone = model.Phone,
LogoUrl = _imageName,
BusMasterEmial = model.Email
};
_ent.AddToBus_Master(obj);
_ent.SaveChanges();
_res.ActionMessage = String.Format(Resources.Message.SuccessfullyCreated, "Bus Category ");
_res.ErrSource = "DataBase";
_res.MsgType = 0;
_res.MsgNumber = 0;
_res.MsgStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.AlreadyExist, "Bus Category ");
_res.MsgNumber = 1001;
_res.ErrSource = "DataBase";
_res.MsgType = 3;
_res.MsgStatus = true;
}
return(_res);
}
public BusMessageModel CancelOnlineIssues(string pnrcode)
{
BusMessageModel _msg = new BusMessageModel();
try
{
using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope(System.Transactions.TransactionScopeOption.Required))
{
//remove status from local database
var OnlineBusPnr = _ent.Bus_PNRs.FirstOrDefault(x => x.PNRNo == pnrcode);
if (OnlineBusPnr == null)
{
_msg.ActionMessage = "Cancellation Failed !!!!";
_msg.ErrSource = "Data";
_msg.MsgNumber = 1001;
_msg.MsgType = 3;
_msg.MsgStatus = true;
return(_msg);
}
BusApi.BusApiClient _api = new BusApi.BusApiClient();
BusApi.IssueCancelRequest _req = new BusApi.IssueCancelRequest()
{
Auth = BusGeneralProvider.AAuth,
Remarks = "Issue Cancelled.",
PNRCode = pnrcode,
PassengerId = null,
IsSingleCancel = false
};
var _spiRes = _api.CancelIssued(_req);
if (_spiRes.Message.Number == 0)
{
OnlineBusPnr.TicketStatusId = 12;
_ent.ApplyCurrentValues(OnlineBusPnr.EntityKey.EntitySetName, OnlineBusPnr);
// change status of bus_passengers table
if (OnlineBusPnr.Bus_Passengers != null)
{
foreach (var itm in OnlineBusPnr.Bus_Passengers)
{
itm.TicketStatusId = 12;
_ent.ApplyCurrentValues(itm.EntityKey.EntitySetName, itm);
}
}
_ent.Bus_CancelTickets(OnlineBusPnr.BusPNRId, 0, 0, false, ATLTravelPortal.Repository.GeneralRepository.LoggedUserId(), 0);
_ent.SaveChanges();
ts.Complete(); _msg.ActionMessage = "Cancellation success !! PNR (" + pnrcode + ")";
_msg.ErrSource = "Data";
_msg.MsgNumber = 1001;
_msg.MsgType = 0;
_msg.MsgStatus = true;
return(_msg);
}
else
{
_msg.ActionMessage = "Cancellation Failed !!!!";
_msg.ErrSource = "Data";
_msg.MsgNumber = 1001;
_msg.MsgType = 3;
_msg.MsgStatus = true;
return(_msg);
}
}
}
catch
{
_msg.ActionMessage = "Cancellation Failed !!!!";
_msg.ErrSource = "Data";
_msg.MsgNumber = 1001;
_msg.MsgType = 3;
_msg.MsgStatus = true;
return(_msg);
}
}
