public void insertWorkShift(DTO_WorkShift workShift)
{
String query = "INSERT INTO CALAM values(@workShiftID, @userID, @workDate, @startAt, @endAt)";
SqlCommand command = new SqlCommand(query, DAL_CDBConnect.myconn);
command.Parameters.Add("@workShiftID", SqlDbType.VarChar).Value = workShift.WorkShiftID;
command.Parameters.Add("@userID", SqlDbType.Char).Value = workShift.UserID;
command.Parameters.Add("@workDate", SqlDbType.DateTime).Value = workShift.DateWork;
command.Parameters.Add("@startAt", SqlDbType.Float).Value = Math.Round(workShift.BeginAt, 2);
command.Parameters.Add("@endAt", SqlDbType.Float).Value = workShift.EndAt;
command.ExecuteNonQuery();
command.Dispose();
}
public void insertWorkShift(DTO_WorkShift workShift)
{
new DAL_WorkShift().insertWorkShift(workShift);
}
