public async Task <IHttpActionResult> PutChuyenKhoa(int id, ChuyenKhoa chuyenKhoa) { if (id != chuyenKhoa.IDChuyenKhoa) { return(BadRequest()); } db.Entry(chuyenKhoa).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ChuyenKhoaExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public override void SaveModel() { if (this.Validation()) { ChuyenKhoa chuyenKhoa = (ChuyenKhoa)this.GetModel(); SqlResultType flag; if (this.actions == Common.Common.Class.Actions.AddNew) { flag = new SpecialtyProvider().Insert(chuyenKhoa); } else { flag = new SpecialtyProvider().Update(chuyenKhoa); } SaveCompleteEventArgs args = new SaveCompleteEventArgs(); args.Result = flag == SqlResultType.OK; args.Model = chuyenKhoa; args.Message = "Không lưu được thông tin chuyên khoa"; this.SaveCompleteSuccess(chuyenKhoa, args); } else { XtraMessageBox.Show("Thông tin chưa hợp lệ kiểm tra lại thông tin."); } }
private void CommandBinding_Executed_Them(object sender, ExecutedRoutedEventArgs e) { ChuyenKhoa t = xl.tim(txtMaChuyenKhoa.Text); if (t != null) { MessageBox.Show("Đã có phòng khoa này trong CSDL!"); return; } ChuyenKhoa a = new ChuyenKhoa(); a.MaChuyenKhoa = txtMaChuyenKhoa.Text; a.TenChuyenKhoa = txtTenChuyenKhoa.Text; //a.MoTa = txtMoTa.Text; var message = validate(a); if (message != string.Empty) { MessageBox.Show(message, "Thông báo", MessageBoxButton.OK, MessageBoxImage.Warning); return; } xl.them(a); getDS(); }
public void xoa(string MaBN) { ChuyenKhoa a = tim(MaBN); if (a != null) { xoa(a); } }
void Load_BacSi() { ChuyenKhoa chuyenKhoa = new ChuyenKhoa(-1, _TenKhoa); List <BacSi> ListBacSi = Bacsi.BacSi_Select(chuyenKhoa); foreach (BacSi item in ListBacSi) { lsvBacSi.Items.Add(item.TenBS); } }
public async Task <IHttpActionResult> GetChuyenKhoa(int id) { ChuyenKhoa chuyenKhoa = await db.ChuyenKhoas.FindAsync(id); if (chuyenKhoa == null) { return(NotFound()); } return(Ok(chuyenKhoa)); }
public override object GetModel() { ChuyenKhoa chuyenKhoa = new ChuyenKhoa(); chuyenKhoa.MaCK = Convert.ToInt32(txtID.EditValue); chuyenKhoa.TenCK = txtName.Text; chuyenKhoa.MaQuyetDinh = txtCode.Text; chuyenKhoa.TenChiTiet = txtDetails.Text; chuyenKhoa.Status = ckbStatus.Checked ? 1 : 0; return(chuyenKhoa); }
public void Sua(ChuyenKhoa a) { ChuyenKhoa b = tim(a.MaChuyenKhoa); if (b != null) { b.MaChuyenKhoa = a.MaChuyenKhoa; b.TenChuyenKhoa = a.TenChuyenKhoa; // b.MoTa = a.MoTa; tc.capnhat(); } }
public List <BacSi> BacSi_Select(ChuyenKhoa chuyenKhoa) { List <BacSi> ListBacSi = new List <BacSi>(); string query = "BacSi_Select_Khoa '" + chuyenKhoa.TenKhoa + "'"; DataTable result = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in result.Rows) { BacSi Bacsi = new BacSi(item); ListBacSi.Add(Bacsi); } return(ListBacSi); }
public List <ChuyenKhoa> ChuyenKhoa_Select() { List <ChuyenKhoa> ListChuyenKhoa = new List <ChuyenKhoa>(); string query = "sp_SelectChuyenKhoa"; DataTable result = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in result.Rows) { ChuyenKhoa chuyenKhoa = new ChuyenKhoa(item); ListChuyenKhoa.Add(chuyenKhoa); } return(ListChuyenKhoa); }
public List <ChuyenKhoa> getDSChuyenKhoaFirstNull() { List <ChuyenKhoa> ds = new List <ChuyenKhoa>(); ChuyenKhoa a = new ChuyenKhoa(); a.IDChuyenKhoa = -1; a.MaChuyenKhoa = "null"; a.TenChuyenKhoa = "Chọn chuyên khoa"; ds.Add(a); ds.AddRange(getDSChuyenKhoa()); return(ds); }
public async Task <IHttpActionResult> DeleteChuyenKhoa(int id) { ChuyenKhoa chuyenKhoa = await db.ChuyenKhoas.FindAsync(id); if (chuyenKhoa == null) { return(NotFound()); } db.ChuyenKhoas.Remove(chuyenKhoa); await db.SaveChangesAsync(); return(Ok(chuyenKhoa)); }
private string validate(ChuyenKhoa ck) { var message = string.Empty; if (string.IsNullOrEmpty(ck.MaChuyenKhoa)) { return(message = "Vui lòng nhập Mã chuyên khoa."); } if (string.IsNullOrEmpty(ck.TenChuyenKhoa)) { return(message = "Vui lòng nhập Tên chuyên khoa."); } return(message); }
public SqlResultType Delete(ChuyenKhoa ChuyenKhoa) { try { this.sqlHelper.CommandType = CommandType.StoredProcedure; object result = this.sqlHelper.ExecuteScalar("DeleteChuyenKhoa", new string[] { "@MaChuyenKhoa" }, new object[] { ChuyenKhoa.MaCK }); int kq = Convert.ToInt32(result); return(this.GetResult(kq)); } catch (Exception ex) { log.Error("Delete CHUYEN KHOA", ex); return(SqlResultType.Exception); } }
private void BindingModel() { this.dxErrorProviderModel.ClearErrors(); this.isUpdated = false; this.isEdited = false; ChuyenKhoa chuyenKhoa = (ChuyenKhoa)this.Model; txtID.Text = chuyenKhoa.MaCK.ToString(); txtName.Text = chuyenKhoa.TenCK; txtCode.Text = chuyenKhoa.MaQuyetDinh; txtDetails.Text = chuyenKhoa.TenChiTiet; ckbStatus.Checked = chuyenKhoa.Status == 1; txtID.ReadOnly = true; this.isUpdated = true; }
public async Task <IHttpActionResult> PostChuyenKhoa(ChuyenKhoa chuyenKhoa) { chuyenKhoa = new ChuyenKhoa { Avatar = "", IDChuyenKhoa = 0, Name = chuyenKhoa.Name, PhongBans = null, Status = "ACTIVE", TimeUse = null }; db.ChuyenKhoas.Add(chuyenKhoa); return(Ok(await db.SaveChangesAsync() > 0)); }
void Load_BacSi() { ChuyenKhoa chuyenKhoa = new ChuyenKhoa(-1, _TenKhoa); List <BacSi> ListBacSi = Bacsi.BacSi_Select(chuyenKhoa); foreach (BacSi item in ListBacSi) { lvBacSi.Items.Add(item.TenBS); } //DataTable data = Bacsi.ViewBS(); //for(int i= 0;i<data.Rows.Count;i++) //{ // lvBacSi.Items.Add(data.Rows[i]["TenBS"].ToString()); //} }
private void btnLuu_Click(object sender, EventArgs e) { if (KTLuu()) { switch (TTLuu) { case 1: Mack = Convert.ToInt32(txtMaCK.Text); var ma = dataContext.ChuyenKhoas.Where(p => p.MaCK == (Mack)).ToList(); if (ma.Count > 0) { MessageBox.Show("Mã chuyên khoa đã có, vui lòng nhập mã khác"); } else { ChuyenKhoa ck = new ChuyenKhoa(); ck.MaCK = Convert.ToInt32(txtMaCK.Text); ck.TenCK = txtTenCK.Text; ck.TenChiTiet = txtTenCT.Text; ck.Status = cbo_Status.SelectedIndex; dataContext.ChuyenKhoas.Add(ck); dataContext.SaveChanges(); enableControl(false); MessageBox.Show("Lưu thành công!"); } break; case 2: if (!string.IsNullOrEmpty(txtMaCK.Text)) { Mack = Convert.ToInt32(txtMaCK.Text); ChuyenKhoa cksua = dataContext.ChuyenKhoas.Single(p => p.MaCK == (Mack)); cksua.MaCK = Convert.ToInt32(txtMaCK.Text); cksua.TenCK = txtTenCK.Text; cksua.TenChiTiet = txtTenCT.Text; cksua.Status = cbo_Status.SelectedIndex; dataContext.SaveChanges(); MessageBox.Show("Lưu thành công!"); enableControl(false); } break; } _lck = dataContext.ChuyenKhoas.OrderBy(p => p.TenCK).ToList(); grcChuyenKhoa.DataSource = _lck.ToList(); } }
public SqlResultType Update(ChuyenKhoa chuyenKhoa) { try { this.sqlHelper.CommandType = CommandType.StoredProcedure; object result = this.sqlHelper.ExecuteScalar("UpdateChuyenKhoa", new string[] { "@MaChuyenKhoa", "@TenChuyenKhoa", "@TenChiTiet", "@Status", "@MaQuyetDinh" }, new object[] { chuyenKhoa.MaCK, chuyenKhoa.TenCK, chuyenKhoa.TenChiTiet, chuyenKhoa.Status, chuyenKhoa.MaQuyetDinh } ); int kq = Convert.ToInt32(result); return(this.GetResult(kq)); } catch (Exception ex) { log.Error("Update CHUYEN KHOA", ex); return(SqlResultType.Exception); } }
public override bool DeleteModel() { if (this.Model != null) { if (XtraMessageBox.Show("Bạn có muốn xóa bản ghi này không?", "Xóa bản ghi", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.OK) { ChuyenKhoa ChuyenKhoa = (ChuyenKhoa)this.Model; SqlResultType resultType = new SpecialtyProvider().Delete(ChuyenKhoa); if (resultType == SqlResultType.OK) { this.ClearModel(); this.DisabledLayout(true); } return(resultType == SqlResultType.OK); } } return(false); }
private void CommandBinding_Executed_Sua(object sender, ExecutedRoutedEventArgs e) { ChuyenKhoa a = new ChuyenKhoa(); a.MaChuyenKhoa = txtMaChuyenKhoa.Text; a.TenChuyenKhoa = txtTenChuyenKhoa.Text; var message = validate(a); if (message != string.Empty) { MessageBox.Show(message, "Thông báo", MessageBoxButton.OK, MessageBoxImage.Warning); return; } xl.Sua(a); getDS(); }
protected List <ChuyenKhoa> DataReaderToList(SqlDataReader dataReader) { try { List <ChuyenKhoa> dsChuyenKhoa = new List <ChuyenKhoa>(); while (dataReader.Read()) { ChuyenKhoa chuyenKhoa = new ChuyenKhoa(); chuyenKhoa.MaCK = Convert.ToInt32(dataReader["MaChuyenKhoa"].ToString()); chuyenKhoa.TenCK = dataReader["TenChuyenKhoa"].ToString(); chuyenKhoa.TenChiTiet = dataReader["TenChiTiet"].ToString(); chuyenKhoa.Status = DataConverter.StringToInt(dataReader["Status"].ToString()); chuyenKhoa.MaQuyetDinh = dataReader["MaQuyetDinh"].ToString(); dsChuyenKhoa.Add(chuyenKhoa); } return(dsChuyenKhoa); } catch (Exception ex) { log.Error("Generate CHUYEN KHOA", ex); return(null); } }
public void xoa(ChuyenKhoa a) { tc.getDSChuyenKhoa().DeleteOnSubmit(a); tc.capnhat(); }
public void them(ChuyenKhoa a) { tc.getDSChuyenKhoa().InsertOnSubmit(a); tc.capnhat(); }
public List <BacSi> BacSi_Select(ChuyenKhoa chuyenKhoa) { return(Bacsi.BacSi_Select(chuyenKhoa)); }