public string UpdateRouteSchedule()
{
string result = "Failed";
BusApi.BusApiClient _api = new BusApi.BusApiClient();
BusApi.RouteScheduleRequest _req = new BusApi.RouteScheduleRequest();
_req.Auth = BusGeneralProvider.AAuth;
_req.MaxResult = 10000;
_req.OperatorCode = "";
_req.RouteScheduleName = "";
var onlineresult = _api.RouteScheduleList(_req);
if (onlineresult != null && onlineresult.List.Any())
{
var localresult = _ent.OnlineBusRouteSchedule;
foreach (var item in onlineresult.List)
{
bool addnew = true;
foreach (var localitem in localresult)
{
if (item.RouteScheduleCode == localitem.RouteScheduleCode)
{
// edit data....
var editData = _ent.OnlineBusRouteSchedule.FirstOrDefault(x => x.RouteScheduleCode == item.RouteScheduleCode);
editData.RouteScheduleName = item.RouteScheduleName;
editData.RouteScheduleCode = item.RouteScheduleCode;
editData.Operatorcode = item.OperatorCode;
_ent.ApplyCurrentValues(editData.EntityKey.EntitySetName, editData);
//_ent.SaveChanges();
addnew = false;
}
}
if (addnew == true)
{
//add data....
TravelPortalEntity.OnlineBusRouteSchedule obj = new TravelPortalEntity.OnlineBusRouteSchedule
{
RouteScheduleName = item.RouteScheduleName,
RouteScheduleCode = item.RouteScheduleCode,
Operatorcode = item.OperatorCode
};
_ent.AddToOnlineBusRouteSchedule(obj);
//_ent.SaveChanges();
}
}
_ent.SaveChanges();
result = "Updated";
}
return(result);
}
public string UpdateCategory()
{
string result = "Failed";
BusApi.BusApiClient _api = new BusApi.BusApiClient();
BusApi.BusCategoryRequest _req = new BusApi.BusCategoryRequest();
_req.Auth = BusGeneralProvider.AAuth;
_req.MaxResult = 10000;
_req.BusCatagoryName = "";
_req.BusOperatorCode = "";
var onlineresult = _api.CategoryList(_req);
if (onlineresult != null && onlineresult.List.Any())
{
var localresult = _ent.Bus_Categories;
foreach (var item in onlineresult.List)
{
bool addnew = true;
foreach (var localitem in localresult)
{
if (item.CategoryId == localitem.CategoryCode)
{
// edit data....
var editData = _ent.Bus_Categories.FirstOrDefault(x => x.CategoryCode == item.CategoryId);
editData.BusCategoryName = item.CatagoryName;
editData.OperatoCode = item.OperatorId;
_ent.ApplyCurrentValues(editData.EntityKey.EntitySetName, editData);
//_ent.SaveChanges();
addnew = false;
}
}
if (addnew == true)
{
//add data....
TravelPortalEntity.Bus_Categories obj = new TravelPortalEntity.Bus_Categories
{
BusCategoryName = item.CatagoryName,
CategoryCode = item.CategoryId,
OperatoCode = item.OperatorId
};
_ent.AddToBus_Categories(obj);
//_ent.SaveChanges();
}
}
_ent.SaveChanges();
result = "Updated";
}
return(result);
}
public string UpdateCity()
{
string result = "Failed";
BusApi.BusApiClient _api = new BusApi.BusApiClient();
BusApi.BusCityRequest _req = new BusApi.BusCityRequest();
_req.Auth = BusGeneralProvider.AAuth;
_req.MaxResult = 10000;
_req.CityName = "";
var onlineresult = _api.CityList(_req);
if (onlineresult != null && onlineresult.List.Any())
{
var localresult = _ent.Bus_Cities;
foreach (var item in onlineresult.List)
{
bool addnew = true;
foreach (var localitem in localresult)
{
if (item.Value == localitem.BusCityCode)
{
// edit data....
var editData = _ent.Bus_Cities.FirstOrDefault(x => x.BusCityCode == item.Value);
editData.BusCityName = item.Text;
_ent.ApplyCurrentValues(editData.EntityKey.EntitySetName, editData);
//_ent.SaveChanges();
addnew = false;
}
}
if (addnew == true)
{
//add data....
TravelPortalEntity.Bus_Cities obj = new TravelPortalEntity.Bus_Cities
{
BusCityCode = item.Value,
BusCityName = item.Text,
isActive = true,
CreatedBy = ATLTravelPortal.Repository.GeneralRepository.LogedUserId(),
CreatedDate = ATLTravelPortal.Repository.GeneralRepository.CurrentDate()
};
_ent.AddToBus_Cities(obj);
//_ent.SaveChanges();
}
}
_ent.SaveChanges();
result = "Updated";
}
return(result);
}
public string UpdateStation()
{
string result = "Failed";
BusApi.BusApiClient _api = new BusApi.BusApiClient();
BusApi.StationRequest _req = new BusApi.StationRequest();
_req.Auth = BusGeneralProvider.AAuth;
_req.MaxResult = 10000;
_req.StationName = "";
var onlineresult = _api.GetStations(_req);
if (onlineresult != null && onlineresult.List.Any())
{
foreach (var item in onlineresult.List.Where(x => x.StationCode.Trim() != ""))
{
var localresult = _ent.Bus_Stations.FirstOrDefault(x => x.BusStationCode == item.StationCode);
if (localresult != null)
{
localresult.BusStationName = item.StationName;
localresult.BusCityCode = item.CityCode;
localresult.BusCityName = item.CityName;
_ent.ApplyCurrentValues(localresult.EntityKey.EntitySetName, localresult);
}
else
{
//add data....
TravelPortalEntity.Bus_Stations obj = new TravelPortalEntity.Bus_Stations
{
BusCityCode = item.CityCode,
BusCityName = item.CityName,
BusStationCode = item.StationCode,
BusStationName = item.StationName,
};
_ent.AddToBus_Stations(obj);
//_ent.SaveChanges();
}
}
_ent.SaveChanges();
result = "Updated";
}
return(result);
}
public string UpdateOperator()
{
string result = "Failed";
BusApi.BusApiClient _api = new BusApi.BusApiClient();
BusApi.OperatorRequest _req = new BusApi.OperatorRequest();
_req.Auth = BusGeneralProvider.AAuth;
_req.MaxResult = 10000;
_req.OperatorName = "";
var onlineresult = _api.OperatorList(_req);
if (onlineresult != null && onlineresult.List.Any())
{
var localresult = _ent.Bus_Master;
foreach (var item in onlineresult.List)
{
bool addnew = true;
foreach (var localitem in localresult)
{
if (item.Value == localitem.OperatorCode)
{
// edit data....
var editData = _ent.Bus_Master.FirstOrDefault(x => x.OperatorCode == item.Value);
editData.BusMasterName = item.Text;
editData.ContactPerson = "";
editData.ContactAddress = "";
editData.Phone = "";
editData.Mobile = "";
editData.BusMasterEmial = "";
editData.UpdateBy = ATLTravelPortal.Repository.GeneralRepository.LogedUserId();
editData.UpdateDate = ATLTravelPortal.Repository.GeneralRepository.CurrentDate();
//editData.LogoUrl = "";
_ent.ApplyCurrentValues(editData.EntityKey.EntitySetName, editData);
//_ent.SaveChanges();
addnew = false;
}
}
if (addnew == true)
{
//add data....
TravelPortalEntity.Bus_Master obj = new TravelPortalEntity.Bus_Master
{
BusMasterName = item.Text,
OperatorCode = item.Value,
ContactPerson = "",
ContactAddress = "",
Phone = "",
Mobile = "",
BusMasterEmial = "",
CreatedBy = ATLTravelPortal.Repository.GeneralRepository.LogedUserId(),
CreatedDate = ATLTravelPortal.Repository.GeneralRepository.CurrentDate()
};
_ent.AddToBus_Master(obj);
//_ent.SaveChanges();
}
}
_ent.SaveChanges();
result = "Updated";
}
return(result);
}
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);
}
}
