private void gridViewChild_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { int Id = 0; int.TryParse(gridViewChild.GetRowCellValue(gridViewChild.FocusedRowHandle, "Id").ToString(), out Id); if (Id == 0 && string.IsNullOrEmpty(gridViewChild.GetRowCellValue(gridViewChild.FocusedRowHandle, "SoundName").ToString())) { goto End; } else if (Id == 0 && string.IsNullOrEmpty(gridViewChild.GetRowCellValue(gridViewChild.FocusedRowHandle, "LanguageId").ToString())) { goto End; } if (Id != 0 && string.IsNullOrEmpty(gridViewChild.GetRowCellValue(gridViewChild.FocusedRowHandle, "SoundName").ToString())) { MessageBox.Show("Vui lòng nhập tên tệp âm thanh.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && string.IsNullOrEmpty(gridViewChild.GetRowCellValue(gridViewChild.FocusedRowHandle, "LanguageId").ToString())) { MessageBox.Show("Vui lòng chọn ngôn ngữ.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var obj = new Q_CounterSound(); obj.Id = Id; obj.SoundName = gridViewChild.GetRowCellValue(gridViewChild.FocusedRowHandle, "SoundName").ToString(); obj.LanguageId = (int)gridViewChild.GetRowCellValue(gridViewChild.FocusedRowHandle, "LanguageId"); obj.CounterId = counterId; obj.Note = gridViewChild.GetRowCellValue(gridViewChild.FocusedRowHandle, "Note") != null?gridViewChild.GetRowCellValue(gridViewChild.FocusedRowHandle, "Note").ToString() : ""; int kq = 0; if (obj.Id == 0) { kq = BLLCounterSound.Instance.Insert(obj); } else { kq = BLLCounterSound.Instance.Update(obj); } if (kq == 0) { MessageBox.Show("Tên tệp với ngôn ngữ này đã tồn tại. Xin nhập tên khác", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End; } else { GetGridChild(); } } } catch (Exception ex) { } End : { } }
public int Insert(string connectString, Q_CounterSound obj) { using (db = new QMSSystemEntities(connectString)) { if (!CheckExists(obj)) { db.Q_CounterSound.Add(obj); db.SaveChanges(); } return(obj.Id); } }
private void gridViewCounterSound_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { int Id = 0; int.TryParse(gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "Id").ToString(), out Id); if (Id == 0 && (string.IsNullOrEmpty(gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "CounterId").ToString()) || gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "CounterId").ToString() == "0")) { goto End; } else if (Id == 0 && (string.IsNullOrEmpty(gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "SoundId").ToString()) || gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "SoundId").ToString() == "0")) { goto End; } if (Id != 0 && (string.IsNullOrEmpty(gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "CounterId").ToString()) || gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "CounterId").ToString() == "0")) { MessageBox.Show("Vui lòng chọn Quầy.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && (string.IsNullOrEmpty(gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "SoundId").ToString()) || gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "SoundId").ToString() == "0")) { MessageBox.Show("Vui lòng chọn Âm thanh.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var obj = new Q_CounterSound(); obj.Id = Id; obj.CounterId = int.Parse(gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "CounterId").ToString()); obj.SoundName = gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "SoundId").ToString(); obj.Note = gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "Note") != null?gridViewCounterSound.GetRowCellValue(gridViewCounterSound.FocusedRowHandle, "Note").ToString() : ""; if (obj.Id == 0) { BLLCounterSound.Instance.Insert(connect, obj); } else { BLLCounterSound.Instance.Update(connect, obj); } GetGridCounterSound(); frmMain.lib_CounterSound = BLLCounterSound.Instance.Gets(connect); } } catch (Exception ex) { } End: { } }
public int Update(string connectString, Q_CounterSound model) { using (db = new QMSSystemEntities(connectString)) { var obj = db.Q_CounterSound.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id); if (obj != null) { if (!CheckExists(model)) { obj.SoundName = model.SoundName; obj.LanguageId = model.LanguageId; obj.Note = model.Note; obj.CounterId = model.CounterId; db.SaveChanges(); return(model.Id); } else { return(0); } } return(0); } }
private bool CheckExists(Q_CounterSound model) { var obj = db.Q_CounterSound.FirstOrDefault(x => !x.IsDeleted && x.Id != model.Id && x.CounterId == model.CounterId && x.LanguageId == model.LanguageId && x.SoundName.Trim().ToUpper().Equals(model.SoundName.Trim().ToUpper())); return(obj != null ? true : false); }