/// <summary>
/// Verifica se as colunas existem
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public MapaColunaCrgDetalhe CriaMapaColuna(DataRow dr)
{
DataColumnCollection dcc = dr.Table.Columns;
MapaColunaCrgDetalhe mcCrgDet = new MapaColunaCrgDetalhe()
{
CodPrgCrg = -1,
TpIdentif = -1,
Identificacao = -1,
Valor = -1,
IdRegistro = -1
};
if (dcc.Contains("CodPrgCrg"))
mcCrgDet.CodPrgCrg = dcc["CodPrgCrg"].Ordinal;
if (dcc.Contains("TpIdentif"))
mcCrgDet.TpIdentif = dcc["TpIdentif"].Ordinal;
if (dcc.Contains("Identificacao"))
mcCrgDet.Identificacao = dcc["Identificacao"].Ordinal;
if (dcc.Contains("Valor"))
mcCrgDet.Valor = dcc["Valor"].Ordinal;
if(dcc.Contains("IdRegistro"))
mcCrgDet.IdRegistro = dcc["IdRegistro"].Ordinal;
return mcCrgDet;
}
/// <summary>
/// Verifica se as colunas existem
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public MapaColunaCrgDetalhe CriaMapaColuna(DataRow dr)
{
DataColumnCollection dcc = dr.Table.Columns;
MapaColunaCrgDetalhe mcCrgDet = new MapaColunaCrgDetalhe()
{
CodPrgCrg = -1,
TpIdentif = -1,
Identificacao = -1,
Valor = -1,
IdRegistro = -1
};
if (dcc.Contains("CodPrgCrg"))
{
mcCrgDet.CodPrgCrg = dcc["CodPrgCrg"].Ordinal;
}
if (dcc.Contains("TpIdentif"))
{
mcCrgDet.TpIdentif = dcc["TpIdentif"].Ordinal;
}
if (dcc.Contains("Identificacao"))
{
mcCrgDet.Identificacao = dcc["Identificacao"].Ordinal;
}
if (dcc.Contains("Valor"))
{
mcCrgDet.Valor = dcc["Valor"].Ordinal;
}
if (dcc.Contains("IdRegistro"))
{
mcCrgDet.IdRegistro = dcc["IdRegistro"].Ordinal;
}
return(mcCrgDet);
}
/// <summary>
/// Mapeia a partir da leitura Excel
/// </summary>
/// <param name="port"></param>
/// <param name="dr"></param>
public static List <ValidationResult> Mapeia(this ACSOPRGCRDetalheEN detCrgEn, DataRow dr, MapaColunaCrgDetalhe mapa)
{
List <ValidationResult> resultValid = new List <ValidationResult>();
try
{
//Obrigatórios
//PanProxy
if (mapa.TpIdentif > -1)
{
detCrgEn.TpPanProxy = (TipoPanProxy)Convert.ToByte(dr[mapa.TpIdentif].ToString());
}
else
{
resultValid.Add(new ValidationResult("Tipo da Identificação deve ser preenchida.", new[] { "TpIdentif" }));
}
if (mapa.Identificacao > -1)
{
detCrgEn.Identificacao = dr[mapa.Identificacao].ToString();
}
else
{
resultValid.Add(new ValidationResult("Identificação deve ser preenchida.", new[] { "Identificacao" }));
}
if (mapa.CodPrgCrg > -1)
{
detCrgEn.CodPrgCrg = dr[mapa.CodPrgCrg].ToString();
}
else
{
resultValid.Add(new ValidationResult("Código do programa de carga.", new[] { "CodPrgCrg" }));
}
if (mapa.Identificacao > -1)
{
detCrgEn.PanProxy = dr[mapa.Identificacao].ToString();
}
else
{
resultValid.Add(new ValidationResult("Pan/Proxy deve ser preenchida.", new[] { "Pan/Proxy" }));
}
if (mapa.Valor > -1)
{
detCrgEn.Valor = Convert.ToDecimal(dr[mapa.Valor].ToString());
}
else
{
resultValid.Add(new ValidationResult("Valor da carga deve ser preenchido.", new[] { "Valor" }));
}
string idRegistro = dr["IdRegistro"].ToString();
detCrgEn.IdRegistro = (!String.IsNullOrEmpty(idRegistro)) ? idRegistro : null;
detCrgEn.IdEntidade = dr["idEntidade"].ToString();
}
catch (Exception e)
{
if (upSight.Consulta.Base.BD.Geral.TS.TraceError)
{
Trace.TraceError("{0}: {1}", new object[] { "u.CrtCorp.ACSOPRGCR.PtrCN", e });
}
throw;
}
return(resultValid);
}
/// <summary>
/// Mapeia a partir da leitura Excel
/// </summary>
/// <param name="port"></param>
/// <param name="dr"></param>
public static List<ValidationResult> Mapeia(this ACSOPRGCRDetalheEN detCrgEn, DataRow dr, MapaColunaCrgDetalhe mapa)
{
List<ValidationResult> resultValid = new List<ValidationResult>();
try
{
//Obrigatórios
//PanProxy
if (mapa.TpIdentif > -1)
detCrgEn.TpPanProxy = (TipoPanProxy)Convert.ToByte(dr[mapa.TpIdentif].ToString());
else
resultValid.Add(new ValidationResult("Tipo da Identificação deve ser preenchida.", new[] { "TpIdentif" }));
if (mapa.Identificacao > -1)
detCrgEn.Identificacao = dr[mapa.Identificacao].ToString();
else
resultValid.Add(new ValidationResult("Identificação deve ser preenchida.", new[] { "Identificacao" }));
if (mapa.CodPrgCrg > -1)
detCrgEn.CodPrgCrg = dr[mapa.CodPrgCrg].ToString();
else
resultValid.Add(new ValidationResult("Código do programa de carga.", new[] { "CodPrgCrg" }));
if (mapa.Identificacao > -1)
detCrgEn.PanProxy = dr[mapa.Identificacao].ToString();
else
resultValid.Add(new ValidationResult("Pan/Proxy deve ser preenchida.", new[] { "Pan/Proxy" }));
if (mapa.Valor > -1)
detCrgEn.Valor = Convert.ToDecimal(dr[mapa.Valor].ToString());
else resultValid.Add(new ValidationResult("Valor da carga deve ser preenchido.", new[] { "Valor" }));
string idRegistro = dr["IdRegistro"].ToString();
detCrgEn.IdRegistro = (!String.IsNullOrEmpty(idRegistro)) ? idRegistro : null;
detCrgEn.IdEntidade = dr["idEntidade"].ToString();
}
catch (Exception e)
{
if (upSight.Consulta.Base.BD.Geral.TS.TraceError)
Trace.TraceError("{0}: {1}", new object[] { "u.CrtCorp.ACSOPRGCR.PtrCN", e });
throw;
}
return resultValid;
}
