private void btn_PurchaseMet_Click(object sender, EventArgs e)
{
try
{
listpanel[index = 3].BringToFront();
StockDBaccess SD = new StockDBaccess();
grid_met.DataSource = SD.getAllMaterial();
txt_MID.Text = SD.GetMaterialId();
grid_met.ClearSelection();
}
catch (SqlException)
{
MetroMessageBox.Show(this, "\n\nConnecton Failed", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (FormatException)
{
MetroMessageBox.Show(this, "\n\nInvalid Format", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (OutOfMemoryException)
{
MetroMessageBox.Show(this, "\n\nInsuffisent memory", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception)
{
MetroMessageBox.Show(this, "\n\nERROR", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btn_M_Clear_Click(object sender, EventArgs e)
{
try
{
txt_MID.Text = "";
cmb_ftype.Text = null;
cmb_MSize.Text = null;
cmb_Mcolor.Text = null;
cmb_Mtype.Text = null;
txt_Mqty.Text = "";
txt_Area_M_Des.Text = "";
grid_met.ClearSelection();
StockDBaccess SD = new StockDBaccess();
txt_MID.Text = SD.GetMaterialId();
}
catch (SqlException)
{
MetroMessageBox.Show(this, "\n\nConnecton Failed", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (FormatException)
{
MetroMessageBox.Show(this, "\n\nInvalid Format", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (OutOfMemoryException)
{
MetroMessageBox.Show(this, "\n\nInsuffisent memory", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception)
{
MetroMessageBox.Show(this, "\n\nERROR", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btn_M_remove_Click(object sender, EventArgs e)
{
try
{
StockDBaccess SD = new StockDBaccess();
int Status = SD.deleteMaterial(txt_MID.Text);
if (Status == 1)
{
MetroMessageBox.Show(this, "\n\nsuccesfully Removed", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, "\n\nRemove Fail", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
grid_met.DataSource = SD.getAllMaterial();
txt_MID.Text = SD.GetMaterialId();
cmb_ftype.Text = null;
cmb_MSize.Text = null;
cmb_Mcolor.Text = null;
cmb_Mtype.Text = null;
txt_Mqty.Text = "";
txt_Area_M_Des.Text = "";
grid_met.ClearSelection();
}
catch (SqlException)
{
MetroMessageBox.Show(this, "\n\nConnecton Failed", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (FormatException)
{
MetroMessageBox.Show(this, "\n\nInvalid Format", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (OutOfMemoryException)
{
MetroMessageBox.Show(this, "\n\nInsuffisent memory", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception)
{
MetroMessageBox.Show(this, "\n\nERROR", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btn_M_Update_Click(object sender, EventArgs e)
{
try
{
if (cmb_Mtype.SelectedIndex == -1)
{
MessageBox.Show("You must select a Material Type", "Error");
}
else if (cmb_MSize.SelectedIndex == -1)
{
MessageBox.Show("You must select a Size", "Error");
}
else if (cmb_Mcolor.SelectedIndex == -1)
{
MessageBox.Show("You must select a Color", "Error");
}
else if (string.IsNullOrEmpty(txt_Mqty.Text) || !Regex.Match(txt_Mqty.Text, "^[0-9]*$").Success)
{
MessageBox.Show("Invalid, Please enter price correctly", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Convert.ToInt32(txt_Mqty.Text) <= 0)
{
MetroFramework.MetroMessageBox.Show(this, "Quantity cannot be minus or zero!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (!chk_ResMet.Checked)
{
StockMaterial SM = new StockMaterial();
SM.MatId = txt_MID.Text;
SM.MaterialType = cmb_Mtype.Text;
SM.Size = cmb_MSize.Text;
SM.Color = cmb_Mcolor.Text;
SM.Quantity = txt_Mqty.Text;
SM.Description = txt_Area_M_Des.Text;
StockDBaccess SD = new StockDBaccess();
int Status = SD.updateMaterial(SM);
if (Status == 1)
{
MetroMessageBox.Show(this, "\n\nsuccesfully Updated", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, "\n\nUpdate Fail", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
grid_met.DataSource = SD.getAllMaterial();
txt_MID.Text = SD.GetMaterialId();
cmb_ftype.Text = null;
cmb_MSize.Text = null;
cmb_Mcolor.Text = null;
cmb_Mtype.Text = null;
txt_Mqty.Text = "";
txt_Area_M_Des.Text = "";
grid_met.ClearSelection();
}
}
}
catch (SqlException)
{
MetroMessageBox.Show(this, "\n\nConnecton Failed", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (FormatException)
{
MetroMessageBox.Show(this, "\n\nInvalid Format", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (OutOfMemoryException)
{
MetroMessageBox.Show(this, "\n\nInsuffisent memory", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception)
{
MetroMessageBox.Show(this, "\n\nERROR", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}