public void AddStaff() { string bulkOrNot = "n"; do { string designation = ""; int Count = 0, Select, id = 0; bool valid = false; object[] opt = new object[5]; string[] Options; AdministrativeStaff admin = new AdministrativeStaff(); do { opt = EnterValues(); Options = ConfigList("Designation"); Console.WriteLine("Enter Designation :"); do { Console.WriteLine("\nSelect any one option(0 to exit)"); foreach (var val in Options) { Console.WriteLine(++Count + " :" + val); } Count = 0; int.TryParse(Console.ReadLine(), out Select); if (Select == 0) { break; } designation = Options[Select - 1]; break; }while (Select != 0); admin.StaffType = SType.AdministrativeStaff; admin.EmpId = opt[4].ToString(); admin.Name = opt[0].ToString(); admin.Phone = opt[1].ToString(); admin.Email = opt[3].ToString(); admin.Designation = designation; if (!String.IsNullOrEmpty(opt[2].ToString())) { admin.Dob = Convert.ToDateTime(opt[2]); } valid = Validation(admin); if (!valid) { Console.WriteLine("\nDo you want to correct entered values ??(yes-1/No-0)"); id = InputOption(); if (id == 1) { continue; } else { break; } } }while (!valid); if (valid) { // administrativeList.Add(admin); JsonFileOperation jfile = new JsonFileOperation(); jfile.AddToFile <AdministrativeStaff>(admin); XmlFileOperation xfile = new XmlFileOperation(); xfile.AddToFile <AdministrativeStaff>(admin); // DatabaseOperation createtb = new DatabaseOperation(); // createtb.CreateTable(); DatabaseOperation db = new DatabaseOperation(); db.AddBulkData(admin.EmpId, admin.Name, admin.Phone, admin.Email, admin.Dob, (int)admin.StaffType, admin.Designation); //Console.WriteLine("\nValues added are :\n"); //Console.WriteLine("\nName: " + admin.Name + " " + "DOB: " + admin.Dob + " " + "Phone :" + admin.Phone + " " + "Email :" + admin.Email + " Designation: " + admin.Designation); } Console.WriteLine("Add data again : (y/n)\n"); bulkOrNot = Console.ReadLine(); if (bulkOrNot.Equals("n")) { DatabaseOperation database = new DatabaseOperation(); database.ExecuteBulkProc(); break; } }while (bulkOrNot.Equals("y")); }
public void AddStaff() { string bulkOrNot = "n"; do { string subject = ""; int Count = 0, Select, id = 0; bool valid = false; object[] opt = new object[5]; string[] Options; TeachingStaff teaching = new TeachingStaff(); do { opt = EnterValues(); Options = ConfigList("Subject"); Console.WriteLine("Enter Subject :"); do { Console.WriteLine("\nSelect any one option(0 to exit)"); foreach (var val in Options) { Console.WriteLine(++Count + " :" + val); } Count = 0; int.TryParse(Console.ReadLine(), out Select); if (Select == 0) { break; } subject = Options[Select - 1]; break; }while (Select != 0); teaching.StaffType = SType.TeachingStaff; teaching.EmpId = opt[4].ToString(); teaching.Name = opt[0].ToString(); teaching.Phone = opt[1].ToString(); if (!String.IsNullOrEmpty(opt[2].ToString())) { teaching.Dob = Convert.ToDateTime(opt[2]); } teaching.Email = opt[3].ToString(); teaching.Subject = subject; valid = Validation(teaching); if (!valid) { Console.WriteLine("\nDo you want to correct entered values ??(yes-1/No-0)"); id = InputOption(); if (id == 1) { continue; } else { break; } } }while (!valid); if (valid) { teachingList.Add(teaching); // JsonFileOperation jfile = new JsonFileOperation(); // jfile.AddToFile<TeachingStaff>(teaching); // XmlFileOperation xfile = new XmlFileOperation(); // xfile.AddToFile<TeachingStaff>(teaching); DatabaseOperation db = new DatabaseOperation(); db.AddBulkData(teaching.EmpId, teaching.Name, teaching.Phone, teaching.Email, teaching.Dob, (int)teaching.StaffType, teaching.Subject); // Console.WriteLine("\nValues added are :\n"); //Console.WriteLine("\nName: " + teaching.Name + " " + "DOB: " + teaching.Dob + " " + "Phone :" + teaching.Phone + " " + "Email :" + teaching.Email + " Subject: " + teaching.Subject); } Console.WriteLine("Add data again : (y/n)\n"); bulkOrNot = Console.ReadLine(); if (bulkOrNot.Equals("n")) { DatabaseOperation database = new DatabaseOperation(); database.ExecuteBulkProc(); break; } }while (bulkOrNot.Equals("y")); }