private void btAdd_Click(object sender, EventArgs e) { int CMND = 0, SDT = 0; string HoNV = "", TenNV = "", ChucVu = "", GhiChu = ""; HoNV = txtHoNV.Text.Trim(); TenNV = txtTenNV.Text.Trim(); ChucVu = txtChucNV.Text.Trim(); GhiChu = txtGhiChu.Text.Trim(); try { CMND = int.Parse(txtCMNDNV.Text); SDT = int.Parse(txtSDTNV.Text); } catch (FormatException ex) { MessageBox.Show("CMND hoặc SDT chưa nhập hoặc không hợp lệ, nếu thêm thành công mặc định giá trị này bằng 0"); } Employee emp = new Employee(HoNV, TenNV, ChucVu, CMND, SDT, GhiChu); try { int i = new EmployeeBUS().Add(emp); switch (i) { case -1: MessageBox.Show("Lỗi, không thể thêm dữ liệu"); break; case -2: MessageBox.Show("Phải nhập đầy đủ họ, tên và chức vụ"); break; default: TaiKhoan tk = new TaiKhoan(); tk.MaNV = i; tk.MatKhau = i.ToString(); db.TaiKhoans.InsertOnSubmit(tk); db.SubmitChanges(); MessageBox.Show("Đã thêm một nhân viên ở mã " + i); break; } LoadData(); } catch (SqlException ex) { MessageBox.Show(ex.Message); //throw; } }
private void btAdd_Click(object sender, EventArgs e) { List <ChiTietPhong> list = db.ChiTietPhongs.Where(c => c.MaPhong == int.Parse(cbbMaPhong.Text)).ToList(); bool available = false; foreach (ChiTietPhong item in list) { if (item.TrangThaiPhong == true) { available = true; } } if (available == true) { MessageBox.Show("Phòng đang bận"); } else { try { if (dtNgayDatPhong.Value > dtNgayNhanPhong.Value) { MessageBox.Show("Ngày đặt không lớn hơn ngày nhận phòng"); } else { ChiTietPhong ct = new ChiTietPhong(); ct.MaNV = int.Parse(txtMaNV.Text); ct.MaKH = int.Parse(cbbMaKH.Text); ct.MaPhong = int.Parse(cbbMaPhong.Text); ct.NgayDatPhong = dtNgayDatPhong.Value; ct.NgayNhanPhong = dtNgayNhanPhong.Value; ct.NgayTraPhong = new DateTime(8888, 12, 30); ct.LoaiHinhThue = txtLoaiHinhThue.Text; ct.ThanhTien = 0; ct.GhiChu = txtGhiChu.Text; ct.TrangThaiPhong = true; db.ChiTietPhongs.InsertOnSubmit(ct); db.SubmitChanges(); LoadData(); MessageBox.Show("Thêm thành công"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
public void EditAccount(string fullName, string address, string email, string pass, string phone, int department, int role) { var query = from employeeUpdate in db.Employees where employeeUpdate.FullName == fullName select employeeUpdate; foreach (Employee employee in query) { employee.EAddress = address; employee.Email = email; employee.Password = pass; employee.Phone = phone; employee.DepartmentID = department; employee.RoleID = role; } try { db.SubmitChanges(); MessageBox.Show("Data Updated"); } catch (Exception e) { MessageBox.Show(e.ToString()); } }
private void btAdd_Click(object sender, EventArgs e) { try { Phong p = new Phong(); p.MaPhong = int.Parse(txtMaPhong.Text); p.SoGiuong = int.Parse(txtSoGiuong.Text); p.GhiChu = txtGhiChu.Text; db.Phongs.InsertOnSubmit(p); db.SubmitChanges(); MessageBox.Show("Thêm thành công"); } catch (Exception ex) { MessageBox.Show(ex.Message); } LoadData(); }
public static void SetWorkerActive(string id) { Int32 _id = Int32.Parse(id); LINQDataContext db = new LINQDataContext(); var result = (from e in db.PERSONEL where e.id_personel.Equals(_id) select e).First(); result.active = "T"; db.SubmitChanges(); }
public static void DeleteCustomer(string id) { LINQDataContext db = new LINQDataContext(); //Get customer to Delete CLIENT delClient = db.CLIENT.First(e => e.id_client.Equals(id)); //Delete Employee db.CLIENT.DeleteOnSubmit(delClient); //Save changes to Database. db.SubmitChanges(); }
public void AddAccount(Employee employee) { db.Employees.InsertOnSubmit(employee); try { db.SubmitChanges(); MessageBox.Show("Data Inserted"); } catch (Exception) { MessageBox.Show("Error"); } }
public static void SaveRequestDetails(Int32 id, string desc, string status, string result, DateTime expDate) { LINQDataContext db = new LINQDataContext(); REQUEST request = (from e in db.REQUEST where e.id_request.Equals(id) select e).SingleOrDefault(); request.description = desc; request.status = status; request.result = result; request.date_reg = expDate; db.SubmitChanges(); }
public static void DeleteRequestsActivity(Int32 id) { LINQDataContext db = new LINQDataContext(); var activityToDelete = from e in db.ACTIVITY where e.id_request == id select e; foreach (var activity in activityToDelete) { db.ACTIVITY.DeleteOnSubmit(activity); } db.SubmitChanges(); }
public static void EditActivity(string id, DateTime final, string status, string result) { //Create new Employee LINQDataContext db = new LINQDataContext(); ACTIVITY Act = db.ACTIVITY.First(e => e.id_activity.Equals(id)); Act.date_fn_cn = final; Act.status = status; Act.result = result; //Edit Activity to database db.SubmitChanges(); return; }
public static void DeleteCurrentRequest() { LINQDataContext db = new LINQDataContext(); var number = GetRequestId(); var requests = from e in db.REQUEST where e.id_request.Equals(number) select e; foreach (var request in requests) { db.REQUEST.DeleteOnSubmit(request); } db.SubmitChanges(); }
public static void AddActivity(Int32 id, Int32 sn, string ad, string dc, DateTime regDate, DateTime exDate) { LINQDataContext db = new LINQDataContext(); ACTIVITY activity = new ACTIVITY(); activity.id_request = id; activity.sequence_nb = sn; activity.act_dict = ad; activity.description = dc; activity.date_reg = regDate; activity.date_fn_cn = exDate; activity.status = "ACT"; db.ACTIVITY.InsertOnSubmit(activity); db.SubmitChanges(); }
public static void EditCustomer(string id, string name, string fname, string lname, string tel) { //Edit LINQDataContext db = new LINQDataContext(); CLIENT newClient = db.CLIENT.First(e => e.id_client.Equals(id)); newClient.name = name; newClient.first_name = fname; newClient.last_name = lname; newClient.tel = tel; //Save changes to Database. db.SubmitChanges(); return; }
public static void EditPersonel(string id, string fname, string lname, string password, string active) { //Create new Employee LINQDataContext db = new LINQDataContext(); PERSONEL Personel = db.PERSONEL.First(e => e.id_personel.Equals(id)); Personel.first_name = fname; Personel.last_name = lname; Personel.password = password; Personel.active = active; //Edit Employee to database db.SubmitChanges(); return; }
public static void AddVehicle(string nr_object, string name, string obj_type, int id_client) { //Create new Employee LINQDataContext db = new LINQDataContext(); OBJECT newVehicle = new OBJECT(); newVehicle.nr_object = nr_object; newVehicle.name = name; newVehicle.obj_type = obj_type; newVehicle.id_client = id_client; //Add new Customer to database db.OBJECT.InsertOnSubmit(newVehicle); //Save changes to Database. db.SubmitChanges(); }
public static void CreateEmptyRequest() { LINQDataContext db = new LINQDataContext(); REQUEST request = new REQUEST(); request.id_request = GetRequestId(); request.description = ""; request.status = ""; request.result = ""; request.date_reg = DateTime.Today; request.date_fn_cn = DateTime.Today; request.id_personel = 1; request.nr_object = GetDefaultVehicle(); // Alles klar db.REQUEST.InsertOnSubmit(request); db.SubmitChanges(); }
public static void FulfillRequestInformation(Int32 idre, string desc, string stat, string resu, DateTime datr, DateTime datf, Int32 idpe, string nrob) { LINQDataContext db = new LINQDataContext(); REQUEST request = (from e in db.REQUEST where e.id_request.Equals(idre) select e).SingleOrDefault(); request.description = desc; request.status = stat; request.result = resu; request.date_reg = datr; request.date_fn_cn = datf; request.id_personel = idpe; request.nr_object = nrob; db.SubmitChanges(); }
public static void AddCustomer(string name, string fname, string lname, string tel) { //Create new Employee LINQDataContext db = new LINQDataContext(); CLIENT newClient = new CLIENT(); newClient.name = name; newClient.first_name = fname; newClient.last_name = lname; newClient.tel = tel; //Add new Customer to database db.CLIENT.InsertOnSubmit(newClient); //Save changes to Database. db.SubmitChanges(); return; }
public static void AddObject(string nr, string name, Int32 id, string type) { //Create new Employee LINQDataContext db = new LINQDataContext(); OBJECT newObject = new OBJECT(); newObject.nr_object = nr; newObject.name = name; newObject.id_client = id; newObject.obj_type = type; //Add new Customer to database db.OBJECT.InsertOnSubmit(newObject); //Save changes to Database. db.SubmitChanges(); return; }
private void btXacNhan_Click(object sender, EventArgs e) { if (db.TaiKhoans.Where(c => c.MaNV == MaNV).FirstOrDefault().MatKhau != txtMatKhauCu.Text) { MessageBox.Show("Sai mật khẩu, yêu cầu nhập lại"); } else if (txtMatKhauMoi.Text != txtXacNhanMatKhau.Text) { MessageBox.Show("Mật khẩu mới không khớp với mật khẩu xác nhận"); } else { TaiKhoan tk = db.TaiKhoans.Where(c => c.MaNV == MaNV).FirstOrDefault(); tk.MatKhau = txtMatKhauMoi.Text; db.SubmitChanges(); MessageBox.Show("Đổi mật khẩu thành công"); this.Close(); } }
public void DeleteAccount(string fullName) { var query = from deleteEmployee in db.Employees where deleteEmployee.FullName == fullName select deleteEmployee; foreach (var command in query) { db.Employees.DeleteOnSubmit(command); } try { db.SubmitChanges(); MessageBox.Show("Data Deleted"); } catch (Exception e) { MessageBox.Show(e.ToString()); } }
public static void AddPersonel(string fname, string lname, string login, string role, string password, string active) { //Create new Employee LINQDataContext db = new LINQDataContext(); PERSONEL newPersonel = new PERSONEL(); newPersonel.first_name = fname; newPersonel.last_name = lname; newPersonel.login = login; newPersonel.password = password; newPersonel.role = role; newPersonel.active = active; //Add new Employee to database db.PERSONEL.InsertOnSubmit(newPersonel); //Save changes to Database. db.SubmitChanges(); return; }
public static void UpdateActivity(Int32 id, Int32 sn, string dc, string wo, string status, DateTime dreg, DateTime dfc, string act) { //Int32 _idPersonel = 0; LINQDataContext db = new LINQDataContext(); var result = (from e in db.ACTIVITY where e.id_activity == id && e.sequence_nb == sn select e).First(); var result1 = (from e in db.PERSONEL where e.last_name.ToString().Equals(wo) select e).First(); result.id_personel = result1.id_personel; result.description = dc; result.status = status; result.date_reg = dreg; result.date_fn_cn = dfc; result.act_dict = act; db.SubmitChanges(); }
private void GroupsForm_FormClosing(object sender, FormClosingEventArgs e) { dgvGroup[0, 0].Selected = true; // ---------------------------------------------------------------------------------------------- // var db = new LINQDataContext(); for (int rowCounter = 0; rowCounter < dgvGroup.RowCount - 1; rowCounter++) { try { // // search dgvGroup.rows in db.Groups // int ID_No = 0; int.TryParse(dgvGroup[0, rowCounter].Value.ToString(), out ID_No); // Define the query expression. var query = (from groups in db.Groups where groups.ID == ID_No select groups).SingleOrDefault(); if (query != null) // EDIT { try { int year = 0; query.Semester_Entry_Year = (int.TryParse(dgvGroup[1, rowCounter].Value.ToString(), out year)) ? year : 0; query.Semester_Entry_FS = (dgvGroup[2, rowCounter].Value != null) ? ((dgvGroup[2, rowCounter].Value.ToString() == colSemesterEntry.Items[0].ToString()) ? true : false) : true; // // find branch id in string ComboBox Select Academic field // int Branch_ID = 0; string bIND = (dgvGroup[3, rowCounter].Value != null) ? dgvGroup[3, rowCounter].Value.ToString() : ""; if (bIND == "") { throw new Exception("Pleas Select a Branch for the Group by Group's Id (" + ID_No + ")"); } string branch_id = ""; foreach (char ch in bIND.ToCharArray()) { if (char.IsDigit(ch)) { branch_id += ch.ToString(); } else { Branch_ID = int.Parse(branch_id); break; } } query.Branch_Selection = Branch_ID; // int size = 0; query.Size_No = (dgvGroup[4, rowCounter].Value != null) ? (int.TryParse(dgvGroup[4, rowCounter].Value.ToString(), out size)) ? size : 0 : 0; db.SubmitChanges(); } catch { } } else { // // find branch id in string ComboBox Select Academic field // int Branch_ID = 0; string bIND = (dgvGroup[3, rowCounter].Value != null) ? dgvGroup[3, rowCounter].Value.ToString() : ""; if (bIND == "") { throw new Exception("Pleas Select a Branch for the Group by Group's Id (" + ID_No + ")"); } string branch_id = ""; foreach (char ch in bIND.ToCharArray()) { if (char.IsDigit(ch)) { branch_id += ch.ToString(); } else { Branch_ID = int.Parse(branch_id); break; } } // int size = 0; int year = 0; db.GroupsSave(ID_No, (int.TryParse(dgvGroup[1, rowCounter].Value.ToString(), out year)) ? year : 0, (dgvGroup[2, rowCounter].Value != null) ? ((dgvGroup[2, rowCounter].Value.ToString() == colSemesterEntry.Items[0].ToString()) ? true : false) : true, Branch_ID, (dgvGroup[4, rowCounter].Value != null) ? (int.TryParse(dgvGroup[4, rowCounter].Value.ToString(), out size)) ? size : 0 : 0); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
public Boolean InsertNew(Object any) { if (any is Recruiter) { Recruiter obj = (Recruiter)any; TabRecruiter rec = new TabRecruiter(); rec.fname = obj.FirstName; rec.lname = obj.LastName; rec.uname = obj.Username; rec.mobile = obj.MobileNumber; rec.email = obj.EmailAddress; rec.address = obj.Address; rec.designation = obj.Designation; rec.organisation = obj.Organisation; rec.dob = obj.DateOfBirth; rec.gender = obj.Gender; db.TabRecruiters.InsertOnSubmit(rec); db.SubmitChanges(); if (this.InserLogin(obj)) { return(true); } else { return(false); } } else if (any is Seeker) { Seeker obj = (Seeker)any; TabSeeker seek = new TabSeeker(); seek.fname = obj.FirstName; seek.lname = obj.LastName; seek.uname = obj.Username; seek.mobile = obj.MobileNumber; seek.email = obj.EmailAddress; seek.address = obj.Address; seek.dob = obj.DateOfBirth; seek.gender = obj.Gender; db.TabSeekers.InsertOnSubmit(seek); db.SubmitChanges(); foreach (var i in obj.skills) { db.TabSkills.InsertOnSubmit(new TabSkill() { uname = obj.Username + obj.skills.IndexOf(i), skill = i, user = obj.Username }); } db.SubmitChanges(); if (this.InserLogin(obj)) { return(true); } else { return(false); } } return(false); }