//Thêm dữ liệu vào sql
public void Createmember(DemoModels create)
{
int disable = 0;
if (create.Disable == true)
disable = 1;
HoiVien create1 = new HoiVien();
create1.DivisionID = create.DivisionID;
create1.MemberID = create.MemberID;
create1.MemberName = create.MemberName;
create1.ShortName = create.ShortName;
create1.Address = create.Address;
create1.Identify = create.Identify;
create1.Phone = create.Phone;
create1.Tel = create.Tel;
create1.Fax = create.Fax;
create1.Email = create.Email;
create1.Birthday = create.Birthday;
create1.Website = create.Website;
create1.Mailbox = create.Mailbox;
create1.AreaName = create.AreaName;
create1.CityName = create.CityName;
create1.CountryName = create.CountryName;
create1.WardName = create.WardName;
create1.CountyName = create.CountyName;
create1.Disable = Convert.ToByte(disable);
MyConnectionDB.GetInstance().Insert(create1);
}
public string create(HoiVien hv)
{
var db = new PetaPoco.Database("MyConnection");
hv.APK = Guid.NewGuid();
try { db.Insert(hv); }
catch (Exception e)
{
if (e.Message.Contains("Violation of PRIMARY KEY"))
{
return "pk";
}
return e.ToString();
}
return "ok";
}
private void add()
{
try
{
dataDataContext db = new dataDataContext();
HoiVien hv = new HoiVien();
hv.MaHV = txtMaDocGia.Text;
hv.TenHoiVien = txtHoten.Text;
hv.MaLoaiHV = cbblhv.SelectedValue.ToString();
hv.MaSV = txtmssv.Text;
hv.CMND = txtCMND.Text;
hv.DiaChi = txtDiaChi.Text;
hv.Email = txtEmail.Text;
if (checkBox1.Checked == true)
{
hv.GioiTinh = true;
}
else
{
hv.GioiTinh = false;
}
hv.SDT = txtDienThoai.Text;
string theDate = dateNgayLapThe.Value.ToString("yyyy-MM-dd");
DateTime dt = dateNgayLapThe.Value.Date;
DateTime dt2 = dateNgaySinh.Value.Date;
hv.NgayLapThe = dt;
hv.NgaySinh = dt2;
// MessageBox.Show(hv.MaHV.ToString() + hv.GioiTinh.ToString() + hv.NgaySinh.ToString() + hv.NgayLapThe.ToString() + hv.MaLoaiHV.ToString());
db.HoiViens.InsertOnSubmit(hv);
db.SubmitChanges();
MessageBox.Show("Thêm thành công");
reload();
}
catch (Exception ex)
{
MessageBox.Show("xay ra loi", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void SuaDuLieu(HoiVien et)
{
sql.SuaDuLieu(et);
}
public void ThemDuLieu(HoiVien et)
{
sql.ThemDuLieu(et);
}
public ActionResult srch(HoiVien srch, int page)
{
TempData["search"] = srch;
var s = Search1(page);
Session["page"] = s.TotalPages;
return Json(s.Items);
}
public void SuaDuLieu(HoiVien et)
{
cn.ThucThiCauLenhSQL(@"UPDATE HOIVIEN SET DiaChi =N'" + et.Diachi + "',GioiTinh=N'" + et.Gioitinh + "', Ho =N'" + et.Ho + "', Ten =N'" + et.Ten + "' where MaHoiVien='" + et.Mahoivien + "'");
}
public void ThemDuLieu(HoiVien et)
{
cn.ThucThiCauLenhSQL(@"INSERT INTO HOIVIEN (MaHoiVien,DiaChi,GioiTinh,Ho,Ten,SoDT,Email) VALUES ('" + et.Mahoivien + "',N'" + et.Diachi + "',N'" + et.Gioitinh + "',N'" + et.Ho + "',N'" + et.Ten + "','" + et.Sodt + "','" + et.Email + "')");
}
//Xư lý lấy thông tin lọc dữ liệu từ view
public void srch(HoiVien srch)
{
TempData["search"] = srch;//Gán thông tin để lọc dữ liệu vào tempData chờ xử lý
}
