private void ImportData() { try { using (DataClasses1DataContext db = new DataClasses1DataContext()) { foreach (DataRow rd in dt.Rows) { if (!rd["CRRNCY"].ToString().Equals("")) { var x = (from ix in db.tb_CRRNCies where ix.CRRNCY.ToLower().Trim() == rd["CRRNCY"].ToString().ToLower().Trim() select ix).FirstOrDefault(); if (x == null) { tb_CRRNCY ts = new tb_CRRNCY(); ts.CRRNCY = Convert.ToString(rd["CRRNCY"].ToString()); ts.Rate = Convert.ToDecimal(rd["Rate"].ToString()); //ts.UnitActive = Convert.ToBoolean(rd["UnitActive"].ToString()); db.tb_CRRNCies.InsertOnSubmit(ts); db.SubmitChanges(); } else { x.Rate = Convert.ToDecimal(rd["Rate"].ToString()); //x.UnitActive = Convert.ToBoolean(rd["UnitActive"].ToString()); db.SubmitChanges(); } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); dbClss.AddError("ImportData", ex.Message, this.Name); } }
private bool AddUnit() { bool ck = false; int C = 0; try { radGridView1.EndEdit(); using (DataClasses1DataContext db = new DataClasses1DataContext()) { foreach (var g in radGridView1.Rows) { if (!Convert.ToString(g.Cells["CRRNCY"].Value).Equals("") && g.IsVisible) { if (Convert.ToString(g.Cells["dgvC"].Value).Equals("T")) { if (Convert.ToString(g.Cells["dgvCRRNCYTemp"].Value).Equals("")) { // MessageBox.Show("11"); tb_CRRNCY u = new tb_CRRNCY(); u.CRRNCY = Convert.ToString(g.Cells["CRRNCY"].Value); //u.UnitActive = Convert.ToBoolean(g.Cells["UnitActive"].Value); u.Rate = dbClss.TDe(g.Cells["Rate"].Value); db.tb_CRRNCies.InsertOnSubmit(u); db.SubmitChanges(); C += 1; dbClss.AddHistory(this.Name, "เพิ่ม", "Insert CRRNCY Code [" + u.CRRNCY + "]", ""); } else { var unit1 = (from ix in db.tb_CRRNCies where ix.CRRNCY == Convert.ToString(g.Cells["dgvCRRNCYTemp"].Value) select ix).First(); unit1.Rate = dbClss.TDe(g.Cells["Rate"].Value); //unit1.UnitActive = Convert.ToBoolean(g.Cells["UnitActive"].Value); C += 1; db.SubmitChanges(); dbClss.AddHistory(this.Name, "แก้ไข", "Update CRRNCY Code [" + unit1.CRRNCY + "]", ""); } } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); dbClss.AddError("AddCRRNCY", ex.Message, this.Name); } if (C > 0) { MessageBox.Show("บันทึกสำเร็จ!"); } return(ck); }