public static List <ModelMilkoScan> Llenargrid()
{
var lista = new List <ModelMilkoScan>();
var connec = ConexionMySql.ObtenerConexion();
var comando = new MySqlCommand("SELECT * FROM milkoscan", connec);
var reader = comando.ExecuteReader();
while (reader.Read())
{
var pModelMilkoScan = new ModelMilkoScan
{
Id = reader.GetInt32(0),
Identificacion = reader.GetString(1),
Rep = reader.GetInt32(2),
Grasa = reader.GetDouble(3),
Proteina = reader.GetDouble(17),
Sng = reader.GetDouble(4),
St = reader.GetDouble(5),
Lactosa = reader.GetDouble(6),
Caseina = reader.GetDouble(7),
Urea = reader.GetDouble(8),
Densidad = reader.GetDouble(9),
Ph = reader.GetDouble(10),
Acidez = reader.GetDouble(11),
Crioscopia = reader.GetDouble(12),
Ffa = reader.GetDouble(13),
Fecha = reader.GetString(14),
ProtCaseina = reader.GetDouble(15),
ProtSuero = reader.GetDouble(16)
};
lista.Add(pModelMilkoScan);
}
return(lista);
}
public static ModelMilkoScan ObtenerMilko(int pIdMilko)
{
var pMs = new ModelMilkoScan();
var connec = ConexionMySql.ObtenerConexion();
var comando = new MySqlCommand($"SELECT * FROM milkoscan WHERE ID ='{pIdMilko}'", connec);
var reader = comando.ExecuteReader();
while (reader.Read())
{
MilkoScanSelect.Id = reader.GetInt32(0);
MilkoScanSelect.Identificacion = reader.GetString(1);
MilkoScanSelect.Rep = reader.GetInt32(2);
MilkoScanSelect.Grasa = reader.GetDouble(3);
MilkoScanSelect.Proteina = reader.GetDouble(17);
MilkoScanSelect.Sng = reader.GetDouble(4);
MilkoScanSelect.St = reader.GetDouble(5);
MilkoScanSelect.Lactosa = reader.GetDouble(6);
MilkoScanSelect.Caseina = reader.GetDouble(7);
MilkoScanSelect.Urea = reader.GetDouble(8);
MilkoScanSelect.Densidad = reader.GetDouble(9);
MilkoScanSelect.Ph = reader.GetDouble(10);
MilkoScanSelect.Acidez = reader.GetDouble(11);
MilkoScanSelect.Crioscopia = reader.GetDouble(12);
MilkoScanSelect.Ffa = reader.GetDouble(13);
MilkoScanSelect.Fecha = reader.GetString(14);
MilkoScanSelect.ProtCaseina = reader.GetDouble(15);
MilkoScanSelect.ProtSuero = reader.GetDouble(16);
}
connec.Close();
return(pMs);
}
public static int Agregar(ModelMilkoScan pMs)
{
var connec = ConexionMySql.ObtenerConexion();
var comando =
new MySqlCommand(
$"CALL SPMilkoScan('{pMs.Identificacion}','{pMs.Rep}','{pMs.Grasa}','{pMs.Sng}','{pMs.St}','{pMs.Lactosa}','{pMs.Caseina}','{pMs.Urea}','{pMs.Densidad}','{pMs.Ph}','{pMs.Acidez}','{pMs.Crioscopia}','{pMs.Ffa}','{pMs.Fecha}','{pMs.ProtCaseina}','{pMs.ProtSuero}','{pMs.Proteina}')",
connec);
var retorno = comando.ExecuteNonQuery();
return(retorno);
}
public static int Actualizar(ModelMilkoScan pModelMilko, int pAcMilko)
{
var retorno = 0;
var conexion = ConexionMySql.ObtenerConexion();
MySqlCommand comando;
{
//actualizar los datos del milko
comando = new MySqlCommand($"UPDATE milkoscan SET Identificacion = '{pModelMilko.Identificacion}', REP = '{pModelMilko.Rep}', Grasa = '{pModelMilko.Grasa}', SNG ='{pModelMilko.Sng}', ST = '{pModelMilko.St}', Lactosa = '{pModelMilko.Lactosa}', Caseina = '{pModelMilko.Caseina}', Urea = '{pModelMilko.Urea}', Densidad = '{pModelMilko.Densidad}', pH = '{pModelMilko.Ph}', Acidez = '{pModelMilko.Acidez}', Crioscopia = '{pModelMilko.Crioscopia}', FFA = '{pModelMilko.Ffa}', Fecha = '{pModelMilko.Fecha}', ProteinaC = '{pModelMilko.ProtCaseina}', ProteinaS = '{pModelMilko.ProtSuero}', Proteina = '{pModelMilko.Proteina}' WHERE ID = '{pModelMilko.Id}'", conexion);
retorno = comando.ExecuteNonQuery();
}
return(retorno);
}