Exemplo n.º 1
0
        private void ImportFileData(DataTable dt)
        {
            try
            {
                Updation update = new Updation();

                foreach (DataRow row in dt.Rows)
                {
                    DataTable dtProductId = retrieve.GetId("usp_GetProductID", row[0].ToString());
                    //stocks in
                    update.UpdateIncreaseAvailableStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[2]), Convert.ToDateTime(row[1]));
                    //stocks out
                    update.UpdateDecreaseAvailableStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[3]), Convert.ToDateTime(row[1]));
                    //stock onhold
                    update.UpdateIncreaseInOnHoldStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[4]), Convert.ToDateTime(row[1]));
                    //resolve onhold
                    update.UpdateResolveInOnHoldStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[5]), Convert.ToDateTime(row[1]));
                    //stock rejected
                    update.UpdateIncreaseRejectedStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[6]), Convert.ToDateTime(row[1]));
                    //resolve rejected
                    update.UpdateIResolveRejectedStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[7]), Convert.ToDateTime(row[1]));
                    //stock reworked
                    update.UpdateIncreaseInReworkedStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[8]), Convert.ToDateTime(row[1]));
                    //resolve reworked
                    update.UpdateResolveInReworkedStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[9]), Convert.ToDateTime(row[1]));
                }

                MainClass.ShowMessage("Stocks Updated Successfully. ", "Success", "Success");
            }
            catch (Exception exp)
            {
                MainClass.ShowMessage(exp.Message, "Error", "Error");
            }
        }
Exemplo n.º 2
0
        public override void buttonSave_Click(object sender, EventArgs e)
        {
            if (dataGridViewPOLines.Rows.Count > 0)
            {
                Updation Update = new Updation();

                using (TransactionScope tc = new TransactionScope())
                {
                    int PoLines = 0;
                    foreach (DataGridViewRow row in dataGridViewPOLines.Rows)
                    {
                        Update.UpdatePODetails(POId, Convert.ToInt32(row.Cells["ProductIdGv"].Value), Convert.ToDecimal(row.Cells["ProductTotalPrice"].Value), Convert.ToDecimal(row.Cells["ProductQuantityGv"].Value), Convert.ToInt32(row.Cells["LineNo"].Value));
                        PoLines += 1;
                    }
                    if (PoLines > 0)
                    {
                        Update.UpdatePOPrice(POId, Convert.ToDecimal(labelGrandTotalValue.Text));
                        MainClass.ShowMessage("Purchase Order Updated Successfully.", "Success", "Success");
                    }
                    else
                    {
                        MainClass.ShowMessage("Unable to Update Purchase Order.", "Error", "Error");
                    }
                    tc.Complete();
                }
            }
        }
