Inheritance: MonoBehaviour
Beispiel #1
0
        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);
        }
Beispiel #3
0
 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));
 }
Beispiel #4
0
        private void Button2_Click(object sender, EventArgs e)
        {
            Form na = new title();

            na.Show();
            this.Hide();
        }
Beispiel #5
0
 //학생이 아님이 체크됐을 때 실행하는 것
 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());
        }
Beispiel #8
0
        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);
        }
Beispiel #9
0
        private void Button2_Click(object sender, EventArgs e)
        {
            Form l = new title();

            l.Show();
            this.Close();
        }
Beispiel #10
0
        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));
        }
Beispiel #11
0
        public ActionResult DeleteConfirmed(string id)
        {
            title title = db.titles.Find(id);

            db.titles.Remove(title);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Beispiel #12
0
 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));
 }
Beispiel #13
0
    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>();
    }
Beispiel #15
0
        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"));
        }
Beispiel #16
0
    void Update()
    {
        titleScript = GameObject.Find("Camera").GetComponent<title>();

        if ( titleScript.takeOff == true ) {

            movingSpeed += 0.9f;
            transform.Translate(Vector3.up * movingSpeed * Time.deltaTime);

        }
    }
Beispiel #17
0
        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));
        }
Beispiel #18
0
        public title GetById(Int64 id)
        {
            using (var context = this._context)
            {
                title entity = context.title.AsNoTracking()
                               .Where(x => x.id == id)
                               .FirstOrDefault();

                return(entity);
            }
        }
Beispiel #19
0
 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));
 }
Beispiel #20
0
        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);
 }
Beispiel #22
0
        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"));
        }
Beispiel #23
0
        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();
        }
Beispiel #24
0
        // 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");
 }
Beispiel #26
0
        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);
            }
        }
Beispiel #27
0
        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);
 }
Beispiel #30
0
        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);
        }
Beispiel #31
0
        // 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));
        }
Beispiel #32
0
        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);//じゃない場合はデフォルト起動
            }
        }
Beispiel #33
0
        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();
        }
Beispiel #34
0
			if ( trace.enabled() )  trace.log( title + ".getParameterMetaData()" );
Beispiel #35
0
        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;
            }
        }
Beispiel #36
0
        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();
        }
Beispiel #37
0
        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();
        }
Beispiel #38
0
 return new DoubleFrame(title,25,new Rect(25,40,Screen.width-50,Screen.height-80));
Beispiel #39
0
 /// <sumamary>
 /// Save title
 /// </sumamary>
 public static void SaveTitle(title objTitle)
 {
     BrightPlatformEntities objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection);
     objBrightPlatformEntity.titles.AddObject(objTitle);
     objBrightPlatformEntity.SaveChanges();
 }