public static DataSet AutoLoginGet()
{
SqlParameter[] dbParams = new SqlParameter[]
{
};
return(FDBHelper.ExecuteDataSet("usp_Data_FUsuario_Logged", dbParams));
}
public static DataSet GetAll()
{
SqlParameter[] dbParams = new SqlParameter[]
{
};
return(FDBHelper.ExecuteDataSet("usp_Data_FDetalleVenta_GetAll", dbParams));
}
public static System.Data.DataSet GetAll()
{
SqlParameter[] dbParams = new SqlParameter[]
{
};
return(FDBHelper.ExecuteDataSet("usp_Data_FCategoria_GetAll", dbParams));
}
public static DataSet GetNumeroDocumento()
{
SqlParameter[] dbParams = new SqlParameter[]
{
};
return(FDBHelper.ExecuteDataSet("usp_Data_FVenta_GetNumeroDocumento", dbParams));
}
public static int Eliminar(Categoria categoria)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Id", SqlDbType.Int, 0, categoria.Id)
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_FCategoria_Eliminar", dbParams)));
}
public static int Eliminar(DetalleVenta detalleVenta)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Id", SqlDbType.Int, 0, detalleVenta.Id),
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_FDetalleVenta_Eliminar", dbParams)));
}
public static DataSet GetAll(string sProdServ)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@ProdServ", SqlDbType.VarChar, 0, sProdServ),
};
return(FDBHelper.ExecuteDataSet("usp_Data_FProducto_GetAll", dbParams));
}
public static int Eliminar(Venta venta)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Id", SqlDbType.VarChar, 0, venta.Id)
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_Fventa_Eliminar", dbParams)));
}
public static int Eliminar(Producto producto)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Id", SqlDbType.Int, 0, producto.Id),
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_FProducto_Eliminar", dbParams)));
}
public static int VerificarNCF(string Ncf)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Ncf", SqlDbType.VarChar, 0, Ncf),
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_FUsuario_VerificarNCF", dbParams)));
}
public static DataSet GetAll(int ventaId)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@VentaId", SqlDbType.Int, 0, ventaId),
};
return(FDBHelper.ExecuteDataSet("usp_Data_FDetalleVenta_GetAll", dbParams));
}
public static int Eliminar(Cliente cliente)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Id", SqlDbType.Int, 0, cliente.Id),
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_FCliente_Eliminar", dbParams)));
}
public static int Insertar(Categoria categoria)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Descripcion", SqlDbType.VarChar, 0, categoria.Descripcion),
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_FCategoria_Insertar", dbParams)));
}
public static int BringUserID(string user)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Username", SqlDbType.VarChar, 0, user)
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_BringUserID", dbParams)));
}
internal static int aumentar_stock(Detalle_Venta dventa)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@ProductoId", SqlDbType.Int, 0, dventa.Producto.Id),
FDBHelper.MakeParam("@Cantidad", SqlDbType.Decimal, 0, dventa.Cantidad),
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_Fdetalle_venta_aumentar_stock", dbParams)));
}
public static int NotFavoriteAnymore(int noteID)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@NoteID", SqlDbType.Int, 0, noteID)
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_NotFavoriteAnymore", dbParams)));
}
public static DataSet ValidarLogin(string sUsuario, string sPassword)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Usuario", SqlDbType.VarChar, 0, sUsuario),
FDBHelper.MakeParam("@Password", SqlDbType.VarChar, 0, sPassword)
};
return(FDBHelper.ExecuteDataSet("usp_Data_FLogin_ValidarLogin", dbParams));
}
public static int Insertar(Venta venta)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@ClienteId", SqlDbType.Int, 0, venta.Cliente.Id),
FDBHelper.MakeParam("@FechaVenta", SqlDbType.Date, 0, venta.FechaVenta),
FDBHelper.MakeParam("@NumeroDocumento", SqlDbType.VarChar, 0, venta.NumeroDocumento)
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_FVenta_Insertar", dbParams)));
}
public static DataSet GetAllDeletedNotes(int UserID)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@UserID", SqlDbType.Int, 0, UserID)
};
// This will return the deleted notes (with all data they have).
return(FDBHelper.ExecuteDataSet("usp_Data_GetAllDeletedNotes", dbParams));
}
public static int AutoLoginSet(string sUsuario, string sPassword, int sLogged)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Usuario", SqlDbType.VarChar, 0, sUsuario),
FDBHelper.MakeParam("@Password", SqlDbType.VarChar, 0, sPassword),
FDBHelper.MakeParam("@Logged", SqlDbType.Int, 0, sLogged)
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_FUsuario_Logged_Actualizar", dbParams)));
}
public static DataSet LoadDeletedNotesByPage(int UserID, int pageNumber)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@UserID", SqlDbType.Int, 0, UserID),
FDBHelper.MakeParam("@ActualPage", SqlDbType.Int, 0, pageNumber)
};
return(FDBHelper.ExecuteDataSet("usp_Data_LoadDeletedNotesByPage", dbParams));
}
public static int CreateUser(string user, string password)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Username", SqlDbType.VarChar, 0, user),
FDBHelper.MakeParam("@Password", SqlDbType.VarChar, 0, password)
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_CreateUser", dbParams)));
}
//Este es el metodo para hacer el LOG
public static void Log(string usuario, string accion)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@usuario", SqlDbType.VarChar, 0, usuario),
FDBHelper.MakeParam("@fechaHora", SqlDbType.DateTime, 0, DateTime.Now),
FDBHelper.MakeParam("@accion", SqlDbType.VarChar, 0, accion)
};
FDBHelper.ExecuteDataSet("usp_Data_FLogin_LogLogin", dbParams);
}
public static int Insertar(Detalle_Venta detalle_venta)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@VentaId", SqlDbType.Int, 0, detalle_venta.Venta.Id),
FDBHelper.MakeParam("@ProductoID", SqlDbType.Int, 0, detalle_venta.Producto.Id),
FDBHelper.MakeParam("@Cantidad", SqlDbType.Decimal, 0, detalle_venta.Cantidad),
FDBHelper.MakeParam("@PrecioUnitario", SqlDbType.Decimal, 0, detalle_venta.Precio_unitario),
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_Fdetalle_venta_Insertar", dbParams)));
}
public static int Insertar(Cliente cliente)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Nombre", SqlDbType.VarChar, 0, cliente.Nombre),
FDBHelper.MakeParam("@Apellido", SqlDbType.VarChar, 0, cliente.Apellido),
FDBHelper.MakeParam("@Dni", SqlDbType.Int, 0, cliente.Dni),
FDBHelper.MakeParam("@Domicilio", SqlDbType.VarChar, 0, cliente.Domicilio),
FDBHelper.MakeParam("@Telefono", SqlDbType.VarChar, 0, cliente.Telefono)
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_Fclientes_Insertar", dbParams)));
}
public static int Actualizar(DetalleVenta detalleVenta)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Id", SqlDbType.Int, 0, detalleVenta.Id),
FDBHelper.MakeParam("@VentaId", SqlDbType.Int, 0, detalleVenta.Venta.Id),
FDBHelper.MakeParam("@ProductoId", SqlDbType.Date, 0, detalleVenta.Producto.Id),
FDBHelper.MakeParam("@Cantidad", SqlDbType.VarChar, 0, detalleVenta.Cantidad),
FDBHelper.MakeParam("@PrecioUnitario", SqlDbType.VarChar, 0, detalleVenta.PrecioUnitario),
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_FDetalleVenta_Actualizar", dbParams)));
}
public static int Insertar(DetalleVenta detalleVenta)
{
SqlParameter[] dbParams = new SqlParameter[]
{
//, , ,
FDBHelper.MakeParam("@VentaId", SqlDbType.Int, 0, detalleVenta.Venta.Id),
FDBHelper.MakeParam("@ProductoId", SqlDbType.Int, 0, detalleVenta.Producto.Id),
FDBHelper.MakeParam("@Cantidad", SqlDbType.Int, 0, detalleVenta.Cantidad),
FDBHelper.MakeParam("@PrecioUnitario", SqlDbType.Decimal, 0, detalleVenta.PrecioUnitario),
FDBHelper.MakeParam("@DescripcionVenta", SqlDbType.VarChar, 0, detalleVenta.DescripcionVenta)
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_FDetalleVenta_Insertar", dbParams)));
}
public static int ModifyNote(Note note)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@ID", SqlDbType.Int, 0, note.Id),
FDBHelper.MakeParam("@Title", SqlDbType.VarChar, 0, note.Title),
FDBHelper.MakeParam("@Category", SqlDbType.VarChar, 0, note.Category),
FDBHelper.MakeParam("@NoteDescription", SqlDbType.VarChar, 0, note.Description),
FDBHelper.MakeParam("@Importance", SqlDbType.VarChar, 0, note.Importance),
FDBHelper.MakeParam("@Favorite", SqlDbType.Int, 0, note.Favorite)
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_ModifyNote", dbParams)));
}
public static int Insertar(Producto producto)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@CategoriaId", SqlDbType.Int, 0, producto.Categoria.Id),
FDBHelper.MakeParam("@Nombre", SqlDbType.VarChar, 0, producto.Nombre),
FDBHelper.MakeParam("@Descripcion", SqlDbType.VarChar, 0, producto.Descripcion),
FDBHelper.MakeParam("@Stock", SqlDbType.Decimal, 0, producto.Stock),
FDBHelper.MakeParam("@PrecioCompra", SqlDbType.Decimal, 0, producto.PrecioCompra),
FDBHelper.MakeParam("@PrecioVenta", SqlDbType.Decimal, 0, producto.PrecioVenta),
FDBHelper.MakeParam("@FechaVencimiento", SqlDbType.Date, 0, producto.FechaVencimineto),
FDBHelper.MakeParam("@imagen", SqlDbType.Image, 0, producto.Imagen),
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_FProducto_Insertar", dbParams)));
}
public static int Insertar(Cliente cliente)
{
SqlParameter[] dbParams = new SqlParameter[]
{
FDBHelper.MakeParam("@Nombre", SqlDbType.VarChar, 0, cliente.Nombre),
FDBHelper.MakeParam("@Apellido", SqlDbType.VarChar, 0, cliente.Apellido),
FDBHelper.MakeParam("@Ncf", SqlDbType.VarChar, 0, cliente.Ncf),
FDBHelper.MakeParam("@Domicilio", SqlDbType.VarChar, 0, cliente.Domicilio),
FDBHelper.MakeParam("@Telefono", SqlDbType.VarChar, 0, cliente.Telefono),
FDBHelper.MakeParam("@TipoCliente", SqlDbType.VarChar, 0, cliente.TipoCliente),
FDBHelper.MakeParam("@RNC", SqlDbType.Int, 0, cliente.Rnc),
FDBHelper.MakeParam("@NoRSocial", SqlDbType.VarChar, 0, cliente.NoRSocial),
FDBHelper.MakeParam("@VencimientoSecuencia", SqlDbType.Date, 0, cliente.VencimientoSecuencia)
};
return(Convert.ToInt32(FDBHelper.ExecuteScalar("usp_Data_FCliente_Insertar", dbParams)));
}