public void ProcessRequest(HttpContext context) { if (context.Request.Form["aid"] != null) { string aid = context.Request.Form["aid"].ToString().Trim(); string afileID = context.Request.Form["afileID"].ToString().Trim(); if (encode.sqlInjection(aid) || encode.sqlInjection(afileID)) { throw new Exception("illegal paramater value"); } Veryfly_DB myVery = new Veryfly_DB(); DataTable dt = myVery.checkimagetext(aid, afileID); List <TooL> eList = new List <TooL>(); TooL e = new TooL(); if (dt.Rows[0]["sender_imagetext"].ToString().Trim() == context.Request.Form["vaild"].ToString().Trim()) { DataView dv = dt.DefaultView; dv.RowFilter = "main_stat<>'N'"; if (dv.Count == 0) { e.err_msg = "This data has been deleted,download fail."; e.afile_encryptfileName = ""; e.afile_origiFileName = ""; e.afile_id = ""; e.sender_id = ""; e.afile_exten = ""; e.sender_notifyflag = ""; } else { e.err_msg = ""; e.afile_encryptfileName = dv[0]["afile_encryptfileName"].ToString().Trim(); e.afile_origiFileName = dv[0]["afile_origiFileName"].ToString().Trim(); e.afile_id = dv[0]["afile_id"].ToString().Trim(); e.sender_id = dv[0]["sender_id"].ToString().Trim(); e.afile_exten = dv[0]["afile_exten"].ToString().Trim(); e.sender_notifyflag = dv[0]["sender_notifyflag"].ToString().Trim(); } } else { e.err_msg = "Verification fails, make sure you type the Verification code is correct."; e.afile_encryptfileName = ""; e.afile_origiFileName = ""; e.afile_id = ""; e.sender_id = ""; e.afile_exten = ""; e.sender_notifyflag = ""; } eList.Add(e); System.Web.Script.Serialization.JavaScriptSerializer objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer(); string ans = objSerializer.Serialize(eList); //new context.Response.ContentType = "application/json"; context.Response.Write(ans); } }
public void ProcessRequest(HttpContext context) { if (context.Request.Form["aid"] != null) { string aid = context.Request.Form["aid"].ToString().Trim(); string afileID = context.Request.Form["afileID"].ToString().Trim(); if (encode.sqlInjection(aid) || encode.sqlInjection(afileID)) { throw new Exception("illegal paramater value"); } Veryfly_DB myVery = new Veryfly_DB(); DataTable dt = myVery.checkimagetext(aid, afileID); if (dt.Rows[0]["sender_imagetext"].ToString().Trim() == context.Request.Form["vaild"].ToString().Trim()) { DataView dv = dt.DefaultView; dv.RowFilter = "main_stat<>'N'"; if (dv.Count == 0) { context.Response.Write("This data has been deleted,download fail."); } else { context.Response.Write("Authentication is successful! Unzip password will be sent to your mailbox when the download is complete."); } } else { context.Response.Write("Verification fails, make sure you type the Verification code is correct."); } } }
public void ProcessRequest(HttpContext context) { if (context.Request.Form["aid"] != null) { string aid = context.Request.Form["aid"].ToString().Trim(); string afileID = context.Request.Form["afileID"].ToString().Trim(); if (encode.sqlInjection(aid) || encode.sqlInjection(afileID)) { throw new Exception("參數包含不合法字元"); } Veryfly_DB myVery = new Veryfly_DB(); DataTable dt = myVery.checkimagetext(aid, afileID); if (dt.Rows[0]["sender_imagetext"].ToString().Trim() == context.Request.Form["vaild"].ToString().Trim()) { DataView dv = dt.DefaultView; dv.RowFilter = "main_stat<>'N'"; if (dv.Count == 0) { context.Response.Write("此筆資料寄件者已刪除,檔案下載失敗"); } else { context.Response.Write("驗證成功!確認下載完成之後,解壓縮密碼會寄到您的信箱內"); } } else { context.Response.Write("驗證失敗,請確認輸入之驗證碼是否正確"); } } }
public void ProcessRequest(HttpContext context) { if (context.Request.Form["aid"] != null) { string aid = context.Request.Form["aid"].ToString().Trim(); string afileID = context.Request.Form["afileID"].ToString().Trim(); if (encode.sqlInjection(aid) || encode.sqlInjection(afileID)) { throw new Exception("參數包含不合法字元"); } Veryfly_DB myVery = new Veryfly_DB(); DataTable dt = myVery.checkimagetext(aid, afileID); List <TooL> eList = new List <TooL>(); TooL e = new TooL(); if (dt.Rows[0]["sender_imagetext"].ToString().Trim() == context.Request.Form["vaild"].ToString().Trim()) { DataView dv = dt.DefaultView; dv.RowFilter = "main_stat<>'N'"; if (dv.Count == 0) { e.err_msg = "此筆資料寄件者已刪除,檔案下載失敗"; e.afile_encryptfileName = ""; e.afile_origiFileName = ""; e.afile_id = ""; e.sender_id = ""; e.afile_exten = ""; e.sender_notifyflag = ""; } else { e.err_msg = ""; e.afile_encryptfileName = dv[0]["afile_encryptfileName"].ToString().Trim(); e.afile_origiFileName = dv[0]["afile_origiFileName"].ToString().Trim(); e.afile_id = dv[0]["afile_id"].ToString().Trim(); e.sender_id = dv[0]["sender_id"].ToString().Trim(); e.afile_exten = dv[0]["afile_exten"].ToString().Trim(); e.sender_notifyflag = dv[0]["sender_notifyflag"].ToString().Trim(); } } else { e.err_msg = "驗證失敗,請確認輸入之驗證碼是否正確"; e.afile_encryptfileName = ""; e.afile_origiFileName = ""; e.afile_id = ""; e.sender_id = ""; e.afile_exten = ""; e.sender_notifyflag = ""; } eList.Add(e); System.Web.Script.Serialization.JavaScriptSerializer objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer(); string ans = objSerializer.Serialize(eList); //new context.Response.ContentType = "application/json"; context.Response.Write(ans); } }
public void ProcessRequest(HttpContext context) { try { if (context.Request["aid"] != null) { string aid = context.Request.Form["aid"].ToString().Trim(); string afileID = context.Request.Form["afileID"].ToString().Trim(); if (encode.sqlInjection(aid) || encode.sqlInjection(afileID)) { throw new Exception("參數包含不合法字元"); } Veryfly_DB myVery = new Veryfly_DB(); DataTable dt = myVery.checkimagetext(aid, afileID); if (dt.Rows[0]["sender_stat"].ToString().Trim() == "N") { Email email = new Email(); //email.sendEmail(dt.Rows[0]["sender_mail"].ToString(), "[ITRI] 通知:您有來自工研院大檔案傳輸的信件", "親愛的朋友 您好:<br /><br />先生/小姐,在 2013/04/18寄送下列的檔案給您。<br />請您利用下面的解壓縮密碼來開啟檔案:<br /><img alt='認證碼' src='cid:attech01.jpg' /><br />請使用此密碼解壓縮檔案<br /> 謝謝", dt.Rows[0]["afile_encrypt"].ToString()); DataTable dtAccordingParentidToFindMember = Common.AccordingParentidToFindMember(dt.Rows[0]["sender_parentid"].ToString()); DataTable dtGetDetail = Common.GetDetail(dtAccordingParentidToFindMember.Rows[0]["main_infno"].ToString(), dtAccordingParentidToFindMember.Rows[0]["main_isempno"].ToString()); email.sendEmail(dt.Rows[0]["sender_mail"].ToString(), "[ITRI] 通知:您有來自工研院大檔案傳輸的信件", "親愛的朋友 您好:<br /><br />" + dtGetDetail.Rows[0]["cName"].ToString() + " <" + dtGetDetail.Rows[0]["cEmail"].ToString() + "> 先生/小姐,在" + dtAccordingParentidToFindMember.Rows[0]["Cmain_createdate"].ToString() + "寄送下列的檔案給您。<br />請您利用下面的[解壓縮密碼]來開啟檔案:(請不要複製[]符號)<br /><b>[</b><span style='color:Red'>" + dt.Rows[0]["afile_encrypt"].ToString() + "</span><b>]</b><br />請使用此密碼解壓縮檔案<br /> 謝謝", dt.Rows[0]["afile_encrypt"].ToString(), ""); context.Response.Write("OK"); } else { context.Response.Write("NO_downLoad"); } } } catch (Exception ex) { context.Response.Write(ex.Message); } }
public void ProcessRequest(HttpContext context) { try { if (context.Request["aid"] != null) { string aid = context.Request.Form["aid"].ToString().Trim(); string afileID = context.Request.Form["afileID"].ToString().Trim(); if (encode.sqlInjection(aid) || encode.sqlInjection(afileID)) { throw new Exception("paramater contains illegal characters"); } Veryfly_DB myVery = new Veryfly_DB(); DataTable dt = myVery.checkimagetext(aid, afileID); if (dt.Rows[0]["sender_stat"].ToString().Trim() == "N") { Email email = new Email(); //email.sendEmail(dt.Rows[0]["sender_mail"].ToString(), "[ITRI] 通知:您有來自工研院大檔案傳輸的信件", "親愛的朋友 您好:<br /><br />先生/小姐,在 2013/04/18寄送下列的檔案給您。<br />請您利用下面的解壓縮密碼來開啟檔案:<br /><img alt='認證碼' src='cid:attech01.jpg' /><br />請使用此密碼解壓縮檔案<br /> 謝謝", dt.Rows[0]["afile_encrypt"].ToString()); DataTable dtAccordingParentidToFindMember = Common.AccordingParentidToFindMember(dt.Rows[0]["sender_parentid"].ToString()); DataTable dtGetDetail = Common.GetDetail(dtAccordingParentidToFindMember.Rows[0]["main_infno"].ToString(), dtAccordingParentidToFindMember.Rows[0]["main_isempno"].ToString()); email.sendEmail(dt.Rows[0]["sender_mail"].ToString(), "[ITRI] Notification from ITRI WebFTP - unZip Mail ", "Dear: <br /><br />" + dtGetDetail.Rows[0]["cName"].ToString() + " <" + dtGetDetail.Rows[0]["cEmail"].ToString() + "> had send some files to you at " + dtAccordingParentidToFindMember.Rows[0]["Cmain_createdate"].ToString() + ".<br />Please use the following [Unzip Password] to open the file: (Please do not copy [] symbols)<br /><b>[</b><span style='color:Red'>" + dt.Rows[0]["afile_encrypt"].ToString() + "</span><b>]</b><br /><br /> Thank you.", dt.Rows[0]["afile_encrypt"].ToString(), ""); context.Response.Write("OK"); } else { context.Response.Write("NO_downLoad"); } } } catch (Exception ex) { context.Response.Write(ex.Message); } }
public void ProcessRequest(HttpContext context) { if (context.Request["aid"] != null) { string aid = context.Request.QueryString["aid"].ToString().Trim(); string afileID = context.Request.QueryString["afileID"].ToString().Trim(); if (encode.sqlInjection(aid) || encode.sqlInjection(afileID)) { throw new Exception("參數包含不合法字元"); } else { Veryfly_DB myVery = new Veryfly_DB(); DataTable dt = myVery.checkimagetext(aid, afileID); if (dt.Rows.Count == 0) { throw new Exception("找不到此收件人"); } else { string vailde = dt.Rows[0]["sender_imagetext"].ToString().Trim(); if (vailde == context.Request["vailde"].ToString().Trim()) { string strpath; //底下的IF為 該筆是一般 而且是單筆的不是整包的壓縮檔(!="N") if (dt.Rows[0]["afile_comorsec"].ToString().Trim() == "common" && dt.Rows[0]["afile_encrypt"].ToString().Trim() != "N") { strpath = string.Format("{0}{1}", AppConfig.source_path, context.Request["filename"] + context.Request["exten"]); } else if (dt.Rows[0]["afile_comorsec"].ToString().Trim() == "nonforward" && dt.Rows[0]["afile_encrypt"].ToString().Trim() != "N") { strpath = string.Format("{0}{1}", AppConfig.source_path, context.Request["filename"] + context.Request["exten"]); } else { strpath = string.Format("{0}{1}", AppConfig.Source_zip_path, context.Request["filename"] + context.Request["exten"]); } FileInfo file = new FileInfo(strpath); string strContentType = string.Empty; switch (file.Extension) { case ".asf": strContentType = "video/x-ms-asf"; break; case ".avi": strContentType = "video/avi"; break; case ".ppt": strContentType = "application/vnd.ms-powerpoint"; break; case ".pptx": strContentType = "application/vnd.ms-powerpoint"; break; case ".doc": strContentType = "application/msword"; break; case ".docx": strContentType = "application/msword"; break; case ".zip": strContentType = "application/zip"; break; case ".xls": strContentType = "application/vnd.ms-excel"; break; case ".xlsx": strContentType = "application/vnd.ms-excel"; break; case ".csv": strContentType = "application/vnd.ms-excel"; break; case ".gif": strContentType = "image/gif"; break; case ".jpg": strContentType = "image/jpeg"; break; case "jpeg": strContentType = "image/jpeg"; break; case ".wav": strContentType = "audio/wav"; break; case ".mp3": strContentType = "audio/mpeg3"; break; case ".mpg": strContentType = "video/mpeg"; break; case "mpeg": strContentType = "video/mpeg"; break; case ".htm": strContentType = "text/html"; break; case ".html": strContentType = "text/html"; break; case ".asp": strContentType = "text/asp"; break; default: strContentType = "application/octet-stream"; break; } if (file.Exists) { FileStream oF = new FileStream(strpath, FileMode.Open, FileAccess.Read); context.Response.ClearHeaders(); context.Response.Clear(); context.Response.BufferOutput = false; context.Response.CacheControl = "Private"; context.Response.ContentType = strContentType; context.Response.AppendHeader("Content-Length", oF.Length.ToString()); /*指定文件大小,可讓瀏覽器能夠顯示下載進度,並可優化、加快下載速度*/ string strDownloadName = string.Empty; if (context.Request.Browser.Browser == "IE") { context.Response.HeaderEncoding = System.Text.Encoding.GetEncoding("utf-8"); strDownloadName = context.Server.UrlPathEncode(context.Request["source"].ToString()); } else { strDownloadName = context.Request["source"].ToString(); } context.Response.AddHeader("content-disposition", "attachment;filename=\"" + strDownloadName + context.Request["exten"].ToString() + "\""); //context.Response.WriteFile(strpath); //context.Response.Flush(); //context.Response.End(); if (PassStream(context.Response.OutputStream, oF, context)) { if (dt.Rows[0]["sender_stat"].ToString().Trim() == "Y" && dt.Rows[0]["afile_comorsec"].ToString().Trim() == "security")//寄解壓縮密碼 只有在第一次下載才需要 { Email email = new Email(); //email.sendEmail(dt.Rows[0]["sender_mail"].ToString(), "[ITRI] 通知:您有來自工研院大檔案傳輸的信件", "親愛的朋友 您好:<br /><br />先生/小姐,在 2013/04/18寄送下列的檔案給您。<br />請您利用下面的解壓縮密碼來開啟檔案:<br /><img alt='認證碼' src='cid:attech01.jpg' /><br />請使用此密碼解壓縮檔案<br /> 謝謝", dt.Rows[0]["afile_encrypt"].ToString()); DataTable dtAccordingParentidToFindMember = Common.AccordingParentidToFindMember(dt.Rows[0]["sender_parentid"].ToString()); DataTable dtGetDetail = Common.GetDetail(dtAccordingParentidToFindMember.Rows[0]["main_infno"].ToString(), dtAccordingParentidToFindMember.Rows[0]["main_isempno"].ToString()); email.sendEmail(dt.Rows[0]["sender_mail"].ToString(), "[ITRI] 通知:您有來自工研院大檔案傳輸的信件", "親愛的朋友 您好:<br /><br />" + dtGetDetail.Rows[0]["cName"].ToString() + " <" + dtGetDetail.Rows[0]["cEmail"].ToString() + "> 先生/小姐,在" + dtAccordingParentidToFindMember.Rows[0]["Cmain_createdate"].ToString() + "寄送下列的檔案給您。<br />請您利用下面的[解壓縮密碼]來開啟檔案:(請不要複製[]符號)<br /><b>[</b><span style='color:Red'>" + dt.Rows[0]["afile_encrypt"].ToString() + "</span><b>]</b><br />請使用此密碼解壓縮檔案<br /> 謝謝", dt.Rows[0]["afile_encrypt"].ToString(), ""); //把狀態更新 就不會再寄信了 myVery.UpdateSender_Stat(dt.Rows[0]["sender_id"].ToString()); } //下載次數跟時間LOG myVery.InsertDownloadLog(afileID, dt.Rows[0]["sender_parentid"].ToString(), aid, DateTime.Now); } //判斷[收件者下載檔案或刪除取檔網址時通知我] if (context.Request.QueryString["notifyflag"] != null && context.Request.QueryString["notifyflag"].ToString().Trim() == "Y") { //如果有勾選要寄信給寄件人 Email email = new Email(); StringBuilder sb = new StringBuilder(); sb.Append(@"您好: <br /> 謹通知您:<br /> 您在 "); sb.Append(@"" + Convert.ToDateTime(dt.Rows[0]["afile_createdate"].ToString()).ToString("yyy/MM/dd") + " 傳送的檔案<br /><br />"); sb.Append(@"" + dt.Rows[0]["ShowFileName"].ToString() + dt.Rows[0]["afile_exten"].ToString() + "<br /><br />目前由"); sb.Append(@" < " + dt.Rows[0]["sender_mail"].ToString() + " > "); sb.Append(@"信箱收件者下載中。<br />"); //sb.Append(@""); DataTable dtAccordingParentidToFindMember = Common.AccordingParentidToFindMember(dt.Rows[0]["sender_parentid"].ToString()); DataTable dtGetDetail = Common.GetDetail(dtAccordingParentidToFindMember.Rows[0]["main_infno"].ToString(), dtAccordingParentidToFindMember.Rows[0]["main_isempno"].ToString()); email.sendEmail(dtGetDetail.Rows[0]["cEmail"].ToString(), "[ITRI] 通知:您透過大檔案傳輸寄出的檔案正在被下載", sb.ToString(), ""); } } } } } } else { throw new Exception("檔案不存在"); } }
public void ProcessRequest(HttpContext context) { if (context.Request["aid"] != null) { string aid = context.Request.QueryString["aid"].ToString().Trim(); string afileID = context.Request.QueryString["afileID"].ToString().Trim(); if (encode.sqlInjection(aid) || encode.sqlInjection(afileID)) { throw new Exception("illegal paramater value"); } else { Veryfly_DB myVery = new Veryfly_DB(); DataTable dt = myVery.checkimagetext(aid, afileID); if (dt.Rows.Count == 0) { throw new Exception("Can't find the sender."); } else { string vailde = dt.Rows[0]["sender_imagetext"].ToString().Trim(); if (vailde == context.Request["vailde"].ToString().Trim()) { string strpath; //底下的IF為 該筆是一般 而且是單筆的不是整包的壓縮檔(!="N") if (dt.Rows[0]["afile_comorsec"].ToString().Trim() == "common" && dt.Rows[0]["afile_encrypt"].ToString().Trim() != "N") { strpath = string.Format("{0}{1}", AppConfig.source_path, context.Request["filename"] + context.Request["exten"]); } else if (dt.Rows[0]["afile_comorsec"].ToString().Trim() == "nonforward" && dt.Rows[0]["afile_encrypt"].ToString().Trim() != "N") { strpath = string.Format("{0}{1}", AppConfig.source_path, context.Request["filename"] + context.Request["exten"]); } else { strpath = string.Format("{0}{1}", AppConfig.Source_zip_path, context.Request["filename"] + context.Request["exten"]); } FileInfo file = new FileInfo(strpath); string strContentType = string.Empty; switch (file.Extension) { case ".asf": strContentType = "video/x-ms-asf"; break; case ".avi": strContentType = "video/avi"; break; case ".doc": strContentType = "application/msword"; break; case ".zip": strContentType = "application/zip"; break; case ".xls": strContentType = "application/vnd.ms-excel"; break; case ".csv": strContentType = "application/vnd.ms-excel"; break; case ".gif": strContentType = "image/gif"; break; case ".jpg": strContentType = "image/jpeg"; break; case "jpeg": strContentType = "image/jpeg"; break; case ".wav": strContentType = "audio/wav"; break; case ".mp3": strContentType = "audio/mpeg3"; break; case ".mpg": strContentType = "video/mpeg"; break; case "mpeg": strContentType = "video/mpeg"; break; case ".htm": strContentType = "text/html"; break; case ".html": strContentType = "text/html"; break; case ".asp": strContentType = "text/asp"; break; default: strContentType = "application/octet-stream"; break; } if (file.Exists) { FileStream oF = new FileStream(strpath, FileMode.Open, FileAccess.Read); context.Response.ClearHeaders(); context.Response.Clear(); context.Response.BufferOutput = false; context.Response.CacheControl = "Private"; context.Response.ContentType = strContentType; context.Response.AppendHeader("Content-Length", oF.Length.ToString()); /*指定文件大小,可讓瀏覽器能夠顯示下載進度,並可優化、加快下載速度*/ string strDownloadName = string.Empty; if (context.Request.Browser.Browser == "IE") { context.Response.HeaderEncoding = System.Text.Encoding.GetEncoding("big5"); strDownloadName = context.Request["source"]; } else { strDownloadName = System.Web.HttpUtility.UrlEncode(context.Request["source"]); } context.Response.AddHeader("content-disposition", "attachment;filename=" + strDownloadName + context.Request["exten"]); //context.Response.WriteFile(strpath); //context.Response.Flush(); //context.Response.End(); if (PassStream(context.Response.OutputStream, oF, context)) { if (dt.Rows[0]["sender_stat"].ToString().Trim() == "Y" && dt.Rows[0]["afile_comorsec"].ToString().Trim() == "security")//寄解壓縮密碼 只有在第一次下載才需要 { Email email = new Email(); //email.sendEmail(dt.Rows[0]["sender_mail"].ToString(), "[ITRI] 通知:您有來自工研院大檔案傳輸的信件", "親愛的朋友 您好:<br /><br />先生/小姐,在 2013/04/18寄送下列的檔案給您。<br />請您利用下面的解壓縮密碼來開啟檔案:<br /><img alt='認證碼' src='cid:attech01.jpg' /><br />請使用此密碼解壓縮檔案<br /> 謝謝", dt.Rows[0]["afile_encrypt"].ToString()); DataTable dtAccordingParentidToFindMember = Common.AccordingParentidToFindMember(dt.Rows[0]["sender_parentid"].ToString()); DataTable dtGetDetail = Common.GetDetail(dtAccordingParentidToFindMember.Rows[0]["main_infno"].ToString(), dtAccordingParentidToFindMember.Rows[0]["main_isempno"].ToString()); email.sendEmail(dt.Rows[0]["sender_mail"].ToString(), "[ITRI] Notification from ITRI WebFTP - unZip Mail", "Dear: <br /><br />" + dtGetDetail.Rows[0]["cName"].ToString() + " <" + dtGetDetail.Rows[0]["cEmail"].ToString() + "> had send some files to you at " + dtAccordingParentidToFindMember.Rows[0]["Cmain_createdate"].ToString() + "<br />Please use the following [Unzip Password] to open the file: (Please do not copy [] symbols)<br /><b>[</b><span style='color:Red'>" + dt.Rows[0]["afile_encrypt"].ToString() + "</span><b>]</b><br /><br />Thank you.", dt.Rows[0]["afile_encrypt"].ToString(), ""); //把狀態更新 就不會再寄信了 myVery.UpdateSender_Stat(dt.Rows[0]["sender_id"].ToString()); } //下載次數跟時間LOG myVery.InsertDownloadLog(afileID, dt.Rows[0]["sender_parentid"].ToString(), aid, DateTime.Now); } //判斷[收件者下載檔案或刪除取檔網址時通知我] if (context.Request.QueryString["notifyflag"] != null && context.Request.QueryString["notifyflag"].ToString().Trim() == "Y") { //如果有勾選要寄信給寄件人 Email email = new Email(); StringBuilder sb = new StringBuilder(); sb.Append(@"Dear: <br /> *Notices*<br />"); sb.Append(@"The file " + dt.Rows[0]["ShowFileName"].ToString() + dt.Rows[0]["afile_exten"].ToString() + " you sent at " + Convert.ToDateTime(dt.Rows[0]["afile_createdate"].ToString()).ToString("yyy/MM/dd") + ""); sb.Append(@"is downloading by receiver "); sb.Append(@" < " + dt.Rows[0]["sender_mail"].ToString() + " > "); sb.Append(@"now.<br />"); //sb.Append(@""); DataTable dtAccordingParentidToFindMember = Common.AccordingParentidToFindMember(dt.Rows[0]["sender_parentid"].ToString()); DataTable dtGetDetail = Common.GetDetail(dtAccordingParentidToFindMember.Rows[0]["main_infno"].ToString(), dtAccordingParentidToFindMember.Rows[0]["main_isempno"].ToString()); email.sendEmail(dtGetDetail.Rows[0]["cEmail"].ToString(), "[ITRI] Notification from ITRI WebFTP - your file has been downloaded", sb.ToString(), ""); } } } } } } else { throw new Exception("File does not exist"); } }