public int AddOrModifyJobOverTimeHours(JobOverTimeHours job_overtime_hours, string type)
{
using (SqlConnection sqlConnection = new SqlConnection(this.ConnectionString))
{
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("spJobOverTime_InsertUpdateDetails", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@OverTimeID", job_overtime_hours.OverTimeID);
sqlCommand.Parameters.AddWithValue("@ProjectID", job_overtime_hours.ProjectID);
sqlCommand.Parameters.AddWithValue("@ProjectStatusID", job_overtime_hours.ProjectStatusID);
sqlCommand.Parameters.AddWithValue("@ProjectTypeID", job_overtime_hours.ProjectTypeID);
sqlCommand.Parameters.AddWithValue("@JobNumber", job_overtime_hours.JobNumber);
sqlCommand.Parameters.AddWithValue("@JobTypeID", job_overtime_hours.JobTypeID);
sqlCommand.Parameters.AddWithValue("@Date", job_overtime_hours.Date);
sqlCommand.Parameters.AddWithValue("@OverTime", job_overtime_hours.OverTimeName);
sqlCommand.Parameters.AddWithValue("@OverTimeHours", job_overtime_hours.OverTimeHours);
sqlCommand.Parameters.AddWithValue("@OverTimeDoneBy", job_overtime_hours.OverTimeDoneBy);
sqlCommand.Parameters.AddWithValue("@Active", job_overtime_hours.Active);
sqlCommand.Parameters.AddWithValue("@CreatedBy", job_overtime_hours.CreatedBy);
sqlCommand.Parameters.AddWithValue("@CreatedDate", job_overtime_hours.CreatedDate);
sqlCommand.Parameters.AddWithValue("@OperationMode", type);
sqlCommand.Parameters.AddWithValue("@Comments", job_overtime_hours.Comments);
sqlCommand.Parameters.AddWithValue("@DocumentTypeID", job_overtime_hours.DocumentTypeID);
//Sprint 21#TFS 44278,44472 UI - OverTime ChangesUI - OverTime Changes validation
sqlCommand.Parameters.AddWithValue("@EndDate", job_overtime_hours.EndDate);
sqlCommand.Parameters.AddWithValue("@LateBooking", job_overtime_hours.LateBooking);
sqlCommand.Parameters.AddWithValue("@Cancellation", job_overtime_hours.Cancellation);
sqlCommand.Parameters.AddWithValue("@OTShift", job_overtime_hours.OTShift);
int job_overtime_hrs = 0;
job_overtime_hrs = ExecuteNonQuery(sqlCommand);
return(job_overtime_hrs);
}
}
protected virtual JobOverTimeHours GetJobOverTimeHoursFromreader(IDataReader reader)
{
EntityConverter <JobOverTimeHours> jobOverTimeHoursExpenseEntity = new EntityConverter <JobOverTimeHours>();
JobOverTimeHours JobOverTimeExpense = jobOverTimeHoursExpenseEntity.Convert(reader);
return(JobOverTimeExpense);
}
