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