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));
}
public void update(HourlyRatesModel model, string log)
{
WebDBConnection.Update(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.AddEditLog(db, Session, model.Id, log);
db.SaveChanges();
}
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 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));
}
/* METHODS ********************************************************************************************************************************************/
/* DATABASE METHODS ***********************************************************************************************************************************/
public bool isExists(Guid?Id, HourlyRatesModel model)
{
return(db.Database.SqlQuery <HourlyRatesModel>(@"
SELECT HourlyRates.*
FROM HourlyRates
WHERE 1=1
AND (@Id IS NULL OR HourlyRates.Id <> @Id)
AND (@Branches_Id IS NULL OR HourlyRates.Branches_Id = Branches_Id)
AND (@UserAccounts_Id IS NULL OR HourlyRates.UserAccounts_Id = @UserAccounts_Id)
AND (@LessonPackages_Id IS NULL OR HourlyRates.LessonPackages_Id = @LessonPackages_Id)
AND (@Rate = 0 OR HourlyRates.Rate > 0)
AND (@Rate > 0 OR HourlyRates.Rate = 0)
AND (@FullTimeTutorPayrate = 0 OR HourlyRates.FullTimeTutorPayrate > 0)
AND (@FullTimeTutorPayrate > 0 OR HourlyRates.FullTimeTutorPayrate = 0)
",
DBConnection.getSqlParameter(HourlyRatesModel.COL_Id.Name, Id),
DBConnection.getSqlParameter(HourlyRatesModel.COL_Branches_Id.Name, model.Branches_Id),
DBConnection.getSqlParameter(HourlyRatesModel.COL_UserAccounts_Id.Name, model.UserAccounts_Id),
DBConnection.getSqlParameter(HourlyRatesModel.COL_LessonPackages_Id.Name, model.LessonPackages_Id),
DBConnection.getSqlParameter(HourlyRatesModel.COL_Rate.Name, model.Rate),
DBConnection.getSqlParameter(HourlyRatesModel.COL_FullTimeTutorPayrate.Name, model.FullTimeTutorPayrate)
).Count() > 0);
}
