protected void btngo_Click(object sender, EventArgs e) { try { lblerror.Visible = false; divform.Visible = true; btnsave.Enabled = true; tblinstallment.Visible = true; int projectid = Convert.ToInt32(ddlproject.SelectedValue); ViewState["Installment"] = txtinstallment.Text.Trim(); createtable(); } catch (Exception ex) { } } protected void btnsave_Click(object sender, EventArgs e) { try { lblerror.Visible = false; ViewState["ItemName"] = null; #region DataTable if (dttrue == true) { table = new DataTable("Installment"); DataColumn column1 = new DataColumn(); column1.DataType = System.Type.GetType("System.String"); column1.Caption = "ItemName"; column1.ColumnName = "ItemName"; DataColumn column2 = new DataColumn(); column2.DataType = System.Type.GetType("System.String"); column2.Caption = "Quantity"; column2.ColumnName = "Quantity"; DataColumn column3 = new DataColumn(); column3.DataType = System.Type.GetType("System.String"); column3.Caption = "UOM"; column3.ColumnName = "UOM"; DataColumn column4 = new DataColumn(); column4.DataType = System.Type.GetType("System.String"); column4.Caption = "Description"; column4.ColumnName = "Description"; table.Columns.Add(column1); table.Columns.Add(column2); table.Columns.Add(column3); table.Columns.Add(column4); dttrue = false; } #endregion DataRow row; int count = int.Parse(ViewState["Installment"].ToString()); for (int i = 1; i <= count; i++) { DropDownList textdays; int uom = 0; int ItemName = 0; DropDownList textbp = (DropDownList)tblinstallment.FindControl("txtbasic" + i.ToString()); if (textbp.SelectedIndex != 0) { ItemName = Convert.ToInt32(textbp.SelectedIndex); } else { lblerror.Text = "Please select Item Name"; lblerror.Visible = true; lblerror.ForeColor = Color.Red; return; } ViewState["ItemName"] = ItemName; TotalBasicPrice = 0; TotalOtherCharges = 0; TotalPLC = 0; TotalIFM = 0; TotalDiscountAdjust = 0; textdays = (DropDownList)tblinstallment.FindControl("txtdays" + i.ToString()); if (textdays.SelectedIndex != 0) { uom = Convert.ToInt32(textdays.SelectedIndex); } else { lblerror.Text = "Please select UOM"; lblerror.Visible = true; lblerror.ForeColor = Color.Red; return; } TextBox textIFM = (TextBox)tblinstallment.FindControl("txtifm" + i.ToString()); quantity = textIFM.Text.Trim(); TextBox textinststage = (TextBox)tblinstallment.FindControl("txtpaymentdesc" + i.ToString()); string Description = textinststage.Text.Trim(); row = table.NewRow(); row["ItemName"] = ItemName; row["UOM"] = uom; row["Quantity"] = quantity; row["Description"] = Description; table.Rows.Add(row); } ViewState["ItemName"] = null; DataSet ds = new DataSet(); ds.Tables.Add(table); ViewState["Table"] = ds; TotalBasicPrice = 0; TotalOtherCharges = 0; TotalPLC = 0; TotalIFM = 0; TotalDiscountAdjust = 0; SaveRequisition(); //Response.Redirect("~/Purchase/Requisition.aspx"); } catch (Exception ex) { lblerror.Text = ex.ToString(); lblerror.Visible = true; lblerror.ForeColor = Color.Red; } } public void SaveRequisition() { try { if (ViewState["Table"] != null) { ds = (DataSet)ViewState["Table"]; int count = ds.Tables[0].Rows.Count; objConnection = commonfunctions.GetConnection(); if (objConnection.State != ConnectionState.Open) { objConnection.Open(); } myTransaction = objConnection.BeginTransaction(); myCommand = new SqlCommand("sp_insert_Requisition", objConnection, myTransaction); myCommand.CommandType = CommandType.StoredProcedure; for (int i = 0; i < count; i++) { myCommand.Parameters.Clear(); SqlParameter param1 = new SqlParameter("@projectid", SqlDbType.Int, 4); param1.Value = Convert.ToInt32(ddlproject.SelectedValue); myCommand.Parameters.Add(param1); SqlParameter param2 = new SqlParameter("@DeptId", SqlDbType.Int, 4); param2.Value = Convert.ToInt32(ddlpaymentplan.SelectedValue); myCommand.Parameters.Add(param2); SqlParameter param3 = new SqlParameter("@ItemName", SqlDbType.Int, 4); param3.Value = Convert.ToDecimal(ds.Tables[0].Rows[i]["ItemName"].ToString()); myCommand.Parameters.Add(param3); SqlParameter param4 = new SqlParameter("@Quantity", SqlDbType.Decimal, 9); param4.Value = Convert.ToDecimal(ds.Tables[0].Rows[i]["Quantity"].ToString()); myCommand.Parameters.Add(param4); SqlParameter param5 = new SqlParameter("@UOM", SqlDbType.Int, 4); param5.Value = Convert.ToDecimal(ds.Tables[0].Rows[i]["UOM"].ToString()); myCommand.Parameters.Add(param5); SqlParameter param6 = new SqlParameter("@description", SqlDbType.VarChar, 200); param6.Value = (ds.Tables[0].Rows[i]["Description"].ToString()); myCommand.Parameters.Add(param6); SqlParameter param7 = new SqlParameter("@Submitedby", SqlDbType.VarChar, 50); param7.Value = TextBox1.Text; myCommand.Parameters.Add(param7); SqlParameter param8 = new SqlParameter("@Approvedby", SqlDbType.VarChar, 50); param8.Value = TextBox2.Text; myCommand.Parameters.Add(param8); myCommand.ExecuteNonQuery(); } myCommand.ExecuteNonQuery(); myTransaction.Commit(); myCommand.Dispose(); lblerror.Text = "Data save successfully"; ; lblerror.ForeColor = Color.Blue; lblerror.Visible = true; divform.Visible = false; txtinstallment.Text = ""; ViewState["Table"] = null; objConnection.Close(); ddlproject.SelectedIndex = 0; ddlpaymentplan.SelectedIndex = 0; //bindGrid(); } } catch (Exception ex) { btnsave.Enabled = true; myTransaction.Rollback(); objConnection.Close(); lblerror.Text = ex.Message; lblerror.Visible = true; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)