public static int GetUltimoNumeroFactura(SqlTransaction transaction)
{
var sp = new StoreProcedure(DataBaseConst.Factura.SPGetUltimoNumeroFactura);
var numeroFactura = Convert.ToInt32(sp.ExecuteScalar(transaction));
return(numeroFactura);
}
public Rol InsertRol(Rol rol)
{
List <SPParameter> param = new List <SPParameter>();
param.Add(new SPParameter("rolName", rol.Name));
param.Add(new SPParameter("rolHabilitado", rol.Habilitado));
StoreProcedure sp = new StoreProcedure(DataBaseConst.Rol.SP_InsertRol, param);
rol.ID = (int)sp.ExecuteScalar();
return(rol);
}