public static int addGodownTransfer(godownTransfer gm)
 {
     try
     {
         List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
         parameter.Add(new KeyValuePair <string, object>("@godownTransferId", gm.godownTransferId));
         parameter.Add(new KeyValuePair <string, object>("@godownTransferDate", gm.godownTransferDate));
         parameter.Add(new KeyValuePair <string, object>("@fromGodownTransfer", gm.fromGodownTransfer));
         parameter.Add(new KeyValuePair <string, object>("@toGodownTransfer", gm.toGodownTransfer));
         parameter.Add(new KeyValuePair <string, object>("@addedBy", gm.addedBy));
         parameter.Add(new KeyValuePair <string, object>("@addedOn", gm.addedOn));
         parameter.Add(new KeyValuePair <string, object>("@FinancialYearID", gm.FinancialYearID));
         parameter.Add(new KeyValuePair <string, object>("@isUpdate", gm.isUpdate));
         parameter.Add(new KeyValuePair <string, object>("@isDelete", gm.isDelete));
         parameter.Add(new KeyValuePair <string, object>("@invoiceId", gm.invoiceId));
         SqlHandler sqlH   = new SqlHandler();
         int        listi  = sqlH.ExecuteNonQueryI("[dbo].[Usp_addGodownTransfer]", parameter);
         int        result = 0;
         for (int k = 0; k < gm.dtItems.Rows.Count; k++)
         {
             List <KeyValuePair <string, object> > parameter1 = new List <KeyValuePair <string, object> >();
             parameter1.Add(new KeyValuePair <string, object>("@godownTransferId", gm.godownTransferId));
             parameter1.Add(new KeyValuePair <string, object>("@FinancialYearID", gm.FinancialYearID));
             parameter1.Add(new KeyValuePair <string, object>("@stockIdFrom", gm.dtItems.Rows[k]["stockId"]));
             parameter1.Add(new KeyValuePair <string, object>("@stockIdTo", gm.dtItems.Rows[k]["stockIdTo"]));
             parameter1.Add(new KeyValuePair <string, object>("@itemId", gm.dtItems.Rows[k]["itemId"]));
             parameter1.Add(new KeyValuePair <string, object>("@categoryId", gm.dtItems.Rows[k]["categoryId"]));
             parameter1.Add(new KeyValuePair <string, object>("@companyId", gm.dtItems.Rows[k]["companyId"]));
             parameter1.Add(new KeyValuePair <string, object>("@productCode", gm.dtItems.Rows[k]["productCode"]));
             parameter1.Add(new KeyValuePair <string, object>("@godownNameto", gm.toGodownTransfer));
             parameter1.Add(new KeyValuePair <string, object>("@godownNamefrom", gm.fromGodownTransfer));
             parameter1.Add(new KeyValuePair <string, object>("@batchNo", gm.dtItems.Rows[k]["batchNo"]));
             parameter1.Add(new KeyValuePair <string, object>("@MFGDate", Convert.ToDateTime(gm.dtItems.Rows[k]["MFD_Date"])));
             parameter1.Add(new KeyValuePair <string, object>("@exprireDate", Convert.ToDateTime(gm.dtItems.Rows[k]["expireDate"])));
             parameter1.Add(new KeyValuePair <string, object>("@Quantity", gm.dtItems.Rows[k]["Quantity"]));
             parameter1.Add(new KeyValuePair <string, object>("@unitBy", gm.dtItems.Rows[k]["unitBy"]));
             parameter1.Add(new KeyValuePair <string, object>("@godownTransfertemId", gm.dtItems.Rows[k]["godownTransfertemId"]));
             parameter1.Add(new KeyValuePair <string, object>("@isUpdate", gm.isUpdate));
             parameter1.Add(new KeyValuePair <string, object>("@isDelete", gm.isDelete));
             parameter1.Add(new KeyValuePair <string, object>("@addedBy", gm.addedBy));
             parameter1.Add(new KeyValuePair <string, object>("@addedOn", gm.addedOn));
             parameter1.Add(new KeyValuePair <string, object>("@invoiceId", gm.invoiceId));
             result = +sqlH.ExecuteNonQueryI("[dbo].[Usp_addGodownTransferItem]", parameter1);
         }
         return(listi + result);
     }
     catch (Exception ae)
     {
         throw ae;
     }//8999501263
 }
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (cmbFromGodown.SelectedIndex == 0 || cmbFromGodown.SelectedValue == null)
                {
                    if (Utility.Langn == "English")
                    {
                        MessageBox.Show("Please select From Godown...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                    else
                    {
                        MessageBox.Show("कृपया From गोडाऊन निवडा...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                    cmbFromGodown.Focus(); return;
                }
                if (cmbtoGodown.SelectedIndex == 0 || cmbtoGodown.SelectedValue == null)
                {
                    if (Utility.Langn == "English")
                    {
                        MessageBox.Show("Please select To Godown...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                    else
                    {
                        MessageBox.Show("कृपया To गोडाऊन निवडा...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                    cmbtoGodown.Focus(); return;
                }
                if (cmbFromGodown.Text.Trim() == cmbtoGodown.Text.Trim())
                {
                    if (Utility.Langn == "English")
                    {
                        MessageBox.Show("Please Change To Godown...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                    else
                    {
                        MessageBox.Show("कृपया To गोडाऊन बदला...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                    cmbtoGodown.Focus(); return;
                }
                for (int c = 0; c < dgvGodownTransfer.Rows.Count; c++)
                {
                    if (dgvGodownTransfer.Rows[c].Cells["itemName"].Value == null)
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please add Item Name in list..");
                        }
                        else
                        {
                            MessageBox.Show("कृपया लिस्ट मध्ये वस्तूचे नाव भरा..");
                        }
                        dgvGodownTransfer.Focus();
                        dgvGodownTransfer.CurrentCell = dgvGodownTransfer.Rows[c].Cells["itemName"];
                        return;
                    }
                    if (dgvGodownTransfer.Rows[c].Cells["Quantity"].Value == null || Convert.ToDouble(dgvGodownTransfer.Rows[c].Cells["Quantity"].Value) == 0)
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please add Quantity in list..");
                        }
                        else
                        {
                            MessageBox.Show("कृपया लिस्ट मध्ये वस्तूचे नाव भरा..");
                        }
                        dgvGodownTransfer.Focus();
                        dgvGodownTransfer.CurrentCell = dgvGodownTransfer.Rows[c].Cells["Quantity"];
                        return;
                    }
                }

                godownTransfer gm = new godownTransfer();
                if (isUpdate == false && isDelete == false)
                {
                    gm.godownTransferId = SaleDetailsController.getMaxIdSalesItemDetails(5, Utility.FinancilaYearId);
                    gm.invoiceId        = SaleDetailsController.getMaxIdSalesItemDetails(6, Utility.FinancilaYearId);
                }
                else
                {
                    gm.godownTransferId = Convert.ToInt64(txtId.Text);
                    gm.invoiceId        = Convert.ToInt64(txtInvoice.Text);
                }
                gm.godownTransferDate = dtpDate.Value;
                gm.fromGodownTransfer = cmbFromGodown.Text.Trim();
                gm.toGodownTransfer   = cmbtoGodown.Text.Trim();
                gm.isDelete           = isDelete;
                gm.isUpdate           = isUpdate;
                DataTable dtSaleItems = new DataTable();
                foreach (DataGridViewColumn col in dgvGodownTransfer.Columns)
                {
                    dtSaleItems.Columns.Add(col.Name);
                }

                foreach (DataGridViewRow row in dgvGodownTransfer.Rows)
                {
                    DataRow dRow = dtSaleItems.NewRow();
                    foreach (DataGridViewCell cell in row.Cells)
                    {
                        if (cell.Value == null)
                        {
                            if (Utility.Langn == "English")
                            {
                                MessageBox.Show("Please add all details in list");
                            }
                            else
                            {
                                MessageBox.Show("कृपया लिस्ट मध्ये पूर्ण माहिती भरा");
                            }
                            return;
                        }
                        dRow[cell.ColumnIndex] = cell.Value;
                    }
                    dtSaleItems.Rows.Add(dRow);
                }
                gm.dtItems         = dtSaleItems;
                gm.FinancialYearID = Utility.FinancilaYearId;
                gm.addedBy         = 1;
                gm.addedOn         = dtpDate.Value;

                int    i   = 0;
                string msg = "";
                if (isDelete == false)
                {
                    if (Utility.Langn == "English")
                    {
                        msg = "Record Saved successfully !! ";
                    }
                    else
                    {
                        msg = "माहिती यशस्वीरित्या साठवल्या गेली !! ";
                    }
                    i = godownTransferController.addGodownTransfer(gm);
                }
                if (isDelete == true)
                {
                    if (Utility.Langn == "English")
                    {
                        msg = "Record Deleted successfully!! ";
                    }
                    else
                    {
                        msg = "माहिती यशस्वीरित्या   डिलीट  झाली आहे!! ";
                    }
                    i = godownTransferController.addGodownTransfer(gm);
                }
                if (i > 0)
                {
                    MessageBox.Show(msg, "जतन", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    btnnew_Click(sender, e);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }