private void btnOK_Click(object sender, EventArgs e)
{
DentalClinicDataContext dataContext = new DentalClinicDataContext();
Staff staff = new Staff();
staff.StaffId = txtMaNVBS.Text;
staff.fullName = txtTenNVBS.Text;
staff.dateOfBirth = dtpkNgaySinh.Value;
staff.PositionId = int.Parse(cbViTri.SelectedValue.ToString());
if (radioButton_Nam.Checked)
{
staff.gender = true;
}
if (radioButton_Nu.Checked)
{
staff.gender = true;
}
staff.address = txtDiaChi.Text;
staff.phone = txtSoDienThoai.Text;
staff.identityNumber = txtCMT.Text;
staff.experience = txtKinhNghiem.Text;
staff.email = txtEmail.Text;
staff.certificateId = txtBangCap.Text;
staff.note = txtGhiChu.Text;
dataContext.Staffs.InsertOnSubmit(staff);
dataContext.SubmitChanges();
click_CloseForm(sender, e);
this.Close();
}
private void btnDelete_Click(object sender, EventArgs e)
{
Medicine medicine = new Medicine();
medicine = dentalClinic.Medicines.Where(s => s.MedicineId == Cons.temp).Single();
dentalClinic.Medicines.DeleteOnSubmit(medicine);
dentalClinic.SubmitChanges();
UserControl_QuanLyThuoc_Load(sender, e);
}
private void btnDelete_Click(object sender, EventArgs e)
{
Service service = new Service();
service = dentalClinic.Services.Where(ma => ma.ServiceId == Cons.temp).Single();
dentalClinic.Services.DeleteOnSubmit(service);
dentalClinic.SubmitChanges();
UserControl_QuanLyDichVu_Load(sender, e);
}
private void bnt_OkThemLichHen_Click(object sender, EventArgs e)
{
Appointment appointment = new Appointment();
appointment = dataContext.Appointments.Where(a => a.AppointmentId == Cons.temp).Single();
dataContext.Appointments.DeleteOnSubmit(appointment);
dataContext.SubmitChanges();
click_CloseForm(sender, e);
this.Close();
}
private void btn_DangXuat_Click(object sender, EventArgs e)
{
WorkingStatus workingStatus = new WorkingStatus();
workingStatus = DataContext.WorkingStatus.Where(a => a.WorkingStatusId == Cons.WorkingStatusId).Single();
workingStatus.timeEnd = DateTime.Now;
DataContext.SubmitChanges();
this.Hide();
this.Close();
}
private void btnOk_Click(object sender, EventArgs e)
{
try
{
Service service = new Service();
service = dentalClinic.Services.Where(ma => ma.ServiceId == Cons.temp).Single();
service.nameService = txtTenDichVu.Text;
service.price = decimal.Parse(txtGiaTien.Text);
service.note = txtMoTa.Text;
dentalClinic.SubmitChanges();
click_CloseForm(sender, e);
this.Close();
}
catch
{
MessageBox.Show("Lỗi dữ liệu mời bạn kiểm tra lại", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnOk_Click(object sender, EventArgs e)
{
try
{
DentalClinicDataContext dentalClinic = new DentalClinicDataContext();
Service service = new Service();
service.ServiceId = txtDichVu.Text;
service.nameService = txtTenDichVu.Text;
service.price = decimal.Parse(txtGiaTien.Text);
service.note = txtMoTa.Text;
dentalClinic.Services.InsertOnSubmit(service);
dentalClinic.SubmitChanges();
click_CloseForm(sender, e);
this.Close();
}
catch (Exception)
{
MessageBox.Show("Yêu cầu nhập đúng định dạng và không trùng !");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
Medicine medicine = new Medicine();
medicine = dental.Medicines.Where(ma => ma.MedicineId == Cons.temp).Single();
medicine.MedicineId = txtMaThuoc.Text;
medicine.nameMedicine = txtTenThuoc.Text;
medicine.quantity = int.Parse(txtSoLuong.Text);
medicine.expirationDate = dtpkHanSuDung.Value;
medicine.unit = txtDonViTinh.Text;
medicine.price = decimal.Parse(txtDonGia.Text);
medicine.TypeMedicineId = cbLoaiThuoc.SelectedValue.ToString();
dental.SubmitChanges();
click_CloseForm(sender, e);
this.Close();
}
catch
{
MessageBox.Show("Lỗi dữ liệu mời bạn kiểm tra lại", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click_1(object sender, EventArgs e)
{
try
{
DentalClinicDataContext dental = new DentalClinicDataContext();
Medicine medicine = new Medicine();
medicine.MedicineId = txtMaThuoc.Text;
medicine.nameMedicine = txtTenThuoc.Text;
medicine.quantity = int.Parse(txtSoLuong.Text);
medicine.expirationDate = dtpkHanSuDung.Value;
medicine.unit = txtDonViTinh.Text;
medicine.TypeMedicineId = cbLoaiThuoc.SelectedValue.ToString();
medicine.price = decimal.Parse(txtDonGia.Text);
dental.Medicines.InsertOnSubmit(medicine);
dental.SubmitChanges();
click_CloseForm(sender, e);
this.Close();
}
catch (Exception)
{
MessageBox.Show("Yêu cầu nhập dúng định dạng!");
}
}
private void bnt_OkThemLichHen_Click(object sender, EventArgs e)
{
try
{
Appointment appointment = new Appointment();
appointment = dataContext.Appointments.Where(a => a.AppointmentId == Cons.temp).Single();
appointment.nameAppointment = txt_TenLichHen.Text;
appointment.scheduleDate = dtp_NgayHen.Value;
appointment.timeBegin = new TimeSpan(int.Parse(nud_GioBatDau.Value.ToString()), int.Parse(nud_PhutBatDau.Value.ToString()), 0);
appointment.timeEnd = new TimeSpan(int.Parse(nud_GioKetThuc.Value.ToString()), int.Parse(nud_GioKetThuc.Value.ToString()), 0);
appointment.note = txtNote.Text;
appointment.PatientId = cmbMaBenhNhan.SelectedValue.ToString();
dataContext.SubmitChanges();
click_CloseForm(sender, e);
this.Close();
}
catch
{
MessageBox.Show("Lỗi yêu cầu nhập đúng !");
}
}
private void bnt_OkThemLichHen_Click(object sender, EventArgs e)
{
try
{
Appointment appointment = new Appointment();
appointment.AppointmentId = ranDomId();
appointment.nameAppointment = txt_TenLichHen.Text;
appointment.scheduleDate = dtp_NgayHen.Value;
appointment.timeBegin = new TimeSpan(dtp_GioHen.Value.Hour, dtp_GioHen.Value.Minute, dtp_GioHen.Value.Second);
appointment.timeEnd = new TimeSpan(dtp_GioHen.Value.Hour, dtp_GioHen.Value.Minute, dtp_GioHen.Value.Second);
appointment.note = txt_Note.Text;
appointment.PatientId = cmbMaBenhNhan.SelectedValue.ToString();
dataContext.Appointments.InsertOnSubmit(appointment);
dataContext.SubmitChanges();
Cons.temp = "";
click_CloseForm(sender, e);
this.Close();
}
catch
{
MessageBox.Show("Lỗi yêu cầu nhập đúng !");
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
DentalClinicDataContext dataContext = new DentalClinicDataContext();
var query = from a in dataContext.Accounts
join s in dataContext.Staffs on a.StaffId equals s.StaffId
join p in dataContext.Positions on s.PositionId equals p.PositionId
select new
{
a.AccountId,
a.userName,
a.passWord,
p.PositionId
};
string username = txtUsername.Text;
string password = txtPassword.Text;
/*if (Login(username, password))
* {*/
if (txtUsername.Text != "" && txtPassword.Text != "")
{
foreach (var item in query.ToList())
{
if (item.userName == txtUsername.Text && item.passWord == txtPassword.Text)
{
Cons.permission = item.PositionId; //gắn quyền.
if (item.PositionId == 1)
{
// Chèn dữ liệu login
Cons.AccountID = item.AccountId;
WorkingStatus workingStatus = new WorkingStatus();
workingStatus.WorkingStatusId = Cons.ranDomId();
workingStatus.AccountId = item.AccountId;
workingStatus.timeBegin = DateTime.Now;
Cons.WorkingStatusId = workingStatus.WorkingStatusId; // luư lại.
dataContext.WorkingStatus.InsertOnSubmit(workingStatus);
dataContext.SubmitChanges();
CreateFormMain_Staff();
}
if (item.PositionId == 2)
{
// Chèn dữ liệu login
Cons.AccountID = item.AccountId;
WorkingStatus workingStatus = new WorkingStatus();
workingStatus.WorkingStatusId = Cons.ranDomId();
workingStatus.AccountId = item.AccountId;
workingStatus.timeBegin = DateTime.Now;
Cons.WorkingStatusId = workingStatus.WorkingStatusId; // luư lại.
dataContext.WorkingStatus.InsertOnSubmit(workingStatus);
dataContext.SubmitChanges();
CreateFormMain_Doctor();
}
if (item.PositionId == 3)
{
// Chèn dữ liệu login
Cons.AccountID = item.AccountId;
WorkingStatus workingStatus = new WorkingStatus();
workingStatus.WorkingStatusId = Cons.ranDomId();
workingStatus.AccountId = item.AccountId;
workingStatus.timeBegin = DateTime.Now;
Cons.WorkingStatusId = workingStatus.WorkingStatusId; // luư lại.
dataContext.WorkingStatus.InsertOnSubmit(workingStatus);
dataContext.SubmitChanges();
CreateFormMain_Manager();
}
return;
}
else
{
error_transition.Show(lbl_Error);
}
}
}
/*}*/
}