public static int Save(RosteringInfo rostering, RosteringInfo rostering2 = null)
{
int id;
if (rostering.ID <= 0) {
id = RosteringDao.Add(rostering, rostering2);
}
else {
id = RosteringDao.Update(rostering, rostering2) ? rostering.ID : 0;
}
return id;
}
private RosteringInfo BuildEntity2()
{
if (string.IsNullOrEmpty(Request.Form["startTime2"])) {
return null;
}
RosteringInfo rostering = new RosteringInfo();
rostering.StartTime = Request.Form["startTime2"];
rostering.EarlyRange = GetFormInteger("earlyRange2");
rostering.EndTime = Request.Form["endTime2"];
rostering.LateRange = GetFormInteger("lateRange2");
rostering.Duration = Convert.ToDecimal(Request.Form["duration2"]);
return rostering;
}
private RosteringInfo BuildEntity()
{
RosteringInfo rostering = new RosteringInfo();
rostering.ID = GetFormInteger("id");
rostering.Name = Request.Form["name"];
rostering.StartTime = Request.Form["startTime"];
rostering.EarlyRange = GetFormInteger("earlyRange");
rostering.EndTime = Request.Form["endTime"];
rostering.LateRange = GetFormInteger("lateRange");
rostering.Duration = Convert.ToDecimal(Request.Form["duration"]);
rostering.NightWork = GetFormInteger("nightWork");
rostering.Active = Request.Form["active"] == "true";
return rostering;
}
public static int Add(RosteringInfo rostering, RosteringInfo rostering2)
{
SqlParameter[] parameters = new SqlParameter[11];
parameters[0] = new SqlParameter("@Name", SqlDbType.VarChar, 20);
parameters[0].Value = rostering.Name;
parameters[1] = new SqlParameter("@StartTime", SqlDbType.VarChar, 20);
parameters[1].Value = DateUtility.FormatTime(rostering.StartTime);
parameters[2] = new SqlParameter("@EarlyRange", SqlDbType.Int);
parameters[2].Value = rostering.EarlyRange;
parameters[3] = new SqlParameter("@EndTime", SqlDbType.VarChar, 20);
parameters[3].Value = DateUtility.FormatTime(rostering.EndTime);
parameters[4] = new SqlParameter("@LateRange", SqlDbType.Int);
parameters[4].Value = rostering.LateRange;
parameters[5] = new SqlParameter("@MultipleType", SqlDbType.Int);
parameters[5].Value = rostering2 == null ? 1 : 2;
parameters[6] = new SqlParameter("@Duration", SqlDbType.Decimal);
parameters[6].Value = rostering.Duration;
parameters[7] = new SqlParameter("@NightWork", SqlDbType.Int);
parameters[7].Value = rostering.NightWork;
parameters[8] = new SqlParameter("@Flag", SqlDbType.Int);
parameters[8].Value = rostering.Active ? 1 : 0;
parameters[9] = new SqlParameter("@RealStartTime", SqlDbType.VarChar, 20);
parameters[9].Value = rostering.RealStartTime;
parameters[10] = new SqlParameter("@RealEndTime", SqlDbType.VarChar, 20);
parameters[10].Value = rostering.RealEndTime;
StringBuilder sql = new StringBuilder();
sql.AppendLine("DECLARE @ID int");
sql.AppendLine("INSERT INTO Rostering (bcName, startTime, earlyRange, endTime, lateRange, multType, mulripleDur, nightWork, flag, realStartTime, realEndTime)");
sql.AppendLine("VALUES (@Name, @StartTime, @EarlyRange, @EndTime, @LateRange, @MultipleType, @Duration, @NightWork, @Flag, @RealStartTime, @RealEndTime)");
sql.AppendLine("SET @ID = SCOPE_IDENTITY()");
sql.AppendLine("SELECT @ID");
int newID = (int)helper.ExecuteScalar(sql.ToString(), parameters);
//Save the record of 'afternoon'.
if (rostering2 != null) {
SqlParameter[] parameters2 = new SqlParameter[11];
parameters2[0] = new SqlParameter("@Name", SqlDbType.VarChar, 20);
parameters2[0].Value = rostering.Name;
parameters2[1] = new SqlParameter("@StartTime", SqlDbType.VarChar, 20);
parameters2[1].Value = DateUtility.FormatTime(rostering2.StartTime);
parameters2[2] = new SqlParameter("@EarlyRange", SqlDbType.Int);
parameters2[2].Value = rostering2.EarlyRange;
parameters2[3] = new SqlParameter("@EndTime", SqlDbType.VarChar, 20);
parameters2[3].Value = DateUtility.FormatTime(rostering2.EndTime);
parameters2[4] = new SqlParameter("@LateRange", SqlDbType.Int);
parameters2[4].Value = rostering2.LateRange;
parameters2[5] = new SqlParameter("@MultipleType", SqlDbType.Int);
parameters2[5].Value = 0;
parameters2[6] = new SqlParameter("@Duration", SqlDbType.Decimal);
parameters2[6].Value = rostering2.Duration;
parameters2[7] = new SqlParameter("@NightWork", SqlDbType.Int);
parameters2[7].Value = rostering2.NightWork;
parameters2[8] = new SqlParameter("@Flag", SqlDbType.Int);
parameters2[8].Value = rostering.Active ? 1 : 0;
parameters2[9] = new SqlParameter("@RealStartTime", SqlDbType.VarChar, 20);
parameters2[9].Value = rostering2.RealStartTime;
parameters2[10] = new SqlParameter("@RealEndTime", SqlDbType.VarChar, 20);
parameters2[10].Value = rostering2.RealEndTime;
sql.Clear();
sql.AppendLine("DECLARE @ID int");
sql.AppendLine("INSERT INTO Rostering (bcName, startTime, earlyRange, endTime, lateRange, multType, mulripleDur, nightWork, flag, realStartTime, realEndTime)");
sql.AppendLine("VALUES (@Name, @StartTime, @EarlyRange, @EndTime, @LateRange, @MultipleType, @Duration, @NightWork, @Flag, @RealStartTime, @RealEndTime)");
sql.AppendLine("SET @ID = SCOPE_IDENTITY()");
sql.AppendLine("SELECT @ID");
int nextID = (int)helper.ExecuteScalar(sql.ToString(), parameters2);
//Assign the second record's ID to nextID column of the first record.
helper.ExecuteNonQuery("UPDATE Rostering SET nextID = " + nextID.ToString() + " WHERE ID = " + newID.ToString());
}
return newID;
}
public static bool Update(RosteringInfo rostering, RosteringInfo rostering2)
{
SqlParameter[] parameters = new SqlParameter[11];
parameters[0] = new SqlParameter("@Name", SqlDbType.VarChar, 20);
parameters[0].Value = rostering.Name;
parameters[1] = new SqlParameter("@StartTime", SqlDbType.VarChar, 20);
parameters[1].Value = DateUtility.FormatTime(rostering.StartTime);
parameters[2] = new SqlParameter("@EarlyRange", SqlDbType.Int);
parameters[2].Value = rostering.EarlyRange;
parameters[3] = new SqlParameter("@EndTime", SqlDbType.VarChar, 20);
parameters[3].Value = DateUtility.FormatTime(rostering.EndTime);
parameters[4] = new SqlParameter("@LateRange", SqlDbType.Int);
parameters[4].Value = rostering.LateRange;
parameters[5] = new SqlParameter("@Duration", SqlDbType.Decimal);
parameters[5].Value = rostering.Duration;
parameters[6] = new SqlParameter("@NightWork", SqlDbType.Int);
parameters[6].Value = rostering.NightWork;
parameters[7] = new SqlParameter("@Flag", SqlDbType.Int);
parameters[7].Value = rostering.Active ? 1 : 0;
parameters[8] = new SqlParameter("@RealStartTime", SqlDbType.VarChar, 20);
parameters[8].Value = rostering.RealStartTime;
parameters[9] = new SqlParameter("@RealEndTime", SqlDbType.VarChar, 20);
parameters[9].Value = rostering.RealEndTime;
parameters[10] = new SqlParameter("@ID", SqlDbType.Int);
parameters[10].Value = rostering.ID;
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE Rostering SET bcName = @Name");
sql.AppendLine(" , startTime = @StartTime");
sql.AppendLine(" , earlyRange = @EarlyRange");
sql.AppendLine(" , endTime = @EndTime");
sql.AppendLine(" , lateRange = @LateRange");
sql.AppendLine(" , mulripleDur = @Duration");
sql.AppendLine(" , nightWork = @NightWork");
sql.AppendLine(" , flag = @Flag");
sql.AppendLine(" , realStartTime = @RealStartTime");
sql.AppendLine(" , realEndTime = @RealEndTime");
sql.AppendLine("WHERE ID = @ID");
int rowCount = helper.ExecuteNonQuery(sql.ToString(), parameters.ToArray());
//Update the record of 'afternoon'
if (rostering2 != null) {
SqlParameter[] parameters2 = new SqlParameter[11];
parameters2[0] = new SqlParameter("@Name", SqlDbType.VarChar, 20);
parameters2[0].Value = rostering.Name;
parameters2[1] = new SqlParameter("@StartTime", SqlDbType.VarChar, 20);
parameters2[1].Value = DateUtility.FormatTime(rostering2.StartTime);
parameters2[2] = new SqlParameter("@EarlyRange", SqlDbType.Int);
parameters2[2].Value = rostering2.EarlyRange;
parameters2[3] = new SqlParameter("@EndTime", SqlDbType.VarChar, 20);
parameters2[3].Value = DateUtility.FormatTime(rostering2.EndTime);
parameters2[4] = new SqlParameter("@LateRange", SqlDbType.Int);
parameters2[4].Value = rostering2.LateRange;
parameters2[5] = new SqlParameter("@Duration", SqlDbType.Decimal);
parameters2[5].Value = rostering2.Duration;
parameters2[6] = new SqlParameter("@NightWork", SqlDbType.Int);
parameters2[6].Value = rostering2.NightWork;
parameters2[7] = new SqlParameter("@Flag", SqlDbType.Int);
parameters2[7].Value = rostering.Active ? 1 : 0;
parameters2[8] = new SqlParameter("@RealStartTime", SqlDbType.VarChar, 20);
parameters2[8].Value = rostering2.RealStartTime;
parameters2[9] = new SqlParameter("@RealEndTime", SqlDbType.VarChar, 20);
parameters2[9].Value = rostering2.RealEndTime;
parameters2[10] = new SqlParameter("@ID", SqlDbType.Int);
parameters2[10].Value = rostering.ID;
sql.Clear();
sql.AppendLine("UPDATE Rostering SET bcName = @Name");
sql.AppendLine(" , startTime = @StartTime");
sql.AppendLine(" , earlyRange = @EarlyRange");
sql.AppendLine(" , endTime = @EndTime");
sql.AppendLine(" , lateRange = @LateRange");
sql.AppendLine(" , mulripleDur = @Duration");
sql.AppendLine(" , nightWork = @NightWork");
sql.AppendLine(" , flag = @Flag");
sql.AppendLine(" , realStartTime = @RealStartTime");
sql.AppendLine(" , realEndTime = @RealEndTime");
sql.AppendLine("WHERE ID = (SELECT nextID FROM Rostering WHERE ID = @ID)");
rowCount = helper.ExecuteNonQuery(sql.ToString(), parameters2.ToArray());
}
return rowCount > 0;
}