public HttpResponseMessage getUserActivityCodes(postmethod pm)
    {
        getUserActivityCodes ga = new getUserActivityCodes();

        try
        {
            string qry = "select * from MDM_DeviceMaster where DeviceID='" + pm.uuid + "'";
            dr = databaseHelper.getDataReader(qry);

            if (dr.Read())
            {
                if (!dr.IsClosed)
                {
                    dr.Close();
                }

                List <userCodes> uc = new List <userCodes>();
                qry    = "select ActivityCode,ActivityName,Type from MDM_ActivityCode";
                dtable = databaseHelper.getDataTable(qry);

                foreach (DataRow drow in dtable.Rows)
                {
                    uc.Add(new userCodes
                    {
                        code = drow["ActivityCode"].ToString(),
                        name = drow["ActivityName"].ToString(),
                        type = drow["Type"].ToString()
                    });
                }
                ga.userCodes = uc;
                ga.response  = true;
                HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, ga);

                /*qry = "delete from MDM_PushNotification where DeviceID='" + pm.uuid + "'";
                 * rcnt = databaseHelper.ExecuteQuery(qry);*/

                return(response);
            }
            else
            {
                ga.response  = true;
                ga.errorCode = "Authentication Failed";
                HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.BadRequest, ga);
                return(response);
            }
        }
        catch (Exception ex)
        {
            linfo.LogFile(enLogType.EXCEPTION, ex.Message, null);
        }
        finally
        {
            if (dr != null && !dr.IsClosed)
            {
                dr.Close();
            }
        }
        return(null);
    }
    public HttpResponseMessage getUserActivityCodes(postmethod pm)
    {        
        getUserActivityCodes ga = new getUserActivityCodes();
        try
        {

            string qry = "select * from MDM_DeviceMaster where DeviceID='" + pm.uuid + "'";
            dr = databaseHelper.getDataReader(qry);

            if (dr.Read())
            {
                if (!dr.IsClosed)
                    dr.Close();

                List<userCodes> uc = new List<userCodes>();
                qry = "select ActivityCode,ActivityName,Type from MDM_ActivityCode";
                dtable = databaseHelper.getDataTable(qry);

                foreach (DataRow drow in dtable.Rows)
                {
                    uc.Add(new userCodes
                    {
                        code = drow["ActivityCode"].ToString(),
                        name = drow["ActivityName"].ToString(),
                        type = drow["Type"].ToString()
                    });
                }
                ga.userCodes = uc;
                ga.response = true;
                HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, ga);

                /*qry = "delete from MDM_PushNotification where DeviceID='" + pm.uuid + "'";
                rcnt = databaseHelper.ExecuteQuery(qry);*/

                return response;
            }
            else
            {
                ga.response = true;
                ga.errorCode = "Authentication Failed";
                HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.BadRequest, ga);
                return response;
            }
        }
        catch (Exception ex)
        {
            linfo.LogFile(enLogType.EXCEPTION, ex.Message, null);            
        }
        finally
        {
            if (dr != null && !dr.IsClosed)
                dr.Close();
        }
        return null;
    }