public static Entities.PublicationEntities.PublicationTask GetPublicationTask(int publicationTaskID) { DAL.Utilities.Helper helper = new DAL.Utilities.Helper(_connectionString); Entities.PublicationEntities.PublicationTask publicationTask = new Entities.PublicationEntities.PublicationTask(); SqlCommand command = new SqlCommand(); command.CommandTimeout = 10; command.CommandType = CommandType.StoredProcedure; command.CommandText = "GetPublicationTask"; command.Parameters.Add("@PublicationTaskID", System.Data.SqlDbType.Int).Value = publicationTaskID; DataTable dataTable = helper.GetDataTable(command); if (dataTable.Rows.Count == 0) { publicationTask = null; } else { publicationTask = DAL.PublicationDAL.PublicationTaskEntityTransformer.ConvertRowToPublicationTask(dataTable.Rows[0]); } return(publicationTask); }
public static bool SavePublicationTask(Entities.PublicationEntities.PublicationTask publicationTask) { //Save and return a copy of the task //DAL.Helper helper = new Helper(connectionString); bool result = false; SqlCommand command = new SqlCommand(); command.CommandTimeout = 10; command.CommandType = CommandType.StoredProcedure; command.CommandText = "SavePublicationTask"; command.Parameters.Add("@PublicationTaskID", System.Data.SqlDbType.Int).Value = publicationTask.PublicationTaskID; command.Parameters.Add("@Name", System.Data.SqlDbType.NVarChar).Value = publicationTask.Name; command.Parameters.Add("@Status", System.Data.SqlDbType.Int).Value = publicationTask.Status; DAL.Utilities.Helper helper = new DAL.Utilities.Helper(_connectionString); result = helper.ExecuteCommand(command); command.Dispose(); return(result); }
public static Entities.PublicationEntities.PublicationTask CreatePublicationTask(Entities.PublicationEntities.PublicationTask publicationTask) { string sql = string.Empty; sql = @"INSERT INTO PublicationTask (Name, Published, Status) "; sql += @"VALUES (@Name, @Published, @Status);"; sql += @"SELECT CAST(SCOPE_IDENTITY() AS INT)"; try { SqlCommand command = new SqlCommand(sql); command.CommandText = sql; command.Parameters.Add("@Name", System.Data.SqlDbType.NVarChar).Value = publicationTask.Name; command.Parameters.Add("@Status", System.Data.SqlDbType.Int).Value = publicationTask.Status; DAL.Utilities.Helper helper = new DAL.Utilities.Helper(_connectionString); int publicationTaskID = helper.ExecuteCommandScalar(command); if (publicationTaskID > 0) { publicationTask.PublicationTaskID = publicationTaskID; } else { publicationTask = null; } } catch (Exception ex) { string errorMessage = ex.Message; publicationTask = null; } return(publicationTask); }