/// <summary>
/// Guarda el calculo del muscular del cliente
/// </summary>
/// <param name="client"></param>
/// <param name="pliegueTricipal"></param>
/// <param name="pliegueEscapular"></param>
/// <param name="trigliceridos"></param>
/// <param name="Colesterol"></param>
/// <param name="Glucosa"></param>
/// <param name="frecuenciaCardiaca"></param>
/// <param name="frecuanciArtSisfolica"></param>
/// <param name="frecuanciArtDiasfolica"></param>
/// <param name="porcentajeCargaPecho"></param>
/// <param name="porcentajeCargaPierna"></param>
/// <param name="metabolismoBasal"></param>
/// <returns></returns>
public JsonResult saveMuscularCal(int client, decimal pliegueTricipal,
decimal pliegueEscapular, decimal trigliceridos, decimal Colesterol, decimal Glucosa,
decimal frecuenciaCardiaca, decimal frecuanciArtSisfolica, decimal frecuanciArtDiasfolica,
decimal porcentajeCargaPecho, decimal porcentajeCargaPierna, decimal metabolismoBasal)
{
try
{
TblRecordTicket recordTicketData = new TblRecordTicket();
recordTicketData.id_socio = client;
recordTicketData.pliegueTricipal = pliegueTricipal;
recordTicketData.pliegueEscapular = pliegueEscapular;
recordTicketData.trigliceridos = trigliceridos;
recordTicketData.Colesterol = Colesterol;
recordTicketData.Glucosa = Glucosa;
recordTicketData.frecuenciaCardiaca = frecuenciaCardiaca;
recordTicketData.frecuanciArtSisfolica = frecuanciArtSisfolica;
recordTicketData.frecuanciArtDiasfolica = frecuanciArtDiasfolica;
recordTicketData.porcentajeCargaPecho = porcentajeCargaPecho;
recordTicketData.porcentajeCargaPierna = porcentajeCargaPierna;
recordTicketData.metabolismoBasal = metabolismoBasal;
int result = clientRules.SaveRecordClientTicket(recordTicketData);
return(Json(result));
}
catch (Exception ex)
{
return(Json(ex));
}
}
public int SaveRecordClientTicket(TblRecordTicket clientTicket)
{
int result = -1;
string nameStoredProcedure = "add_HistorialTicketSocio";
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnStringSSW"].ConnectionString);
SqlCommand cmd = new SqlCommand(nameStoredProcedure, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@id_socio", clientTicket.id_socio));
cmd.Parameters.Add(new SqlParameter("@pliegueTricipal", clientTicket.pliegueTricipal));
cmd.Parameters.Add(new SqlParameter("@pliegueEscapular", clientTicket.pliegueEscapular));
cmd.Parameters.Add(new SqlParameter("@trigliceridos", clientTicket.trigliceridos));
cmd.Parameters.Add(new SqlParameter("@Colesterol", clientTicket.Colesterol));
cmd.Parameters.Add(new SqlParameter("@Glucosa", clientTicket.Glucosa));
cmd.Parameters.Add(new SqlParameter("@frecuenciaCardiaca", clientTicket.frecuenciaCardiaca));
cmd.Parameters.Add(new SqlParameter("@frecuanciArtSisfolica", clientTicket.frecuanciArtSisfolica));
cmd.Parameters.Add(new SqlParameter("@frecuanciArtDiasfolica", clientTicket.frecuanciArtDiasfolica));
cmd.Parameters.Add(new SqlParameter("@porcentajeCargaPecho", clientTicket.porcentajeCargaPecho));
cmd.Parameters.Add(new SqlParameter("@porcentajeCargaPierna", clientTicket.porcentajeCargaPierna));
cmd.Parameters.Add(new SqlParameter("@metabolismoBasal", clientTicket.metabolismoBasal));
conn.Open();
result = cmd.ExecuteNonQuery();
conn.Close();
return(result);
}
/// <summary>
/// Guarda el ticket 2 para control del usuario.
/// </summary>
/// <param name="complete"></param>
/// <param name="numSocio"></param>
/// <param name="nombreCompleto"></param>
/// <param name="entrenador"></param>
/// <param name="registro"></param>
/// <returns></returns>
public Boolean printTicketClientRecord(bool complete, String numSocio, String nombreCompleto, String entrenador, TblRecordTicket registro)
{
String lineComplete = " " + "***** PORCENTAJE CARGA ****** " + Environment.NewLine +
" " + "*" + "Pecho: " + registro.porcentajeCargaPecho + Environment.NewLine +
" " + "*" + "Pierna: " + registro.porcentajeCargaPierna + Environment.NewLine +
" " + Environment.NewLine +
" " + "***** METABOLISMO ****** " + Environment.NewLine +
" " + "*" + "Basal: " + registro.metabolismoBasal +
" " + Environment.NewLine;
String lines = "WELLNESS LAB EN FORMA" + "" + Environment.NewLine +
"EXPEDIDO EN:" + Environment.NewLine +
"CALLE ODONTOLOGÍA NO. 13" + Environment.NewLine +
"LOC. 1 COLONIA SPUAZ" + Environment.NewLine +
"MEXICO, GPE. ZACATECAS" + Environment.NewLine +
" " + Environment.NewLine +
" " + "***** DATOS SOCIO ****** " + Environment.NewLine +
"Socio: " + numSocio + " " + nombreCompleto + " " + Environment.NewLine +
"Fecha de revisión: " + DateTime.Now.ToShortDateString() + "" + Environment.NewLine +
" " + Environment.NewLine +
" " + "***** INICIALES ****** " + Environment.NewLine +
" " + "*" + "Trigliceridos: " + registro.trigliceridos + Environment.NewLine +
" " + "*" + "Colesterol: " + registro.Colesterol + Environment.NewLine +
" " + "*" + "Glucosa: " + registro.Glucosa + Environment.NewLine +
" " + Environment.NewLine +
" " + "***** PLIEGUES ****** " + Environment.NewLine +
" " + "*" + "Tricipal: " + registro.pliegueTricipal + Environment.NewLine +
" " + "*" + "Escapular: " + registro.pliegueEscapular + Environment.NewLine +
" " + Environment.NewLine +
" " + "***** Presión ****** " + Environment.NewLine +
" " + "*" + "Cardiaca: " + registro.frecuenciaCardiaca + Environment.NewLine +
" " + "*" + "Arterial Sisfolica: " + registro.frecuanciArtSisfolica + Environment.NewLine +
" " + "*" + "Arterial Diasfolica: " + registro.frecuanciArtDiasfolica + Environment.NewLine +
" " + Environment.NewLine +
(complete ? lineComplete : "") +
" " + Environment.NewLine +
" " + "***** REGISTRADO POR ****** " + Environment.NewLine +
"ENTRENADOR: " + entrenador + Environment.NewLine +
" " + Environment.NewLine +
" " + "TU SALUD ES NUESTRA PASION..." + " " + Environment.NewLine +
"VIVE LA EXPERIENCIA WELLNESS LAB EN FORMA" + " " + Environment.NewLine +
"GRACIAS POR SU PREFERENCIA" + " ";
return(saveTicket(lines.ToString(), @"\Ticket_Progreso_Registro_" + (complete ? "_Completo_":"_Parcial_") + numSocio + "_Socio_ " + nombreCompleto + "_" + DateTime.Now.ToLongDateString() + ".txt"));
}
/// <summary>
/// Guarda el ticket 2 para control del usuario.
/// </summary>
/// <param name="complete"></param>
/// <param name="numSocio"></param>
/// <param name="nombreCompleto"></param>
/// <param name="entrenador"></param>
/// <param name="registro"></param>
/// <returns></returns>
public String descriptionProgressRecord(bool complete, String numSocio, String nombreCompleto, String entrenador, TblRecordTicket registro)
{
String lineComplete = " " + "***** PORCENTAJE CARGA ****** " + "<br>" +
" " + "*" + "Pecho: " + registro.porcentajeCargaPecho + "<br>" +
" " + "*" + "Pierna: " + registro.porcentajeCargaPierna + "<br>" +
" " + "<br>" +
" " + "***** METABOLISMO ****** " + "<br>" +
" " + "*" + "Basal: " + registro.metabolismoBasal;
String lines = "WELLNESS LAB EN FORMA" + "" + "\n" +
"EXPEDIDO EN:" + "<br />" + "\n" +
"CALLE ODONTOLOGÍA NO. 13 LOC. 1 COLONIA SPUAZ" + "" + "\n" +
"MEXICO, GPE. ZACATECAS" + "\n" +
" " + "<br>" +
"Socio: " + numSocio + " " + nombreCompleto + " " + "<br>" +
"Fecha de revisión: " + DateTime.Now.ToShortDateString() + "" + "<br>" +
" " + "***** INICIALES ****** " + "<br>" +
" " + "*" + "Trigliceridos: " + registro.trigliceridos + "<br>" +
" " + "*" + "Colesterol: " + registro.Colesterol + "<br>" +
" " + "*" + "Glucosa: " + registro.Glucosa + "<br>" +
" " + "<br>" +
" " + "***** PLIEGUES ****** " + "<br>" +
" " + "*" + "Tricipal: " + registro.pliegueTricipal + "<br>" +
" " + "*" + "Escapular: " + registro.pliegueEscapular + "<br>" +
" " + "<br>" +
" " + "***** Presión ****** " + "<br>" +
" " + "*" + "Cardiaca: " + registro.frecuenciaCardiaca + "<br>" +
" " + "*" + "Arterial Sisfolica: " + registro.frecuanciArtSisfolica + "<br>" +
" " + "*" + "Arterial Diasfolica: " + registro.frecuanciArtDiasfolica + "<br>" +
" " + "<br>" +
(complete ? lineComplete : "") +
" " + "*" + "<br>" +
" " + " " + "<br>" +
" " + "TU SALUD ES NUESTRA PASION..." + " " + "<br>" +
"VIVE LA EXPERIENCIA WELLNESS LAB EN FORMA" + " " + "<br>" +
"GRACIAS POR SU PREFERENCIA" + " ";
return(lines);
}
public int SaveRecordClientTicket(TblRecordTicket clientTicket)
{
ClientRecordTicketDAO clients = new ClientRecordTicketDAO();
return(clients.SaveRecordClientTicket(clientTicket));
}
