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