//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ý }