public TitleModel GetById(int id) { title entity = this._repository.GetById(id); TitleModel model = this.ConvertEntityToModel(entity); return(model); }
public ActionResult Create([Bind(Include = "title_id,title1,type,pub_id,price,advance,royalty,ytd_sales,notes,pubdate")] title titles) { if (ModelState.IsValid) { var test = db.titles.Find(titles.title_id); //find if title_id (prim key's) already exists if (test == null) { //they won't execute due to the reason that those fields are required. probably there is another way to set default values for required fields /*if (titles.type == "") titles.type = "UNDECIDED"; if (titles.pubdate == null) titles.pubdate = DateTime.Now; */ db.titles.Add(titles); try { db.SaveChanges(); } catch (Exception e) { return RedirectToAction("../Home/Error"); } } else //value already exists return RedirectToAction("../Home/Error"); return RedirectToAction("Index"); } ViewBag.pub_id = new SelectList(db.publishers, "pub_id", "pub_name", titles.pub_id); ViewBag.title_id = new SelectList(db.royscheds, "title_id", "title_id", titles.title_id); return View(titles); }
public ActionResult Edit([Bind(Include = "title_id,title1,type,pub_id,price,advance,royalty,ytd_sales,notes,pubdate")] title title, string[] author_ids) { if (ModelState.IsValid) { foreach (var ta in db.titleauthors.Where(ta => ta.title_id == title.title_id).ToList()) { db.titleauthors.Remove(ta); } foreach (var aid in author_ids) { titleauthor ta = new titleauthor(); ta.au_id = aid; ta.title_id = title.title_id; db.titleauthors.Add(ta); } db.Entry(title).State = EntityState.Modified; db.SaveChanges(); TempData["message_css"] = "alert alert-success"; TempData["message"] = "Successful"; return(RedirectToAction("Index")); } ViewBag.pub_id = new SelectList(db.publishers, "pub_id", "pub_name", title.pub_id); ViewBag.author_ids = new MultiSelectList(db.authors.Select(a => new { id = a.au_id, au_fulname = a.au_lname + " " + a.au_fname }), "id", "au_fulname"); TempData["message_css"] = "alert alert-danger"; TempData["message"] = "Invalid input"; return(View(title)); }
private void Button2_Click(object sender, EventArgs e) { Form na = new title(); na.Show(); this.Hide(); }
//학생이 아님이 체크됐을 때 실행하는 것 void unlessStudent(title t) { if (t == title.check) { checkInsertGrade.Sensitive = !checkIsTeacher.Active; checkInsertClass.Sensitive = !checkIsTeacher.Active; checkInsertUser.Sensitive = isFull(t); } else if (t == title.checkDoubt) { checkDoubtInsertGrade.Sensitive = !checkDoubtIsTeacher.Active; checkDoubtInsertClass.Sensitive = !checkDoubtIsTeacher.Active; checkDoubtInsertUser.Sensitive = isFull(t); } else if (t == title.uncheck) { uncheckInsertGrade.Sensitive = !uncheckIsTeacher.Active; uncheckInsertClass.Sensitive = !uncheckIsTeacher.Active; uncheckInsertUser.Sensitive = isFull(t); } else if (t == title.add) { addInsertGrade.Sensitive = !addIsTeacher.Active; addInsertClass.Sensitive = !addIsTeacher.Active; insertUser.Sensitive = isFull(t); } else if (t == title.delete) { delInsertGrade.Sensitive = !delIsTeacher.Active; delInsertClass.Sensitive = !delIsTeacher.Active; delInsertUserWithoutID.Sensitive = isFull(t); } }
public async Task <ActionResult <title> > PostTitle(title title) { _context.title.Add(title); await _context.SaveChangesAsync(); return(CreatedAtAction("Gettitle", new { id = title.titleId }, title)); }
public async Task <IActionResult> PutTitle(int id, title title) { if (id != title.titleId) { return(BadRequest()); } _context.Entry(title).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!titleExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public title ConvertModelToEntity(TitleModel model, int userId = -1) { title entity = new title(); if (model == null) { return(null); } entity.name = model.Name; entity.isCurrent = model.IsCurrent; if (model.Id > 0) { entity.id = model.Id; } if (userId > 0) { if (entity.id > 0) { entity.editedById = userId; entity.editedByDate = System.DateTime.Now; } else //entity.id <= 0 { entity.createdById = userId; entity.createdByDate = System.DateTime.Now; } } return(entity); }
private void Button2_Click(object sender, EventArgs e) { Form l = new title(); l.Show(); this.Close(); }
public ActionResult ShowBooks(author author) { title ta = new title(); var books = entities.sp_display().Where(t => t.title_id == ta.title_id).ToList().FirstOrDefault(); object obj = books.title; return(View(obj)); }
public ActionResult DeleteConfirmed(string id) { title title = db.titles.Find(id); db.titles.Remove(title); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ID,title_nm,title_descr")] title title) { if (ModelState.IsValid) { db.Entry(title).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(title)); }
void Update() { titleScript = GameObject.Find("Camera").GetComponent <title>(); if (titleScript.takeOff == true) { movingSpeed += 0.9f; transform.Translate(Vector3.up * movingSpeed * Time.deltaTime); } }
// Use this for initialization void Start() { // キャンセル用に初期位置を保存 Position = new Vector3(transform.position.x, transform.position.y, transform.position.z); m_inFlag = false; GameObject Entry_time = this.transform.parent.gameObject; m_Title = Entry_time.GetComponent <title>(); }
public ActionResult addTitle(TitleExt model) { if (model != null) { reflectModel.setValues(model); int res = 0; DateTime dt = DateTime.Now; try { var u = (user)Session["user"]; title t = new title() { uid = u.id, addtime = dt, art_title = model.art_title, keywords = model.keywords, state = 1, sort = 100, top = false }; TransactionOptions transOpt = new TransactionOptions(); //设置事务隔离级别 transOpt.IsolationLevel = IsolationLevel.ReadCommitted; // 设置事务超时时间为60秒 transOpt.Timeout = new TimeSpan(0, 0, 60); using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, transOpt)) { using (WeiQingEntities db = new WeiQingEntities()) { db.title.Add(t); res = db.SaveChanges(); // 保存帖子标题 if (res > 0) { var tid = db.title.Where(x => x.uid == u.id).Max(x => x.id); tiezi tz = new tiezi() { tid = tid, addtime = dt, uid = u.id, content = model.content, floor = 1, state = 1, uname = u.nick_name }; db.tiezi.Add(tz); res = db.SaveChanges(); // 保存帖子的内容,一楼 if (res > 0) { scope.Complete(); return(Content(res.ToString())); } } } } } catch (Exception ex) { return(Content(ex.Message)); } } return(Content("0")); }
void Update() { titleScript = GameObject.Find("Camera").GetComponent<title>(); if ( titleScript.takeOff == true ) { movingSpeed += 0.9f; transform.Translate(Vector3.up * movingSpeed * Time.deltaTime); } }
public ActionResult Create([Bind(Include = "ID,title_nm,title_descr")] title title) { if (ModelState.IsValid) { db.titles.Add(title); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(title)); }
public title GetById(Int64 id) { using (var context = this._context) { title entity = context.title.AsNoTracking() .Where(x => x.id == id) .FirstOrDefault(); return(entity); } }
public ActionResult Edit([Bind(Include = "title_id,title1,type,pub_id,price,advance,royalty,ytd_sales,notes,pubdate")] title title) { if (ModelState.IsValid) { db.Entry(title).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.pub_id = new SelectList(db.publishers, "pub_id", "pub_name", title.pub_id); ViewBag.title_id = new SelectList(db.royscheds, "title_id", "title_id", title.title_id); return(View(title)); }
public static void transformation(title tit, RenderWindow win, int i) { if (MainMenu.Versus_AI == true && tit.colorOfFigure == "black") { Table.actualDeck[i].Id_Of_Figure = "queen"; return; } transformIndex = i; inTransformation = true; float Ypos; if (tit.colorOfFigure == "white") { Ypos = tit.sp.Position.Y + title.titleHeight; } else { Ypos = tit.sp.Position.Y - title.titleHeight; } float Xpos = tit.sp.Position.X; uint width = title.titleWidth; uint height = title.titleHeight; Image im = new Image(width, height, new Color(255, 255, 255, 200)); Texture text = new Texture(im); Sprite sp1 = new Sprite(text); Sprite sp2 = new Sprite(text); Image imFQ = new Image(0, 0); Image imFH = new Image(0, 0); sp1.Position = new Vector2f(Xpos - title.titleWidth / 2, Ypos); sp2.Position = new Vector2f(Xpos + title.titleWidth / 2, Ypos); if (tit.colorOfFigure == "white") { imFQ = new Image(queen.WhiteImagePath); imFH = new Image(horse.WhiteImagePath); } else if (tit.colorOfFigure == "black") { imFQ = new Image(queen.BlackImagePath); imFH = new Image(horse.BlackImagePath); } Texture tFQ = new Texture(imFQ); Texture tFH = new Texture(imFH); Sprite sQ = new Sprite(tFQ); Sprite sH = new Sprite(tFH); sQ.Position = sp1.Position; sH.Position = sp2.Position; titles.Add(sp1); titles.Add(sp2); titles.Add(sQ); titles.Add(sH); }
// GET: titles/Details/5 public ActionResult Details(string id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } title titles = db.titles.Find(id); if (titles == null) { return HttpNotFound(); } return View(titles); }
public ActionResult DeleteConfirmed(string id) { title title = db.titles.Find(id); db.Database.ExecuteSqlCommand("DELETE FROM roysched WHERE title_id = @p0", title.title_id); db.sales.RemoveRange(title.sales); db.titleauthors.RemoveRange(title.titleauthors); db.titles.Remove(title); db.SaveChanges(); TempData["message_css"] = "alert alert-info"; TempData["message"] = "Deleted"; return(RedirectToAction("Index")); }
public void AddTitle(int employee_no, string employee_title) { title t = new title(); t.emp_no = employee_no; t.title1 = employee_title; var db = new newdataEntities(); db.titles.Add(t); db.SaveChanges(); db.Dispose(); }
// GET: Titles/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } title title = db.titles.Find(id); if (title == null) { return(HttpNotFound()); } return(View(title)); }
public ActionResult DeleteConfirmed(string id) { title titles = db.titles.Find(id); db.titles.Remove(titles); try { db.SaveChanges(); } catch (Exception e) { return RedirectToAction("../Home/Error"); } return RedirectToAction("Index"); }
public int Update(title entity) { if (entity == null) { return(-1); } using (var context = this._context) { context.MarkAsModified(entity); var result = context.SaveChanges(); return(entity.id); } }
public int Insert(title entity) { if (entity == null) { return(-1); } using (var context = this._context) { context.title.Add(entity); var result = context.SaveChanges(); return(result); } }
public void GetById_Test() { // Arrange TestKolgraphEntities context = new TestKolgraphEntities(); var repository = new TitleRepository(context); int id = 1; // Act title result = repository.GetById(id); // Assert Assert.IsNotNull(result); Assert.AreEqual(id, result.id); }
// GET: titles/Edit/5 public ActionResult Edit(string id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } title titles = db.titles.Find(id); if (titles == null) { return HttpNotFound(); } ViewBag.pub_id = new SelectList(db.publishers, "pub_id", "pub_name", titles.pub_id); ViewBag.title_id = new SelectList(db.royscheds, "title_id", "title_id", titles.title_id); return View(titles); }
public void ConvertModelToEntity_Test() { // Arrange TestKolgraphEntities context = new TestKolgraphEntities(); var service = new TitleService(); TitleModel model = GetTestModel(); // Act title entity = service.ConvertModelToEntity(model); // Assert Assert.IsNotNull(entity); Assert.AreEqual(entity.name, model.Name); Assert.AreEqual(entity.isCurrent, model.IsCurrent); }
// GET: Titles/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } title title = db.titles.Find(id); if (title == null) { return(HttpNotFound()); } ViewBag.pub_id = new SelectList(db.publishers, "pub_id", "pub_name", title.pub_id); ViewBag.author_ids = new MultiSelectList(db.authors.Select(a => new { id = a.au_id, au_fulname = a.au_lname + " " + a.au_fname }), "id", "au_fulname"); return(View(title)); }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); title form1 = new title();//タイトル Form3 form3 = new Form3();//メイン画面 Application.Run(form1);//タイトル走らせる //ここからタイトルが閉じたときの処理 if (form1.finfrag == false)//終了フラグが立ってない { if(Flag.loadfrag==true)//ロードフラグ立ってたらロードしてスタート saveload.load(); Application.Run(form3);//じゃない場合はデフォルト起動 } }
public void SaveMatch(Product Record, int matchedArticleID, int countryID) { // First get all data needed for matching. Ean, sku and title_synonym are seperate because they can store multiple values. article articleTable = _context.article.Where(a => a.id == matchedArticleID).Include(a => a.ean) .Include(a => a.sku) .Include(t => t.title.Select(ts => ts.title_synonym)) .FirstOrDefault(); // Loop through ean and sku collections to check if the ean or sku already exists. If not, add it if (!(articleTable.ean.Any(e => e.ean1 == Record.EAN)) && Record.EAN != "") _context.ean.Add(new ean { ean1 = Record.EAN, article_id = matchedArticleID }); if (!(articleTable.sku.Any(s => s.sku1 == Record.SKU)) && Record.SKU != "") _context.sku.Add(new sku { sku1 = Record.SKU, article_id = matchedArticleID }); title title = articleTable.title.Where(t => t.article_id == matchedArticleID && t.country_id == countryID).FirstOrDefault(); if (title == default(title)) { title addedTitle = new title { title1 = Record.Title, country_id = (short)countryID, article_id = matchedArticleID }; _context.title.Add(addedTitle); _context.title_synonym.Add(new title_synonym { occurrences = 1, title = Record.Title, title_id = addedTitle.id }); } else { // If any title synonym matches the title, up the occurences. if (articleTable.title.Any(t => t.title_synonym.Any(ts => ts.title.ToLower().Trim() == Record.Title.ToLower().Trim()))) { title_synonym ts = _context.title_synonym.Where(innerTs => innerTs.title.ToLower().Trim() == Record.Title.ToLower().Trim()).FirstOrDefault(); ts.occurrences++; // _context.Entry(ts).State = EntityState.Modified; if (ts.occurrences > articleTable.title.Max(t => t.title_synonym.Max(ts2 => ts2.occurrences))) { UpdateTitle(title.id, ts.title); } } // else, add the title to the synonyms. else { title_synonym ts = new title_synonym { occurrences = 1, title = Record.Title, title_id = title.id }; _context.title_synonym.Add(ts); } } _context.SaveChanges(); }
if ( trace.enabled() ) trace.log( title + ".getParameterMetaData()" );
private void btnSave_Click(object sender, EventArgs e) { if (ValidateEntries()) { DataTable dtSource = (DataTable)m_objRefGridView.GridControl.DataSource; if (dtSource != null) { title objTitle = null; int ssyk = 0; if (IsEditMode) { var titleid = (int)txtTitle.Tag; var row = dtSource.Select("id <> " + titleid.ToString() + " AND name = '" + txtTitle.Text.Trim().Replace("'", "''") + "'"); if (row != null && row.Length > 0) { MessageBox.Show("Title name already exists. Please try another name."); this.ParentForm.DialogResult = DialogResult.None; return; } else { DataRow dr = m_objRefGridView.GetFocusedDataRow(); if (dr != null) { dr.BeginEdit(); dr["name"] = txtTitle.Text.Trim(); if (int.TryParse(txtSSYK.Text.Trim(), out ssyk)) dr["ssyk"] = ssyk; else dr["ssyk"] = DBNull.Value; dr["language_id"] = (int)cboLanguage.EditValue; dr.EndEdit(); dr.AcceptChanges(); dr.Table.AcceptChanges(); } objTitle = BPContext.titles.FirstOrDefault(x => x.id == titleid); } } //add new title if (objTitle == null) { objTitle = new title(); objTitle.date_created = DateTime.Now; } objTitle.name = txtTitle.Text.Trim(); if (int.TryParse(txtSSYK.Text.Trim(), out ssyk)) objTitle.ssyk = ssyk; else objTitle.ssyk = null; objTitle.language_id = (int)cboLanguage.EditValue; //add new title if (!IsEditMode) { BPContext.titles.AddObject(objTitle); } BPContext.SaveChanges(); //add new datarow to datasouce if (!IsEditMode) { DataRow dr = dtSource.NewRow(); dr["id"] = objTitle.id; dr["name"] = objTitle.name; if (objTitle.ssyk == null) dr["ssyk"] = DBNull.Value; else dr["ssyk"] = objTitle.ssyk; dr["language_id"] = objTitle.language_id; dr["date_created"] = objTitle.date_created; dtSource.Rows.Add(dr); dtSource.AcceptChanges(); } m_objRefGridView.MoveLastVisible(); } } else { this.ParentForm.DialogResult = DialogResult.None; } }
public void SaveNewArticle(Product Record, int countryId) { country cou = _context.country.Where(c => c.id == countryId).FirstOrDefault(); webshop webshop = _context.webshop.Where(w => w.url == Record.Webshop).FirstOrDefault(); if (webshop == default(webshop)) { return; } if (cou == default(country)) { Console.WriteLine("Could not find country id {0}, aborting the save.", countryId); return; } article art = new article { description = Record.Description, brand = Record.Brand, image_loc = Record.Image_Loc }; // Do not modify this as this is neccessary to get the last id. _context.article.Add(art); ean ean = new ean { ean1 = Record.EAN, article_id = art.id }; _context.ean.Add(ean); title title = new title { title1 = Record.Title, country_id = (short)countryId, article_id = art.id, country = cou }; _context.title.Add(title); title_synonym ts = new title_synonym { title = Record.Title, title_id = title.id, occurrences = 1 }; _context.title_synonym.Add(ts); if (Record.SKU != "") { sku sku = new sku { sku1 = Record.SKU, article_id = art.id }; _context.sku.Add(sku); } decimal castedShipCost; decimal castedPrice; if (!(decimal.TryParse(Record.DeliveryCost, NumberStyles.Any, CultureInfo.InvariantCulture, out castedShipCost))) Console.WriteLine("Cannot cast shipping cost " + Record.DeliveryCost + " to decimal."); if (!(decimal.TryParse(Record.Price, NumberStyles.Any, CultureInfo.InvariantCulture, out castedPrice))) Console.WriteLine("Cannot cast price " + Record.Price + " to decimal."); product product = new product { article_id = art.id, ship_cost = castedShipCost, ship_time = Record.DeliveryTime, price = castedPrice, webshop_url = webshop.url, direct_link = Record.Url, affiliate_name = Record.Affiliate, affiliate_unique_id = Record.AffiliateProdID }; _context.product.Add(product); _context.SaveChanges(); }
private void btnSave_Click(object sender, EventArgs e) { WaitDialog.Show("Saving data ..."); if (ValidateEntries()) { using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { if (m_GridData != null) { title _eftTitle = null; int _ssyk = 0; if (m_WriteMode == SelectionProperty.eWriteMode.Edit) { m_WriteMode = SelectionProperty.eWriteMode.Edit; //var row = GridData.Select(String.Format("id <> {0} AND name = '{1}'", GridRow.id, txtTitle.Text.Trim().Replace("'", "''"))); //if (row != null && row.Length > 0) { string _Title = txtTitle.Text.Trim().Replace("'", "''"); int _Existing = m_GridData.Where(i => i.name == _Title && i.id != m_GridRow.id).Count(); if (_Existing > 0) { BrightVision.Common.UI.NotificationDialog.Warning("Bright Sales", "Title name already exists. Please try another name."); this.ParentForm.DialogResult = DialogResult.None; return; } _eftTitle = _efDbContext.titles.FirstOrDefault(i => i.id == m_GridRow.id); if (_eftTitle != null) { _eftTitle.name = txtTitle.Text.Trim(); _eftTitle.language_id = Convert.ToInt32(cboLanguage.EditValue); _eftTitle.ssyk = null; if (int.TryParse(txtSSYK.Text.Trim(), out _ssyk)) _eftTitle.ssyk = _ssyk; _efDbContext.SaveChanges(); _efDbContext.Detach(_eftTitle); } } else { string _Title = txtTitle.Text.Trim().Replace("'", "''"); int _Existing = m_GridData.Where(i => i.name == _Title && i.id != m_GridRow.id).Count(); if (_Existing > 0) { BrightVision.Common.UI.NotificationDialog.Warning("Bright Sales", "Title name already exists. Please try another name."); this.ParentForm.DialogResult = DialogResult.None; return; } m_WriteMode = SelectionProperty.eWriteMode.New; _eftTitle = new title() { date_created = DateTime.Now, name = txtTitle.Text.Trim(), language_id = Convert.ToInt32(cboLanguage.EditValue), ssyk = null }; if (int.TryParse(txtSSYK.Text.Trim(), out _ssyk)) _eftTitle.ssyk = _ssyk; _efDbContext.titles.AddObject(_eftTitle); _efDbContext.SaveChanges(); _efDbContext.Detach(_eftTitle); } m_EventBus.Notify(new AddTitleSettingEvents.OnSave() { Title = _eftTitle, WriteMode = m_WriteMode }); //if (_eftTitle == null) { // _eftTitle = new title(); // _eftTitle.date_created = DateTime.Now; //} //objTitle.name = txtTitle.Text.Trim(); //if (int.TryParse(txtSSYK.Text.Trim(), out ssyk)) // objTitle.ssyk = ssyk; //else // objTitle.ssyk = null; //objTitle.language_id = (int)cboLanguage.EditValue; //add new title //if (!IsEditMode) //{ // BPContext.titles.AddObject(objTitle); //} //BPContext.SaveChanges(); //add new datarow to datasouce //if (!IsEditMode) //{ // DataRow dr = dtSource.NewRow(); // dr["id"] = objTitle.id; // dr["name"] = objTitle.name; // if (objTitle.ssyk == null) // dr["ssyk"] = DBNull.Value; // else // dr["ssyk"] = objTitle.ssyk; // dr["language_id"] = objTitle.language_id; // dr["date_created"] = objTitle.date_created; // dtSource.Rows.Add(dr); // dtSource.AcceptChanges(); //} //pGridTitles.MoveLastVisible(); } } } else { this.ParentForm.DialogResult = DialogResult.None; } WaitDialog.Close(); }
return new DoubleFrame(title,25,new Rect(25,40,Screen.width-50,Screen.height-80));
/// <sumamary> /// Save title /// </sumamary> public static void SaveTitle(title objTitle) { BrightPlatformEntities objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection); objBrightPlatformEntity.titles.AddObject(objTitle); objBrightPlatformEntity.SaveChanges(); }