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