//GET BY STATE
public SqlOperation GetRetriveByStateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_CLIENT_STATE_PR"
};
var client = (Client)entity;
operation.AddBooleanParam(DB_COL_ACTIVE, client.Active);
return(operation);
}
//Search by state
public SqlOperation GetRetriveByStateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_PRODUCT_STATE_PR"
};
var product = (Product)entity;
operation.AddBooleanParam(DB_COL_STATE, product.State);
return(operation);
}
public SqlOperation GetRetriveByStateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_CATEGORY_STATE_PR"
};
var c = (Category)entity;
operation.AddBooleanParam(DB_COL_ACTIVE, c.Active);
return(operation);
}
//Search by state
public SqlOperation GetRetriveByStateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_OFFER_CODE_STATE_PR"
};
var offerCode = (OfferCode)entity;
operation.AddBooleanParam(DB_COL_ACTIVE, offerCode.Active);
return(operation);
}
public SqlOperation GetRetriveByStateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_STORE_STATE_PR"
};
var store = (Store)entity;
operation.AddVarcharParam(DB_COL_ID, store.Id);
operation.AddBooleanParam(DB_COL_ACTIVE, store.Active);
return(operation);
}
public SqlOperation GetRetriveByStateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_STORE_ADMINISTRATOR_STATE_PR"
};
var storeAdmin = (StoreAdministrator)entity;
operation.AddVarcharParam(DB_COL_EMAIL, storeAdmin.Email);
operation.AddBooleanParam(DB_COL_ACTIVE, storeAdmin.Active);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_PREFERENCE_PR"
};
var preference = (Preference)entity;
operation.AddIntParam(DB_COL_ID, preference.Id);
operation.AddIntParam(DB_COL_PREFERENCE_1, preference.Preference1);
operation.AddIntParam(DB_COL_PREFERENCE_2, preference.Preference2);
operation.AddIntParam(DB_COL_PREFERENCE_3, preference.Preference3);
operation.AddBooleanParam(DB_COL_ACTIVE, preference.Active);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CREATE_REQUERIMIENTO_PR"
};
var c = (Requerimientos)entity;
//operation.AddIntParam(DB_COL_ID_REQUERIMIENTO, c.ID_REQUERIMIENTO);
operation.AddStringParam(DB_COL_CODIGO, c.CODIGO);
operation.AddDoubleParam(DB_COL_PRIORIDAD, c.PRIORIDAD);
operation.AddStringParam(DB_COL_DESCRIPCION, c.DESCRIPCION);
operation.AddIntParam(DB_COL_ID_PROYECTO, c.ID_PROYECTO);
operation.AddBooleanParam(DB_COL_ESTADO, c.ESTADO);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_STORE_PR"
};
var store = (Store)entity;
operation.AddVarcharParam(DB_COL_ID, store.Id);
operation.AddVarcharParam(DB_COL_NAME, store.Name);
operation.AddVarcharParam(DB_COL_LOGO, store.Logo);
operation.AddVarcharParam(DB_COL_PHONE_NUMBER, store.PhoneNumber);
operation.AddIntParam(DB_COL_CATEGORY, store.Category);
operation.AddBooleanParam(DB_COL_ACTIVE, store.Active);
operation.AddDecimalParam(DB_COL_EARNINGS, store.Earnings);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_PRODUCT_MEDIA_PR"
};
var productMedia = (ProductMedia)entity;
operation.AddIntParam(DB_COL_ID, productMedia.Id);
operation.AddVarcharParam(DB_COL_IMAGE_1, productMedia.Image1);
operation.AddVarcharParam(DB_COL_IMAGE_2, productMedia.Image2);
operation.AddVarcharParam(DB_COL_IMAGE_3, productMedia.Image3);
operation.AddVarcharParam(DB_COL_IMAGE_4, productMedia.Image4);
operation.AddVarcharParam(DB_COL_IMAGE_5, productMedia.Image5);
operation.AddVarcharParam(DB_COL_VIDEO, productMedia.Video);
operation.AddBooleanParam(DB_COL_ACTIVE, productMedia.Active);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_PRODUCT_PR"
};
var Product = (Product)entity;
operation.AddIntParam(DB_COL_ID, Product.Id);
operation.AddVarcharParam(DB_COL_NAME, Product.Name);
operation.AddVarcharParam(DB_COL_DESCRIPTION, Product.Description);
operation.AddDecimalParam(DB_COL_PRICE_INITIAL, Product.PriceInitial);
operation.AddDecimalParam(DB_COL_PRICE_FINAL, Product.PriceFinal);
operation.AddDecimalParam(DB_COL_START_TAXES, Product.Taxes);
operation.AddVarcharParam(DB_COL_PROVIDER, Product.Provider);
operation.AddIntParam(DB_COL_ID_CATEGORY, Product.IdCategory);
operation.AddIntParam(DB_COL_ID_CURRENCY, Product.IdCurrency);
operation.AddBooleanParam(DB_COL_STATE, Product.State);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_CLIENT_PR"
};
var client = (Client)entity;
operation.AddVarcharParam(DB_COL_EMAIL, client.Email);
operation.AddVarcharParam(DB_COL_ID, client.Id);
operation.AddVarcharParam(DB_COL_URL_PHOTO_ID, client.Url_Photo_Id);
operation.AddIntParam(DB_COL_ID_ROL, client.Id_Rol);
operation.AddVarcharParam(DB_COL_NAME_1, client.Name_1);
operation.AddVarcharParam(DB_COL_NAME_2, client.Name_2);
operation.AddVarcharParam(DB_COL_LAST_NAME_1, client.Last_Name_1);
operation.AddVarcharParam(DB_COL_LAST_NAME_2, client.Last_Name_2);
operation.AddVarcharParam(DB_COL_PHONE_1, client.Phone_1);
operation.AddVarcharParam(DB_COL_PHONE_2, client.Phone_2);
operation.AddVarcharParam(DB_COL_URL_PROFILE_PRIC, client.Url_Profile_Pric);
operation.AddVarcharParam(DB_COL_PASSWORD, client.Password);
operation.AddBooleanParam(DB_COL_ACTIVE, client.Active);
return(operation);
}
