protected void btnUploadAttachments_Click(object sender, EventArgs e) { lblMsg.Text = ""; try { int Case_ID = UDFLib.ConvertToInteger(hdnCaseID.Value); int Vessel_ID = UDFLib.ConvertToInteger(hdnVesselId.Value); int Office_ID = UDFLib.ConvertToInteger(hdnOfficeId.Value); DataTable dt = new DataTable(); dt = objUploadFilesize.Get_Module_FileUpload("CWF_"); if (dt.Rows.Count > 0) { string datasize = dt.Rows[0]["Size_KB"].ToString(); if (UploadAttachments.HasFile) { if (UploadAttachments.PostedFile.ContentLength < Int32.Parse(dt.Rows[0]["Size_KB"].ToString()) * 1024) { //if (UploadAttachments.FileName.Length > 0) //{ Guid GUID = Guid.NewGuid(); long SIZE_BYTES = UploadAttachments.PostedFile.ContentLength; if (SIZE_BYTES > 0 && Case_ID > 0) { string File_Path = GUID + System.IO.Path.GetExtension(UploadAttachments.FileName); UploadAttachments.PostedFile.SaveAs(Server.MapPath("~/Uploads/MedHistory/" + File_Path)); int FileID = BLL_Crew_MedHistory.INSERT_Crew_MedHistory_Attachment(Case_ID, Vessel_ID, Office_ID, UploadAttachments.FileName.Replace("&", "_"), File_Path, SIZE_BYTES, GetSessionUserID()); } DataTable dtAtt = BLL_Crew_MedHistory.Get_Crew_MedHistory_Attachments(Case_ID, Vessel_ID, Office_ID, GetSessionUserID()); rptAttachments.DataSource = dtAtt; rptAttachments.DataBind(); } else { lblMsg.Text = datasize + " KB File size exceeds maximum limit"; } } } else { string js2 = "alert('Upload size not set!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert9", js2, true); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
protected void rptAttachments_ItemCommand(object sender, RepeaterCommandEventArgs e) { if (e.CommandName == "Delete") { int ID = UDFLib.ConvertToInteger(e.CommandArgument); int Case_ID = UDFLib.ConvertToInteger(hdnCaseID.Value); int Vessel_ID = UDFLib.ConvertToInteger(hdnVesselId.Value); int Office_ID = UDFLib.ConvertToInteger(hdnOfficeId.Value); BLL_Crew_MedHistory.DELETE_Crew_MedHistory_Attachment(ID, Case_ID, Vessel_ID, Office_ID, GetSessionUserID()); DataTable dtAtt = BLL_Crew_MedHistory.Get_Crew_MedHistory_Attachments(Case_ID, Vessel_ID, Office_ID, GetSessionUserID()); rptAttachments.DataSource = dtAtt; rptAttachments.DataBind(); } }
public string Get_MedHistory_Attachments(int Case_ID, int Vessel_ID, int Office_ID, int UserID) { DataTable dt = BLL_Crew_MedHistory.Get_Crew_MedHistory_Attachments(Case_ID, Vessel_ID, Office_ID, UserID); UDCHyperLink aLink = new UDCHyperLink("DocURL", "", new string[] { }, new string[] { }, "_blank"); Dictionary <string, UDCHyperLink> dicLink = new Dictionary <string, UDCHyperLink>(); dicLink.Add("Attachment_Name", aLink); return(UDFLib.CreateHtmlTableFromDataTable(dt, new string[] { "Attachments" }, new string[] { "Attachment_Name" }, dicLink, new Dictionary <string, UDCToolTip>(), new string[] { "left" }, "CrewQuery-Attachments-table", "CrewQuery-Attachments-DataHeder", "CrewQuery-Attachments-Data")); }