public ActionResult UpdateAlumniRecord(int RecordID) { //method holds the record ID that need to be updated //a default value for action result ActionResult response = null; if (Session["RoleID"] != null) { //session that check if someone log in or none //if there is log in run the condition. //if there is none then go to else option if ((int)Session["RoleID"] == 1 || (int)Session["RoleID"] == 2 || (int)Session["RoleID"] == 3) { //session that determine what user is log in. //if any of these role is not log in then go to else option. //an instance to hold new info from ViewModel specially the form. AlumniVM alumniUpdateForm = new AlumniVM(); //identifier for data access object that holds the program,view alumni by ID. AlumniDO mappedDataIDDo = AlumniDataAccessLayer.ViewAlumniRecordByID(RecordID); //calling view model to populate the form with the exsisting info from the database //then converting it to presentation object alumniUpdateForm.AlumniForm = Mapper.MapAlumniDOtoPO(mappedDataIDDo); //department data object identifier that holds program of read department method. List <DepartmentDO> departmentObjectList = DepartmentDataAccessLayer.ReadDepartment(); //program that makes a dropdown option for department. //calling the instance then targetting the dropdown then add to the list whichever run in to the foreach loop. alumniUpdateForm.DepartmentDropDown.Add(new SelectListItem { Text = "Please choose a department", Value = "0" }); foreach (DepartmentDO departmentObject in departmentObjectList) { SelectListItem item = new SelectListItem(); item.Text = departmentObject.DeptName; item.Value = departmentObject.DeptID.ToString(); alumniUpdateForm.DepartmentDropDown.Add(item); } //showing the form with info and the dropdown department. response = View(alumniUpdateForm); } else { response = RedirectToAction("Index", "Home"); } } else { response = RedirectToAction("Index", "Home"); } //returning a populated form value or redirect. return(response); }
public static AlumniDO MapAlumniBOtoDO(AlumniBO frmAlumniBO) { AlumniDO toAlumniDO = new AlumniDO(); toAlumniDO.RecordID = frmAlumniBO.RecordID; toAlumniDO.CompleteName = frmAlumniBO.CompleteName; toAlumniDO.YearGraduated = frmAlumniBO.YearGraduated; toAlumniDO.Position = frmAlumniBO.Position; toAlumniDO.Company = frmAlumniBO.Company; toAlumniDO.ContactNumber = frmAlumniBO.ContactNumber; toAlumniDO.DepartmentID = frmAlumniBO.DepartmentID; return(toAlumniDO); }
public ActionResult UpdateAlumniRecord(AlumniVM updateForm) { //method holds whatever info does user add in the form. //a default value for action result ActionResult result = null; if (Session["RoleID"] != null) { //session that check if someone log in or none //if there is log in run the condition. //if there is none then go to else option if ((int)Session["RoleID"] == 1 || (int)Session["RoleID"] == 2 || (int)Session["RoleID"] == 3) { //session that determine what user is log in. //if any of these role is not log in then go to else option. if (ModelState.IsValid) { //if everything is valid in a model state,run the program //if it doesnt meet any requirements, run else option. //a DO identifier that hold info from the form //info coming from the form obtain form the user will be converted to data access //object and be added to the database. AlumniDO mappedDataUpdate = Mapper.MapAlumniPOtoDO(updateForm.AlumniForm); AlumniDataAccessLayer.UpdateAlumniRecord(mappedDataUpdate); //after it is added to database redirect to view to check new entry. result = RedirectToAction("ViewAllAlumni"); } else { //throwing a view form with a dropdown. result = View(updateForm); } } else { result = RedirectToAction("Index", "Home"); } } else { result = RedirectToAction("Index", "Home"); } //returning a form ,a view all or a redirect. return(result); }
public AlumniDO ViewAlumniRecordByID(int alumniID) { //the method hold alumniID info that will be coming from the controller and returns an object back to controller AlumniDO alumniObject = new AlumniDO(); //an instance that is needed for the return. try { //needed to be able to catch an error if any of the properties or object or functions are not met. using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { //connecting the program to the database //where the stored procedure will be used. SqlCommand sqlCommand = new SqlCommand("VIEW_ALUMNI_RECORD_BY_ID", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; //pass the id before open make a parameter for command sqlCommand.Parameters.AddWithValue("@RecordID", alumniID); sqlConnection.Open(); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { //using the reader,getting all the info one by one until all are recorded to the return. alumniObject = new AlumniDO(); alumniObject.RecordID = sqlDataReader.GetInt32(0); alumniObject.CompleteName = sqlDataReader.GetString(1).Trim(); alumniObject.YearGraduated = sqlDataReader.GetInt16(2); alumniObject.Position = sqlDataReader.GetString(3).Trim(); alumniObject.Company = sqlDataReader.GetString(4).Trim(); alumniObject.ContactNumber = sqlDataReader.GetString(5).Trim(); alumniObject.DepartmentID = sqlDataReader.GetInt32(6); } //making sure that all connections are close and dispose sqlDataReader.Close(); sqlDataReader.Dispose(); sqlCommand.Dispose(); } } catch (Exception exc) { LoggingDataAccessLayer.LogViewAlumniRecordByID(exc); //calling the LoggingDAL instance to pass on the info to the method. } //return a single DO not a list return(alumniObject); }
//an instance for LoggingDAL to hold information. public List <AlumniDO> ReadAlumniRecord() { //method return a list of alumni record List <AlumniDO> alumniList = new List <AlumniDO>(); //an instance for alumni list to be used as a return. try { //needed to be able to catch an error if any of the properties or object or functions are not met. using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { //connecting the program to the database //where the stored procedure will be used. SqlCommand sqlCommand = new SqlCommand("READ_ALUMNI_RECORDS", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlConnection.Open(); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { //using the reader,getting all the info one by one until all are recorded to the return. AlumniDO alumniObject = new AlumniDO(); alumniObject.RecordID = sqlDataReader.GetInt32(0); alumniObject.CompleteName = sqlDataReader.GetString(1); alumniObject.YearGraduated = sqlDataReader.GetInt16(2); alumniObject.Position = sqlDataReader.GetString(3); alumniObject.Company = sqlDataReader.GetString(4); alumniObject.ContactNumber = sqlDataReader.GetString(5); alumniObject.DepartmentID = sqlDataReader.GetInt32(6); alumniObject.Department.DeptName = sqlDataReader.GetString(7); alumniList.Add(alumniObject); } //making sure that all connections are close and dispose sqlDataReader.Close(); sqlDataReader.Dispose(); sqlCommand.Dispose(); } } catch (Exception exc) { LoggingDataAccessLayer.LogReadAlumniRecord(exc); //calling the LoggingDAL instance to pass on the info to the method. } return(alumniList); }
public static AlumniPO MapAlumniDOtoPO(AlumniDO frmAlumniDO) { //the method holds info of an AlumniDataObject and pass on an info //that is being converted to a presentation object. AlumniPO toAlumniPO = new AlumniPO(); toAlumniPO.RecordID = frmAlumniDO.RecordID; toAlumniPO.CompleteName = frmAlumniDO.CompleteName; toAlumniPO.YearGraduated = frmAlumniDO.YearGraduated; toAlumniPO.Position = frmAlumniDO.Position; toAlumniPO.Company = frmAlumniDO.Company; toAlumniPO.ContactNumber = frmAlumniDO.ContactNumber; toAlumniPO.DepartmentID = frmAlumniDO.DepartmentID; toAlumniPO.Department = frmAlumniDO.Department.DeptName; return(toAlumniPO); }
public void CreateAlumniRecord(AlumniDO alumniCreateDO) { //method hold info about the properties in alumni record table and this has no return. try { //needed to be able to catch an error if any of the properties or object or functions are not met. using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { //connecting the program to the database //where the stored procedure will be used. SqlCommand sqlCommand = new SqlCommand("CREATE_ALUMNI_RECORDS", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlConnection.Open(); //this time add value on each paramers that the sql stored procedure have. //all value are stored to the method's parameter. sqlCommand.Parameters.AddWithValue("@CompleteName", alumniCreateDO.CompleteName); sqlCommand.Parameters.AddWithValue("@YearGraduated", alumniCreateDO.YearGraduated); sqlCommand.Parameters.AddWithValue("@Position", alumniCreateDO.Position); sqlCommand.Parameters.AddWithValue("@Company", alumniCreateDO.Company); sqlCommand.Parameters.AddWithValue("@ContactNumber", alumniCreateDO.ContactNumber); sqlCommand.Parameters.AddWithValue("@DepartmentID", alumniCreateDO.DepartmentID); sqlCommand.ExecuteNonQuery(); //making sure that all connections are close and dispose sqlConnection.Close(); sqlConnection.Dispose(); sqlCommand.Dispose(); } } catch (Exception exc) { LoggingDataAccessLayer.LogCreateAlumniRecords(exc); //calling the LoggingDAL instance to pass on the info to the method. } }
public ActionResult CreateAlumniRecord(AlumniVM registerForm) { //method holds whatever info does user add in the form. //a default value for action result ActionResult result = null; if (Session["RoleID"] != null) { //session that check if someone log in or none //if there is log in run the condition. //if there is none then go to else option if ((int)Session["RoleID"] == 1 || (int)Session["RoleID"] == 2 || (int)Session["RoleID"] == 3) { //session that determine what user is log in. //if any of these role is not log in then go to else option. if (ModelState.IsValid) { //if everything is valid in a model state,run the program //if it doesnt meet any requirements, run else option. //a DO identifier that hold info from the form //info coming from the form obtain form the user will be converted to data access //object and be added to the database. AlumniDO mappedDataCreate = Mapper.MapAlumniPOtoDO(registerForm.AlumniForm); //calling the data access layer instance to create a new record with the info from user. AlumniDataAccessLayer.CreateAlumniRecord(mappedDataCreate); //after it is added to database redirect to view to check new entry. result = RedirectToAction("ViewAllAlumni"); } else { //this is a program for dropdown to the form. AlumniVM alumniForm = new AlumniVM(); List <DepartmentDO> departmentObjectList = DepartmentDataAccessLayer.ReadDepartment(); alumniForm.DepartmentDropDown.Add(new SelectListItem { Text = "Please choose a department", Value = "0" }); foreach (DepartmentDO departmentObject in departmentObjectList) { SelectListItem item = new SelectListItem(); item.Text = departmentObject.DeptName; item.Value = departmentObject.DeptID.ToString(); alumniForm.DepartmentDropDown.Add(item); } //throwing a view form with a dropdown. result = View(alumniForm); } } else { result = RedirectToAction("Index", "Home"); } } else { result = RedirectToAction("Index", "Home"); } //returning a form or redirect. return(result); }