예제 #1
0
        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"));
        }
예제 #2
0
        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"));
        }