public ServiceResponse Edit(AirOfflineSettingModel model)
{
using (var ts = new TransactionScope(TransactionScopeOption.Required))
{
try
{
foreach (var item in model.AirlineList)
{
var result = _entity.Air_OffLineAirlineSettings.Where(x => x.OfflineAirlineSettingId == item.PId).FirstOrDefault();
if (result != null)
{
result.IsOffline = item.IsOffline;
_entity.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
_entity.SaveChanges();
}
}
ts.Complete();
_response = new ServiceResponse("Record successfully created!!", MessageType.Success, true, "Edit");
}
catch (Exception ex)
{
_response = new ServiceResponse("Error occured while editing record!!", MessageType.Warning, false, "Edit");
return(_response);
}
return(_response);
}
}
public void LockUserNow(String UserName)
{
var obj = ent.aspnet_Membership.Where(x => x.aspnet_Users.UserName == UserName).ToList().LastOrDefault();
obj.IsLockedOut = true;
ent.ApplyCurrentValues(obj.EntityKey.EntitySetName, obj);
ent.SaveChanges();
}
public void Air_GroupBookingStatusUpdate(GroupBookingReportModel model)
{
Air_GroupBooking result = ent.Air_GroupBooking.Where(x => x.GroupBookingId == model.GroupBookingId).FirstOrDefault();
result.GroupBookingStatusId = model.StatusId;
ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
ent.SaveChanges();
}
public BusMessageModel Edit(BusScheduleModel model)
{
if (IsExists(model.ScheduleId, model.BusMasterId, model.BusCategoryId, model.DepartureCityId, model.DestinationCityId, model.DepartureTime) == false)
{
var obj = _ent.Bus_Schedules.Where(x => x.ScheduleId == model.ScheduleId).FirstOrDefault();
if (obj != null)
{
obj.ArrivalTime = model.ArrivalTime;
obj.BusCategoryId = model.BusCategoryId;
obj.BusMasterId = model.BusMasterId;
obj.DepartureCityId = model.DepartureCityId;
obj.DepartureTime = model.DepartureTime;
obj.DestinationCityId = model.DestinationCityId;
obj.Friday = model.Friday;
obj.Monday = model.Monday;
obj.Saturday = model.Saturday;
obj.Sunday = model.Sunday;
obj.Thursday = model.Thursday;
obj.Tuesday = model.Tuesday;
obj.Wednesday = model.Wednesday;
obj.GovRate = model.Rate;
obj.ActualRate = model.ActualRate;
obj.KM = model.KiloMeter;
obj.UpdateBy = ATLTravelPortal.Repository.GeneralRepository.LogedUserId();
obj.UpdateDate = ATLTravelPortal.Repository.GeneralRepository.CurrentDate();
obj.BusType = model.TypeName;
obj.DurationHHMM = model.DurationHHMM;
obj.PurchaseRate = model.PurchaseRate;
obj.AgentCommission = model.AgentCommission;
_ent.ApplyCurrentValues(obj.EntityKey.EntitySetName, obj);
_ent.SaveChanges();
_res.ActionMessage = String.Format(Resources.Message.SuccessfullyUpdated, "Bus Schedule ");
_res.MsgNumber = 0;
_res.MsgStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Bus Schedule ");
_res.MsgNumber = 1005;
_res.ErrSource = "DataBase";
_res.MsgType = 3;
_res.MsgStatus = true;
}
}
else
{
_res.ActionMessage = String.Format(Resources.Message.AlreadyExist, "Bus Schedule ");
_res.MsgNumber = 1001;
_res.ErrSource = "DataBase";
_res.MsgType = 3;
_res.MsgStatus = true;
}
return(_res);
}
public void UpdateEmail(AdminUserManagementModel.CreateAdminAspUser model)
{
aspnet_Membership tu = db.aspnet_Membership.Where(u => u.UserId == model.UserId).FirstOrDefault();
tu.UserId = model.UserId;
tu.Email = model.GetEmail.Email;
tu.LoweredEmail = model.GetEmail.Email;
db.ApplyCurrentValues(tu.EntityKey.EntitySetName, tu);
db.SaveChanges();
/////
}
public void UpdateBranch(BankManagementsModel model)
{
BankBranches result = _ent.BankBranches.Where(x => x.BankBranchId == model.BankBranchId).FirstOrDefault();
result.BranchAddress = model.BranchAddress;
result.BranchName = model.BranchName;
result.ContactPerson = model.BranchContactPerson;
result.PhoneNumber = model.BranchPhoneNumber;
result.ContactPersonPhoneNo = model.BranchContactPhoneNo;
result.ContactPersonEmail = model.BranchContactEmail;
result.CountryId = model.BranchCountryId;
_ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
_ent.SaveChanges();
}
public void UpdateHtl_BookingRecord(HotelOfflineBookModel model)
{
int AgntiId = _ent.Htl_BookingRecord.FirstOrDefault(x => x.BookingRecordId == model.BookingRecordId).AgentId;
_ent.Htl_SaveSalesTransaction(Repository.HotelGeneralRepository.getIPAddress(), model.BookingRecordId, AgntiId, ATLTravelPortal.Repository.GeneralRepository.LogedUserId());
Htl_BookingRecord result = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == model.BookingRecordId).FirstOrDefault();
result.TicketStatusId = 16;
result.GDSBookingId = model.GDSBookingId;
result.BookingReferenceNo = model.BookingReferenceNo;
result.BookingConformationNo = model.BookingConformationNo;
_ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
_ent.SaveChanges();
}
public void Approve(long Id, int userid)
{
//GL_Transactions result = ent.GL_Transactions.Where(x => x.VoucherNo == Id).FirstOrDefault();
List <GL_Transactions> result = ent.GL_Transactions.Where(x => x.VoucherNo == Id).ToList();
foreach (var rslt in result)
{
rslt.TranStatusId = 2;
rslt.CheckerId = userid;
rslt.CheckerDate = DateTime.Now;
ent.ApplyCurrentValues(rslt.EntityKey.EntitySetName, rslt);
ent.SaveChanges();
}
}
public void DeleteVoucher(Int64 voucherno, LedgerVoucherModel model)
{
List <GL_Transactions> result = ent.GL_Transactions.Where(x => x.VoucherNo == voucherno).ToList();
foreach (var item in result)
{
item.TranStatusId = 4;
item.DeletedBy = model.DeletedBy;
item.DeletedDate = DateTime.Now;
item.DeletedRemark = GetFormattedRemark(item.DeletedRemark, model.DeleteRemark, model.DeletedBy ?? 0);
item.DeletedTerminalId = model.CheckerTerminal;
ent.ApplyCurrentValues(item.EntityKey.EntitySetName, item);
ent.SaveChanges();
}
}
//for edit
public ActionResponse Edit(AdminBankAccountModel model)
{
if (IsExists(model.AdminBankId, model.BankId, model.BankBranchId, model.AccountNumber) == false)
{
Core_AdminBanks result = _ent.Core_AdminBanks.Where(x => x.AdminBankId == model.AdminBankId).FirstOrDefault();
result.AdminBankId = model.AdminBankId;
result.BankId = model.BankId;
result.BankBranchId = model.BankBranchId;
result.BankAccountTypeId = model.BankAccountTypeId;
result.AccountName = model.AccountName;
result.AccountNumber = model.AccountNumber;
_ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
_ent.SaveChanges();
_res.ActionMessage = String.Format(Resources.Message.SuccessfullyUpdated, "Bank detail");
_res.ErrNumber = 0;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.AlreadyExist, "Bank detail");
_res.ErrNumber = 1001;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
return(_res);
}
public ActionResponse Edit(CardValueModel model)
{
if (IsExists(model.CardValueId, model.CardValue) == false)
{
var result = _ent.MRC_CardValue.Where(x => x.CardValueId == model.CardValueId).FirstOrDefault();
result.CardValue = (double)model.CardValue;
result.CardValueDesc = model.CardValueDesc;
result.IsActive = model.IsActive;
result.ModifiedBy = ATLTravelPortal.Repository.GeneralRepository.LogedUserId();
result.ModifiedDate = ATLTravelPortal.Repository.GeneralRepository.CurrentDate();
if (result != null)
{
_ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
_ent.SaveChanges();
}
_res.ActionMessage = String.Format(Resources.Message.SuccessfullyUpdated, "Card Value");
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ErrNumber = 0;
_res.ResponseStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.AlreadyExist, "Card Value");
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ErrNumber = 0;
_res.ResponseStatus = true;
}
return(_res);
}
public bool UpdateBusPNRModel(BusPNRModel model)
{
Bus_PNRs bus_PNRs = _ent.Bus_PNRs.Where(x => x.BusPNRId == model.BusPNRId).FirstOrDefault();
//int _discountRate = int.Parse(System.Configuration.ConfigurationManager.AppSettings["BusDiscount"].ToString());
bus_PNRs.Prefix = model.Prefix;
bus_PNRs.FullName = model.FullName;
bus_PNRs.PhoneNumber = model.PhoneNumber;
bus_PNRs.ContactAddress = model.ContactAddress;
bus_PNRs.MobileNumber = model.MobileNumber;
bus_PNRs.EmailAddress = model.EmailAddress;
bus_PNRs.Type = model.Type;
bus_PNRs.BusCategoryId = model.BusCategoryId;
bus_PNRs.BusMasterId = model.BusMasterId;
bus_PNRs.DepartureDate = model.DepartureDate;
bus_PNRs.DepartureTime = model.DepartureTime;
bus_PNRs.BusNo = model.BusNo;
bus_PNRs.HideServiceCharge = model.HideServiceCharge;
_ent.ApplyCurrentValues(bus_PNRs.EntityKey.EntitySetName, bus_PNRs);
if (bus_PNRs.Bus_Passengers != null)
{
foreach (var pax in model.Passengers)
{
Bus_Passengers paxToUpdate = _ent.Bus_Passengers.Where(x => x.BusPassengerId == pax.BusPassengerId).FirstOrDefault();
if (paxToUpdate.IsPrimary)
{
paxToUpdate.PassengerName = model.Prefix + " " + model.FullName;
paxToUpdate.MobileNumber = model.MobileNumber;
paxToUpdate.Fare = pax.Fare - paxToUpdate.Markup;
paxToUpdate.PickupPoint = pax.PickupPoint;
paxToUpdate.TicketNumber = pax.TicketNumber;
paxToUpdate.SeatNoalias = pax.SeatNumber;
paxToUpdate.IsPrimary = true;
//paxToUpdate.DiscountAmount = (pax.Fare * _discountRate) / 100;
_ent.ApplyCurrentValues(paxToUpdate.EntityKey.EntitySetName, paxToUpdate);
}
else
{
paxToUpdate.PassengerName = pax.PassengerName == null ? "" : pax.PassengerName;
paxToUpdate.MobileNumber = pax.MobileNumber == null ? "" : pax.MobileNumber;
paxToUpdate.Fare = pax.Fare - paxToUpdate.Markup;
paxToUpdate.PickupPoint = pax.PickupPoint;
paxToUpdate.TicketNumber = pax.TicketNumber;
paxToUpdate.SeatNoalias = pax.SeatNumber;
//paxToUpdate.DiscountAmount = (pax.Fare * _discountRate) / 100;
_ent.ApplyCurrentValues(paxToUpdate.EntityKey.EntitySetName, paxToUpdate);
}
}
}
_ent.SaveChanges();
return(true);
}
public void SaveConfigureAccount(int AccountConfId, int ProductId, int LedgerId)
{
GL_AccountConf result = ent.GL_AccountConf.Where(x => x.AccountConfId == AccountConfId).FirstOrDefault();
result.ProductId = ProductId;
result.MappedLedgerId = LedgerId;
ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
ent.SaveChanges();
}
public ApplicationSettingViewModel Update(ApplicationSettingViewModel model, out ActionResponse _ores)
{
if (model.ProductId != null)
{
AppSettings obj = _ent.AppSettings.Where(u => u.ProductId == model.ProductId).FirstOrDefault();
if (obj != null)
{
obj.ProductId = model.ProductId;
obj.EnablePasswordRetrieval = model.EnablePasswordRetrieval;
obj.EnablePasswordReset = model.EnablePasswordReset;
obj.RequiresQuestionAndAnswer = model.RequiresQuestionAndAnswer;
obj.RequiresUniqueEmail = model.RequiresUniqueEmail;
obj.MaxInvalidPasswordAttempts = model.MaxInvalidPasswordAttempts;
obj.MinRequiredPasswordLength = model.MinRequiredPasswordLength;
obj.MinRequiredNonalphanumericCharacters = model.MinRequiredNonalphanumericCharacters;
obj.PasswordAttemptWindow = model.PasswordAttemptWindow;
obj.AppDateFormat = model.AppDateFormat;
obj.SMTPServer = model.SMTPServer;
obj.SMTPPort = model.SMTPPort;
obj.SMTPUsername = model.SMTPUsername;
obj.SMTPPassword = model.SMTPPassword;
obj.EnableExpirePasswordWhenUserNotLoginFromDays = model.EnableExpirePasswordWhenUserNotLoginFromDays;
obj.EnableAutoExpirePassword = model.EnableAutoExpirePassword;
obj.AutoPasswordExpiryInDays = model.AutoPasswordExpiryInDays;
obj.ShowPassowrdExpireNotificationBeforeDays = model.ShowPassowrdExpireNotificationBeforeDays;
obj.Paggination = model.Paggination;
_ent.ApplyCurrentValues(obj.EntityKey.EntitySetName, obj);
_ent.SaveChanges();
_res.ActionMessage = String.Format(Resources.Message.SuccessfullyUpdated, "Application Setting");
_res.ErrNumber = 0;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Application Setting");
_res.ErrNumber = 1005;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
}
else
{
_res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Application Setting");
_res.ErrNumber = 1005;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
_ores = _res;
return(model);
/////
}
//for edit
public void EditLedgerMaster(LedgerMasterModel model)
{
GL_Ledgers result = ent.GL_Ledgers.Where(x => x.LedgerId == model.LedgerId).FirstOrDefault();
result.LedgerId = model.LedgerId;
result.ProductId = model.ProductId;
result.AccGroupId = model.AccGroupId;
result.AccSubGroupId = model.AccSubGroupId;
result.AccTypeId = model.AccTypeId;
result.Id = model.ddlAirLines;
result.LedgerName = model.LedgerName;
ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
ent.SaveChanges();
}
//for edit
public void EditBank(BankModel model)
{
Banks result = ent.Banks.Where(x => x.BankId == model.BankId).FirstOrDefault();
result.BankId = model.BankId;
result.BankName = model.BankName;
result.BankAddress = model.BankAddress;
result.PhoneNo = model.PhoneNo;
result.ContactPerson = model.ContactPerson;
result.ContactPersonPhoneNo = model.ContactPersonPhoneNo;
result.ContactPersonMobileNo = model.ContactPersonMobileNo;
result.ContactPersonEmail = model.ContactPersonEmail;
result.CountryId = model.CountryId;
ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
ent.SaveChanges();
}
/// <summary>
/// For Editing Message supply the MessageBoardId
/// </summary>
/// <param name="model"></param>
public AgentMessageBoardModel Edit(AgentMessageBoardModel model, int[] ChkAgentId, int[] ChkProductId, out ActionResponse _ores)
{
_res = Validate(model, ChkAgentId, ChkProductId);
if (_res.ErrNumber == 0)
{
var result = _ent.AgentMessageBoards.Where(x => x.MessageBoardId == model.MessageBoardId).FirstOrDefault();
if (result != null)
{
result.UpdatedBy = model.UpdatedBy;
result.UpdatedDate = model.UpdatedDate;
result.AgentIdList = model.AgentIdList.TrimEnd(',');
result.HeadingContent = model.HeadContains;
result.MessageContent = model.MessageContains;
result.MessagePriorityId = model.PriorityId;
result.MessageTypeId = model.MessageTypeId;
result.ExpireOn = (DateTime)model.ExpiredOn;
result.EffectiveFrom = (DateTime)model.EffectiveFrom;
result.MessageCategoryId = model.MessageCatagoriesId;
//result.ProductIdList = "1";
result.ProductIdList = model.ProductIdList.TrimEnd(',');
_ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
_ent.SaveChanges();
_res.ActionMessage = String.Format(Resources.Message.SuccessfullyUpdated, "Message");
_res.ErrNumber = 0;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Message");
_res.ErrNumber = 2000;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
}
_ores = _res;
return(model);
}
public ActionResponse Approve(int?FXRateId)
{
if (FXRateId != null)
{
Core_FXRate result = ent.Core_FXRate.Where(x => x.FXRateId == FXRateId).FirstOrDefault();
result.isApproved = true;
ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
ent.SaveChanges();
_res.ActionMessage = String.Format(Resources.Message.SuccessfullyApproved, "FX Rate");
_res.ErrNumber = 0;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "FX Rate");
_res.ErrNumber = 2000;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
return(_res);
}
public BusMessageModel Edit(BusCityModel model)
{
if (IsExists(model.BusCityId, model.BusCityName) == false)
{
var obj = _ent.Bus_Cities.Where(x => x.BusCityId == model.BusCityId).FirstOrDefault();
if (obj != null)
{
obj.BusCityName = model.BusCityName;
obj.BusCityCode = model.BusCityCode;
_ent.ApplyCurrentValues(obj.EntityKey.EntitySetName, obj);
_ent.SaveChanges();
_res.ActionMessage = String.Format(Resources.Message.SuccessfullyUpdated, "Bus City ");
_res.MsgNumber = 0;
_res.MsgStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "Bus City ");
_res.MsgNumber = 1005;
_res.ErrSource = "DataBase";
_res.MsgType = 3;
_res.MsgStatus = true;
}
}
else
{
_res.ActionMessage = String.Format(Resources.Message.AlreadyExist, "Bus City ");
_res.MsgNumber = 1001;
_res.ErrSource = "DataBase";
_res.MsgType = 3;
_res.MsgStatus = true;
}
return(_res);
}
//public bool IssueTicket(Int64 PNRId, int UserId)
//{
// string GDSRefNo = ent.PNRs.Where(x => x.PNRId == PNRId).FirstOrDefault().GDSRefrenceNumber;
// Abacus.Ticketing.TicketIssueManager manager = new Abacus.Ticketing.TicketIssueManager();
// try
// {
// var retriveData = BookingManager.RetrievePNR(GDSRefNo);
// if (string.IsNullOrEmpty(retriveData.PassengerList.FirstOrDefault().TicketNumber))
// {
// retriveData = manager.IssueTicket(GDSRefNo, (decimal)0);
// }
// int TicketStatusId = ent.PNRs.Where(x => x.PNRId == PNRId).FirstOrDefault().TicketStatusId;
// if (TicketStatusId != 4)
// {
// var dbPassengerList = ent.Passengers.Where(x => x.PNRId == PNRId && x.isDeleted == false).ToArray();
// int paxCounter = 0;
// foreach (var item in retriveData.PassengerList)
// {
// Passengers pass = dbPassengerList.ElementAt(paxCounter);
// pass.TicketNumber = item.TicketNumber;
// ent.ApplyCurrentValues(pass.EntityKey.EntitySetName, pass);
// ent.SaveChanges();
// paxCounter++;
// }
// ent.Air_IssueTickets(PNRId, UserId);
// }
// return true;
// }
// catch (GDS.GDSException ex)
// {
// throw ex;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public bool IssueTicket(Int64 PNRId, int UserId)
{
var result = ent.PNRs.Where(x => x.PNRId == PNRId).FirstOrDefault();
if (result != null)
{
string GDSRefNo = result.GDSRefrenceNumber;
Abacus.Ticketing.TicketIssueManager manager = new Abacus.Ticketing.TicketIssueManager();
try
{
var retriveData = BookingManager.RetrievePNR(GDSRefNo, null);
if (string.IsNullOrEmpty(retriveData.PassengerList.FirstOrDefault().TicketNumber))
{
retriveData = manager.IssueTicket(GDSRefNo, (decimal)0);
}
int TicketStatusId = ent.PNRs.Where(x => x.PNRId == PNRId).FirstOrDefault().TicketStatusId;
if (TicketStatusId != 4)
{
var dbPassengerList = ent.Passengers.Where(x => x.PNRId == PNRId && x.isDeleted == false).ToArray();
int paxCounter = 0;
foreach (var item in retriveData.PassengerList)
{
Passengers pass = dbPassengerList.ElementAt(paxCounter);
pass.TicketNumber = item.TicketNumber;
ent.ApplyCurrentValues(pass.EntityKey.EntitySetName, pass);
ent.SaveChanges();
paxCounter++;
}
ent.Air_IssueTickets(PNRId, UserId);
}
return(true);
}
catch (GDS.GDSException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
else
{
string GDSRefNo = ent.TBO_PNRs.Where(x => x.MPNRId == PNRId).FirstOrDefault().RecLoc;
Abacus.Ticketing.TicketIssueManager manager = new Abacus.Ticketing.TicketIssueManager();
try
{
var retriveData = BookingManager.RetrievePNR(GDSRefNo, null);
if (string.IsNullOrEmpty(retriveData.PassengerList.FirstOrDefault().TicketNumber))
{
retriveData = manager.IssueTicket(GDSRefNo, (decimal)0);
}
int TicketStatusId = ent.TBO_MasterPNRs.Where(x => x.MPNRId == PNRId).FirstOrDefault().TicketStatusId;
if (TicketStatusId != 4 || TicketStatusId != 16 || TicketStatusId != 19)
{
var dbPassengerList = ent.TBO_Passengers.Where(x => x.MPNRId == PNRId && x.IsDeleted == false).ToArray();
int paxCounter = 0;
foreach (var item in retriveData.PassengerList)
{
TBO_Passengers pass = dbPassengerList.ElementAt(paxCounter);
TBO_PNRTickets tickets = pass.TBO_PNRTickets.FirstOrDefault();
tickets.TicketNumber = item.TicketNumber;
ent.ApplyCurrentValues(tickets.EntityKey.EntitySetName, tickets);
ent.SaveChanges();
paxCounter++;
}
ent.TBO_Air_IssueTickets(PNRId, UserId);
}
return(true);
}
catch (GDS.GDSException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
}