public string GetRFP(string sc)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select * from RECIEPT_FOR_PAYMENT where SCORE_ID=@sc order by RECIEPT_FOR_PAYMENT_ID desc", new SqlParameter[] { new SqlParameter("@sc", sc) }, CommandType.Text);
List <RFP> rfps = new List <RFP>();
int objId = (int)Mydb.ExecuteScalar("select OBJECT_ID from PER_SCORE where SCORE_ID=@sc", new SqlParameter[] { new SqlParameter("@sc", sc) }, CommandType.Text);
foreach (DataRow item in dt.Rows)
{
RFP rfp = new RFP();
rfp.ACCURED_SUMM = item["ACCURED_SUMM"].ToString();
rfp.BACKLOG_START = item["BACKLOG_START"].ToString();
rfp.DATA_MOUNTH_YEAR = item["DATA_MOUNTH_YEAR"].ToString();
rfp.PAYMENT_SUM = item["PAYMENT_SUMM"].ToString();
rfp.RECIEPT_FOR_PAYMENT_ID = (int)item["RECIEPT_FOR_PAYMENT_ID"];
rfp.PAY_DATE = item["PAY_DATE"].ToString();
rfp.MASTER_GUID = item["MASTER_GUID"].ToString();
rfp.PAYED = item["PAYED"].ToString();
rfp.GENERAL_SUM = item["GENERAL_SUM"].ToString();
rfp.RECEIVED = item["RECEIVED"].ToString();
rfp.PAYMENT_SUM = Mydb.ExecuteScalar("TestDB.dbo.sp_QUICK_API_get_shopId", new SqlParameter[] { new SqlParameter("@tokenid", ""), new SqlParameter("@login", ""), new SqlParameter("@obj", objId) }, CommandType.StoredProcedure).ToString();
rfps.Add(rfp);
}
return(JsonConvert.SerializeObject(rfps));
}
protected void savebtn_Click(object sender, EventArgs e)
{
// Code for Upload file to database
if (docUpload.HasFiles)
{
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 = 6,
Document_Data = buffer,
Document_Name = file.FileName,
Content_Type = file.ContentType,
ReferenceID = rId,
DateStamp = DateTime.Today,
VendorID = vendorID
});
dc.SaveChanges();
PopulateUploadedFiles();
}
}
RFP r = new RFP();
decimal proposedPrice = Convert.ToDecimal(Request.Form[txtProposedPrice.UniqueID]);
r.UpdateRFPStatus(proposedPrice, rId, vendorID);//updates the complete status on VendorRFITable
Page.Response.Redirect("VendorRFPList.aspx");
}
else
{
ErrorMessage.Visible = true;
FailureText.Text = "***2 Files are required to submit the RFP";
}
}
}
/// <summary>
/// Submit the RFP in the system
/// </summary>
protected void Submit_Click(object sender, EventArgs e)
{
RFP rfp = new RFP();
decimal gatewayPrice = Convert.ToDecimal(this.txtgatewayPrice.Text);
int rfpid;
rfp.CreateNewRFP(ddRFI.SelectedIndex, UserInfoBoxControl.UserID, gatewayPrice, lblstartdate.Text, lblenddate.Text);
rfpid = rfp.GetLastRFP_IDinserted();
int index = 0;//index use to step through the permissionlist
foreach (var vendor in vendorlist)
{
try
{
string insertQry = "Insert into [BHSCMS].[dbo].[VendorRFPTable] (RFP_ID, VendorID, PermissionID) Values (@rfpId, @vendorid, @permissionId)";
string connString = ConfigurationManager.ConnectionStrings["BHSCMS"].ConnectionString;
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand(insertQry, conn);
conn.Open();
cmd.Parameters.AddWithValue("@rfpId", rfpid);
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)
{
}
}
if (fileList != null && fileList.Count > 0)
{
foreach (DocumentFile file in fileList)
{
file.ReferenceID = rfpid;
file.TypeID = 3;
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;
ddRFI.Visible = false;
ddlRFIlabel.Visible = false;
txtRFIProduct.Visible = false;
txtRFIProductlabel.Visible = false;
RFPsubmit.Visible = true;
lblsuccess.Text = "The RFP has been successfully submitted";
fileList = null;
vendorlist = null;//static lists are cleared to be used again
permissionlist = null;
companylist = null;
}
