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); }