public bool Edit(IProfessionalContribution _developerProfessionalContribution, int ID)
{
var developerProfessionalContribution = (_developerProfessionalContribution as DeveloperProfessionalContributionEntity);
string str = string.Empty;
try
{
str = string.Format(@"update tblDeveloperProfessionalContribution set MasterProgrammingLanguages = {0},MasterUnitTesting= {1},MasterClientFramework ={2},
MasterSofwareDevelopmentFramework = {3},IntructorAtCompany ={4},SharingAtWorkshop ={5},DevelopTrainningCourse ={6},SubmissionImprovementProposal ={7},
ActivitesInComunity ={8},DevelopsSubordinates ={9},JobKpiAssessmentID ={10} where ID = {11}",
(int)developerProfessionalContribution.MasterProgrammingLanguages,
(int)developerProfessionalContribution.MasterUnitTesting,
(int)developerProfessionalContribution.MasterClientFramework,
(int)developerProfessionalContribution.MasterSofwareDevelopmentFramework,
(bool)developerProfessionalContribution.IntructorAtCompany,
(bool)developerProfessionalContribution.SharingAtWorkshop,
(bool)developerProfessionalContribution.DevelopTrainningCourse,
(bool)developerProfessionalContribution.SubmissionImprovementProposal,
(bool)developerProfessionalContribution.ActivitesInComunity,
(bool)developerProfessionalContribution.DevelopsSubordinates,
developerProfessionalContribution.JobKpiAssessment.ID,
ID
);
DBManager.InstantDBManger.QueryExecutionWithTransaction(str);
return(true);
}
catch (Exception exp)
{
CommonFunctions.ShowErrorDialog("SQL error:" + exp.ToString());
return(false);
}
}
public bool Add(IProfessionalContribution _developerProfessionalContribution)
{
var developerProfessionalContribution = (_developerProfessionalContribution as DeveloperProfessionalContributionEntity);
string str = string.Empty;
try
{
str = string.Format(@"insert into tblDeveloperProfessionalContribution (MasterProgrammingLanguages,MasterUnitTesting,MasterClientFramework,
MasterSofwareDevelopmentFramework,IntructorAtCompany,SharingAtWorkshop,DevelopTrainningCourse,SubmissionImprovementProposal,ActivitesInComunity,DevelopsSubordinates,JobKpiAssessmentID)
values ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10})",
(int)developerProfessionalContribution.MasterProgrammingLanguages,
(int)developerProfessionalContribution.MasterUnitTesting,
(int)developerProfessionalContribution.MasterClientFramework,
(int)developerProfessionalContribution.MasterSofwareDevelopmentFramework,
(bool)developerProfessionalContribution.IntructorAtCompany,
(bool)developerProfessionalContribution.SharingAtWorkshop,
(bool)developerProfessionalContribution.DevelopTrainningCourse,
(bool)developerProfessionalContribution.SubmissionImprovementProposal,
(bool)developerProfessionalContribution.ActivitesInComunity,
(bool)developerProfessionalContribution.DevelopsSubordinates,
developerProfessionalContribution.JobKpiAssessment.ID
);
DBManager.InstantDBManger.QueryExecutionWithTransaction(str);
return(true);
}
catch (Exception exp)
{
CommonFunctions.ShowErrorDialog("SQL error:" + exp.ToString());
return(false);
}
}
