public int Save(TurnML Turn) { try { ModelDAL ModelDAL = new ModelDAL(); String Response = ModelDAL.InsertModel(Turn, TableName, IdUserSession); SqlConnection Conexion = new SqlConnection() { ConnectionString = ConnectionString }; using (SqlCommand cmd2 = new SqlCommand(Response.ToString(), Conexion)) { Conexion.Open(); int newID = (Int32)cmd2.ExecuteScalar(); if (Conexion.State == System.Data.ConnectionState.Open) { Conexion.Close(); } return(newID); } } catch (Exception ex) { throw new Exception(String.Format("{0}.save : {1}", core, ex)); } }
public TurnML GetEntity(DataRow row) { try { if (row != null) { TurnML TurnML = new TurnML() { Id = (row[TurnML.DataBase.Id] != DBNull.Value) ? int.Parse(row[TurnML.DataBase.Id].ToString()) : 0, Name = (row[TurnML.DataBase.Name] != DBNull.Value) ? row[TurnML.DataBase.Name].ToString() : string.Empty, Description = (row[TurnML.DataBase.Description] != DBNull.Value) ? row[TurnML.DataBase.Description].ToString() : string.Empty, TimeEntry = (row[TurnML.DataBase.TimeEntry] != DBNull.Value) ? Convert.ToDateTime(row[TurnML.DataBase.TimeEntry].ToString()):DateTime.Now, StartEntry = (row[TurnML.DataBase.StartEntry] != DBNull.Value) ? Convert.ToDateTime(row[TurnML.DataBase.StartEntry].ToString()) : DateTime.Now, LimitEntry = (row[TurnML.DataBase.LimitEntry] != DBNull.Value) ? Convert.ToDateTime(row[TurnML.DataBase.LimitEntry].ToString()) : DateTime.Now, Departuretime = (row[TurnML.DataBase.Departuretime] != DBNull.Value) ? Convert.ToDateTime(row[TurnML.DataBase.Departuretime].ToString()) : DateTime.Now, LimitDeparture = (row[TurnML.DataBase.LimitDeparture] != DBNull.Value) ? Convert.ToDateTime(row[TurnML.DataBase.LimitDeparture].ToString()) : DateTime.Now, HoursJornada = (row[TurnML.DataBase.HoursJornada] != DBNull.Value) ? Convert.ToDateTime(row[TurnML.DataBase.HoursJornada].ToString()) : DateTime.Now, }; return(TurnML); } return(null); } catch (Exception ex) { throw new Exception(String.Format("{0}.GetEntity : {1}", core, ex)); } }
private void buttonEliminar_Click(object sender, EventArgs e) { try { if (dataGridViewData.RowCount > 0) { int IdTurno = Int32.Parse(dataGridViewData.Rows[IdRowSelect].Cells["Id"].Value.ToString()); cFAT100010 Alert = new cFAT100010("Información", String.Format("¿Desea eliminar el registro {0}?", IdTurno), MessageBoxIcon.Question); Alert.ShowDialog(); if (Alert.DialogResult == DialogResult.Yes) { IdRowSelect = dataGridViewData.CurrentRow.Index; TurnML Turn = new TurnML() { Id = IdTurno }; TurnBLL.Delete(Turn); dataGridViewData.Rows.Remove(dataGridViewData.CurrentRow); } } else { cFAT100010 Alert = new cFAT100010("Información", "No hay datos", MessageBoxIcon.Information); Alert.ShowDialog(); } } catch (Exception ex) { MessageBox.Show(String.Format("buttonEliminar_Click: {0}", ex), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Delete(TurnML turn) { try { TurnDAL.Delete(turn); } catch (Exception ex) { throw new Exception(String.Format("{0}.Delete: {1}", core, ex)); } }
public int Save(TurnML Turn) { try { if (Turn.Id == 0) { return(TurnDAL.Save(Turn)); } else { return(TurnDAL.Update(Turn)); } } catch (Exception ex) { throw new Exception(String.Format("{0}.Save: {1}", core, ex)); } }
public void Delete(TurnML Turn) { try { ModelDAL ModelDAL = new ModelDAL(); String Response = ModelDAL.DeleteModel(Turn, TableName, IdUserSession); SqlConnection Conexion = new SqlConnection() { ConnectionString = ConnectionString }; Conexion.Open(); SqlCommand cmd2 = new SqlCommand(Response.ToString(), Conexion); cmd2.ExecuteNonQuery(); Conexion.Close(); } catch (Exception ex) { throw new Exception(String.Format("{0}.delete: {1}", core, ex)); } }
public void LoadTurnId(int IdTurno) { try { TurnML Turn = TurnBLL.GetIdEntity(IdTurn); IdTurn = Convert.ToInt32(Turn.Id.ToString()); textBoxTurno.Text = Turn.Name.ToString(); textBoxDescripcion.Text = Turn.Description.ToString(); dateTimeHoraEntrada.Text = Turn.TimeEntry.ToString(); dateTimeIniciaEntrada.Text = Turn.StartEntry.ToString(); dateTimeLimiteEntrada.Text = Turn.LimitEntry.ToString(); dateTimeHoraSalida.Text = Turn.Departuretime.ToString(); dateTimeLimiteSalida.Text = Turn.LimitDeparture.ToString(); textBoxHorasJornada.Text = Turn.HoursJornada.ToString("HH:mm:ss"); } catch (Exception ex) { MessageBox.Show(String.Format("LoadTurnId: {0}", ex.Message), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void buttonGuardar_Click(object sender, EventArgs e) { try { if (FormValidate()) { TurnML Turn = new TurnML() { Name = textBoxTurno.Text, Description = textBoxDescripcion.Text, TimeEntry = dateTimeHoraEntrada.Value, StartEntry = dateTimeIniciaEntrada.Value, LimitEntry = dateTimeLimiteEntrada.Value, Departuretime = dateTimeHoraSalida.Value, LimitDeparture = dateTimeLimiteSalida.Value, HoursJornada = Convert.ToDateTime(textBoxHorasJornada.Text) }; if (IdTurn > 0) { Turn.Id = IdTurn; } TurnBLL.Save(Turn); cFMTU100010 FrmDataGrid = this.Owner as cFMTU100010; FrmDataGrid.LoadDataGridView(); cFAT100010 Alert = new cFAT100010("Información", "Información Guardado con exito!!", MessageBoxIcon.Information); Alert.ShowDialog(); Clear(); this.Close(); } } catch (Exception ex) { MessageBox.Show(String.Format("buttonGuardar_Click: {0}", ex), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//--------------- NUEVA MIGRACION public void ListRecord(DateTime Start, DateTime End) { try { DataTable ListRecord = MigrationHistoryDAL.ListRecord(Start, End); TimeOutCheckBLL TimeOutCheckBLL = new TimeOutCheckBLL(); TurnBLL TurnBLL = new TurnBLL(); DataTable TimeOutCheckDT = TimeOutCheckBLL.TimeOutCheck("checkin"); DataTable TimeOutCheckMax = TimeOutCheckBLL.TimeOutCheck("maxihours"); //String TotalAddHours; //= new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0,0, 0); TimeSpan TotalAddHours; TimeSpan MaxAddHours; int idGetUser = 0; if (TimeOutCheckMax.Rows.Count > 0) { MaxAddHours = TimeSpan.Parse(TimeOutCheckMax.Rows[0]["timeCheck"].ToString()); } else { MaxAddHours = TimeSpan.Parse("00:00:00"); } //bool SinHoras = false; if (TimeOutCheckDT.Rows.Count > 0) { //TotalAddHours = TimeOutCheckDT.Rows[0]["timeCheck"].ToString(); TotalAddHours = TimeSpan.Parse(TimeOutCheckDT.Rows[0]["timeCheck"].ToString()); //SinHoras = true; } else { TotalAddHours = TimeSpan.Parse("00:00:00"); } if (ListRecord.Rows.Count > 0) { String NameTurn = String.Empty; CheckInHoursML CheckInHours = new CheckInHoursML(); foreach (DataRow Record in ListRecord.Rows) { idGetUser = MigrationHistoryDAL.getUserDialing(Record["idUser"].ToString()); //Verificar si es MARCACION VALIDA if (MigrationHistoryDAL.ValidRecord(Convert.ToDateTime(Record["dateTimeRecord"].ToString()), TotalAddHours, idGetUser) && idGetUser != 0) { //VERIFICAR SI NO EXISTE UNA MARCACION CON LOS MISMO PARAMETROS if (MigrationHistoryDAL.IsExistRecord(idGetUser, Convert.ToDateTime(Record["dateTimeRecord"].ToString())) == 0) { TurnML TurnUser = TurnBLL.GetTurnUser(Convert.ToDateTime(Record["dateTimeRecord"].ToString()), idGetUser); String RecordData = MigrationHistoryDAL.RecordOld(idGetUser); if (!String.IsNullOrEmpty(RecordData)) { DateTime RecordOldTime = Convert.ToDateTime(RecordData.ToString()); CheckInHours.IdEmployee = idGetUser; CheckInHours.MachineNumber = 1; CheckInHours.DateTimeRecord = Convert.ToDateTime(Record["dateTimeRecord"].ToString()); CheckInHours.DateOnlyRecord = Convert.ToDateTime(Record["dateOnlyRecord"].ToString()); CheckInHours.TimeOnlyRecord = TimeSpan.Parse(Record["timeOnlyRecord"].ToString()); CheckInHours.IdTurn = (TurnUser != null) ? TurnUser.Id : 0; TimeSpan TotalDiffHours = TotalDiffTime(RecordOldTime, Convert.ToDateTime(Record["dateTimeRecord"].ToString())); if (MaxAddHours > TotalDiffHours) { int Resul = MigrationHistoryDAL.NumRecordsUser(idGetUser) % 2; CheckInHours.TypeCheck = (Resul == 0)?"ENTRADA":"SALIDA"; } else { CheckInHours.TypeCheck = "ENTRADA"; } } else { if (TurnUser != null) { CheckInHours.IdEmployee = idGetUser; CheckInHours.MachineNumber = 1; CheckInHours.DateTimeRecord = Convert.ToDateTime(Record["dateTimeRecord"].ToString()); CheckInHours.DateOnlyRecord = Convert.ToDateTime(Record["dateOnlyRecord"].ToString()); CheckInHours.TimeOnlyRecord = TimeSpan.Parse(Record["timeOnlyRecord"].ToString()); CheckInHours.IdTurn = TurnUser.Id; CheckInHours.TypeCheck = "ENTRADA"; } else { CheckInHours.IdEmployee = idGetUser; CheckInHours.MachineNumber = 1; CheckInHours.DateTimeRecord = Convert.ToDateTime(Record["dateTimeRecord"].ToString()); CheckInHours.DateOnlyRecord = Convert.ToDateTime(Record["dateOnlyRecord"].ToString()); CheckInHours.TimeOnlyRecord = TimeSpan.Parse(Record["timeOnlyRecord"].ToString()); CheckInHours.IdTurn = 0; CheckInHours.TypeCheck = "ENTRADA"; } } CheckInHoursBLL CheckInHoursBLL = new CheckInHoursBLL(); CheckInHoursBLL.Save(CheckInHours); } } } } //return ListRecord; } catch (Exception ex) { throw new Exception(String.Format("{0}.ListRecord: {1}", core, ex)); } }
public DataTable ReportExtrasHours(DateTime DateStart, DateTime DateEnd, int IdTurn = 0, int IdDepartament = 0, int IdEmployee = 0) { try { DataTable HoursExtras = ReportsDAL.ReportExtras(DateStart, DateEnd, IdTurn, IdDepartament, IdEmployee); TurnBLL TurnBLL = new TurnBLL(); TimeSpan ExtraEntrada; TimeSpan ExtraSalida; TimeSpan RetardoEntrada; TimeSpan SalidaAntes; //return ReportsDAL.ReportExtras(DateStart, DateEnd); HoursExtras.Columns.Add("TiempoExtra", typeof(TimeSpan)); HoursExtras.Columns.Add("Retardos", typeof(TimeSpan)); foreach (DataRow Horas in HoursExtras.Rows) { TimeSpan HoraEntrada = TimeSpan.Parse(Convert.ToDateTime(Horas["ENTRADA"].ToString()).ToString("HH:mm:ss")); TimeSpan HoraSalida = TimeSpan.Parse(Convert.ToDateTime(Horas["SALIDA"].ToString()).ToString("HH:mm:ss")); ExtraEntrada = TimeSpan.Parse("00:00:00"); ExtraSalida = TimeSpan.Parse("00:00:00"); RetardoEntrada = TimeSpan.Parse("00:00:00"); SalidaAntes = TimeSpan.Parse("00:00:00"); if (Horas["TURNO"].ToString() != "HRS EXTRA") { TurnML TurnMLEmployee = TurnBLL.GetTurnForNaMe(Horas["TURNO"].ToString()); TimeSpan HoraInicial = TimeSpan.Parse(Convert.ToDateTime(TurnMLEmployee.StartEntry.ToString()).ToString("HH:mm:ss")); TimeSpan LimiteSalida = TimeSpan.Parse(Convert.ToDateTime(TurnMLEmployee.LimitDeparture.ToString()).ToString("HH:mm:ss")); TimeSpan LimiteEntrada = TimeSpan.Parse(Convert.ToDateTime(TurnMLEmployee.LimitEntry.ToString()).ToString("HH:mm:ss")); TimeSpan Salida = TimeSpan.Parse(Convert.ToDateTime(TurnMLEmployee.Departuretime.ToString()).ToString("HH:mm:ss")); if (HoraEntrada < HoraInicial) { ExtraEntrada = HoraInicial.Subtract(HoraEntrada); } if (HoraSalida > LimiteSalida) { ExtraSalida = HoraSalida.Subtract(LimiteSalida); } //RETARDOS if (HoraEntrada > LimiteEntrada) { RetardoEntrada = HoraEntrada.Subtract(LimiteEntrada); } if (HoraSalida < Salida && HoraSalida > HoraEntrada) { SalidaAntes = Salida.Subtract(HoraSalida); } else { RetardoEntrada = TimeSpan.Parse("00:00:00"); } Horas["TiempoExtra"] = SumToTime(ExtraEntrada, ExtraSalida); Horas["Retardos"] = SumToTime(RetardoEntrada, SalidaAntes); } else { Horas["TiempoExtra"] = HoraSalida.Subtract(HoraEntrada); Horas["Retardos"] = "00:00:00"; } } return(HoursExtras); } catch (Exception ex) { throw new Exception(String.Format("ReportExtrasHours: {0}", ex.Message)); } }
public DataTable ReportHoursJob(DateTime DateStart, DateTime DateEnd, int IdTurn = 0, int IdDepartament = 0, int IdEmployee = 0) { try { DataTable HoursExtras = ReportsDAL.ReportExtras(DateStart, DateEnd, IdTurn, IdDepartament, IdEmployee); TurnBLL TurnBLL = new TurnBLL(); EmployeeBLL EmployeeBLL = new EmployeeBLL(); TimeSpan ExtraEntrada; TimeSpan ExtraSalida; TimeSpan RetardoEntrada; TimeSpan SalidaAntes; TimeSpan HrsJornadas; TimeSpan HrsExtras; TimeSpan TotalHrsDia; String TotalHrs; HoursExtras.Columns.Add("HORASJORNADA", typeof(TimeSpan)); HoursExtras.Columns.Add("HORASEXTRAS", typeof(TimeSpan)); HoursExtras.Columns.Add("TOTAL_HRS", typeof(TimeSpan)); HoursExtras.Columns.Add("SUELDO_TOTAL", typeof(Decimal)); foreach (DataRow Horas in HoursExtras.Rows) { TimeSpan HoraEntrada = TimeSpan.Parse(Convert.ToDateTime(Horas["ENTRADA"].ToString()).ToString("HH:mm:ss")); TimeSpan HoraSalida = TimeSpan.Parse(Convert.ToDateTime(Horas["SALIDA"].ToString()).ToString("HH:mm:ss")); //int IdEmployee = Int32.Parse(Horas["CVE"].ToString()); ExtraEntrada = TimeSpan.Parse("00:00:00"); ExtraSalida = TimeSpan.Parse("00:00:00"); RetardoEntrada = TimeSpan.Parse("00:00:00"); SalidaAntes = TimeSpan.Parse("00:00:00"); //horasxDias = TimeSpan.Parse("00:00:00"); EmployeeML SalaryEmployeeML = EmployeeBLL.GetColumnsEmployee(Int32.Parse(Horas["CVE"].ToString())); Decimal Salario = Decimal.Parse(SalaryEmployeeML.Salary.ToString()); Decimal horasxDias = Decimal.Parse(SalaryEmployeeML.HoursDay.ToString()); if (Horas["TURNO"].ToString() != "HRS EXTRA") { TurnML TurnMLEmployee = TurnBLL.GetTurnForNaMe(Horas["TURNO"].ToString()); TimeSpan HoraInicial = TimeSpan.Parse(Convert.ToDateTime(TurnMLEmployee.StartEntry.ToString()).ToString("HH:mm:ss")); TimeSpan LimiteSalida = TimeSpan.Parse(Convert.ToDateTime(TurnMLEmployee.LimitDeparture.ToString()).ToString("HH:mm:ss")); TimeSpan LimiteEntrada = TimeSpan.Parse(Convert.ToDateTime(TurnMLEmployee.LimitEntry.ToString()).ToString("HH:mm:ss")); TimeSpan Salida = TimeSpan.Parse(Convert.ToDateTime(TurnMLEmployee.Departuretime.ToString()).ToString("HH:mm:ss")); TimeSpan HorasJornada = TimeSpan.Parse(Convert.ToDateTime(TurnMLEmployee.HoursJornada.ToString()).ToString("HH:mm:ss")); //HORAS EXTRAS if (HoraEntrada < HoraInicial) { ExtraEntrada = HoraInicial.Subtract(HoraEntrada); } if (HoraSalida > LimiteSalida) { ExtraSalida = HoraSalida.Subtract(LimiteSalida); } //HORAS JORNADA NORMAL if (HoraEntrada != TimeSpan.Parse("00:00:00") && HoraSalida != TimeSpan.Parse("00:00:00")) { Horas["HORASJORNADA"] = HorasJornada; HrsJornadas = HorasJornada; } else { Horas["HORASJORNADA"] = TimeSpan.Parse("00:00:00"); HrsJornadas = TimeSpan.Parse("00:00:00"); } Horas["HORASEXTRAS"] = SumToTime(ExtraEntrada, ExtraSalida); HrsExtras = SumToTime(ExtraEntrada, ExtraSalida); } else { Horas["HORASJORNADA"] = TimeSpan.Parse("00:00:00"); Horas["HORASEXTRAS"] = HoraSalida.Subtract(HoraEntrada); HrsJornadas = TimeSpan.Parse("00:00:00"); HrsExtras = HoraSalida.Subtract(HoraEntrada);; } Horas["TOTAL_HRS"] = SumToTime(HrsJornadas, HrsExtras); TotalHrsDia = SumToTime(HrsJornadas, HrsExtras); TotalHrs = Convert.ToDecimal(Convert.ToDecimal(TotalHrsDia.Hours) + (Convert.ToDecimal(TotalHrsDia.Minutes))).ToString("#.00"); if (horasxDias > 0) { Horas["SUELDO_TOTAL"] = (Salario / 15 / horasxDias) * Convert.ToDecimal(TotalHrs); } else { Horas["SUELDO_TOTAL"] = 0; } } return(HoursExtras); } catch (Exception ex) { throw new Exception(String.Format("ReportHoursJob: {0}", ex.Message)); } }