public JsonResult Ajax_GetDetails(Guid id) { UserAccountRolesModel access = UserAccountsController.getUserAccess(Session); List <PaymentItemsModel> models = PaymentItemsController.get(null, id); string content = string.Format(@" <div class='table-responsive'> <table class='table table-striped table-bordered'> <thead> <tr> <th>Invoice</th> <th class='text-right'>Due before</th> <th class='text-right'>Payment</th> <th class='text-right'>Due now</th> </tr> </thead> <tbody> "); string saleInvoiceLink; foreach (PaymentItemsModel model in models) { saleInvoiceLink = !access.SaleInvoices_View ? model.SaleInvoices_No : string.Format("<a href='/SaleInvoices?FILTER_chkDateFrom=false&FILTER_chkDateTo=false&FILTER_Keyword={0}' target='_blank'>{0}</a>", model.SaleInvoices_No); content += string.Format(@" <tr> <td style='width:50px;'>{0}</td> <td class='text-right'>{1:N0}</td> <td class='text-right'><strong>{2:N0}</strong></td> <td class='text-right'>{3:N0}</td> </tr> ", saleInvoiceLink, model.DueBefore, model.Amount, model.DueAfter ); } PaymentsModel payment = get(id); content += string.Format(@" </tbody></table></div> <div class='mt-2'> <div class='h3 ml-2 float-right font-weight-bold'>TOTAL: {0:N0}</div> </div> ", payment.CashAmount + payment.DebitAmount + payment.ConsignmentAmount ); return(Json(new { content = content }, JsonRequestBehavior.AllowGet)); }
public JsonResult Ajax_GetDetails(Guid id) { UserAccountRolesModel access = UserAccountsController.getUserAccess(Session); List <SaleInvoiceItems_InventoryModel> models = SaleInvoiceItems_InventoryController.get(Session, null, null, id); string content = string.Format(@" <div class='table-responsive'> <table class='table table-striped table-bordered'> <thead> <tr> <th>Invoice</th> <th class='text-right' style='width:70px;'>Qty</th> <th class='text-right' style='width:70px;'>Balance</th> </tr> </thead> <tbody> "); string saleInvoiceLink; foreach (SaleInvoiceItems_InventoryModel model in models) { saleInvoiceLink = !access.SaleInvoices_View ? model.SaleInvoices_No : string.Format("<a href='/SaleInvoices?FILTER_chkDateFrom=false&FILTER_chkDateTo=false&FILTER_Keyword={0}' target='_blank'>{0}</a>", model.SaleInvoices_No); content += string.Format(@" <tr> <td>{0}{1}</td> <td class='text-right'>{2:N0}</td> <td class='text-right'>{3:N0}</td> </tr> ", saleInvoiceLink, !model.SaleInvoices_Cancelled ? string.Empty : "<span class='badge badge-warning ml-2' style='width:70px;'>CANCELLED</span>", model.Qty, model.Balance ); } content += string.Format(@" </tbody></table></div> " ); return(Json(new { content = content }, JsonRequestBehavior.AllowGet)); }
public ActionResult Create(UserAccountRolesModel model) { if (ModelState.IsValid) { if (isExists(EnumActions.Create, null, model.Name)) { ModelState.AddModelError(UserAccountRolesModel.COL_Name.Name, $"{model.Name} sudah terdaftar"); } else { model.Id = Guid.NewGuid(); db.UserAccountRoles.Add(model); ActivityLogsController.AddCreateLog(db, Session, model.Id); db.SaveChanges(); return(RedirectToAction(nameof(Edit), new { id = model.Id })); } } return(View(model)); }
public static UserAccountRolesModel getAccesses(UserAccountsModel UserAccount) { UserAccountRolesModel model = new UserAccountRolesModel(); foreach (UserAccountRolesModel item in get(null, UserAccount)) { //Reminders if (item.Reminders_Add) { model.Reminders_Add = true; } if (item.Reminders_Edit) { model.Reminders_Edit = true; } if (item.Reminders_View) { model.Reminders_View = true; } //Birthdays if (item.Birthdays_View) { model.Birthdays_View = true; } //UserAccounts if (item.UserAccounts_Add) { model.UserAccounts_Add = true; } if (item.UserAccounts_Edit) { model.UserAccounts_Edit = true; } if (item.UserAccounts_View) { model.UserAccounts_View = true; } if (item.UserAccounts_ResetPassword) { model.UserAccounts_ResetPassword = true; } if (item.UserAccounts_EditRoles) { model.UserAccounts_EditRoles = true; } if (item.UserAccounts_ViewAllRoles) { model.UserAccounts_ViewAllRoles = true; } //UserAccountRoles if (item.UserAccountRoles_Add) { model.UserAccountRoles_Add = true; } if (item.UserAccountRoles_Edit) { model.UserAccountRoles_Edit = true; } if (item.UserAccountRoles_View) { model.UserAccountRoles_View = true; } //Settings if (item.Settings_Edit) { model.Settings_Edit = true; } if (item.Settings_View) { model.Settings_View = true; } //Branches if (item.Branches_Add) { model.Branches_Add = true; } if (item.Branches_Edit) { model.Branches_Edit = true; } if (item.Branches_View) { model.Branches_View = true; } //PromotionEvents if (item.PromotionEvents_Add) { model.PromotionEvents_Add = true; } if (item.PromotionEvents_Edit) { model.PromotionEvents_Edit = true; } if (item.PromotionEvents_View) { model.PromotionEvents_View = true; } //PettyCashRecordsCategories if (item.PettyCashRecordsCategories_Add) { model.PettyCashRecordsCategories_Add = true; } if (item.PettyCashRecordsCategories_Edit) { model.PettyCashRecordsCategories_Edit = true; } if (item.PettyCashRecordsCategories_View) { model.PettyCashRecordsCategories_View = true; } //Languages if (item.Languages_Add) { model.Languages_Add = true; } if (item.Languages_Edit) { model.Languages_Edit = true; } if (item.Languages_View) { model.Languages_View = true; } //LessonTypes if (item.LessonTypes_Add) { model.LessonTypes_Add = true; } if (item.LessonTypes_Edit) { model.LessonTypes_Edit = true; } if (item.LessonTypes_View) { model.LessonTypes_View = true; } //LessonPackages if (item.LessonPackages_Add) { model.LessonPackages_Add = true; } if (item.LessonPackages_Edit) { model.LessonPackages_Edit = true; } if (item.LessonPackages_View) { model.LessonPackages_View = true; } //Consignments if (item.Consignments_Add) { model.Consignments_Add = true; } if (item.Consignments_Edit) { model.Consignments_Edit = true; } if (item.Consignments_View) { model.Consignments_View = true; } //Vouchers if (item.Vouchers_Add) { model.Vouchers_Add = true; } if (item.Vouchers_Edit) { model.Vouchers_Edit = true; } if (item.Vouchers_View) { model.Vouchers_View = true; } //Suppliers if (item.Suppliers_Add) { model.Suppliers_Add = true; } if (item.Suppliers_Edit) { model.Suppliers_Edit = true; } if (item.Suppliers_View) { model.Suppliers_View = true; } //Units if (item.Units_Add) { model.Units_Add = true; } if (item.Units_Edit) { model.Units_Edit = true; } if (item.Units_View) { model.Units_View = true; } //ExpenseCategories if (item.ExpenseCategories_Add) { model.ExpenseCategories_Add = true; } if (item.ExpenseCategories_Edit) { model.ExpenseCategories_Edit = true; } if (item.ExpenseCategories_View) { model.ExpenseCategories_View = true; } //Services if (item.Services_Add) { model.Services_Add = true; } if (item.Services_Edit) { model.Services_Edit = true; } if (item.Services_View) { model.Services_View = true; } //Products if (item.Products_Add) { model.Products_Add = true; } if (item.Products_Edit) { model.Products_Edit = true; } if (item.Products_View) { model.Products_View = true; } //SaleInvoices if (item.SaleInvoices_Add) { model.SaleInvoices_Add = true; } if (item.SaleInvoices_Edit) { model.SaleInvoices_Edit = true; } if (item.SaleInvoices_View) { model.SaleInvoices_View = true; } if (item.SaleInvoices_Approve) { model.SaleInvoices_Approve = true; } if (item.SaleInvoices_TutorTravelCost_View) { model.SaleInvoices_TutorTravelCost_View = true; } //Payments if (item.Payments_Add) { model.Payments_Add = true; } if (item.Payments_Edit) { model.Payments_Edit = true; } if (item.Payments_View) { model.Payments_View = true; } if (item.Payments_Approve) { model.Payments_Approve = true; } //PettyCashRecords if (item.PettyCashRecords_Add) { model.PettyCashRecords_Add = true; } if (item.PettyCashRecords_Edit) { model.PettyCashRecords_Edit = true; } if (item.PettyCashRecords_View) { model.PettyCashRecords_View = true; } if (item.PettyCashRecords_Approve) { model.PettyCashRecords_Approve = true; } //Inventory if (item.Inventory_Add) { model.Inventory_Add = true; } if (item.Inventory_Edit) { model.Inventory_Edit = true; } if (item.Inventory_View) { model.Inventory_View = true; } //LessonSessions if (item.LessonSessions_Add) { model.LessonSessions_Add = true; } if (item.LessonSessions_Edit) { model.LessonSessions_Edit = true; } if (item.LessonSessions_EditReviewAndInternalNotes) { model.LessonSessions_EditReviewAndInternalNotes = true; } if (item.LessonSessions_View) { model.LessonSessions_View = true; } if (item.LessonSessions_InternalNotes_View) { model.LessonSessions_InternalNotes_View = true; } //HourlyRates if (item.HourlyRates_Add) { model.HourlyRates_Add = true; } if (item.HourlyRates_Edit) { model.HourlyRates_Edit = true; } if (item.HourlyRates_View) { model.HourlyRates_View = true; } //PayrollPayments if (item.PayrollPayments_Add) { model.PayrollPayments_Add = true; } if (item.PayrollPayments_Edit) { model.PayrollPayments_Edit = true; } if (item.PayrollPayments_View) { model.PayrollPayments_View = true; } if (item.PayrollPayments_Approve) { model.PayrollPayments_Approve = true; } //TutorSchedules if (item.TutorSchedules_Add) { model.TutorSchedules_Add = true; } if (item.TutorSchedules_Edit) { model.TutorSchedules_Edit = true; } if (item.TutorSchedules_View) { model.TutorSchedules_View = true; } //StudentSchedules if (item.StudentSchedules_Add) { model.StudentSchedules_Add = true; } if (item.StudentSchedules_Edit) { model.StudentSchedules_Edit = true; } if (item.StudentSchedules_View) { model.StudentSchedules_View = true; } //ClubSchedules if (item.ClubSchedules_Add) { model.ClubSchedules_Add = true; } if (item.ClubSchedules_Edit) { model.ClubSchedules_Edit = true; } if (item.ClubSchedules_View) { model.ClubSchedules_View = true; } //Files if (item.Files_Add) { model.Files_Add = true; } if (item.Files_Edit) { model.Files_Edit = true; } if (item.Files_View) { model.Files_View = true; } if (item.Files_EditGlobal) { model.Files_EditGlobal = true; } //Income Statement if (item.IncomeStatement_View) { model.IncomeStatement_View = true; } if (item.IncomeStatement_ViewProfit) { model.IncomeStatement_ViewProfit = true; } } return(model); }
public ActionResult Edit(UserAccountRolesModel model) { if (ModelState.IsValid) { if (isExists(EnumActions.Edit, model.Id, model.Name)) { ModelState.AddModelError(UserAccountRolesModel.COL_Name.Name, $"{model.Name} sudah terdaftar"); } else { UserAccountRolesModel originalModel = get(model.Id); string log = string.Empty; log = Helper.append(log, originalModel.Name, model.Name, UserAccountRolesModel.COL_Name.LogDisplay); //Reminders log = Helper.append(log, originalModel.Reminders_Notes, model.Reminders_Notes, UserAccountRolesModel.COL_Reminders_Notes.LogDisplay); log = Helper.append(log, originalModel.Reminders_Add, model.Reminders_Add, UserAccountRolesModel.COL_Reminders_Add.LogDisplay); log = Helper.append(log, originalModel.Reminders_Edit, model.Reminders_Edit, UserAccountRolesModel.COL_Reminders_Edit.LogDisplay); log = Helper.append(log, originalModel.Reminders_View, model.Reminders_View, UserAccountRolesModel.COL_Reminders_View.LogDisplay); //Birthdays log = Helper.append(log, originalModel.Birthdays_Notes, model.Birthdays_Notes, UserAccountRolesModel.COL_Birthdays_Notes.LogDisplay); log = Helper.append(log, originalModel.Birthdays_View, model.Birthdays_View, UserAccountRolesModel.COL_Birthdays_View.LogDisplay); //UserAccounts log = Helper.append(log, originalModel.UserAccounts_Notes, model.UserAccounts_Notes, UserAccountRolesModel.COL_UserAccounts_Notes.LogDisplay); log = Helper.append(log, originalModel.UserAccounts_Add, model.UserAccounts_Add, UserAccountRolesModel.COL_UserAccounts_Add.LogDisplay); log = Helper.append(log, originalModel.UserAccounts_Edit, model.UserAccounts_Edit, UserAccountRolesModel.COL_UserAccounts_Edit.LogDisplay); log = Helper.append(log, originalModel.UserAccounts_View, model.UserAccounts_View, UserAccountRolesModel.COL_UserAccounts_View.LogDisplay); log = Helper.append(log, originalModel.UserAccounts_ResetPassword, model.UserAccounts_ResetPassword, UserAccountRolesModel.COL_UserAccounts_ResetPassword.LogDisplay); log = Helper.append(log, originalModel.UserAccounts_EditRoles, model.UserAccounts_EditRoles, UserAccountRolesModel.COL_UserAccounts_EditRoles.LogDisplay); log = Helper.append(log, originalModel.UserAccounts_ViewAllRoles, model.UserAccounts_ViewAllRoles, UserAccountRolesModel.COL_UserAccounts_ViewAllRoles.LogDisplay); //User Account Roles log = Helper.append(log, originalModel.UserAccountRoles_Notes, model.UserAccountRoles_Notes, UserAccountRolesModel.COL_UserAccountRoles_Notes.LogDisplay); log = Helper.append(log, originalModel.UserAccountRoles_Add, model.UserAccountRoles_Add, UserAccountRolesModel.COL_UserAccountRoles_Add.LogDisplay); log = Helper.append(log, originalModel.UserAccountRoles_Edit, model.UserAccountRoles_Edit, UserAccountRolesModel.COL_UserAccountRoles_Edit.LogDisplay); log = Helper.append(log, originalModel.UserAccountRoles_View, model.UserAccountRoles_View, UserAccountRolesModel.COL_UserAccountRoles_View.LogDisplay); //Settings log = Helper.append(log, originalModel.Settings_Notes, model.Settings_Notes, UserAccountRolesModel.COL_Settings_Notes.LogDisplay); log = Helper.append(log, originalModel.Settings_Edit, model.Settings_Edit, UserAccountRolesModel.COL_Settings_Edit.LogDisplay); log = Helper.append(log, originalModel.Settings_View, model.Settings_View, UserAccountRolesModel.COL_Settings_View.LogDisplay); //Branches log = Helper.append(log, originalModel.Branches_Notes, model.Branches_Notes, UserAccountRolesModel.COL_Branches_Notes.LogDisplay); log = Helper.append(log, originalModel.Branches_Add, model.Branches_Add, UserAccountRolesModel.COL_Branches_Add.LogDisplay); log = Helper.append(log, originalModel.Branches_Edit, model.Branches_Edit, UserAccountRolesModel.COL_Branches_Edit.LogDisplay); log = Helper.append(log, originalModel.Branches_View, model.Branches_View, UserAccountRolesModel.COL_Branches_View.LogDisplay); //PromotionEvents log = Helper.append(log, originalModel.PromotionEvents_Notes, model.PromotionEvents_Notes, UserAccountRolesModel.COL_PromotionEvents_Notes.LogDisplay); log = Helper.append(log, originalModel.PromotionEvents_Add, model.PromotionEvents_Add, UserAccountRolesModel.COL_PromotionEvents_Add.LogDisplay); log = Helper.append(log, originalModel.PromotionEvents_Edit, model.PromotionEvents_Edit, UserAccountRolesModel.COL_PromotionEvents_Edit.LogDisplay); log = Helper.append(log, originalModel.PromotionEvents_View, model.PromotionEvents_View, UserAccountRolesModel.COL_PromotionEvents_View.LogDisplay); //PettyCashRecordsCategories log = Helper.append(log, originalModel.PettyCashRecordsCategories_Notes, model.PettyCashRecordsCategories_Notes, UserAccountRolesModel.COL_PettyCashRecordsCategories_Notes.LogDisplay); log = Helper.append(log, originalModel.PettyCashRecordsCategories_Add, model.PettyCashRecordsCategories_Add, UserAccountRolesModel.COL_PettyCashRecordsCategories_Add.LogDisplay); log = Helper.append(log, originalModel.PettyCashRecordsCategories_Edit, model.PettyCashRecordsCategories_Edit, UserAccountRolesModel.COL_PettyCashRecordsCategories_Edit.LogDisplay); log = Helper.append(log, originalModel.PettyCashRecordsCategories_View, model.PettyCashRecordsCategories_View, UserAccountRolesModel.COL_PettyCashRecordsCategories_View.LogDisplay); //Languages log = Helper.append(log, originalModel.Languages_Notes, model.Languages_Notes, UserAccountRolesModel.COL_Languages_Notes.LogDisplay); log = Helper.append(log, originalModel.Languages_Add, model.Languages_Add, UserAccountRolesModel.COL_Languages_Add.LogDisplay); log = Helper.append(log, originalModel.Languages_Edit, model.Languages_Edit, UserAccountRolesModel.COL_Languages_Edit.LogDisplay); log = Helper.append(log, originalModel.Languages_View, model.Languages_View, UserAccountRolesModel.COL_Languages_View.LogDisplay); //LessonTypes log = Helper.append(log, originalModel.LessonTypes_Notes, model.LessonTypes_Notes, UserAccountRolesModel.COL_LessonTypes_Notes.LogDisplay); log = Helper.append(log, originalModel.LessonTypes_Add, model.LessonTypes_Add, UserAccountRolesModel.COL_LessonTypes_Add.LogDisplay); log = Helper.append(log, originalModel.LessonTypes_Edit, model.LessonTypes_Edit, UserAccountRolesModel.COL_LessonTypes_Edit.LogDisplay); log = Helper.append(log, originalModel.LessonTypes_View, model.LessonTypes_View, UserAccountRolesModel.COL_LessonTypes_View.LogDisplay); //LessonPackages log = Helper.append(log, originalModel.LessonPackages_Notes, model.LessonPackages_Notes, UserAccountRolesModel.COL_LessonPackages_Notes.LogDisplay); log = Helper.append(log, originalModel.LessonPackages_Add, model.LessonPackages_Add, UserAccountRolesModel.COL_LessonPackages_Add.LogDisplay); log = Helper.append(log, originalModel.LessonPackages_Edit, model.LessonPackages_Edit, UserAccountRolesModel.COL_LessonPackages_Edit.LogDisplay); log = Helper.append(log, originalModel.LessonPackages_View, model.LessonPackages_View, UserAccountRolesModel.COL_LessonPackages_View.LogDisplay); //Consignments log = Helper.append(log, originalModel.Consignments_Notes, model.Consignments_Notes, UserAccountRolesModel.COL_Consignments_Notes.LogDisplay); log = Helper.append(log, originalModel.Consignments_Add, model.Consignments_Add, UserAccountRolesModel.COL_Consignments_Add.LogDisplay); log = Helper.append(log, originalModel.Consignments_Edit, model.Consignments_Edit, UserAccountRolesModel.COL_Consignments_Edit.LogDisplay); log = Helper.append(log, originalModel.Consignments_View, model.Consignments_View, UserAccountRolesModel.COL_Consignments_View.LogDisplay); //Vouchers log = Helper.append(log, originalModel.Vouchers_Notes, model.Vouchers_Notes, UserAccountRolesModel.COL_Vouchers_Notes.LogDisplay); log = Helper.append(log, originalModel.Vouchers_Add, model.Vouchers_Add, UserAccountRolesModel.COL_Vouchers_Add.LogDisplay); log = Helper.append(log, originalModel.Vouchers_Edit, model.Vouchers_Edit, UserAccountRolesModel.COL_Vouchers_Edit.LogDisplay); log = Helper.append(log, originalModel.Vouchers_View, model.Vouchers_View, UserAccountRolesModel.COL_Vouchers_View.LogDisplay); //Suppliers log = Helper.append(log, originalModel.Suppliers_Notes, model.Suppliers_Notes, UserAccountRolesModel.COL_Suppliers_Notes.LogDisplay); log = Helper.append(log, originalModel.Suppliers_Add, model.Suppliers_Add, UserAccountRolesModel.COL_Suppliers_Add.LogDisplay); log = Helper.append(log, originalModel.Suppliers_Edit, model.Suppliers_Edit, UserAccountRolesModel.COL_Suppliers_Edit.LogDisplay); log = Helper.append(log, originalModel.Suppliers_View, model.Suppliers_View, UserAccountRolesModel.COL_Suppliers_View.LogDisplay); //Units log = Helper.append(log, originalModel.Units_Notes, model.Units_Notes, UserAccountRolesModel.COL_Units_Notes.LogDisplay); log = Helper.append(log, originalModel.Units_Add, model.Units_Add, UserAccountRolesModel.COL_Units_Add.LogDisplay); log = Helper.append(log, originalModel.Units_Edit, model.Units_Edit, UserAccountRolesModel.COL_Units_Edit.LogDisplay); log = Helper.append(log, originalModel.Units_View, model.Units_View, UserAccountRolesModel.COL_Units_View.LogDisplay); //ExpenseCategories log = Helper.append(log, originalModel.ExpenseCategories_Notes, model.ExpenseCategories_Notes, UserAccountRolesModel.COL_ExpenseCategories_Notes.LogDisplay); log = Helper.append(log, originalModel.ExpenseCategories_Add, model.ExpenseCategories_Add, UserAccountRolesModel.COL_ExpenseCategories_Add.LogDisplay); log = Helper.append(log, originalModel.ExpenseCategories_Edit, model.ExpenseCategories_Edit, UserAccountRolesModel.COL_ExpenseCategories_Edit.LogDisplay); log = Helper.append(log, originalModel.ExpenseCategories_View, model.ExpenseCategories_View, UserAccountRolesModel.COL_ExpenseCategories_View.LogDisplay); //Services log = Helper.append(log, originalModel.Services_Notes, model.Services_Notes, UserAccountRolesModel.COL_Services_Notes.LogDisplay); log = Helper.append(log, originalModel.Services_Add, model.Services_Add, UserAccountRolesModel.COL_Services_Add.LogDisplay); log = Helper.append(log, originalModel.Services_Edit, model.Services_Edit, UserAccountRolesModel.COL_Services_Edit.LogDisplay); log = Helper.append(log, originalModel.Services_View, model.Services_View, UserAccountRolesModel.COL_Services_View.LogDisplay); //Products log = Helper.append(log, originalModel.Products_Notes, model.Products_Notes, UserAccountRolesModel.COL_Products_Notes.LogDisplay); log = Helper.append(log, originalModel.Products_Add, model.Products_Add, UserAccountRolesModel.COL_Products_Add.LogDisplay); log = Helper.append(log, originalModel.Products_Edit, model.Products_Edit, UserAccountRolesModel.COL_Products_Edit.LogDisplay); log = Helper.append(log, originalModel.Products_View, model.Products_View, UserAccountRolesModel.COL_Products_View.LogDisplay); //SaleInvoices log = Helper.append(log, originalModel.SaleInvoices_Notes, model.SaleInvoices_Notes, UserAccountRolesModel.COL_SaleInvoices_Notes.LogDisplay); log = Helper.append(log, originalModel.SaleInvoices_Add, model.SaleInvoices_Add, UserAccountRolesModel.COL_SaleInvoices_Add.LogDisplay); log = Helper.append(log, originalModel.SaleInvoices_Edit, model.SaleInvoices_Edit, UserAccountRolesModel.COL_SaleInvoices_Edit.LogDisplay); log = Helper.append(log, originalModel.SaleInvoices_View, model.SaleInvoices_View, UserAccountRolesModel.COL_SaleInvoices_View.LogDisplay); log = Helper.append(log, originalModel.SaleInvoices_Approve, model.SaleInvoices_Approve, UserAccountRolesModel.COL_SaleInvoices_Approve.LogDisplay); log = Helper.append(log, originalModel.SaleInvoices_TutorTravelCost_View, model.SaleInvoices_TutorTravelCost_View, UserAccountRolesModel.COL_SaleInvoices_TutorTravelCost_View.LogDisplay); //Payments log = Helper.append(log, originalModel.Payments_Notes, model.Payments_Notes, UserAccountRolesModel.COL_Payments_Notes.LogDisplay); log = Helper.append(log, originalModel.Payments_Add, model.Payments_Add, UserAccountRolesModel.COL_Payments_Add.LogDisplay); log = Helper.append(log, originalModel.Payments_Edit, model.Payments_Edit, UserAccountRolesModel.COL_Payments_Edit.LogDisplay); log = Helper.append(log, originalModel.Payments_View, model.Payments_View, UserAccountRolesModel.COL_Payments_View.LogDisplay); log = Helper.append(log, originalModel.Payments_Approve, model.Payments_Approve, UserAccountRolesModel.COL_Payments_Approve.LogDisplay); //PettyCashRecords log = Helper.append(log, originalModel.PettyCashRecords_Notes, model.PettyCashRecords_Notes, UserAccountRolesModel.COL_PettyCashRecords_Notes.LogDisplay); log = Helper.append(log, originalModel.PettyCashRecords_Add, model.PettyCashRecords_Add, UserAccountRolesModel.COL_PettyCashRecords_Add.LogDisplay); log = Helper.append(log, originalModel.PettyCashRecords_Edit, model.PettyCashRecords_Edit, UserAccountRolesModel.COL_PettyCashRecords_Edit.LogDisplay); log = Helper.append(log, originalModel.PettyCashRecords_View, model.PettyCashRecords_View, UserAccountRolesModel.COL_PettyCashRecords_View.LogDisplay); log = Helper.append(log, originalModel.PettyCashRecords_Approve, model.PettyCashRecords_Approve, UserAccountRolesModel.COL_PettyCashRecords_Approve.LogDisplay); //Inventory log = Helper.append(log, originalModel.Inventory_Notes, model.Inventory_Notes, UserAccountRolesModel.COL_Inventory_Notes.LogDisplay); log = Helper.append(log, originalModel.Inventory_Add, model.Inventory_Add, UserAccountRolesModel.COL_Inventory_Add.LogDisplay); log = Helper.append(log, originalModel.Inventory_Edit, model.Inventory_Edit, UserAccountRolesModel.COL_Inventory_Edit.LogDisplay); log = Helper.append(log, originalModel.Inventory_View, model.Inventory_View, UserAccountRolesModel.COL_Inventory_View.LogDisplay); //LessonSessions log = Helper.append(log, originalModel.LessonSessions_Notes, model.LessonSessions_Notes, UserAccountRolesModel.COL_LessonSessions_Notes.LogDisplay); log = Helper.append(log, originalModel.LessonSessions_Add, model.LessonSessions_Add, UserAccountRolesModel.COL_LessonSessions_Add.LogDisplay); log = Helper.append(log, originalModel.LessonSessions_Edit, model.LessonSessions_Edit, UserAccountRolesModel.COL_LessonSessions_Edit.LogDisplay); log = Helper.append(log, originalModel.LessonSessions_EditReviewAndInternalNotes, model.LessonSessions_EditReviewAndInternalNotes, UserAccountRolesModel.COL_LessonSessions_EditReviewAndInternalNotes.LogDisplay); log = Helper.append(log, originalModel.LessonSessions_View, model.LessonSessions_View, UserAccountRolesModel.COL_LessonSessions_View.LogDisplay); log = Helper.append(log, originalModel.LessonSessions_InternalNotes_View, model.LessonSessions_InternalNotes_View, UserAccountRolesModel.COL_LessonSessions_InternalNotes_View.LogDisplay); //HourlyRates log = Helper.append(log, originalModel.HourlyRates_Notes, model.HourlyRates_Notes, UserAccountRolesModel.COL_HourlyRates_Notes.LogDisplay); log = Helper.append(log, originalModel.HourlyRates_Add, model.HourlyRates_Add, UserAccountRolesModel.COL_HourlyRates_Add.LogDisplay); log = Helper.append(log, originalModel.HourlyRates_Edit, model.HourlyRates_Edit, UserAccountRolesModel.COL_HourlyRates_Edit.LogDisplay); log = Helper.append(log, originalModel.HourlyRates_View, model.HourlyRates_View, UserAccountRolesModel.COL_HourlyRates_View.LogDisplay); //PayrollPayments log = Helper.append(log, originalModel.PayrollPayments_Notes, model.PayrollPayments_Notes, UserAccountRolesModel.COL_PayrollPayments_Notes.LogDisplay); log = Helper.append(log, originalModel.PayrollPayments_Add, model.PayrollPayments_Add, UserAccountRolesModel.COL_PayrollPayments_Add.LogDisplay); log = Helper.append(log, originalModel.PayrollPayments_Edit, model.PayrollPayments_Edit, UserAccountRolesModel.COL_PayrollPayments_Edit.LogDisplay); log = Helper.append(log, originalModel.PayrollPayments_View, model.PayrollPayments_View, UserAccountRolesModel.COL_PayrollPayments_View.LogDisplay); log = Helper.append(log, originalModel.PayrollPayments_Approve, model.PayrollPayments_Approve, UserAccountRolesModel.COL_PayrollPayments_Approve.LogDisplay); //TutorSchedules log = Helper.append(log, originalModel.TutorSchedules_Notes, model.TutorSchedules_Notes, UserAccountRolesModel.COL_TutorSchedules_Notes.LogDisplay); log = Helper.append(log, originalModel.TutorSchedules_Add, model.TutorSchedules_Add, UserAccountRolesModel.COL_TutorSchedules_Add.LogDisplay); log = Helper.append(log, originalModel.TutorSchedules_Edit, model.TutorSchedules_Edit, UserAccountRolesModel.COL_TutorSchedules_Edit.LogDisplay); log = Helper.append(log, originalModel.TutorSchedules_View, model.TutorSchedules_View, UserAccountRolesModel.COL_TutorSchedules_View.LogDisplay); //StudentSchedules log = Helper.append(log, originalModel.StudentSchedules_Notes, model.StudentSchedules_Notes, UserAccountRolesModel.COL_StudentSchedules_Notes.LogDisplay); log = Helper.append(log, originalModel.StudentSchedules_Add, model.StudentSchedules_Add, UserAccountRolesModel.COL_StudentSchedules_Add.LogDisplay); log = Helper.append(log, originalModel.StudentSchedules_Edit, model.StudentSchedules_Edit, UserAccountRolesModel.COL_StudentSchedules_Edit.LogDisplay); log = Helper.append(log, originalModel.StudentSchedules_View, model.StudentSchedules_View, UserAccountRolesModel.COL_StudentSchedules_View.LogDisplay); //ClubSchedules log = Helper.append(log, originalModel.ClubSchedules_Notes, model.ClubSchedules_Notes, UserAccountRolesModel.COL_ClubSchedules_Notes.LogDisplay); log = Helper.append(log, originalModel.ClubSchedules_Add, model.ClubSchedules_Add, UserAccountRolesModel.COL_ClubSchedules_Add.LogDisplay); log = Helper.append(log, originalModel.ClubSchedules_Edit, model.ClubSchedules_Edit, UserAccountRolesModel.COL_ClubSchedules_Edit.LogDisplay); log = Helper.append(log, originalModel.ClubSchedules_View, model.ClubSchedules_View, UserAccountRolesModel.COL_ClubSchedules_View.LogDisplay); //Files log = Helper.append(log, originalModel.Files_Notes, model.Files_Notes, UserAccountRolesModel.COL_Files_Notes.LogDisplay); log = Helper.append(log, originalModel.Files_Add, model.Files_Add, UserAccountRolesModel.COL_Files_Add.LogDisplay); log = Helper.append(log, originalModel.Files_Edit, model.Files_Edit, UserAccountRolesModel.COL_Files_Edit.LogDisplay); log = Helper.append(log, originalModel.Files_View, model.Files_View, UserAccountRolesModel.COL_Files_View.LogDisplay); log = Helper.append(log, originalModel.Files_EditGlobal, model.Files_EditGlobal, UserAccountRolesModel.COL_Files_EditGlobal.LogDisplay); //Income Statement log = Helper.append(log, originalModel.IncomeStatement_Notes, model.IncomeStatement_Notes, UserAccountRolesModel.COL_IncomeStatement_Notes.LogDisplay); log = Helper.append(log, originalModel.IncomeStatement_View, model.IncomeStatement_View, UserAccountRolesModel.COL_IncomeStatement_View.LogDisplay); log = Helper.append(log, originalModel.IncomeStatement_ViewProfit, model.IncomeStatement_ViewProfit, UserAccountRolesModel.COL_IncomeStatement_ViewProfit.LogDisplay); if (!string.IsNullOrEmpty(log)) { db.Entry(model).State = EntityState.Modified; ActivityLogsController.AddEditLog(db, Session, model.Id, log); db.SaveChanges(); } UserAccountsController.updateLoginSession(Session); return(RedirectToAction(nameof(Index))); } } return(View(model)); }
public JsonResult Ajax_GetDetails(Guid id) { UserAccountRolesModel access = UserAccountsController.getUserAccess(Session); List <SaleInvoiceItemsModel> models = SaleInvoiceItemsController.get_by_SaleInvoices_Id(id); string content = string.Format(@" <div class='table-responsive'> <table class='table table-striped table-bordered'> <!--<thead> <tr> <th>Line</th> <th>Description</th> <th></th> <th></th> <th></th> </tr> </thead>--> <tbody> "); foreach (SaleInvoiceItemsModel model in models) { int voucher = model.VouchersAmount; string subtractions = ""; if (voucher != 0) { subtractions = Util.append(subtractions, string.Format("Voucher: {0:N0}", -1 * voucher), "<br/>"); } if (model.DiscountAmount != 0) { subtractions = Util.append(subtractions, string.Format("Discount: {0:N0}", -1 * model.DiscountAmount), "<br/>"); } if (!string.IsNullOrEmpty(subtractions)) { subtractions += "<br/>"; } string log = model.RowNo.ToString(); if (access.SaleInvoices_TutorTravelCost_View) { log = string.Format("<a href='javascript: void(0)' onclick=\"Log('{0}')\">{1}</a>", model.Id.ToString(), model.RowNo); } string remaining = ""; if (!model.IsClubSubscription) { remaining = string.Format("<br/><strong>Available Hours:</strong> {0:N2}", model.SessionHours_Remaining); } else { DateTime expirationDate = model.StartingDate.AddMonths(model.ExpirationMonth).AddSeconds(-1); int remainingDays = 0; if (expirationDate > DateTime.Now.Date) { remainingDays = (expirationDate - DateTime.Now.Date).Days; } remaining = string.Format("<br/><strong>Expired:</strong> {0:dd/MM/yy} ({1:N0} days)", expirationDate, remainingDays); } content += string.Format(@" <tr> <td class='align-top' style='width:10px;'>{0}</td> <td class='align-top'>{1}{2}{3}{4}</td> <td class='align-top text-right'> Qty: {5:N0} x {6:N0} {7}{8} </td> <td class='align-top text-right'> {9} <strong>{10:N0}</strong> </td> </tr> ", log, model.Description, model.LessonPackages_Id == null ? "" : remaining, !string.IsNullOrWhiteSpace(model.VouchersName) ? string.Format("<br/>Vouchers: {0}", model.VouchersName) : "", !string.IsNullOrWhiteSpace(model.Notes) ? string.Format("<br/>Notes: {0}", model.Notes) : "", model.Qty, model.Price, model.TravelCost > 0 || model.TutorTravelCost > 0 ? string.Format("<br/>Travel: {0:N0}", model.TravelCost) : "", access.SaleInvoices_TutorTravelCost_View && (model.TravelCost > 0 || model.TutorTravelCost > 0) ? string.Format(" (Tutor: {0:N0})", model.TutorTravelCost) : "", subtractions, model.TotalAmount ); } SaleInvoicesModel SaleInvoice = get(id); content += string.Format(@" </tbody></table></div> <div class='mt-2'> <div class='h3 ml-2 float-right font-weight-bold'>TOTAL: {0:N0}</div> {1} </div> ", SaleInvoice.Amount, !string.IsNullOrWhiteSpace(SaleInvoice.Notes) ? string.Format("<div><strong>Notes: </strong>{0}</div>", SaleInvoice.Notes) : "" ); return(Json(new { content = content }, JsonRequestBehavior.AllowGet)); }