public ActionResult ConstrainsSubmission(ShiftsConstrains model)
{
ShiftsConstrains sc = new ShiftsConstrains()
{
Constrains = model.Constrains,
WorkerId = model.WorkerId,
WSID = model.WSID
};
if (clnt.AddWorkerConstrains(sc) == 1)
{
TempData["Success"] = true;
}
else
{
TempData["ErrorMessgae"] = new Message()
{
Title = "אירעה שגיאה",
Content = "אירעה שגיאה בעת הזנת האילוצים, נסה שנית."
};
}
ViewData["NextWeekStartDate"] = clnt.GetWeekStartDate();
return(View(model));
}
public static int AddWorkerConstrains(ShiftsConstrains shiftsConstrains)
{
if (RemoveWorkerConstrains(shiftsConstrains.WorkerId, shiftsConstrains.WSID) == 1)
{
OpenConnection();
for (int i = 0; i < shiftsConstrains.Constrains.Count; i++)
{
if (shiftsConstrains.Constrains[i])
{
int part = i / 7;
int day = i - 7 * part;
// create new StoredProcedure command
cmd = new SqlCommand("sp_AddWorkerConstrains", con);
cmd.CommandType = CommandType.StoredProcedure;
// add the parameters
cmd.Parameters.AddWithValue("@WSID", shiftsConstrains.WSID);
cmd.Parameters.AddWithValue("@WorkerId", shiftsConstrains.WorkerId);
cmd.Parameters.AddWithValue("@Day", day);
cmd.Parameters.AddWithValue("@ShiftTime", part);
cmd.ExecuteNonQuery();
}
}
CloseConnection();
return(1);
}
else
{
return(0);
}
}
public ActionResult ConstrainsSubmission()
{
ShiftsConstrains model = new ShiftsConstrains();
model.WSID = clnt.GetWSID();
model.WorkerId = SessionManager.CurrentWorker.IdNumber;
model.Constrains = clnt.GetWorkerConstrains(model.WorkerId, model.WSID);
ViewData["NextWeekStartDate"] = clnt.GetWeekStartDate();
return(View(model));
}
public int AddWorkerConstrains(ShiftsConstrains shiftsConstrains)
{
return(Invoker.AddWorkerConstrains(shiftsConstrains));
}