public bool InsertTransection(TransectionDB tb)
{
try
{
using (transec_datasetDataContext dc = new transec_datasetDataContext())
{
TransectionDB objEmp = new TransectionDB();
objEmp.Id = tb.Id;
objEmp.Transaction_Id = tb.Transaction_Id;
objEmp.Amount = tb.Amount;
objEmp.Currency_Code = tb.Currency_Code;
objEmp.Transaction_Date = tb.Transaction_Date;
objEmp.Status = tb.Status;
dc.TransectionDBs.InsertOnSubmit(objEmp);
dc.SubmitChanges();
}
OperationMessage = "Inserted.";
return(true);
}
catch (Exception ex)
{
OperationMessage = ex.Message;
return(false);
}
}
public List <TransectionDB> ReadCsvFile(string file)
{
try
{
List <TransectionDB> tdbL = new List <TransectionDB>();
string Fulltext;
if (FileUpload1.HasFile)
{
using (StreamReader sr = new StreamReader(file))
{
while (!sr.EndOfStream)
{
Fulltext = sr.ReadToEnd().ToString();
string[] rows = Fulltext.Split('\n');
for (int i = 0; i < rows.Count() - 1; i++)
{
if (rows[i] != "")
{
string[] rowValues = rows[i].Replace("\r", "").Split(',');
{
TransectionDB tdb = new TransectionDB();
tdb.Id = Guid.NewGuid();
tdb.Transaction_Id = rowValues[0].ToString();
tdb.Amount = decimal.Parse(rowValues[1].ToString());
tdb.Currency_Code = rowValues[2].ToString();
tdb.Transaction_Date = DateTime.ParseExact(rowValues[3].ToString(), "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
tdb.Status = rowValues[4].ToString();
tdbL.Add(tdb); //add other rows
}
}
}
}
}
}
return(tdbL);
}
catch (Exception ex)
{
ValidationMessage = "UnValidation format." + ex.Message;
return(null);
}
}
partial void DeleteTransectionDB(TransectionDB instance);
partial void UpdateTransectionDB(TransectionDB instance);
partial void InsertTransectionDB(TransectionDB instance);
