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; }