public async Task IncreaseClickCount(int itemID) { DynamicParameters param = new DynamicParameters(); param.Add("@ItemID", itemID); await DapperORM.ExecuteWithoutReturnAsync("ItemClickCountSET", param); }
public async Task DeleteUser(int userID) { DynamicParameters param = new DynamicParameters(); param.Add("@UserID", userID); await DapperORM.ExecuteWithoutReturnAsync("UserDELETE", param); }
public async Task <IEnumerable <CascadingRegionNames> > GetCascadingRegionNames(int neighborhoodID) { DynamicParameters param = new DynamicParameters(); param.Add("@NeighborhoodID", neighborhoodID); return(await DapperORM.ReturListAsync <CascadingRegionNames>("RegionNamesGETByNeighborhoodID", param)); }
public IEnumerable <RegionNeighborhoodModel> GetRegionNeighborhoods(int districtID) { DynamicParameters param = new DynamicParameters(); param.Add("@DistrictID", districtID); return(DapperORM.ReturList <RegionNeighborhoodModel>("RegionNeighborhoodGET", param)); }
public IEnumerable <RegionDistrictModel> GetRegionDistricts(int countyID) { DynamicParameters param = new DynamicParameters(); param.Add("@CountyID", countyID); return(DapperORM.ReturList <RegionDistrictModel>("RegionDistrictGET", param)); }
public IEnumerable <RegionCountyModel> GetRegionCounties(int cityID) { DynamicParameters param = new DynamicParameters(); param.Add("@CityID", cityID); return(DapperORM.ReturList <RegionCountyModel>("RegionCountyGET", param)); }
public async Task <IEnumerable <PhoneModel> > GetPhonesByUserID(int userID) { DynamicParameters param = new DynamicParameters(); param.Add("@UserID", userID); return(await DapperORM.ReturListAsync <PhoneModel>("PhoneGET", param)); }
public async Task ItemDelete(int itemID) { DynamicParameters param = new DynamicParameters(); param.Add("@ItemID", itemID); await DapperORM.ExecuteWithoutReturnAsync("ItemDELETE", param); }
public async Task <IEnumerable <CategoryModel> > GetCategories(int parentCategoryID = 0) { DynamicParameters param = new DynamicParameters(); param.Add("@ParentCategoryID", parentCategoryID); return(await DapperORM.ReturListAsync <CategoryModel>("CategoryGET", param)); }
public async Task <IEnumerable <UserModel> > GetUsers(int userID = 0) { DynamicParameters param = new DynamicParameters(); param.Add("@UserID", userID); return(await DapperORM.ReturListAsync <UserModel>("UserGET", param)); }
public async Task DeletePhone(int phoneID) { DynamicParameters param = new DynamicParameters(); param.Add("@PhoneID", phoneID); await DapperORM.ExecuteWithoutReturnAsync("PhoneDELETE", param); }
public async Task <IEnumerable <PropertyModel> > PropertyValueGet(int itemID) { DynamicParameters param = new DynamicParameters(); param.Add("@ItemID", itemID); return(await DapperORM.ReturListAsync <PropertyModel>("ItemPropertyValueGET", param)); }
public async Task SaveItemPhoto(int itemID = 0, string fileName = "") { DynamicParameters param = new DynamicParameters(); param.Add("@Path", fileName); param.Add("@ItemID", itemID); await DapperORM.ExecuteWithoutReturnAsync("ItemPhotoSET", param); }
public async Task MakeProfilePhoto(int itemID, string photoPath) { DynamicParameters param = new DynamicParameters(); param.Add("@ItemID", itemID); param.Add("@PhotoPath", photoPath); await DapperORM.ExecuteWithoutReturnAsync("ItemProfilePhotoSET", param); }
public async Task <IEnumerable <PropertyModel> > PropertyGet(int categoryID = 0, int propertyID = 0) { DynamicParameters param = new DynamicParameters(); if (propertyID > 0) { param.Add("@PropertyID", propertyID); } param.Add("@CategoryID", categoryID); return(await DapperORM.ReturListAsync <PropertyModel>("PropertyGET", param)); }
public async Task AddUser(UserRegisterModel user) { DynamicParameters param = new DynamicParameters(); param.Add("@Mail", user.Mail); param.Add("@Password", user.Password); param.Add("@Name", user.Name); param.Add("@Surname", user.Surname); param.Add("@Role", user.Role); param.Add("@TCKNO", user.Tckno); await DapperORM.ExecuteWithoutReturnAsync("UserSET", param); }
public LoginResultModel UserLogin(AuthenticateModel user) { DynamicParameters param = new DynamicParameters(); param.Add("@Mail", user.Mail); param.Add("@Password", user.Password); var result = DapperORM.ReturList <LoginResultModel>("UserLOGIN", param); if (result.Count <LoginResultModel>() == 0) { return(null); } return(result.First <LoginResultModel>()); }
public async Task AddOrEdit(CategoryModel category) { DynamicParameters param = new DynamicParameters(); param.Add("@CategoryName", category.CategoryName); param.Add("@ParentCategoryID", category.ParentCategoryID); if (category.CategoryID == 0) { await DapperORM.ExecuteWithoutReturnAsync("CategorySET", param); } else { param.Add("@CategoryID", category.CategoryID); await DapperORM.ExecuteWithoutReturnAsync("CategoryUPDATE", param); } }
public async Task AddOrEditPhone(PhoneModel phoneModel) { DynamicParameters param = new DynamicParameters(); param.Add("@Number", phoneModel.Number); param.Add("@UserID", phoneModel.UserID); if (phoneModel.PhoneID == 0) { await DapperORM.ExecuteWithoutReturnAsync("PhoneSET", param); } else { param.Add("@PhoneID", phoneModel.PhoneID); await DapperORM.ExecuteWithoutReturnAsync("PhoneUPDATE", param); } }
public async Task AddOrEdit(PropertyModel property) { DynamicParameters param = new DynamicParameters(); param.Add("@PropertyName", property.PropertyName); param.Add("@Type", property.Type); param.Add("@CategoryID", property.CategoryID); if (property.PropertyID > 0) { param.Add("@PropertyID", property.PropertyID); await DapperORM.ExecuteWithoutReturnAsync("PropertyUPDATE", param); } else { await DapperORM.ExecuteWithoutReturnAsync("PropertySET", param); } }
public async Task <List <ItemModel> > GetItemWithPhotos(int itemID = 0, int userID = 0) //TO DO : make better { DynamicParameters param = new DynamicParameters(); string sql; if (userID > 0) { param.Add("@UserID", userID); sql = "ItemGETByUserID"; } else { param.Add("@ItemID", itemID); sql = "ItemGET"; } using (SqlConnection cnn = new SqlConnection(DapperORM.GetConnectionString())) { List <ItemModel> listItems = null; var lists = await cnn.QueryAsync <ItemModel, UserModel, ItemPhotoModel, ItemModel>(sql, (i, u, p) => { i.ItemPhotos = new List <ItemPhotoModel>(); i.ItemPhotos.Add(p); i.User = new UserModel(); i.User = u; return(i); }, param, commandType : CommandType.StoredProcedure, splitOn : "UserID, PhotoID"); var result = lists.GroupBy(item => item.ItemID).Select(g => { var groupedPost = g.First(); groupedPost.ItemPhotos = g.Select(p => p.ItemPhotos.Single()).ToList(); return(groupedPost); }); listItems = result.ToList <ItemModel>(); return(listItems); } }
public async Task AddOrEditItem(ItemModel item) { DynamicParameters param = new DynamicParameters(); param.Add("@Title", item.Title); param.Add("@Description", item.Description); param.Add("@CategoryID", item.CategoryID); param.Add("@UserID", item.User.UserID); param.Add("@Price", item.Price); param.Add("@State", item.State); param.Add("@NeighborhoodID", item.NeighborhoodID); param.Add("@MapX", item.MapX); param.Add("@MapY", item.MapY); param.Add("@ProfilePhotoPath", item.ProfilePhotoPath); if (item.ItemID == 0) { item.ItemID = DapperORM.ExecuteReturnScalar <int>("ItemSET", param); if (item.Properties != null) { foreach (var property in item.Properties) { DynamicParameters propparam = new DynamicParameters(); propparam.Add("@PropertyID", property.PropertyID); propparam.Add("@Value", property.Value); propparam.Add("@ItemID", item.ItemID); DapperORM.ExecuteWithoutReturn("ItemPropertyValueSET", propparam); } } } else { param.Add("@ItemID", item.ItemID); await DapperORM.ExecuteWithoutReturnAsync("ItemUPDATE", param); } }
public IEnumerable <RegionCityModel> GetRegionCities() { return(DapperORM.ReturList <RegionCityModel>("RegionCityGET")); }