public static void UpdateRevenueEntry(RevenueEntry revenueEntry) { using (var hdc = new HotelDataEntryDataContext()) { try { var entry = hdc.RevenueEntries.Single(item => item.RevenueId == revenueEntry.RevenueId); entry.OccupancyRoom = revenueEntry.OccupancyRoom; entry.FBRevenue = revenueEntry.FBRevenue; entry.SpaRevenue = revenueEntry.SpaRevenue; entry.RoomRevenue = revenueEntry.RoomRevenue; entry.Others = revenueEntry.Others; entry.Total = revenueEntry.Total; entry.UpdateDateTime = DateTime.Now; entry.UpdateUser = revenueEntry.UpdateUser; hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static HotelDataEntryLib.HotelBudget AddHotelEntryListByYear(HotelBudget hotelEntry) { HotelBudget hotelEntrySubmit; using (var hdc = new HotelDataEntryDataContext()) { hotelEntrySubmit = new HotelBudget() { PropertyId = hotelEntry.PropertyId, Year =hotelEntry.Year, UpdateDateTime = DateTime.Now }; hdc.HotelBudgets.InsertOnSubmit(hotelEntrySubmit); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } return hotelEntrySubmit; }
public static void UpdateProperty(Property property) { using (var hdc = new HotelDataEntryDataContext()) { var prop = hdc.Properties.Single(item => item.PropertyId == property.PropertyId); prop.PropertyName = property.PropertyName; prop.PropertyCode = property.PropertyCode; prop.CurrencyId = property.CurrencyId; prop.Status = property.Status; prop.UpdateDateTime = DateTime.Now; try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void UpdateUserProfile(User user) { using (var hdc = new HotelDataEntryDataContext()) { var getUser = (from dataItem in hdc.Users where dataItem.UserId == user.UserId select dataItem).First(); getUser.FirstName = user.FirstName; getUser.LastName = user.LastName; getUser.Email = user.Email; getUser.PropertyId = user.PropertyId; getUser.UpdateDateTime = DateTime.Now; getUser.PermissionId = user.PermissionId; getUser.Status = user.Status; getUser.Position = user.Position; getUser.AccessProperties = user.AccessProperties; getUser.Username = user.Username; try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static HotelDataEntryLib.HotelRevenue AddHotelEntryListByMonthYear(HotelRevenue hotelEntry) { HotelRevenue hotelEntrySubmit; using (var hdc = new HotelDataEntryDataContext()) { hotelEntrySubmit = new HotelRevenue() { PropertyId = hotelEntry.PropertyId, Month = hotelEntry.Month, Year = hotelEntry.Year, UpdateDateTime = DateTime.Now }; hdc.HotelRevenues.InsertOnSubmit(hotelEntrySubmit); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } return(hotelEntrySubmit); }
public static void StoreError(string errMsg, string stacktrace, string Url) { try { using (var hdc = new HotelDataEntryDataContext()) { hdc.Logs.InsertOnSubmit(new HotelDataEntryLib.Log() { ErrorDate = DateTime.Now, ClientIP = HttpContext.Current.Request.UserHostAddress, Detail = stacktrace, Message = errMsg, Url = Url }); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } } catch (Exception ex) { throw ex; } }
public static void AddCurrency(Currency currency) { if (currency.IsBase == 1) { UpdateIsBaseCurrency(); } using (var hdc = new HotelDataEntryDataContext()) { hdc.Currencies.InsertOnSubmit(new HotelDataEntryLib.Currency { CurrencyCode = currency.CurrencyCode, CurrencyName = currency.CurrencyName, UpdateDateTime = DateTime.Now, Status = currency.Status, ConversionRate = currency.ConversionRate, IsBase = currency.IsBase }); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void UpdateCurrency(Currency currency) { if (currency.IsBase == 1) { UpdateIsBaseCurrency(); } using (var hdc = new HotelDataEntryDataContext()) { var cur = hdc.Currencies.Single(item => item.CurrencyId == currency.CurrencyId); cur.CurrencyName = currency.CurrencyName; cur.CurrencyCode = currency.CurrencyCode; cur.Status = currency.Status; cur.ConversionRate = currency.ConversionRate; cur.UpdateDateTime = DateTime.Now; cur.IsBase = currency.IsBase; try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void UpdateBudgetEntry(BudgetEntry budgetEntry) { using (var hdc = new HotelDataEntryDataContext()) { try { var entry = hdc.BudgetEntries.Single(item => item.BudgetId == budgetEntry.BudgetId); entry.OccupancyRoom = budgetEntry.OccupancyRoom; entry.RoomBudget = budgetEntry.RoomBudget; entry.FBBudget = budgetEntry.FBBudget; entry.SpaBudget = budgetEntry.SpaBudget; entry.Others = budgetEntry.Others; entry.Total = budgetEntry.Total; entry.UpdateDateTime = DateTime.Now; entry.UpdateUser = budgetEntry.UpdateUser; hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void AddCurrency(Currency currency) { if (currency.IsBase == 1) { UpdateIsBaseCurrency(); } using (var hdc = new HotelDataEntryDataContext()) { hdc.Currencies.InsertOnSubmit(new HotelDataEntryLib.Currency { CurrencyCode = currency.CurrencyCode, CurrencyName = currency.CurrencyName, UpdateDateTime = DateTime.Now, Status = currency.Status, ConversionRate = currency.ConversionRate, IsBase = currency.IsBase }); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void AddProperty(Property property) { using (var hdc = new HotelDataEntryDataContext()) { hdc.Properties.InsertOnSubmit(new Property { PropertyCode = property.PropertyCode, PropertyName = property.PropertyName, CurrencyId = property.CurrencyId, UpdateDateTime = DateTime.Now, Status = property.Status }); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void AddBudgetEntryListByYear(HotelBudget hotelEntry, string username) { using (var hdc = new HotelDataEntryDataContext()) { for (var i = 0; i < 12; i++) { hdc.BudgetEntries.InsertOnSubmit(new BudgetEntry() { HotelBudgetId = hotelEntry.HotelBudgetId, OccupancyRoom = 0, RoomBudget = 0.00, FBBudget = 0.00, SpaBudget = 0.00, Others = 0.00, Total = 0.00, UpdateDateTime = DateTime.Now, UpdateUser = username, PositionMonth = (i + 1) + "/" + hotelEntry.Year }); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } } }
public static void AddBudgetEntryListByYear(HotelBudget hotelEntry, string username) { using (var hdc = new HotelDataEntryDataContext()) { for (var i = 0; i < 12; i++) { hdc.BudgetEntries.InsertOnSubmit(new BudgetEntry() { HotelBudgetId = hotelEntry.HotelBudgetId, OccupancyRoom = 0, RoomBudget = 0.00, FBBudget = 0.00, SpaBudget = 0.00, Others = 0.00, Total = 0.00, UpdateDateTime = DateTime.Now, UpdateUser = username, PositionMonth = (i+1)+"/"+hotelEntry.Year }); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } } }
public static void StoreError(string errMsg, string stacktrace, string Url) { try { using (var hdc = new HotelDataEntryDataContext()) { hdc.Logs.InsertOnSubmit(new HotelDataEntryLib.Log() { ErrorDate = DateTime.Now, ClientIP = HttpContext.Current.Request.UserHostAddress, Detail = stacktrace, Message = errMsg, Url = Url }); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } } catch (Exception ex) { throw ex; } }
public static void AddProperty(Property property) { using (var hdc = new HotelDataEntryDataContext()) { hdc.Properties.InsertOnSubmit(new Property { PropertyCode = property.PropertyCode, PropertyName = property.PropertyName, CurrencyId = property.CurrencyId, UpdateDateTime = DateTime.Now, Status = property.Status }); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void DeleteUserProfile(int userId) { using (var hdc = new HotelDataEntryDataContext()) { var user = hdc.Users.Single(item => item.UserId == userId); hdc.Users.DeleteOnSubmit(user); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void AddUserProfile(User user) { using (var hdc = new HotelDataEntryDataContext()) { user.UpdateDateTime = DateTime.Now; hdc.Users.InsertOnSubmit(user); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void AddUserProfile(User user) { using (var hdc = new HotelDataEntryDataContext()) { user.UpdateDateTime = DateTime.Now; hdc.Users.InsertOnSubmit(user); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void DeleteUserProfile(int userId) { using (var hdc = new HotelDataEntryDataContext()) { var user = hdc.Users.Single(item => item.UserId == userId); hdc.Users.DeleteOnSubmit(user); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void DeleteCurrency(int currencyId) { using (var hdc = new HotelDataEntryDataContext()) { var currency = hdc.Currencies.Single(item => item.CurrencyId == currencyId); hdc.Currencies.DeleteOnSubmit(currency); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void DeleteProperty(int propertyId) { using (var hdc = new HotelDataEntryDataContext()) { var property = hdc.Properties.Single(item => item.PropertyId == propertyId); hdc.Properties.DeleteOnSubmit(property); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void DeleteProperty(int propertyId) { using (var hdc = new HotelDataEntryDataContext()) { var property = hdc.Properties.Single(item => item.PropertyId == propertyId); hdc.Properties.DeleteOnSubmit(property); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void DeleteCurrency(int currencyId) { using (var hdc = new HotelDataEntryDataContext()) { var currency = hdc.Currencies.Single(item => item.CurrencyId == currencyId); hdc.Currencies.DeleteOnSubmit(currency); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void UpdateIsBaseCurrency() { using (var hdc = new HotelDataEntryDataContext()) { var baseCurrency = hdc.Currencies.Single(item => item.IsBase == 1); if (baseCurrency != null) { baseCurrency.IsBase = 0; try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } } }
public static void AddRevenueEntryListByMonthYear(HotelRevenue hotelEntry, string username) { var dates = GetLastDayOfMonth(hotelEntry.Month, hotelEntry.Year); using (var hdc = new HotelDataEntryDataContext()) { for (var i = 0; i < dates; i++) { hdc.RevenueEntries.InsertOnSubmit(new RevenueEntry() { HotelRevenueId = hotelEntry.HotelRevenueId, OccupancyRoom = 0, RoomRevenue = 0.00, FBRevenue = 0.00, SpaRevenue = 0.00, Others = 0.00, Total = 0.00, UpdateDateTime = DateTime.Now, UpdateUser = username, PositionDate = new DateTime(hotelEntry.Year, hotelEntry.Month, (i + 1)) }); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } } }
public static void AddRevenueEntryListByMonthYear(HotelRevenue hotelEntry, string username) { var dates = GetLastDayOfMonth(hotelEntry.Month,hotelEntry.Year); using (var hdc = new HotelDataEntryDataContext()) { for (var i = 0; i < dates; i++) { hdc.RevenueEntries.InsertOnSubmit(new RevenueEntry() { HotelRevenueId = hotelEntry.HotelRevenueId, OccupancyRoom = 0, RoomRevenue = 0.00, FBRevenue = 0.00, SpaRevenue = 0.00, Others = 0.00, Total = 0.00, UpdateDateTime = DateTime.Now, UpdateUser = username, PositionDate = new DateTime(hotelEntry.Year, hotelEntry.Month, (i + 1)) }); try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } } }
public static void UpdateUserProfile(User user) { using (var hdc = new HotelDataEntryDataContext()) { var getUser = (from dataItem in hdc.Users where dataItem.UserId == user.UserId select dataItem).First(); getUser.FirstName = user.FirstName; getUser.LastName = user.LastName; getUser.Email = user.Email; getUser.PropertyId = user.PropertyId; getUser.UpdateDateTime = DateTime.Now; getUser.PermissionId = user.PermissionId; getUser.Status = user.Status; getUser.Position = user.Position; getUser.AccessProperties = user.AccessProperties; getUser.Username = user.Username; try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void UpdateCurrency(Currency currency) { if (currency.IsBase == 1) { UpdateIsBaseCurrency(); } using (var hdc = new HotelDataEntryDataContext()) { var cur = hdc.Currencies.Single(item => item.CurrencyId == currency.CurrencyId); cur.CurrencyName = currency.CurrencyName; cur.CurrencyCode = currency.CurrencyCode; cur.Status = currency.Status; cur.ConversionRate = currency.ConversionRate; cur.UpdateDateTime = DateTime.Now; cur.IsBase = currency.IsBase; try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void UpdateBudgetEntry(BudgetEntry budgetEntry) { using (var hdc = new HotelDataEntryDataContext()) { try { var entry = hdc.BudgetEntries.Single(item => item.BudgetId == budgetEntry.BudgetId); entry.OccupancyRoom = budgetEntry.OccupancyRoom; entry.RoomBudget = budgetEntry.RoomBudget; entry.FBBudget = budgetEntry.FBBudget; entry.SpaBudget = budgetEntry.SpaBudget; entry.Others = budgetEntry.Others; entry.Total = budgetEntry.Total; entry.UpdateDateTime = DateTime.Now; entry.UpdateUser = budgetEntry.UpdateUser; hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void UpdateIsBaseCurrency() { using (var hdc = new HotelDataEntryDataContext()) { var baseCurrency = hdc.Currencies.Single(item => item.IsBase == 1); if (baseCurrency != null) { baseCurrency.IsBase = 0; try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } } }
public static void UpdateRevenueEntry(RevenueEntry revenueEntry) { using (var hdc = new HotelDataEntryDataContext()) { try { var entry = hdc.RevenueEntries.Single(item => item.RevenueId == revenueEntry.RevenueId); entry.OccupancyRoom = revenueEntry.OccupancyRoom; entry.FBRevenue = revenueEntry.FBRevenue; entry.SpaRevenue = revenueEntry.SpaRevenue; entry.RoomRevenue = revenueEntry.RoomRevenue; entry.Others = revenueEntry.Others; entry.Total = revenueEntry.Total; entry.UpdateDateTime = DateTime.Now; entry.UpdateUser = revenueEntry.UpdateUser; hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }
public static void UpdateProperty(Property property) { using (var hdc = new HotelDataEntryDataContext()) { var prop = hdc.Properties.Single(item => item.PropertyId == property.PropertyId); prop.PropertyName =property.PropertyName; prop.PropertyCode = property.PropertyCode; prop.CurrencyId = property.CurrencyId; prop.Status = property.Status; prop.UpdateDateTime = DateTime.Now; try { hdc.SubmitChanges(); } catch (SqlException ex) { if (ex.Number == 2601 || ex.Number == 2627) { throw; } } } }