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