/// <summary> /// Manage user profile like adding or deleting user from databse or updating user email or role in the database. /// </summary> public static void RequestedAction() { DataService.AccessService dataService = new DataService.AccessService(); var file = new StreamReader(File.OpenRead(@"c:\Test.csv")); while (!file.EndOfStream) { var EachLine = file.ReadLine(); var valuesOfLine = EachLine.Split(','); string userEmail = valuesOfLine[0]; int role = int.Parse(valuesOfLine[1]); string Action = valuesOfLine[2]; //string NewEmail = valuesOfLine[3]; if (Action == "add") { dataService.AddUser(userEmail, role); } else if (Action == "delete") { dataService.DeleteUser(userEmail); } else if (Action == "updateRole") { dataService.UpdateUserRole(userEmail, role); } else if (Action == "updateEmail") { string NewEmail = valuesOfLine[3]; dataService.UpdateUserEmail(userEmail, NewEmail); } } }