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