public JsonResult Ajax_Create(Guid?UserAccounts_Id, string Description, DateTime Timestamp, int Amount) { if (UserAccounts_Id == null) { UtilWebMVC.Json(Response, "Please select employee"); } else if (string.IsNullOrEmpty(Description)) { UtilWebMVC.Json(Response, "Please provide description"); } else { Guid Id = Guid.NewGuid(); add(new PayrollPaymentItemsModel() { Id = Id, PayrollPayments_Id = null, Timestamp = Timestamp, Description = Description, Hour = 0, HourlyRate = 0, TutorTravelCost = 0, Amount = Amount, UserAccounts_Id = UserAccounts_Id.Value, CancelNotes = string.Empty, Branches_Id = Helper.getActiveBranchId(Session), IsFullTime = false }); ActivityLogsController.AddCreateLog(db, Session, Id); db.SaveChanges(); } return(Json(new { Message = "" })); }
public ActionResult Edit(HourlyRatesModel modifiedModel, string FILTER_Keyword) { if (ModelState.IsValid) { if (isExists(modifiedModel.Id, modifiedModel)) { UtilWebMVC.setBootboxMessage(this, "Kombinasi sudah terdaftar"); } else { HourlyRatesModel originalModel = get(modifiedModel.Id); string log = string.Empty; log = Helper.append <BranchesModel>(log, originalModel.Branches_Id, modifiedModel.Branches_Id, HourlyRatesModel.COL_Branches_Id.LogDisplay); log = Helper.append <LessonPackagesModel>(log, originalModel.LessonPackages_Id, modifiedModel.LessonPackages_Id, HourlyRatesModel.COL_LessonPackages_Id.LogDisplay); log = Helper.append <UserAccountsModel>(log, originalModel.UserAccounts_Id, modifiedModel.UserAccounts_Id, HourlyRatesModel.COL_UserAccounts_Id.LogDisplay); log = Helper.append(log, originalModel.Rate, modifiedModel.Rate, HourlyRatesModel.COL_Rate.LogDisplay); log = Helper.append(log, originalModel.FullTimeTutorPayrate, modifiedModel.FullTimeTutorPayrate, HourlyRatesModel.COL_FullTimeTutorPayrate.LogDisplay); log = Helper.append(log, originalModel.Notes, modifiedModel.Notes, HourlyRatesModel.COL_Notes.LogDisplay); if (!string.IsNullOrEmpty(log)) { update(modifiedModel, log); } return(RedirectToAction(nameof(Index), new { FILTER_Keyword = FILTER_Keyword })); } } setViewBag(FILTER_Keyword); return(View(modifiedModel)); }
/* INDEX **********************************************************************************************************************************************/ // GET: UserAccounts public ActionResult Index(int?rss, string FILTER_Keyword, int?FILTER_Active, Guid?FILTER_Languages_Id) { if (!UserAccountsController.getUserAccess(Session).UserAccounts_View) { return(RedirectToAction(nameof(HomeController.Index), "Home")); } setViewBag(FILTER_Keyword, FILTER_Active, FILTER_Languages_Id); if (rss != null) { ViewBag.RemoveDatatablesStateSave = rss; return(View()); } else { if (UtilWebMVC.hasNoFilter(FILTER_Keyword, FILTER_Active, FILTER_Languages_Id)) { return(View()); } else { string roles = ""; if (!getUserAccess(Session).UserAccounts_EditRoles) { roles = SettingsController.get().StudentRole.ToString(); } return(View(get(null, null, FILTER_Keyword, FILTER_Active, FILTER_Languages_Id, roles, false))); } } }
/* INDEX **********************************************************************************************************************************************/ // GET: LessonSessions public ActionResult Index(int?rss, string FILTER_Keyword, string FILTER_InvoiceNo, int?FILTER_Cancelled, bool?FILTER_chkDateFrom, DateTime?FILTER_DateFrom, bool?FILTER_chkDateTo, DateTime?FILTER_DateTo) { if (!UserAccountsController.getUserAccess(Session).LessonSessions_View) { return(RedirectToAction(nameof(HomeController.Index), "Home")); } if (UtilWebMVC.hasNoFilter(FILTER_Keyword, FILTER_InvoiceNo, FILTER_Cancelled, FILTER_chkDateFrom, FILTER_DateFrom, FILTER_chkDateTo, FILTER_DateTo)) { FILTER_chkDateFrom = true; FILTER_DateFrom = Helper.getCurrentDateTime(); if (UserAccountsController.getUserAccount(Session).Roles_List.Contains(SettingsController.get().StudentRole.ToString())) { FILTER_Cancelled = 0; } } setViewBag(FILTER_Keyword, FILTER_InvoiceNo, FILTER_Cancelled, FILTER_chkDateFrom, FILTER_DateFrom, FILTER_chkDateTo, FILTER_DateTo); if (rss != null) { ViewBag.RemoveDatatablesStateSave = rss; return(View()); } else { List <LessonSessionsModel> models = get(FILTER_Keyword, FILTER_InvoiceNo, FILTER_Cancelled, FILTER_chkDateFrom, FILTER_DateFrom, FILTER_chkDateTo, FILTER_DateTo) .OrderByDescending(x => x.Timestamp).ToList(); return(View(models)); } }
public ActionResult Edit(SettingsModel modifiedModel, List <HttpPostedFileBase> uploadFiles) { if (!UserAccountsController.getUserAccess(Session).Settings_Edit) { return(RedirectToAction(nameof(HomeController.Index), "Home")); } if (ModelState.IsValid) { //Prepare changes SettingsModel originalModel = get(); string log = string.Empty; log = addLog(log, SettingsModel.COL_AutoEntryForCashPayments.Id, SettingsModel.COL_AutoEntryForCashPayments.Display, db.PettyCashRecordsCategories.Where(x => x.Id == originalModel.AutoEntryForCashPayments).FirstOrDefault().Name, db.PettyCashRecordsCategories.Where(x => x.Id == modifiedModel.AutoEntryForCashPayments).FirstOrDefault().Name, "Update: '{1}'"); log = addLog(log, SettingsModel.COL_AutoEntryForCashPayments.Id, SettingsModel.COL_AutoEntryForCashPayments.Display, originalModel.AutoEntryForCashPayments_Notes, modifiedModel.AutoEntryForCashPayments_Notes, "Notes: '{1}'"); log = addLog(log, SettingsModel.COL_StudentRole.Id, SettingsModel.COL_StudentRole.Display, originalModel.StudentRole == null ? "" : db.UserAccountRoles.Where(x => x.Id == originalModel.StudentRole).FirstOrDefault().Name, modifiedModel.StudentRole == null ? "" : db.UserAccountRoles.Where(x => x.Id == modifiedModel.StudentRole).FirstOrDefault().Name, "Update: '{1}'"); log = addLog(log, SettingsModel.COL_StudentRole.Id, SettingsModel.COL_StudentRole.Display, originalModel.StudentRole_Notes, modifiedModel.StudentRole_Notes, "Notes: '{1}'"); log = addLog(log, SettingsModel.COL_TutorRole.Id, SettingsModel.COL_TutorRole.Display, originalModel.TutorRole == null ? "" : db.UserAccountRoles.Where(x => x.Id == originalModel.TutorRole).FirstOrDefault().Name, modifiedModel.TutorRole == null ? "" : db.UserAccountRoles.Where(x => x.Id == modifiedModel.TutorRole).FirstOrDefault().Name, "Update: '{1}'"); log = addLog(log, SettingsModel.COL_TutorRole.Id, SettingsModel.COL_TutorRole.Display, originalModel.TutorRole_Notes, modifiedModel.TutorRole_Notes, "Notes: '{1}'"); log = addLog(log, SettingsModel.COL_ResetPassword.Id, SettingsModel.COL_ResetPassword.Display, originalModel.ResetPassword, modifiedModel.ResetPassword, "UPDATE: '{1}'"); log = addLog(log, SettingsModel.COL_ResetPassword.Id, SettingsModel.COL_ResetPassword.Display, originalModel.ResetPassword_Notes, modifiedModel.ResetPassword_Notes, "Notes: '{1}'"); log = addLogForList <UserAccountRolesModel>(log, SettingsModel.COL_FullAccessForTutorSchedules.Id, SettingsModel.COL_FullAccessForTutorSchedules.Display, originalModel.FullAccessForTutorSchedules_List, modifiedModel.FullAccessForTutorSchedules_List); log = addLog(log, SettingsModel.COL_FullAccessForTutorSchedules.Id, SettingsModel.COL_FullAccessForTutorSchedules.Display, originalModel.FullAccessForTutorSchedules_Notes, modifiedModel.FullAccessForTutorSchedules_Notes, "Notes: '{1}'"); log = addLogForList <UserAccountRolesModel>(log, SettingsModel.COL_ShowOnlyOwnUserData.Id, SettingsModel.COL_ShowOnlyOwnUserData.Display, originalModel.ShowOnlyOwnUserData_List, modifiedModel.ShowOnlyOwnUserData_List); log = addLog(log, SettingsModel.COL_ShowOnlyOwnUserData.Id, SettingsModel.COL_ShowOnlyOwnUserData.Display, originalModel.ShowOnlyOwnUserData_Notes, modifiedModel.ShowOnlyOwnUserData_Notes, "Notes: '{1}'"); log = addLogForList <UserAccountRolesModel>(log, SettingsModel.COL_PayrollRatesRoles.Id, SettingsModel.COL_PayrollRatesRoles.Display, originalModel.PayrollRatesRoles_List, modifiedModel.PayrollRatesRoles_List); log = addLog(log, SettingsModel.COL_PayrollRatesRoles.Id, SettingsModel.COL_PayrollRatesRoles.Display, originalModel.PayrollRatesRoles_Notes, modifiedModel.PayrollRatesRoles_Notes, "Notes: '{1}'"); //Update Database if (string.IsNullOrEmpty(log)) { UtilWebMVC.setBootboxMessage(this, "No change to update"); } else { update(modifiedModel); //update setting values db.SaveChanges(); //insert activity logs UtilWebMVC.setBootboxMessage(this, log); return(RedirectToAction(nameof(Edit))); } } setViewBag(modifiedModel); return(View(modifiedModel)); }
/* INDEX **********************************************************************************************************************************************/ // GET: SaleInvoices public ActionResult Index(int?rss, string FILTER_Keyword, string FILTER_PaymentNo, int?FILTER_Cancelled, int?FILTER_Approved, int?FILTER_HasDueAmount, bool?FILTER_chkDateFrom, DateTime?FILTER_DateFrom, bool?FILTER_chkDateTo, DateTime?FILTER_DateTo) { if (!UserAccountsController.getUserAccess(Session).SaleInvoices_View) { return(RedirectToAction(nameof(HomeController.Index), "Home")); } if (UtilWebMVC.hasNoFilter(FILTER_Keyword, FILTER_PaymentNo, FILTER_Cancelled, FILTER_Approved, FILTER_chkDateFrom, FILTER_DateFrom, FILTER_chkDateTo, FILTER_DateTo)) { //FILTER_chkDateFrom = true; //FILTER_DateFrom = Helper.getCurrentDateTime(); FILTER_Cancelled = 0; if (UserAccountsController.getUserAccount(Session).Roles_List.Contains(SettingsController.get().StudentRole.ToString())) { FILTER_HasDueAmount = null; } else { FILTER_HasDueAmount = 1; } } setViewBag(FILTER_Keyword, FILTER_PaymentNo, FILTER_Cancelled, FILTER_Approved, FILTER_HasDueAmount, FILTER_chkDateFrom, FILTER_DateFrom, FILTER_chkDateTo, FILTER_DateTo); ViewBag.RemoveDatatablesStateSave = rss; List <SaleInvoicesModel> models = get(FILTER_Keyword, FILTER_PaymentNo, FILTER_Cancelled, FILTER_Approved, FILTER_HasDueAmount, FILTER_chkDateFrom, FILTER_DateFrom, FILTER_chkDateTo, FILTER_DateTo) .OrderByDescending(x => x.No).ToList(); return(View(models)); }
public ActionResult returnView(List <LessonSessionsModel> LessonSessions, string errorMessage) { if (!string.IsNullOrEmpty(errorMessage)) { UtilWebMVC.setBootboxMessage(this, errorMessage); } ViewData["LessonSessions"] = LessonSessions; return(View()); }
public ActionResult Create(SaleInvoicesModel model, string JsonSaleInvoiceItems, string FILTER_Keyword, string FILTER_PaymentNo, int?FILTER_Cancelled, int?FILTER_Approved, int?FILTER_HasDueAmount, bool?FILTER_chkDateFrom, DateTime?FILTER_DateFrom, bool?FILTER_chkDateTo, DateTime?FILTER_DateTo) { List <SaleInvoiceItemsModel> SaleInvoiceItems = new List <SaleInvoiceItemsModel>(); if (!string.IsNullOrEmpty(JsonSaleInvoiceItems)) { SaleInvoiceItems = JsonConvert.DeserializeObject <List <SaleInvoiceItemsModel> >(JsonSaleInvoiceItems); } string errorMessage = ""; if (ModelState.IsValid) { if (SaleInvoiceItems.Count == 0) { UtilWebMVC.setBootboxMessage(this, "Please add at least 1 item"); } else if (!hasSufficientInventory(SaleInvoiceItems, out errorMessage)) { UtilWebMVC.setBootboxMessage(this, errorMessage); } else { add(model, SaleInvoiceItems); return(RedirectToAction(nameof(Index), new { rss = 1 })); //not working. all filter returns null //return RedirectToAction(nameof(Index), new //{ // FILTER_Keyword = FILTER_Keyword, // FILTER_PaymentNo = FILTER_PaymentNo, // FILTER_Cancelled = FILTER_Cancelled, // FILTER_Approved = FILTER_Approved, // FILTER_chkDateFrom = FILTER_chkDateFrom, // FILTER_DateFrom = FILTER_DateFrom, // FILTER_chkDateTo = FILTER_chkDateTo, // FILTER_DateTo = FILTER_DateTo //}); } } setViewBag(FILTER_Keyword, FILTER_PaymentNo, FILTER_Cancelled, FILTER_Approved, FILTER_HasDueAmount, FILTER_chkDateFrom, FILTER_DateFrom, FILTER_chkDateTo, FILTER_DateTo); ViewData["SaleInvoiceItems"] = SaleInvoiceItems; return(View(model)); }
public ActionResult Create(HourlyRatesModel model, string FILTER_Keyword) { if (ModelState.IsValid) { if (isExists(null, model)) { UtilWebMVC.setBootboxMessage(this, "Kombinasi sudah terdaftar"); } else { add(model); return(RedirectToAction(nameof(Index), new { FILTER_Keyword = FILTER_Keyword })); } } setViewBag(FILTER_Keyword); return(View(model)); }
public JsonResult Ajax_Create(Guid UserAccounts_Id, string Notes, DateTime Timestamp, decimal Amount, DateTime DatePeriod) { List <PayrollPaymentItemsModel> PayrollPaymentItems = PayrollPaymentItemsController.combineClassSesions(PayrollPaymentItemsController.get(Session, UserAccounts_Id, DatePeriod, null)); if (Amount != PayrollPaymentItems.Sum(x => x.Amount - x.PayrollPaymentAmount)) { return(UtilWebMVC.Json(Response, "Due amount has changed. Please reload list and try again.")); } add(PayrollPaymentItems, new PayrollPaymentsModel { Id = Guid.NewGuid(), Timestamp = Timestamp, Amount = Amount, Notes = Notes, UserAccounts_Id = UserAccounts_Id, Branches_Id = (Guid)PayrollPaymentItems[0].Branches_Id }); return(Json(new { Message = "" })); }
public static DateTime setFilterViewBag(Controller controller, int?year, int?month, DateTime?PayPeriod, string search, string periodChange, int?ActionType) { DateTime payPeriod; if (PayPeriod != null) { payPeriod = (DateTime)PayPeriod; } else if (month == null || year == null) { payPeriod = new DateTime(getCurrentDateTime().Year, getCurrentDateTime().Month, 1, 0, 0, 0); } else { payPeriod = new DateTime((int)year, (int)month, 1, 0, 0, 0); } if (periodChange == EnumActions.Previous.ToString()) { payPeriod = payPeriod.AddMonths(-1); } else if (periodChange == EnumActions.Next.ToString()) { payPeriod = payPeriod.AddMonths(1); } var ViewBag = controller.ViewBag; ViewBag.PayPeriodYear = UtilWebMVC.validateParameter(payPeriod.Year); ViewBag.PayPeriodMonth = UtilWebMVC.validateParameter(payPeriod.Month); ViewBag.PayPeriod = UtilWebMVC.validateParameter(payPeriod); ViewBag.Search = UtilWebMVC.validateParameter(search); ViewBag.ActionType = UtilWebMVC.validateParameter(ActionType); return(payPeriod); }
public ActionResult Create(string submitButton, Guid?ParentId, HttpPostedFileBase File, Guid?FileId, string FileDescription, bool?IsGlobalFile, Guid?DirectoryId, string DirectoryName, bool?IsGlobalDirectory) { FilesModel model = new FilesModel(); if (ParentId == null) { model.ParentId = RootId; } else { model.ParentId = (Guid)ParentId; } if (IsGlobalFile == true || IsGlobalDirectory == true) { model.Branches_Id = null; } else { model.Branches_Id = Helper.getActiveBranchId(Session); } if (submitButton == BUTTONVALUE_UPLOADFILE || submitButton == BUTTONVALUE_UPLOADREVISION) { if (File == null || File.ContentLength == 0) { UtilWebMVC.setBootboxMessage(this, "Invalid File"); } else { AuthorizationCodeWebApp.AuthResult authorization = GoogleDriveAPIHelper.getAuthorization(this); if (authorization.Credential == null) { UtilWebMVC.setBootboxMessage(this, "Google Login was required. Please navigate to the folder and try to upload the file again."); return(RedirectToAction(nameof(IndexAsync))); } else { authorization = GoogleDriveAPIHelper.checkExpiration(this, authorization); string OnlineFileId = GoogleDriveAPIHelper.UploadToDrive(GoogleDriveAPIHelper.GetServiceForWebApplication(authorization), File); if (GoogleDriveAPIHelper.isFileUploadSuccessful(this, OnlineFileId)) { model.Filename = File.FileName; model.OnlineFileId = OnlineFileId; model.Notes = FileDescription; if (submitButton == BUTTONVALUE_UPLOADFILE) { add(model); } else { FilesModel originalModel = get((Guid)FileId); model.ParentId = originalModel.ParentId; add(model); originalModel.ParentId = model.Id; update(originalModel); } } } } } else if (submitButton == BUTTONVALUE_CREATEDIRECTORY || submitButton == BUTTONVALUE_UPDATEDIRECTORY) { if (string.IsNullOrWhiteSpace(DirectoryName)) { UtilWebMVC.setBootboxMessage(this, "Invalid Name"); } else { model.DirectoryName = DirectoryName; if (submitButton == BUTTONVALUE_CREATEDIRECTORY) { add(model); } else { model.Id = (Guid)DirectoryId; update(model); } } } return(null); }
public static List <SaleInvoicesModel> get(HttpSessionStateBase Session, Guid?Id, string SaleInvoiceItemIdList, string FILTER_Keyword, string FILTER_PaymentNo, bool?FILTER_chkDateFrom, DateTime?FILTER_DateFrom, bool?FILTER_chkDateTo, DateTime?FILTER_DateTo, int?Cancelled, int?Approved, int?FILTER_HasDueAmount) { Guid Branches_Id = Helper.getActiveBranchId(Session); if (FILTER_chkDateFrom == null || !(bool)FILTER_chkDateFrom) { FILTER_DateFrom = null; } if (FILTER_chkDateTo == null || !(bool)FILTER_chkDateTo) { FILTER_DateTo = null; } string SaleInvoiceItemIdListClause = ""; if (!string.IsNullOrEmpty(SaleInvoiceItemIdList)) { SaleInvoiceItemIdListClause = string.Format("AND SaleInvoices.Id IN ({0})", UtilWebMVC.convertToSqlIdList(SaleInvoiceItemIdList)); } string ShowOnlyOwnUserDataClause = ""; if (UserAccountsController.getShowOnlyUserData(Session)) { ShowOnlyOwnUserDataClause = string.Format(" AND Customer_UserAccounts.Id = '{0}' ", UserAccountsController.getUserId(Session)); } string sql = string.Format(@" SELECT SaleInvoices.*, Branches.Name AS Branches_Name, Customer_UserAccounts.Fullname AS Customer_UserAccounts_Name, Customer_UserAccounts.No AS Customer_UserAccounts_No, ROW_NUMBER() OVER (ORDER BY SaleInvoices.No DESC) AS InitialRowNumber FROM SaleInvoices LEFT JOIN Branches ON Branches.Id = SaleInvoices.Branches_Id LEFT JOIN UserAccounts Customer_UserAccounts ON Customer_UserAccounts.Id = SaleInvoices.Customer_UserAccounts_Id WHERE 1=1 AND (@Id IS NULL OR SaleInvoices.Id = @Id) AND (@Id IS NOT NULL OR ( (@FILTER_Keyword IS NULL OR ( SaleInvoices.No LIKE '%'+@FILTER_Keyword+'%' OR Customer_UserAccounts.Fullname LIKE '%'+@FILTER_Keyword+'%' )) AND (@FILTER_PaymentNo IS NULL OR (SaleInvoices.Id IN ( SELECT SaleInvoices.Id FROM PaymentItems LEFT JOIN Payments ON Payments.Id = PaymentItems.Payments_Id LEFT JOIN SaleInvoices ON Saleinvoices.Id = PaymentItems.ReferenceId WHERE Payments.No = @FILTER_PaymentNo ))) AND (@FILTER_DateFrom IS NULL OR SaleInvoices.Timestamp >= @FILTER_DateFrom) AND (@FILTER_DateTo IS NULL OR SaleInvoices.Timestamp <= @FILTER_DateTo) AND (@Cancelled IS NULL OR SaleInvoices.Cancelled = @Cancelled) AND (@Approved IS NULL OR SaleInvoices.Approved = @Approved) AND (@FILTER_HasDueAmount IS NULL OR ((@FILTER_HasDueAmount = 0 AND SaleInvoices.Due = 0) OR (@FILTER_HasDueAmount = 1 AND SaleInvoices.Due > 0))) AND (@Branches_Id IS NULL OR SaleInvoices.Branches_Id = @Branches_Id) {0}{1} )) ORDER BY SaleInvoices.No DESC ", SaleInvoiceItemIdListClause, ShowOnlyOwnUserDataClause); return(new DBContext().Database.SqlQuery <SaleInvoicesModel>(sql, DBConnection.getSqlParameter(SaleInvoicesModel.COL_Id.Name, Id), DBConnection.getSqlParameter("FILTER_Keyword", FILTER_Keyword), DBConnection.getSqlParameter("FILTER_PaymentNo", FILTER_PaymentNo), DBConnection.getSqlParameter("FILTER_DateFrom", FILTER_DateFrom), DBConnection.getSqlParameter("FILTER_DateTo", Util.getAsEndDate(FILTER_DateTo)), DBConnection.getSqlParameter("FILTER_HasDueAmount", FILTER_HasDueAmount), DBConnection.getSqlParameter(SaleInvoicesModel.COL_Branches_Id.Name, Branches_Id), DBConnection.getSqlParameter(SaleInvoicesModel.COL_Cancelled.Name, Cancelled), DBConnection.getSqlParameter(SaleInvoicesModel.COL_Approved.Name, Approved) ).ToList()); }
public JsonResult Ajax_Update_CancelNotes(Guid id, string notes) { return(UtilWebMVC.Json(Response, update_CancelNotes(id, notes))); }