/////////////////////////////// ///////// Form Events ///////// /////////////////////////////// protected void Page_Load(object sender, EventArgs e) { clsSpeedo.Authenticate(); if (!Page.IsPostBack) { RFI.AuthenticateUser(RFI.RFIUserType.Requestor, Request.Cookies["Speedo"]["UserName"].ToString(), Request.QueryString["rficode"].ToString()); txtRFICode.Text = Request.QueryString["rficode"].ToString(); txtRequestorName.Text = clsUsers.GetName(Request.Cookies["Speedo"]["UserName"].ToString()); RFI objRFI = new RFI(); objRFI.RFICode = txtRFICode.Text; objRFI.Fill(); txtIntended.Text = objRFI.Intended; txtDateReq.Text = objRFI.DateRequested.ToString("MMMM dd, yyyy"); txtApproverName.Text = clsEmployee.GetName(objRFI.Approver, EmployeeNameFormat.LastFirst); txtApproverRem.Text = objRFI.ApproverRemarks; txtPMName.Text = clsEmployee.GetName(objRFI.ProcurementManager, EmployeeNameFormat.LastFirst); txtPMRem.Text = objRFI.ProcurementManagerRemarks; hdnStatus.Value = objRFI.Status; txtStat.Text = objRFI.StatusDescription; dgItems.DataSource = RFIDetails.GetDSGPageRFIDetails(Request.QueryString["rficode"]); dgItems.DataBind(); } }
protected void btnSend_Click(object sender, ImageClickEventArgs e) { if (dgItems.Items.Count == 0) { divError.Visible = true; lblErrMsg.Text = "Unable to send your request.<br>" + "<table>" + "<tr>" + "<td style='vertical-align:top;'><b>Reason:</b></td>" + "<td>You need to include at least one item to request. Make sure to click <b>Add New Item</b> button to include your requested item.</td>" + "</tr>" + "</table>"; } else { DataTable tblItems = ViewState["RequestedItems"] as DataTable; RFI objRFI = new RFI(); objRFI.Username = Request.Cookies["Speedo"]["UserName"]; objRFI.Intended = txtIntended.Text; objRFI.Approver = ddlApprover.SelectedValue; objRFI.ApproverStatus = "F"; objRFI.ProcurementManager = hdnProcurementCode.Value; objRFI.ProcurementManagerStatus = "F"; objRFI.Insert(tblItems); string strApproverMail = clsUsers.GetEmail(ddlApprover.SelectedValue); string strApproverName = clsEmployee.GetName(ddlApprover.SelectedValue); RFI.SendNotification(RFI.RFIMailType.SentToApprover, txtRequestorName.Text, strApproverName, strApproverMail, objRFI.RFICode); RFI.SendNotification(RFI.RFIMailType.SentToRequestor, txtRequestorName.Text, strApproverName, clsUsers.GetEmail(Request.Cookies["Speedo"]["UserName"].ToString()), objRFI.RFICode); Response.Redirect("RFIMain.aspx"); } }
protected void savebtn_Click(object sender, EventArgs e) { RFI r = new RFI(); // Code for Upload file to database if (docUpload.HasFile) { fileList = new List <DocumentFile>(); if (docUpload.PostedFiles.Count == 2) { ErrorMessage.Visible = false; foreach (HttpPostedFile file in docUpload.PostedFiles) { //HttpPostedFile file = docUpload.PostedFile; BinaryReader br = new BinaryReader(file.InputStream); byte[] buffer = br.ReadBytes(file.ContentLength); using (BHSCMS_Entities dc = new BHSCMS_Entities()) { dc.DocumentTables.Add( new DocumentTable { TypeID = 5, Document_Data = buffer, Document_Name = file.FileName, Content_Type = file.ContentType, ReferenceID = rId, DateStamp = DateTime.Today, VendorID = vendorID }); dc.SaveChanges(); PopulateUploadedFiles(); } } r.UpdateRFIStatus(rId, vendorID);//updates the complete status on VendorRFITable Page.Response.Redirect("VendorRFIList.aspx"); } else { ErrorMessage.Visible = true; FailureText.Text = "***2 Files are required to submit the RFI"; } } }
protected void LoadRFI() { string strWrite = ""; int intCtr = 0; using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["speedo"].ToString())) { clsMRCF mrcf = new clsMRCF(); SqlCommand cmd = cn.CreateCommand(); cmd.CommandText = "SELECT TOP 10 rficode,intended,datereq,apprcode,apprstat,proccode,procstat,status FROM CIS.RFI WHERE username='******' ORDER BY datereq DESC"; cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { strWrite += "<tr>" + "<td class='GridRows'>" + "<a href='RFIDetails.aspx?rficode=" + dr["rficode"] + "'><img src='../../Support/" + RFI.GetRequestStatusIcon(dr["status"].ToString()) + "' alt='' /></a>" + "</td>" + "<td class='GridRows'>" + "<a href='RFIDetails.aspx?rficode=" + dr["rficode"] + "' style='font-size:small;'>" + dr["intended"] + "</a><br>" + "Date Requested: " + Convert.ToDateTime(dr["datereq"]).ToString("MMMM dd,yyyy") + "</td>" + "<td class='GridRows'>" + RFI.GetRequestStatusRemarks(dr["status"].ToString(), dr["apprcode"].ToString(), dr["apprstat"].ToString(), dr["proccode"].ToString(), dr["procstat"].ToString()) + "</td>" + "</tr>"; intCtr++; } dr.Close(); } Response.Write(strWrite); if (intCtr == 0) { Response.Write("<tr><td colspan='3' class='GridRows'>No record found</td></tr>"); } else { Response.Write("<tr><td colspan='3' class='GridRows'>[ " + intCtr + " records found ]</td></tr>"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Master.HeadingMessage("Material Details(" + Request.QueryString["MAT_CODE1"] + ")"); MR.MasterTableView.AllowPaging = false; MR.Rebind(); decimal mr_sum = WebTools.DSum("MR_QTY", "VIEW_MAT_REQUISITION", "CLIENT_PART_NO='" + Request.QueryString["MAT_CODE1"] + "'"); lblMrCnt.Text = "Count :" + MR.MasterTableView.Items.Count.ToString(); lblMrSum.Text = "Sum :" + mr_sum.ToString(); PO.MasterTableView.AllowPaging = false; PO.Rebind(); decimal po_sum = WebTools.DSum("PO_QTY", "VIEW_PO_REPORT_MAIN", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'"); lblPoCnt.Text = "Count :" + PO.MasterTableView.Items.Count.ToString(); lblPoSum.Text = "Sum :" + po_sum.ToString(); Batch.MasterTableView.AllowPaging = false; Batch.Rebind(); decimal batch_sum = WebTools.DSum("BATCH_QTY", "VIEW_PO_BATCH_PLAN_DETAIL", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'"); lblBatchCnt.Text = "Count :" + Batch.MasterTableView.Items.Count.ToString(); lblBatchSum.Text = "Sum :" + batch_sum.ToString(); IRN.MasterTableView.AllowPaging = false; IRN.Rebind(); decimal irn_sum = WebTools.DSum("RELEASE_QTY", "VIEW_PO_IRN_DETAIL_REP", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'"); lblIrnCnt.Text = "Count :" + IRN.MasterTableView.Items.Count.ToString(); lblIrnSum.Text = "Sum :" + irn_sum.ToString(); MRR.MasterTableView.AllowPaging = false; MRR.Rebind(); decimal mrr_sum = WebTools.DSum("RECV_QTY", "VIEW_MAT_RCV_REPORT_DT", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'"); lblMrrCnt.Text = "Count :" + MRR.MasterTableView.Items.Count.ToString(); lblMrrSum.Text = "Sum :" + mrr_sum.ToString(); RFI.MasterTableView.AllowPaging = false; RFI.Rebind(); decimal rfi_sum = WebTools.DSum("INSP_QTY", "VIEW_MAT_RFI_REPORT", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'"); lblRfiCnt.Text = "Count :" + RFI.MasterTableView.Items.Count.ToString(); lblRfiSum.Text = "Sum :" + rfi_sum.ToString(); MRIR.MasterTableView.AllowPaging = false; MRIR.Rebind(); decimal mrir_sum = WebTools.DSum("ACPT_QTY", "VIEW_MAT_MRIR_REPORT", "MAT_CODE='" + Request.QueryString["MAT_CODE1"] + "'"); lblMrirCnt.Text = "Count :" + MRIR.MasterTableView.Items.Count.ToString(); lblMrirSum.Text = "Sum :" + mrir_sum.ToString(); MaterialRequest.MasterTableView.AllowPaging = false; MaterialRequest.Rebind(); decimal mat_req_sum = WebTools.DSum("REQ_QTY", "VIEW_MATERIAL_REQUEST_DT1", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'"); lblMaterialRequestCnt.Text = "Count :" + MaterialRequest.MasterTableView.Items.Count.ToString(); lblMaterialRequestSum.Text = "Sum :" + mat_req_sum.ToString(); MTN.MasterTableView.AllowPaging = false; MTN.Rebind(); decimal mtn_sum = WebTools.DSum("TRANSF_QTY", "VIEW_ADAPTER_MAT_TRANSF_DT1", "MATERIAL_CODE='" + Request.QueryString["MAT_CODE1"] + "'"); lblMtnCnt.Text = "Count :" + MTN.MasterTableView.Items.Count.ToString(); lblMtnSum.Text = "Sum :" + mtn_sum.ToString(); MTNreceive.MasterTableView.AllowPaging = false; MTNreceive.Rebind(); decimal mtn_recv_sum = WebTools.DSum("RCV_QTY", "VIEW_MAT_TRANSFER_RCV_DT", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'"); lblMtnRcvCnt.Text = "Count :" + MTNreceive.MasterTableView.Items.Count.ToString(); lblMtnRcvSum.Text = "Sum :" + mtn_recv_sum.ToString(); MIV.MasterTableView.AllowPaging = false; MIV.Rebind(); decimal miv_sum = WebTools.DSum("ISSUE_QTY", "VIEW_ADAPTER_ISSUE_ADD_DETAIL", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'"); lblMivCnt.Text = "Count :" + MIV.MasterTableView.Items.Count.ToString(); lblMivSum.Text = "Sum :" + miv_sum.ToString(); Reconcilation.MasterTableView.AllowPaging = false; Reconcilation.Rebind(); decimal recon_sum = WebTools.DSum("BAL_QTY", "VIEW_ITEM_REP_A", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'"); lblReconCnt.Text = "Count :" + Reconcilation.MasterTableView.Items.Count.ToString(); lblReconSum.Text = "Sum :" + recon_sum.ToString(); } }
/// <summary> /// Submit the RFI in the system /// </summary> protected void Submit_Click1(object sender, EventArgs e) { RFI rfi = new RFI(); int rfiId; rfi.CreateNewRFI(UserInfoBoxControl.UserID, lblstartdate.Text, lblenddate.Text, ddCategories.SelectedIndex, Convert.ToDecimal(this.currentPrice.Text), this.productDescription.Text); rfiId = rfi.GetLastRFI_IDinserted(); int index = 0;//index use to step through the permissionlist foreach (var vendor in vendorlist) { try { string insertQry = "Insert into [BHSCMS].[dbo].[VendorRFITable] (RFI_ID, VendorID, PermissionID) Values (@rfiId, @vendorid, @permissionId)"; string connString = ConfigurationManager.ConnectionStrings["BHSCMS"].ConnectionString; SqlConnection conn = new SqlConnection(connString); SqlCommand cmd = new SqlCommand(insertQry, conn); conn.Open(); cmd.Parameters.AddWithValue("@rfiId", rfiId); cmd.Parameters.AddWithValue("@vendorid", vendor); cmd.Parameters.AddWithValue("@permissionId", permissionlist[index]); cmd.ExecuteNonQuery(); conn.Close(); index++;//increases the index of permissionID list } catch (Exception ex) { } } //string docFullPath = FTPUpload(rfiId);//calls the UploadRFI method to upload file and save the path in the DocumentTable if (fileList != null && fileList.Count > 0) { foreach (DocumentFile file in fileList) { file.ReferenceID = rfiId; file.TypeID = 2; FunctionsHelper.UploadDocument(file); } } else { //Alert the user that something bad has happened string startupScript = "alert('Document Upload failed please try again. Or contact an IS Admin')"; ClientScript.RegisterStartupScript(GetType(), "startupScript", startupScript); } reviewPanel.Visible = false; setupPanel.Visible = false; panelVendors.Visible = false; panelvendorlist.Visible = false; ddCategories.Visible = false; ddlCategorylabel.Visible = false; txtCategory.Visible = false; txtCategorylabel.Visible = false; RFIsubmit.Visible = true; lblsuccess.Text = "The RFI has been successfully submitted"; vendorlist = null;//static lists are cleared to be used again permissionlist = null; companylist = null; fileList = null; }