private void ImportData() { try { using (DataClasses1DataContext db = new DataClasses1DataContext()) { foreach (DataRow rd in dt.Rows) { if (!rd["VendorNo"].ToString().Equals("") && !rd["ContactName"].ToString().Equals("")) { var x = (from ix in db.tb_VendorContacts where ix.VendorNo.ToLower().Trim() == rd["VendorNo"].ToString().ToLower().Trim() && ix.ContactName.Trim().ToLower() == rd["ContactName"].ToString().Trim().ToLower() select ix).FirstOrDefault(); if (x == null) { tb_VendorContact ts = new tb_VendorContact(); ts.VendorNo = Convert.ToString(rd["VendorNo"].ToString()); ts.ContactName = Convert.ToString(rd["ContactName"].ToString()); try { ts.DefaultNo = Convert.ToBoolean(rd["DefaultNo"].ToString()); } catch { ts.DefaultNo = false; } ts.Tel = Convert.ToString(rd["Tel"].ToString()); ts.Mobile = Convert.ToString(rd["Tel"].ToString()); ts.Fax = Convert.ToString(rd["Fax"].ToString()); ts.Email = Convert.ToString(rd["Email"].ToString()); db.tb_VendorContacts.InsertOnSubmit(ts); db.SubmitChanges(); } else { x.Tel = Convert.ToString(rd["Tel"].ToString()); x.Mobile = Convert.ToString(rd["Tel"].ToString()); x.Fax = Convert.ToString(rd["Fax"].ToString()); x.Email = Convert.ToString(rd["Email"].ToString()); try { x.DefaultNo = Convert.ToBoolean(rd["DefaultNo"].ToString()); } catch { x.DefaultNo = false; } db.SubmitChanges(); } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); dbClss.AddError("InportData", 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(cboVendor.Text.Trim()).Equals("")) { if (Convert.ToString(g.Cells["dgvC"].Value).Equals("T")) { if (Convert.ToString(g.Cells["VendorNo"].Value).Equals("")) { // MessageBox.Show("11"); tb_VendorContact gy = new tb_VendorContact(); gy.id = 0; gy.VendorNo = cboVendor.Text.Trim(); gy.ContactName = Convert.ToString(g.Cells["ContactName"].Value); gy.DefaultNo = Convert.ToBoolean(g.Cells["DefaultNo"].Value); gy.Tel = Convert.ToString(g.Cells["Tel"].Value); gy.Fax = Convert.ToString(g.Cells["Fax"].Value); gy.Mobile = Convert.ToString(g.Cells["Tel"].Value); gy.Email = Convert.ToString(g.Cells["Email"].Value); db.tb_VendorContacts.InsertOnSubmit(gy); db.SubmitChanges(); C += 1; dbClss.AddHistory(this.Name, "เพิ่มผู้ติดต่อ", "เพิ่มรายชื่อ [" + cboVendor.Text + "," + gy.ContactName + "]", ""); } else { var unit1 = (from ix in db.tb_VendorContacts where ix.id == Convert.ToInt32(g.Cells["id"].Value) select ix).First(); unit1.ContactName = Convert.ToString(g.Cells["ContactName"].Value); unit1.Tel = Convert.ToString(g.Cells["Tel"].Value); unit1.Mobile = Convert.ToString(g.Cells["Tel"].Value); unit1.Fax = Convert.ToString(g.Cells["Fax"].Value); unit1.Email = Convert.ToString(g.Cells["Email"].Value); unit1.DefaultNo = Convert.ToBoolean(g.Cells["DefaultNo"].Value); C += 1; db.SubmitChanges(); dbClss.AddHistory(this.Name, "แก้ไขผู้ติดต่อ", "รายชื่อผู้ติดต่อ [" + cboVendor.Text + "," + unit1.ContactName + "]", ""); } } } else { MessageBox.Show("กรุณาเลือก รหัสผู้ขายก่อน !"); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); dbClss.AddError("เพิ่มแก้ไข ผู้ติดต่อ", ex.Message, this.Name); } if (C > 0) { MessageBox.Show("บันทึกสำเร็จ!"); } return(ck); }