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