public void update_Cancelled(Guid Id, string CancelNotes) { WebDBConnection.Update(db.Database, "Payments", DBConnection.getSqlParameter(PaymentsModel.COL_Id.Name, Id), DBConnection.getSqlParameter(PaymentsModel.COL_Cancelled.Name, 1), DBConnection.getSqlParameter(PaymentsModel.COL_CancelNotes.Name, CancelNotes) ); ActivityLogsController.AddEditLog(db, Session, Id, string.Format(PaymentsModel.COL_CancelNotes.LogDisplay, CancelNotes)); //Adjust sale invoice due amount List <PaymentItemsModel> paymentItems = PaymentItemsController.get(null, Id); List <SaleInvoicesModel> saleInvoices; foreach (PaymentItemsModel paymentitem in paymentItems) { saleInvoices = SaleInvoicesController.get(Session, paymentitem.ReferenceId.ToString()); if (saleInvoices.Count > 0) { WebDBConnection.Update(db.Database, "SaleInvoices", DBConnection.getSqlParameter(SaleInvoicesModel.COL_Id.Name, saleInvoices[0].Id), DBConnection.getSqlParameter(SaleInvoicesModel.COL_Due.Name, saleInvoices[0].Due + paymentitem.Amount) ); } } db.SaveChanges(); }
public static void update_OnlineToken(DBContext db, string Id, string OnlineToken) { WebDBConnection.Update(db.Database, "UserAccounts", DBConnection.getSqlParameter(UserAccountsModel.COL_Id.Name, new Guid(Id)), DBConnection.getSqlParameter(UserAccountsModel.COL_OnlineToken.Name, OnlineToken) ); }
public void update_Approved(Guid Id, bool value) { WebDBConnection.Update(db.Database, "Payments", DBConnection.getSqlParameter(PaymentsModel.COL_Id.Name, Id), DBConnection.getSqlParameter(PaymentsModel.COL_Approved.Name, value) ); ActivityLogsController.AddEditLog(db, Session, Id, string.Format(PaymentsModel.COL_Approved.LogDisplay, null, value)); db.SaveChanges(); }
public static void update_Due(HttpSessionStateBase Session, DBContext db, Guid Id, int originalValue, int newValue) { WebDBConnection.Update(db.Database, "SaleInvoices", DBConnection.getSqlParameter(SaleInvoicesModel.COL_Id.Name, Id), DBConnection.getSqlParameter(SaleInvoicesModel.COL_Due.Name, newValue) ); ActivityLogsController.AddEditLog(db, Session, Id, string.Format(SaleInvoicesModel.COL_Due.LogDisplay, originalValue, newValue)); db.SaveChanges(); }
public void updatePassword(UserAccountsModel model, string log) { WebDBConnection.Update(db.Database, "UserAccounts", DBConnection.getSqlParameter(UserAccountsModel.COL_Id.Name, model.Id), DBConnection.getSqlParameter(UserAccountsModel.COL_Password.Name, model.Password), DBConnection.getSqlParameter(UserAccountsModel.COL_ResetPassword.Name, model.ResetPassword) ); ActivityLogsController.AddEditLog(db, Session, model.Id, log); db.SaveChanges(); }
public void update(VouchersModel model, string log) { WebDBConnection.Update(db.Database, "Vouchers", DBConnection.getSqlParameter(VouchersModel.COL_Id.Name, model.Id), DBConnection.getSqlParameter(VouchersModel.COL_Active.Name, model.Active), DBConnection.getSqlParameter(VouchersModel.COL_Code.Name, model.Code), DBConnection.getSqlParameter(VouchersModel.COL_Description.Name, model.Description), DBConnection.getSqlParameter(VouchersModel.COL_Amount.Name, model.Amount) ); ActivityLogsController.AddEditLog(db, Session, model.Id, log); db.SaveChanges(); }
public void update(LessonSessionsModel model, string log) { WebDBConnection.Update(db.Database, "LessonSessions", DBConnection.getSqlParameter(LessonSessionsModel.COL_Id.Name, model.Id), DBConnection.getSqlParameter(LessonSessionsModel.COL_HourlyRates_Rate.Name, model.HourlyRates_Rate), DBConnection.getSqlParameter(LessonSessionsModel.COL_TravelCost.Name, model.TravelCost), DBConnection.getSqlParameter(LessonSessionsModel.COL_TutorTravelCost.Name, model.TutorTravelCost), DBConnection.getSqlParameter(LessonSessionsModel.COL_Review.Name, model.Review), DBConnection.getSqlParameter(LessonSessionsModel.COL_InternalNotes.Name, model.InternalNotes) ); ActivityLogsController.AddEditLog(db, Session, model.Id, log); db.SaveChanges(); }
public void update(FilesModel model, string log) { WebDBConnection.Update(db.Database, "Files", DBConnection.getSqlParameter(FilesModel.COL_Id.Name, model.Id), DBConnection.getSqlParameter(FilesModel.COL_Branches_Id.Name, model.Branches_Id), DBConnection.getSqlParameter(FilesModel.COL_DirectoryName.Name, model.DirectoryName), DBConnection.getSqlParameter(FilesModel.COL_ParentId.Name, model.ParentId), DBConnection.getSqlParameter(FilesModel.COL_Notes.Name, model.Notes) ); ActivityLogsController.AddEditLog(db, Session, model.Id, log); db.SaveChanges(); }
public void update(HourlyRatesModel model, string log) { WebDBConnection.Update(db.Database, "HourlyRates", DBConnection.getSqlParameter(HourlyRatesModel.COL_Id.Name, model.Id), DBConnection.getSqlParameter(HourlyRatesModel.COL_Branches_Id.Name, model.Branches_Id), DBConnection.getSqlParameter(HourlyRatesModel.COL_LessonPackages_Id.Name, model.LessonPackages_Id), DBConnection.getSqlParameter(HourlyRatesModel.COL_UserAccounts_Id.Name, model.UserAccounts_Id), DBConnection.getSqlParameter(HourlyRatesModel.COL_Rate.Name, model.Rate), DBConnection.getSqlParameter(HourlyRatesModel.COL_FullTimeTutorPayrate.Name, model.FullTimeTutorPayrate), DBConnection.getSqlParameter(HourlyRatesModel.COL_Notes.Name, model.Notes) ); ActivityLogsController.AddEditLog(db, Session, model.Id, log); db.SaveChanges(); }
public static void update(DBContext db, HttpSessionStateBase Session, PayrollPaymentItemsModel model) { PayrollPaymentItemsModel originalModel = get(Session, model.Id); string log = string.Empty; log = Helper.append(log, originalModel.HourlyRate, model.HourlyRate, PayrollPaymentItemsModel.COL_HourlyRate.LogDisplay); log = Helper.append(log, originalModel.TutorTravelCost, model.TutorTravelCost, PayrollPaymentItemsModel.COL_TutorTravelCost.LogDisplay); log = Helper.append(log, originalModel.Amount, model.Amount, PayrollPaymentItemsModel.COL_Amount.LogDisplay); if (!string.IsNullOrEmpty(log)) { WebDBConnection.Update(db.Database, "PayrollPaymentItems", DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_Id.Name, model.Id), DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_HourlyRate.Name, model.HourlyRate), DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_TutorTravelCost.Name, model.TutorTravelCost), DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_Amount.Name, model.Amount) ); ActivityLogsController.AddEditLog(db, Session, model.Id, log); db.SaveChanges(); } }
public void update(UserAccountsModel model, string log) { if (model.Roles_List != null) { model.Roles = string.Join(",", model.Roles_List.ToArray()); } if (model.Interest_List != null) { model.Interest = string.Join(",", model.Interest_List.ToArray()); } if (model.Branches_List != null) { model.Branches = string.Join(",", model.Branches_List.ToArray()); } WebDBConnection.Update(db.Database, "UserAccounts", DBConnection.getSqlParameter(UserAccountsModel.COL_Id.Name, model.Id), DBConnection.getSqlParameter(UserAccountsModel.COL_Username.Name, model.Username), DBConnection.getSqlParameter(UserAccountsModel.COL_Fullname.Name, model.Fullname), DBConnection.getSqlParameter(UserAccountsModel.COL_Birthday.Name, model.Birthday), DBConnection.getSqlParameter(UserAccountsModel.COL_Branches_Id.Name, model.Branches_Id), DBConnection.getSqlParameter(UserAccountsModel.COL_Branches.Name, model.Branches), DBConnection.getSqlParameter(UserAccountsModel.COL_Active.Name, model.Active), DBConnection.getSqlParameter(UserAccountsModel.COL_ResetPassword.Name, model.ResetPassword), DBConnection.getSqlParameter(UserAccountsModel.COL_Email.Name, model.Email), DBConnection.getSqlParameter(UserAccountsModel.COL_Address.Name, model.Address), DBConnection.getSqlParameter(UserAccountsModel.COL_Phone1.Name, model.Phone1), DBConnection.getSqlParameter(UserAccountsModel.COL_Phone2.Name, model.Phone2), DBConnection.getSqlParameter(UserAccountsModel.COL_Notes.Name, model.Notes), DBConnection.getSqlParameter(UserAccountsModel.COL_Interest.Name, model.Interest), DBConnection.getSqlParameter(UserAccountsModel.COL_PromotionEvents_Id.Name, model.PromotionEvents_Id), DBConnection.getSqlParameter(UserAccountsModel.COL_Roles.Name, model.Roles) ); updateLoginSession(Session); ActivityLogsController.AddEditLog(db, Session, model.Id, log); db.SaveChanges(); }