private List<Signatures> GetSignaturesInformation(SqlConnection con, string signaturesId)
 {
     var listSig = new List<Signatures>();
     try
     {
         var daSig = new SqlDataAdapter("GetSignaturesInformation", con) { SelectCommand = { CommandType = CommandType.StoredProcedure } };
         daSig.SelectCommand.Parameters.Add(new SqlParameter("@TSID", SqlDbType.Int)).Value = signaturesId;
         var dsSig = new DataSet();
         daSig.Fill(dsSig);
         if (dsSig.Tables[0].Rows.Count > 0)
         {
             for (int i = 0; i < dsSig.Tables[0].Rows.Count; i++)
             {
                 var signatures = new Signatures
                                      {
                                          _name = dsSig.Tables[0].Rows[i]["Name"].ToString(),
                                          _signatureContent = dsSig.Tables[0].Rows[i]["TContent"].ToString(),
                                          _signatureType =
                                              (SignatureType)
                                              Enum.Parse(typeof(SignatureType),
                                                         dsSig.Tables[0].Rows[i]["SType"].ToString())
                                      };
                 listSig.Add(signatures);
             }
         }
     }
     catch (Exception)
     {
         return listSig;
     }
     return listSig;
 }
 private List<Signatures> GetSignaturesInformation(SqlConnection con, string signaturesId)
 {
     List<Signatures> listSig = new List<Signatures>();
     Signatures signatures = new Signatures();
     SqlDataAdapter daSig = new SqlDataAdapter("select SignatureId,TContent,Name from Treatment_Signature where TSID=" + signaturesId + "", con);
     DataSet dsSig = new DataSet();
     daSig.Fill(dsSig);
     if (dsSig.Tables[0].Rows.Count > 0)
     {
         for (int i = 0; i < dsSig.Tables[0].Rows.Count; i++)
         {
             signatures._name = dsSig.Tables[0].Rows[i]["Name"].ToString();
             signatures._signatureContent = dsSig.Tables[0].Rows[i]["TContent"].ToString();
             SqlCommand cmdProcedure = new SqlCommand("select [Type] from Signatures where Id='" + dsSig.Tables[0].Rows[i]["SignatureId"].ToString() + "'", con);
             using (var read = cmdProcedure.ExecuteReader())
             {
                 if (read.Read())
                 {
                     signatures._signatureType = (SignatureType)Enum.Parse(typeof(SignatureType), read["Type"].ToString());
                 }
             }
             listSig.Add(signatures);
         }
     }
     return listSig;
 }