protected void grdWorkflowMaster_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
ASPxPageControl pageControl = grid.FindEditFormTemplateControl("WorkflowMasterPageControl") as ASPxPageControl;
ASPxDateEdit effectDate = pageControl.FindControl("EffectDate") as ASPxDateEdit;
ASPxComboBox entCode = pageControl.FindControl("EntCode") as ASPxComboBox;
ASPxComboBox buCode = pageControl.FindControl("BUCode") as ASPxComboBox;
ASPxComboBox buHead = pageControl.FindControl("BUHead") as ASPxComboBox;
SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());
conn.Open();
string PK = e.Keys[0].ToString();
string entCodeDesc = GlobalClass.EntityCodeDescription(entCode.Value.ToString());
string buCodeDesc = GlobalClass.BUCodeDescription(buCode.Value.ToString());
string buHeadName = AccountClass.UserCompleteName(Convert.ToInt32(buHead.Value.ToString()));
string sLastModified = DateTime.Now.ToString();
string update_MRP = "UPDATE tbl_System_Workflow " +
" SET [EffectDate] = @EffectDate, " +
" [EntCode] = @EntCode, " +
" [BUCode] = @BUCode, " +
" [BUHead]= @BUHead, " +
" [LastModified] = @LastModified " +
" WHERE [PK] = @PK";
SqlCommand cmd = new SqlCommand(update_MRP, conn);
cmd.Parameters.AddWithValue("@PK", PK);
cmd.Parameters.AddWithValue("@EffectDate", effectDate.Value.ToString());
cmd.Parameters.AddWithValue("@EntCode", entCode.Value.ToString());
cmd.Parameters.AddWithValue("@BUCode", buCode.Value.ToString());
cmd.Parameters.AddWithValue("@BUHead", buHead.Value.ToString());
cmd.Parameters.AddWithValue("@LastModified", sLastModified);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
conn.Close();
BindWorkflow();
e.Cancel = true;
grid.CancelEdit();
}
