public void CreateNewBid(BidModel bid)
{
DbConnection.Open();
MySqlCommand command = DbConnection.CreateCommand();
command.CommandText = "INSERT INTO bid (owner,noticeid,pdfdoc) values(@owner,@noticeid,@pdfdoc)";
command.Parameters.AddWithValue("@owner", bid.Owner);
command.Parameters.AddWithValue("@noticeid", bid.NoticeId);
command.Parameters.AddWithValue("@pdfdoc", bid.PdfDoc);
command.ExecuteNonQuery();
DbConnection.Close();
}
public ActionResult AddBid()
{
// create a new bid
if (Request.HttpMethod.Equals("POST"))
{
BidModel bid = new BidModel();
bid.Owner = (String)Session["username"];
bid.NoticeId = int.Parse(Request.Form["noticeid"]);
HttpPostedFileBase file = Request.Files["PDF"];
if (file != null && file.ContentLength > 0) // upload PDF document
{
System.IO.Stream fileStream = file.InputStream;
byte[] data = new byte[file.ContentLength];
fileStream.Read(data, 0, data.Length);
fileStream.Close();
bid.PdfDoc = data;
}
DBContext.GetInstance().CreateNewBid(bid);
return RedirectToAction("BidDashboard", "Bidder");
}
return RedirectToAction("BidDashboard", "Bidder"); // return to dashboard after creating it.
}
public void CreateNewBid(BidModel bid)
{
DbConnection.Open();
MySqlCommand command = DbConnection.CreateCommand();
command.CommandText = "INSERT INTO bid (owner,noticeid,pdfdoc) values(@owner,@noticeid,@pdfdoc)";
command.Parameters.AddWithValue("@owner", bid.Owner);
command.Parameters.AddWithValue("@noticeid", bid.NoticeId);
command.Parameters.AddWithValue("@pdfdoc", bid.PdfDoc);
command.ExecuteNonQuery();
DbConnection.Close();
}