protected void AutoRefreshTimer_Tick(object sender, EventArgs e) { GridEntries.DataBind(); if (IsPostBack) { checkAll(); } }
/// <summary> /// Prepares informations to display grid properly /// </summary> private void InitializeGrid() { if (AvailableFieldTypes == null) { return; } var tmpGridEntries = new List <GridEntry>(); foreach (var field in AvailableFieldTypes) { var gridEntry = new GridEntry(); gridEntry = CreateEntry(directory, field, gridEntry); tmpGridEntries.Add(gridEntry); } GridEntries = tmpGridEntries; OriginalGridEntries = new List <GridEntry>(GridEntries.Select(g => (GridEntry)g.Clone()).ToList()); }
protected void AutoRefreshTimer_Tick(object sender, EventArgs e) { GridEntries.DataBind(); }
protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) { var strSql = new StringBuilder(string.Empty); var con = new SqlConnection(strConnection); var conQueue = new SqlConnection(strConnection); var cmd = new SqlCommand(); //CheckBox CheckNo = (CheckBox)sender; var rdbl = (RadioButtonList)sender; var grdRow = (GridViewRow)rdbl.NamingContainer; //CheckBox chkNo = (CheckBox)grdRow.FindControl("CheckNo"); var chkRl = (RadioButtonList)grdRow.FindControl("RadioButtonList1"); var lblID = (Label)grdRow.FindControl("LabelID"); var cusTime = DateTime.Now; var named = User.Identity.Name; if (chkRl.SelectedValue == "False") { try { const string strQueueUpdate = "Update NewQueue set Status = @Status, StatusTime = @StatusTime WHERE QueueID = @QueueID"; cmd.CommandType = CommandType.Text; cmd.CommandText = strQueueUpdate; cmd.Parameters.Clear(); //cmd.Parameters.AddWithValue("@CustCareApproval", ChkApp); cmd.Parameters.AddWithValue("@Status", "UNCLR"); cmd.Parameters.AddWithValue("@StatusTime", cusTime); cmd.Parameters.AddWithValue("@QueueID", lblID.Text); cmd.Connection = conQueue; conQueue.Open(); cmd.ExecuteNonQuery(); } catch (SqlException ex) { var errorMsg = "Error in Updation"; errorMsg += ex.Message; throw new Exception(errorMsg); } finally { con.Close(); conQueue.Close(); GridEntries.DataBind(); } } else if (chkRl.SelectedValue == "True") { try { const string strQueueUpdate = "Update NewQueue set Status = @Status WHERE QueueID = @QueueID"; cmd.CommandType = CommandType.Text; cmd.CommandText = strQueueUpdate; cmd.Parameters.Clear(); //cmd.Parameters.AddWithValue("@CustCareApproval", ChkApp); cmd.Parameters.AddWithValue("@Status", "LODCLE"); //cmd.Parameters.AddWithValue("@StatusTime", cusTime); cmd.Parameters.AddWithValue("@QueueID", lblID.Text); cmd.Connection = conQueue; conQueue.Open(); cmd.ExecuteNonQuery(); } catch (SqlException ex) { var errorMsg = "Error in Updation"; errorMsg += ex.Message; throw new Exception(errorMsg); } finally { con.Close(); conQueue.Close(); } } checkAll(); }