// PUT: api/Leave_Requests/5
public HttpResponseMessage Put(int id, [FromBody] Leave_Requests lrUpdated)
{
using (APIModelEntities entity = new APIModelEntities())
{
try
{
var lrOriginal = entity.Leave_Requests.FirstOrDefault(Lr => Lr.Id == id);
if (lrOriginal == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Leave record with Id " + id + " not found."));
}
lrOriginal.StartDate = lrUpdated.StartDate;
lrOriginal.EndDate = lrUpdated.EndDate;
lrOriginal.Approved = lrUpdated.Approved;
///TODO: Need to write logic to manage total granted leaves and availed leaves.
///
entity.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Leave record Updated."));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
}
// POST: api/Leave_Requests
public IHttpActionResult Post([FromBody] Leave_Requests lr)
{
try
{
using (APIModelEntities entity = new APIModelEntities())
{
entity.Leave_Requests.Add(lr);
entity.SaveChanges();
return(Created(new Uri(Request.RequestUri + lr.Id.ToString()), lr));
}
}
catch (Exception Ex)
{
return(BadRequest(Ex.Message));
}
}
// GET: api/Leave_Requests
//public IEnumerable<string> Get()
//{
// return new string[] { "value1", "value2" };
//}
// GET: api/Leave_Requests/5
public IHttpActionResult Get(int id)
{
//Method will return only one selected leave.
using (APIModelEntities entity = new APIModelEntities())
{
Leave_Requests lr = entity.Leave_Requests.FirstOrDefault(L => L.Id == id);
if (lr != null)
{
return(Ok(lr));
}
else
{
return(NotFound());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Username"] == null)
{
Response.Redirect("~/Login", true);
}
if (!Session["type"].Equals("m"))
{
Response.Redirect("~/HomePage");
}
string userId = Session["Username"].ToString();
Response.Write("Logged-in User: "******"I_WORK_CONN"].ToString();
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand cmd1 = new SqlCommand("Manager_View_Trip_Requests", conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add(new SqlParameter("m_username", Session["Username"]));
cmd1.ExecuteNonQuery();
SqlDataAdapter sda1 = new SqlDataAdapter(cmd1);
DataTable dt1 = new DataTable();
sda1.Fill(dt1);
Trip_Requests.DataSource = dt1;
Trip_Requests.DataBind();
SqlCommand cmd2 = new SqlCommand("Manager_View_Leave_Requests", conn);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.Add(new SqlParameter("m_username", Session["Username"]));
cmd2.ExecuteNonQuery();
SqlDataAdapter sda2 = new SqlDataAdapter(cmd2);
DataTable dt2 = new DataTable();
sda2.Fill(dt2);
Leave_Requests.DataSource = dt2;
Leave_Requests.DataBind();
conn.Close();
}
}
