private void btnAddCustomer_Click(object sender, EventArgs e) { string CustomerName = txtCustomerName.Text.ToString().Trim().Replace("'", "''"); string CustomerShortName = txtCustomerShortName.Text.ToString().Trim().Replace("'", "''"); string CustomerCode = txtCustomerCode.Text.ToString().Trim().Replace("'", "''"); if (CustomerName == "") { chkNull("CustomerName", txtCustomerName); } else if (CustomerShortName == "") { chkNull("CustomerShortName", txtCustomerShortName); } else if (CustomerCode == "") { chkNull("CustomerCode", txtCustomerCode); } else { //chkDup if (db.get("Select ShortName From Customer Where ShortName = '" + CustomerShortName + "' ", mainConn) == true) { ct.showWarningMessage("CustomerShortName is Duplicate!"); txtCustomerShortName.Focus(); return; } else if (db.get("Select Code From Customer Where Code = '" + CustomerCode + "' ", mainConn) == true) { ct.showWarningMessage("CustomerCode is Duplicate!"); txtCustomerCode.Focus(); return; } else { if (ct.doConfirm("SAVE Customer?") == true) { sql = "Insert into Customer(Name,/**/ShortName,/**/Code,CustomerType) Values ('" + CustomerName + "','" + CustomerShortName + "','" + CustomerCode + "',9)"; Console.WriteLine(sql); int i = db.Query(sql, mainConn); if (i > 0) { DEV01 frmDev = Application.OpenForms.OfType <DEV01>().First(); db.getSl("Select OIDCUST,ShortName,Name From Customer", mainConn, frmDev.slCustomer_Main, "OIDCUST", "Name"); ct.showInfoMessage("Save Customer is Successfull."); this.Close(); } } } } }
private void btnAddStyle_Click(object sender, EventArgs e) { string StyleName = txtStyleName.Text.ToString().Trim().Replace("'", "''"); string CategoryName = glCategoryName.Text.ToString(); //chkNull or Empty if (StyleName == "") { ct.showWarningMessage("Please Key StyleName!"); txtStyleName.Focus(); return; } else if (CategoryName == "") { ct.showWarningMessage("Please Select CategoryName!"); glCategoryName.Focus(); return; } else { //chkDup if (db.get("Select StyleName From ProductStyle Where StyleName = '" + StyleName + "' ", mainConn) == true) { ct.showWarningMessage("StyleName is Duplicate!"); txtStyleName.Focus(); return; } else { //Confirm Save if (ct.doConfirm("Save StyleName ? ") == true) { sql = "Insert Into ProductStyle (StyleName,OIDGCATEGORY) Values('" + StyleName + "'," + glCategoryName.EditValue.ToString() + ")"; Console.WriteLine(sql); int i = db.Query(sql, mainConn); if (i > 0) { DEV01 frmDev = Application.OpenForms.OfType <DEV01>().First(); db.getSl("select OIDSTYLE,StyleName From ProductStyle", mainConn, frmDev.slStyleName_Main, "OIDSTYLE", "StyleName"); ct.showInfoMessage("Save StyleName is Successufull."); this.Close(); } } } } }
private void btnAddCategory_Click(object sender, EventArgs e) { string CategoryName = txtCategoryName.Text.ToString().Trim().Replace("'", "''"); //chkNull or Empty if (CategoryName == "") { ct.showWarningMessage("Please Key CategoryName!"); txtCategoryName.Focus(); return; } else { //chkDup if (db.get("Select CategoryName From GarmentCategory Where CategoryName = '" + CategoryName + "' ", mainConn) == true) { ct.showWarningMessage("CategroryName is Duplicate!"); txtCategoryName.Focus(); return; } else { //Confirm Save if (ct.doConfirm("Save CategoryName ? ") == true) { sql = "Insert Into GarmentCategory (CategoryName) Values('" + CategoryName + "')"; Console.WriteLine(sql); int i = db.Query(sql, mainConn); if (i > 0) { DEV01 frmDev = Application.OpenForms.OfType <DEV01>().First(); db.getGl("Select OIDGCATEGORY,CategoryName from GarmentCategory", mainConn, frmDev.glCategoryDivision_Main, "OIDGCATEGORY", "CategoryName"); ct.showInfoMessage("Save CategoryName is Successufull."); this.Close(); } } } } }