public static ClaimAttachment GetClaimAttachmentByClaimAttachmentId(int claimAttachmentId)
{
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimAttachmentByClaimAttachmentId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ClaimAttachmentId", DbType.Int32, claimAttachmentId);
db.AddOutParameter(dbCommand, "@Description", DbType.String, 200);
db.AddOutParameter(dbCommand, "@Attachment", DbType.String, 1000);
db.AddOutParameter(dbCommand, "@ClaimId", DbType.Int32, 4);
db.ExecuteNonQuery(dbCommand);
ClaimAttachment claimAttachment = new ClaimAttachment();
claimAttachment.ClaimAttachmentId = claimAttachmentId;
claimAttachment.Description = db.GetParameterValue(dbCommand, "Description").ToString();
claimAttachment.Attachment = db.GetParameterValue(dbCommand, "Attachment").ToString();
claimAttachment.ClaimId = Convert.ToInt32(db.GetParameterValue(dbCommand, "ClaimId"));
return(claimAttachment);
}
public static List <ClaimAttachment> GetClaimAttachmentListByClaimId(int claimId)
{
List <ClaimAttachment> list = new List <ClaimAttachment>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimAttachmentListByClaimId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ClaimId", DbType.Int32, claimId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
ClaimAttachment claimAttachment = new ClaimAttachment();
claimAttachment.ClaimAttachmentId = Convert.ToInt32(dataReader["ClaimAttachmentId"]);
claimAttachment.Description = dataReader["Description"].ToString();
list.Add(claimAttachment);
}
}
return(list);
}
