protected void DMGrid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxTextBox qty = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["EdittedQty"], "InvEdittedQty") as ASPxTextBox; ASPxTextBox cost = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["EdittedCost"], "InvEdittedCost") as ASPxTextBox; ASPxTextBox total = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["EdittiedTotalCost"], "InvEdittiedTotalCost") as ASPxTextBox; string PK = e.Keys[0].ToString(); Double qty_float = 0, cost_float = 0, total_float = 0; if (qty.Value != null) { qty_float = Convert.ToDouble(qty.Value.ToString()); } if (cost.Value != null) { cost_float = Convert.ToDouble(cost.Value.ToString()); } if (total.Value != null) { total_float = Convert.ToDouble(total.Value.ToString()); } //Double qty_float = Convert.ToDouble(qty.Value.ToString()); //Double cost_float = Convert.ToDouble(cost.Value.ToString()); //Double total_float = Convert.ToDouble(total.Value.ToString()); SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); //string update = "UPDATE " + MRPClass.DirectMatTable() + // " SET [EdittedQty] = @QTY, [EdittedCost] = @COST, [EdittiedTotalCost] = @TOTAL, " + // " [ApprovedQty] = @QTY, [ApprovedCost] = @COST, [ApprovedTotalCost] = @TOTAL " + // " WHERE [PK] = @PK"; //SqlCommand cmd = new SqlCommand(update, conn); //cmd.Parameters.AddWithValue("@PK", PK); //cmd.Parameters.AddWithValue("@QTY", qty_float); //cmd.Parameters.AddWithValue("@COST", cost_float); //cmd.Parameters.AddWithValue("@TOTAL", total_float); //cmd.CommandType = CommandType.Text; //int result = cmd.ExecuteNonQuery(); int result = QuerySPClass.InsertUpdateDirectMaterials(wrkflwln, 2, Convert.ToInt32(PK), docnumber, 1, "", "", "", "", "", "", "", qty_float, cost_float, total_float); if (result > 0) { MRPClass.UpdateLastModified(conn, docnumber); string remarks = MRPClass.directmaterials_logs + "-" + MRPClass.edit_logs; MRPClass.AddLogsMOPList(conn, mrp_key, remarks); } conn.Close(); e.Cancel = true; grid.CancelEdit(); bindDM = true; BindDirectMaterials(docnumber); }
protected void CapexGridApproval_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxTextBox qty = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ApprovedQty"], "ApprovedQtyCapex") as ASPxTextBox; ASPxTextBox cost = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ApprovedCost"], "ApprovedCostCapex") as ASPxTextBox; ASPxTextBox total = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ApprovedTotalCost"], "ApprovedTotalCostCapex") as ASPxTextBox; string PK = e.Keys[0].ToString(); Double qty_float = Convert.ToDouble(qty.Value.ToString()); Double cost_float = Convert.ToDouble(cost.Value.ToString()); Double total_float = Convert.ToDouble(total.Value.ToString()); SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string update = "UPDATE " + MRPClass.CapexTable() + " SET [ApprovedQty] = @QTY, [ApprovedCost] = @COST, [ApprovedTotalCost] = @TOTAL WHERE [PK] = @PK"; SqlCommand cmd = new SqlCommand(update, conn); cmd.Parameters.AddWithValue("@PK", PK); cmd.Parameters.AddWithValue("@QTY", qty_float); cmd.Parameters.AddWithValue("@COST", cost_float); cmd.Parameters.AddWithValue("@TOTAL", total_float); cmd.CommandType = CommandType.Text; int result = cmd.ExecuteNonQuery(); if (result > 0) { MRPClass.UpdateLastModified(conn, docnumber); string remarks = MRPClass.capex_logs + "-" + MRPClass.edit_logs; MRPClass.AddLogsMOPList(conn, mrp_key, remarks); } conn.Close(); e.Cancel = true; grid.CancelEdit(); bindCapex = true; BindCapex(docnumber); }