private static string Save(SkillXPersonXSkillLevelDataModel data, RequestProfile requestProfile, string action)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.SkillXPersonXSkillLevelInsert " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
break;
case "Update":
sql += "dbo.SkillXPersonXSkillLevelUpdate " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.SkillXPersonXSkillLevelId) +
", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.SkillId) +
", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.PersonId) +
", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevelId);
return(sql);
}
private DataTable GetData(string name)
{
var data = new SkillXPersonXSkillLevelDataModel();
var dt = SkillXPersonXSkillLevelDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected override void ShowData(int skillXPersonXSkillLevelId)
{
oDetailButtonPanel.SetId = SetId;
var data = new SkillXPersonXSkillLevelDataModel();
data.SkillXPersonXSkillLevelId = skillXPersonXSkillLevelId;
var dt = SkillXPersonXSkillLevelDataManager.GetDetails(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
var row = dt.Rows[0];
lblSkillXPersonXSkillLevelId.Text = Convert.ToString(row[SkillXPersonXSkillLevelDataModel.DataColumns.SkillXPersonXSkillLevelId]);
lblSkillLevel.Text = Convert.ToString(row[SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevel]);
lblSkill.Text = Convert.ToString(row[SkillXPersonXSkillLevelDataModel.DataColumns.Skill]);
lblPerson.Text = Convert.ToString(row[SkillXPersonXSkillLevelDataModel.DataColumns.Person]);
oUpdateInfo.LoadText(dt.Rows[0]);
oHistoryList.Setup((int)SystemEntity.SkillXPersonXSkillLevel, skillXPersonXSkillLevelId, "SkillXPersonXSkillLevel");
dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "SkillXPersonXSkillLevel");
}
else
{
Clear();
}
}
public static List <SkillXPersonXSkillLevelDataModel> GetEntityDetails(SkillXPersonXSkillLevelDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.SkillXPersonXSkillLevelSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = requestProfile.ApplicationId
, ReturnAuditInfo = returnAuditInfo
, SkillXPersonXSkillLevelId = dataQuery.SkillXPersonXSkillLevelId
, SkillId = dataQuery.SkillId
, PersonId = dataQuery.PersonId
, SkillLevelId = dataQuery.SkillLevelId
};
List <SkillXPersonXSkillLevelDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <SkillXPersonXSkillLevelDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static void Delete(SkillXPersonXSkillLevelDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.SkillXPersonXSkillLevelDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.SkillXPersonXSkillLevelId) +
", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.SkillId) +
", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.PersonId) +
", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevelId);
Framework.Components.DataAccess.DBDML.RunSQL("SkillXPersonXSkillLevel.Delete", sql, DataStoreKey);
}
public static bool DoesExist(SkillXPersonXSkillLevelDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.SkillXPersonXSkillLevelSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.SkillXPersonXSkillLevelId);
var oDT = new Framework.Components.DataAccess.DBDataTable("SkillXPersonXSkillLevel.DoesExist", sql, DataStoreKey);
return(oDT.DBTable.Rows.Count > 0);
}
public static DataTable Search(SkillXPersonXSkillLevelDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.SkillXPersonXSkillLevelSearch " +
" " + BaseDataManager.SetCommonParametersForSearch(requestProfile.AuditId, requestProfile.ApplicationId, requestProfile.ApplicationModeId) +
", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.SkillXPersonXSkillLevelId) +
", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.SkillId) +
", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.PersonId) +
", " + ToSQLParameter(data, SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevelId);
var oDT = new Framework.Components.DataAccess.DBDataTable("SkillXPersonXSkillLevel.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
public void LoadData(int skillXPersonXSkillLevelId, bool showId)
{
var data = new SkillXPersonXSkillLevelDataModel();
data.SkillXPersonXSkillLevelId = skillXPersonXSkillLevelId;
var oSkillXPersonXSkillLevelTable = SkillXPersonXSkillLevelDataManager.GetDetails(data, SessionVariables.RequestProfile);
if (oSkillXPersonXSkillLevelTable.Rows.Count == 1)
{
var row = oSkillXPersonXSkillLevelTable.Rows[0];
if (!showId)
{
txtSkillXPersonXSkillLevelId.Text = Convert.ToString(row[SkillXPersonXSkillLevelDataModel.DataColumns.SkillXPersonXSkillLevelId]);
// only show Audit History in case of Update page, not for Clone.
oHistoryList.Setup((int)SystemEntity.SkillXPersonXSkillLevel, skillXPersonXSkillLevelId, "SkillXPersonXSkillLevel");
dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "SkillXPersonXSkillLevel");
}
else
{
txtSkillXPersonXSkillLevelId.Text = String.Empty;
}
txtSkillLevelId.Text = Convert.ToString(row[SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevelId]);
txtSkillId.Text = Convert.ToString(row[SkillXPersonXSkillLevelDataModel.DataColumns.SkillId]);
txtPersonId.Text = Convert.ToString(row[SkillXPersonXSkillLevelDataModel.DataColumns.PersonId]);
drpPersonList.SelectedValue = Convert.ToString(row[SkillXPersonXSkillLevelDataModel.DataColumns.PersonId]);
drpSkillList.SelectedValue = Convert.ToString(row[SkillXPersonXSkillLevelDataModel.DataColumns.SkillId]);
drpSkillLevelList.SelectedValue = Convert.ToString(row[SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevelId]);
}
else
{
txtSkillXPersonXSkillLevelId.Text = String.Empty;
txtSkillId.Text = String.Empty;
txtPersonId.Text = String.Empty;
txtSkillLevelId.Text = String.Empty;
}
}
public static string ToSQLParameter(SkillXPersonXSkillLevelDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case SkillXPersonXSkillLevelDataModel.DataColumns.SkillXPersonXSkillLevelId:
if (data.SkillXPersonXSkillLevelId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SkillXPersonXSkillLevelDataModel.DataColumns.SkillXPersonXSkillLevelId, data.SkillXPersonXSkillLevelId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SkillXPersonXSkillLevelDataModel.DataColumns.SkillXPersonXSkillLevelId);
}
break;
case SkillXPersonXSkillLevelDataModel.DataColumns.SkillId:
if (data.SkillId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SkillXPersonXSkillLevelDataModel.DataColumns.SkillId, data.SkillId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SkillXPersonXSkillLevelDataModel.DataColumns.SkillId);
}
break;
case SkillXPersonXSkillLevelDataModel.DataColumns.PersonId:
if (data.PersonId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SkillXPersonXSkillLevelDataModel.DataColumns.PersonId, data.PersonId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SkillXPersonXSkillLevelDataModel.DataColumns.PersonId);
}
break;
case SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevelId:
if (data.SkillLevelId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevelId, data.SkillLevelId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevelId);
}
break;
case SkillXPersonXSkillLevelDataModel.DataColumns.Skill:
if (!string.IsNullOrEmpty(data.Skill))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SkillXPersonXSkillLevelDataModel.DataColumns.Skill, data.Skill);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SkillXPersonXSkillLevelDataModel.DataColumns.Skill);
}
break;
case SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevel:
if (!string.IsNullOrEmpty(data.SkillLevel))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevel, data.SkillLevel);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SkillXPersonXSkillLevelDataModel.DataColumns.SkillLevel);
}
break;
}
return(returnValue);
}
public static void Update(SkillXPersonXSkillLevelDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
Framework.Components.DataAccess.DBDML.RunSQL("SkillXPersonXSkillLevel.Update", sql, DataStoreKey);
}
public static SkillXPersonXSkillLevelDataModel GetDetails(SkillXPersonXSkillLevelDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}