protected void btnSave_Click(object sender, EventArgs e)
{
var businessHeler = new BusinessLayer.BusinessLayer();
var product = new Product();
product.Name = txtName.Text;
product.Description = txtDesc.Text;
product.SKU = txtSKU.Text;
product.Vendor = txtVendor.Text;
int productID;
if (int.TryParse(hdnProductId.Value, out productID))
{
product.ProductId = productID;
}
businessHeler.ManageProduct(product);
grdProducts.DataSource = businessHeler.GetProducts();
grdProducts.DataBind();
txtName.Text = string.Empty;
txtDesc.Text = string.Empty;
txtSKU.Text = string.Empty;
txtVendor.Text = string.Empty;
hdnProductId.Value = string.Empty;
}
static void Add(BusinessLayer.BusinessLayer myBusinessLayer, LayerType layerType)
{
Console.WriteLine("Name:");
string Name = Console.ReadLine();
switch (layerType)
{
case LayerType.TEACHER:
Teacher newTeacher = new Teacher()
{
TeacherName = Name
};
myBusinessLayer.AddTeacher(newTeacher);
Console.WriteLine("Teacher: " + Name + " created.");
break;
case LayerType.COURSE:
Console.WriteLine("Teacher Id:");
int Id = Int32.Parse(Console.ReadLine());
Course newCourse = new Course()
{
CourseName = Name, TeacherId = Id
};
myBusinessLayer.AddCourse(newCourse);
Console.WriteLine("Course: " + Name + " created.");
break;
default:
break;
}
}
static void Delete(BusinessLayer.BusinessLayer myBusinessLayer, LayerType layerType)
{
Console.WriteLine("Id to delete:");
int Id = Int32.Parse(Console.ReadLine());
switch (layerType)
{
case LayerType.TEACHER:
if (myBusinessLayer.GetTeacherByID(Id) == null)
{
Console.WriteLine("No teacher by that ID or Name was found. Returning to main menu");
}
else
{
Console.WriteLine("Teacher: " + myBusinessLayer.GetTeacherByID(Id).TeacherName + " has been deleted");
myBusinessLayer.RemoveTeacher(myBusinessLayer.GetTeacherByID(Id));
}
break;
case LayerType.COURSE:
if (myBusinessLayer.GetCourseByID(Id) == null)
{
Console.WriteLine("No Course by that ID or Name was found. Returning to main menu");
}
else
{
Console.WriteLine("Course: " + myBusinessLayer.GetCourseByID(Id).CourseName + " has been deleted");
myBusinessLayer.RemoveCourse(myBusinessLayer.GetCourseByID(Id));
}
break;
default:
break;
}
}
public static IEnumerable <RestaurantComp.Restaurant> SearchRestaurants(string p)
{
List <RestaurantComp.Restaurant> unsearched = BusinessLayer.GetDataRestaurants().ToList();
List <RestaurantComp.Restaurant> searched = new List <RestaurantComp.Restaurant>();
foreach (RestaurantComp.Restaurant x in unsearched)
{
if (!String.IsNullOrEmpty(p))
{
if (x.name.ToLower().Contains(p.ToLower()))
{
searched.Add(x);
}
}
}
return(searched);
}
public static void Main(string[] args)
{
IBusinessLayer blayer = new BusinessLayer.BusinessLayer();
IEnumerable <Student> students = blayer.GetAllStudents();
IEnumerable <Teacher> teachers = blayer.GetAllTeachers();
IEnumerable <Course> coursesList = blayer.GetAllCourses();
foreach (var s in blayer.GetAllStudents())
{
Console.WriteLine(s.StudentName);
foreach (var c in s.Courses)
{
Console.WriteLine(c.CourseName);
}
}
bool exit = false;
while (!exit)
{
Console.WriteLine(
"\n\nMenu\n" +
"Teach Actions:\n" +
"[1] Create\n" +
"[2] Update using Teacher ID\n" +
"[3] Update using Teacher Name\n" +
"[4] Delete\n" +
"[5] Display All" +
"\n\n" +
"Course Actions:\n" +
"[6] Create\n" +
"[7] Update using Course ID\n" +
"[8] Update using Course Name\n" +
"[9] Delete\n" +
"[10] Display All\n" +
"\n[0] Exit");
Console.Write("Choice: ");
try
{
int choice = Convert.ToInt32(Console.ReadLine());
switch (choice)
{
case 1:
Teacher t = AddTeacher();
if (t != null)
{
blayer.AddTeacher(t);
Console.WriteLine("Teacher added!");
}
break;
case 2:
UpdateTeacher(blayer);
break;
case 3:
UpdateTeacherByName(blayer);
break;
case 4:
RemoveTeacher(blayer);
break;
case 5:
DisplayAll <Teacher>(blayer);
break;
case 6:
AddCourse(blayer);
break;
case 7:
ModifyCourseByID(blayer);
break;
case 8:
ModifyCourseByName(blayer);
break;
case 9:
RemoveCourse(blayer);
break;
case 10:
DisplayAll <Course>(blayer);
break;
case 0:
exit = true;
break;
default:
Console.WriteLine("Invalid option.");
break;
}
Console.WriteLine("Press any key to continue...");
Console.ReadKey();
}
catch (Exception)
{
Console.WriteLine("Wrong input type.\nPress any key to continue...");
Console.ReadKey();
}
}
}
static void Main(string[] args)
{
BusinessLayer BL = new BusinessLayer();
int choice, option, id;
string answer;
bool exit = false;
Teacher teach = new Teacher();
Course course = new Course();
Console.WriteLine("Repository Application Menu");
while (exit == false)
{
Console.WriteLine("\n1. Add a Teacher\n" +
"2. Update a Teacher\n" +
"3. Delete a Teacher\n" +
"4. Courses taught by Teacher(input ID)\n" +
"5. Display all Teachers\n\n" +
"6. Add a Course\n" +
"7. Update a Course\n" +
"8. Delete a Course\n" +
"9. Display all Courses\n" +
"0. Exit\n");
choice = Convert.ToInt32(Console.ReadLine());
try
{
switch (choice)
{
case 0: //exit
exit = true;
break;
case 1: //add teach
Console.WriteLine("add a Teacher's name: ");
teach.TeacherName = Console.ReadLine();
BL.AddTeacher(teach);
break;
case 2: //update teach
Console.WriteLine("Search by:\n1. ID\n2. name");
option = Convert.ToInt32(Console.ReadLine());
if (option == 1) //search by ID
{
Console.WriteLine("Enter ID: ");
id = Convert.ToInt32(Console.ReadLine());
teach = BL.GetTeacherByID(id);
}
else if (option == 2) //search by name
{
Console.WriteLine("Enter Name: ");
string name = Console.ReadLine();
teach = BL.GetTeacherByName(name);
}
Console.WriteLine("Current name: {0} with id: {1}", teach.TeacherName, teach.TeacherId);
Console.WriteLine("Change name: ");
teach.TeacherName = Console.ReadLine();
BL.UpdateTeacher(teach);
break;
case 3: //delete teach
Console.WriteLine("Search by:\n1. ID\n2. name");
option = Convert.ToInt32(Console.ReadLine());
if (option == 1) //search by ID
{
Console.WriteLine("Enter ID: ");
id = Convert.ToInt32(Console.ReadLine());
teach = BL.GetTeacherByID(id);
}
else if (option == 2) //search by name
{
Console.WriteLine("Enter Name: ");
string name = Console.ReadLine();
teach = BL.GetTeacherByName(name);
}
Console.WriteLine("Current name: {0} with id: {1}", teach.TeacherName, teach.TeacherId);
Console.WriteLine("Delete this? (Y/N)");
while (exit == false) //confirm deletion
{
answer = Console.ReadLine();
if (answer == "y" || answer == "Y")
{
BL.RemoveTeacher(teach);
exit = true;
}
else if (answer == "n" || answer == "N")
{
exit = true;
}
else
{
Console.WriteLine("only y or n");
}
}
exit = false;
break;
case 4: //courses taught by teacher
BL.GetAllCourse();
Console.WriteLine("Enter a teacher ID: ");
id = Convert.ToInt32(Console.ReadLine());
teach = BL.GetTeacherByID(id);
Console.WriteLine("Teacher name: {0}\nCourse(s) teaching:\n", teach.TeacherName);
foreach (Course c in teach.Courses)
{
Console.WriteLine(c.CourseName);
}
break;
case 5: //all teachers
Console.WriteLine("{0}\t{1}", "Teacher Name", "Teacher ID");
Console.WriteLine("___________________________");
foreach (Teacher t in BL.GetAllTeacher())
{
Console.WriteLine("{0}\t{1}", t.TeacherName, t.TeacherId);
}
break;
case 6: //add course
Console.WriteLine("add a Course name: ");
course.CourseName = Console.ReadLine();
Console.WriteLine("Who teaches this course?(Enter ID)\n");
course.TeacherId = Convert.ToInt32(Console.ReadLine());
BL.AddCourse(course);
break;
case 7: //update course
Console.WriteLine("Search by:\n1. ID\n2. name");
option = Convert.ToInt32(Console.ReadLine());
if (option == 1) //search by ID
{
Console.WriteLine("Enter ID: ");
id = Convert.ToInt32(Console.ReadLine());
BL.GetCourseByID(id);;
}
else if (option == 2) //search by name
{
Console.WriteLine("Enter Name: ");
string name = Console.ReadLine();
BL.GetCourseByName(name);
}
Console.WriteLine("Current name: {0} with id: {1}", course.CourseName, course.CourseId);
Console.WriteLine("Change name: ");
course.CourseName = Console.ReadLine();
BL.UpdateCourse(course);
break;
case 8: //delete course
Console.WriteLine("Search by:\n1. ID\n2. name");
option = Convert.ToInt32(Console.ReadLine());
if (option == 1) //search by ID
{
Console.WriteLine("Enter ID: ");
id = Convert.ToInt32(Console.ReadLine());
course = BL.GetCourseByID(id);
}
else if (option == 2) //search by name
{
Console.WriteLine("Enter Name: ");
string name = Console.ReadLine();
course = BL.GetCourseByName(name);
}
Console.WriteLine("Current name: {0} with id: {1}", course.CourseName, course.CourseId);
Console.WriteLine("Delete this? (Y/N)");
while (exit == false) //confirm deletion
{
answer = Console.ReadLine();
if (answer == "y" || answer == "Y")
{
BL.RemoveCourse(course);
exit = true;
}
else if (answer == "n" || answer == "N")
{
exit = true;
}
else
{
Console.WriteLine("only y or n");
}
}
exit = false;
break;
case 9: //all courses
Console.WriteLine("{0}\t{1}", "Course Name", "Course ID");
Console.WriteLine("___________________________");
foreach (Course c in BL.GetAllCourse())
{
Console.WriteLine("{0}\t\t{1}", c.CourseName, c.CourseId);
}
break;
}
}
catch (Exception)
{
Console.WriteLine("Item does not exist");
}
}
Console.WriteLine("Press any key to continue . . .");
Console.ReadKey();
}
static void Main(string[] args)
{
BusinessLayer.BusinessLayer bl = new BusinessLayer.BusinessLayer();
bool run = true;
while (run)
{
Console.WriteLine("");
Console.WriteLine("----- Respository Program -----");
Console.WriteLine("[ Teacher ]");
Console.WriteLine("1. Add Teacher");
Console.WriteLine("2. Update Teacher");
Console.WriteLine("3. Remove Teacher");
Console.WriteLine("4. Display all courses associated with a Teacher ID");
Console.WriteLine("5. Display all teachers");
Console.WriteLine("");
Console.WriteLine("[ Course ]");
Console.WriteLine("6. Add Course");
Console.WriteLine("7. Update Course");
Console.WriteLine("8. Remove Course");
Console.WriteLine("9. Display all courses");
Console.WriteLine("-------------------------------");
Console.WriteLine("0. Exit");
Console.WriteLine("Select an option: ");
Console.WriteLine("");
int optionInt = Convert.ToInt32(Console.ReadLine());
if (optionInt == 1)
{
Console.WriteLine("Teacher Name ?");
string name = Console.ReadLine();
Teacher temp = new Teacher
{
TeacherName = name
};
bl.AddTeacher(temp);
}
else if (optionInt == 2)
{
Console.WriteLine("1. Update Teacher by teacher id");
Console.WriteLine("2. Update Teacher by teacher name");
Console.WriteLine("Select an option: ");
int subOption = Convert.ToInt32(Console.ReadLine());
if (subOption == 1)
{
Console.WriteLine("Teacher ID ?");
int id = Convert.ToInt32(Console.ReadLine());
Teacher teacher = bl.GetTeacherByID(id);
if (teacher == null)
{
Console.WriteLine("Teacher not found!");
}
else
{
Console.WriteLine("Enter new teacher name: ");
teacher.TeacherName = Console.ReadLine();
bl.UpdateTeacher(teacher);
}
}
else if (subOption == 2)
{
Console.WriteLine("Teacher Name ?");
string name = Console.ReadLine();
Teacher temp = bl.GetTeacherByName(name);
if (temp == null)
{
Console.WriteLine("Teacher not found!");
}
else
{
int id = temp.TeacherId;
Teacher teacher = bl.GetTeacherByID(id);
if (teacher == null)
{
Console.WriteLine("Teacher not found!");
}
else
{
Console.WriteLine("Enter new teacher name: ");
teacher.TeacherName = Console.ReadLine();
bl.UpdateTeacher(teacher);
}
}
}
else
{
Console.WriteLine("Input is invalid");
}
}
else if (optionInt == 3)
{
Console.WriteLine("Teacher ID to be deleted?");
int id = Convert.ToInt16(Console.ReadLine());
Teacher teacher = bl.GetTeacherByID(id);
if (teacher == null)
{
Console.WriteLine("Teacher not found !");
}
else
{
Teacher temp = bl.GetCoursesByTeacherID(id);
foreach (var i in temp.Courses)
{
Course c = bl.GetCourseByID(i.CourseId);
c.TeacherId = null;
bl.UpdateCourse(c);
}
bl.RemoveTeacher(teacher);
}
}
else if (optionInt == 4)
{
Console.WriteLine("Teacher ID ?");
int id = Convert.ToInt32(Console.ReadLine());
Teacher teacher = bl.GetCoursesByTeacherID(id);
if (teacher == null || teacher.Courses.Count == 0)
{
Console.WriteLine("No courses associated with this Teacher ID");
}
else
{
foreach (Course c in teacher.Courses)
{
Console.WriteLine("- " + c.CourseName);
}
}
}
else if (optionInt == 5)
{
IEnumerable <Teacher> allTeachers = bl.GetAllTeachers();
Console.WriteLine();
Console.WriteLine("ID Teacher Name");
foreach (Teacher temp in allTeachers)
{
Console.WriteLine(temp.TeacherId + " " + temp.TeacherName);
}
Console.WriteLine();
}
else if (optionInt == 6)
{
Console.WriteLine("Teacher ID ?");
int id = Convert.ToInt32(Console.ReadLine());
Teacher teacher = bl.GetTeacherByID(id);
if (teacher == null)
{
Console.WriteLine("Teacher not found!");
}
else
{
Console.WriteLine("Course Name? ");
string cName = Console.ReadLine();
//Console.WriteLine("Course Location? ");
//string cLocation = Console.ReadLine();
Course temp = new Course()
{
CourseName = cName,
TeacherId = id
};
bl.AddCourse(temp);
}
}
else if (optionInt == 7)
{
Console.WriteLine("1. Update Course by Course id");
Console.WriteLine("2. Update Course by Course name");
Console.WriteLine("Select an option: ");
int subOption = Convert.ToInt32(Console.ReadLine());
if (subOption == 1)
{
Console.WriteLine("Course ID ?");
int id = Convert.ToInt32(Console.ReadLine());
Course course = bl.GetCourseByID(id);
if (course == null)
{
Console.WriteLine("Course not found");
}
else
{
Console.WriteLine("Enter new course name: ");
course.CourseName = Console.ReadLine();
IEnumerable <Teacher> allTeachers = bl.GetAllTeachers();
Console.WriteLine("");
Console.WriteLine("Current available Teachers");
foreach (Teacher temp in allTeachers)
{
Console.WriteLine(temp.TeacherId + " " + temp.TeacherName);
}
Console.WriteLine("Current teacher id is " + course.TeacherId + " . Please enter new teacher id: ");
int idTemp = Convert.ToInt32(Console.ReadLine());
bool flag = false;
foreach (Teacher temp in allTeachers)
{
if (idTemp == temp.TeacherId)
{
flag = true;
}
}
if (flag == true)
{
course.TeacherId = idTemp;
bl.UpdateCourse(course);
}
else
{
Console.WriteLine("Teacher ID is invalid");
}
}
}
else if (subOption == 2)
{
Console.WriteLine("Course Name ?");
string name = Console.ReadLine();
Course tempCourse = bl.GetCourseByName(name);
if (tempCourse == null)
{
Console.WriteLine("Course not found!");
}
else
{
int id = tempCourse.CourseId;
Course course = bl.GetCourseByID(id);
if (course == null)
{
Console.WriteLine("Course not found!");
}
else
{
Console.WriteLine("Enter new course name: ");
course.CourseName = Console.ReadLine();
IEnumerable <Teacher> allTeachers = bl.GetAllTeachers();
Console.WriteLine("");
Console.WriteLine("Current available Teachers");
foreach (Teacher temp in allTeachers)
{
Console.WriteLine(temp.TeacherId + " " + temp.TeacherName);
}
Console.WriteLine("Current teacher id is " + course.TeacherId + " . Please enter new teacher id: ");
int idTemp = Convert.ToInt32(Console.ReadLine());
bool flag = false;
foreach (Teacher temp in allTeachers)
{
if (idTemp == temp.TeacherId)
{
flag = true;
}
}
if (flag == true)
{
course.TeacherId = idTemp;
bl.UpdateCourse(course);
}
else
{
Console.WriteLine("Teacher ID is invalid");
}
}
}
}
else
{
Console.WriteLine("Input is invalid");
}
}
else if (optionInt == 8)
{
Console.WriteLine("Course ID to be deleted?");
int id = Convert.ToInt32(Console.ReadLine());
Course course = bl.GetCourseByID(id);
if (course == null)
{
Console.WriteLine("Course not found!");
}
else
{
bl.RemoveCourse(course);
}
}
else if (optionInt == 9)
{
IEnumerable <Course> allCourses = bl.GetAllCourses();
Console.WriteLine();
Console.WriteLine($"\t {"ID",-5}" + $"{"Course name",-15}" + $"{"TeacherID",-15}");
//Console.WriteLine("ID Course Name TeacherID");
foreach (Course temp in allCourses)
{
Console.WriteLine($"\t {temp.CourseId,-5}" + $"{temp.CourseName,-15}" + $"{temp.TeacherId,-15}");
//Console.WriteLine(temp.CourseId + " " + temp.CourseName+ " " + temp.TeacherId);
}
Console.WriteLine();
}
else if (optionInt == 0)
{
run = false;
}
else
{
Console.WriteLine("Input is invalid, please re-enter the option from 0-9");
}
} //end while
}
public static void Main(string[] args)
{
IBusinessLayer businessLayer = new BusinessLayer.BusinessLayer();
bool cont = true;
string userInput;
while (cont)
{
Console.WriteLine("CRUD Operations School Database");
Console.WriteLine("1) Table Teacher ");
Console.WriteLine("2) Table Course ");
Console.WriteLine("3) Exit");
string menu1 = Console.ReadLine();
switch (menu1)
{
case "1":
userInput = menuTableTeacher();
if (userInput == "1")
{
Teacher newTeach = new Teacher();
Console.WriteLine("Enter Teacher Name: ");
//string name = Console.ReadLine();
newTeach.TeacherName = Console.ReadLine();
businessLayer.AddTeacher(newTeach);
}
else if (userInput == "2")
{
Console.WriteLine("Enter ID: ");
string temp = Console.ReadLine();
int id = int.Parse(temp);
Teacher newTeach = businessLayer.GetTeacherByID(id);
if (newTeach != null)
{
Console.WriteLine(newTeach.TeacherId + " " + newTeach.TeacherName);
ICollection <Course> courses = newTeach.Courses;
foreach (Course course in courses)
{
Console.WriteLine(course.CourseId + " " + course.CourseName);
}
}
else
{
Console.WriteLine("Teacher not found!!!");
}
}
else if (userInput == "3")
{
Console.WriteLine("Enter Teacher ID to Update: ");
string temp = Console.ReadLine();
int id = int.Parse(temp);
Teacher newTeach = businessLayer.GetTeacherByID(id);
Console.WriteLine("Enter Teacher new Name: ");
//string name = Console.ReadLine();
newTeach.TeacherName = Console.ReadLine();
businessLayer.UpdateTeacher(newTeach);
}
else if (userInput == "4")
{
Console.WriteLine("Enter Teacher ID to Delete: ");
string temp = Console.ReadLine();
int id = int.Parse(temp);
Teacher newTeach = businessLayer.GetTeacherByID(id);
businessLayer.RemoveTeacher(newTeach);
}
else
{
IList <Teacher> teachers = businessLayer.GetAllTeacher();
foreach (Teacher teacher in teachers)
{
Console.WriteLine(string.Format("{0} - {1}", teacher.TeacherId, teacher.TeacherName));
}
}
break;
case "2":
userInput = menuTableCourse();
if (userInput == "1")
{
Course newCourse = new Course();
Console.WriteLine("Enter New Course Name: ");
string name = Console.ReadLine();
newCourse.CourseName = name;
businessLayer.AddCourse(newCourse);
}
else if (userInput == "2")
{
Console.WriteLine("Enter ID: ");
string temp = Console.ReadLine();
int id = int.Parse(temp);
Course newCourse = businessLayer.GetCourseByID(id);
if (newCourse != null)
{
Console.WriteLine(newCourse.CourseId + " " + newCourse.CourseName);
}
else
{
Console.WriteLine("Course not found!!!");
}
}
else if (userInput == "3")
{
Console.WriteLine("Enter Course ID to Update: ");
string temp = Console.ReadLine();
int id = int.Parse(temp);
Course newCourse = businessLayer.GetCourseByID(id);
Console.WriteLine("Enter Course new Name: ");
newCourse.CourseName = Console.ReadLine();
businessLayer.UpdateCourse(newCourse);
}
else if (userInput == "4")
{
Console.WriteLine("Enter Course ID to Delete: ");
string temp = Console.ReadLine();
int id = int.Parse(temp);
Course newCourse = businessLayer.GetCourseByID(id);
businessLayer.RemoveCourse(newCourse);
}
else
{
IList <Course> courses = businessLayer.GetAllCourse();
foreach (Course course in courses)
{
Console.WriteLine(string.Format("{0} - {1}", course.CourseId, course.CourseName));
}
}
break;
case "3":
cont = false;
break;
default:
continue;
}
}
}
static void Update(BusinessLayer.BusinessLayer myBusinessLayer, LayerType layerType)
{
switch (layerType)
{
case LayerType.TEACHER:
foreach (var s in myBusinessLayer.getAllTeachers())
{
Console.WriteLine(s.TeacherId + " " + s.TeacherName);
}
Console.WriteLine("Enter Teacher ID: ");
int NameTeacher = Int32.Parse(Console.ReadLine());
Console.WriteLine("Enter New Name For Teacher: ");
myBusinessLayer.GetTeacherByID(NameTeacher).TeacherName = Console.ReadLine();
myBusinessLayer.UpdateTeacher(myBusinessLayer.GetTeacherByID(NameTeacher));
Console.WriteLine("Teacher name has been updated to: " + myBusinessLayer.GetTeacherByID(NameTeacher).TeacherName);
break;
case LayerType.COURSE:
foreach (var s in myBusinessLayer.GetAllCourses())
{
Console.WriteLine(s.CourseId + " " + s.CourseName);
}
Console.WriteLine("Enter Course ID: ");
int NameCourse = Int32.Parse(Console.ReadLine());
int choice = -1;
Console.WriteLine
(
"\n 0. Update Name \n " +
"1. Update Teacher \n "
);
try
{
choice = Int32.Parse(Console.ReadLine());
}
catch
{
Console.WriteLine("Selection invalid\n");
}
switch (choice)
{
case 0:
Console.WriteLine("Enter New Name For Course: ");
myBusinessLayer.GetCourseByID(NameCourse).CourseName = Console.ReadLine();
myBusinessLayer.UpdateCourse(myBusinessLayer.GetCourseByID(NameCourse));
Console.WriteLine("Course name has been updated to: " + myBusinessLayer.GetCourseByID(NameCourse).CourseName);
break;
case 1:
Console.WriteLine("Enter New Teacher Id For Course: ");
myBusinessLayer.GetCourseByID(NameCourse).TeacherId = Int32.Parse(Console.ReadLine());
myBusinessLayer.UpdateCourse(myBusinessLayer.GetCourseByID(NameCourse));
Console.WriteLine("Course teacher id has been updated to: " + myBusinessLayer.GetCourseByID(NameCourse).TeacherId);
break;
default:
break;
}
break;
default:
break;
}
}
static void Main(string[] args)
{
int choice = -1;
bool exit = true;
do
{
Console.WriteLine
(
"\n0. Exit Program \n" +
"1. Add Teachers \n" +
"2. Update Teacher \n" +
"3. Delete Teacher \n" +
"4. Display all Teachers \n" +
"5. Display Teacher's Courses by Teacher id \n" +
"6. Add Course \n" +
"7. Update Course \n" +
"8. Delete Course \n" +
"9. Display all Courses\n"
);
try
{
choice = Int32.Parse(Console.ReadLine());
}
catch
{
Console.WriteLine("Selection invalid\n");
}
BusinessLayer.BusinessLayer myBusinessLayer = new BusinessLayer.BusinessLayer();
switch (choice)
{
case 0:
exit = false;
Environment.Exit(0);
break;
case 1:
Add(myBusinessLayer, LayerType.TEACHER);
break;
case 2:
Update(myBusinessLayer, LayerType.TEACHER);
break;
case 3:
Delete(myBusinessLayer, LayerType.TEACHER);
break;
case 4:
foreach (var t in myBusinessLayer.GetAllTeachers())
{
Console.WriteLine(t.TeacherId + " " + t.TeacherName);
}
break;
case 5:
Console.WriteLine("Teacher Id:");
int Id = Int32.Parse(Console.ReadLine());
var coursePrint = myBusinessLayer.GetAllCourses().Where(t => t.TeacherId == Id);
foreach (var course in coursePrint)
{
Console.WriteLine(course.CourseId + " " + course.CourseName + " ");
}
break;
case 6:
Add(myBusinessLayer, LayerType.COURSE);
break;
case 7:
Update(myBusinessLayer, LayerType.COURSE);
break;
case 8:
Delete(myBusinessLayer, LayerType.COURSE);
break;
case 9:
foreach (var c in myBusinessLayer.GetAllCourses())
{
Console.WriteLine(c.CourseId + " " + c.CourseName);
}
break;
default:
Console.WriteLine("Please select a valid Menu Option");
break;
}
}while (exit);
}
static void Main(string[] args)
{
var RunDate = DateTime.Now;
RunDate = RunDate.AddTicks(-(RunDate.Ticks % 10000000));;
var Instances = InstanceServices.GetAllActive();
var Jobs = JobServices.GetById(1);
Jobs.RunDate = RunDate;
Jobs.RunCount = Jobs.RunCount + 1;
JobServices.Update(Jobs);
//JobLogServices.logging = true;
var LogBook = new JobLog {
JobId = Jobs.Id, RunDate = RunDate, RunCount = (Int32)Jobs.RunCount
};
LogBook.Type = "INF"; LogBook.Message = "***** START OF LOG FILE *****";
JobLogServices.Insert(LogBook);
//Console.WriteLine("***** START OF LOG FILE *****");
if (Jobs.Enabled == true)
{
LogBook.Type = "INF"; LogBook.Message = ("JOB: " + Jobs.Name + " IS ENABLED"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
#region SchedulerSettings
// construct a scheduler factory
//ISchedulerFactory schedulerFactory = new StdSchedulerFactory();
//get a scheduler
// _scheduler = schedulerFactory.GetScheduler();
//// add scheduler listener
////_scheduler.ListenerManager.AddSchedulerListener(new SchedulerListener());
//// add global job listener
////_scheduler.ListenerManager.AddJobListener(new JobListener(), GroupMatcher<JobKey>.AnyGroup());
//// add global trigger listener
////_scheduler.ListenerManager.AddTriggerListener(new TriggerListener(), GroupMatcher<TriggerKey>.AnyGroup());
//_scheduler.Start();
// Console.WriteLine("Starting Scheduler");
#endregion
#region CallQuartzJob
/*foreach (string value in servers)
* {
* // if (_utility.VerifyRemoteMachineStatus(value) == true)
* //{
*
* // foreach (string value in servers)
* //{
*
* Jobs.getServerName srvName = new Jobs.getServerName(); //This Constructor needs to be parameterless
* AddSimpleJob(srvName, value);
*
* Jobs.getCpuData cpuData = new Jobs.getCpuData();
* AddSimpleJob(cpuData, value);
*
* //}
* //else
* //{
* // Console.WriteLine("Server: " + value + " is offline");
* //}
*
* }*/
#endregion
LogBook.Type = "INF"; LogBook.Message = ("INITIATING SQL CONNECTIVITY TEST"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
//Console.WriteLine("INFORMATIVE: INITIATING SQL CONNECTIVITY TEST");
foreach (var i in Instances)
{
var objLogic = new BusinessLayer.BusinessLayer();
objLogic.SetConnString(i.Name);
if (objLogic.IsServerConnected(objLogic.objDataLayer.ConnString) == true)
{
//Console.WriteLine("INFORMATIVE: SQL INSTANCE :" + i.Name + " IS UP");
LogBook.Type = "INF"; LogBook.Message = ("SQL INSTANCE :" + i.Name + " IS UP"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
var helper_ServerProperty = new ServerProperty();
var helper_SysConfig = new SysConfig();
var helper_SysOsInfo = new SysOsInfo();
var helper_PowerPlan = new PowerPlan();
var InstanceDetail_obj = new InstanceDetail();
Console.WriteLine("INFORMATIVE: Getting Information from Instance: " + i.Name);
helper_ServerProperty = objLogic.GetServerProperties();
if (helper_ServerProperty.Success == true)
{
LogBook.Type = "INF"; LogBook.Message = ("<SUCCESS> GET SERVER PROPERTIES"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
helper_SysConfig = objLogic.GetSysConfiguration();
if (helper_SysConfig.Success == true)
{
LogBook.Type = "INF"; LogBook.Message = ("<SUCCESS> GET SYSTEM CONFIG"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
helper_SysOsInfo = objLogic.GetSysOsInformation();
if (helper_SysOsInfo.Success == true)
{
LogBook.Type = "INF"; LogBook.Message = ("<SUCCESS> GET SYSTEM OS INFORMATION"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
helper_PowerPlan = objLogic.GetPowerPlan();
if (helper_PowerPlan.Success == true)
{
LogBook.Type = "INF"; LogBook.Message = ("<SUCCESS> GET POWER PLAN"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
InstanceDetail_obj.Edition = helper_ServerProperty.Edition;
InstanceDetail_obj.Version = helper_ServerProperty.ProductVersion;
InstanceDetail_obj.ServicePack = helper_ServerProperty.ProductLevel;
InstanceDetail_obj.AuthMode = helper_ServerProperty.AuthMode;
InstanceDetail_obj.InstallDate = helper_ServerProperty.SQLInstallDate;
InstanceDetail_obj.TcpPort = helper_ServerProperty.LocalTcpPort;
InstanceDetail_obj.MaxServerMemory_MB = helper_SysConfig.MaxServerMemory;
InstanceDetail_obj.MinServerMemory_MB = helper_SysConfig.MinServerMemory;
InstanceDetail_obj.BackupCompression = helper_SysConfig.BackupCompression;
InstanceDetail_obj.MaxDOP = helper_SysConfig.MaxDop;
InstanceDetail_obj.Xp_Cmdshell = helper_SysConfig.Xp_Cmdshell;
InstanceDetail_obj.CPU_Count = helper_SysOsInfo.CpuCount;
InstanceDetail_obj.ServerMemory_MB = helper_SysOsInfo.ServerMemory;
InstanceDetail_obj.LastStartDate = helper_SysOsInfo.SQLStartTime;
InstanceDetail_obj.MachineType = helper_SysOsInfo.MachineType;
InstanceDetail_obj.PowerPlan = helper_PowerPlan.powerPlan;
InstanceDetail_obj.InstanceId = i.Id;
InstanceDetail_obj.RunCount = (Int32)Jobs.RunCount;
InstanceDetail_obj.RunDate = (DateTime)Jobs.RunDate;
try
{
InstanceDetailServices.Insert(InstanceDetail_obj);
}
catch (Exception ex)
{
//Console.WriteLine("ERROR: FAILED TO INSERT OBJECT INTO InstanceDetailed TABLE");
LogBook.Type = "ERR"; LogBook.Message = ("<FAILED> COULD NOT INSERT OBJECT INTO InstanceDetailed TABLE - INSTANCE: " + i.Name + " TABLE - EXCEPTION: " + ex.Message); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
}
else
{
LogBook.Type = "ERR"; LogBook.Message = ("<FAIL> GET POWER PLAN - INSTANCE: " + i.Name); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
}
else
{
LogBook.Type = "ERR"; LogBook.Message = ("<FAIL> GET SYSTEM OS INFORMATION - INSTANCE: " + i.Name); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
}
else
{
LogBook.Type = "ERR"; LogBook.Message = ("<FAIL> GET SYSTEM CONFIG - INSTANCE: " + i.Name); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
}
else
{
LogBook.Type = "ERR"; LogBook.Message = ("<FAIL> GET SERVER PROPERTIES - INSTANCE: " + i.Name); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
//var databaselist = new List<DataLayer.HelperClasses.DatabaseOption>();
//databaselist =
try
{
foreach (DatabaseOption DO in objLogic.GetDatabaseOptions())
{
DO.InstanceId = i.Id;
DO.RunDate = (DateTime)Jobs.RunDate;
DO.RunCount = (Int32)Jobs.RunCount;
DatabaseOptionServices.Insert(DO);
}
LogBook.Type = "INF"; LogBook.Message = ("<SUCCESS> GET DATABASE OPTIONS"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
catch (Exception ex)
{
//Console.WriteLine("Exception: " + ex.Message);
LogBook.Type = "ERR"; LogBook.Message = ("<FAIL> COULD NOT RETRIEVE OR INSERT DATA INTO DatabaseOptions TABLE - INSTANCE: " + i.Name + " - EXCEPTION: " + ex.Message); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
try
{
foreach (Backup B in objLogic.GetBackups())
{
B.RunDate = (DateTime)Jobs.RunDate;
B.RunCount = (Int32)Jobs.RunCount;
B.InstanceId = i.Id;
BackupServices.Insert(B);
}
LogBook.Type = "INF"; LogBook.Message = ("<SUCCESS> GET BACKUPS"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
catch (Exception ex)
{
//Console.WriteLine("Exception: " + ex.Message);
LogBook.Type = "ERR"; LogBook.Message = ("<FAIL> COULD NOT RETRIEVE OR INSERT DATA INTO Backups TABLE - INSTANCE: " + i.Name + " - EXCEPTION: " + ex.Message); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
try
{
foreach (Drive D in objLogic.GetDrives())
{
D.RunDate = (DateTime)Jobs.RunDate;
D.RunCount = (Int32)Jobs.RunCount;
D.InstanceId = i.Id;
DriveServices.Insert(D);
}
LogBook.Type = "INF"; LogBook.Message = ("<SUCCESS> GET DRIVE INFORMATION"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
catch (Exception ex)
{
//Console.WriteLine("Exception: " + ex.Message);
LogBook.Type = "ERR"; LogBook.Message = ("<FAIL> COULD NOT RETRIEVE OR INSERT DATA INTO Drives TABLE - INSTANCE: " + i.Name + " - EXCEPTION: " + ex.Message); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
try
{
foreach (DatabaseFile DBF in objLogic.GetDatabaseFiles())
{
DBF.RunDate = (DateTime)Jobs.RunDate;
DBF.RunCount = (Int32)Jobs.RunCount;
DBF.InstanceId = i.Id;
DatabaseFileServices.Insert(DBF);
}
LogBook.Type = "INF"; LogBook.Message = ("<SUCCESS> GET DATABASE FILE INFORMATION"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
catch (Exception ex)
{
//Console.WriteLine("Exception: " + ex.Message);
LogBook.Type = "ERR"; LogBook.Message = ("<FAIL> COULD NOT RETRIEVE OR INSERT DATA INTO DatabaseFiles TABLE - INSTANCE: " + i.Name + " - EXCEPTION: " + ex.Message); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
try
{
foreach (DatabaseSize DBS in objLogic.GetDatabaseSize())
{
DBS.RunDate = (DateTime)Jobs.RunDate;
DBS.RunCount = (Int32)Jobs.RunCount;
DBS.InstanceId = i.Id;
DatabaseSizeServices.Insert(DBS);
}
LogBook.Type = "INF"; LogBook.Message = ("<SUCCESS> GET DATABASE SIZE INFORMATION"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
catch (Exception ex)
{
//Console.WriteLine("Exception: " + ex.Message);
LogBook.Type = "ERR"; LogBook.Message = ("<FAIL> COULD NOT RETRIEVE OR INSERT DATA INTO DatabaseSize TABLE - INSTANCE: " + i.Name + " - EXCEPTION: " + ex.Message); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
try
{
foreach (UserMembership UM in objLogic.GetUserMembership())
{
UM.RunDate = (DateTime)Jobs.RunDate;
UM.RunCount = (Int32)Jobs.RunCount;
UM.InstanceId = i.Id;
UserMembershipServices.Insert(UM);
}
LogBook.Type = "INF"; LogBook.Message = ("<SUCCESS> GET USER MEMBERSHIP INFORMATION"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
catch (Exception ex)
{
//Console.WriteLine("Exception: " + ex.Message);
LogBook.Type = "ERR"; LogBook.Message = ("<FAIL> COULD NOT RETRIEVE OR INSERT DATA INTO UserMembership TABLE - INSTANCE: " + i.Name + " - EXCEPTION: " + ex.Message); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
try
{
foreach (LoginMembership LM in objLogic.GetLoginMembership())
{
LM.RunDate = (DateTime)Jobs.RunDate;
LM.RunCount = (Int32)Jobs.RunCount;
LM.InstanceId = i.Id;
LoginMembershipServices.Insert(LM);
}
LogBook.Type = "INF"; LogBook.Message = ("<SUCCESS> GET LOGIN MEMBERSHIP INFORMATION"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
catch (Exception ex)
{
//Console.WriteLine("Exception: " + ex.Message);
LogBook.Type = "ERR"; LogBook.Message = ("<FAIL> COULD NOT RETRIEVE OR INSERT DATA INTO LoginMembership TABLE - INSTANCE: " + i.Name + " - EXCEPTION: " + ex.Message); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
try
{
foreach (LogSize LS in objLogic.GetLogSize())
{
LS.RunDate = (DateTime)Jobs.RunDate;
LS.RunCount = (Int32)Jobs.RunCount;
LS.InstanceId = i.Id;
LogSizeServices.Insert(LS);
}
LogBook.Type = "INF"; LogBook.Message = ("<SUCCESS> GET LOG SIZE INFORMATION"); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
catch (Exception ex)
{
//Console.WriteLine("Exception: " + ex.Message);
LogBook.Type = "ERR"; LogBook.Message = ("<FAIL> COULD NOT RETRIEVE OR INSERT DATA INTO LogSize TABLE - INSTANCE: " + i.Name + " - EXCEPTION: " + ex.Message); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
}
else
{
//Console.WriteLine("WARNING: COULD NOT CONNECT TO SQL INSTANCE: " + i.Name);
LogBook.Type = "WRN"; LogBook.Message = ("COULD NOT CONNECT TO SQL INSTANCE: " + i.Name); LogBook.RunDate = DateTime.Now;
JobLogServices.Insert(LogBook);
}
}
//JobServices.Update(Jobs);
}
else
{
LogBook.Type = "INF"; LogBook.Message = ("JOB: " + Jobs.Name + " IS DISABLED");
JobLogServices.Insert(LogBook);
}
//_scheduler.Shutdown();
Console.WriteLine("***** END OF LOG FILE *****");
LogBook.Type = "INF"; LogBook.Message = "***** END OF LOG FILE *****";
JobLogServices.Insert(LogBook);
//Console.ReadLine();
}
