public bool Edit(IPersonalSkills _personalSkills, int ID)
{
var personalSkills = (_personalSkills as DeveloperPersonalSkillsEntity);
string str = string.Empty;
try
{
str = string.Format(@"update tblDeveloperPersonalSkills set Leadership = {0},Communication= {1},TimeManagement ={2},
Counselling = {3},Teamwork ={4},ObjectOrientedDesign ={5},StructuredDesign ={6},ArchitecturalPattern ={7},
DesignPattern ={8},ObjectOrientedAnalysis ={9},ObjectOrientedAnalysis ={9},UML ={10},ApplicationArchitectureDesign ={11},
ExternalDesignJP ={12},DetailedDesign ={12},JobKpiAssessmentID ={13} where ID = {14}",
(int)personalSkills.Leadership,
(int)personalSkills.Communication,
(int)personalSkills.TimeManagement,
(int)personalSkills.Counselling,
(int)personalSkills.Teamwork,
(int)personalSkills.ObjectOrientedDesign,
(int)personalSkills.StructuredDesign,
(int)personalSkills.ArchitecturalPattern,
(int)personalSkills.DesignPattern,
(int)personalSkills.ObjectOrientedAnalysis,
(int)personalSkills.UML,
(int)personalSkills.ApplicationArchitectureDesign,
(int)personalSkills.ExternalDesignJP,
(int)personalSkills.DetailedDesign,
personalSkills.JobKpiAssessment.ID,
ID
);
DBManager.InstantDBManger.QueryExecutionWithTransaction(str);
return(true);
}
catch (Exception exp)
{
CommonFunctions.ShowErrorDialog("SQL error:" + exp.ToString());
return(false);
}
}
public bool Add(IPersonalSkills _personalSkills)
{
var personalSkills = (_personalSkills as DeveloperPersonalSkillsEntity);
string str = string.Empty;
try
{
str = string.Format(@"insert into tblDeveloperPersonalSkills (Leadership,Communication,TimeManagement,
Counselling,Teamwork,ObjectOrientedDesign,StructuredDesign,ArchitecturalPattern,
DesignPattern,ObjectOrientedAnalysis,UML,ApplicationArchitectureDesign,ExternalDesignJP,DetailedDesign,JobKpiAssessmentID)
values ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14})",
(int)personalSkills.Leadership,
(int)personalSkills.Communication,
(int)personalSkills.TimeManagement,
(int)personalSkills.Counselling,
(int)personalSkills.Teamwork,
(int)personalSkills.ObjectOrientedDesign,
(int)personalSkills.StructuredDesign,
(int)personalSkills.ArchitecturalPattern,
(int)personalSkills.DesignPattern,
(int)personalSkills.ObjectOrientedAnalysis,
(int)personalSkills.UML,
(int)personalSkills.ApplicationArchitectureDesign,
(int)personalSkills.ExternalDesignJP,
(int)personalSkills.DetailedDesign,
personalSkills.JobKpiAssessment.ID
);
DBManager.InstantDBManger.QueryExecutionWithTransaction(str);
return(true);
}
catch (Exception exp)
{
CommonFunctions.ShowErrorDialog("SQL error:" + exp.ToString());
return(false);
}
}
internal MySkills(byte[] binData)
{
_binData = binData;
// Weaponry skills
byte[] binDataWeaponry = new byte[lengthWeaponry];
Array.Copy(_binData, offsetWeaponry, binDataWeaponry, 0, lengthWeaponry);
_weaponry = new MyWeaponrySkills(binDataWeaponry);
// Physical skills
byte[] binDataPhysical = new byte[lengthPhysical];
Array.Copy(_binData, offsetPhysical, binDataPhysical, 0, lengthPhysical);
_physical = new MyPhysicalSkills(binDataPhysical);
// Personal skills
byte[] binDataPersonal = new byte[lengthPersonal];
Array.Copy(_binData, offsetPersonal, binDataPersonal, 0, lengthPersonal);
_personal = new MyPersonalSkills(binDataPersonal);
// Academia skills
byte[] binDataAcademia = new byte[lengthAcademia];
Array.Copy(_binData, offsetAcademia, binDataAcademia, 0, lengthAcademia);
_academia = new MyAcademiaSkills(binDataAcademia);
}
