public static string GetDigitalSignature(int signatureId) { string base64String = string.Empty; try { DigitalSignatureBE signature = null; using (SqlConnection conn = new SqlConnection(_connectionstring)) { conn.Open(); SqlCommand cmd = new SqlCommand("usp_DigitalSignature_Fetch", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("SignatureID", signatureId); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) signature = ToDigitalSignatureBE(reader); } } if (signature != null) { base64String = Convert.ToBase64String(signature.Blob, 0, signature.Blob.Length); base64String = "data:image/png;base64," + base64String; } } catch (Exception e) { } return base64String; }
private static DigitalSignatureBE ToDigitalSignatureBE(SqlDataReader rdr) { DigitalSignatureBE o = new DigitalSignatureBE(); o.SignatureID = Convert.ToInt32(rdr["SignatureID"]); o.UserID = Convert.ToString(rdr["UserID"]); o.Blob = rdr["Blob"] != DBNull.Value ? (byte[])(rdr["Blob"]) : null; o.DigitalSignatoryTypeSurrogate = Convert.ToInt32(rdr["DigitalSignatoryTypeSurrogate"]); o.CreationDateTime = Convert.ToDateTime(rdr["CreationDateTime"]); o.LastUpdatedDate = Convert.ToDateTime(rdr["LastUpdatedDate"]); return o; }
public static void UpdateDigitalSignature(DigitalSignatureBE o) { using (SqlConnection conn = new SqlConnection(_connectionstring)) { conn.Open(); SqlCommand cmd = new SqlCommand("usp_DigitalSignature_Update", conn); cmd.CommandType = CommandType.StoredProcedure; BusinessEntityHelper.ReplaceNullProperties<DigitalSignatureBE>(o); FromDigitalSignatureBE(ref cmd, o); cmd.Parameters.AddWithValue("LastUpdatedDate", DateTime.Now); cmd.ExecuteNonQuery(); } }
private static void FromDigitalSignatureBE(ref SqlCommand cmd, DigitalSignatureBE o) { cmd.Parameters.AddWithValue("SignatureID", o.SignatureID); cmd.Parameters.AddWithValue("UserID", o.UserID); cmd.Parameters.AddWithValue("CreationDateTime", o.CreationDateTime); cmd.Parameters.AddWithValue("DigitalSignatoryTypeSurrogate", o.DigitalSignatoryTypeSurrogate); if (o.Blob != null) { cmd.Parameters.AddWithValue("Blob", o.Blob); } else { cmd.Parameters.AddWithValue("Blob", DBNull.Value); cmd.Parameters["Blob"].SqlDbType = SqlDbType.Image; } }
public static void AddDigitalSignature(DigitalSignatureBE o, out int createdSurrogate) { createdSurrogate = 0; using (SqlConnection conn = new SqlConnection(_connectionstring)) { conn.Open(); SqlCommand cmd = new SqlCommand("usp_DigitalSignature_Add", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Surrogate", SqlDbType.Int, 8).Direction = ParameterDirection.Output; BusinessEntityHelper.ReplaceNullProperties<DigitalSignatureBE>(o); FromDigitalSignatureBE(ref cmd, o); cmd.ExecuteNonQuery(); if (cmd.Parameters["Surrogate"].Value != DBNull.Value) { createdSurrogate = Convert.ToInt32(cmd.Parameters["Surrogate"].Value); } } }
public static DigitalSignatureBE FetchDigitalSignature(int surrogate) { DigitalSignatureBE o = null; using (SqlConnection conn = new SqlConnection(_connectionstring)) { conn.Open(); SqlCommand cmd = new SqlCommand("usp_DigitalSignature_Fetch", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("SignatureID", surrogate); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) o = ToDigitalSignatureBE(reader); } } return o; }