private void LoadDayUnregistered()
{
DAYS dia = DaysDao.getDay(int.Parse(Request["Day"]));
if (dia != null)
{
int contador2 = 1;
int contador3 = 0;
//if (diaReported != null && diaReported.REPORT_DAY != null && diaReported.REPORT_DAY.Count > 0)
//{
// contador3 += diaReported.REPORT_DAY.Count;
// contador2 += diaReported.REPORT_DAY.Count;
//}
List <DAYS_CONFIG> listado = dia.DAYS_CONFIG.ToList();
if (contador2 <= listado.Count)
{
for (int i = contador3; i < listado.Count; i++)
{
Label lbl = (Label)FindControl("lblReport" + contador2);
lbl.Text = listado[i].name;
HtmlGenericControl divPanel = (HtmlGenericControl)FindControl("div" + contador2);
divPanel.Style.Remove("display");
DropDownList ddl = (DropDownList)FindControl("ddlDataTypeReport" + contador2);
ddl.Items.Insert(0, listado[i].dataType);
TextBox txt = (TextBox)FindControl("txtReport" + contador2);
switch (listado[i].dataType)
{
case "Time":
txt.CssClass = "validateTime";
break;
case "Integer":
txt.CssClass = "validateOnlyNumber";
txt.MaxLength = 4;
break;
case "Broken/Unbroken":
txt.CssClass = "validateOnlyBOrU";
txt.MaxLength = 1;
break;
}
contador2++;
}
}
int otroCont = 1;
for (int k = 0; k < listado.Count; k++)
{
Label lblDesc = (Label)FindControl("lblDescReport" + otroCont);
lblDesc.Text = listado[k].description;
otroCont++;
}
//foreach (DAYS_CONFIG confDay in dia.DAYS_CONFIG)
//{
//}
}
}
private void AvailableDays()
{
DiasActivos = DaysDao.getActiveDaysForReport();
foreach (DAYS dia in DiasActivos)
{
ddlDay.Items.Add(new ListItem("Day " + dia.Day.ToString(), dia.idDay.ToString()));
}
ddlDay.SelectedIndex = 0;
}
private void LoadAvailableDaysToReport()
{
List <DAYS> activedDays = DaysDao.getActiveDaysForReport();
if (activedDays != null)
{
int cont = 0;
foreach (DAYS activeDay in activedDays)
{
DateTime configuredDate = (DateTime)activeDay.completeDay;
ddlDay.Items.Insert(cont, new ListItem("Day " + activeDay.Day.ToString() + " " + CreateDateSuffix(configuredDate) + " of " + configuredDate.ToString("MMMM", new CultureInfo("en-US")), activeDay.idDay.ToString()));
cont++;
}
}
}
private void loadAvailableDays()
{
List <DAYS> getDays = DaysDao.getDays();
if (getDays != null)
{
int cont = 0;
foreach (DAYS dia in getDays)
{
DateTime configuredDate = (DateTime)dia.completeDay;
//ddlDay.Items.Insert(cont, new ListItem("Day " + dia.Day.ToString() + " " + CreateDateSuffix(configuredDate) + " of " + configuredDate.ToString("MMMM", new CultureInfo("en-US")), dia.Day.ToString()));
ddlDay.Items.Insert(cont, new ListItem("Day " + dia.Day.ToString() + " " + CreateDateSuffix(configuredDate) + " of " + configuredDate.ToString("MMMM", new CultureInfo("en-US")), dia.idDay.ToString()));
cont++;
}
ddlDay.Items.Insert(cont, new ListItem("Add new day...", "0"));
ddlDay.SelectedIndex = 0;
}
}
private void LoadDays()
{
List <DAYS> dias = DaysDao.getDays();
for (int i = 1; i <= 30; i++)
{
//if (dias != null && dias.Count > 0)
//{
// if ((from t in dias where ((int)t.Day) == i select t).FirstOrDefault() == null)
// {
ddlDayNew.Items.Add(i.ToString());
// }
//}
//else
//{
// ddlDayNew.Items.Add(i.ToString());
//}
}
}
private void LoadDayRegisteredToBeModified()
{
DAYS diaReported = DaysDao.getDay(int.Parse(Request["Day"]));
if (diaReported != null)
{
hdIdDayConfigured.Value = diaReported.idDay.ToString();
txtDateOfDay.Text = ((DateTime)diaReported.completeDay).ToString("dd/MM/yyyy");
ddlStateDay.SelectedValue = diaReported.state;
int cont = 1;
if (diaReported.DAYS_CONFIG != null && diaReported.DAYS_CONFIG.Count > 0)
{
foreach (DAYS_CONFIG confDay in diaReported.DAYS_CONFIG)
{
HiddenField hdField = (HiddenField)FindControl("hdReport" + cont);
hdField.Value = confDay.idReportNum.ToString();
CheckBox cbField = (CheckBox)FindControl("CheckBox" + cont);
cbField.Checked = true;
cbField.Enabled = false;
TextBox lbl = (TextBox)FindControl("txtReport" + cont);
lbl.Text = confDay.name;
DropDownList ddl = (DropDownList)FindControl("ddlDataTypeReport" + cont);
ddl.SelectedValue = confDay.dataType;
TextBox txtDesc = (TextBox)FindControl("txtDescription" + cont);
txtDesc.Text = confDay.description;
HtmlAnchor anchorDel = (HtmlAnchor)FindControl("anchorDelete" + cont);
anchorDel.Visible = true;
anchorDel.HRef = "javascript:DeleteExercise(" + confDay.idReportNum.ToString() + ");";
cont++;
}
}
}
}
public bool saveNewDay(int day, string date, string state)
{
return(DaysDao.saveNewDay(day, date, state));
}
public bool SaveConfigDay(int day, int idDay, string date, string state, List <int> idDiasConfigurados, List <string> names, List <string> dataTypes, List <string> descriptions)
{
return(DaysDao.SaveConfigForDay(day, idDay, date, state, idDiasConfigurados.ToArray(), names.ToArray(), dataTypes.ToArray(), descriptions.ToArray()));
}
public bool SaveInform(int idUser, int day, int idRegister, List <int> idReportedDays, List <string> names, List <string> dataTypes, List <string> inform)
{
return(DaysDao.SaveInform(idUser, day, idRegister, idReportedDays.ToArray(), names.ToArray(), dataTypes.ToArray(), inform.ToArray()));
}
public bool DeleteExercise(int idExercise)
{
return(DaysDao.DeleteExercise(idExercise));
}
private void ArmarTable()
{
//DAYS excerciseForDay = DaysDao.getDay(int.Parse(ddlDay.SelectedValue));
DAYS excerciseForDay = DaysDao.getDay(1);
if (Users != null)
{
DataTable tabla = new DataTable("Usuarios");
DataColumn dtColumnIdUser = new DataColumn("idUser");
tabla.Columns.Add(dtColumnIdUser);
DataColumn dtName = new DataColumn("name");
tabla.Columns.Add(dtName);
DataColumn dtAge = new DataColumn("age");
tabla.Columns.Add(dtAge);
DataColumn dtGender = new DataColumn("gender");
tabla.Columns.Add(dtGender);
DataColumn dtNationality = new DataColumn("nationality");
tabla.Columns.Add(dtNationality);
DataColumn dtEmail = new DataColumn("email");
tabla.Columns.Add(dtEmail);
DataColumn dtPass = new DataColumn("pass");
tabla.Columns.Add(dtPass);
DataColumn dtHades = new DataColumn("hades_pb");
tabla.Columns.Add(dtHades);
DataColumn dtPoseidon = new DataColumn("poseidon_pb");
tabla.Columns.Add(dtPoseidon);
DataColumn dtVenus = new DataColumn("venus_pb");
tabla.Columns.Add(dtVenus);
if (excerciseForDay != null && excerciseForDay.DAYS_CONFIG != null && excerciseForDay.DAYS_CONFIG.Count > 0)
{
List <DAYS_CONFIG> excer = excerciseForDay.DAYS_CONFIG.ToList();
for (int i = 0; i < excer.Count; i++)
{
DataColumn column = new DataColumn(excer[i].name + " " + excer[i].dataType);
BoundField columna = new BoundField();
columna.DataField = excer[i].name + " " + excer[i].dataType;
columna.HeaderText = excer[i].name + " " + excer[i].dataType;
columna.SortExpression = excer[i].name + " " + excer[i].dataType;
gvUsuarios.Columns.Add(columna);
tabla.Columns.Add(column);
}
}
for (int j = 0; j < Users.Count; j++)
{
DataRow dw = tabla.NewRow();
dw.SetField("idUser", Users[j].idUser);
dw.SetField("name", Users[j].name);
dw.SetField("age", Users[j].age);
dw.SetField("gender", Users[j].gender);
dw.SetField("nationality", Users[j].nationality);
dw.SetField("email", Users[j].email);
dw.SetField("pass", Users[j].pass);
dw.SetField("hades_pb", Users[j].hades_pb);
dw.SetField("poseidon_pb", Users[j].poseidon_pb);
dw.SetField("venus_pb", Users[j].venus_pb);
//if (Users[j].DAYS_REPORT != null && Users[j].DAYS_REPORT.Count > 0)
//{
DAYS_REPORT diaSolicitado = UserDao.getDiaReportado(Users[j].idUser, 1);
if (diaSolicitado != null)
{
List <REPORT_DAY> diasReportados = DaysDao.getDiasReportados(diaSolicitado.idRegister);
for (int i = 0; i < diasReportados.Count; i++)
{
dw.SetField(diasReportados[i].Name + " " + diasReportados[i].DataInform, diasReportados[i].Inform);
}
}
//}
tabla.Rows.Add(dw);
}
//TablaUsuarios = tabla;
//gvUsuarios.DataSource = TablaUsuarios;
//gvUsuarios.DataBind();
}
}
private void LoadDayRegisteredToBeModified()
{
diaReported = DaysDao.getReportedDayByUser(LoggedUser.idUser, int.Parse(Request["Day"]));
if (diaReported != null)
{
hdIdDayReported.Value = diaReported.idRegister.ToString();
int cont = 1;
foreach (REPORT_DAY confDay in diaReported.REPORT_DAY)
{
if (confDay != null && confDay.Name != null)
{
if (confDay.Name == lblReport1.Text && confDay.DataInform == ddlDataTypeReport1.SelectedValue)
{
cont = 1;
}
if (confDay.Name == lblReport2.Text && confDay.DataInform == ddlDataTypeReport2.SelectedValue)
{
cont = 2;
}
if (confDay.Name == lblReport3.Text && confDay.DataInform == ddlDataTypeReport3.SelectedValue)
{
cont = 3;
}
if (confDay.Name == lblReport4.Text && confDay.DataInform == ddlDataTypeReport4.SelectedValue)
{
cont = 4;
}
if (confDay.Name == lblReport5.Text && confDay.DataInform == ddlDataTypeReport5.SelectedValue)
{
cont = 5;
}
if (confDay.Name == lblReport6.Text && confDay.DataInform == ddlDataTypeReport6.SelectedValue)
{
cont = 6;
}
if (confDay.Name == lblReport7.Text && confDay.DataInform == ddlDataTypeReport7.SelectedValue)
{
cont = 7;
}
if (confDay.Name == lblReport8.Text && confDay.DataInform == ddlDataTypeReport8.SelectedValue)
{
cont = 8;
}
if (confDay.Name == lblReport9.Text && confDay.DataInform == ddlDataTypeReport9.SelectedValue)
{
cont = 9;
}
if (confDay.Name == lblReport10.Text && confDay.DataInform == ddlDataTypeReport10.SelectedValue)
{
cont = 10;
}
}
HtmlGenericControl divPanel = (HtmlGenericControl)FindControl("div" + cont);
divPanel.Style.Remove("display");
HiddenField hdField = (HiddenField)FindControl("hdReport" + cont);
hdField.Value = confDay.idReportDay.ToString();
Label lbl = (Label)FindControl("lblReport" + cont);
lbl.Text = confDay.Name;
DropDownList ddl = (DropDownList)FindControl("ddlDataTypeReport" + cont);
ddl.Items.Insert(0, confDay.DataInform);
TextBox txt = (TextBox)FindControl("txtReport" + cont);
txt.Text = confDay.Inform;
switch (confDay.DataInform)
{
case "Time":
txt.CssClass = "validateTime";
break;
case "Integer":
txt.MaxLength = 4;
txt.CssClass = "validateOnlyNumber";
break;
case "Broken/Unbroken":
txt.CssClass = "validateOnlyBOrU";
txt.MaxLength = 1;
break;
}
//cont++;
}
}
}
