private int AddDoreDetail(PostDataSetTableAdapters.DoreDetailTableAdapter db, int doreId, string marsoole_id, string sender, string receiver, string destination, string detail_time, string hagh_maghar, string destination_code, string source_code, string d, string vazn, string mablagh_ezhar, string haghe_bime, string maliat, string hagh_sahm_p, string hagh_sahm_t_gh, string price) { if (marsoole_id.Trim() == "جمع") { return(-1); } sender = sender.RemoveArabicKaf().ReplaceWithArabicYa(); receiver = receiver.RemoveArabicKaf().ReplaceWithArabicYa(); destination = destination.RemoveArabicKaf().ReplaceWithArabicYa(); //marsoole_id = Encoding.Unicode.GetString(Encoding.ASCII.GetBytes(marsoole_id)); //sender = Encoding.Unicode.GetString(Encoding.ASCII.GetBytes(sender)); //receiver = Encoding.Unicode.GetString(Encoding.ASCII.GetBytes(receiver)); //destination = Encoding.Unicode.GetString(Encoding.ASCII.GetBytes(destination)); //detail_time = Encoding.Unicode.GetString(Encoding.ASCII.GetBytes(detail_time)); return(db.InsertDoreDetail(doreId, marsoole_id, sender, receiver, destination, detail_time, hagh_maghar.ToLong(), destination_code, source_code, d, vazn.ToDouble(), mablagh_ezhar.ToLong(), haghe_bime.ToLong(), maliat.ToLong(), hagh_sahm_p.ToLong(), hagh_sahm_t_gh.ToLong(), price.ToLong())); // return -1; }
public DataView GetDoreDetail(int doreId) { if (doreId <= 0) { return(null); } using (var db = new PostDataSetTableAdapters.DoreDetailTableAdapter()) { return(new DataView(db.GetDetailByDoreId(doreId))); } }
public void AddDoreDetailFromFiles(List <string> files, int ignoreRows, int doreId, BackgroundWorker worker) { using (var adapter = new PostDataSetTableAdapters.DoreDetailTableAdapter()) //using (var trans = new TransactionScope()) { adapter.Connection.Open(); adapter.Transaction = adapter.Connection.BeginTransaction(); foreach (var file in files) { if (File.Exists(file)) { FileStream stream = null; IExcelDataReader excelReader = null; try { stream = File.Open(file.ToString(), FileMode.Open, FileAccess.Read); excelReader = Excel.ExcelReaderFactory.CreateOpenXmlReader(stream); DataSet dataset = excelReader.AsDataSet(); if (dataset == null) { return; } DataTable dt = dataset.Tables[0]; if (doreId > 0) { for (int i = ignoreRows + 1; i < dt.Rows.Count; i++) { if (dt.Rows[i][0] == null || dt.Rows[i][0].ToString() == "") { break; } AddDoreDetail(adapter, doreId, dt.Rows[i][27].ToString(), dt.Rows[i][24].ToString(), dt.Rows[i][22].ToString(), dt.Rows[i][21].ToString(), dt.Rows[i][20].ToString(), dt.Rows[i][19].ToString(), dt.Rows[i][18].ToString(), dt.Rows[i][17].ToString(), dt.Rows[i][16].ToString(), dt.Rows[i][15].ToString(), dt.Rows[i][12].ToString(), dt.Rows[i][9].ToString(), dt.Rows[i][8].ToString(), dt.Rows[i][5].ToString(), dt.Rows[i][3].ToString(), dt.Rows[i][0].ToString()); } } } catch (Exception ex) { adapter.Transaction.Rollback(); if (ex.Message.Contains("because it is being used by another process")) { throw new Exception("فایل \r\n" + file + "\r\n در حال استفاده است ابتدا آن را بسته و سپس اقدام کنید."); } else { throw ex; } } finally { try { if (excelReader != null) { excelReader.Close(); } stream.Close(); } catch { } } } worker.ReportProgress(0); } adapter.Transaction.Commit(); } }