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)
);
}
