protected void lnkDownload_Click(object sender, EventArgs e)
{
try
{
LinkButton lnkbtn = (LinkButton)sender;
string[] values = lnkbtn.CommandArgument.Split('@');
objProjectCls = new ProjectClass();
objProjectCls.AttachmentHandle = "T_ERECTIONACTIVITY";
DataTable dt = objProjectCls.GetPath();
string ServerPath = "D:\\" + dt.Rows[0]["t_path"].ToString() + "\\";
// string ServerPath = "D:\\" + dt.Rows[0]["t_serv"].ToString() + "\\" + dt.Rows[0]["t_path"].ToString() + "\\" + values[0];// dt.Rows[0]["Path"].ToString() + "\\" + values[0];// Server.MapPath("~/Files/") + values[0]; //
//string ServerPath = "E:\\attachmentlibrary1\\" + values[0];
//"D:\\" + dt.Rows[0]["t_path"].ToString() + "\\" + values[0];
WebClient req = new WebClient();
HttpResponse response = HttpContext.Current.Response;
response.Clear();
response.ClearContent();
response.ClearHeaders();
response.Buffer = true;
response.AddHeader("Content-Disposition", "attachment;filename=\"" + values[1] + "\"");
byte[] data = req.DownloadData(ServerPath);
response.BinaryWrite(data);
response.End();
}
catch (System.Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Could not find');", true);
}
}
protected void UploadAttachment(string NotesId)
{
try
{
string sUsername = (string)(Session["Username"]);
// sUsername = "******";// for testing only
//if (Request.QueryString["user"] != null)
if (sUsername != null)
{
objProjectCls = new ProjectClass();
// objProjectCls.IndexValue = Request.QueryString["Index"];
objProjectCls.AttachmentHandle = "T_ERECTIONACTIVITY";
DataTable dt = objProjectCls.GetPath();
if (dt.Rows.Count > 0)
{
//string ServerPath = dt.Rows[0]["t_serv"].ToString() + "\\"+ "D:\\" + dt.Rows[0]["t_path"].ToString() + "\\"; //dt.Rows[0]["Path"].ToString() + "\\";// // Server.MapPath("~/Files/");//
string ServerPath = "D:\\" + dt.Rows[0]["t_path"].ToString() + "\\"; //dt.Rows[0]["Path"].ToString() + "\\";// // Server.MapPath("~/Files/");//
//attachmentlibrary1
// string ServerPath = "E:\\attachmentlibrary1\\";
string LocalPath = Server.MapPath("~/Files/");
if (FileUpload.HasFile)
{
int filecount = 0;
filecount = FileUpload.PostedFiles.Count;
if (filecount > 0)
{
foreach (HttpPostedFile PostedFile in FileUpload.PostedFiles)
{
string fileName = Path.GetFileNameWithoutExtension(PostedFile.FileName);
string fileExtension = Path.GetExtension(PostedFile.FileName);
try
{
objProjectCls = new ProjectClass();
objProjectCls.AttachmentHandle = "T_ERECTIONACTIVITY";
objProjectCls.IndexValue = NotesId;
objProjectCls.PurposeCode = "Attachment for Mobile App Notes";// Request.QueryString["PurposeCode"];
//objProjectCls.AttachedBy = Request.QueryString["user"];
objProjectCls.AttachedBy = sUsername;
objProjectCls.FileName = fileName + fileExtension;
objProjectCls.LibraryCode = dt.Rows[0]["LibCode"].ToString();
//"LIB000001";
// DataTable dtFile = objProjectCls.GetFileName();
// if (dtFile.Rows.Count == 0)
// {
DataTable dtDocID = objProjectCls.InsertAttachment();
if (dtDocID.Rows[0][0].ToString() != "0")
{
try
{
string AttachServerPath = ServerPath + dtDocID.Rows[0][0];
FileUpload.SaveAs(AttachServerPath);
}
catch (Exception ex)
{
// err.Text = ex.Message;
}
// FileUpload.SaveAs(LocalPath + fileName + fileExtension);
HttpContext.Current.Cache.Remove("ATHData");
//AttachmentBindData(NotesId);
BindData();
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Successfully Uploaded');", true);
}
else
{
//objProjectCls = new AttachmentCls();
//objProjectCls.DocumentId = dtDocID.Rows[0][0].ToString();
//int res = objProjectCls.DeleteAttachment();
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Attachment Handle does not exist');", true);
}
// }
// else
// {
// ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('This file name already exist please change your file name');", true);
// }
}
catch (System.Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('" + ex.Message + "');", true);
}
}
}
else
{
}
}
}
else
{
}
// }
//else
//{
// ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Attachment Handle does not exist');", true);
//}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data not found Properly');", true);
}
}
catch (Exception ex)
{
}
}