protected void ManPowerGridApproval_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
ASPxTextBox qty = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ApprovedQty"], "ApprovedQtyManPower") as ASPxTextBox;
ASPxTextBox cost = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ApprovedCost"], "ApprovedCostManPower") as ASPxTextBox;
ASPxTextBox total = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ApprovedTotalCost"], "ApprovedTotalCostManPower") 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.ManPowerTable() + " 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.manpower_logs + "-" + MRPClass.edit_logs;
MRPClass.AddLogsMOPList(conn, mrp_key, remarks);
}
conn.Close();
e.Cancel = true;
grid.CancelEdit();
bindManPower = true;
BindManPower(docnumber);
}
