Exemplo n.º 1
0
        //public bool ModifyDepartment(ModifyDepartmentDTO obj)
        //{
        //    bool res = false;
        // obj.ModifiedBy = "1002";
        //    SqlCommand cmd = new SqlCommand("sp_ModifyDepartment");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("@p_DepartmentId", obj.DepartmentId);
        //    cmd.Parameters.AddWithValue("@p_Name", obj.Name);
        //    cmd.Parameters.AddWithValue("@p_Code", obj.Code);
        //    cmd.Parameters.AddWithValue("@p_CollegeId", obj.CollegeId);
        //    cmd.Parameters.AddWithValue("@p_ActionBy", obj.ModifiedBy);
        //    int result = new DBlayer().ExecuteNonQuery(cmd);
        //    if (result != Int32.MaxValue)
        //    {
        //        res = true;
        //    }
        //    return res;
        //}

        public bool RemoveEventDetail(RemoveEventDetailsDTO obj)
        {
            bool       res = false;
            SqlCommand cmd = new SqlCommand("sp_RemoveEventDetail");

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@p_EventId", obj.EventId);
            int result = new DBlayer().ExecuteNonQuery(cmd);

            if (result != Int32.MaxValue)
            {
                res = true;
            }
            return(res);
        }
Exemplo n.º 2
0
        public HttpResponseMessage RemoveEventDetail(RemoveEventDetailsDTO obj)
        {
            HttpResponseMessage message;

            try
            {
                EventDetailsDAL dal    = new EventDetailsDAL();
                var             dynobj = new { result = dal.RemoveEventDetail(obj) };
                message = Request.CreateResponse(HttpStatusCode.OK, dynobj);
            }
            catch (Exception ex)
            {
                message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "something Wrong.Try Again!" });
            }
            return(message);
        }