using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

//using SchnellMedia.Common.CustomLogger;

public class Job

{

        public Guid JobId { get; set; }

        public string PimJobNumber { get; set; }

        public string ContactPerson { get; set; }

        public string Clerk { get; set; }

        public DateTime InDate { get; set; }

        public DateTime OutDate { get; set; }

        public int QuantityForcing { get; set; }

        public string Info { get; set; }

        public DateTime Created { get; set; }

        public DateTime Modified { get; set; }

     public static Job[] GetJobs()

        {

           // Logger log = Global.LogManager.FunctionStart();

​

            SqlConnection sqlConnection = null;

            SqlDataReader sqlReader = null;

            try

            {

                sqlConnection = new SqlConnection(WebGlobals.DBConnectionString);

                sqlConnection.Open();

​

                const string sqlQuery = @"SELECT    [Jobs].[JobId], 

                                                    [Jobs].[PimJobNumber], 

                                                    [Jobs].[ContactPerson], 

                                                    [Jobs].[Clerk], 

                                                    [Jobs].[InDate], 

                                                    [Jobs].[OutDate], 

                                                    [Jobs].[QuantityForcing], 

                                                    [Jobs].[Info], 

                                                    [Jobs].[Created], 

                                                    [Jobs].[Modified] 

                                          FROM 

                                                    [Jobs] 

                                          WHERE 

                                                    [Jobs].[Deleted] IS NULL;";

​

                SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection);

                sqlReader = sqlCommand.ExecuteReader();

​

                List<Job> items = new List<Job>();

                while (sqlReader.Read())

                {

                    Job item = new Job

                    {

                        JobId = (Guid)sqlReader["JobId"],

                        PimJobNumber = (string)sqlReader["PimJobNumber"],

                        ContactPerson = (string)sqlReader["ContactPerson"],

                        Clerk = (string)sqlReader["Clerk"],

                        InDate = (DateTime)sqlReader["InDate"],

                        OutDate = (DateTime)sqlReader["OutDate"],

                        QuantityForcing = (int)sqlReader["QuantityForcing"],

                        Info = (string)sqlReader["Info"],

                        Created = (DateTime)sqlReader["Created"],

                        Modified = sqlReader["Modified"] == DBNull.Value ? DateTime.MinValue : (DateTime)sqlReader["Modified"],

                    };

                    items.Add(item);

                }

​

                items.Sort((item, item2) => System.String.Compare(item.PimJobNumber, item2.PimJobNumber, System.StringComparison.Ordinal));

                log.FunctionEnd("Successed. Resultcount: " + items.Count);

                return items.ToArray();

            }

            catch (Exception ex)

            {

                log.FunctionEnd("An error occured while trying to get the jobs. Error:" + ex.Message);

            }

            finally

            {

                if (sqlReader != null && !sqlReader.IsClosed)

                {

                    sqlReader.Close();

                }

                if (sqlConnection != null && sqlConnection.State != ConnectionState.Closed)

                {

                    sqlConnection.Close();

                }

            }

            return null;

        }

}