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