public int Save(ITestAdministrator objTestAdministrator) { SqlCommand objMyCommand; SqlConnection objMyConnection = DBUtility.getConnection(); try { using (objMyConnection) { objMyCommand = new SqlCommand("sp_AddTestAdmin", objMyConnection); objMyCommand.CommandType = CommandType.StoredProcedure; objMyCommand.Parameters.AddWithValue("@ID", objTestAdministrator.get_EmployeeID); objMyCommand.Parameters.AddWithValue("@isTestAdmin", objTestAdministrator.get_IsTestAdmin); objMyConnection.Open(); return(objMyCommand.ExecuteNonQuery()); } } catch (Exception EE) { Console.WriteLine(EE); Console.Read(); return(0); } finally { objMyConnection.Close(); } }
public static ITestAdministrator Create_TestAdministrator(int emp_id, bool testAdmin_sts) { ITestAdministrator objTestAdministrator = null; if (objTestAdministrator == null) { objTestAdministrator = new TestAdministrator(emp_id, testAdmin_sts); } return(objTestAdministrator); }
public List <ITestAdministrator> getTestAdministrators() { List <ITestAdministrator> lstTestAdministrator = new List <ITestAdministrator>(); SqlCommand objMyCommand; SqlConnection objMyConnection = DBUtility.getConnection(); try { using (objMyConnection) { objMyCommand = new SqlCommand("sp_DisplayTestAdmin", objMyConnection); objMyCommand.CommandType = CommandType.StoredProcedure; objMyConnection.Open(); SqlDataReader objSqlDataReader = objMyCommand.ExecuteReader(); while (objSqlDataReader.Read()) { ITestAdministrator objTestAdministrator = TestAdministratorFactory.Create_TestAdministrator(0, false); objTestAdministrator.get_EmployeeID = Convert.ToInt32(objSqlDataReader[0]); objTestAdministrator.get_EmployeeName = Convert.ToString(objSqlDataReader[1]); objTestAdministrator.get_IsTestAdmin = Convert.ToBoolean(objSqlDataReader[2]); objTestAdministrator.get_EmployeeDesignation = Convert.ToString(objSqlDataReader[3]); objTestAdministrator.get_EmployeeLocation = Convert.ToString(objSqlDataReader[4]); objTestAdministrator.get_EmployeeExperience = Convert.ToInt32(objSqlDataReader[5]); lstTestAdministrator.Add(objTestAdministrator); } objSqlDataReader.Close(); } return(lstTestAdministrator); } catch (Exception EE) { Console.WriteLine(EE); Console.Read(); return(null); } finally { objMyConnection.Close(); } }
// To retrieve all the testadministrators public List <ITestAdministrator> GetList() { List <ITestAdministrator> lstTestAdministrator = new List <ITestAdministrator>(); SqlCommand objMyCommand; SqlConnection objMyConnection = DBUtility.getConnection(); try { using (objMyConnection) { objMyCommand = new SqlCommand("sp_DisplayTestAdmin", objMyConnection); objMyCommand.CommandType = CommandType.StoredProcedure; objMyConnection.Open(); SqlDataReader objSqlDataReader = objMyCommand.ExecuteReader(); while (objSqlDataReader.Read()) { int id = Int32.Parse(objSqlDataReader["EmployeeID"].ToString()); bool IsTestAdmin = bool.Parse(objSqlDataReader["IsTestAdmin"].ToString()); ITestAdministrator newtestadministrator = TestAdministratorFactory.Create_TestAdministrator(id, IsTestAdmin); lstTestAdministrator.Add(newtestadministrator); } objSqlDataReader.Close(); } return(lstTestAdministrator); } catch (Exception EE) { Console.WriteLine(EE); Console.Read(); return(null); } finally { objMyConnection.Close(); } }
// To add Test Administrator public int addtestadmin(int EmployeeID) { TestAdministratorManager objTestAdminManager = new TestAdministratorManager(); listemployee(); if (EmployeeList.Any(p => p.get_EmployeeID == EmployeeID && p.get_Designation == "unithead")) { ITestAdministrator objTestAdministrator = TestAdministratorFactory.Create_TestAdministrator(EmployeeID, true); ITestAdministratorDB testadministratorDB = TestAdministratorDBFactory.Create_TestAdminDB(); return(testadministratorDB.Save(objTestAdministrator)); } else if (EmployeeList.Any(p => p.get_EmployeeID == EmployeeID && p.get_Designation == "employee")) { ITestAdministrator objTestAdministrator = TestAdministratorFactory.Create_TestAdministrator(EmployeeID, false); ITestAdministratorDB test_adminDB = TestAdministratorDBFactory.Create_TestAdminDB(); return(test_adminDB.Save(objTestAdministrator)); } else { return(0); } }