private void GenerateCheckListDoc() { lblLinkChkList1.Text = ""; string registerFileNo = dbFileNoData.getFileNo("CRS"); //string ChkFileName = Server.MapPath(@"~/Documents/" + cmbVillage.SelectedValue.ToString() + "/" + "Rajendra.doc"); string ChkFileName = "CRS_" + cmbVillage.SelectedValue.ToString() + "_" + cmbDocumentNo.SelectedValue.ToString() + "_" + registerFileNo + ".doc"; Response.Clear(); //Response.AddHeader("content-disposition", "attachment;filename=FileName.doc"); Response.AddHeader("content-disposition", "attachment;filename=" + ChkFileName + ""); Response.Charset = ""; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/doc"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); So1CheckList.RenderControl(htmlWrite); string path = Server.MapPath(@"~/Documents/" + cmbVillage.SelectedValue.ToString() + "/" + ChkFileName); StreamWriter sWriter = new StreamWriter(path); //FileUpload FileChk = new FileUpload(); //FileChk. = ChkFileName.ToString(); sWriter.Write(stringWrite.ToString()); sWriter.Close(); //update MR File Number dbFileNoData.registername = "CRS"; dbFileNoData.currentno = Convert.ToInt32(registerFileNo) + 1; dbFileNoData.UpdateFileNo(); lblLinkChkList1.Text = ChkFileName; //Insert in to Document Status string DocumentID = dbDocumentStatusData.getDocumentSeqNo(); dbDocumentStatusData.documentid = Convert.ToInt32(DocumentID); dbDocumentStatusData.villagecode = cmbVillage.SelectedValue.ToString(); dbDocumentStatusData.documentcode = "CRS"; dbDocumentStatusData.documentname = ChkFileName; dbDocumentStatusData.documentpath = path; dbDocumentStatusData.createdby = Session["UserName"].ToString(); dbDocumentStatusData.createddate = DateTime.Today; dbDocumentStatusData.docno = cmbDocumentNo.SelectedValue.ToString(); //Check For Record Exist dsDocumenteExists = dbDocumentStatusData.DocumentExistInDocStatus(cmbVillage.SelectedValue.ToString(), cmbDocumentNo.SelectedValue.ToString(), "CRS", "SO2"); if (dsDocumenteExists.Tables[0].Rows.Count == 0) { //string ModifiedSurveyNo = dbDocumentStatusData.surveyno; //dbDocumentStatusData.surveyno = ModifiedSurveyNo.Replace("'", ""); dbDocumentStatusData.surveyno = ""; dbDocumentStatusData.familyno = ""; dbDocumentStatusData.titlesearchno = ""; dbDocumentStatusData.officename = "SO2"; bool DocInsert = dbDocumentStatusData.AddDocumentStatus(); } else { bool DocumentFileUpdate = dbDocumentStatusData.UpdateDocumentStatusFile(); if (DocumentFileUpdate) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Check List Remark Not Uploaded');", true); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Check List Remark updated');", true); } } Response.Write(stringWrite.ToString()); Response.End(); }
private void GenerateFileName(string DocType, FileUpload FControlName, LinkButton LinkDoc) { try { string registerFileNo = dbFileNoData.getFileNo(DocType); string filename = Path.GetFileName(FControlName.FileName); string fileExtension = System.IO.Path.GetExtension(FControlName.PostedFile.FileName); string VillageCode = cmbVillage.SelectedValue.ToString(); string DocumentNo = cmbDocumentNo.SelectedValue.ToString(); string NewFileName = DocType + "_" + VillageCode + "_" + DocumentNo + "_" + registerFileNo + fileExtension; string folderName = Server.MapPath("~/Documents/" + VillageCode + "/"); if (!Directory.Exists(folderName)) { Directory.CreateDirectory(folderName); } FControlName.SaveAs(folderName + NewFileName); //update MR File Number dbFileNoData.registername = DocType; dbFileNoData.currentno = Convert.ToInt32(registerFileNo) + 1; dbFileNoData.UpdateFileNo(); LinkDoc.Text = NewFileName; string FinalPath = folderName + NewFileName; ViewState["filepath"] = FinalPath; //Insert in to Document Status string DocumentID = dbDocumentStatusData.getDocumentSeqNo(); dbDocumentStatusData.documentid = Convert.ToInt32(DocumentID); dbDocumentStatusData.villagecode = VillageCode; dbDocumentStatusData.documentcode = DocType; dbDocumentStatusData.documentname = NewFileName; dbDocumentStatusData.documentpath = ViewState["filepath"].ToString(); dbDocumentStatusData.createdby = Session["UserName"].ToString(); dbDocumentStatusData.createddate = DateTime.Today; dbDocumentStatusData.docno = DocumentNo; //Check For Record Exist dsDocumenteExists = dbDocumentStatusData.DocumentExistInDocStatus(VillageCode, DocumentNo, DocType, "SO1"); if (dsDocumenteExists.Tables[0].Rows.Count == 0) { //string ModifiedSurveyNo = dbDocumentStatusData.surveyno; //dbDocumentStatusData.surveyno = ModifiedSurveyNo.Replace("'", ""); dbDocumentStatusData.surveyno = ""; dbDocumentStatusData.familyno = ""; dbDocumentStatusData.titlesearchno = ""; dbDocumentStatusData.officename = "SO1"; bool DocInsert = dbDocumentStatusData.AddDocumentStatus(); } else { bool DocumentFileUpdate = dbDocumentStatusData.UpdateDocumentStatusFile(); if (DocumentFileUpdate) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('New File Not Uploaded');", true); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('New File updated');", true); } } } catch (Exception ex) { } }