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);
}
