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