public static request getRequestById(int id)
 {
     var result = new request();
     SqlDataReader myReader;
     using (var myConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ChartConnection"].ConnectionString))
     {
         using (var myCmd = new SqlCommand("GetRequestByID " + id, myConn))
         {
             try
             {
                 myConn.Open();
                 myReader = myCmd.ExecuteReader();
                 if (myReader.HasRows)
                 {
                     while (myReader.Read())
                     {
                         result.id = (int)myReader["id"];
                         result.mar = (int)myReader["mar"];
                         result.login = (string)myReader["login"];
                         result.bu_id = (int)myReader["bu_id"];
                         result.part_id = (int)myReader["part_id"];
                         result.batch = (string)myReader["batch"];
                         result.run_det = (string)myReader["run_det"];
                         result.due_date = (DateTime)myReader["due_date"];
                         result.sta_id = (int)myReader["sta_id"];
                         result.pri_id = (int)myReader["pri_id"];
                         result.userID = (int)myReader["userID"];
                         result.act_due_date = (DateTime)myReader["act_due_date"];
                         result.meas_method = checkIfNull(myReader["meas_method"].ToString());
                         result.comment = checkIfNull(myReader["comment"].ToString());
                         result.work_req = checkIfNull(myReader["work_req"].ToString());
                         result.attachment = checkIfNull(myReader["attachment"].ToString());
                         result.aps_id = checkIfInt(myReader["aps_id"].ToString());
                         result.mac_id = checkIfInt(myReader["mac_id"].ToString());
                         result.rfr_id = checkIfInt(myReader["rfr_id"].ToString());
                         result.rework = Boolean.Parse(myReader["rework"].ToString());
                         result.include_full_fair_report_required = checkIfInt(myReader["include_full_fair_report_required"].ToString());
                         result.cad_compare_volume_graphics = checkIfInt(myReader["cad_compare_volume_graphics"].ToString());
                         result.volume_graphics = checkIfInt(myReader["volume_graphics"].ToString());
                         result.other_please_specify = checkIfInt(myReader["other_please_specify"].ToString());
                         result.cmm_measurement = checkIfInt(myReader["cmm_measurement"].ToString());
                         result.vmm_measurement = checkIfInt(myReader["vmm_measurement"].ToString());
                         result.ocps_comments = checkIfNull(myReader["ocps_comments"].ToString());
                     }
                 }
             }
             catch (Exception e)
             {
                 var x = e.ToString();
             }
         }
     }
     return result;
 }