private void sbtnSave_Click(object sender, EventArgs e) { if (!txtMaThanhPho.Text.Trim().Equals("")) { if (add) { try { DataClasses1DataContext qlBH = new DataClasses1DataContext(); ThanhPho tp = new ThanhPho(); tp.ThanhPho1 = txtMaThanhPho.Text; tp.TenThanhPho = txtTenThanhPho.Text; qlBH.ThanhPhos.InsertOnSubmit(tp); qlBH.ThanhPhos.Context.SubmitChanges(); LoadData(); XtraMessageBox.Show("Done"); } catch { XtraMessageBox.Show("ErrorSave"); } } else { try { int r = dataGridViewThanhPho.CurrentCell.RowIndex; string strThanhpho = dataGridViewThanhPho.Rows[r].Cells[0].Value.ToString(); //SQL DataClasses1DataContext qlBH = new DataClasses1DataContext(); var tpQuery = (from tp in qlBH.ThanhPhos where tp.ThanhPho1 == strThanhpho select tp).SingleOrDefault(); if (tpQuery != null) { tpQuery.TenThanhPho = txtTenThanhPho.Text; qlBH.SubmitChanges(); LoadData(); } LoadData(); XtraMessageBox.Show("Edit DONE"); } catch { XtraMessageBox.Show("Edit error"); } } } else { XtraMessageBox.Show("Invalid ThanhPho"); txtMaThanhPho.Focus(); } }
partial void UpdateThanhPho(ThanhPho instance);
partial void DeleteThanhPho(ThanhPho instance);
partial void InsertThanhPho(ThanhPho instance);