//Método para Refrescar la información de la tabla private void RefreshDataGridView() { List <CategoryForm> categories = BusinessCategory.GetAllCategories().ToList(); this.dtgridCatgory.DataSource = categories; DisabledFields(); }
public async Task <ActionResult <BusinessCategory> > PostBusinessCategory(BusinessCategory businessCategory) { _context.businessCategories.Add(businessCategory); await _context.SaveChangesAsync(); return(CreatedAtAction("GetBusinessCategory", new { id = businessCategory.Id }, businessCategory)); }
//Método para insertar categoría private void btInsert_Click(object sender, EventArgs e) { bool isValid = ValidateField(); if (isValid) { CategoryForm category = new CategoryForm { CategoryName = this.txtInsertarCategoria.Text, CategoryDescription = this.txtInsertarDescripcion.Text, CategoryId = Guid.NewGuid() }; bool hasBeenInserted = BusinessCategory.InsertCategory(category); if (hasBeenInserted) { RefreshDataGridView(); MessageBox.Show("Categoría insertada correctamente"); CleanFieldsInserted(); } else { MessageBox.Show("Error al insertar categoria"); } } }
// Método para actualizar categoría private void button1_Click(object sender, EventArgs e) { bool isValid = ValidateFieldUpdate(); if (!isValid) { return; } CategoryForm category = new CategoryForm { CategoryName = this.txtCategoryName.Text, CategoryDescription = this.txtDescripcion.Text, CategoryId = new Guid(this.lbId.Text), }; bool isUpdated = BusinessCategory.UpdateCategory(category); if (isUpdated) { RefreshDataGridView(); CleanFields(); MessageBox.Show("Categoría actualizada correctamente"); } else { MessageBox.Show("Ha ocurrido un error actualizando los campos de la categoría"); } }
public async Task <IActionResult> PutBusinessCategory(int id, BusinessCategory businessCategory) { if (id != businessCategory.Id) { return(BadRequest()); } _context.Entry(businessCategory).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!BusinessCategoryExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public ActionResult ListCategories() { var target = new BusinessCategory(); var retorno = target.GetAllCategories(); return(Json(retorno, JsonRequestBehavior.AllowGet)); }
private void Subcategories_Load(object sender, EventArgs e) { RefreshDataGridView(); IEnumerable <DataAccess.Entities.Category> categories = BusinessCategory.GetAllCategories().ToList(); comboInsert.DataSource = categories; comboInsert.DisplayMember = "CategoryName"; comboInsert.ValueMember = "CategoryId"; }
public async Task <ActionResult> DeleteConfirmed(int id) { BusinessCategory businessCategory = await db.BusinessCategories.FindAsync(id); db.BusinessCategories.Remove(businessCategory); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public DAO.BusinessCategory CreateBusinessCategory(BusinessCategory businessCategory) { return(new DAO.BusinessCategory() { Description = businessCategory.Description, CategoryName = businessCategory.CategoryName, Id = businessCategory.Id, Businesses = businessCategory.Businesses.Select(b => businessFactory.CreateBusiness(b)).ToList() }); }
public async Task <ActionResult> Edit([Bind(Include = "BusinessCategoryID,Title,Description,CompanyID")] BusinessCategory businessCategory) { if (ModelState.IsValid) { db.Entry(businessCategory).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.CompanyID = new SelectList(db.Companies, "CompanyID", "CompanyName", businessCategory.CompanyID); return(View(businessCategory)); }
public void Post([FromBody] Business value) { var imageString = value.ImageUrl; var imageUrls = HttpHelper.getImageName("bussines"); value.ImageUrl = imageUrls.imageUrl; using (var transaction = _db.Database.BeginTransaction()) { value.BusinesCategories = new List <BusinessCategory>(); foreach (var item in value.Categories) { if (item.Id > 0) { _db.ProductCategories.Attach(item); _db.Entry(item).State = EntityState.Unchanged; } else { _db.ProductCategories.Add(item); _db.SaveChanges(); } var busCat = new BusinessCategory() { Bussiness = value, BussinessId = value.Id, ProductCategory = item, ProductCategoryId = item.Id }; value.BusinesCategories.Add(busCat); } try { _db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } _db.Businesses.Add(value); _db.SaveChanges(); ImageUtility.SaveImage(imageUrls.imageDir, imageString); }
public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BusinessCategory businessCategory = await db.BusinessCategories.FindAsync(id); if (businessCategory == null) { return(HttpNotFound()); } return(View(businessCategory)); }
/// <summary> /// Converts a BusinessCategory value to a corresponding string value /// </summary> /// <param name="enumValue">The BusinessCategory value to convert</param> /// <returns>The representative string value</returns> public static string ToValue(BusinessCategory enumValue) { switch (enumValue) { //only valid enum elements can be used //this is necessary to avoid errors case BusinessCategory.NOT_PROVIDED: case BusinessCategory.ARTS_CRAFTS_AND_COLLECTIBLES: case BusinessCategory.BABY: case BusinessCategory.BEAUTY_AND_FRAGRANCES: case BusinessCategory.BOOKS_AND_MAGAZINES: case BusinessCategory.BUSINESS_TO_BUSINESS: case BusinessCategory.CLOTHING_ACCESSORIES_AND_SHOES: case BusinessCategory.COMPUTERS_ACCESSORIES_AND_SERVICES: case BusinessCategory.EDUCATION: case BusinessCategory.ELECTRONICS_AND_TELECOM: case BusinessCategory.ENTERTAINMENT_AND_MEDIA: case BusinessCategory.FINANCIAL_SERVICES_AND_PRODUCTS: case BusinessCategory.FOOD_RETAIL_AND_SERVICE: case BusinessCategory.GIFTS_AND_FLOWERS: case BusinessCategory.HEALTH_AND_PERSONAL_CARE: case BusinessCategory.HOME_AND_GARDEN: case BusinessCategory.NONPROFIT: case BusinessCategory.PETS_AND_ANIMALS: case BusinessCategory.RELIGION_AND_SPIRITUALITY_FOR_PROFIT: case BusinessCategory.RETAIL_NOT_ELSEWHERE_CLASSIFIED: case BusinessCategory.SERVICES_OTHER: case BusinessCategory.SPORTS_AND_OUTDOORS: case BusinessCategory.TOYS_AND_HOBBIES: case BusinessCategory.TRAVEL: case BusinessCategory.VEHICLE_SERVICE_AND_ACCESSORIES: case BusinessCategory.PROFESSIONAL_SERVICES: case BusinessCategory.RETAIL_BARS_AND_RESTAURANTS: case BusinessCategory.ENTERTAINMENT_AND_TRAVEL: case BusinessCategory.HEALTH_AND_SOCIAL_CARE: case BusinessCategory.TRANSPORT_AND_VEHICLES: case BusinessCategory.CONSTRUCTION_TRADES_AND_CLEANING: case BusinessCategory.PROPERTY: case BusinessCategory.EXERCISE_AND_FITNESS: case BusinessCategory.EDUCATION_AND_SKILLS: case BusinessCategory.NON_PROFIT1: case BusinessCategory.MANUFACTURING_RND_AND_AGRICULTURE: return(StringValues[(int)enumValue]); //an invalid enum value was requested default: return(null); } }
// GET: BusinessCategories/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BusinessCategory businessCategory = await db.BusinessCategories.FindAsync(id); if (businessCategory == null) { return(HttpNotFound()); } ViewBag.CompanyID = new SelectList(db.Companies, "CompanyID", "CompanyName", businessCategory.CompanyID); return(View(businessCategory)); }
// Method for grid update for GridCategory protected void GridCategory_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { var listInsert = new List <BusinessCategory>(); foreach (var args in e.InsertValues) { //InsertNewItem(args.NewValues); BusinessCategory category = new BusinessCategory(); category.AreaID = Convert.ToString(args.NewValues["AreaID"]); category.UniqueID = Convert.ToString(args.NewValues["UniqueID"]); category.CategoryTitle = Convert.ToString(args.NewValues["CategoryTitle"]); category.Description = Convert.ToString(args.NewValues["Description"]); category.Source = Convert.ToString(args.NewValues["Source"]); category.Date = Convert.ToDateTime(args.NewValues["Date"]); listInsert.Add(category); } if (listInsert.Count > 0) { rtm_services.InsertNewBusinessCategory(listInsert); } var listUpdates = new List <BusinessCategory>(); foreach (var args in e.UpdateValues) { BusinessCategory category = new BusinessCategory(); category.Id = Convert.ToString(args.Keys["Id"]); category.UniqueID = Convert.ToString(args.NewValues["UniqueID"]); category.CategoryTitle = Convert.ToString(args.NewValues["CategoryTitle"]); category.Description = Convert.ToString(args.NewValues["Description"]); category.Source = Convert.ToString(args.NewValues["Source"]); category.Date = Convert.ToDateTime(args.NewValues["Date"]); listUpdates.Add(category); } if (listUpdates.Count > 0) { rtm_services.UpdateBusinessCategory(listUpdates); } foreach (var args in e.DeleteValues) { DeleteCategoryItem(args.Keys); } e.Handled = true; BindCategory(); BindProcess(ddlProjects.SelectedItem.Value.ToString()); }
// Método para editar una subcategoria private void SubcategoryClick(object sender, DataGridViewCellEventArgs e) { EnabledFields(); IEnumerable <DataAccess.Entities.Category> categories = BusinessCategory.GetAllCategories().ToList(); comboSubcategory.DataSource = categories; comboSubcategory.DisplayMember = "CategoryName"; comboSubcategory.ValueMember = "CategoryId"; var rows = this.dtgridSubcatgory.CurrentRow; if (rows != null) { this.txtSubcategoryName.Text = rows.Cells["SubcategoryName"].Value.ToString(); this.txtSubcategoryDescripcion.Text = rows.Cells["SubcategoryDescription"].Value.ToString(); this.lbId.Text = rows.Cells["SubcategoryId"].Value.ToString(); this.comboSubcategory.Text = rows.Cells["Category"].Value.ToString(); } else { MessageBox.Show("Selecciona una fila"); } }
// Método para eliminar categoría private void button3_Click(object sender, EventArgs e) { var rows = this.dtgridCatgory.CurrentRow; if (rows != null) { var isDeleted = BusinessCategory.DeleteCategory(new Guid(rows.Cells["CategoryId"].Value.ToString())); if (isDeleted) { RefreshDataGridView(); CleanFields(); MessageBox.Show("Categoría borrada correctamente"); } else { MessageBox.Show("Error borrando categoría"); } } else { MessageBox.Show("Debe seleccionar una fila que borrar"); } }
// Método para buscar categoría private void SearchCategory(object sender, EventArgs e) { this.dtgridCatgory.DataSource = BusinessCategory.SearchCategory(this.txtSearch.Text); }
protected override void Seed(VotingContext context) { var groups = new List <Category> { new Category { CategoryID = 0, Title = "Solutioneers Features", Description = "Craving a new feature on the site? Submit it here and we will do our best to make sure all the top voted ideas get integrated into our systems!" }, new Category { CategoryID = 1, Title = "Business", Description = "Some important shit here" }, new Category { CategoryID = 2, Title = "Comics", Description = "Some important shit here" }, new Category { CategoryID = 3, Title = "Communication", Description = "Some important shit here" }, new Category { CategoryID = 4, Title = "Education", Description = "Some important shit here" }, new Category { CategoryID = 5, Title = "Entertainment", Description = "Some important shit here" }, new Category { CategoryID = 6, Title = "Finance", Description = "Some important shit here" }, new Category { CategoryID = 7, Title = "Health & Fitness", Description = "Some important shit here" }, new Category { CategoryID = 8, Title = "Lifestyle", Description = "Some important shit here" }, new Category { CategoryID = 9, Title = "Media & Video", Description = "Some important shit here" }, new Category { CategoryID = 10, Title = "Medical", Description = "Some important shit here" }, new Category { CategoryID = 11, Title = "Music & Audio", Description = "Some important shit here" }, new Category { CategoryID = 12, Title = "News & Magazines", Description = "Some important shit here" }, new Category { CategoryID = 13, Title = "Photography", Description = "Some important shit here" }, new Category { CategoryID = 14, Title = "Productivity", Description = "Some important shit here" }, new Category { CategoryID = 15, Title = "Shopping", Description = "Some important shit here" }, new Category { CategoryID = 16, Title = "Social", Description = "Some important shit here" }, new Category { CategoryID = 17, Title = "Sports", Description = "Some important shit here" }, new Category { CategoryID = 18, Title = "Tools", Description = "Some important shit here" }, new Category { CategoryID = 19, Title = "Transportation", Description = "Some important shit here" }, new Category { CategoryID = 20, Title = "Travel & Local", Description = "Some important shit here" }, new Category { CategoryID = 21, Title = "Weather", Description = "Some important shit here" } }; groups.ForEach(s => context.Categories.Add(s)); for (int i = 0, j = 0; i < 10; i++) { Company populate = new Company(); populate.CompanyID = i; populate.CreationDate = DateTime.Now; populate.Description = "This is some dummy description number: " + i; populate.CompanyName = "Company No: " + i; populate.UserID = "Admin Dummy Data"; Location tempLocation = new Location(); tempLocation.LocationID = i; tempLocation.Phone = "1111111111"; tempLocation.StreetAddress1 = "1234 Someplace NW ST"; tempLocation.State = Enums.State.WA; tempLocation.ZipCode = "98402"; tempLocation.City = "Seattle"; tempLocation.CompanyID = populate.CompanyID; tempLocation.Company = populate; tempLocation.HoursOfOperation = new List <HoursOfOperation>(); BusinessCategory tempBizCat = new BusinessCategory(); tempBizCat.BusinessCategoryID = i; tempBizCat.Company = populate; tempBizCat.Description = "This is a dummy description for a biz cat" + i; tempBizCat.CompanyID = populate.CompanyID; tempBizCat.Title = "BusinessCategory Temp Holder" + i; populate.Locations = new List <Location> { tempLocation }; populate.BusinessCategories = new List <BusinessCategory> { tempBizCat }; /* * HoursOfOperation tempHours = new HoursOfOperation(); * tempHours.HoursOfOperationID = i; * tempHours.DayOfWeek = DayOfWeek.Friday; * tempHours.LocationID = tempLocation.LocationID; * tempHours.Location = tempLocation; * tempHours.TimeOpen = "9 AM - 5 PM"; * * tempLocation.HoursOfOperation.Concat(new List<HoursOfOperation> { tempHours }); * populate.Locations.Concat(new List<Location>{ tempLocation }); * * * context.HoursOfOperations.Add(tempHours);*/ context.BusinessCategories.Add(tempBizCat); context.Locations.Add(tempLocation); context.Companies.Add(populate); } context.SaveChanges(); }
public BookingRepositoryActionResult <BusinessCategory> InsertBusinessCategory(BusinessCategory bc) { try { _ctx.BusinessCategories.Add(bc); var result = _ctx.SaveChanges(); if (result > 0) { return(new BookingRepositoryActionResult <BusinessCategory>(bc, BookingRepositoryActionStatus.Created)); } else { return(new BookingRepositoryActionResult <BusinessCategory>(bc, BookingRepositoryActionStatus.NothingModified, null)); } } catch (Exception ex) { return(new BookingRepositoryActionResult <BusinessCategory>(null, BookingRepositoryActionStatus.Error, ex)); } }
public object CreateDataShapedObject(BusinessCategory businessCategory, List <string> lstOfFields) { return(CreateDataShapedObject(CreateBusinessCategory(businessCategory), lstOfFields)); }
public BookingRepositoryActionResult <BusinessCategory> UpdateBusinessCategory(BusinessCategory eg) { try { // you can only update when an expensegroup already exists for this id var existingEG = _ctx.BusinessCategories.FirstOrDefault(exg => exg.Id == eg.Id); if (existingEG == null) { return(new BookingRepositoryActionResult <BusinessCategory>(eg, BookingRepositoryActionStatus.NotFound)); } // change the original entity status to detached; otherwise, we get an error on attach // as the entity is already in the dbSet // set original entity state to detached _ctx.Entry(existingEG).State = EntityState.Detached; // attach & save _ctx.BusinessCategories.Attach(eg); // set the updated entity state to modified, so it gets updated. _ctx.Entry(eg).State = EntityState.Modified; var result = _ctx.SaveChanges(); if (result > 0) { return(new BookingRepositoryActionResult <BusinessCategory>(eg, BookingRepositoryActionStatus.Updated)); } else { return(new BookingRepositoryActionResult <BusinessCategory>(eg, BookingRepositoryActionStatus.NothingModified, null)); } } catch (Exception ex) { return(new BookingRepositoryActionResult <BusinessCategory>(null, BookingRepositoryActionStatus.Error, ex)); } }