private void ImportData()
{
try
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
string VendorNo = "";
foreach (DataRow rd in dt.Rows)
{
if (!rd["VendorName"].ToString().Equals(""))
{
var x = (from ix in db.tb_Vendors where ix.VendorNo.ToLower().Trim() == rd["VendorNo"].ToString().ToLower().Trim() select ix).FirstOrDefault();
if (x == null)
{
tb_Vendor ts = new tb_Vendor();
VendorNo = dbClss.TSt(rd["VendorNo"].ToString());
if (VendorNo == "")
{
ts.VendorNo = dbClss.GetNo(1, 2);
}
else
{
ts.VendorNo = VendorNo;
}
ts.VendorName = Convert.ToString(rd["VendorName"].ToString());
ts.Address = Convert.ToString(rd["Address"].ToString());
ts.CRRNCY = Convert.ToString(rd["CRRNCY"].ToString());
ts.Remark = Convert.ToString(rd["Remark"].ToString());
ts.Active = Convert.ToBoolean(rd["Active"].ToString());
db.tb_Vendors.InsertOnSubmit(ts);
db.SubmitChanges();
}
else
{
x.VendorName = Convert.ToString(rd["VendorName"].ToString());
x.Address = Convert.ToString(rd["Address"].ToString());
x.CRRNCY = Convert.ToString(rd["CRRNCY"].ToString());
x.Remark = Convert.ToString(rd["Remark"].ToString());
x.Active = Convert.ToBoolean(rd["Active"].ToString());
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(g.Cells["VendorName"].Value).Equals("") &&
!Convert.ToString(g.Cells["CRRNCY"].Value).Equals("")
)
{
if (Convert.ToString(g.Cells["dgvC"].Value).Equals("T"))
{
if (Convert.ToString(g.Cells["dgvCodeTemp"].Value).Equals(""))
{
// MessageBox.Show("11");
tb_Vendor gy = new tb_Vendor();
gy.VendorNo = dbClss.GetNo(1, 2);
gy.Active = Convert.ToBoolean(g.Cells["Active"].Value);
gy.VendorName = Convert.ToString(g.Cells["VendorName"].Value);
gy.CRRNCY = Convert.ToString(g.Cells["CRRNCY"].Value);
gy.Address = Convert.ToString(g.Cells["Address"].Value);
gy.Remark = Convert.ToString(g.Cells["Remark"].Value);
db.tb_Vendors.InsertOnSubmit(gy);
db.SubmitChanges();
dbClss.AddHistory(this.Name, "เพิ่มผู้ขาย", "เพิ่มผู้ขาย [" + gy.VendorName + "]", "");
C += 1;
}
else
{
var unit1 = (from ix in db.tb_Vendors
where ix.VendorNo == Convert.ToString(g.Cells["dgvCodeTemp"].Value)
select ix).First();
unit1.VendorName = Convert.ToString(g.Cells["VendorName"].Value);
unit1.Active = Convert.ToBoolean(g.Cells["Active"].Value);
unit1.Address = Convert.ToString(g.Cells["Address"].Value);
unit1.CRRNCY = Convert.ToString(g.Cells["CRRNCY"].Value);
unit1.Remark = Convert.ToString(g.Cells["Remark"].Value);
// unit1.VendorName = Convert.ToString(g.Cells["VendorName"].Value);
C += 1;
db.SubmitChanges();
dbClss.AddHistory(this.Name, "แก้ไข", "แก้ไขผู้ขาย [" + unit1.VendorName + "]", "");
}
}
}
else
{
MessageBox.Show("กรอกข้อมูลไม่ครบ!");
}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message);
dbClss.AddError("เพิ่มผู้ขาย", ex.Message, this.Name); }
if (C > 0)
{
MessageBox.Show("บันทึกสำเร็จ!");
}
return(ck);
}
