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