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