public static List <ATTMessageAttachment> GetMsgAttachmentByIDs(int?orgID, int?msgID)
{
List <ATTMessageAttachment> lst = new List <ATTMessageAttachment>();
try
{
DataTable tbl = DLLMessageAttachment.GetMsgAttachmentByIDs(orgID, msgID);
foreach (DataRow row in tbl.Rows)
{
ATTMessageAttachment att = new ATTMessageAttachment();
att.OrgID = int.Parse(row["org_id"].ToString());
att.MessageID = int.Parse(row["msg_id"].ToString());
att.AttachmentID = int.Parse(row["MSG_ATTACH_ID"].ToString());
att.FileName = row["FILE_NAME"].ToString();
att.ContentFile = row["FILE_BYTES"] as byte[];
lst.Add(att);
}
tbl.Dispose();
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public List <ATTMessageAttachment> GetOutboxAttachmentList(ATTMessage objRqdMsg)
{
try
{
List <ATTMessageAttachment> tmpAttachmentLst = new List <ATTMessageAttachment>();
ArrayList arrVal = new ArrayList();
foreach (ATTMessageAttachment objAttachment in objRqdMsg.LstMsgAttachment)
{
int l = 0;
bool flag = false;
if (arrVal.Count > 0)
{
for (int k = 0; k < arrVal.Count; k++)
{
if (objAttachment.AttachmentID == int.Parse(arrVal[k].ToString()))
{
flag = true;
break;
}
}
}
if (!flag)
{
ATTMessageAttachment obj = new ATTMessageAttachment();
obj.OrgID = objAttachment.OrgID;
obj.MessageID = objAttachment.MessageID;
obj.AttachmentID = objAttachment.AttachmentID;
obj.FileName = objAttachment.FileName;
arrVal.Add(objAttachment.AttachmentID.ToString());
tmpAttachmentLst.Add(obj);
}
}
return(tmpAttachmentLst);
}
catch (Exception ex)
{
throw(ex);
}
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
try
{
string arguments = ((LinkButton)sender).CommandArgument.ToString();
CalculateIDs(arguments);
ATTMessage objMsg = (ATTMessage)Session["objRqdMsg"];
List <ATTMessageAttachment> lstMsgAttachment = new List <ATTMessageAttachment>();
lstMsgAttachment = objMsg.LstMsgAttachment;
ATTMessageAttachment objRqdMsgAttachment = lstMsgAttachment.Find(delegate(ATTMessageAttachment obj)
{
return(obj.OrgID == orgID && obj.MessageID == msgID && obj.AttachmentID == attachID);
}
);
if (objRqdMsgAttachment != null)
{
byte[] fileByte = objRqdMsgAttachment.ContentFile;
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=" + objRqdMsgAttachment.FileName);
Response.ContentType = "application/octet-stream";
Response.BinaryWrite(fileByte);
}
}
catch (Exception ex)
{
throw(ex);
}
}
public static List <ATTMessageAttachment> SetMessageAttachment(int orgID, int messageID, int?msgSeq, string type)
{
try
{
List <ATTMessageAttachment> lstMsgAttachment = new List <ATTMessageAttachment>();
foreach (DataRow row in tblMsgAttachment.Rows)
{
bool flag = false;
if (type == "IN")
{
if (orgID == int.Parse(row["ORG_ID"].ToString()) &&
messageID == int.Parse(row["MSG_ID"].ToString()) &&
msgSeq == int.Parse(row["MSG_SEQ"].ToString())
)
{
flag = true;
}
}
else
{
if (orgID == int.Parse(row["ORG_ID"].ToString()) &&
messageID == int.Parse(row["MSG_ID"].ToString())
)
{
flag = true;
}
}
//if (orgID == int.Parse(row["ORG_ID"].ToString()) &&
// messageID == int.Parse(row["MSG_ID"].ToString())
// )
if (flag)
{
ATTMessageAttachment objMsgAttachment = new ATTMessageAttachment(
int.Parse(row["ORG_ID"].ToString()),
int.Parse(row["MSG_ID"].ToString()),
int.Parse(row["MSG_ATTACH_ID"].ToString()),
row["FILE_NAME"].ToString().Trim(),
(byte[])(row["FILE_BYTES"])
);
if (row["FILE_NAME"].ToString().Trim().Length > 15)
{
objMsgAttachment.DisplayName = row["FILE_NAME"].ToString().Trim().Substring(0, 15) + ".....";
}
else
{
objMsgAttachment.DisplayName = row["FILE_NAME"].ToString().Trim();
}
lstMsgAttachment.Add(objMsgAttachment);
}
}
return(lstMsgAttachment);
}
catch (Exception ex)
{
throw(ex);
}
}