public static string ToSQLParameter(TaskNoteDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case TaskNoteDataModel.DataColumns.TaskNoteId:
if (data.TaskNoteId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskNoteDataModel.DataColumns.TaskNoteId, data.TaskNoteId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskNoteDataModel.DataColumns.TaskNoteId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public void SetData(TaskNoteDataModel item)
{
SystemKeyId = item.TaskNoteId;
base.SetData(item);
}
public static DataTable Search(TaskNoteDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 0);
return(list.ToDataTable());
}
public static void Update(TaskNoteDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("TaskNote.Update", sql, DataStoreKey);
}
public static TaskNoteDataModel GetDetails(TaskNoteDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 0);
return(list.FirstOrDefault());
}
public void SetData(TaskNoteDataModel data)
{
SystemKeyId = data.TaskNoteId;
base.SetData(data);
}
public virtual string GetSearchProcedureScript(List <string> searchableColumns)
{
var obj = new TaskNoteDataModel();
return(base.GetSearchProcedureScript(searchableColumns, obj.GetType()));
}
public virtual string GetUpdateProcedureScript()
{
var obj = new TaskNoteDataModel();
return(base.GetUpdateProcedureScript(obj.GetType()));
}
public static void Update(TaskNoteDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Update");
DBDML.RunSQL("Clent.Update", sql, DataStoreKey);
}
private void ReBindEditableGrid()
{
var data = new TaskNoteDataModel();
var dtTaskNote = TaskTimeTracker.Components.BusinessLayer.Task.TaskNoteDataManager.Search(data, SessionVariables.RequestProfile);
}
