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));
}
