public static void ORM(Upload o, DataRow r)
{
try
{
o.CantErrores = Int32.Parse((r[UploaDS.COLUMN_CANT_ERRORS].ToString()));
o.IDUpload = Int64.Parse(r[UploaDS.COLUMN_IDUPLOAD].ToString());
o.Fecha = null;
if (r[UploaDS.COLUMN_DATETIME] != DBNull.Value)
o.Fecha = (DateTime)r[UploaDS.COLUMN_DATETIME];
o.FileName = r[UploaDS.COLUMN_FILENAME].ToString();
o.FileHash = r[UploaDS.COLUMN_FILEHASH].ToString();
o.Start_Date = null;
if (r[UploaDS.COLUMN_ST_DATETIME] != DBNull.Value)
o.Start_Date = (DateTime)r[UploaDS.COLUMN_ST_DATETIME];
o.End_Date = null;
if (r[UploaDS.COLUMN_FN_DATETIME] != DBNull.Value)
o.End_Date = (DateTime)r[UploaDS.COLUMN_FN_DATETIME];
o.Total_Lines = Int32.Parse((r[UploaDS.COLUMN_TOTAL_LINES].ToString()));
o.Line_Proceses = Int32.Parse((r[UploaDS.COLUMN_LINE_PROCESSES].ToString()));
o.Line_Errors = Int32.Parse((r[UploaDS.COLUMN_LINE_ERRORS].ToString()));
o.Descripcion = r[UploaDS.COLUMN_DESCRIPTION].ToString();
o.Inserted_Rcd = Int32.Parse((r[UploaDS.COLUMN_INSERTED_RCD].ToString()));
o.Updated_Rcd = Int32.Parse((r[UploaDS.COLUMN_UPDATED_RCD].ToString()));
o.Deleted_Rcd = Int32.Parse((r[UploaDS.COLUMN_DELETED_RCD].ToString()));
o.IDEmpresa = null;
if (r[UploaDS.COLUMN_IDEMPRESA] != DBNull.Value)
o.IDEmpresa = Int32.Parse((r[UploaDS.COLUMN_IDEMPRESA].ToString()));
o.Empresa_Nombre = r[UploaDS.COLUMN_EMPRESA_NOMBRE].ToString();
}
catch (Exception ex)
{
throw ex;
}
}
public static Upload GetById(int id)
{
Upload Result = null;
try
{
UploaDS DS = new UploaDS();
String objectHash = Guid.NewGuid().ToString();
DataRow dr = DS.GetObjectById(id, objectHash);
if (dr != null)
{
Result = new Upload();
ORM(Result, dr);
}
}
catch (Exception ex)
{
throw ex;
}
return Result;
}
public static List<Upload> List(FiltroUpload f, out int RecordCount)
{
List<Upload> resultList = new List<Upload>();
try
{
UploaDS dataservice = new UploaDS();
DataSet ds = dataservice.List(f, out RecordCount);
if (ds.Tables.Count > 0)
foreach (DataRow r in ds.Tables[0].Rows)
{
Upload a = new Upload();
ORM(a, r);
resultList.Add(a);
}
}
catch (Exception ex)
{
throw ex;
}
return resultList;
}
public void SetUpdateInControls(Upload upLoad)
{
this.txtEmpresa.Text = upLoad.Empresa_Nombre;
this.txtFecha.Text = upLoad.Fecha != null ? upLoad.Fecha.Value.ToShortDateString() : string.Empty;
this.txtEstados.Text = upLoad.CantErrores == 0 ? Resource.LBL_UPLOAD_HIT : Resource.LBL_UPLOAD_FAIL;
this.txtFileLines.Text = upLoad.Total_Lines.ToString();
this.txtLineErrors.Text = upLoad.Line_Errors.ToString();
this.txtLineProc.Text = upLoad.Line_Proceses.ToString();
this.txtSTFecha.Text = upLoad.Start_Date.ToString();
this.txtFNFecha.Text = upLoad.End_Date.ToString();
this.txtUpdateLine.Text = upLoad.Updated_Rcd.ToString();
this.txtInsetedLine.Text = upLoad.Inserted_Rcd.ToString();
this.txtDeletedLine.Text = upLoad.Deleted_Rcd.ToString();
this.txtNombreArchivo.Text = upLoad.FileName;
// Alineamiento de las columnas
this.dtgUploads.Columns[(int)ColumnasListado.ID_ERROR_TYPE].ItemStyle.HorizontalAlign = HorizontalAlign.Right;
this.dtgUploads.Columns[(int)ColumnasListado.FILELINE].ItemStyle.HorizontalAlign = HorizontalAlign.Right;
this.dtgUploads.Columns[(int)ColumnasListado.INFORMATION].ItemStyle.HorizontalAlign = HorizontalAlign.Left;
this.dtgUploads.Columns[(int)ColumnasListado.ERROR_DESCRIPCTION].ItemStyle.HorizontalAlign = HorizontalAlign.Left;
}
