private void btn_ConfirmSales_Click(object sender, EventArgs e) { try { listpanel[index = 5].BringToFront(); SalesOrderDBaccess SO = new SalesOrderDBaccess(); StockDBaccess SD = new StockDBaccess(); String st = "Pending"; grid_Ordrs.DataSource = SO.getSpecialSalesOrders(st); grid_StockDetails.DataSource = SD.getNotDamagedMaterial(); rbn_Met.Checked = true; } 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 rbn_Met_CheckedChanged(object sender, EventArgs e) { try { if (rbn_Met.Checked) { StockDBaccess SD = new StockDBaccess(); grid_StockDetails.DataSource = SD.getNotDamagedMaterial(); } if (rbn_Pro.Checked) { StockDBaccess SD = new StockDBaccess(); grid_StockDetails.DataSource = SD.getNotDamagedProduct(); } } 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 cmb_ptype_SelectedIndexChanged(object sender, EventArgs e) { try { ManagementDBaccess MA = new ManagementDBaccess(); StockDBaccess SD = new StockDBaccess(); cmb_size.DataSource = MA.getSize(cmb_ptype.Text); cmb_size.DisplayMember = "ProductSize"; cmb_Design.DataSource = MA.getDesignType(cmb_ptype.Text); cmb_Design.DisplayMember = "DesignType"; cmb_size.Text = null; cmb_Design.Text = null; grid_Damaged.DataSource = SD.getAllProduct(); } 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_DamageStatus_Click(object sender, EventArgs e) { try { listpanel[index = 2].BringToFront(); rbn_Pro.Checked = true; StockDBaccess SD = new StockDBaccess(); grid_Damaged.DataSource = SD.getAllProduct(); grid_Damaged.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_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_clear_Click(object sender, EventArgs e) { try { txt_PID.Text = ""; cmb_ptype.Text = null; cmb_Brand.Text = null; cmb_Design.Text = null; cmb_size.Text = null; cmb_color.Text = null; cmb_ftype.Text = null; txt_Area_des.Text = ""; txt_qty.Text = ""; grid_product.ClearSelection(); StockDBaccess SD = new StockDBaccess(); txt_PID.Text = SD.GetProductId(); } 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 chk_ResMet_OnChange(object sender, EventArgs e) { try { StockDBaccess SD = new StockDBaccess(); if (chk_ResMet.Checked) { grid_met.DataSource = SD.getReceivedMet(); } else { grid_met.DataSource = SD.getAllMaterial(); } } 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_StockDetails_Click(object sender, EventArgs e) { try { listpanel[index = 3].BringToFront(); StockDBaccess SD = new StockDBaccess(); grid_ProDetails.DataSource = SD.getAllProduct(); grid_MatDetails.DataSource = SD.getAllMaterial(); } 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_remove_Click(object sender, EventArgs e) { try { StockDBaccess SD = new StockDBaccess(); int Status = SD.deleteProduct(txt_PID.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_product.DataSource = SD.getAllProduct(); txt_PID.Text = SD.GetProductId(); cmb_ptype.Text = null; cmb_Brand.Text = null; cmb_Design.Text = null; cmb_size.Text = null; cmb_color.Text = null; cmb_ftype.Text = null; txt_Area_des.Text = ""; txt_qty.Text = ""; grid_product.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_ndmg_Click(object sender, EventArgs e) { try { if (grid_Damaged.SelectedRows.Count < 1) { MetroMessageBox.Show(this, "\n\nSelect Record From Grid to proceed", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { StockDBaccess SD = new StockDBaccess(); String status = "Not Damaged"; if (rbn_Pro.Checked) { String ProId = grid_Damaged.CurrentRow.Cells["Pro_id"].Value.ToString(); int Status = SD.UpdateProductDamageStatus(ProId, status); if (Status == 1) { MetroMessageBox.Show(this, "\n\nStatus Changed", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MetroMessageBox.Show(this, "\n\nUpdate Status Fail", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } grid_Damaged.DataSource = SD.getAllProduct(); } if (rbn_Met.Checked) { String MatId = grid_Damaged.CurrentRow.Cells["Mat_id"].Value.ToString(); int Status = SD.UpdateMaterialDamageStatus(MatId, status); if (Status == 1) { MetroMessageBox.Show(this, "\n\nStatus Changed", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MetroMessageBox.Show(this, "\n\nUpdate Status Fail", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } grid_Damaged.DataSource = SD.getAllMaterial(); } } } 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_update_Click(object sender, EventArgs e) { try { if (cmb_ptype.SelectedIndex == -1) { MessageBox.Show("You must select a Material Type", "Error"); } else if (cmb_Brand.SelectedIndex == -1) { MessageBox.Show("You must select a Brand", "Error"); } else if (cmb_Design.SelectedIndex == -1) { MessageBox.Show("You must select a Design", "Error"); } else if (cmb_size.SelectedIndex == -1) { MessageBox.Show("You must select a Size", "Error"); } else if (cmb_color.SelectedIndex == -1) { MessageBox.Show("You must select a Color", "Error"); } else if (cmb_ptype.SelectedIndex == -1) { MessageBox.Show("You must select a Product Type", "Error"); } else if (cmb_ftype.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 (string.IsNullOrEmpty(txt_Mqty.Text) || !Regex.Match(txt_Mqty.Text, "^[0-9]*$").Success) { MessageBox.Show("Invalid, Please enter Quantity correctly", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Convert.ToInt32(txt_qty.Text) <= 0) { MetroFramework.MetroMessageBox.Show(this, "Quantity cannot be minus or zero!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { StockProduct SP = new StockProduct(); SP.ProId = txt_PID.Text; SP.ProType = cmb_ptype.Text; SP.Size = cmb_size.Text; SP.Color = cmb_color.Text; SP.FabricType = cmb_ftype.Text; SP.Quantity = txt_qty.Text; SP.Description = txt_Area_des.Text; StockDBaccess SD = new StockDBaccess(); int Status = SD.updateProduct(SP); if (Status == 1) { MetroMessageBox.Show(this, "\n\nsuccesfully Updated", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } MetroMessageBox.Show(this, "\n\nUpdate Fail", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); grid_product.DataSource = SD.getAllProduct(); txt_PID.Text = SD.GetProductId(); cmb_ptype.Text = null; cmb_Brand.Text = null; cmb_Design.Text = null; cmb_size.Text = null; cmb_color.Text = null; cmb_ftype.Text = null; txt_Area_des.Text = ""; txt_qty.Text = ""; grid_product.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); } }