private static string Save(TaskPriorityXApplicationUserDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.TaskPriorityXApplicationUserInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.TaskPriorityXApplicationUserUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityXApplicationUserId) + ", " + ToSQLParameter(data, TaskPriorityXApplicationUserDataModel.DataColumns.TaskId) + ", " + ToSQLParameter(data, TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityTypeId) + ", " + ToSQLParameter(data, TaskPriorityXApplicationUserDataModel.DataColumns.ApplicationUserId) + ", " + ToSQLParameter(data, BaseDataModel.BaseDataColumns.UpdatedBy) + ", " + ToSQLParameter(data, BaseDataModel.BaseDataColumns.UpdatedDate); return(sql); }
public static List <TaskPriorityXApplicationUserDataModel> GetEntityDetails(TaskPriorityXApplicationUserDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TaskPriorityXApplicationUserSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ReturnAuditInfo, BaseDataManager.ReturnAuditInfoOnDetails) + ", " + ToSQLParameter(data, TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityXApplicationUserId); var result = new List <TaskPriorityXApplicationUserDataModel>(); using (var reader = new DBDataReader("Get Details", sql, DataStoreKey)) { var dbReader = reader.DBReader; while (dbReader.Read()) { var dataItem = new TaskPriorityXApplicationUserDataModel(); dataItem.TaskPriorityXApplicationUserId = (int?)dbReader[TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityXApplicationUserId]; dataItem.TaskId = (int?)dbReader[TaskPriorityXApplicationUserDataModel.DataColumns.TaskId]; dataItem.TaskPriorityTypeId = (int?)dbReader[TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityTypeId]; dataItem.ApplicationUserId = (int?)dbReader[TaskPriorityXApplicationUserDataModel.DataColumns.ApplicationUserId]; //SetBaseInfo(dataItem, dbReader); result.Add(dataItem); } } return(result); }
public static void Delete(TaskPriorityXApplicationUserDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TaskPriorityXApplicationUserDelete " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityXApplicationUserId); Framework.Components.DataAccess.DBDML.RunSQL("TaskPriorityXApplicationUser.Delete", sql, DataStoreKey); }
public static bool DoesExist(TaskPriorityXApplicationUserDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TaskPriorityXApplicationUserSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " + ToSQLParameter(data, TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityXApplicationUserId); var oDT = new Framework.Components.DataAccess.DBDataTable("TaskPriorityXApplicationUser.DoesExist", sql, DataStoreKey); return(oDT.DBTable.Rows.Count > 0); }
public static string ToSQLParameter(TaskPriorityXApplicationUserDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityXApplicationUserId: if (data.TaskPriorityXApplicationUserId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityXApplicationUserId, data.TaskPriorityXApplicationUserId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityXApplicationUserId); } break; case TaskPriorityXApplicationUserDataModel.DataColumns.TaskId: if (data.TaskId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskPriorityXApplicationUserDataModel.DataColumns.TaskId, data.TaskId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskPriorityXApplicationUserDataModel.DataColumns.TaskId); } break; case TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityTypeId: if (data.TaskPriorityTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityTypeId, data.TaskPriorityTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityTypeId); } break; case TaskPriorityXApplicationUserDataModel.DataColumns.ApplicationUserId: if (data.ApplicationUserId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskPriorityXApplicationUserDataModel.DataColumns.ApplicationUserId, data.ApplicationUserId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskPriorityXApplicationUserDataModel.DataColumns.ApplicationUserId); } break; } return(returnValue); }
public static DataTable Search(TaskPriorityXApplicationUserDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.TaskPriorityXApplicationUserSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityXApplicationUserId) + ", " + ToSQLParameter(data, TaskPriorityXApplicationUserDataModel.DataColumns.TaskId) + ", " + ToSQLParameter(data, TaskPriorityXApplicationUserDataModel.DataColumns.TaskPriorityTypeId) + ", " + ToSQLParameter(data, TaskPriorityXApplicationUserDataModel.DataColumns.ApplicationUserId); var oDT = new Framework.Components.DataAccess.DBDataTable("TaskPriorityXApplicationUser.Search", sql, DataStoreKey); return(oDT.DBTable); }
public static void Update(TaskPriorityXApplicationUserDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); Framework.Components.DataAccess.DBDML.RunSQL("TaskPriorityXApplicationUser.Update", sql, DataStoreKey); }
public static TaskPriorityXApplicationUserDataModel GetDetails(TaskPriorityXApplicationUserDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile); return(list.FirstOrDefault()); }