public InternshipRequirement()
{
_requirementId = -1;
studentContent = new StudentContent();
ModulesTaken = new ModuleTakenCollection();
PreferenceRanks = new PreferenceRankCollection();
_limitationExplanation = "";
}
// returns all properties previews inserted into the data base .
//notice: if no values are found in the data base all properties will be empty
// only using for editing skills values
public StudentContent LoadItAll(String requirementId)
{
StudentContent objSC = new StudentContent();
objSC.MadDataSkills(requirementId);
objSC.MapDataResumeContent(requirementId);
objSC.MapDataTranscriptContent(requirementId);
objSC.MapDataOtherSkillsContent(requirementId);
return(objSC);
}
/// <summary>
/// Creates a FileUpload object with data Loaded from the database
/// </summary>
/// <param name="requirementId"> Internship RequirementId</param>
/// <returns></returns>
public static StudentContent Load(int requirementId)
{
try
{
StudentContentDataService dataService = new StudentContentDataService();
DataSet ds = dataService.Load(requirementId);
StudentContent objFile = new StudentContent();
return((objFile.MapData(ds)) ? objFile : null);
}
catch
{
throw;
}
}
public StudentContent MapDataOtherSkillsContent(string requirementId)
{
try
{
StudentContent objSC = new StudentContent();
StudentContentDataService myDataService = new StudentContentDataService();
DataTable MyDatatable = myDataService.LoadOtherSkillContent(requirementId);
foreach (DataRow row in MyDatatable.Rows)
{
string temp = row.ItemArray[0] as string;
this.OtherSkillContent = temp;
objSC.OtherSkillContent = temp;
}
return(objSC);
}
catch
{
throw;
}
}
public StudentContent MadDataSkills(string requirementId)
{
try
{
StudentContent objSC = new StudentContent();
StudentContentDataService myDataService = new StudentContentDataService();
DataTable MyDatatable = myDataService.LoadSkillReport(requirementId);
foreach (DataRow row in MyDatatable.Rows)
{
string temp = row.ItemArray[0] as string;
switch (temp)
{
case "1":
this.CiscoRouter = temp;
objSC.CiscoRouter = temp;
break;
case "2":
this.WAN = temp;
objSC.WAN = temp;
break;
case "3":
this.TCPIP = temp;
objSC.TCPIP = temp;
break;
case "4":
this.Data = temp;
objSC.Data = temp;
break;
case "5":
this.Network = temp;
objSC.Network = temp;
break;
case "6":
this.Java = temp;
objSC.Java = temp;
break;
case "7":
this.Csharp = temp;
objSC.Csharp = temp;
break;
case "8":
this.VBNET = temp;
objSC.VBNET = temp;
break;
case "9":
this.CplusPlus = temp;
objSC.CplusPlus = temp;
break;
case "10":
this.PHP = temp;
objSC.PHP = temp;
break;
case "11":
this.ASPNET = temp;
objSC.ASPNET = temp;
break;
case "12":
this.SQL = temp;
objSC.SQL = temp;
break;
case "13":
this.Oracle = temp;
objSC.Oracle = temp;
break;
case "14":
this.PMySQL = temp;
objSC.PMySQL = temp;
break;
}
}
return(objSC);
}
catch
{
throw;
}
}