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