public IHttpActionResult Putbrand(int id, brand brand) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != brand.brand_id) { return(BadRequest()); } db.Entry(brand).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!brandExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public BrandView(brand origianl) { this.id = origianl.id; this.name = origianl.name; this.image = origianl.image; this.webSite = origianl.webSite; }
public int BADeleteBrand(brand objbranddetails) { DABrand objbrandDA = new DABrand(); int returnValue = objbrandDA.DADeleteBrand(objbranddetails); return(returnValue); }
public ReturnValueRepo CreateBrand(int itemSubType, string brandName, string description) { var result = new ReturnValueRepo(); var newBrand = new brand { brand_parent_id = itemSubType, brand_name = brandName, brand_description = description }; int commandResult = InventoryDatabase.Database.ExecuteSqlCommand( @"INSERT INTO [dbo].[brand] ([brand_name] ,[brand_parent_id] ,[brand_description]) VALUES ({0} ,{1} ,{2})", brandName, itemSubType, description); //InventoryDatabase.brands.Add(newBrand); //if (InventoryDatabase.SaveChanges() > 0) if (commandResult > 0) { result.Success = true; result.Param1 = newBrand.brand_id.ToString(); } return(result); }
public async Task <IActionResult> Edit(string id, [Bind("br_id,br_name")] brand brand) { if (id != brand.br_id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(brand); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!brandExists(brand.br_id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(brand)); }
public ActionResult Edit([Bind(Include = "id,name,activeFlag,createDate,updateDate")] brand brand, string editname, HttpPostedFileBase editlogo) { if (ModelState.IsValid) { brand modifybrand = db.brands.Find(brand.id); if (modifybrand != null) { if (editlogo != null && editlogo.ContentLength > 0) { string fileName = System.IO.Path.GetFileName(editlogo.FileName); string urlImage = Server.MapPath("~/Image/" + fileName); editlogo.SaveAs(urlImage); modifybrand.name = editname; modifybrand.updateDate = DateTime.Now; modifybrand.logo = "Image/" + fileName; modifybrand.updateDate = DateTime.Now; } else { modifybrand.name = editname; modifybrand.updateDate = DateTime.Now; } } db.Entry(modifybrand).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(brand)); }
public IActionResult EditBrand(BrandViewModel model, string manufact, string type) { brand brand = new brand() { brand_key = model.Avto_Key }; brand.expenses = model.expenses; brand.name = model.name; brand.body_type = model.body_type; brand.type_of_avto = _context.type_of_avto.Where(e => e.type_of_avto_key == Convert.ToInt32(type)).FirstOrDefault(); brand.type_of_avto_key = _context.type_of_avto.Where(e => e.type_of_avto_key == Convert.ToInt32(type)).FirstOrDefault().type_of_avto_key; manufacturer manufacturer = _context.manufacturers.Where(e => e.name == manufact).FirstOrDefault(); if (manufacturer == null) { manufacturer manufactur = new manufacturer() { name = manufact }; _context.manufacturers.Add(manufactur); _context.SaveChanges(); } brand.manufacturer = _context.manufacturers.Where(e => e.Manufacturer_Key == Convert.ToInt32(manufact)).FirstOrDefault(); brand.manufacturer_key = _context.manufacturers.Where(e => e.Manufacturer_Key == Convert.ToInt32(manufact)).FirstOrDefault().Manufacturer_Key; _context.brands.Update(brand); _context.SaveChanges(); return(RedirectToAction("ShowsBrand", "Shows")); }
// GET: brandsMain/Details/5 public ActionResult Details(int id) { brand brandss = null; using (var client = new HttpClient()) { client.BaseAddress = new Uri("http://localhost:54964/api/brandsApi"); //HTTP GET var responseTask = client.GetAsync("brandsApi?id=" + id.ToString()); responseTask.Wait(); var result = responseTask.Result; if (result.IsSuccessStatusCode) { var readTask = result.Content.ReadAsAsync <brand>(); readTask.Wait(); brandss = readTask.Result; } else //web api sent error response { //log response status here.. ModelState.AddModelError(string.Empty, "Server error. Please contact administrator."); } } return(View(brandss)); }
public long Addbrand(brand brand) { try { brand insert_brand = new brand { brand_name = brand.brand_name, //created_by = created_date = DateTime.Now, //updated_by = updated_date = DateTime.Now, is_active = true, is_deleted = false, }; _entities.brands.Add(insert_brand); _entities.SaveChanges(); long last_insert_id = insert_brand.brand_id; return(last_insert_id); } catch (Exception ex) { return(0); } }
public int BAAddbranddetails(brand objbranddetails) { DABrand objbrandDA = new DABrand(); int returnValue = objbrandDA.DAAddbranddetails(objbranddetails); return(returnValue); }
public IActionResult AddBrand(BrandViewModel model, string type, string manufact) { brand brand = new brand() { expenses = model.expenses, name = model.name, body_type = model.body_type, type_of_avto = _context.type_of_avto.Where(e => e.name == type).FirstOrDefault(), type_of_avto_key = _context.type_of_avto.Where(e => e.name == type).FirstOrDefault().type_of_avto_key, }; manufacturer manufacturer = _context.manufacturers.Where(e => e.name == manufact).FirstOrDefault(); if (manufacturer == null) { manufacturer manufactur = new manufacturer() { name = manufact }; _context.manufacturers.Add(manufactur); _context.SaveChanges(); } brand.manufacturer = _context.manufacturers.Where(e => e.name == manufact).FirstOrDefault(); brand.manufacturer_key = _context.manufacturers.Where(e => e.name == manufact).FirstOrDefault().Manufacturer_Key; _context.brands.Add(brand); _context.SaveChanges(); return(RedirectToAction("AddBrand", "AddSome")); }
private void btnUpdateBrand_Click(object sender, EventArgs e) { if (gridBrand.SelectedCells[0].Value != null) { if (!tbBrands.Text.Equals("")) { int id = Convert.ToInt32(gridBrand.SelectedCells[0].Value.ToString()); brand br = idc.brands.SingleOrDefault(x => x.brand_id == id); br.brand_title = tbBrands.Text; idc.SubmitChanges(); MessageBox.Show("Successfully updated a brand."); } else { lblError.Text = "Enter a name to proceed."; } } else { lblError.Text = "Please select a row to update."; } }
public int DA_ValidateBrand(brand objBrandDetails) { int val = 0; DataTable dt = new DataTable(); try { con.Open(); MySqlCommand cmd = new MySqlCommand(objQuery.ValidateBrand, con); cmd.Parameters.AddWithValue("@BrandName", objBrandDetails.BrandName); //cmd.Parameters.AddWithValue("@CategoryName",objBrandDetails.ca) cmd.Parameters.AddWithValue("@CategoryId", objBrandDetails.CategoryId); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(dt); if (dt.Rows.Count > 0) { val = 1; } else { val = 0; } } catch (Exception ex) { ex.ToString(); //throw; } finally { con.Close(); } return(val); }
public ActionResult Create([Bind(Include = "id,name,origin,describe,logo")] brand brand, FormCollection data, HttpPostedFileBase f) { if (ModelState.IsValid) { brand.name = data["name"]; brand.origin = data["origin"]; brand.describe = data["describe"]; if (f != null) { string fullname = Server.MapPath("~/img/brand/" + f.FileName); f.SaveAs(fullname); brand.logo = f.FileName; } else { brand.logo = ""; } db.brand.Add(brand); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(brand)); }
public static List <brand> getBrands(string FilePath) { List <brand> brands = new List <brand>(); // Объявляем и забиваем файл в документ XmlDocument xd = new XmlDocument(); FileStream fs = new FileStream(FilePath, FileMode.Open); xd.Load(fs); XmlNodeList list = xd.GetElementsByTagName("Row"); // Создаем и заполняем лист по тегу "user" for (int i = 0; i < list.Count; i++) { brand b = new brand(); b.code1C = list[i].FirstChild.InnerText; b.name = list[i].LastChild.InnerText; brands.Add(b); } // Закрываем поток fs.Close(); return(brands); }
public void AddPrices_And_Delete_NULL_price() { var beer = new brand(); beer.country = "TEST country"; beer.description = "TEST descripion"; beer.maker = "Refsvindinge"; beer.name = "Ale nr 1673"; beer.type = "TEST type"; beer.volume = "TEST 22"; beer.deleted = false; var result = _service.AddBeer( beer, 807 ); //remember to change values that match something existing in the DB var priceRecordId = _service.AddPrices( new establishment_brand { brand_id = result.id, establishment_id = 807, price = "22", size = "med", deleted = false }, 807, result.id ); //remember to change values that match something existing in the DB _service.AddPrices( new establishment_brand { brand_id = result.id, establishment_id = 807, price = "25", size = "med", deleted = false }, 807, result.id ); //remember to change values that match something existing in the DB Assert.IsNotNull( priceRecordId ); var record = _service.Database.establishment_brands.Where( x => x.price == null && x.id == priceRecordId ).FirstOrDefault(); Assert.IsNull( record ); }
public brand AddBeer( brand beer, int establishmentId ) { if (!Exists( beer.name )) { Database.brands.InsertOnSubmit( beer ); Database.SubmitChanges(); HublisherApp.UpdateGlobals(); } else { var update = Database.brands.Where( b => b.id == beer.id && b.deleted == false ).FirstOrDefault(); if (update != null) { update.name = beer.name; update.maker = beer.maker; update.country = beer.country; update.description = beer.description; update.type = beer.type; update.volume = beer.volume; update.updated = DateTime.Now; Database.SubmitChanges(); Database.Refresh( System.Data.Linq.RefreshMode.OverwriteCurrentValues, update ); } } beer = HublisherApp._allBrands.Where( x => x.name.Equals( beer.name ) ).FirstOrDefault(); if (!Exists( beer.id, establishmentId )) { this.Database.establishment_brands.InsertOnSubmit( new establishment_brand { brand_id = beer.id, establishment_id = establishmentId, deleted = false} ); this.Database.SubmitChanges(); } return beer; }
public ActionResult addBrand([Bind(Include = "id,name,activeFlag,createDate,updateDate,status")] brand brand, HttpPostedFileBase logoBrand) { if (logoBrand != null && logoBrand.ContentLength > 0) { string fileName = System.IO.Path.GetFileName(logoBrand.FileName); string urlImage = Server.MapPath("~/Image/" + fileName); } }
public ActionResult DeleteConfirmed(int id) { brand brand = db.brand.Find(id); db.brand.Remove(brand); db.SaveChanges(); return(RedirectToAction("Index")); }
public static brandDTO toBrandDTO(this brand b1) { return(new brandDTO() { id = b1.id, name = b1.name }); }
private void CreateItem() { DataAccess da = new DataAccess(); brand item = new brand(); item.name = edtName.Text; item.description = edtDescr.Text; da.BrandCreate(item); }
/// <summary> /// 根据品牌简称获取全称 /// </summary> /// <param name="brandName">品牌简称</param> /// <returns></returns> public string getBrandFullName(string brandName) { string s = string.Empty; pbxdatasourceDataContext context = new pbxdatasourceDataContext(); brand MdBrand = new brand(); s = (from c in context.brand where c.BrandAbridge == brandName select c).SingleOrDefault().BrandName; return(s); }
public void LoadItem(int id) { _id = id; DataAccess da = new DataAccess(); brand b = da.GetBrand(id); edtName.Text = b.name; edtDescr.Text = b.description; }
// delete brand record public ActionResult Delete(int id) { brand b = mc.brands.Single(x => x.brand_id == id); if (b == null) { return(HttpNotFound()); } return(View(b)); }
//farbe, räder, sitze, marke public car(farbe colour, brand marke, seat sitz, int sitzAnzahl) { mColour = colour; mMarke = marke; for (int i = 0; i < sitzAnzahl; i++) { mSeatArray[i] = sitz; } mSitzAnzahl = sitzAnzahl; }
private void EditItem() { DataAccess da = new DataAccess(); brand item = new brand(); item.id = _id; item.name = edtName.Text; item.description = edtDescr.Text; da.BrandEdit(item); }
// edit exsisting brand public ActionResult Edit(int id) { brand br = mc.brands.Single(s => s.brand_id == id); if (br == null) { return(HttpNotFound()); } return(View(br)); }
public ActionResult Edit([Bind(Include = "brand_id,brand_name")] brand brand) { if (ModelState.IsValid) { db.Entry(brand).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(brand)); }
/// <summary> /// Thread body /// </summary> /// <param name="state"></param> private void StartWork(object state) { BrandView brandView = state as BrandView; brand savedBrand = null; brand theBrand = new brand(); brandView.Merge(theBrand, editMode); AutoResetEvent nextOneAutoResetEvent = new AutoResetEvent(false); EventHandler <save_BrandCompletedEventArgs> h1 = (s, e) => { // TODO: handle error from server side savedBrand = e.Result; nextOneAutoResetEvent.Set(); }; Globals.WSClient.save_BrandCompleted += h1; Globals.WSClient.save_BrandAsync(theBrand); nextOneAutoResetEvent.WaitOne(); Globals.WSClient.save_BrandCompleted -= h1; // Check return result. If failure, savedCategory will be null if (savedBrand != null) { this.Dispatcher.BeginInvoke(delegate() { brandView.Restore(new BrandView(savedBrand)); }); } else { // Show error message ShopproHelper.ShowMessageWindow(this, "Error", "Fail to save this entry.", false); // Back to readonly mode this.Dispatcher.BeginInvoke(delegate() { // Restore cached UI data brandView.CancelEdit(); this.brandDataForm.CancelEdit(); }); } // No unsaved item this.editMode = DataFormMode.ReadOnly; // Hide busy indicator ShopproHelper.HideBusyIndicator(this); // Go to original page if necessary if (this.ContentPageCtx.GotoAddNewPage) { ShopproHelper.GoToContentPage(this, PageEnum.BrandListPage); } }
private void LoadModel(brand brand) { try { Model.ItemsSource = context.model.Where(i => i.brand == brand.id).ToList(); } catch (Exception ex) { MsgBox.Error(ex.Message); } }
public ActionResult Delete(brand brObj) { if (ModelState.IsValid) { mc.Entry(brObj).State = EntityState.Deleted; mc.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }
public ActionResult Create([Bind(Include = "brand_id,brand_name")] brand brand) { if (ModelState.IsValid) { db.brands.Add(brand); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(brand)); }
public void Update_Beer_Return_Updated() { var beer = new brand(); beer.country = "TEST country"; beer.description = "TEST descripion"; beer.maker = "Refsvindinge"; beer.name = "Ale nr 167111"; beer.type = "TEST type"; beer.volume = "TEST 22"; beer.id = 11; beer.deleted = false; _service.AddBeer( beer, 807 ); beer = _service.GetBeer( 11 ); Assert.IsNotNull( beer.updated ); }
public void Add_New_Beer_Return_New_Id() { var beer = new brand(); beer.country = "TEST country"; beer.description = "TEST descripion"; beer.maker = "Refsvindinge"; beer.name = "Ale nr 1673"; beer.type = "TEST type"; beer.volume = "TEST 22"; beer.deleted = false; var result = _service.AddBeer( beer, 807 ); //remember to change values that match something existing in the DB var b = _service.Database.brands.OrderByDescending( e => e.id ).First(); Assert.IsTrue( result.id == b.id ); Console.WriteLine( b.id ); Console.WriteLine( result.id ); }