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();
}
}