Exemplo n.º 3
0
        public override void buttonSave_Click(object sender, EventArgs e)
        {
            if (textBoxCategoryName.Text == "")
            {
                labelCategoryNameError.Visible = true;
            }
            else
            {
                labelCategoryNameError.Visible = false;
            }

            if (comboBoxIsSales.SelectedIndex == -1)
            {
                labelIsSalesError.Visible = true;
            }
            else
            {
                labelIsSalesError.Visible = false;
            }

            if (labelCategoryNameError.Visible || labelIsSalesError.Visible)
            {
                MainClass.ShowMessage("Fields with * are mandatory", "Error", "Error"); //Error is the type of message.
            }
            else
            {
                if (comboBoxIsSales.SelectedIndex == 1)
                {
                    stat = 0;
                }
                else if (comboBoxIsSales.SelectedIndex == 0)
                {
                    stat = 1;
                }
                if (edit == 0)  //Code for save operation
                {
                    Insertion insert = new Insertion();
                    insert.SaveCategoryDetails(textBoxCategoryName.Text, stat);


                    retrieve.ShowCategories(dataGridViewCat, catIdGV, CatGVName, CatGVStatus);
                    MainClass.Disable_Reset(panelRightSlider);
                }
                else if (edit == 1) //code for update operaiton
                {
                    DialogResult dr = MessageBox.Show("Are you sure, you want to update record.", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

                    if (dr == DialogResult.Yes)
                    {
                        Updation update = new Updation();
                        update.UpdateCategoryDetails(textBoxCategoryName.Text, stat, CategoryId);


                        retrieve.ShowCategories(dataGridViewCat, catIdGV, CatGVName, CatGVStatus);
                        MainClass.Disable_Reset(panelRightSlider);
                    }
                }
            }
        }
Exemplo n.º 4
0
        public override void buttonSave_Click(object sender, EventArgs e)
        {
            if (dataGridViewPOLines.Rows.Count > 0)
            {
                int quantityReceivedCheck = 0;
                foreach (DataGridViewRow row in dataGridViewPOLines.Rows)
                {
                    if (row.Cells["QuantityReceivedDgv"].Value == null || row.Cells["QuantityReceivedDgv"].Value == string.Empty)
                    {
                        break;
                    }
                    quantityReceivedCheck += 1;
                }
                if (quantityReceivedCheck < dataGridViewPOLines.Rows.Count)
                {
                    MainClass.ShowMessage("Please Enter received qunatity for all lines.", "Error", "Error");
                }
                else
                {
                    Updation  Update = new Updation();
                    Insertion insert = new Insertion();
                    using (TransactionScope tc = new TransactionScope())
                    {
                        ReceivingId = insert.SaveReceiving(POId, Convert.ToDecimal(labelGrandTotalValue.Text));

                        int recvLines = 0;

                        foreach (DataGridViewRow row in dataGridViewPOLines.Rows)
                        {
                            recvLines += insert.SaveReceiveLine(ReceivingId, Convert.ToInt32(row.Cells["ProductIdGv"].Value), Convert.ToDecimal(row.Cells["ReceivedQuantityCostDgv"].Value), Convert.ToDecimal(row.Cells["QuantityReceivedDgv"].Value), Convert.ToInt32(row.Cells["LineNo"].Value));
                        }
                        if (recvLines > 0)
                        {
                            Update.UpdatePOStatus(POId, 2);
                            MainClass.ShowMessage("Receiving perfromed successfully.", "Success", "Success");
                            CreateReceivingPdfReport(ReceivingId, POId);
                        }
                        else
                        {
                            MainClass.ShowMessage("Unable to perform receiving.", "Error", "Error");
                        }
                        tc.Complete();
                    }
                }
            }
            else
            {
                MainClass.ShowMessage("Please Select a Purchase Order to perform receiving.", "Error", "Error");
            }
        }
Exemplo n.º 5
0
        private void buttonAddToStocks_Click(object sender, EventArgs e)
        {
            if (comboBoxSelectProduct.SelectedIndex == -1)
            {
                labelProductDateError.Visible = true;
            }
            else
            {
                labelProductDateError.Visible = false;
            }
            if (textBoxQuantity.Text == "")
            {
                labelQuantityError.Visible = true;
            }
            else
            {
                labelQuantityError.Visible = false;
            }
            if (labelProductDateError.Visible || labelQuantityError.Visible)
            {
                MainClass.ShowMessage("Fields with * are mandatory", "Error", "Error"); //Error is the type of message.
            }
            else
            {
                Updation update = new Updation();

                update.UpdateIncreaseRejectedStocks(Convert.ToInt32(comboBoxSelectProduct.SelectedValue.ToString()), Convert.ToDecimal(textBoxQuantity.Text), dateTimePickerEntryDate.Value);
                ShowDataInGrid();
                //foreach (DataGridViewRow rows in dataGridViewProduct.Rows)
                //{
                //    if(Convert.ToDecimal(rows.Cells["ProductMinValGv"].Value)< Convert.ToDecimal(rows.Cells["AvailableStocks"].Value))
                //    {
                //        rows.Cells["AvailableStocks"].Style.BackColor = Color.LightGreen;
                //        rows.Cells["AvailableStocks"].Style.ForeColor = Color.Black;
                //    }
                //    else
                //    {
                //        rows.Cells["AvailableStocks"].Style.BackColor = Color.IndianRed;
                //        rows.Cells["AvailableStocks"].Style.ForeColor = Color.Black;
                //    }
                //}

                MainClass.ShowMessage("Stocks added sucessfully", "Success", "Success");
                textBoxQuantity.Clear();
            }
        }
Exemplo n.º 6
0
        public override void buttonSave_Click(object sender, EventArgs e)
        {
            if (dataGridViewSalesLines.Rows.Count > 0)
            {
                int       SalesID = 0;
                Insertion insert  = new Insertion();
                using (TransactionScope tc = new TransactionScope())
                {
                    SalesID = insert.SaveSales(Convert.ToInt32(comboBoxCustomer.SelectedValue), Convert.ToDecimal(labelGrandTotalValue.Text), Retrievel.User_ID);
                    int SalesLines = 0;
                    foreach (DataGridViewRow row in dataGridViewSalesLines.Rows)
                    {
                        SalesLines += insert.SaveSalesLine(SalesID, Convert.ToInt32(row.Cells["ProductIdGv"].Value), Convert.ToDecimal(row.Cells["ProductTotalPrice"].Value), Convert.ToDecimal(row.Cells["ProductQuantityGv"].Value), row.Cells["Unit"].Value.ToString(), Convert.ToInt32(row.Cells[1].Value));
                        if (SalesLines > 0) //decrease the stock
                        {
                            Updation update = new Updation();

                            int rowsDec = update.UpdateDecreaseAvailableStocks(Convert.ToInt32(row.Cells["ProductIdGv"].Value), Convert.ToDecimal(row.Cells["ProductQuantityGv"].Value));
                        }
                    }
                    if (SalesLines > 0)
                    {
                        MainClass.ShowMessage("Sales Invoice Created Successfully.", "Success", "Success");
                        dataGridViewSalesLines.Rows.Clear();
                        textBoxSalesNumber.Text    = retrieve.RetrunSalesNumber().ToString();
                        comboBoxCustomer.Text      = "";
                        comboBoxSelectProduct.Text = "";
                        textBoxUnit.Clear();
                        textBoxQuantity.Clear();
                        textBoxProdCost.Clear();
                        textBoxTotalCost.Clear();
                        CreateSalesPdfReport(SalesID);
                        labelGrandTotalValue.Text = "0.00";
                    }
                    else
                    {
                        MainClass.ShowMessage("Unable to create Sales Invoice.", "Error", "Error");
                    }
                    tc.Complete();
                }
            }
        }
Exemplo n.º 7
0
        private void Load()
        {
            Updation update = new Updation();

            update.UpdateStockDailyStatus();


            timer2.Start();
            StockNotification = retrieve.StocksStatusNotification();
            if (StockNotification == 1)
            {
                labelNotifcationStatus.Text = "Stocks are at Minimum level.";
                comboBoxProducts.Visible    = true;

                linkLabelMin.Visible = true;

                retrieve.GetListsComboStocks("Usp_ProductsWithMinValuesofStocks", comboBoxProducts, "ProductName", "ID");
            }
            // labelUser.Text = Retrievel.User_Name;
        }
Exemplo n.º 8
0
        private void buttonResolveRejecteStock_Click(object sender, EventArgs e)
        {
            if (comboBoxSelectProduct.SelectedIndex == -1)
            {
                labelProductDateError.Visible = true;
            }
            else
            {
                labelProductDateError.Visible = false;
            }
            if (textBoxQuantity.Text == "")
            {
                labelQuantityError.Visible = true;
            }
            else
            {
                labelQuantityError.Visible = false;
            }
            if (labelProductDateError.Visible || labelQuantityError.Visible)
            {
                MainClass.ShowMessage("Fields with * are mandatory", "Error", "Error"); //Error is the type of message.
            }
            else
            {
                Updation update = new Updation();

                int row = update.UpdateIResolveRejectedStocks(Convert.ToInt32(comboBoxSelectProduct.SelectedValue.ToString()), Convert.ToDecimal(textBoxQuantity.Text), dateTimePickerEntryDate.Value);

                if (row > 0)
                {
                    ShowDataInGrid();
                    MainClass.ShowMessage("Stocks added sucessfully", "Success", "Success");
                    textBoxQuantity.Clear();
                }
                else
                {
                    MainClass.ShowMessage("Please Add Rejected Stocks first.", "Error", "Error");
                }
            }
        }
        public override void buttonSave_Click(object sender, EventArgs e)
        {
            if (textBoxProductName.Text == "")
            {
                labelProductNameError.Visible = true;
            }
            else
            {
                labelProductNameError.Visible = false;
            }

            if (textBoxProductCode.Text == "")
            {
                labelProductCodeError.Visible = true;
            }
            else
            {
                labelProductCodeError.Visible = false;
            }
            if (textBoxPrice.Text == "")
            {
                labelPurchasePriceError.Visible = true;
            }
            else
            {
                labelPurchasePriceError.Visible = false;
            }
            if (textBoxUnit.Text == "")
            {
                labelUnitError.Visible = true;
            }
            else
            {
                labelUnitError.Visible = false;
            }

            if (textBoxMinimumValue.Text == "")
            {
                labelMinValueError.Visible = true;
            }
            else
            {
                labelMinValueError.Visible = false;
            }
            if (textBoxSalesPrice.Text == "")
            {
                labelSalePriceError.Visible = true;
            }
            else
            {
                labelSalePriceError.Visible = false;
            }

            if (comboBoxCategory.SelectedIndex == -1)
            {
                labelCategoryError.Visible = true;
            }
            else
            {
                labelCategoryError.Visible = false;
            }

            if (labelProductNameError.Visible || labelProductCodeError.Visible || labelPurchasePriceError.Visible || labelUnitError.Visible || labelMinValueError.Visible || labelCategoryError.Visible || labelSalePriceError.Visible)
            {
                MainClass.ShowMessage("Fields with * are mandatory", "Error", "Error"); //Error is the type of message.
            }
            else
            {
                if (edit == 0)  //Code for save operation
                {
                    Insertion insert = new Insertion();
                    insert.SaveProductDetails(textBoxProductName.Text, textBoxProductCode.Text, Convert.ToDecimal(textBoxPrice.Text), textBoxUnit.Text, Convert.ToDecimal(textBoxMinimumValue.Text), Convert.ToInt32(comboBoxCategory.SelectedValue), Convert.ToDecimal(textBoxSalesPrice.Text), true);


                    retrieve.ShowProducts(dataGridViewProduct, ProductIdGv, ProductNameGv, ProductCodeGv, ProductPriceGv, ProductUnitGv, ProductMinValGv, ProductCatNameGv, ProductCatIdGv, SalesPriceGv);
                    //MainClass.Disable_Reset(panelRightSlider);
                }
                else if (edit == 1) //code for update operaiton
                {
                    DialogResult dr = MessageBox.Show("Are you sure, you want to update record.", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

                    if (dr == DialogResult.Yes)
                    {
                        Updation update = new Updation();
                        update.UpdateProductDetails(textBoxProductName.Text, textBoxProductCode.Text, Convert.ToDecimal(textBoxPrice.Text), textBoxUnit.Text, Convert.ToDecimal(textBoxMinimumValue.Text), CategoryId, ProductId, Convert.ToDecimal(textBoxSalesPrice.Text));


                        retrieve.ShowProducts(dataGridViewProduct, ProductIdGv, ProductNameGv, ProductCodeGv, ProductPriceGv, ProductUnitGv, ProductMinValGv, ProductCatNameGv, ProductCatIdGv, SalesPriceGv);
                        //   MainClass.Disable_Reset(panelRightSlider);
                    }
                }
            }
        }
        private void buttonAddToStocks_Click(object sender, EventArgs e)
        {
            if (comboBoxSelectProduct.SelectedIndex == -1)
            {
                labelProductDateError.Visible = true;
            }
            else
            {
                labelProductDateError.Visible = false;
            }
            if (string.IsNullOrEmpty(textBoxQuantity.Text))
            {
                labelQuantityError.Visible = true;
            }
            else
            {
                labelQuantityError.Visible = false;
            }
            if (string.IsNullOrEmpty(dateTimePickerEntryDate.Text))
            {
                labelEntryDateError.Visible = true;
            }
            else
            {
                labelEntryDateError.Visible = false;
            }
            if (labelProductDateError.Visible || labelQuantityError.Visible || labelEntryDateError.Visible)
            {
                MainClass.ShowMessage("Fields with * are mandatory", "Error", "Error"); //Error is the type of message.
            }
            else
            {
                Updation update = new Updation();

                update.UpdateIncreaseAvailableStocks(Convert.ToInt32(comboBoxSelectProduct.SelectedValue.ToString()), Convert.ToDecimal(textBoxQuantity.Text), dateTimePickerEntryDate.Value);
                retrieve.ShowStock(dataGridViewProduct, ProductIdGv, ProductNameGv, ProductCodeGv, ProductUnitGv, ProductMinValGv, AvailableStocks, ReworkedStock, RejectedStock, OnholdStock);
                foreach (DataGridViewRow rows in dataGridViewProduct.Rows)
                {
                    if (Convert.ToDecimal(rows.Cells["ProductMinValGv"].Value) < Convert.ToDecimal(rows.Cells["AvailableStocks"].Value))
                    {
                        rows.Cells["ProductNameGv"].Style.BackColor = Color.LightGreen;
                        rows.Cells["ProductNameGv"].Style.ForeColor = Color.Black;


                        rows.Cells["AvailableStocks"].Style.BackColor = Color.LightGreen;
                        rows.Cells["AvailableStocks"].Style.ForeColor = Color.Black;
                    }
                    else
                    {
                        rows.Cells["ProductNameGv"].Style.BackColor = Color.IndianRed;
                        rows.Cells["ProductNameGv"].Style.ForeColor = Color.Black;

                        rows.Cells["AvailableStocks"].Style.BackColor = Color.IndianRed;
                        rows.Cells["AvailableStocks"].Style.ForeColor = Color.Black;
                    }
                }

                MainClass.ShowMessage("Stocks added sucessfully", "Success", "Success");

                textBoxQuantity.Clear();
            }
        }
Exemplo n.º 11
0
        public override void buttonSave_Click(object sender, EventArgs e)
        {
            if (textBoxSupplierName.Text == "")
            {
                labelSupplierNameError.Visible = true;
            }
            else
            {
                labelSupplierNameError.Visible = false;
            }

            if (textBoxSupplierCode.Text == "")
            {
                labelSupplierCodeError.Visible = true;
            }
            else
            {
                labelSupplierCodeError.Visible = false;
            }
            if (textBoxSupplierContactNumber.Text == "")
            {
                labelSupplierContactError.Visible = true;
            }
            else
            {
                labelSupplierContactError.Visible = false;
            }
            if (textBoxSupplierEmail.Text == "")
            {
                labelSupplierEmailError.Visible = true;
            }
            else
            {
                labelSupplierEmailError.Visible = false;
            }
            if (textBoxAddress.Text == "")
            {
                labelAddressError.Visible = true;
            }
            else
            {
                labelAddressError.Visible = false;
            }
            if (textBoxSupplierCity.Text == "")
            {
                labelSupplierCityError.Visible = true;
            }
            else
            {
                labelSupplierCityError.Visible = false;
            }

            if (textBoxCountry.Text == "")
            {
                labelCountryError.Visible = true;
            }
            else
            {
                labelCountryError.Visible = false;
            }
            if (textBoxPayment.Text == "")
            {
                labelPaymentError.Visible = true;
            }
            else
            {
                labelPaymentError.Visible = false;
            }

            if (textBoxDeliveryMethod.Text == "")
            {
                labelDelMethodError.Visible = true;
            }
            else
            {
                labelDelMethodError.Visible = false;
            }
            if (textBoxDelLeadTime.Text == "")
            {
                labelDelLeadTimeError.Visible = true;
            }
            else
            {
                labelDelLeadTimeError.Visible = false;
            }

            if (labelSupplierNameError.Visible || labelSupplierCodeError.Visible || labelSupplierContactError.Visible || labelSupplierEmailError.Visible || labelAddressError.Visible || labelSupplierCityError.Visible || labelCountryError.Visible || labelDelMethodError.Visible || labelPaymentError.Visible || labelDelLeadTimeError.Visible)
            {
                MainClass.ShowMessage("Fields with * are mandatory", "Error", "Error"); //Error is the type of message.
            }
            else
            {
                if (edit == 0)  //Code for save operation
                {
                    Insertion insert = new Insertion();
                    insert.SaveSupplierDetails(textBoxSupplierName.Text, textBoxSupplierCode.Text, textBoxSupplierContactNumber.Text, textBoxSupplierEmail.Text, textBoxAddress.Text, textBoxSupplierCity.Text, textBoxCountry.Text, textBoxPayment.Text, textBoxDeliveryMethod.Text, textBoxDelLeadTime.Text, Convert.ToDecimal(textBoxDelLeadTime.Text));


                    retrieve.ShowSupplier(dataGridViewSupplier, SupplierIdGv, SupplierNameGv, SupplierCodeGv, SupplierContactNumberGv, SupplierEmailGv, SupplierAddresseGv, SupplierCityGv, SupplierCountryGv, SupplierPaymentMethodGv, SupplierDeliveryMethodGv, SupplierDeliveryLeadTimeIdGv);
                    MainClass.Disable_Reset(panelRightSlider);
                }
                else if (edit == 1) //code for update operaiton
                {
                    DialogResult dr = MessageBox.Show("Are you sure, you want to update record.", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

                    if (dr == DialogResult.Yes)
                    {
                        Updation update = new Updation();
                        update.UpdateSupplierDetails(textBoxSupplierName.Text, textBoxSupplierCode.Text, textBoxSupplierContactNumber.Text, textBoxSupplierEmail.Text, textBoxAddress.Text, textBoxSupplierCity.Text, textBoxCountry.Text, textBoxPayment.Text, textBoxDeliveryMethod.Text, textBoxDelLeadTime.Text, Convert.ToDecimal(textBoxDelLeadTime.Text), SupplierId);

                        retrieve.ShowSupplier(dataGridViewSupplier, SupplierIdGv, SupplierNameGv, SupplierCodeGv, SupplierContactNumberGv, SupplierEmailGv, SupplierAddresseGv, SupplierCityGv, SupplierCountryGv, SupplierPaymentMethodGv, SupplierDeliveryMethodGv, SupplierDeliveryLeadTimeIdGv);
                        MainClass.Disable_Reset(panelRightSlider);
                    }
                }
            }
        }
Exemplo n.º 12
0
        public override void buttonSave_Click(object sender, EventArgs e)
        {
            if (textBoxUserName.Text == "")
            {
                labelNameError.Visible = true;
            }
            else
            {
                labelNameError.Visible = false;
            }
            if (textBoxPasword.Text == "")
            {
                labelPasswordError.Visible = true;
            }
            else
            {
                labelPasswordError.Visible = false;
            }
            if (textBoxContact.Text == "")
            {
                labelContactNumberError.Visible = true;
            }
            else
            {
                labelContactNumberError.Visible = false;
            }
            if (textBoxEmail.Text == "")
            {
                labelEmailError.Visible = true;
            }
            else
            {
                labelEmailError.Visible = false;
            }
            if (comboBoxSelectRole.SelectedIndex == -1)
            {
                labelRoleError.Visible = true;
            }
            else
            {
                labelRoleError.Visible = false;
            }
            if (labelNameError.Visible || labelPasswordError.Visible || labelContactNumberError.Visible || labelEmailError.Visible || labelRoleError.Visible)
            {
                MainClass.ShowMessage("Fields with * are mandatory", "Error", "Error"); //Error is the type of message.
            }
            else
            {
                if (edit == 0)  //Code for save operation
                {
                    Insertion insert = new Insertion();
                    insert.SaveUserDetails(textBoxUserName.Text, textBoxPasword.Text, textBoxContact.Text, textBoxEmail.Text, Convert.ToInt32(comboBoxSelectRole.SelectedValue));

                    retrieve.ShowUsers(dataGridViewUsers, UserIdGV, UsernameGV, PasswordGV, ContactGv, EmailGV, Role, RoleId);
                    MainClass.Disable_Reset(panelRightSlider);
                }
                else if (edit == 1) //code for update operaiton
                {
                    DialogResult dr = MessageBox.Show("Are you sure, you want to update record.", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

                    if (dr == DialogResult.Yes)
                    {
                        Updation update = new Updation();
                        update.UpdateUserDetails(textBoxUserName.Text, textBoxPasword.Text, textBoxContact.Text, textBoxEmail.Text, userId, Convert.ToInt32(comboBoxSelectRole.SelectedValue));

                        retrieve.ShowUsers(dataGridViewUsers, UserIdGV, UsernameGV, PasswordGV, ContactGv, EmailGV, Role, RoleId);
                        MainClass.Disable_Reset(panelRightSlider);
                    }
                }
            }
        }