Monday 18 March 2013

Multiple data Insert from gridview using datatable in Window Application





C# Code
 private void FrmKitSetUp_Load(object sender, EventArgs e)
        {
            CreateDataTable();                     
        }
private void CreateDataTable()
        {
            try
            {
                dt = new DataTable();
                dt.Columns.Add("SlNo", typeof(int));
                dt.Columns.Add("Barcode", typeof(string));
                dt.Columns.Add("Quantity", typeof(int));
                dt.Columns.Add("Item_id", typeof(int));
            }
            catch (Exception ex)
            {
            }
        }
  private void BtnSave_Click(object sender, EventArgs e)
        {
            if (checkData() == true)
            {
                if (checkDuplicateSave() == true)
                {
                    if (MessageBox.Show("Do you want to save this record?", "kenCloud", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == System.Windows.Forms.DialogResult.Yes)
                    {
                        CreateDataTable_Insert();
                        TAGGING_Setup objIssueQC = new TAGGING_Setup();
                        // objIssueQC.Issue_NO_QC = "1";
                        objIssueQC.Pack_Title = TxtTitle.Text.Trim();
                        objIssueQC.Barcode = CmbBarcode.Text.Trim();
                        objIssueQC.Created_By = 1;
                        objIssueQC.KitDetails = dt1;
                        ERPManagement.GetInstance.InsertKitting(objIssueQC);
                        MessageBox.Show("Data saved successfully.", "KenCloud", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        Reset();
                    }
                }
            }
        }

 private void CreateDataTable_Insert()
        {
            try
            {
                dt1 = new DataTable();
                dt1.Columns.Add("Barcode", typeof(string));
                dt1.Columns.Add("Quantity", typeof(int));
                dt1.Columns.Add("Item_id", typeof(int));

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    dt1.Rows.Add(new Object[] { dt.Rows[i][1].ToString(), int.Parse(dt.Rows[i][2].ToString()), int.Parse(dt.Rows[i][3].ToString()) });
                    dt1.AcceptChanges();
                    dt1.DefaultView.Sort = "Barcode";
                }
            }
            catch (Exception ex)
            {
            }
        }
//Grid re add Heba
  private void BtnAdd_Click(object sender, EventArgs e)
        {
                       if (int.Parse(TxtQuantity.Text) <= quantity)
                    {
                        EditDataTable();

                    }

       }
   private void EditDataTable()
        {
            if (DataTableEditFlag == 2)
            {
                if (InsertIntoGridAtEdit() == true)
                {
                    if (rowindex == DgvBarcode.CurrentRow.Index)
                    {
                        dt.Rows[rowindex]["Barcode"] = CmbBarcode.Text;
                        dt.Rows[rowindex]["Quantity"] = TxtQuantity.Text;
                        dt.AcceptChanges();
                        DgvBarcode.DataSource = dt;
                        DataTableEditFlag = 1;
                        GetSlnoDtTbl(dt, TxtSlno);
                        ClearBarcode();
                    }
                    else
                    {
                        MessageBox.Show("You have select a wrong barcode to edit.", "KenCloud", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        // ClearBarcode();
                        CmbBarcode.Focus();
                        return;
                    }
                }
            }}

Multiple data Insert from gridview using datatable in Asp.Net


C# Code
  protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                  CreateDataTable();
            }
        }

     private void CreateDataTable()
        {
            try
            {
                dt = new DataTable();
                dt.Columns.Add("Barcode", typeof(string));
                dt.Columns.Add("Quantity", typeof(int));
                dt.Columns.Add("Category_id", typeof(int));
                dt.Columns.Add("Item_id", typeof(int));
               
                ViewState["tabledata"] = dt;
            }
            catch (Exception ex)
            {
            }

        }
//Grid re Add Heba
 protected void BtnAdd_Click(object sender, EventArgs e)
        {
            if (Checkwhenaddgrid() == true)
            {
                dt = new DataTable();
                dt = (DataTable)ViewState["tabledata"];
                DataRow dr;
                if (flag == 0)
                {
                    dr = dt.NewRow();
                    dr[0] = TxtBarcode.Text;
                    dr[1] = TxtQuantity.Text;
                    dr[2] = ViewState["cataid"];
                    dr[3] = ViewState["ItemID"];
                    dt.Rows.Add(dr);
                }
                else if (flag == 1)
                {
                     dt.Rows[rowno][0] = TxtBarcode.Text;
                     dt.Rows[rowno][1] = TxtQuantity.Text;
                    dt.Rows[rowno][2] = ViewState["cataid"];
                    dt.Rows[rowno][3] = ViewState["ItemID"];
                }
                ViewState["tabledata"] = dt;
                TxtBarcode.Text = "";
                TxtQuantity.Text = "";
                FillGrid();
                foreach (GridViewRow dgv in GrdViewKit.Rows)
                {
                    int a = GrdViewKit.Rows.Count;
                    TxttotalNoOfIems.Text = Convert.ToString(a);
                }
            }
        }
 protected void BtnSave_Click(object sender, EventArgs e)
        {
            save_single();
        }
  private void save_single()
        {
            if (checkData() == true)
            {
                CreateDataTable();
                CreateDataTable_Insert();
                TAGGING_IssueToPackagingAndKitting objIssueQC = new TAGGING_IssueToPackagingAndKitting();
                objIssueQC.Issue_To = int.Parse(DDlIssueTo.SelectedValue.ToString());
                objIssueQC.Expected_Receive_Date = Convert.ToDateTime(TxtIssueDate.Text);
                objIssueQC.Issue_Date_Packing = Convert.ToDateTime(TxtExpectedReceiveDate.Text);
                objIssueQC.Toatl_Qty_of_Items = int.Parse(TxttotalNoOfIems.Text);
                objIssueQC.Toatl_Gross_Weight = 0;
                objIssueQC.Toatl_Stone_Weight = 0;
                objIssueQC.Toatl_Net_Weight = 0;
                objIssueQC.Created_By = 1;
                objIssueQC.ItemDetailsPacking = dt;
                issueNo = ERPManagement.GetInstance.InsertPackingAndKitting(objIssueQC);
                Message("Data saved successfully." + Environment.NewLine + "Issue to pack single no. :" + issueNo);//, "KenCloud", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }
        }
 private void CreateDataTable_Insert()
        {
            try
            {
                foreach (GridViewRow gvr in GrdViewKit.Rows)
                {
                    if (GrdViewKit.Rows.Count > 0)
                    {
                        DataRow dr = dt.NewRow();
                        dr["Barcode"] = gvr.Cells[0].Text;
                        dr["Quantity"] = gvr.Cells[1].Text;
                        int Category_id = Convert.ToInt32(GrdViewKit.DataKeys[gvr.RowIndex].Values[0]);
                        int Item_ID = Convert.ToInt32(GrdViewKit.DataKeys[gvr.RowIndex].Values[1]);
                        dr["Category_id"] = Category_id;
                        dr["Item_ID"] = Item_ID;                      
                        dt.Rows.Add(dr);
                        dt.AcceptChanges();
                    }
                }

            }
            catch (Exception ex)
            {
            }

        }