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