public static List <CompetencyXSkillDataModel> GetEntityDetails(CompetencyXSkillDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.CompetencyXSkillSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ReturnAuditInfo, BaseDataManager.ReturnAuditInfoOnDetails) + ", " + ToSQLParameter(data, CompetencyXSkillDataModel.DataColumns.CompetencyXSkillId); var result = new List <CompetencyXSkillDataModel>(); using (var reader = new DBDataReader("Get Details", sql, DataStoreKey)) { var dbReader = reader.DBReader; while (dbReader.Read()) { var dataItem = new CompetencyXSkillDataModel(); dataItem.CompetencyXSkillId = (int?)dbReader[CompetencyXSkillDataModel.DataColumns.CompetencyXSkillId]; dataItem.CompetencyId = (int?)dbReader[CompetencyXSkillDataModel.DataColumns.CompetencyId]; dataItem.SkillId = (int?)dbReader[CompetencyXSkillDataModel.DataColumns.SkillId]; dataItem.Competency = (string)dbReader[CompetencyXSkillDataModel.DataColumns.Competency]; dataItem.Skill = (string)dbReader[CompetencyXSkillDataModel.DataColumns.Skill]; SetBaseInfo(dataItem, dbReader); result.Add(dataItem); } } return(result); }
private static string Save(CompetencyXSkillDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.CompetencyXSkillInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.CompetencyXSkillUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, CompetencyXSkillDataModel.DataColumns.CompetencyXSkillId) + ", " + ToSQLParameter(data, CompetencyXSkillDataModel.DataColumns.SkillId) + ", " + ToSQLParameter(data, CompetencyXSkillDataModel.DataColumns.CompetencyId); return(sql); }
public static void Delete(CompetencyXSkillDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.CompetencyXSkillDelete " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, CompetencyXSkillDataModel.DataColumns.CompetencyXSkillId); Framework.Components.DataAccess.DBDML.RunSQL("CompetencyXSkill.Delete", sql, DataStoreKey); }
public static DataTable DoesExist(CompetencyXSkillDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.CompetencyXSkillSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, CompetencyXSkillDataModel.DataColumns.SkillId) + ", " + ToSQLParameter(data, CompetencyXSkillDataModel.DataColumns.CompetencyId); var oDT = new Framework.Components.DataAccess.DBDataTable("CompetencyXSkill.DoesExist", sql, DataStoreKey); return(oDT.DBTable); }
public static DataTable Search(CompetencyXSkillDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.CompetencyXSkillSearch " + " " + BaseDataManager.SetCommonParametersForSearch(requestProfile.AuditId, requestProfile.ApplicationId, requestProfile.ApplicationModeId) + ", " + ToSQLParameter(data, CompetencyXSkillDataModel.DataColumns.CompetencyXSkillId) + ", " + ToSQLParameter(data, CompetencyXSkillDataModel.DataColumns.CompetencyId) + ", " + ToSQLParameter(data, CompetencyXSkillDataModel.DataColumns.SkillId); var oDT = new Framework.Components.DataAccess.DBDataTable("CompetencyXSkill.Search", sql, DataStoreKey); return(oDT.DBTable); }
public static void Update(CompetencyXSkillDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); Framework.Components.DataAccess.DBDML.RunSQL("CompetencyXSkill.Update", sql, DataStoreKey); }
public static CompetencyXSkillDataModel GetDetails(CompetencyXSkillDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile); return(list.FirstOrDefault()); }