public object addTeacher(string magv, string hoten, string gt, string ns, string sdt, string mamon)
{
GiaoVien gv = new GiaoVien();
MonHoc mh = data.MonHocs.Single(a => a.MaMon == mamon);
gv.MaGV = magv;
gv.TenGV = hoten;
if (gt == "Nam")
{
gv.Gioitinh = false;
}
if (gt == "Nữ")
{
gv.Gioitinh = true;
}
gv.NgaySinh = DateTime.ParseExact(ns, "dd/MM/yyyy", CultureInfo.InvariantCulture);
gv.SoDT = sdt;
if (mh != null)
{
gv.MaMon = mamon;
}
data.GiaoViens.InsertOnSubmit(gv);
data.SubmitChanges();
return(1);
}
public object Delete(string ma)
{
var nv = from a in data.NhanViens
where a.MaNV == ma
select a;
data.NhanViens.DeleteAllOnSubmit(nv);
var nv1 = from b in data.PhanCongs
where b.MaNV == ma
select b;
data.PhanCongs.DeleteAllOnSubmit(nv1);
data.SubmitChanges();
return(1);
}
public object addChiTietSach(string ms, string ts, string tg, string tl, string nxb, string nn, string lv, int namxb, string vitri)
{
ChiTietSach chitietsach = new ChiTietSach();
//ViTriSach vt = data.ViTriSaches.Single(a => a.MaVT == vitri);
chitietsach.MaSach = ms;
chitietsach.TenSach = ts;
chitietsach.TacGia = tg;
chitietsach.TheLoai = tl;
chitietsach.NXB = nxb;
chitietsach.NgonNgu = nn;
chitietsach.LinhVuc = lv;
chitietsach.NamXB = namxb;
chitietsach.MaVT = vitri;
/*if(vt!= null)
* {
* chitietsach.MaVT = vitri;
* }*/
data.ChiTietSaches.InsertOnSubmit(chitietsach);
data.SubmitChanges();
return(1);
}
private void btnThêm_Click(object sender, EventArgs e)
{
DataDiagramDataContext data = new DataDiagramDataContext();
NhanVien NV = new NhanVien();
PhanCong PC = new PhanCong();
try
{
NV.MaNV = txtMaNV.Text;
NV.HoTen = txtHoTen.Text;
PC.MaNV = txtMaNV.Text;
PC.MaDA = txtDuAn.Text;
NV.Luong = Convert.ToInt32(txtLuong.Text);
NV.MaNGS = txtMaNGS.Text;
NV.MaPB = txtMaPB.Text;
if (rabtn_nam.Checked == true)
{
NV.GT = false;
}
if (rabtn_nu.Checked == true)
{
NV.GT = true;
}
NV.NS = Convert.ToDateTime(dtpBirtday.Value.ToShortDateString());
data.NhanViens.InsertOnSubmit(NV);
data.PhanCongs.InsertOnSubmit(PC);
data.SubmitChanges();
txtMaNV.Text = "";
txtHoTen.Text = "";
///txtNS.Text = "";
txtLuong.Text = "";
txtMaNGS.Text = "";
txtMaPB.Text = "";
dgvNhanVien.DataSource = bus.getData1();
dgvNhanVien.Refresh();
MessageBox.Show("Đã thêm thành công");
}
catch (Exception ex)
{
Console.Write(ex);
MessageBox.Show("Nhập liệu sai!!!");
}
}
public int add_Hdtt(string ma1, string ma2, string ma3, string ngay, string tien, string ma4)
{
int so1 = (from p in data.HDThanhToans where p.MaHDTT == ma1 select p).Count();
int so2 = (from p in data.HDThuePhongs where p.MaPhong == ma2 select p).Count();
int so3 = (from p in data.HDThuePhongs where p.MaKHThue == ma3 select p).Count();
int so4 = (from p in data.NhanViens where p.MaNV == ma4 select p).Count();
if (so1 == 0 && so2 == 1 && so3 == 1 && so4 == 1)
{
HDThanhToan tt = new HDThanhToan();
tt.MaHDTT = ma1;
tt.MaPhong = ma2;
tt.MaKHTT = ma3;
tt.NgayThanhToan = Convert.ToDateTime(ngay);
tt.TongTienThanhToan = Convert.ToInt32(tien);
tt.MaNV = ma4;
data.HDThanhToans.InsertOnSubmit(tt);
data.SubmitChanges();
return(1);
}
else
{
return(0);
}
}