public DtoCPago VerCPago(int idcomprobante)
{
DataTable dtDatos = null;
conexion.Open();
SqlCommand command = new SqlCommand("sp_VerCPagos", conexion);
command.Parameters.AddWithValue("@ID", idcomprobante);
SqlDataAdapter daAdaptador = new SqlDataAdapter(command);
command.CommandType = CommandType.StoredProcedure;
dtDatos = new DataTable();
daAdaptador.Fill(dtDatos);
var model = new DtoCPago();
var xd = dtDatos.Rows[0].ItemArray;
var obj = xd[0];
model.IMC_Imagen = Convert.ToBase64String(ObjectToByteArray(xd[0]));
model.DCP_Monto = Convert.ToDouble(xd[1]);
model.VCP_NOperacion = xd[2].ToString();
model.ICP_NFisio = Convert.ToInt32(xd[3].ToString());
model.ICP_NNutri = Convert.ToInt32(xd[4].ToString());
conexion.Close();
return(model);
}
public void llenarDatos()
{
int codP = Convert.ToInt32(Session["id"].ToString());
DTOCP = CTRCP.verComprobanteP(codP);
txt_monto1.Text = DTOCP.DCP_Monto.ToString();
txt_noperacion1.Text = DTOCP.VCP_NOperacion.ToString();
txt_nnutri1.Text = DTOCP.ICP_NFisio.ToString();
txt_nfisio1.Text = DTOCP.ICP_NNutri.ToString();
}
public void llenarDatos()
{
int codP = Convert.ToInt32(Session["idcomp"]);
objDTOCP = objCTRCP.verComprobanteP(codP);
txt_monto.Text = objDTOCP.DCP_Monto.ToString();
txt_operaciones.Text = objDTOCP.VCP_NOperacion.ToString();
txt_n_cita_fisio.Text = objDTOCP.ICP_NFisio.ToString();
txt_n_cita_nutri.Text = objDTOCP.ICP_NNutri.ToString();
}
public void RegistrarComprobantePago(DtoCPago ObjDTOCP, string imag)
{
SqlCommand command = new SqlCommand("sp_RegistrarComprobantePago", conexion);
command.CommandType = CommandType.StoredProcedure;
//command.Parameters.AddWithValue("@CodigoCita", cita.IC_Cod);command.Parameters.AddWithValue("@FechaHoraSolicitadaCita", ObjDtoCita.DC_FechaHoraSolicitada);
command.Parameters.AddWithValue("@Imagen", imag);
command.Parameters.AddWithValue("@Noperaciones", ObjDTOCP.VCP_NOperacion);
command.Parameters.AddWithValue("@NFisio", ObjDTOCP.ICP_NFisio);
command.Parameters.AddWithValue("@NNutri", ObjDTOCP.ICP_NNutri);
command.Parameters.AddWithValue("@Monto", ObjDTOCP.DCP_Monto);
command.Parameters.AddWithValue("@CodigoUsuarioDNI", ObjDTOCP.FK_CU_Dni);
conexion.Open();
command.ExecuteNonQuery();
conexion.Close();
}
public void ActualizarRegistrarPago(DtoCPago ObjDTOCP)
{
SqlCommand command = new SqlCommand("sp_ActualizarPago", conexion);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Cod_P", ObjDTOCP.PK_ICP_Cod);
//command.Parameters.AddWithValue("@Imagen", ObjDTOCP.IMC_Imagen);
command.Parameters.AddWithValue("@Noperaciones", ObjDTOCP.VCP_NOperacion);
command.Parameters.AddWithValue("@NFisio", ObjDTOCP.ICP_NFisio);
command.Parameters.AddWithValue("@NNutri", ObjDTOCP.ICP_NNutri);
command.Parameters.AddWithValue("@Monto", ObjDTOCP.DCP_Monto);
conexion.Open();
command.ExecuteNonQuery();
conexion.Close();
}
public Boolean VERPAGO(DtoCPago objtu)
{
Boolean hayproducto = true;
string select = "select * from T_Comprobante_Pago where PK_ICP_Cod = " + objtu.PK_ICP_Cod;
SqlCommand Comando = new SqlCommand(select, conexion);
conexion.Close();
conexion.Open();
SqlDataReader reader = Comando.ExecuteReader();
if (reader.Read())
{
if (reader[2] != DBNull.Value)
{
objtu.VCP_NOperacion = (string)reader[2];
}
else
{
objtu.VCP_NOperacion = "";
}
if (reader[3] != DBNull.Value)
{
objtu.ICP_NFisio = (int)reader[3];
}
else
{
objtu.ICP_NFisio = 0;
}
if (reader[4] != DBNull.Value)
{
objtu.ICP_NNutri = (int)reader[4];
}
else
{
objtu.ICP_NNutri = 0;
}
if (reader[6] != DBNull.Value)
{
objtu.DCP_Monto = (double)reader[6];
}
else
{
objtu.DCP_Monto = 0;
}
//if (reader[5] != DBNull.Value)
//{ objtu.precioUnitario = (int)reader[5]; }
//else
//{ objtu.precioUnitario = 0; }
//if (reader[6] != DBNull.Value)
//{ objtu.valorVenta = (int)reader[6]; }
//else
//{ objtu.valorVenta = 0; }
//if (reader[7] != DBNull.Value)
//{ objtu.cantidad = (int)reader[7]; }
//else
//{ objtu.cantidad = 0; }
//if (reader[8] != DBNull.Value)
//{ objtu.fk_codInventario = (int)reader[8]; }
//else
//{ objtu.fk_codInventario = 0; }
objtu.estado = 99;
}
else
{
hayproducto = false;
objtu.estado = 1;
}
conexion.Close();
return(hayproducto);
}
public void ActualizarComprobante_Pago(DtoCPago objDTOCP)
{
objDaoCPago.ActualizarRegistrarPago(objDTOCP);
}
public void RegistrarComprobante_Pago(DtoCPago objDTOCP, string imag)
{
objDaoCPago.RegistrarComprobantePago(objDTOCP, imag);
}
public void VERPAGO(DtoCPago objusu)
{
objDaoCPago.VERPAGO(objusu);
}
