public void add(VouchersModel model)
{
WebDBConnection.Insert(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.AddCreateLog(db, Session, model.Id);
db.SaveChanges();
}
public static void add(PayrollPaymentItemsModel model)
{
WebDBConnection.Insert(new DBContext().Database, "PayrollPaymentItems",
DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_Id.Name, model.Id),
DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_PayrollPayments_Id.Name, model.PayrollPayments_Id),
DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_Timestamp.Name, model.Timestamp),
DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_Description.Name, model.Description),
DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_Hour.Name, model.Hour),
DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_HourlyRate.Name, model.HourlyRate),
DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_TutorTravelCost.Name, model.TutorTravelCost),
DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_Amount.Name, model.Amount),
DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_UserAccounts_Id.Name, model.UserAccounts_Id),
DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_CancelNotes.Name, model.CancelNotes),
DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_Branches_Id.Name, model.Branches_Id),
DBConnection.getSqlParameter(PayrollPaymentItemsModel.COL_IsFullTime.Name, model.IsFullTime)
);
}
public void add(HourlyRatesModel model)
{
model.Id = Guid.NewGuid();
WebDBConnection.Insert(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.AddCreateLog(db, Session, model.Id);
db.SaveChanges();
}
public void add(FilesModel model)
{
model.UserAccounts_Id = (Guid)UserAccountsController.getUserId(Session);
model.No = WebDBConnection.GetNextHex(db.Database, "Files", "No");
WebDBConnection.Insert(db.Database, "Files",
DBConnection.getSqlParameter(FilesModel.COL_Id.Name, model.Id),
DBConnection.getSqlParameter(FilesModel.COL_OnlineFileId.Name, model.OnlineFileId),
DBConnection.getSqlParameter(FilesModel.COL_ParentId.Name, model.ParentId),
DBConnection.getSqlParameter(FilesModel.COL_Branches_Id.Name, model.Branches_Id),
DBConnection.getSqlParameter(FilesModel.COL_No.Name, model.No),
DBConnection.getSqlParameter(FilesModel.COL_Filename.Name, model.Filename),
DBConnection.getSqlParameter(FilesModel.COL_DirectoryName.Name, model.DirectoryName),
DBConnection.getSqlParameter(FilesModel.COL_Notes.Name, model.Notes),
DBConnection.getSqlParameter(FilesModel.COL_UserAccounts_Id.Name, model.UserAccounts_Id),
DBConnection.getSqlParameter(FilesModel.COL_Timestamp.Name, model.Timestamp),
DBConnection.getSqlParameter(FilesModel.COL_IsDeleted.Name, model.IsDeleted),
DBConnection.getSqlParameter(FilesModel.COL_Approved.Name, model.Approved)
);
}
public void add(PaymentsModel model)
{
WebDBConnection.Insert(db.Database, "Payments",
DBConnection.getSqlParameter(PaymentsModel.COL_Id.Name, model.Id),
DBConnection.getSqlParameter(PaymentsModel.COL_No.Name, model.No),
DBConnection.getSqlParameter(PaymentsModel.COL_Timestamp.Name, model.Timestamp),
DBConnection.getSqlParameter(PaymentsModel.COL_CashAmount.Name, model.CashAmount),
DBConnection.getSqlParameter(PaymentsModel.COL_DebitAmount.Name, model.DebitAmount),
DBConnection.getSqlParameter(PaymentsModel.COL_DebitBank.Name, model.DebitBank),
DBConnection.getSqlParameter(PaymentsModel.COL_DebitOwnerName.Name, model.DebitOwnerName),
DBConnection.getSqlParameter(PaymentsModel.COL_DebitNumber.Name, model.DebitNumber),
DBConnection.getSqlParameter(PaymentsModel.COL_DebitRefNo.Name, model.DebitRefNo),
DBConnection.getSqlParameter(PaymentsModel.COL_Consignments_Id.Name, model.Consignments_Id),
DBConnection.getSqlParameter(PaymentsModel.COL_ConsignmentAmount.Name, model.ConsignmentAmount),
DBConnection.getSqlParameter(PaymentsModel.COL_Notes.Name, model.Notes),
DBConnection.getSqlParameter(PaymentsModel.COL_Cancelled.Name, model.Cancelled),
DBConnection.getSqlParameter(PaymentsModel.COL_Approved.Name, model.Approved),
DBConnection.getSqlParameter(PaymentsModel.COL_IsTransfer.Name, model.IsTransfer),
DBConnection.getSqlParameter(PaymentsModel.COL_CancelNotes.Name, model.CancelNotes)
);
ActivityLogsController.AddCreateLog(db, Session, model.Id);
db.SaveChanges();
}