private void button2_Click(object sender, EventArgs e)
{
using (SSLsEntities db = new SSLsEntities())
{
if (_Id == 0)
{
// add new
Vendor obj = new Vendor();
obj.Code = textBoxCode.Text;
obj.Name = textBoxName.Text;
obj.Address = textBoxAddress.Text;
obj.Tel = textBoxTel.Text;
obj.Fax = textBoxFax.Text;
obj.TaxNo = textBoxTax.Text.Trim();
obj.Description = textBoxDesc.Text;
obj.CreateDate = DateTime.Now;
obj.CreateBy = Singleton.SingletonAuthen.Instance().Id;
obj.Enable = true;
obj.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
obj.UpdateDate = DateTime.Now;
if (radioButtonCostOnly.Checked == true)
{
obj.FKPOCostType = MyConstant.POCostType.CostOnly;
}
else
{
obj.FKPOCostType = MyConstant.POCostType.CostAndVat;
}
db.Vendor.Add(obj);
var vendorsOnSingleton = Singleton.SingletonVender.Instance().Vendors;
if (vendorsOnSingleton.FirstOrDefault(w => w.Code == obj.Code) != null) // ถ้า code นี้ เคยมีแล้ว
{
MessageBox.Show("รหัสซ้ำบนระบบใหม่ (pos.Vendor) " + vendorsOnSingleton.FirstOrDefault(w => w.Code == obj.Code).Name);
return;
}
// add to wh customer and brand
using (WH_TRATEntities wh = new WH_TRATEntities())
{
var getCust = wh.WH_CUSTOMER_MAST.FirstOrDefault(w => (w.CUSTOMER_NO + "") == obj.Code);
if (getCust != null) // แปลว่าซ้ำยุ่ในระบบเก่า
{
MessageBox.Show("รหัสซ้ำบนระบบเก่า (dbo.WH_CUSTOMER_MAST) " + getCust.CUSTOMER_NAME);
return;
}
// check in brand
var getBrand = wh.WH_BRAND_MAST.FirstOrDefault(w => (w.BRAND_NO + "") == obj.Code);
if (getBrand != null) // ซ้ำ ยี่ห้อในระบบเก่า
{
MessageBox.Show("รหัสซ้ำบนระบบเก่า (dbo.WH_BRAND_MAST) " + getBrand.BRAND_NAME);
return;
}
// pass customer and brand to add 2 table
WH_CUSTOMER_MAST customer = new WH_CUSTOMER_MAST();
customer.CUSTOMER_NO = int.Parse(obj.Code);
customer.CUSTOMER_NAME = obj.Name;
customer.CUSTOMER_BRANCH = "-";
customer.CUSTOMER_TAXID = obj.TaxNo;
customer.CUSTOMER_ADDRESS = obj.Address;
customer.CUSTOMER_PROVINCE = "";
customer.CUSTOMER_POSTNO = null;
customer.CUSTOMER_PHONE = obj.Tel;
customer.CUSTOMER_FAX = obj.Fax;
customer.CUSTOMER_EMAIL = "";
customer.CREATE_DATE = DateTime.Now;
customer.UPDATE_DATE = null;
customer.USER_ID = obj.CreateBy;
wh.WH_CUSTOMER_MAST.Add(customer);
// brand
WH_BRAND_MAST brand = new WH_BRAND_MAST();
brand.BRAND_NO = int.Parse(obj.Code);
brand.BRAND_NAME = obj.Name;
brand.CREATE_DATE = DateTime.Now;
brand.UPDATE_DATE = null;
brand.USER_ID = obj.CreateBy;
wh.WH_BRAND_MAST.Add(brand);
wh.SaveChanges();
}
db.SaveChanges();
}
else
{
// edit
var obj = db.Vendor.SingleOrDefault(w => w.Id == _Id);
var vendorSingle = Singleton.SingletonVender.Instance().Vendors.SingleOrDefault(w => w.Id == _Id);
Singleton.SingletonVender.Instance().Vendors.Remove(vendorSingle);
obj.UpdateDate = DateTime.Now;
obj.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
//obj.Code = textBoxCode.Text;
obj.Name = textBoxName.Text;
obj.Address = textBoxAddress.Text;
obj.Tel = textBoxTel.Text;
obj.Fax = textBoxFax.Text;
obj.Description = textBoxDesc.Text;
if (radioButton1.Checked)
{
obj.Enable = true;
}
else
{
obj.Enable = false;
}
if (radioButtonCostOnly.Checked == true)
{
obj.FKPOCostType = MyConstant.POCostType.CostOnly;
}
else
{
obj.FKPOCostType = MyConstant.POCostType.CostAndVat;
}
db.Entry(obj).State = EntityState.Modified;
}
db.SaveChanges();
string user = Singleton.SingletonAuthen.Instance().Id;
var v = db.Vendor.Include("POCostType").OrderByDescending(w => w.UpdateDate).Where(w => w.UpdateBy == user).FirstOrDefault();
Singleton.SingletonVender.Instance().Vendors.Add(v);
dataGrid();
//this.Dispose();
//_Id = 0;
}
}
private void button2_Click(object sender, EventArgs e)
{
using (SSLsEntities db = new SSLsEntities())
{
if (_Id == 0)
{
// add new
ProductBrands obj = new ProductBrands();
obj.Code = textBoxCode.Text;
obj.Name = textBoxName.Text;
obj.Description = textBoxDesc.Text;
obj.CreateDate = DateTime.Now;
obj.CreateBy = Singleton.SingletonAuthen.Instance().Id;
obj.Enable = true;
obj.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
obj.UpdateDate = DateTime.Now;
db.ProductBrands.Add(obj);
//add to wh
using (WH_TRATEntities wh = new WH_TRATEntities())
{
var getBrand = wh.WH_BRAND_MAST.FirstOrDefault(w => (w.BRAND_NO + "") == obj.Code);
if (getBrand == null)
{
// add now
WH_BRAND_MAST brand = new WH_BRAND_MAST();
brand.BRAND_NAME = obj.Name;
brand.BRAND_NO = int.Parse(obj.Code);
brand.CREATE_DATE = DateTime.Now;
brand.USER_ID = obj.UpdateBy;
wh.WH_BRAND_MAST.Add(brand);
wh.SaveChanges();
}
else
{
// not add
}
}
}
else
{
// edit
var obj = db.ProductBrands.SingleOrDefault(w => w.Id == _Id);
obj.UpdateDate = DateTime.Now;
obj.UpdateBy = Singleton.SingletonAuthen.Instance().Id;
//obj.Code = textBoxCode.Text;
obj.Name = textBoxName.Text;
obj.Description = textBoxDesc.Text;
if (radioButton1.Checked)
{
obj.Enable = true;
}
else
{
obj.Enable = false;
}
db.Entry(obj).State = EntityState.Modified;
}
db.SaveChanges();
Singleton.SingletonPriority1.SetInstance();
//Singleton.SingletonPriority1.Instance();
dataGrid();
//this.Dispose();
//_Id = 0;
}
}