public JobCV Get(int id)
{
JobCV jobCV = dbJobCV.Get(id);
jobCV.JobExperienceList = jobExperienceCtr.GetAllByJobCVId(jobCV.Id);
jobCV.ApplierEducationList = applierEducationCtr.GetAllByJobCVId(jobCV.Id);
jobCV.JobAppendixList = jobAppendixCtr.GetAllByJobCVId(jobCV.Id);
return(jobCV);
}
public void GetTest()
{
//Arrange
DBJobCV dbJobCV = new DBJobCV();
//Act
JobCV jobCv = dbJobCV.Get(1);
//Assert
Assert.IsNotNull(jobCv);
}
public void GetJobCVTest()
{
//Arrange
JobCVCtr jobCVCtr = new JobCVCtr();
//Act
JobCV jobCv = jobCVCtr.Get(1);
//Assert
Assert.IsTrue(jobCv != null);
}
public void CreateJobCVInDB()
{
//Arrange
JobCV jobCV = new JobCV(1, "Jensens bøfhus", "Bio");
DBJobCV dbJobCV = new DBJobCV();
//Act
JobCV jobCVReturned = dbJobCV.Create(jobCV);
//Assert
Assert.IsNotNull(jobCVReturned);
}
/// <summary>
/// Is a method that creates a JobCV in the database with the varibles Title and Bio
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public Applier Create(JobCV obj, Applier applier)
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText = "INSERT INTO JobCV (Title, Bio) output INSERTED.Id VALUES (@Title, @Bio)";
cmd.Parameters.AddWithValue("Title", obj.Title);
cmd.Parameters.AddWithValue("Bio", obj.Bio);
applier.JobCV.Id = (int)cmd.ExecuteScalar();
return(applier);
}
}
}
public void Update(JobCV obj)
{
dbJobCV.Update(obj);
foreach (var Experience in obj.JobExperienceList)
{
jobExperienceCtr.Update(Experience);
}
foreach (var Education in obj.ApplierEducationList)
{
applierEducationCtr.Update(Education);
}
foreach (var Appendix in obj.JobAppendixList)
{
jobAppendixCtr.Update(Appendix);
}
}
/// <summary>
/// Updates the given object JobCV in the database
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool Update(JobCV obj)
{
using (SqlConnection connection = conn.OpenConnection())
{
using (SqlCommand cmd = connection.CreateCommand())
{
try
{
cmd.CommandText = "UPDATE JobCV SET Title = @Title, Bio = @Bio WHERE Id = @Id ";
cmd.Parameters.AddWithValue("Title", obj.Title);
cmd.Parameters.AddWithValue("Bio", obj.Bio);
cmd.Parameters.AddWithValue("Id", obj.Id);
cmd.ExecuteNonQuery();
return(true);
}
catch (SqlException)
{
return(false);
}
}
}
}
/// <summary>
/// Updates the JobCV object in the database
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool Update(JobCV obj)
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (SqlCommand cmd = connection.CreateCommand())
{
try
{
cmd.CommandText = "UPDATE JobCV SET Title = @Title, ApplierId = @ApplierId WHERE Id = @Id ";
cmd.Parameters.AddWithValue("Titlte", obj.Title);
cmd.Parameters.AddWithValue("StartDate", obj.ApplierId);
cmd.Parameters.AddWithValue("Id", obj.Id);
cmd.ExecuteNonQuery();
return(true);
}
catch (SqlException)
{
return(false);
}
}
}
}
/// <summary>
/// Add the specifik jobcv into the database
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public JobCV Create(JobCV jobCV)
{
using (SqlConnection connection = conn.OpenConnection())
{
using (SqlCommand cmd = connection.CreateCommand())
{
try
{
cmd.CommandText = "INSERT INTO JobCV (Title, Bio) output INSERTED.Id VALUES (@Title, @Bio)";
cmd.Parameters.AddWithValue("Title", jobCV.Title);
cmd.Parameters.AddWithValue("Bio", jobCV.Bio);
int modefied = (int)cmd.ExecuteScalar();
jobCV.Id = modefied; //Get primary id after creation
return(jobCV);
}
catch (SqlException e)
{
throw e;
return(null);
}
}
}
}
public void ApplierUpdateDBTest()
{
//Arrange
DbApplier dbApplier = new DbApplier();
JobCV jobCV = new JobCV
{
Id = 1
};
Applier applier = new Applier
{
Id = 6,
Password = "******",
Email = "*****@*****.**",
Address = "hejvej 1",
Country = "BonBonLand",
ImageURL = "langIndePåNettet",
Description = "En applier description",
BannerURL = "LængereIndePåNettet",
MaxRadius = 20,
HomePage = "www.Hejvej.dk",
FName = "Benny",
LName = "Børge",
Age = 41,
Status = true,
CurrentJob = "HejSigende",
Birthdate = new DateTime(1989, 09, 11),
JobCV = jobCV,
};
//Act
bool check = dbApplier.Update(applier);
//Assert
Assert.IsTrue(check);
}
/// <summary>
/// Returns a JobCV Object by the given Applier
/// </summary>
/// <param name="apllier"></param>
/// <returns></returns>
public JobCV Get(int JobCVId)
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText = "SELECT * FROM JobCV WHERE Id = @Id";
cmd.Parameters.AddWithValue("@Id", JobCVId);
DBApplierEducation dbApplierEducation = new DBApplierEducation();
DBJobAppendix dbJobAppendix = new DBJobAppendix();
DBJobExperience dbJobExperience = new DBJobExperience();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
JobCV jobCV = new JobCV()
{
Id = (int)reader["Id"],
Title = (string)reader["Title"],
Bio = (string)reader["Bio"],
ApplierEducationList = dbApplierEducation.GetAllByJobCVId((int)reader["Id"]),
JobAppendixList = dbJobAppendix.GetAllByJobCVId((int)reader["Id"]),
JobExperienceList = dbJobExperience.GetAllByJobCVId((int)reader["Id"])
};
return(jobCV);
}
else
{
return(null);
}
}
}
}
}
/// <summary>
/// Return a single JobCV Object by the given Applier
/// </summary>
/// <param name="apllier"></param>
/// <returns></returns>
public JobCV Get(int id)
{
using (SqlConnection connection = conn.OpenConnection())
{
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText = "SELECT * FROM JobCV WHERE Id = @Id";
cmd.Parameters.AddWithValue("@Id", id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
JobCV jobCV = new JobCV();
jobCV.Id = (int)reader["Id"];
jobCV.Title = (string)reader["Title"];
jobCV.Bio = (string)reader["Bio"];
return(jobCV);
}
else
{
return(null);
}
}
}
}
/// <summary>
/// Creates a new JobCV in the database returns the Primary key on the Applier.
/// </summary>
/// <param name="obj"></param>
/// <param name="applier"></param>
/// <returns>Applier</returns>
public Applier CreateAndReturnPrimaryKey(JobCV obj, Applier applier)
{
return(jobCVCtr.CreateAndReturnPrimaryKey(obj, applier));
}
public void EditProfile(JobCV cv)
{
Ctx.ApplyValues <JobCV>(cv);
SaveChanges();
}
public void Create(JobCV jobCV, Applier applier)
{
applier.jobCV = dbJobCV.Create(jobCV);
applierCtr.Update(applier);
}
/// <summary>
/// Creates a ned jobCV with no independence on an Applier in the database. This wil not be added to any Applier.
/// </summary>
/// <param name="obj"></param>
public void Create(JobCV jobCV)
{
jobCVCtr.Create(jobCV);
}
public ActionResult _JobCV()
{
JobCV jobCV = new JobCV();
return(PartialView(jobCV));
}
/// <summary>
/// Updates the given JobCV object in the database
/// </summary>
/// <param name="obj"></param>
public void Update(JobCV obj)
{
jobCVCtr.Update(obj);;
}
public void CreateJobCV(JobCV jobCV, Applier applier)
{
jobCVCtr.Create(jobCV, applier);
}
