///////////////////////////////
///////// 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;
}
