public AddTitleSetting(SelectionProperty.eWriteMode WriteMode, List<CXTitle> pGridData, CXTitle pGridRow) { m_WriteMode = WriteMode; m_GridRow = pGridRow; m_GridData = pGridData; InitializeComponent(); this.PopulateLanguageComboList(); if (m_WriteMode == SelectionProperty.eWriteMode.Edit) { btnSave.Text = "Update"; if (m_GridRow != null) { txtTitle.Text = m_GridRow.name.ToString(); txtTitle.Tag = m_GridRow.id; txtSSYK.Text = m_GridRow.ssyk.ToString(); cboLanguage.EditValue = m_GridRow.language_id; } } }
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(); }