public clsTransferAttachment GetTransferAttachment(int id) { clsTransferAttachment attachment1 = new clsTransferAttachment(); try { using (SqlConnection conn = new SqlConnection(strConn)) { conn.Open(); { using (SqlCommand cmd = new SqlCommand("TMR_USP_GetTransferAttachment")) { 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.ClientID = reader["ClientID"].ToString(); attachment1.FileName = reader["fileName"].ToString(); attachment1.FileContents = (byte[])reader["fileData"]; } } } } conn.Close(); } } catch (Exception ex) { } return(attachment1); }
public List <clsTransferAttachment> GetTransferAttachments(int id) { List <clsTransferAttachment> attachments = new List <clsTransferAttachment>(); try { using (SqlConnection conn = new SqlConnection(strConn)) { conn.Open(); { using (SqlCommand cmd = new SqlCommand("TMR_USP_GetTransferAttachments")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.AddWithValue("@TransferID", id); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { clsTransferAttachment attach = new clsTransferAttachment(); attach.RegistrationNo = reader["RegistrationNo"].ToString(); attach.ClientID = reader["ClientID"].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 AddTransferAttachment(clsTransferAttachment attachment) { int st = 0; try { using (SqlConnection conn = new SqlConnection(strConn)) { conn.Open(); { using (SqlCommand cmd = new SqlCommand("TMR_USP_AddTransferAttachment")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.AddWithValue("@TransferID", attachment.TransferId); cmd.Parameters.AddWithValue("@RegistrationNo", attachment.RegistrationNo); cmd.Parameters.AddWithValue("@ClientID", attachment.ClientID); 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); } }