public DataRow Select(ECorporation corporation)
{
DaCommand command = new DaCommand("dbo.CorporationSelect");
command.AddInParameter("@CodeCorporation", DbType.String, corporation.CodeCorporation);
return(ExecuteDataRow(command));
}
public DataRow Select(EUser user)
{
DaCommand command = new DaCommand("UserSelect");
command.AddInParameter("@CodeUser", DbType.String, user.CodeUser);
return(ExecuteDataRow(command));
}
public DataTable SelectByUser(EUser user)
{
DaCommand command = new DaCommand("UserCompanySelectByUser");
command.AddInParameter("@CodeUser", DbType.String, user.CodeUser);
return(ExecuteDataTable(command));
}
public DataRow Select(EProduct eProduct)
{
DaCommand command = new DaCommand("ProductSelect");
command.AddInParameter("@CodeProduct", DbType.String, eProduct.CodeProduct);
return(ExecuteDataRow(command));
}
public void Delete(EProduct eProduct)
{
DaCommand command = new DaCommand("ProductDelete");
command.AddInParameter("@CodeProduct", DbType.String, eProduct.CodeProduct);
ExecuteNonQuery(command);
}
public DataRow Select(ECompany company)
{
DaCommand command = new DaCommand("dbo.CompanySelect");
command.AddInParameter("@CodeCompany", DbType.String, company.CodeCompany);
return(ExecuteDataRow(command));
}
public void Delete(ESequence sequence)
{
DaCommand command = new DaCommand("SequenceDelete");
command.AddInParameter("@CodeSequence", DbType.String, sequence.CodeSequence);
ExecuteNonQuery(command);
}
public void Delete(ECorporation corporation)
{
DaCommand command = new DaCommand("dbo.CorporationDelete");
command.AddInParameter("@CodeCorporation", DbType.String, corporation.CodeCorporation);
ExecuteNonQuery(command);
}
public void Delete(ECompany company)
{
DaCommand command = new DaCommand("dbo.CompanyDelete");
command.AddInParameter("@CodeCompany", DbType.String, company.CodeCompany);
ExecuteNonQuery(command);
}
public void Delete(EClient eClient)
{
DaCommand command = new DaCommand("ClientDelete");
command.AddInParameter("@CodeClient", DbType.Int32, eClient.CodeClient);
ExecuteNonQuery(command);
}
public DataTable List()
{
DaCommand command = new DaCommand("UserList");
DataTable table = ExecuteDataTable(command);
return(table);
}
public DataRow Select(EClient eClient)
{
DaCommand command = new DaCommand("ClientSelect");
command.AddInParameter("@CodeClient", DbType.Int32, eClient.CodeClient);
return(ExecuteDataRow(command));
}
public DataRow Select(ESequence sequence)
{
DaCommand command = new DaCommand("SequenceSelect");
command.AddInParameter("@CodeSequence", DbType.String, sequence.CodeSequence);
return(ExecuteDataRow(command));
}
public void Delete(EUser user)
{
DaCommand command = new DaCommand("UserDelete");
command.AddInParameter("@CodeUser", DbType.String, user.CodeUser);
ExecuteNonQuery(command);
}
public void Insert(EUserCompany userCompany)
{
DaCommand command = new DaCommand("UserCompanyInsert");
command.AddInParameter("@CodeUser", DbType.String, userCompany.CodeUser);
command.AddInParameter("@CodeCompany", DbType.String, userCompany.CodeCompany);
ExecuteNonQuery(command);
}
public void Update(ESequence sequence)
{
DaCommand command = new DaCommand("SequenceUpdate");
command.AddInParameter("@CodeSequence", DbType.String, sequence.CodeSequence);
command.AddInParameter("@Correlative", DbType.Int32, sequence.Correlative);
ExecuteNonQuery(command);
}
public void Update(ECorporation corporation)
{
DaCommand command = new DaCommand("dbo.CorporationUpdate");
command.AddInParameter("@CodeCorporation", DbType.String, corporation.CodeCorporation);
command.AddInParameter("@Name", DbType.String, corporation.Name);
command.AddInParameter("@State", DbType.Int16, corporation.State);
ExecuteNonQuery(command);
}
protected SqlCommand GetCommand(DaCommand Command)
{
SqlCommand store = new SqlCommand();
store.CommandText = Command.CommandText;
store.CommandType = CommandType.StoredProcedure;
SetParameters(ref store, Command);
return(store);
}
public DataTable Select(EAudit entity, short top)
{
DaCommand command = new DaCommand("AuditSelect");
command.AddInParameter("@CodeCompany", DbType.String, entity.CodeCompany);
command.AddInParameter("@CodeEntity", DbType.String, entity.CodeEntity);
command.AddInParameter("@Code", DbType.String, entity.Code);
command.AddInParameter("@Top", DbType.Int16, top);
return(ExecuteDataTable(command));
}
public void Update(EProductType eProductType)
{
DaCommand command = new DaCommand("ProductTypeUpdate");
command.AddInParameter("@CodeProductType", DbType.String, eProductType.CodeProductType);
command.AddInParameter("@Description", DbType.String, eProductType.Description);
command.AddInParameter("@CodeSunatExistence", DbType.String, eProductType.CodeSunatExistence);
command.AddInParameter("@State", DbType.Int16, eProductType.State);
ExecuteNonQuery(command);
}
public void Update(EUser user)
{
DaCommand command = new DaCommand("UserUpdate");
command.AddInParameter("@CodeUser", DbType.String, user.CodeUser);
command.AddInParameter("@Name", DbType.String, user.Name);
command.AddInParameter("@Email", DbType.String, user.Email);
command.AddInParameter("@State", DbType.String, user.State);
ExecuteNonQuery(command);
}
public void Insert(EUser user)
{
DaCommand command = new DaCommand("UserInsert");
command.AddInParameter("@CodeUser", DbType.String, user.CodeUser);
command.AddInParameter("@Name", DbType.String, user.Name);
command.AddInParameter("@Password", DbType.String, user.PasswordHash);
command.AddInParameter("@Email", DbType.String, user.Email);
command.AddInParameter("@State", DbType.String, user.State);
ExecuteNonQuery(command);
}
public void Insert(EAudit entity)
{
DaCommand command = new DaCommand("AuditInsert");
command.AddInParameter("@CodeCompany", DbType.String, entity.CodeCompany);
command.AddInParameter("@CodeEntity", DbType.String, entity.CodeEntity);
command.AddInParameter("@Code", DbType.String, entity.Code);
command.AddInParameter("@Sequence", DbType.String, entity.Sequence);
command.AddInParameter("@TypeEvent", DbType.String, entity.TypeEvent);
command.AddInParameter("@UserRegister", DbType.String, entity.UserRegister);
ExecuteNonQuery(command);
}
public override DataRow ExecuteDataRow(DaCommand Command)
{
DataTable table = ExecuteDataTable(Command);
if (table.Rows.Count > 0)
{
return(table.Rows[0]);
}
else
{
return(null);
}
}
public override object ExecuteScalar(DaCommand Command)
{
try
{
SqlCommand store = GetCommand(Command);
store.Connection = GetConnection();
return(store.ExecuteScalar());
}
catch (Exception ex)
{
throw ex;
}
finally
{
GetConnection().Close();
}
}
private void SetParameters(ref SqlCommand store, DaCommand command)
{
store.Parameters.Clear();
foreach (var par in command.Parameters)
{
SqlParameter parameter = new SqlParameter();
parameter.ParameterName = par.ParameterName;
parameter.Direction = par.Direction;
parameter.DbType = par.DbType;
parameter.Value = par.Value;
if (par.DbType == DbType.String && par.Value == null)
{
parameter.Value = DBNull.Value;
}
store.Parameters.Add(parameter);
}
}
public void Update(ECompany company)
{
DaCommand command = new DaCommand("dbo.CompanyUpdate");
command.AddInParameter("@CodeCompany", DbType.String, company.CodeCompany);
command.AddInParameter("@CodeCorporation", DbType.String, company.CodeCorporation);
command.AddInParameter("@LongName", DbType.String, company.LongName);
command.AddInParameter("@ShortName", DbType.String, company.ShortName);
command.AddInParameter("@Ruc", DbType.String, company.Ruc);
command.AddInParameter("@Address", DbType.String, company.Address);
command.AddInParameter("@PageWeb", DbType.String, company.PageWeb);
command.AddInParameter("@Phone", DbType.String, company.Phone);
command.AddInParameter("@Fax", DbType.String, company.Fax);
command.AddInParameter("@Logo", DbType.String, company.Logo);
command.AddInParameter("@State", DbType.Int16, company.State);
ExecuteNonQuery(command);
}
public void Update(EClient eClient)
{
DaCommand command = new DaCommand("ClientUpdate");
command.AddInParameter("@CodeClient", DbType.Int32, eClient.CodeClient);
command.AddInParameter("@FirstName", DbType.String, eClient.FirstName);
command.AddInParameter("@SecondName", DbType.String, eClient.SecondName);
command.AddInParameter("@FatherLastName", DbType.String, eClient.FatherLastName);
command.AddInParameter("@MotherLastName", DbType.String, eClient.MotherLastName);
command.AddInParameter("@LongName", DbType.String, eClient.LongName);
command.AddInParameter("@ShortName", DbType.String, eClient.ShortName);
command.AddInParameter("@SearchName", DbType.String, eClient.SearchName);
command.AddInParameter("@CodeTypeDocumentIdentity", DbType.String, eClient.CodeTypeDocumentIdentity);
command.AddInParameter("@NumberIdentity", DbType.String, eClient.NumberIdentity);
command.AddInParameter("@Address", DbType.String, eClient.Address);
command.AddInParameter("@Phone", DbType.String, eClient.Phone);
command.AddInParameter("@Fax", DbType.String, eClient.Fax);
command.AddInParameter("@Email", DbType.String, eClient.Email);
command.AddInParameter("@State", DbType.String, eClient.State);
ExecuteNonQuery(command);
}
public void Update(EProduct eProduct)
{
DaCommand command = new DaCommand("ProductUpdate");
command.AddInParameter("@CodeProduct", DbType.String, eProduct.CodeProduct);
command.AddInParameter("@CodeProductLine", DbType.String, eProduct.CodeProductLine);
command.AddInParameter("@CodeProductFamily", DbType.String, eProduct.CodeProductFamily);
command.AddInParameter("@CodeProductSubFamily", DbType.String, eProduct.CodeProductSubFamily);
command.AddInParameter("@CodeProductLevel", DbType.String, eProduct.CodeProductLevel);
command.AddInParameter("@CodeProductLevelTwo", DbType.String, eProduct.CodeProductLevelTwo);
command.AddInParameter("@CodeProductType", DbType.String, eProduct.CodeProductType);
command.AddInParameter("@CodeProductGroup", DbType.String, eProduct.CodeProductGroup);
command.AddInParameter("@CodeProductBrand", DbType.String, eProduct.CodeProductBrand);
command.AddInParameter("@CodeProductUnitMeasure", DbType.String, eProduct.CodeProductUnitMeasure);
command.AddInParameter("@CodeProductModel", DbType.String, eProduct.CodeProductModel);
command.AddInParameter("@CodeMoney", DbType.String, eProduct.CodeMoney);
command.AddInParameter("@CodeProductRecet", DbType.String, eProduct.CodeProductRecet);
command.AddInParameter("@CodeSunatProductTaxRV", DbType.String, eProduct.CodeSunatProductTaxRV);
command.AddInParameter("@CodeSunatProductTaxRC", DbType.String, eProduct.CodeSunatProductTaxRC);
command.AddInParameter("@UseRecet", DbType.Boolean, eProduct.UseRecet);
command.AddInParameter("@CodeBar", DbType.String, eProduct.CodeBar);
command.AddInParameter("@CodeIntern", DbType.String, eProduct.CodeIntern);
command.AddInParameter("@DescriptionForStore", DbType.String, eProduct.DescriptionForStore);
command.AddInParameter("@DescriptionForSale", DbType.String, eProduct.DescriptionForSale);
command.AddInParameter("@DescriptionShortForStore", DbType.String, eProduct.DescriptionShortForStore);
command.AddInParameter("@PriceCostMoneyNational", DbType.Decimal, eProduct.PriceCostMoneyNational);
command.AddInParameter("@PriceCostMoneyForeign", DbType.Decimal, eProduct.PriceCostMoneyForeign);
command.AddInParameter("@PriceSaleMoneyNational", DbType.Decimal, eProduct.PriceSaleMoneyNational);
command.AddInParameter("@PriceSaleMoneyForeign", DbType.Decimal, eProduct.PriceSaleMoneyForeign);
command.AddInParameter("@PriceCostAverage", DbType.Decimal, eProduct.PriceCostAverage);
command.AddInParameter("@ActiveForSale", DbType.Boolean, eProduct.ActiveForSale);
command.AddInParameter("@ActiveForBuy", DbType.Boolean, eProduct.ActiveForBuy);
command.AddInParameter("@StockMinimun", DbType.Decimal, eProduct.StockMinimun);
command.AddInParameter("@StockMaximun", DbType.Decimal, eProduct.StockMaximun);
command.AddInParameter("@ValidateStock", DbType.Boolean, eProduct.ValidateStock);
command.AddInParameter("@ValidateStock", DbType.Boolean, eProduct.ValidateStock);
ExecuteNonQuery(command);
}
public override DataTable ExecuteDataTable(DaCommand Command)
{
try
{
SqlCommand store = GetCommand(Command);
store.Connection = GetConnection();
DataTable table = new DataTable();
using (SqlDataReader reader = store.ExecuteReader())
{
table.Load(reader);
reader.Close();
}
return(table);
}
catch (Exception ex)
{
throw ex;
}
finally
{
GetConnection().Close();
}
}