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 (lvSupplier.Items.Count > 0)
{
try
{
FormSupplier_Modify.ADD_STATE = false;
FormSupplier_Modify.sSupplierKode = lvSupplier.Items[lvSupplier.FocusedItem.Index].SubItems[0].Text;
FormSupplier_Modify sForm = new FormSupplier_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 FormSupplier_Modify_Load(object sender, EventArgs e)
{
cmbStatus.Items.Add("ACTIVE");
cmbStatus.Items.Add("INACTIVE");
if (ADD_STATE == true)
{
txtSupplierCode.Text = "SUPP-" + clsFunctions.GenerateCD("SELECT MAX(autoid) FROM tblsupplier", "tblsupplier");
cmdAddSupplier = new MySqlCommand("INSERT INTO tblsupplier( suppliercode , suppliername, discription, contactperson, bussinessno, email, address, status, dateadded)" +
"VALUES (@getSupplierCode,@getSupplierName,@getDiscription,@getContactPerson,@getBussinesNo,@getEmail,@getAddress,@getStatus,@getDateAdded)", clsConnection.CN);
this.Text = "Add New";
}
else
{
txtSupplierCode.ReadOnly = true;
//Set Edit OleDbCommand
cmdAddSupplier = new MySqlCommand("UPDATE tblsupplier SET suppliercode=@getSupplierCode, suppliername=@getSupplierName, discription=@getDiscription, contactperson=@getContactPerson, bussinessno=@getBussinesNo, email=@getEmail, address=@getAddress, status=@getStatus, dateadded=@getDateAdded WHERE suppliercode LIKE '" + sSupplierKode + "' ", clsConnection.CN);
FillFields();
this.Text = "Edit Existing";
}
cmdAddSupplier.Parameters.Add("@getSupplierCode", MySqlDbType.VarChar);
cmdAddSupplier.Parameters.Add("@getSupplierName", MySqlDbType.VarChar);
cmdAddSupplier.Parameters.Add("@getDiscription", MySqlDbType.Text);
cmdAddSupplier.Parameters.Add("@getContactPerson", MySqlDbType.VarChar);
cmdAddSupplier.Parameters.Add("@getBussinesNo", MySqlDbType.VarChar);
cmdAddSupplier.Parameters.Add("@getEmail", MySqlDbType.VarChar);
cmdAddSupplier.Parameters.Add("@getAddress", MySqlDbType.VarChar);
cmdAddSupplier.Parameters.Add("@getStatus", MySqlDbType.VarChar);
cmdAddSupplier.Parameters.Add("@getDateAdded", MySqlDbType.Date);
publcFormSupplier_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)
{
FormSupplier_Modify.ADD_STATE = true;
FormSupplier_Modify sForm = new FormSupplier_Modify();
sForm.ShowDialog();
}
else
{
MessageBox.Show("Anda perlu hak akses administrator untuk menggunakan fitur ini!", clsVariables.sMSGBOX, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}