private void bttnModify_Click(object sender, EventArgs e)
{
if (clsFunctions.recordExist("SELECT tblusers.usercode, tblusers.usertype FROM tblusers WHERE (tblusers.usertype=1 && tblusers.usercode='" + clsVariables.sUsercode + "') ORDER BY tblusers.autoid ASC", "tblusers") == true)
{
if (lvProduct.Items.Count > 0)
{
try
{
FormProduct_Modify.ADD_STATE = false;
FormProduct_Modify.sProductKode = lvProduct.Items[lvProduct.FocusedItem.Index].SubItems[0].Text;
FormProduct_Modify sForm = new FormProduct_Modify();
sForm.ShowDialog();
}
catch (ArgumentOutOfRangeException aooreE) { MessageBox.Show("" + aooreE.Message); }
catch (NullReferenceException nreE) { }
}
else
{
MessageBox.Show("No record to edit.", clsVariables.sMSGBOX, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
MessageBox.Show("Anda perlu hak akses administrator untuk menggunakan fitur ini!", clsVariables.sMSGBOX, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void FormProduct_Modify_Load(object sender, EventArgs e)
{
if (ADD_STATE == true)
{
//txtProductCode.Text = "PROD-" + clsFunctions.GenerateCD("SELECT MAX(autoid) FROM tblproduct", "tblproduct");
cmdAddProduct = new MySqlCommand("INSERT INTO tblproduct( productcode , productname, categoryautoid, supplierautoid, unitprice, sellingprice, stock)" +
"VALUES (@getProductCode,@getProductName,@getCategoryId,@getSupplierID,@getUnitPrice,@getSellingPrice,@getStock)", clsConnection.CN);
this.Text = "Add New";
}
else
{
txtProductCode.Enabled = false;
//Set Edit OleDbCommand
cmdAddProduct = new MySqlCommand("UPDATE tblproduct SET productcode=@getProductCode, productname=@getProductName, categoryautoid=@getCategoryId, supplierautoid=@getSupplierID, unitprice=@getUnitPrice, sellingprice=@getSellingPrice, stock=@getStock WHERE productcode LIKE '" + sProductKode + "' ", clsConnection.CN);
FillFields();
this.Text = "Edit Existing";
}
cmdAddProduct.Parameters.Add("@getProductCode", MySqlDbType.VarChar);
cmdAddProduct.Parameters.Add("@getProductName", MySqlDbType.VarChar);
cmdAddProduct.Parameters.Add("@getCategoryId", MySqlDbType.Int16);
cmdAddProduct.Parameters.Add("@getSupplierID", MySqlDbType.Int16);
cmdAddProduct.Parameters.Add("@getUnitPrice", MySqlDbType.Decimal);
cmdAddProduct.Parameters.Add("@getSellingPrice", MySqlDbType.Decimal);
cmdAddProduct.Parameters.Add("@getStock", MySqlDbType.Int16);
publcFormProduct_Modify = this;
}
private void bttnAddNew_Click(object sender, EventArgs e)
{
if (clsFunctions.recordExist("SELECT tblusers.usercode, tblusers.usertype FROM tblusers WHERE (tblusers.usertype=1 && tblusers.usercode='" + clsVariables.sUsercode + "') ORDER BY tblusers.autoid ASC", "tblusers") == true)
{
FormProduct_Modify.ADD_STATE = true;
FormProduct_Modify sForm = new FormProduct_Modify();
sForm.ShowDialog();
}
else
{
MessageBox.Show("Anda perlu hak akses administrator untuk menggunakan fitur ini!", clsVariables.sMSGBOX, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}