// PUT api/values/5
public HttpResponseMessage Put(int id, [FromBody] EmployeeMo value)
{
bool status = objEmployye.UpdateEmployee(id, value);
if (status)
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
// POST api/values
public HttpResponseMessage Post([FromBody] EmployeeMo value)
{
bool Status = objEmployye.SaveEmployee(value);
if (Status)
{
return(Request.CreateResponse(HttpStatusCode.Created));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
public bool UpdateEmployee(int id, EmployeeMo ObjEmp)
{
try
{
using (SqlConnection conn = new SqlConnection(ConString))
{
string Query = "update Employee set FirstName = '" + ObjEmp.FirstName + "',LastName = '" + ObjEmp.LastName + "',Age = '" + ObjEmp.Age + "',Gender = '" + ObjEmp.Gender + "',JoinedDate = '" + ObjEmp.JoinedDate + "' where ID = " + id;
using (SqlCommand cmd = new SqlCommand(Query, conn))
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool SaveEmployee(EmployeeMo ObjEmp)
{
try
{
using (SqlConnection conn = new SqlConnection(ConString))
{
string Query = "insert into Employee(FirstName,LastName,Age,Gender,JoinedDate) values('" + ObjEmp.FirstName + "','" + ObjEmp.LastName + "','" + ObjEmp.Age + "','" + ObjEmp.Gender + "','" + ObjEmp.JoinedDate + "')";
using (SqlCommand cmd = new SqlCommand(Query, conn))
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
