//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); }