protected void Page_Load(object sender, EventArgs e) { try { if ((HttpContext.Current.Session["LoginId"]) == null) { Response.Redirect("~/Login.aspx"); } if (!Page.IsPostBack) { Session["strFileName"] = null; Session["strFilePath"] = null; Session["chars"] = null; Session["filenew"] = null; //cbpdf.Visible = false; #region------------fill DDLClient------------ BLProject blvc = new BLProject(); SqlDataReader dr = blvc.getClientNameForProject1(); ddlCliNm.Items.Clear(); if (dr.HasRows) { while (dr.Read()) ddlCliNm.Items.Add(dr.GetString(0)); ddlCliNm.Items.Insert(0, new ListItem("--Select--", "-1")); dr.Close(); } #endregion #region----------Fill DDLTypeofWork-------------- BLProject bltow = new BLProject(); SqlDataReader dr1 = bltow.getTypeOfWorkForProject1(); ddlTypWrk.Items.Clear(); if (dr1.HasRows) { while (dr1.Read()) ddlTypWrk.Items.Add(dr1.GetString(1)); ddlTypWrk.Items.Insert(0, new ListItem("--Select--", "-1")); dr1.Close(); } #endregion ddlStatus.Items.Insert(0, new ListItem("--Select--", "-1")); #region-----------All fillgrid function call-------------- fillgridClerk(); fillgridPapers(); fillgridEmployees(); fillgridDocBoy(); #endregion #region------------------Show values to date textboxces----------------- txtDate.Text = DateTime.Now.Date.ToShortDateString(); txtSoftCopySent.Text = DateTime.Now.Date.ToShortDateString(); txtPendingDocRcd.Text = DateTime.Now.Date.ToShortDateString(); txtHardCopySent.Text = DateTime.Now.Date.ToShortDateString(); //txtPendingDocRcsp.Text = DateTime.Now.Date.ToShortDateString(); txtSearchInitiated.Text = DateTime.Now.Date.ToShortDateString(); //txtFinalReportSent.Text = DateTime.Now.Date.ToShortDateString(); txtSearchReceived.Text = DateTime.Now.Date.ToShortDateString(); txtReceiptSearch.Text = DateTime.Now.Date.ToShortDateString(); txtStrDtEmp.Text = DateTime.Now.Date.ToShortDateString(); txtEndDtEmp.Text = DateTime.Now.Date.ToShortDateString(); txtStrStarDtClerk.Text = DateTime.Now.Date.ToShortDateString(); txtStrEndDtClerk.Text = DateTime.Now.Date.ToShortDateString(); #endregion if (Request.QueryString["ProjectId"] != null) { //dpdwnlstFileNames.Visible = true; lblProjectId.Text = Request.QueryString["ProjectId"].ToString(); int intProjectId = int.Parse(lblProjectId.Text); BLProject blc = new BLProject(); //btnOpenAddWrk.Enabled = true; //btnDelAddWrk.Enabled = true; //btnEmailAddWrk.Enabled = true; // Code to show selected Documents int gvdocid; //intProjectId = int.Parse(Session["ProjectId"].ToString()); SqlDataReader dr3 = blc.showSelectedDoc1(intProjectId); System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add("docid"); if (dr3.HasRows) { while (dr3.Read()) { int doc = dr3.GetInt32(0); dt.Rows.Add(doc); } dr3.Close(); } foreach (GridViewRow gvrow in GVPapers.Rows) { if (gvrow.RowType == DataControlRowType.DataRow) { System.Web.UI.WebControls.Label lblDocumentID = (gvrow.Cells[0].FindControl("lblDocumentId") as System.Web.UI.WebControls.Label); gvdocid = int.Parse(lblDocumentID.Text); System.Web.UI.WebControls.CheckBox chksel = (gvrow.Cells[0].FindControl("ChkBxSelDoc") as System.Web.UI.WebControls.CheckBox); for (int i = 0; i < dt.Rows.Count; i++) { int doc = int.Parse(dt.Rows[i].Field<string>(0)); if (doc == gvdocid) { chksel.Checked = true; } } } } //Code to show selected Employees int gvempid; // intProjectId = int.Parse(Session["ProjectId"].ToString()); SqlDataReader dr4 = blc.showSelectedEmployees1(intProjectId); System.Data.DataTable dt1 = new System.Data.DataTable(); dt1.Columns.Add("empid"); if (dr4.HasRows) { while (dr4.Read()) { int emp = dr4.GetInt32(0); dt1.Rows.Add(emp); } dr4.Close(); } foreach (GridViewRow gvrow in GVEmployees.Rows) { if (gvrow.RowType == DataControlRowType.DataRow) { System.Web.UI.WebControls.Label lblEmployeeID = (gvrow.Cells[0].FindControl("lblEmployeeID") as System.Web.UI.WebControls.Label); gvempid = Convert.ToInt32(lblEmployeeID.Text); System.Web.UI.WebControls.CheckBox chksel = (gvrow.Cells[0].FindControl("ChkBxSelEmp") as System.Web.UI.WebControls.CheckBox); for (int i = 0; i < dt1.Rows.Count; i++) { int emp = int.Parse(dt1.Rows[i].Field<string>(0)); if (emp == gvempid) { chksel.Checked = true; } } } } //Code To show Selected Document Boys int gvdocboyid; // intProjectId = int.Parse(Session["ProjectId"].ToString()); SqlDataReader dr5 = blc.showSelectedDocBoys1(intProjectId); System.Data.DataTable dt2 = new System.Data.DataTable(); dt2.Columns.Add("docboyid"); if (dr5.HasRows) { while (dr5.Read()) { int doc = dr5.GetInt32(0); dt2.Rows.Add(doc); } dr5.Close(); } foreach (GridViewRow gvrow in GVDocBoy.Rows) { if (gvrow.RowType == DataControlRowType.DataRow) { System.Web.UI.WebControls.Label lblDocumentBoyID = (gvrow.Cells[0].FindControl("lblDocumentBoyID") as System.Web.UI.WebControls.Label); gvdocboyid = int.Parse(lblDocumentBoyID.Text); System.Web.UI.WebControls.CheckBox chksel = (gvrow.Cells[0].FindControl("ChkBxSelDocBoy") as System.Web.UI.WebControls.CheckBox); for (int i = 0; i < dt2.Rows.Count; i++) { int docboy = int.Parse(dt2.Rows[i].Field<string>(0)); if (docboy == gvdocboyid) { chksel.Checked = true; } } } } //Code to show selected clerk int gvclerkid; //intProjectId = int.Parse(Session["ProjectId"].ToString()); SqlDataReader dr6 = blc.showSelectedClerk1(intProjectId); System.Data.DataTable dt3 = new System.Data.DataTable(); dt3.Columns.Add("clerkid"); if (dr6.HasRows) { while (dr6.Read()) { int clerk = dr6.GetInt32(0); dt3.Rows.Add(clerk); } } dr6.Close(); foreach (GridViewRow gvrow in GVClerk.Rows) { if (gvrow.RowType == DataControlRowType.DataRow) { System.Web.UI.WebControls.Label lblClerkID = (gvrow.Cells[0].FindControl("lblClerkID") as System.Web.UI.WebControls.Label); gvclerkid = int.Parse(lblClerkID.Text); System.Web.UI.WebControls.CheckBox chksel = (gvrow.Cells[0].FindControl("ChkBxSelClerk") as System.Web.UI.WebControls.CheckBox); for (int i = 0; i < dt3.Rows.Count; i++) { int clerk = int.Parse(dt3.Rows[i].Field<string>(0)); if (clerk == gvclerkid) { chksel.Checked = true; } } } } SqlDataReader dr2 = blc.getProjectDetailsForUpdate1(intProjectId); if (dr2.HasRows) { while (dr2.Read()) { Button1.Enabled = false; //btnSaveWordFile.Enabled = true; ddlCliNm.Enabled = false; ddlTypWrk.Enabled = false; //ddlStatus.Visible = false; txtDate.Text = dr2.GetDateTime(1).ToShortDateString(); ddlCliNm.SelectedValue = dr2.GetString(3); //code for fill grid of service BLServices blaee = new BLServices(); string strClientName1 = Convert.ToString(ddlCliNm.SelectedItem.Text); SqlDataReader dr8 = blaee.getClientIDforService1(strClientName1); if (dr8.HasRows) { while (dr8.Read()) lblCliId1.Text = dr8.GetInt32(0).ToString(); } dr8.Close(); int intClientID = int.Parse(lblCliId1.Text); BLServices blpr = new BLServices(); SqlDataReader dr9 = blpr.getServicePrice1(intClientID); System.Data.DataTable dt5 = new System.Data.DataTable(); if (dr9.HasRows) { dt5.Load(dr9); GVServices.DataSource = dt5; GVServices.DataBind(); } dr9.Close(); //Code to show selected Services int gvserviceid; // intProjectId = int.Parse(Session["ProjectId"].ToString()); SqlDataReader drService = blc.showSelectedServices1(intProjectId); System.Data.DataTable dtService = new System.Data.DataTable(); dtService.Columns.Add("serviceid"); if (drService.HasRows) { while (drService.Read()) { int service = drService.GetInt32(0); dtService.Rows.Add(service); } } drService.Close(); foreach (GridViewRow gvrow in GVServices.Rows) { if (gvrow.RowType == DataControlRowType.DataRow) { System.Web.UI.WebControls.Label lblSeviceID = (gvrow.Cells[0].FindControl("lblServiceID") as System.Web.UI.WebControls.Label); gvserviceid = int.Parse(lblSeviceID.Text); System.Web.UI.WebControls.CheckBox chksel = (gvrow.Cells[0].FindControl("ChkBxSelService") as System.Web.UI.WebControls.CheckBox); for (int i = 0; i < dtService.Rows.Count; i++) { int service = int.Parse(dtService.Rows[i].Field<string>(0)); if (service == gvserviceid) { chksel.Checked = true; } } } } lblTypWrkID.Text = dr2.GetInt32(4).ToString(); ddlTypWrk.SelectedValue = dr2.GetString(5); txtCasNm.Text = dr2.GetString(6); bool intExternalWork = dr2.GetBoolean(7); if (intExternalWork == true) chkBxDsReqExtWrk.Checked = true; else chkBxDsReqExtWrk.Checked = false; bool intNeedSearch = dr2.GetBoolean(8); if (intNeedSearch == true) chkBxDsReqSrch.Checked = true; else chkBxDsReqSrch.Checked = false; txtRemarks.Text = dr2.GetString(9); txtPrice.Text = dr2.GetDecimal(10).ToString(); txtOtherCharge.Text = dr2.GetDecimal(11).ToString(); txtTotAmt.Text = dr2.GetDecimal(12).ToString(); txtStatus.Text = dr2.GetString(13); ddlStatus.SelectedValue = dr2.GetString(13); bool intIsDeleted = dr2.GetBoolean(14); if (intIsDeleted == true) rbYesIsDel.Checked = true; else rbNoIsDel.Checked = true; int intApprove = dr2.GetInt32(15); if (intApprove == 1) ChkBxApprovProject.Checked = true; else ChkBxApprovProject.Checked = false; txtServiceTax.Text = dr2.GetDecimal(16).ToString(); txtRefNo.Text = dr2.GetString(17); if (dr2["LoanNo"] != DBNull.Value) { txtLoanAcNoAddWrk.Text = dr2.GetString(18); } else { txtLoanAcNoAddWrk.Text = ""; } if (dr2["PropertyAddress"] != DBNull.Value) { txtPropertyDetails.Text = dr2.GetString(19); } else { txtPropertyDetails.Text = ""; } if (dr2["dt_softcopysent"] != DBNull.Value) { txtSoftCopySent.Text = dr2.GetDateTime(20).ToShortDateString(); } else { txtSoftCopySent.Text = DateTime.Now.Date.ToShortDateString(); } DateTime dt_MISclient = Convert.ToDateTime("1990-01-01 00:00:00.000"); if (dr2["dt_search_initiated"] != DBNull.Value) { txtSearchInitiated.Text = dr2.GetDateTime(22).ToShortDateString(); } else { txtSearchInitiated.Text = DateTime.Now.Date.ToShortDateString(); } if (dr2["dt_search_received"] != DBNull.Value) { txtSearchReceived.Text = dr2.GetDateTime(23).ToShortDateString(); } else { txtSearchReceived.Text = DateTime.Now.Date.ToShortDateString(); } if (dr2["dt_search_received_receipt"] != DBNull.Value) { txtReceiptSearch.Text = dr2.GetDateTime(24).ToShortDateString(); } else { txtReceiptSearch.Text = DateTime.Now.Date.ToShortDateString(); } if (dr2["dt_hardcopysent"] != DBNull.Value) { txtHardCopySent.Text = dr2.GetDateTime(25).ToShortDateString(); } else { txtHardCopySent.Text = DateTime.Now.Date.ToShortDateString(); } if (dr2["dt_pendingdocumentsrec"] != DBNull.Value) { txtPendingDocRcd.Text = dr2.GetDateTime(26).ToShortDateString(); } else { txtPendingDocRcd.Text = DateTime.Now.Date.ToShortDateString(); } //if (dr2["dt_pendingdocumentsresp"] != DBNull.Value) //{ // txtPendingDocRcsp.Text = dr2.GetDateTime(27).ToShortDateString(); //} //else //{ // txtPendingDocRcsp.Text = DateTime.Now.Date.ToShortDateString(); //} //if (dr2["dt_finalreportsent"] != DBNull.Value) //{ // txtFinalReportSent.Text = dr2.GetDateTime(28).ToShortDateString(); //} //else //{ // txtPendingDocRcsp.Text = DateTime.Now.Date.ToShortDateString(); //} if (dr2["branch"] != DBNull.Value) { txtBranchAddWrk.Text = dr2.GetString(31); } else { txtBranchAddWrk.Text = ""; } //if (dr2["loanamt"] != DBNull.Value) //{ // txtLoanAmtAddWrk.Text = dr2.GetDecimal(32).ToString(); //} //else //{ // txtLoanAmtAddWrk.Text = ""; //} if (dr2["worddoc"] != DBNull.Value) { Byte[] strworddoc = (byte[])dr2["worddoc"]; str = System.Text.Encoding.Default.GetString(strworddoc); Session["strFilePath"] = str; } else { Session["strFilePath"] = null; } if (dr2["filename"] != DBNull.Value) { //string filename = dr2.GetString(30); //string[] values = filename.Split(','); //for (int i = 0; i < values.Length; i++) //{ // values[i] = values[i].Trim(); // filename = values[i]; // dpdwnlstFileNames.Items.Add(filename); //} //Session["strFileName"] = dr2.GetString(30); } else { Session["strFileName"] = null; } //TRy if (dr2["EmailID"] != DBNull.Value) { //txtEmail.Text = dr2.GetString(33); } } dr2.Close(); } } } else { //Span1.InnerHtml = ""; lblResult.Text = ""; lblCatchError.Text = ""; lbltesting.Text = ""; lblMessageFile.Text = ""; lblDelMsg.Text = ""; //CEDate.SelectedDate = DateTime.ParseExact(txtDate.Text, CEDate.Format, null); CalendarExtender9.SelectedDate = DateTime.ParseExact(txtStrDtEmp.Text, CalendarExtender9.Format, null); CalendarExtender10.SelectedDate = DateTime.ParseExact(txtEndDtEmp.Text, CalendarExtender10.Format, null); CalendarExtender11.SelectedDate = DateTime.ParseExact(txtStrStarDtClerk.Text, CalendarExtender11.Format, null); CalendarExtender12.SelectedDate = DateTime.ParseExact(txtStrEndDtClerk.Text, CalendarExtender12.Format, null); CalendarExtender1.SelectedDate = DateTime.ParseExact(txtSoftCopySent.Text, CalendarExtender1.Format, null); CalendarExtender2.SelectedDate = DateTime.ParseExact(txtPendingDocRcd.Text, CalendarExtender2.Format, null); CalendarExtender3.SelectedDate = DateTime.ParseExact(txtHardCopySent.Text, CalendarExtender3.Format, null); //CalendarExtender5.SelectedDate = DateTime.ParseExact(txtPendingDocRcsp.Text, CalendarExtender5.Format, null); CalendarExtender4.SelectedDate = DateTime.ParseExact(txtSearchInitiated.Text, CalendarExtender4.Format, null); //CalendarExtender6.SelectedDate = DateTime.ParseExact(txtFinalReportSent.Text, CalendarExtender6.Format, null); CalendarExtender7.SelectedDate = DateTime.ParseExact(txtSearchReceived.Text, CalendarExtender7.Format, null); CalendarExtender8.SelectedDate = DateTime.ParseExact(txtReceiptSearch.Text, CalendarExtender8.Format, null); } } catch (Exception ex) { lblCatchError.Text = ex.Message.ToString(); } }
protected void FileUpload(int projectid) { try { string dirPath = Server.MapPath("~/Document/"); string filenm = projectid.ToString(); string fileExt = System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName); BLProject BlObjGetDetails = new BLProject(); if (Request.QueryString["ProjectId"] != null) { SqlDataReader dr2 = BlObjGetDetails.getProjectDetailsForUpdate1(projectid); dr2.Read(); //Split Mutiple files separated by comma and get last filename if (dr2["filename"] != DBNull.Value) { string[] Files = Directory.GetFiles(dirPath, filenm + "*.*", SearchOption.AllDirectories); int getFileCount = Files.Length; filename = dr2.GetString(30); values = filename.Split(','); for (int i = 0; i < values.Length; i++) { values[i] = values[i].Trim(); file = values[i]; } if (Session["filenew"] == null) { Session["filenew"] = filename; } } else { string[] Files = Directory.GetFiles(dirPath, filenm + ".*", SearchOption.AllDirectories); int getFileCount = Files.Length; if (getFileCount == 0) { file = projectid.ToString(); } foreach (string f in Files) { if (f.Contains(filenm)) { file = Session["filenew"].ToString(); suffix = 'a'; } else { file = projectid.ToString(); } } } dr2.Close(); //Split Upto filename and . character values = file.Split('.'); for (int i = 0; i < values.Length; i++) { values[i] = values[i].Trim(); file = values[i]; break; } int length = file.Length; suffix = file.Last(); if (Char.IsDigit(suffix)) { suffix = 'a'; } } strFileName = FileUpload1.PostedFile.FileName; c = projectid.ToString() + fileExt; string[] Files1 = Directory.GetFiles(dirPath, filenm + "*.*", SearchOption.AllDirectories); int getFileCount1 = Files1.Length; if (getFileCount1 == 0) { strFilePath = Server.MapPath("~\\Document\\" + c); FileUpload1.SaveAs(Server.MapPath("~\\Document\\") + c); filenew = c; Session["file"] = filenew; Session["filenew"] = filenew; Session["strFilePath"] = strFilePath; lblMessageFile.ForeColor = System.Drawing.Color.Green; lblMessageFile.Text = c + " file Uploaded Sucessfully."; lblFileuploadValue.Text = "1"; } else { if (Session["file"] != null) { file = Session["file"].ToString(); } if (Session["chars"] != null) { suffix = Convert.ToChar(Session["chars"]); } if (file.Contains(suffix)) { suffix++; } c = projectid.ToString() + suffix + fileExt; Session["chars"] = suffix; strFilePath = Session["strFilePath"].ToString() + "," + Server.MapPath("~\\Document\\" + c); FileUpload1.SaveAs(Server.MapPath("~\\Document\\") + c); if (Session["filenew"] != null) { filenew = Session["filenew"].ToString(); } if (Request.QueryString["ProjectId"] != null) { dpdwnlstFileNames.Items.Add(c); //filenew = filename; } filenew = filenew + "," + c; Session["file"] = c; Session["filenew"] = filenew; lblMessageFile.ForeColor = System.Drawing.Color.Green; lblMessageFile.Text = c + " file Uploaded Sucessfully."; lblFileuploadValue.Text = "1"; } Session["strFilePath"] = strFilePath; Session["strFileName"] = filenew; } catch (Exception ex) { lblCatchError.Text = ex.Message.ToString(); } }