public ActionResult Create(PettyCashRecordsModel model, string FILTER_Keyword, int?FILTER_Approved, bool?FILTER_chkDateFrom, DateTime?FILTER_DateFrom, bool?FILTER_chkDateTo, DateTime?FILTER_DateTo) { if (ModelState.IsValid) { model.Id = Guid.NewGuid(); model.Branches_Id = Helper.getActiveBranchId(Session); model.Timestamp = Helper.getCurrentDateTime(); model.UserAccounts_Id = (Guid)UserAccountsController.getUserId(Session); add(db, model); return(RedirectToAction(nameof(Index), new { FILTER_Keyword = FILTER_Keyword, FILTER_Approved = FILTER_Approved, FILTER_chkDateFrom = FILTER_chkDateFrom, FILTER_DateFrom = FILTER_DateFrom, FILTER_chkDateTo = FILTER_chkDateTo, FILTER_DateTo = FILTER_DateTo })); } setViewBag(FILTER_Keyword, FILTER_Approved, FILTER_chkDateFrom, FILTER_DateFrom, FILTER_chkDateTo, FILTER_DateTo); return(View()); }
public static void add(DBContext db, PettyCashRecordsModel model) { db.Database.ExecuteSqlCommand(@" -- INCREMENT LAST HEX NUMBER DECLARE @HexLength int = 5, @LastHex_String varchar(5), @NewNo varchar(5) SELECT @LastHex_String = ISNULL(MAX(No),'') From PettyCashRecords DECLARE @LastHex_Int int SELECT @LastHex_Int = CONVERT(INT, CONVERT(VARBINARY, REPLICATE('0', LEN(@LastHex_String)%2) + @LastHex_String, 2)) --@LastHex_String length must be even number of digits to convert to int SET @NewNo = RIGHT(CONVERT(NVARCHAR(10), CONVERT(VARBINARY(8), @LastHex_Int + 1), 1),@HexLength) INSERT INTO PettyCashRecords (Id, Branches_Id, ReferenceId, No, Timestamp, PettyCashRecordsCategories_Id, Notes, Amount, Approved, UserAccounts_Id, ExpenseCategories_Id) VALUES(@Id,@Branches_Id,@ReferenceId,@NewNo,@Timestamp,@PettyCashRecordsCategories_Id,@Notes,@Amount,@Approved,@UserAccounts_Id,@ExpenseCategories_Id); ", DBConnection.getSqlParameter(PettyCashRecordsModel.COL_Id.Name, model.Id), DBConnection.getSqlParameter(PettyCashRecordsModel.COL_Branches_Id.Name, model.Branches_Id), DBConnection.getSqlParameter(PettyCashRecordsModel.COL_ReferenceId.Name, model.ReferenceId), DBConnection.getSqlParameter(PettyCashRecordsModel.COL_Timestamp.Name, model.Timestamp), DBConnection.getSqlParameter(PettyCashRecordsModel.COL_PettyCashRecordsCategories_Id.Name, model.PettyCashRecordsCategories_Id), DBConnection.getSqlParameter(PettyCashRecordsModel.COL_Notes.Name, model.Notes), DBConnection.getSqlParameter(PettyCashRecordsModel.COL_Amount.Name, model.Amount), DBConnection.getSqlParameter(PettyCashRecordsModel.COL_Approved.Name, model.Approved), DBConnection.getSqlParameter(PettyCashRecordsModel.COL_UserAccounts_Id.Name, model.UserAccounts_Id), DBConnection.getSqlParameter(PettyCashRecordsModel.COL_ExpenseCategories_Id.Name, model.ExpenseCategories_Id) ); }