public bool SaveStaffApproval(SaveStaffApprovalDTO obj) { bool res = false; SqlCommand cmd = new SqlCommand("sp_SaveStaffApproval"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@p_EventId", obj.StudentId); cmd.Parameters.AddWithValue("@p_StudentId", obj.StudentId); cmd.Parameters.AddWithValue("@p_Name", obj.Name); cmd.Parameters.AddWithValue("@p_CollegeName", obj.CollegeName); cmd.Parameters.AddWithValue("@p_Department", obj.Department); cmd.Parameters.AddWithValue("@p_Class", obj.Class); cmd.Parameters.AddWithValue("@p_Section", obj.Section); cmd.Parameters.AddWithValue("@p_EventType", obj.EventType); //cmd.Parameters.AddWithValue("@p_Purpose", obj.Purpose); cmd.Parameters.AddWithValue("@p_Date", obj.Date); cmd.Parameters.AddWithValue("@p_FromTime", obj.FromTime); cmd.Parameters.AddWithValue("@p_ToTime", obj.ToTime); cmd.Parameters.AddWithValue("@p_ApprovedStaff", obj.ApprovedStaff); int result = new DBlayer().ExecuteNonQuery(cmd); if (result != Int32.MaxValue) { res = true; } return(res); }
public HttpResponseMessage SaveStaffApproval(SaveStaffApprovalDTO obj) { HttpResponseMessage message; try { StaffApprovalDAL dal = new StaffApprovalDAL(); var dynobj = new { result = dal.SaveStaffApproval(obj) }; message = Request.CreateResponse(HttpStatusCode.OK, dynobj); } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "something Wrong.Try Again!" }); } return(message); }