protected void btnCrearCola_Click(object sender, EventArgs e) { try { QueueOperations queue = new QueueOperations(rblMora.SelectedItem != null ? true : false, cbScoring.Checked, txtContadormora.Text.Trim() != String.Empty ? true : false, cbMontoFinanciado.Checked, cbMontoVencido.Checked, ddlUltimoEstatusRegistrado.SelectedItem.Value != "0" ? true : false, cbPromesaPagoRota.Checked, rblTipoFinanciamiento.SelectedItem != null ? true : false, rblCreditoSimple.SelectedItem != null ? true : false, rblArrendamiento.SelectedItem != null ? true : false); queue.SaveQueueU(txtNombreCola.Text.Trim(), rblMora.SelectedItem != null ? rblMora.SelectedItem.Value : String.Empty, txtContadormora.Text.Trim(), ddlUltimoEstatusRegistrado.SelectedItem.Value != "0" ? ddlUltimoEstatusRegistrado.SelectedItem.Text : String.Empty , rblTipoFinanciamiento.SelectedItem != null ? rblTipoFinanciamiento.SelectedItem.Value : String.Empty , rblCreditoSimple.SelectedItem != null ? rblCreditoSimple.SelectedItem.Value : String.Empty, rblArrendamiento.SelectedItem != null ? rblArrendamiento.SelectedItem.Value : String.Empty); ClearQueueData(); FillQueueUsersGrid(); lblMensajeColasTrabajo.Text = "Cola creada correctamente"; lblMensajeColasTrabajo.CssClass = "successfully"; lblMensajeColasTrabajo.Visible = true; } catch (Exception ex) { lblMensajeColasTrabajo.Text = "Ha occurrido un error. Póngase en contacto con el administrador"; lblMensajeColasTrabajo.CssClass = "error"; lblMensajeColasTrabajo.Visible = true; } }
protected void ddlQueues_SelectedIndexChanged(object sender, EventArgs e) { try { DropDownList ddl = (DropDownList)sender; GridViewRow row = (GridViewRow)ddl.Parent.Parent; String userName = HttpUtility.HtmlDecode(row.Cells[1].Text); String pkUser = new User(userName).GetID(); String pkQueue = ddl.SelectedItem.Value; QueueOperations qo = new QueueOperations(Convert.ToInt32(pkUser), Convert.ToInt32(pkQueue)); qo.SaveQueueByUser(); } catch (Exception ex) { throw ex; } }
public DataTable GetFirstPaymentByUser(String userID) { try { DataBaseSettings db = new DataBaseSettings(); String finalQuery = queryGet + QueueOperations.GetQueueConditionsByUsers(userID); //if (finalQuery.Contains("ORDER BY")) //{ // finalQuery += String.Format(", EnCola"); //} //else //{ // finalQuery += String.Format("ORDER BY EnCola"); //} return(db.GetDataTable(finalQuery)); } catch (Exception ex) { throw ex; } }
private void FillQueueUsersGrid() { gvQueueUsers.DataSource = QueueOperations.GetQueueByUsers(); gvQueueUsers.DataBind(); }