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