public bool ImportaDados(DataTable dt, string responsavel)
{
DataTable dtCloned = dt.Clone();
dtCloned.Columns.Add("DESC_USER", typeof(string));
dtCloned.Columns.Add("DAT_IMPORTACAO", typeof(DateTime));
dtCloned.Columns[5].DataType = typeof(DateTime);
dtCloned.Columns[6].DataType = typeof(Decimal);
DateTime DataHora = DateTime.Now;
string userName = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
foreach (DataRow row in dt.Rows)
{
dtCloned.ImportRow(row);
}
foreach (DataRow row in dtCloned.Rows)
{
row["DESC_USER"] = userName;
row["DAT_IMPORTACAO"] = DataHora;
//row["VALOR"] = row["VALOR"].ToString().Replace(",", ".");
}
Deletar();
var obj = new ImportaBaseSerasaDAL().ImportaDados(dtCloned);
return(obj);
}
public int GeraRemessa()
{
int CodRemessa = new ImportaBaseSerasaDAL().GeraRemessa();
return(CodRemessa);
}
