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); }