public ActionResult Hire(HireEng aHireEng) { Engineer engineer = db.Engineers.Find(aHireEng.Id); aHireEng.Eid = engineer.id; aHireEng.Sid = Convert.ToInt32(Session["userID"]); aHireEng.EngineerName = engineer.engName; aHireEng.engineerAddress = engineer.engAdress; if(aHireEng.RequestText==null) { ViewBag.error = "Request Text doest not Empty!!!"; return View(aHireEng); } if(ModelState.IsValid) { HireBLL aHire= new HireBLL(); ViewBag.message = aHire.RequestHire(aHireEng); return View(aHireEng); } return RedirectToAction("Index"); }
public string RequestHire(HireEng ahireEng) { if (!hireGetway.isExistRequest(ahireEng)) { if (hireGetway.HireEng(ahireEng) > 0) { return("Request Sent Successfully"); } else { return("Faild"); } } return("Sorry!!! You already send Request......."); }
//Get Hire Request public ActionResult Hire(int? id) { if(id==null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Engineer engineer = db.Engineers.Find(id); HireEng hire = new HireEng(); hire.Eid = engineer.id; hire.Sid = Convert.ToInt32( Session["UserID"]); hire.EngineerName = engineer.engName; hire.engineerAddress=engineer.engAdress; if(engineer ==null) { return HttpNotFound(); } return View(hire); }
public int HireEng(HireEng aHireEng) { SqlConnection con = new SqlConnection(ConnectionString); con.Open(); string sqlQuery = "insert into HireEng (Sid, Eid, RequestText, RequestDate) values (@sid, @eid, @Request, '" + DateTime.Now + "') "; SqlCommand com = new SqlCommand(sqlQuery, con); com.Parameters.Clear(); com.Parameters.AddWithValue("sid", aHireEng.Sid); com.Parameters.AddWithValue("eid", aHireEng.Eid); com.Parameters.AddWithValue("Request", aHireEng.RequestText); int rowcount = com.ExecuteNonQuery(); con.Close(); return(rowcount); }
public bool isExistRequest(HireEng Request) { SqlConnection con = new SqlConnection(ConnectionString); con.Open(); string sqlQuery = "select * from HireEng where Eid=@EngId and Sid = @SupID"; SqlCommand com = new SqlCommand(sqlQuery, con); com.Parameters.Clear(); com.Parameters.AddWithValue("EngId", Request.Eid); com.Parameters.AddWithValue("supId", Request.Sid); SqlDataReader reader = com.ExecuteReader(); if (reader.HasRows) { return(true); } else { return(false); } }