public clsReceiptAttachment GetReceiptAttachment(int id) { clsReceiptAttachment attachment1 = new clsReceiptAttachment(); try { using (SqlConnection conn = new SqlConnection(strConn)) { conn.Open(); { using (SqlCommand cmd = new SqlCommand("TMR_USP_GetReceiptAttachment")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.AddWithValue("@id", id); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { attachment1.RegistrationNo = reader["RegistrationNo"].ToString(); attachment1.ReceiptNumber = reader["ReceiptNumber"].ToString(); attachment1.FileName = reader["fileName"].ToString(); attachment1.FileContents = (byte[])reader["fileData"]; } } } } conn.Close(); } } catch (Exception ex) { } return(attachment1); }
public List <clsReceiptAttachment> GetReceiptAttachments(string strMember, string strReceiptNumber) { List <clsReceiptAttachment> attachments = new List <clsReceiptAttachment>(); try { using (SqlConnection conn = new SqlConnection(strConn)) { conn.Open(); { using (SqlCommand cmd = new SqlCommand("TMR_USP_GetReceiptAttachments")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.AddWithValue("@RegistrationNo", strMember); cmd.Parameters.AddWithValue("@ReceiptNumber", strReceiptNumber); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { clsReceiptAttachment attach = new clsReceiptAttachment(); attach.RegistrationNo = reader["RegistrationNo"].ToString(); attach.ReceiptNumber = reader["ReceiptNumber"].ToString(); attach.FileName = reader["fileName"].ToString(); attach.FileDate = Convert.ToDateTime(reader["FileDate"]); attach.Remarks = reader["Remarks"].ToString(); attach.id = Convert.ToInt32(reader["id"]); attachments.Add(attach); } } } } conn.Close(); } } catch (Exception ex) { } return(attachments); }
public bool AddReceiptAttachment(clsReceiptAttachment attachment) { int st = 0; try { using (SqlConnection conn = new SqlConnection(strConn)) { conn.Open(); { using (SqlCommand cmd = new SqlCommand("TMR_USP_AddReceiptAttachment")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.AddWithValue("@RegistrationNo", attachment.RegistrationNo); cmd.Parameters.AddWithValue("@ReceiptNumber", attachment.ReceiptNumber); cmd.Parameters.AddWithValue("@filedata", attachment.FileContents); cmd.Parameters.AddWithValue("@fileName", attachment.FileName); cmd.Parameters.AddWithValue("@remarks", attachment.Remarks); cmd.Parameters.AddWithValue("@filedate", attachment.FileDate); st = cmd.ExecuteNonQuery(); } } conn.Close(); } } catch (Exception ex) { } if (st > 0) { return(true); } else { return(false); } }