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; }