public void getAllDetails(string iDocSendID) { entDocument objEnt; SendRecDoc objDoc = new SendRecDoc(); int userid = ((UserDetails)Session[clsConstant.TOKEN]).UserID; objEnt = objDoc.getDocDetailsMDB(int.Parse(id)); lblDocCategory.Text = objEnt.DocCat; lblDocID.Text = objEnt.DocID; lblDocType.Text = objEnt.DocType; lblDueDate.Text = objEnt.DueDate; lblDocName.Text = objEnt.DocName; if (((UserDetails)Session[clsConstant.TOKEN]).UserID.ToString() == objEnt.UserID) { lblSenderName.Text = "ME"; } else { lblSenderName.Text = objEnt.SenderName; } lblLoanNo.Text = objEnt.LoanNo; lblTaNumber.Text = objEnt.TANo; lblProject.Text = objEnt.Project; lblFileTrackingID.Text = objEnt.FileTrackingID; Session["userRemindEmail"] = objEnt.eMailID; }
public void SaveComment_clarification(string _Type, string _iDocsendDetailsID, string _sDocumentName, string refno) { SendRecDoc objDoc = new SendRecDoc(); string PuserID = ((UserDetails)Session[clsConstant.TOKEN]).UserID.ToString(); string sqlto = "select tblUserMaster.iUserID from tblUserMaster "; sqlto = sqlto + " join tblDocSendDetail on tblDocSendDetail.iUserID=tblUserMaster.iUserID "; sqlto = sqlto + " where iDocSendID =" + _iDocsendDetailsID + " and bTOCC=1 "; SqlConnection cntouser = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString); SqlDataAdapter adtouser = new System.Data.SqlClient.SqlDataAdapter(sqlto, cntouser); DataSet dstouser = new DataSet(); adtouser.Fill(dstouser); for (int i = 0; i <= dstouser.Tables[0].Rows.Count - 1; i++) { string userto = dstouser.Tables[0].Rows[i]["iUserID"].ToString(); string sqlmcid = " select imcid from tblDocSend where iDocSendID=" + _iDocsendDetailsID; SqlConnection mcidcon = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString); SqlDataAdapter mciad = new System.Data.SqlClient.SqlDataAdapter(sqlmcid, mcidcon); DataSet dsmcid = new DataSet(); mciad.Fill(dsmcid); string emailAlert = string.Empty; DataSet dsuserEmail = new DataSet(); dsuserEmail = objDoc.getmailforrejectApprove(int.Parse(dsmcid.Tables[0].Rows[0]["imcid"].ToString())); emailAlert += GetFromID(int.Parse(dsmcid.Tables[0].Rows[0]["imcid"].ToString())) + ';'; emailAlert += dsuserEmail.Tables[0].Rows[0]["selectusr"].ToString() + ';'; emailAlert = FindEmailID(emailAlert, ((UserDetails)(Session[clsConstant.TOKEN])).EmailID) + ';'; if (emailAlert.Contains("*****@*****.**")) { emailAlert += "*****@*****.**" + ';'; } Session["userEmail"] = emailAlert; if (objDoc.saveALLComment(dsmcid.Tables[0].Rows[0]["imcid"].ToString(), _iDocsendDetailsID, "R", _sDocumentName, refno, DateTime.Now, int.Parse(PuserID), userto, "") > 0) { Utility objUtl = new Utility(); try { string nameOfSender = ((UserDetails)Session[clsConstant.TOKEN]).FirstName.ToString() + ' ' + ((UserDetails)Session[clsConstant.TOKEN]).LastName.ToString(); objUtl.SendAlertEmail_MC_NIC_NotAttachment(Session["userEmail"].ToString(), "Replied - " + refno, nameOfSender, null, null, ((UserDetails)Session[clsConstant.TOKEN]).Designation, ((UserDetails)Session[clsConstant.TOKEN]).Agency); } catch (Exception ex) { throw ex; } } } }
protected void fillComboBox(DropDownList objDdl) { objDoc = new SendRecDoc(); objDdl.DataSource = objDoc.bindControl(clsConstant.SP_GET_AGENCY, "A"); objDdl.DataTextField = "DisplayFieldText"; objDdl.DataValueField = "ValueFieldText"; objDdl.DataBind(); }
private void fillControl() { objDoc = new SendRecDoc(); this.fillComboBox(ddlAgency, ddlEmailGroup); this.fillComboBox(ddlAgencyCC, ddlEmailGrpCC); this.getUserDetails(id == ""?"0":id, lstToSelectedEmail); this.getUserDetails(id, lstCCSelected); }
protected void grdAtchFile_SelectedIndexChanged(object sender, EventArgs e) { try { int iDocID = 0; for (int i = 0; i < grdAtchFile.Rows.Count; i++) { if (grdAtchFile.SelectedIndex == i) { iDocID = Convert.ToInt32(grdAtchFile.DataKeys[i].Value.ToString()); SendRecDoc objSendDoc = new SendRecDoc(); entDocument objEnt = objSendDoc.downloadDocForAttachFile(iDocID); if (objEnt != null) { Byte[] programFile = objEnt.FileData; if (objEnt.FileName != null) { string contentType = objEnt.FileType; //obtaing filename from the table string fileName = objEnt.FileName; //The ContentType property specifies the HTTP content type for the response. //If no ContentType is specified, the default is text/HTML. Response.ContentType = contentType; //The AddHeader method adds a new HTML header and value to the response sent to the client Response.AddHeader("content-disposition", "attachment;filename=" + fileName); //The Charset property appends the name of the character set (for example, ISO-8859-13) to the content-type header in the Response object //Here Blank is attached Response.Charset = ""; //Provides enumerated values that are used to set the Cache-Control HTTP header. Response.Cache.SetCacheability(HttpCacheability.NoCache); } //Provides enumerated values that are used to set the Cache-Control HTTP header. Response.BinaryWrite(programFile); //The End method causes the Web server to stop // processing the script and return the current result. Response.End(); } else { lblMessage.Text = "File DoesNot Exists"; } } } } catch (Exception ex) { logger.Error(ex); } }
protected void btnResend_Click(object sender, EventArgs e) { SendRecDoc objDoc = new SendRecDoc(); if (objDoc.saveComment(id, "C", int.Parse(iuserid), txtComments.Text)) { lblMessage.ForeColor = System.Drawing.Color.Blue; lblMessage.Text = "Document has been close successfully"; txtComments.Text = ""; } else { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Sorry Error Occurs"; } }
protected void Page_Load(object sender, EventArgs e) { try { id = Request.QueryString["DocDetailsId"]; iuserid = Request.QueryString["UserID"]; if (!IsPostBack) { ViewState["PreviousPage"] = Request.UrlReferrer; if (Utility.CheckAccess("CloseDocument") == false) { UrlParameterPasser urlWrapper = new UrlParameterPasser(); urlWrapper["pageaccesserr"] = "1"; urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx"; urlWrapper.PassParameters(); } else { getAllDetails(id); } } if (id == null || iuserid == null) { UrlParameterPasser urlparam = new UrlParameterPasser("DocumentReceived1.aspx"); urlparam.PassParameters(); } else { objDoc = new SendRecDoc(); if (objDoc.isDocClose(id, iuserid)) { lblMessage.Text = "Document already Closed."; txtComments.Visible = false; btnClose.Visible = false; } } } catch (Exception ex) { logger.Error(ex); } }
protected void getAgencyDetails(DropDownList objDdlst, ListBox objLstTo, ListBox objLstSelected) { objDoc = new SendRecDoc(); objLstTo.DataSource = objDoc.bindControl(clsConstant.SP_GET_USER_BY_AGENCY, "ListBox", int.Parse(objDdlst.SelectedValue), -1); objLstTo.DataTextField = "DisplayFieldText"; objLstTo.DataValueField = "ValueFieldText"; objLstTo.DataBind(); for (int iloop = 0; iloop < objLstSelected.Items.Count; iloop++) { for (int ilp = 0; ilp < objLstTo.Items.Count; ilp++) { if (objLstTo.Items[ilp].Value == objLstSelected.Items[iloop].Value) { objLstTo.Items.Remove(objLstTo.Items.FindByValue(objLstTo.Items[ilp].Value)); } } } //ddlEmailGroup.SelectedIndex = -1; }
protected void btnResend_Click(object sender, EventArgs e) { try { SendRecDoc objDoc = new SendRecDoc(); if (objDoc.saveCommentMDB(id, "M", int.Parse(iuserid), txtComments.Text)) { Utility objUtl = new Utility(); try { string nameOfSender = ((UserDetails)Session[clsConstant.TOKEN]).FirstName.ToString() + ' ' + ((UserDetails)Session[clsConstant.TOKEN]).LastName.ToString(); //objUtl.sendNewDocumentMail(Session["userRemindEmail"].ToString(), "Reminder - " + lblDocName.Text, nameOfSender); // for Local objUtl.SendAlertEmail(Session["userRemindEmail"].ToString(), "Reminder - " + lblDocName.Text, nameOfSender , ((UserDetails)Session[clsConstant.TOKEN]).Designation.ToString(), ((UserDetails)Session[clsConstant.TOKEN]).Agency.ToString()); // for NIC UrlParameterPasser objPass = new UrlParameterPasser("DashBoard.aspx"); Session["userMsg"] = "Reminder has been sent successfully"; txtComments.Text = ""; Session.Remove("userRemindEmail"); objPass.PassParameters(); } catch (Exception ex) { throw ex; } } else { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Sorry Error Occurs"; } } catch (Exception ex) { logger.Error(ex); } }
public void getAllDetails(string iDocSendID) { entDocument objEnt; SendRecDoc objDoc = new SendRecDoc(); int userid = ((UserDetails)Session[clsConstant.TOKEN]).UserID; int iType = 0; if (type == "received") { iType = 1; } objEnt = objDoc.setEntValues(int.Parse(iDocSendID), userid, iType, int.Parse(iDocDetailsID)); lblDocCategory.Text = objEnt.DocCat; lblDocID.Text = objEnt.DocID; lblParentDocID.Text = objEnt.ParentID != "0" ? objEnt.ParentID : ""; lblDocType.Text = objEnt.DocType; lblDueDate.Text = objEnt.DueDate; lblDocName.Text = objEnt.DocName; lblAgencyName.Text = objEnt.AgencyCode; hdnDesignation.Value = objEnt.Designation; if (((UserDetails)Session[clsConstant.TOKEN]).UserID.ToString() == objEnt.UserID) { lblSenderName.Text = ((UserDetails)Session[clsConstant.TOKEN]).userNm.ToString(); // "ME"; } else { lblSenderName.Text = objEnt.SenderName; } if ((objEnt.LoanNo != "" && objEnt.TANo.ToString() == "" && objEnt.Project.ToString() == "") || (objEnt.LoanNo == "" && objEnt.TANo.ToString() != "" && objEnt.Project.ToString() == "") || (objEnt.LoanNo == "" && objEnt.TANo.ToString() == "" && objEnt.Project.ToString() != "") || (objEnt.LoanNo != "" && objEnt.TANo.ToString() == "" && objEnt.Project.ToString() != "") || (objEnt.LoanNo == "" && objEnt.TANo.ToString() != "" && objEnt.Project.ToString() != "")) { lblLoanNo.Text = objEnt.LoanNo; lblTaNumber.Text = objEnt.TANo; lblProject.Text = objEnt.Project; tdLoan.InnerText = "Loan"; tdProject.InnerText = "Project"; tdTA.InnerText = "TA No"; } else { lblLoanNo.Text = objEnt.Pipeline; lblTaNumber.Text = objEnt.AAA; lblProject.Text = objEnt.Portfolio; tdLoan.InnerText = "Pipeline"; tdProject.InnerText = "Portfolio"; tdTA.InnerText = "AAA No"; } lblFileTrackingID.Text = objEnt.FileTrackingID; txtMessage.Text = objEnt.Message.Replace("<br>", "\n"); txtReminder.Text = objEnt.ReminderDetails; txtReply.Text = objEnt.ReplyDetails; lblSenderID.Text = objEnt.UserID; lblDocDetailsID.Text = objEnt.DocSendDetailsID; if (txtReminder.Text.Length <= 0) { txtReminder.Visible = false; lblReminder.Visible = false; } if (txtReply.Text.Length <= 0) { txtReply.Visible = false; lblReply.Visible = false; } if (objEnt.DocSendStatus == "C") { imgBtnClose.Visible = false; imgBtnReminder.Visible = false; btnReply.Visible = false; } hdnCreateDate.Value = objEnt.dtCreateDate; }
protected void LoadMCData() { string sql = "SELECT vsMissionClearnceName,iProjectMasterID,iLoanId,iSectorID, (case when iLoanId is not null or iLoanId =0 then (Select vsDocCatName from tblDocCatMaster where iDocCatID = iSectorID) end) as Sector,TaID, RETAType,RETADescription,dbo.tblUserMaster.iUserID, dbo.tblUserMaster.vsFirstName + ' ' + dbo.tblUserMaster.vsLastName AS ReceiverName, (Umast.vsFirstName +' '+ Umast.vsLastName) as SenderName"; sql = sql + ", dbo.tblUserMaster.iAgencyID AS ReveiverAgencyId,itouser,case when SeminarDescription='' then ADBOther else SeminarDescription end SeminarDescription,ADBOther FROM dbo.tblMC INNER JOIN "; sql = sql + " dbo.tblUserMaster ON dbo.tblMC.iFromUser = dbo.tblUserMaster.iUserID INNER JOIN"; sql = sql + " dbo.tblUserMaster AS Umast ON dbo.tblMC.iToUser = Umast.iUserID"; sql = sql + " wHERE iMissionClearanceId=" + MCID; SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString); cn.Close(); cn.Open(); SqlDataAdapter ad = new SqlDataAdapter(sql, cn); DataTable dt = new DataTable(); ad.Fill(dt); if (dt.Rows.Count > 0) { lblSector.Text = dt.Rows[0]["Sector"].ToString(); hdnSectorID.Value = dt.Rows[0]["iSectorID"].ToString(); txtDocName.Text = MCID + "-" + dt.Rows[0]["vsMissionClearnceName"].ToString(); if (Request.QueryString["PgType"] != null) { if (Request.QueryString["PgType"].ToString() == "Appoved") { txtReciever.Text = dt.Rows[0]["ReceiverName"].ToString(); txtSenderName.Text = dt.Rows[0]["SenderName"].ToString(); objDoc = new SendRecDoc(); this.fillComboBox(ddlAgency, ddlEmailGroup); ddlAgency.SelectedValue = dt.Rows[0]["ReveiverAgencyId"].ToString(); ddlAgency_SelectedIndexChanged(null, null); btnMulitpleForward_Click(null, null); } } else { sql = "select * from tblUserMaster where iUserID=" + dt.Rows[0]["iToUser"].ToString(); DataTable dt2 = new DataTable(); ad = new SqlDataAdapter(sql, cn); ad.Fill(dt2); if (dt2.Rows.Count > 0) { txtReciever.Text = dt2.Rows[0]["vsFirstName"].ToString() + " " + dt2.Rows[0]["vsLastName"].ToString(); } txtSenderName.Text = (((UserDetails)Session[clsConstant.TOKEN]).FirstName).ToString() + " " + (((UserDetails)Session[clsConstant.TOKEN]).LastName).ToString(); txtMultiLine.Text = Message(); } if (dt.Rows[0]["iLoanId"].ToString() != "0") { sql = "select * from tblLoanMaster where iLoanID=" + dt.Rows[0]["iLoanID"].ToString(); ad = new SqlDataAdapter(sql, cn); DataTable dt1 = new DataTable(); ad.Fill(dt1); lblMCFOR.Text = "Loan"; ddlFundType.Items.Insert(0, new ListItem("Loan", "Loan")); ddlLoanOrTA.Items.Insert(0, new ListItem(dt1.Rows[0]["vsLoanNumber"].ToString() + "-" + dt1.Rows[0]["vsLoanName"].ToString(), dt.Rows[0]["iLoanID"].ToString())); } else if (dt.Rows[0]["TaID"].ToString() != "0") { sql = "select * from tblTAMaster where iTAID=" + dt.Rows[0]["taid"].ToString(); ad = new SqlDataAdapter(sql, cn); DataTable dt1 = new DataTable(); ad.Fill(dt1); lblMCFOR.Text = "TA"; ddlFundType.Items.Insert(0, new ListItem("TA", "TA")); ddlLoanOrTA.Items.Insert(0, new ListItem(dt1.Rows[0]["iTANumber"].ToString() + "-" + dt1.Rows[0]["vsTAName"].ToString(), dt1.Rows[0]["iTAID"].ToString())); } else if (dt.Rows[0]["RETAType"].ToString() != "0") { if (dt.Rows[0]["RETAType"].ToString() == "1") { lblMCFOR.Text = "Reta"; } if (dt.Rows[0]["RETAType"].ToString() == "2") { lblMCFOR.Text = "Rdta"; } ddlFundType.Items.Insert(0, new ListItem(lblMCFOR.Text, dt.Rows[0]["RETAType"].ToString()));//pramod lblMCFOR.Text = "Reta"; ddlLoanOrTA.Visible = false; lblDescription.Visible = true; lblDescription.Text = dt.Rows[0]["RETADescription"].ToString(); } else if (dt.Rows[0]["iProjectMasterID"].ToString() != "0") { lblMCFOR.Text = "Project"; sql = "select * from tblProjectMaster where iProjectMasterID=" + dt.Rows[0]["iProjectMasterID"].ToString(); ad = new SqlDataAdapter(sql, cn); DataTable dt1 = new DataTable(); ad.Fill(dt1); lblMCFOR.Text = "Project"; ddlFundType.Items.Insert(0, new ListItem("Project", "Project")); ddlLoanOrTA.Items.Insert(0, new ListItem(dt1.Rows[0][2].ToString() + "-" + dt1.Rows[0][1].ToString(), dt1.Rows[0][0].ToString())); } else if (dt.Rows[0]["ADBOther"].ToString() != "") { lblMCFOR.Text = "Others"; ddlFundType.Items.Insert(0, new ListItem("Others", "0")); ddlLoanOrTA.Visible = false; lblDescription.Visible = true; lblDescription.Text = dt.Rows[0]["ADBOther"].ToString(); } else { lblMCFOR.Text = "Seminar"; ddlFundType.Items.Insert(0, new ListItem("Seminar", "0")); ddlLoanOrTA.Visible = false; lblDescription.Visible = true; lblDescription.Text = dt.Rows[0]["SeminarDescription"].ToString(); } } GetMCAttatchment(MCID); cn.Close(); }