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