/// <summary>
/// Inserts FileUpload data into database
/// FileId will be updated with the database identity
/// </summary>
/// <param name="requirementId">Internship RequirementId</param>
/// <param name="tnx">Transcation crerated from student object</param>
public void Insert(int requirementId, IDbTransaction tnx)
{
try
{
StudentContentDataService dataService = new StudentContentDataService(tnx);
dataService.Insert(ref _fileId, requirementId, _transcript, _resume);
}
catch
{
throw;
}
}
/// <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;
}
}
private void OtherSkillContentInsert(string requirementId, IDbTransaction tnx)
{
StudentContentDataService dataService = new StudentContentDataService(tnx);
try
{
//Resume Content
if (_OtherSkillContent != "") //this checks before if ResumeConent property has data.
{
dataService.OtherSkillContentDelete(requirementId); //Deletes before inserting(subtituing update methods.
dataService.OtherSkillContentInsert(requirementId, _OtherSkillContent);
}
dataService.Txn.Commit();
}
catch
{
dataService.Txn.Rollback();
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;
}
}
private void SkillInsert(string requirementId, IDbTransaction tnx)
{
StudentContentDataService dataService = new StudentContentDataService(tnx);
try
{
dataService.Delete_Res_reference(requirementId); //Deletes before inserting(subtituing update methods.
//Networking
if (_CiscoRouter != "")
{
dataService.SkillInsert(requirementId, _CiscoRouter);
}
if (_WAN != "")
{
dataService.SkillInsert(requirementId, _WAN);
}
if (_TCPIP != "")
{
dataService.SkillInsert(requirementId, _TCPIP);
}
//Security
if (_Data != "")
{
dataService.SkillInsert(requirementId, _Data);
}
if (_Network != "")
{
dataService.SkillInsert(requirementId, _Network);
}
//programming
if (_Java != "")
{
dataService.SkillInsert(requirementId, _Java);
}
if (_Csharp != "")
{
dataService.SkillInsert(requirementId, _Csharp);
}
if (_VBnet != "")
{
dataService.SkillInsert(requirementId, _VBnet);
}
if (_CplusPlus != "")
{
dataService.SkillInsert(requirementId, _CplusPlus);
}
if (_PHP != "")
{
dataService.SkillInsert(requirementId, _PHP);
}
if (_ASPNET != "")
{
dataService.SkillInsert(requirementId, _ASPNET);
}
//Database
if (_SQL != "")
{
dataService.SkillInsert(requirementId, _SQL);
}
if (_Oracle != "")
{
dataService.SkillInsert(requirementId, _Oracle);
}
if (_PMySQL != "")
{
dataService.SkillInsert(requirementId, _PMySQL);
}
dataService.Txn.Commit();
// tnx.Dispose();
}
catch
{
dataService.Txn.Rollback();
throw;
}
}
public void proOtherSkillContentInsert(string ID)
{//start new transaction
using (IDbTransaction Trans = StudentContentDataService.BeginTransaction()) { OtherSkillContentInsert(ID, Trans); };
}
