private bool AddUnit()
{
bool ck = false;
int C = 0;
try
{
dgvData.EndEdit();
bool newDoc = false;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
int id = txtid.Text.ToInt();
var vndr = db.mh_Vendors.Where(x => x.id == id).FirstOrDefault();
if (vndr == null)
{
vndr = new mh_Vendor();
db.mh_Vendors.InsertOnSubmit(vndr);
newDoc = true;
dbClss.AddHistory(this.Name, "Vendor", $"New Vendor {txtNo.Text}", vndr.No);
}
if (!newDoc)
{
string vNo = txtNo.Text;
if (vndr.No != txtNo.Text.Trim())
{
dbClss.AddHistory(this.Name, "Vendor", $"Vendor No. from {vndr.No} to {txtNo.Text}", vNo);
}
if (vndr.BranchCode != txtBranchCode.Text.Trim())
{
dbClss.AddHistory(this.Name, "Vendor", $"Branch Code from {vndr.BranchCode} to {txtBranchCode.Text}", vNo);
}
if (vndr.Name != txtName.Text.Trim())
{
dbClss.AddHistory(this.Name, "Vendor", $"Vendor Name from {vndr.Name} to {txtName.Text}", vNo);
}
if (vndr.Address != txtAddress.Text.Trim())
{
dbClss.AddHistory(this.Name, "Vendor", $"Address from {vndr.Address} to {txtAddress.Text}", vNo);
}
if (vndr.ShippingTime != txtShippingTime.Value.ToInt())
{
dbClss.AddHistory(this.Name, "Vendor", $"Shipping time from {vndr.ShippingTime} to {txtShippingTime.Value.ToInt()}", vNo);
}
if (vndr.VATRegistration != cbVatRegis.Checked)
{
dbClss.AddHistory(this.Name, "Vendor", $"VAT Regis. from {vndr.VATRegistration} to {cbVatRegis.Checked}", vNo);
}
if (vndr.PriceIncludeingVat != cbPriceIncVat.Checked)
{
dbClss.AddHistory(this.Name, "Vendor", $"Price Inc. Vat from {vndr.PriceIncludeingVat} to {cbPriceIncVat.Checked}", vNo);
}
if (vndr.ReceivingAddress != txtShippingAddress.Text.Trim())
{
dbClss.AddHistory(this.Name, "Vendor", $"Receive Address from {vndr.ReceivingAddress} to {txtShippingAddress.Text}", vNo);
}
if (vndr.VendorGroup != cbbCustomerGroup.SelectedValue.ToInt())
{
dbClss.AddHistory(this.Name, "Vendor", $"Vendor Group from {vndr.VendorGroup} to {cbbCustomerGroup.SelectedValue.ToInt()}", vNo);
}
if (vndr.VatGroup != cbbVatGroup.SelectedValue.ToInt())
{
dbClss.AddHistory(this.Name, "Vendor", $"Vat Group from {vndr.VatGroup} to {cbbVatGroup.SelectedValue.ToInt()}", vNo);
}
if (vndr.DefaultCurrency != cbbCurrency.SelectedValue.ToInt())
{
dbClss.AddHistory(this.Name, "Vendor", $"Default Currency from {vndr.DefaultCurrency} to {cbbCurrency.SelectedValue.ToInt()}", vNo);
}
if (vndr.Active != cbActive.Checked)
{
dbClss.AddHistory(this.Name, "Vendor", $"Status Active from {vndr.Active} to {cbActive.Checked}", vNo);
}
if (vndr.VatRegisNo.ToSt() != txtVatRegisNo.Text.Trim())
{
dbClss.AddHistory(this.Name, "Vendor", $"Vat Registration No. from {vndr.VatRegisNo} to {txtVatRegisNo.Text.Trim()}", vNo);
}
if (txtAttachFile.Value.ToSt() != "")
{
if (vndr.AttachFile != Path.GetFileName(txtAttachFile.Value.ToSt()))
{
dbClss.AddHistory(this.Name, "Vendor", $"Attach file from {vndr.AttachFile} to {Path.GetFileName(txtAttachFile.Value.ToSt())}", vNo);
}
}
}
vndr.No = txtNo.Text.Trim();
vndr.BranchCode = txtBranchCode.Text;
vndr.Name = txtName.Text.Trim();
vndr.Address = txtAddress.Text.Trim();
vndr.ShippingTime = txtShippingTime.Value.ToInt();
vndr.VATRegistration = cbVatRegis.Checked;
vndr.PriceIncludeingVat = cbPriceIncVat.Checked;
vndr.ReceivingAddress = txtShippingAddress.Text.Trim();
vndr.VendorGroup = cbbCustomerGroup.SelectedValue.ToInt();
vndr.VatGroup = cbbVatGroup.SelectedValue.ToInt();
vndr.DefaultCurrency = cbbCurrency.SelectedValue.ToInt();
vndr.Active = cbActive.Checked;
vndr.VatRegisNo = txtVatRegisNo.Text.Trim();
db.SubmitChanges();
//file
string fullPath = txtAttachFile.Value.ToSt();
string fName = "";
try
{
if (Path.GetFileName(fullPath) != fullPath)
{
try
{
fName = vndr.id.ToSt() + "_" + Path.GetFileName(fullPath);
File.Copy(fullPath, Path.Combine(baseClass.GetPathServer(PathCode.Vendor), fName), true);
fullPath = fName;
}
catch (Exception ex) { baseClass.Error(ex.Message); fName = ""; }
}
}
catch (Exception ex)
{
baseClass.Error(ex.Message);
}
vndr.AttachFile = fName;
db.SubmitChanges();
txtid.Text = vndr.id.ToSt();
foreach (var c in dgvData.Rows)
{
newDoc = false;
if (c.Cells["dgvC"].Value.ToSt() == "")
{
continue;
}
int idDT = c.Cells["id"].Value.ToInt();
var con = db.mh_VendorContacts.Where(x => x.id == idDT).FirstOrDefault();
if (con == null)
{
con = new mh_VendorContact();
newDoc = true;
dbClss.AddHistory(this.Name, "Vendor", $"New Customer Contact {c.Cells["ContactName"].Value.ToSt()}", txtNo.Text);
}
if (!newDoc)
{
if (con.Def != c.Cells["Def"].Value.ToBool())
{
dbClss.AddHistory(this.Name, "Vendor", $"Default from {con.Def} to {c.Cells["Def"].Value.ToBool()}", txtNo.Text);
}
if (con.ContactName != c.Cells["ContactName"].Value.ToSt())
{
dbClss.AddHistory(this.Name, "Vendor", $"Contact Name from {con.ContactName} to {c.Cells["ContactName"].Value.ToSt()}", txtNo.Text);
}
if (con.Tel != c.Cells["Tel"].Value.ToSt())
{
dbClss.AddHistory(this.Name, "Vendor", $"Telephone from {con.Tel} to {c.Cells["Tel"].Value.ToSt()}", txtNo.Text);
}
if (con.Fax != c.Cells["Fax"].Value.ToSt())
{
dbClss.AddHistory(this.Name, "Vendor", $"Fax from {con.Fax} to {c.Cells["Fax"].Value.ToSt()}", txtNo.Text);
}
if (con.Email != c.Cells["Email"].Value.ToSt())
{
dbClss.AddHistory(this.Name, "Vendor", $"Email from {con.Email} to {c.Cells["Email"].Value.ToSt()}", txtNo.Text);
}
if (con.Mobile != c.Cells["Mobile"].Value.ToSt())
{
dbClss.AddHistory(this.Name, "Vendor", $"Mobile from {con.Mobile} to {c.Cells["Mobile"].Value.ToSt()}", txtNo.Text);
}
}
con.Def = c.Cells["Def"].Value.ToBool();
con.VendorId = vndr.id;
con.ContactName = c.Cells["ContactName"].Value.ToSt();
con.Tel = c.Cells["Tel"].Value.ToSt();
con.Fax = c.Cells["Fax"].Value.ToSt();
con.Email = c.Cells["Email"].Value.ToSt();
con.Mobile = c.Cells["Mobile"].Value.ToSt();
con.Active = true;
if (idDT <= 0)
{
db.mh_VendorContacts.InsertOnSubmit(con);
}
if (con.Def)
{
vndr.ContactName = con.ContactName;
vndr.PhoneNo = con.Tel;
vndr.FaxNo = con.Fax;
vndr.Email = con.Email;
vndr.Mobile = con.Mobile;
}
db.SubmitChanges();
}
foreach (var c in dgvData2.Rows)
{
newDoc = false;
int idDt = c.Cells["id"].Value.ToInt();
string Item = c.Cells["Item"].Value.ToSt();
string Desc = c.Cells["Description"].Value.ToSt();
var v = db.mh_VendorItems.Where(x => x.id == idDt).FirstOrDefault();
if (v == null)
{
v = new mh_VendorItem();
v.VendorId = vndr.id;
db.mh_VendorItems.InsertOnSubmit(v);
newDoc = true;
dbClss.AddHistory(this.Name, "Vendor", $"New Catagory {Item}", txtNo.Text);
}
if (!newDoc)
{
if (v.Item != Item)
{
dbClss.AddHistory(this.Name, "Vendor", $"Item from {v.Item} to {Item}", txtNo.Text);
}
if (v.Description != Desc)
{
dbClss.AddHistory(this.Name, "Vendor", $"Description from {v.Description} to {Desc}", txtNo.Text);
}
}
v.Item = Item;
v.Description = Desc;
v.Active = true;
db.SubmitChanges();
}
tAction = TypeAction.Edit;
DataLoad();
if (dgvData.Rows.Count == 1)
{
int idDT = dgvData.Rows[0].Cells["id"].Value.ToInt();
dgvData.Rows[0].Cells["Def"].Value = true;
var m = db.mh_VendorContacts.Where(x => x.id == idDT).FirstOrDefault();
m.Def = true;
db.SubmitChanges();
}
}
baseClass.Info("Save complete.");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dbClss.AddError("Add Vendor Contact", ex.Message, this.Name);
}
//if (C > 0)
// MessageBox.Show("บันทึกสำเร็จ!");
return(ck);
}
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["DefaultCrrncy"].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();
mh_Vendor t = new mh_Vendor();
t.No = dbClss.GetNo(1, 2);
t.Name = g.Cells["VendorName"].Value.ToSt();
t.Active = g.Cells["Active"].Value.ToBool();
t.Address = g.Cells["Address"].Value.ToSt();
t.AttachFile = g.Cells["AttachFile"].Value.ToSt();
t.ContactName = g.Cells["ContactName"].Value.ToSt();
t.DefaultCurrency = g.Cells["DefaultCrrncy"].Value.ToInt();
t.Email = g.Cells["Email"].Value.ToSt();
t.FaxNo = g.Cells["FaxNo"].Value.ToSt();
t.PhoneNo = g.Cells["PhoneNo"].Value.ToSt();
t.PriceIncludeingVat = g.Cells["PriceIncludeVat"].ToBool();
t.ReceivingAddress = g.Cells["ReceiveAddress"].Value.ToSt();
t.ShippingTime = g.Cells["ShippingTime"].Value.ToInt();
t.VatGroup = g.Cells["VatGroup"].Value.ToInt();
t.VATRegistration = g.Cells["VatRegis"].Value.ToBool();
t.VendorGroup = g.Cells["VendorGroup"].Value.ToInt();
dbClss.AddHistory(this.Name, "เพิ่มผู้ขาย", "เพิ่มผู้ขาย [" + t.Name + "]", "");
//dbClss.AddHistory(this.Name, "เพิ่มผู้ขาย", "เพิ่มผู้ขาย [" + gy.VendorName + "]", "");
db.mh_Vendors.InsertOnSubmit(t);
db.SubmitChanges();
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 + "]", "");
var t = db.mh_Vendors.Where(x => x.No == g.Cells["dgvCodeTemp"].Value.ToSt()).First();
t.Name = g.Cells["VendorName"].Value.ToSt();
t.Active = g.Cells["Active"].Value.ToBool();
t.Address = g.Cells["Address"].Value.ToSt();
t.AttachFile = g.Cells["AttachFile"].Value.ToSt();
t.ContactName = g.Cells["ContactName"].Value.ToSt();
t.DefaultCurrency = g.Cells["DefaultCrrncy"].Value.ToInt();
t.Email = g.Cells["Email"].Value.ToSt();
t.FaxNo = g.Cells["FaxNo"].Value.ToSt();
t.PhoneNo = g.Cells["PhoneNo"].Value.ToSt();
t.PriceIncludeingVat = g.Cells["PriceIncludeVat"].ToBool();
t.ReceivingAddress = g.Cells["ReceiveAddress"].Value.ToSt();
t.ShippingTime = g.Cells["ShippingTime"].Value.ToInt();
t.VatGroup = g.Cells["VatGroup"].Value.ToInt();
t.VATRegistration = g.Cells["VatRegis"].Value.ToBool();
t.VendorGroup = g.Cells["VendorGroup"].Value.ToInt();
C += 1;
db.SubmitChanges();
dbClss.AddHistory(this.Name, "แก้ไข", "แก้ไขผู้ขาย [" + t.Name + "]", "");
}
}
}
else
{
MessageBox.Show("กรอกข้อมูลไม่ครบ!");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dbClss.AddError("เพิ่มผู้ขาย", ex.Message, this.Name);
}
if (C > 0)
{
MessageBox.Show("บันทึกสำเร็จ!");
}
return(ck);
}
