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