public DataTable SaveProductMaster(ProductMasterModel model)
{
DataTable dt = new DataTable();
SqlParameter[] arrproc;
string spName = "SaveProductMaster";
arrproc = new SqlParameter[16];
arrproc[0] = new SqlParameter("@ProductCategoryId", model.ProductCategoryId);
arrproc[1] = new SqlParameter("@ProductSubCategoryId", model.ProductSubCategoryId);
arrproc[2] = new SqlParameter("@ProductCode", model.ProductCode);
arrproc[3] = new SqlParameter("@ProductName", model.ProductName);
arrproc[4] = new SqlParameter("@ProductDescription", model.ProductDescription);
arrproc[5] = new SqlParameter("@ProductCompanyId", model.ProductCompanyId);
arrproc[6] = new SqlParameter("@Packing", model.Packing);
arrproc[7] = new SqlParameter("@PurchaseUnitId", model.PurchaseUnitId);
arrproc[8] = new SqlParameter("@SalesUnitId", model.SalesUnitId);
arrproc[9] = new SqlParameter("@PuchaseTaxId", model.PuchaseTaxId);
arrproc[10] = new SqlParameter("@SaleTaxId", model.SaleTaxId);
arrproc[11] = new SqlParameter("@TaxAplicability", model.TaxAplicability);
arrproc[12] = new SqlParameter("@HSNCode", model.HSNCode);
arrproc[13] = new SqlParameter("@SACCode", model.SACCode);
arrproc[14] = new SqlParameter("@IsActive", model.IsActive);
arrproc[15] = new SqlParameter("@CreatedBy", model.UserId);
ADOContext _dbContext = new ADOContext();
dt = _dbContext.ExecSQLProc(spName, arrproc);
return(dt);
}
public BookRepository()
{
_dataBase = MockDataProvider.Instance;
string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
_context = new ADOContext(connectionString);
}
public void TesteSabor()
{
Recordset rs = ADOContext.MyExecute("SELECT id_sabor_id,ativo,valor_adicional,nome,recheio,categoria_id FROM sabores ");
var myClass = new Sabores().BindClass(ref rs);
Assert.IsNotNull(myClass.id_sabor_id);
}
public static DataTable GetUserData(int ModuleID)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ModuleID", ModuleID);
ADOContext dut = new ADOContext();
DataTable dtdata = new DataTable();
dtdata = dut.ExecSQLProc("USP_GETCategoryDropDown", param);
return(dtdata);
}
public void BindData()
{
Recordset rs = ADOContext.MyExecute("select 1 as number1,2 as number2,3 as number3");
var myClass = new Numbers().BindClass(ref rs);
Assert.IsNotNull(myClass.number1);
Assert.IsNotNull(myClass.number2);
Assert.IsNotNull(myClass.number3);
}
public void BindList()
{
Recordset rs = ADOContext.MyExecute("SELECT * FROM armazem");
var myClass = new TestClass().BindClass(ref rs);
Assert.IsNotNull(myClass.idArmazem);
Assert.IsNotNull(myClass.Nome);
Assert.IsNotNull(myClass.Status);
Assert.IsNull(myClass.CampoExtra);
}
public DataTable GetProductMaster(ProductMasterModel model)
{
DataTable dt = new DataTable();
SqlParameter[] arrproc;
string spName = "GetProductMaster";
ADOContext _dbContext = new ADOContext();
arrproc = new SqlParameter[7];
arrproc[0] = new SqlParameter("@PageNumber", model.PageNumber);
arrproc[1] = new SqlParameter("@RecordSize", model.RecordSize);
arrproc[2] = new SqlParameter("@ProductCategoryId", model.ProductCategoryId);
arrproc[3] = new SqlParameter("@ProductSubCategoryId", model.ProductSubCategoryId);
arrproc[4] = new SqlParameter("@ProductCode", model.ProductCode);
arrproc[5] = new SqlParameter("@ProductName", model.ProductName);
arrproc[6] = new SqlParameter("@ProductCompanyId", model.ProductCompanyId);
dt = _dbContext.ExecSQLProc(spName, arrproc);
return(dt);
}
public void TesteTabela()
{
Recordset rs = ADOContext.MyExecute("SELECT * FROM custom_rede_credenciada c WHERE c.ST_REGISTRO = 'G' AND c.ID_EMPRESA = 1 AND c.ID_CUSTOM_REDE_CREDENCIADA_ID = 3");
rs = ADOContext.MyExecute("SELECT * FROM custom_rede_credenciada c WHERE c.ST_REGISTRO = 'G' AND c.ID_EMPRESA = 1 AND c.ID_CUSTOM_REDE_CREDENCIADA_ID = 3");
rs = ADOContext.MyExecute("SELECT * FROM custom_rede_credenciada c WHERE c.ST_REGISTRO = 'G' AND c.ID_EMPRESA = 1 AND c.ID_CUSTOM_REDE_CREDENCIADA_ID = 3");
rs = ADOContext.MyExecute("SELECT * FROM custom_rede_credenciada c WHERE c.ST_REGISTRO = 'G' AND c.ID_EMPRESA = 1 AND c.ID_CUSTOM_REDE_CREDENCIADA_ID = 3");
rs = ADOContext.MyExecute("SELECT * FROM custom_rede_credenciada c WHERE c.ST_REGISTRO = 'G' AND c.ID_EMPRESA = 1 AND c.ID_CUSTOM_REDE_CREDENCIADA_ID = 3");
rs = ADOContext.MyExecute("SELECT * FROM custom_rede_credenciada c WHERE c.ST_REGISTRO = 'G' AND c.ID_EMPRESA = 1 AND c.ID_CUSTOM_REDE_CREDENCIADA_ID = 3");
rs = ADOContext.MyExecute("SELECT * FROM custom_rede_credenciada c WHERE c.ST_REGISTRO = 'G' AND c.ID_EMPRESA = 1 AND c.ID_CUSTOM_REDE_CREDENCIADA_ID = 3");
rs = ADOContext.MyExecute("SELECT * FROM custom_rede_credenciada c WHERE c.ST_REGISTRO = 'G' AND c.ID_EMPRESA = 1 AND c.ID_CUSTOM_REDE_CREDENCIADA_ID = 3");
rs = ADOContext.MyExecute("SELECT * FROM custom_rede_credenciada c WHERE c.ST_REGISTRO = 'G' AND c.ID_EMPRESA = 1 AND c.ID_CUSTOM_REDE_CREDENCIADA_ID = 3");
rs = ADOContext.MyExecute("SELECT * FROM custom_rede_credenciada c WHERE c.ST_REGISTRO = 'G' AND c.ID_EMPRESA = 1 AND c.ID_CUSTOM_REDE_CREDENCIADA_ID = 3");
rs = ADOContext.MyExecute("SELECT * FROM custom_rede_credenciada c WHERE c.ST_REGISTRO = 'G' AND c.ID_EMPRESA = 1 AND c.ID_CUSTOM_REDE_CREDENCIADA_ID = 3");
var myClass = new ClassRedeCredenciadoLiteModel().BindClass(ref rs);
Assert.IsNotNull(myClass.ClassificacaoRedeCredenciadaId);
}
public MotoristaRepository()
{
Context = new ADOContext();
}
public CommonRepository(IConfiguration configuration)
{
Configuration = configuration;
ConnectionString = Configuration.GetConnectionString("InvTrackerContext");
_dbContext = new ADOContext(ConnectionString);
}
public BalanceteController(Base_SaoDomingosContext ctx, ADOContext ctxAdo)
{
_ctx = ctx;
_ctxADO = ctxAdo;
}
public PlanoContasController(Base_SaoDomingosContext ctx, ADOContext ctxAdo)
{
_ctx = ctx;
_ctxADO = ctxAdo;
}
public ResultadoController(Base_SaoDomingosContext context, ADOContext ctxADO)
{
_ctxADO = ctxADO;
_ctx = context;
}
public void GetData()
{
Recordset rs = ADOContext.MyExecute("select 1");
Assert.AreEqual(1, rs.GetVal <int>("1"));
}
