public string getKisininİletisimBilgileri(int inputId) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(); var sql = from iletisim in db.iletisims where iletisim.kimlikid == inputId select new { iletisim.telefon, iletisim.mail, iletisim.yakinad, iletisim.yakinsoyad, iletisim.yakintel, iletisim.yakinderece, iletisim.adres }; if (sql.Count() == 0) { return(null); } else { return(JsonConvert.SerializeObject(sql, Newtonsoft.Json.Formatting.Indented)); } }
public string getapplogin(string tcno, string sifre) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(); var sql = from applogin in db.applogins join Kimlik in db.Kimliks on applogin.kimlikid equals Kimlik.kimlikid where Kimlik.tcno == tcno where applogin.sifre == sifre select new { applogin.apploginid, applogin.yetki, Kimlik.tcno, Kimlik.ad, Kimlik.soyad, Kimlik.dtarih, Kimlik.sehir, Kimlik.kangrubu }; if (sql.Count() == 0) { return(null); } else { return(JsonConvert.SerializeObject(sql, Newtonsoft.Json.Formatting.Indented)); } }
public Inventory() { InitializeComponent(); DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); DAL.Inventory iv = db.Inventories.FirstOrDefault(a => a.Inventory_ID.Equals("1")); Printer.Text = iv.Printer; Computer.Text = iv.Computer; Mouse.Text = iv.Mouse; Keyboard.Text = iv.Keyboard; Projector.Text = iv.Projector; Camera.Text = iv.Camera; WhiteBoard.Text = iv.Whiteboard; Marker.Text = iv.Marker; Pencil.Text = iv.Pencil; Soap.Text = iv.Clock; PaperBundle.Text = iv.Paperbundle; Pen.Text = iv.Pen; Duster.Text = iv.Duster; GeometryBox.Text = iv.Geometrybox; Ruler.Text = iv.Ruler; Chair.Text = iv.Chair; Bench.Text = iv.Bench; Table.Text = iv.Table; }
private void button_Click_2(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); AdmissionStudentIntImplementation a = new AdmissionStudentIntImplementation(); DAL.Admission_Student st = a.getAdmissionStudent(id.Text); if (st == null) { MessageBox.Show("Student Not Found"); } else { Admission_Exam_Result stResult = db.Admission_Exam_Results.FirstOrDefault(ee => ee.Admission_Student_ID.Equals(st.Admission_Student_ID)); fullName.Text = st.Full_Name; admissionSession.Text = st.Admission_Session; group.Text = st.Group; Total_mark.Text = "100"; if (stResult == null) { achievedMark.Text = ""; } else { achievedMark.Text = stResult.Viva_Exam_Mark; } } }
private async void search_Button_Click(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); var t = from a in db.Teachers where a.Teacher_ID == id.Text select a; //var ass = from a in db.Admission_Students // where a.Admission_Student_ID == // select a; bool flag = false; foreach (DAL.Teacher obj in t) { if (obj.Teacher_ID.Equals(id.Text)) { flag = true; Name.Text = obj.Full_Name; } } if (flag == false) { await this.ShowMessageAsync("Error", "ID not found."); Name.Text = ""; } }
public string getKisi(string inputQRTcno) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(); var sql = from Kimlik in db.Kimliks where Kimlik.tcno == inputQRTcno select new { Kimlik.kimlikid, Kimlik.tcno, Kimlik.ad, Kimlik.soyad, Kimlik.dtarih, Kimlik.sehir, Kimlik.kangrubu }; if (sql.Count() == 0) { return(null); } else { return(JsonConvert.SerializeObject(sql, Newtonsoft.Json.Formatting.Indented)); } }
public string getAcilMudahale(int inputId) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(); var sql = from AcilMudahale in db.AcilMudahales join applogin in db.applogins on AcilMudahale.personelid equals applogin.apploginid join Kimlik in db.Kimliks on applogin.kimlikid equals Kimlik.kimlikid where AcilMudahale.kimlikid == inputId select new { Kimlik.ad, // mudahale eden personelin adı Kimlik.soyad, applogin.yetki, AcilMudahale.tarih, AcilMudahale.aciklama }; if (sql.Count() == 0) { return(null); } else { return(JsonConvert.SerializeObject(sql, Newtonsoft.Json.Formatting.Indented)); } }
private void Button_DELETE(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); Teacher deleteTeacher = db.Teachers.FirstOrDefault(ex => ex.Teacher_ID.Equals(ID.Text)); db.Teachers.DeleteOnSubmit(deleteTeacher); db.SubmitChanges(); }
public Eligible_Student_List() { InitializeComponent(); DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); List <EligibleStudentListDG> list = new List <EligibleStudentListDG>(); //List<DAL.Admission_Student> list = new List<DAL.Admission_Student>(); var a = from e in db.Admission_Students select e; EligibleStudentListDG el; foreach (DAL.Admission_Student aStd in a) { el = new EligibleStudentListDG(); var b = from e in db.Admission_Exam_Results where e.Admission_Student_ID == aStd.Admission_Student_ID select e; foreach (Admission_Exam_Result aStdRes in b) { el.Id = aStd.Admission_Student_ID; el.Name = aStd.Full_Name; el.Mobile = aStd.Mobile; el.Grade = aStd.Interested_Grade; el.Gender = aStd.Gender; el.Group = aStd.Group; el.Viva = aStdRes.Viva_Exam_Mark; el.Written = aStdRes.Writtern_Exam_Mark; double total = Double.Parse(aStdRes.Writtern_Exam_Mark) + Double.Parse(aStdRes.Viva_Exam_Mark); el.Total = total.ToString(); BusinessRules rule = new BusinessRules(); bool test = rule.checkEligibility(aStdRes.Writtern_Exam_Mark, aStdRes.Viva_Exam_Mark); if (test == true) { el.Eligibility = "Yes"; } else { el.Eligibility = "No"; } } list.Add(el); } dataGrid.IsReadOnly = true; dataGrid.DataContext = list; }
public void setPassword(int inputId, string setpassword) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(); var sql = db.applogins.Where(w => w.apploginid == inputId).FirstOrDefault(); sql.sifre = setpassword; db.SubmitChanges(); }
public ECRoom101() { InitializeComponent(); DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); DAL.Admission_Student admissionstudent = new DAL.Admission_Student(); DAL.Teacher teach = new DAL.Teacher(); List <string> objList = new List <string>(); List <string> objList2 = new List <string>(); var a = from e in db.Admission_Students select e; var b = from e in db.Teachers select e; foreach (DAL.Admission_Student st in a) { objList.Add(st.Admission_Student_ID); } foreach (DAL.Teacher t in b) { objList2.Add(t.Full_Name); } _1.ItemsSource = objList; _2.ItemsSource = objList; _3.ItemsSource = objList; _4.ItemsSource = objList; _5.ItemsSource = objList; _6.ItemsSource = objList; _7.ItemsSource = objList; _8.ItemsSource = objList; _9.ItemsSource = objList; _10.ItemsSource = objList; _11.ItemsSource = objList; _12.ItemsSource = objList; _13.ItemsSource = objList; _14.ItemsSource = objList; _15.ItemsSource = objList; _16.ItemsSource = objList; _17.ItemsSource = objList; _18.ItemsSource = objList; _19.ItemsSource = objList; _20.ItemsSource = objList; _21.ItemsSource = objList; _22.ItemsSource = objList; _23.ItemsSource = objList; _24.ItemsSource = objList; Invi1.ItemsSource = objList2; Invi2.ItemsSource = objList2; // _1.Content = objList.First(); }
public void addAdmissionStudent(Admission_Student adStd) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); adStd.Admission_Student_ID = getNewAdmissionStudentID(); db.Admission_Students.InsertOnSubmit(adStd); db.SubmitChanges(); }
private void Button_DONE(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); Teacher teach = new Teacher(); teach.First_Name = First.Text; teach.Last_Name = Last.Text; teach.Full_Name = First.Text + " " + Last.Text; teach.Fathers_Name = Father.Text; teach.Mothers_Name = Mother.Text; teach.Gender = Gender.Text; teach.Blood_Group = Blood.Text; if (Married.IsChecked == true) { teach.Marital_Status = "Married"; } else { teach.Marital_Status = "UnMarried"; } teach.DOB = DateTime.Now; teach.Joined_Date = DateTime.Now; teach.Status = "Active"; teach.Mobile = Mobile.Text; teach.Designation = Designation.Text; teach.Address = Address.Text; teach.Email = Email.Text; var max = db.Teachers.OrderByDescending(i => i.Teacher_ID).FirstOrDefault(); string id = ""; foreach (char a in max.Teacher_ID) { int val = (int)Char.GetNumericValue(a); id = (val + 1).ToString(); } teach.Teacher_ID = id; //MessageBox.Show(id); db.Teachers.InsertOnSubmit(teach); db.SubmitChanges(); //eita main mama HR hr = new HR(); hr.Show(); this.Close(); }
public void setAcilMudahale(int inputpersonelid, int inputkisid, string inputnot) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(); AcilMudahale newmudahale = new AcilMudahale(); newmudahale.personelid = inputpersonelid; newmudahale.kimlikid = inputkisid; newmudahale.tarih = DateTime.Now.ToString("dd.MM.yyyy"); newmudahale.aciklama = inputnot; db.AcilMudahales.InsertOnSubmit(newmudahale); db.SubmitChanges(); }
public Admission_Student getAdmissionStudent(string id) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); var temp = from a in db.Admission_Students where a.Admission_Student_ID == id select a; foreach (Admission_Student std in temp) { return(std); } return(null); }
public Student getStudent(string id) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); var std = from e in db.Students where e.Student_ID.Equals(id) select e; foreach (Student student in std) { return(student); } return(null); }
private async void Add_Task_Click(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); //getting max id from datebase var max = db.Tasks.OrderByDescending(i => i.Task_ID).FirstOrDefault(); string taskID = ""; foreach (char a in max.Task_ID) { int val = (int)Char.GetNumericValue(a); taskID = (val + 1).ToString(); } //storing values to task object DAL.Task task = new DAL.Task(); task.Task_ID = taskID; task.TaskType = task_type.Text; task.Task_Description = Task_Description.Text; task.Assigned_Date = DateTime.Now; task.Deadline = DateTime.Parse(deadline.Text); //storing valurs to teacker_task object DAL.Teacher_Task teacher_task = new DAL.Teacher_Task(); teacher_task.Task_ID = taskID; teacher_task.Teacher_ID = Login.getID(); try { db.Teacher_Tasks.InsertOnSubmit(teacher_task); db.Tasks.InsertOnSubmit(task); db.SubmitChanges(); await this.ShowMessageAsync("Information", "Task assignment successful."); HR hr = new HR(); hr.Show(); this.Close(); } catch { await this.ShowMessageAsync("Error", "Task assignment error."); } }
public void setVivaResult(string mark, string teacherID, string stdID) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); //var max = db.Admission_Exam_Results.OrderByDescending(i => i.Admission_Exam_ID).FirstOrDefault(); Admission_Exam_Result re = db.Admission_Exam_Results.FirstOrDefault(e => e.Admission_Student_ID.Equals(stdID)); if (re != null) { re.Viva_Examiner_ID = teacherID; re.Viva_Exam_Mark = mark; } db.SubmitChanges(); }
public bool addStudent(string admission_Student_ID) { try { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); var track = from abc in db.Trackers where abc.Traking_Name.Equals("Student_ID") select abc; int middlePortion = -1; foreach (Tracker trackingNumber in track) { middlePortion = int.Parse(trackingNumber.Tracking_Number); } string student_ID = getNewStudentID(); Student student = new Student(); student.Admissin_Student_ID = admission_Student_ID; student.Student_ID = student_ID; student.Student_Status = "Active"; db.Students.InsertOnSubmit(student); db.SubmitChanges(); foreach (Tracker tracker in track) { middlePortion++; tracker.Tracking_Number = middlePortion.ToString(); db.SubmitChanges(); break; } } catch { return(false); } return(true); }
private void Button_GO(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); var s = from a in db.Students where a.Student_ID == ID.Text select a; var t = from a in db.Teachers where a.Teacher_ID == ID.Text select a; //var ass = from a in db.Admission_Students // where a.Admission_Student_ID == // select a; bool flag = false; foreach (Teacher obj in t) { if (obj.Teacher_ID.Equals(ID.Text)) { flag = true; Name.Text = obj.Full_Name; JoinedDate.Text = obj.Joined_Date.ToString(); Dept.Text = "Science"; MobileNum.Text = obj.Mobile; Email.Text = obj.Email; Designation.Text = obj.Designation; Status.Text = obj.Status; } } if (flag == false) { MessageBox.Show("ID not found!"); Name.Text = ""; JoinedDate.Text = ""; Dept.Text = ""; MobileNum.Text = ""; Email.Text = ""; Designation.Text = ""; Status.Text = ""; } }
public string getAlerjiBilgisi(int inputId) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(); var sql = from alerji in db.alerjis where alerji.kimlikid == inputId select new { alerji.alerjiad }; if (sql.Count() == 0) { return(null); } else { return(JsonConvert.SerializeObject(sql, Newtonsoft.Json.Formatting.Indented)); } }
public string getNewAdmissionStudentID() { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); int studentID = -1; var tracker = from abc in db.Trackers where abc.Traking_Name.Equals("Admission_Student_ID") select abc; foreach (Tracker trackingNumber in tracker) { studentID = int.Parse(trackingNumber.Tracking_Number); } studentID++; return(studentID.ToString()); }
private async void button_Click_2(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); StudentIntImplementation a = new StudentIntImplementation(); AdmissionStudentIntImplementation b = new AdmissionStudentIntImplementation(); DAL.Student st = a.getStudent(id.Text); DAL.Admission_Student admissionSt = null; try { admissionSt = db.Admission_Students.FirstOrDefault(ee => ee.Admission_Student_ID.Equals(st.Admissin_Student_ID)); } catch { //do nothing } if (st == null) { await this.ShowMessageAsync("Error", "Student not found."); } else { DAL.Student_Regular_Fee stReg = db.Student_Regular_Fees.FirstOrDefault(ee => ee.Student_ID.Equals(st.Student_ID)); fullName.Text = admissionSt.Full_Name; grade.Text = admissionSt.Interested_Grade; group.Text = admissionSt.Group; /*if (stReg == null) * mo.Text = ""; * else * mark.Text = stResult.Viva_Exam_Mark;*/ } }
private void Button_Click_1(object sender, RoutedEventArgs e) { //DataAccessClass db = new DataAccessClass(); //DataAccessClass.ExecuteSQL("INSERT INTO Classroom (Classroom_ID, Remarks, Status) VALUES (2, 'None', 'true')"); DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); var t = from a in db.Admins select a; bool b = false; try { foreach (Admin obj in t) { if (obj.Admin_ID.Equals(UserName.Text) && obj.Pasword.Equals(UserPass.Password)) { b = true; //Login l = new Login(UserName.Text, UserPass.Password); Login.setIDPass(UserName.Text, UserPass.Password); Home_Screen home = new Home_Screen(); home.Show(); this.Close(); } } } catch (Exception ex) { b = true; MessageBox.Show("You forgot to write your name and id!"); } if (b == false) { MessageBox.Show("Wrong username or password!"); } }
public string getNewStudentID() { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); int middlePortion = -1; var track = from abc in db.Trackers where abc.Traking_Name.Equals("Student_ID") select abc; foreach (Tracker trackingNumber in track) { middlePortion = int.Parse(trackingNumber.Tracking_Number); } middlePortion++; DateTime date = DateTime.Now; string year = date.Year.ToString().Substring(2); string student_ID = year + "-" + middlePortion.ToString("0000"); return(student_ID); }
public string getControlPerson(string inputTc, string inputAd, string inputSoyad, string inputDtarih, string inputSehir) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(); var sql = from applogin in db.applogins join Kimlik in db.Kimliks on applogin.kimlikid equals Kimlik.kimlikid where Kimlik.tcno == inputTc where Kimlik.ad == inputAd where Kimlik.soyad == inputSoyad where Kimlik.dtarih == inputDtarih where Kimlik.sehir == inputSehir select new { applogin.apploginid }; if (sql.Count() == 0) { return(null); } else { return(JsonConvert.SerializeObject(sql, Newtonsoft.Json.Formatting.Indented)); } }
private async void Button_DELETE(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); Teacher deleteTeacher = db.Teachers.FirstOrDefault(ex => ex.Teacher_ID.Equals(ID.Text)); try { db.Teachers.DeleteOnSubmit(deleteTeacher); db.SubmitChanges(); await this.ShowMessageAsync("Information", "Successfully Deleted."); } catch { await this.ShowMessageAsync("Error", "Delete unsuccessful."); } HR hr = new HR(); hr.Show(); this.Close(); }
public void setWrittenResult(string mark, string teacherID, string stdID) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); var max = db.Admission_Exam_Results.OrderByDescending(i => i.Admission_Exam_ID).FirstOrDefault(); Admission_Exam_Result re = db.Admission_Exam_Results.FirstOrDefault(e => e.Admission_Student_ID.Equals(stdID)); if (re == null) { string id = ""; foreach (char a in max.Admission_Exam_ID) { int val = (int)Char.GetNumericValue(a); id = (val + 1).ToString(); } Admission_Exam_Result rs = new Admission_Exam_Result(); rs.Admission_Exam_ID = id; rs.Written_Examiner_ID = teacherID; rs.Writtern_Exam_Mark = mark; rs.Admission_Student_ID = stdID; rs.Viva_Exam_Mark = "0"; rs.Viva_Examiner_ID = "0"; db.Admission_Exam_Results.InsertOnSubmit(rs); } else { re.Writtern_Exam_Mark = mark; re.Written_Examiner_ID = teacherID; } db.SubmitChanges(); }
private async void Button_DONE(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); var s = from a in db.Students where a.Student_ID == ID.Text select a; var t = from a in db.Teachers where a.Teacher_ID == ID.Text select a; //teach.DOB = DateTime.Now; //teach.Joined_Date = DateTime.Now; //teach.Status = "Active"; //teach.Mobile = Mobile.Text; //teach.Designation = Designation.Text; //teach.Address = Address.Text; //teach.Email = Email.Text; bool flag = false; foreach (Teacher obj in t) { if (obj.Teacher_ID.Equals(ID.Text)) { flag = true; First.Text = obj.First_Name; Last.Text = obj.Last_Name; Father.Text = obj.Fathers_Name; Mother.Text = obj.Mothers_Name; Gender.Text = obj.Gender; Blood.Text = obj.Blood_Group; DateOfBirth.Text = obj.DOB.ToString(); Marital.Text = obj.Marital_Status; Designation.Text = obj.Designation; Address.Text = obj.Address; Email.Text = obj.Email; Mobile.Text = obj.Mobile; } } if (flag == false) { await this.ShowMessageAsync("Error", "Student not found."); First.Text = ""; Last.Text = ""; Father.Text = ""; Mother.Text = ""; Gender.Text = ""; Blood.Text = ""; DateOfBirth.Text = ""; Marital.Text = ""; Designation.Text = ""; Address.Text = ""; Email.Text = ""; Mobile.Text = ""; } //if (Married.IsChecked == true) //{ // teach.Marital_Status = "Married"; //} //else //{ // teach.Marital_Status = "UnMarried"; //} //teach.DOB = DateTime.Now; //teach.Joined_Date = DateTime.Now; //teach.Status = "Active"; //teach.Mobile = Mobile.Text; //teach.Designation = Designation.Text; //teach.Address = Address.Text; //teach.Email = Email.Text; }
private void Button_DONE(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); DAL.Inventory iv = db.Inventories.FirstOrDefault(a => a.Inventory_ID.Equals("1")); if (Edit.Content.ToString() == "EDIT") { Edit.Content = "DONE"; Printer.IsEnabled = true; Computer.IsEnabled = true; Mouse.IsEnabled = true; Keyboard.IsEnabled = true; Projector.IsEnabled = true; Camera.IsEnabled = true; WhiteBoard.IsEnabled = true; Marker.IsEnabled = true; Pencil.IsEnabled = true; Soap.IsEnabled = true; PaperBundle.IsEnabled = true; Pen.IsEnabled = true; Duster.IsEnabled = true; GeometryBox.IsEnabled = true; Ruler.IsEnabled = true; Chair.IsEnabled = true; Bench.IsEnabled = true; Table.IsEnabled = true; /* iv.Printer = Printer.Text; * iv.Computer = Computer.Text; * iv.Mouse = Mouse.Text; * iv.Keyboard = Keyboard.Text; * iv.Projector = Projector.Text; * iv.Camera = Camera.Text; * iv.Whiteboard = WhiteBoard.Text; * iv.Marker = Marker.Text; * iv.Clock = Soap.Text; * iv.Paperbundle = PaperBundle.Text; * iv.Pen = Pen.Text; * iv.Duster = Duster.Text; * iv.Geometrybox = GeometryBox.Text; * iv.Ruler = Ruler.Text; * iv.Chair = Chair.Text; * iv.Bench = Bench.Text; * iv.Table = Table.Text;*/ // db.Inventories.InsertOnSubmit(iv); //db.SubmitChanges(); } else { Edit.Content = "EDIT"; Printer.IsEnabled = false; Computer.IsEnabled = false; Mouse.IsEnabled = false; Keyboard.IsEnabled = false; Projector.IsEnabled = false; Camera.IsEnabled = false; WhiteBoard.IsEnabled = false; Marker.IsEnabled = false; Pencil.IsEnabled = false; Soap.IsEnabled = false; PaperBundle.IsEnabled = false; Pen.IsEnabled = false; Duster.IsEnabled = false; GeometryBox.IsEnabled = false; Ruler.IsEnabled = false; Chair.IsEnabled = false; Bench.IsEnabled = false; Table.IsEnabled = false; //Printer.Text = iv.Printer; //Computer.Text = iv.Computer; //Mouse.Text = iv.Mouse; //Keyboard.Text = iv.Keyboard; //Projector.Text = iv.Projector; //Camera.Text = iv.Camera; //WhiteBoard.Text = iv.Whiteboard; //Marker.Text = iv.Marker; //Pencil.Text = iv.Pencil; //Soap.Text = iv.Clock; //PaperBundle.Text = iv.Paperbundle; //Pen.Text = iv.Pen; //Duster.Text = iv.Duster; //GeometryBox.Text = iv.Geometrybox; //Ruler.Text = iv.Ruler; //Chair.Text = iv.Chair; //Bench.Text = iv.Bench; //Table.Text = iv.Table; iv.Printer = Printer.Text; iv.Computer = Computer.Text; iv.Mouse = Mouse.Text; iv.Keyboard = Keyboard.Text; iv.Projector = Projector.Text; iv.Camera = Camera.Text; iv.Whiteboard = WhiteBoard.Text; iv.Marker = Marker.Text; iv.Clock = Soap.Text; iv.Paperbundle = PaperBundle.Text; iv.Pen = Pen.Text; iv.Duster = Duster.Text; iv.Geometrybox = GeometryBox.Text; iv.Ruler = Ruler.Text; iv.Chair = Chair.Text; iv.Bench = Bench.Text; iv.Table = Table.Text; //db.Inventories.InsertOnSubmit(iv); db.SubmitChanges(); } }