public IHttpActionResult CreateDoor(Locktable locktable) { try { using (IntegraContext integ = new IntegraContext()) { integ.Locktable.Add(locktable); integ.SaveChanges(); var mess = Request.CreateResponse(HttpStatusCode.Created, locktable); mess.Headers.Location = new Uri(Request.RequestUri + locktable.DoorId.ToString()); return(Ok(mess)); } } catch (Exception ex) { return(Content(HttpStatusCode.NotFound, ex.Message)); } }
public IHttpActionResult Put(int id, [FromBody] Locktable locktable) { try { using (IntegraContext integ = new IntegraContext()) { var resp = integ.Locktable.FirstOrDefault(e => e.DoorId == id); if (resp == null) { return(Content(HttpStatusCode.NotFound, "Door with ID " + id.ToString() + " not found to update")); } else { resp._LockNumber = locktable._LockNumber; resp.LOCKID = locktable.LOCKID; resp.ROOMNAME = locktable.ROOMNAME; resp.ROOMTYPEID = locktable.ROOMTYPEID; resp.TIMETABLE = locktable.TIMETABLE; resp.AUTOCHANGETABLE = locktable.AUTOCHANGETABLE; resp.AP_ID = locktable.AP_ID; resp.CalendarID = locktable.CalendarID; resp.DsdCalendarID = locktable.DsdCalendarID; resp.HARDWAREID = locktable.HARDWAREID; resp.ISACTIVE = locktable.ISACTIVE; resp._CreationDate = locktable._CreationDate; resp._UpdatedDate = locktable._UpdatedDate; resp._ApConfig = locktable._ApConfig; resp._ApChannel = locktable._ApChannel; resp._UserDefApAddr = locktable._UserDefApAddr; resp._TimeUnit = locktable._TimeUnit; resp._ContactTime = locktable._ContactTime; resp._OnlineStatus = locktable._OnlineStatus; resp._BatteryStatus = locktable._BatteryStatus; resp._DoorAlarm = locktable._DoorAlarm; resp._DoorState = locktable._DoorState; resp._FwVersion = locktable._FwVersion; resp._SignalStrenght = locktable._SignalStrenght; resp.SEQUENCENUMBER = locktable.SEQUENCENUMBER; resp.Office = locktable.Office; resp.Author_Req = locktable.Author_Req; resp.Status = locktable.Status; resp.Commonpin = locktable.Commonpin; resp.Block = locktable.Block; resp.Cancel = locktable.Cancel; resp.Prog = locktable.Prog; resp.Position = locktable.Position; resp.Author_Def = locktable.Author_Def; resp.Author_Op = locktable.Author_Op; resp.Copycounter = locktable.Copycounter; resp.Oneshotcounter = locktable.Oneshotcounter; resp.Timezone = locktable.Timezone; resp.Officeenabled = locktable.Officeenabled; resp.Officeopt = locktable.Officeopt; resp.Adaenabled = locktable.Adaenabled; resp.Adaopt = locktable.Adaopt; resp.Overrideblocked = locktable.Overrideblocked; resp.Overrideprivacy = locktable.Overrideprivacy; resp.Author_Ch = locktable.Author_Ch; resp.Office_Ch = locktable.Office_Ch; resp.Ada_Ch = locktable.Ada_Ch; resp.Ocid = locktable.Ocid; resp.I2c = locktable.I2c; resp.Zonein = locktable.Zonein; resp.Zoneout = locktable.Zoneout; resp.Areain = locktable.Areain; resp.Areaout = locktable.Areaout; resp.Serialnumber = locktable.Serialnumber; resp.Reqlevel = locktable.Reqlevel; resp.Createdtime = locktable.Createdtime; resp.Initialdate_Ch = locktable.Initialdate_Ch; resp.Expirationdate_Ch = locktable.Expirationdate_Ch; resp.W_Onlinestatus = locktable.W_Onlinestatus; resp.W_Aprotocolconfig = locktable.W_Aprotocolconfig; resp.W_Ap_Phy_Addr = locktable.W_Ap_Phy_Addr; resp.W_Alive_Data = locktable.W_Alive_Data; resp.W_Event_Mode_Data = locktable.W_Event_Mode_Data; resp.W_Polling_Mode_Data = locktable.W_Polling_Mode_Data; resp.W_Signal_Strenght = locktable.W_Signal_Strenght; resp.W_Pending_Tasks = locktable.W_Pending_Tasks; resp.W_Last_Changes = locktable.W_Last_Changes; resp.W_Com_Type = locktable.W_Com_Type; resp.W_Displayonsecuritymonitor = locktable.W_Displayonsecuritymonitor; resp.Alarmnotificationcounter = locktable.Alarmnotificationcounter; resp.W_Phyapp_Assigned = locktable.W_Phyapp_Assigned; resp.Batterylevel = locktable.Batterylevel; resp.Batterychangedate = locktable.Batterychangedate; resp._AllowedEvt1 = locktable._AllowedEvt1; resp._AllowedEvt2 = locktable._AllowedEvt2; resp._WtimeUnit = locktable._WtimeUnit; resp._WtimeInterval = locktable._WtimeInterval; resp._WcontactTime = locktable._WcontactTime; resp._IsAchieved = locktable._IsAchieved; resp.W_Ap_Phy_Addr2 = locktable.W_Ap_Phy_Addr2; resp._Voltage = locktable._Voltage; integ.SaveChanges(); return(Content(HttpStatusCode.OK, resp)); } } } catch (Exception ex) { return(Content(HttpStatusCode.BadRequest, ex.Message)); } }
// GET api/values/5 public IHttpActionResult GenerateDoors(int id, [FromBody] DoorParam doorParam) { try { var _From = doorParam._From; var _Upto = doorParam._Upto; var step = doorParam.Step; var header = doorParam._Header; var _footer = doorParam._Footer; using (IntegraContext integ = new IntegraContext()) { for (int i = _From; i <= _Upto; i++) { //lockt.Add(new Locktable(id,)); var Loc = new Locktable { _LockNumber = id, LOCKID = 1, ROOMNAME = i.ToString(), ROOMTYPEID = 1, TIMETABLE = null, AUTOCHANGETABLE = null, AP_ID = 1, CalendarID = null, DsdCalendarID = null, HARDWAREID = 2, ISACTIVE = 1, _CreationDate = DateTime.Now, _UpdatedDate = DateTime.Now, _ApConfig = 0, _ApChannel = 0, _UserDefApAddr = 0, _TimeUnit = 0, _ContactTime = 0, _OnlineStatus = 0, _BatteryStatus = 0, _DoorAlarm = 0, _DoorState = 0, _FwVersion = null, _SignalStrenght = -129, SEQUENCENUMBER = 492074665, Office = 1, Author_Req = "1111111111111111111111111111111111111111111111111111111", Status = 0, Commonpin = "FFFFFFFF", Block = 14692355, Cancel = -1, Prog = -1, Position = 0, Author_Def = "00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", Author_Op = "00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000", Copycounter = 0, Oneshotcounter = 0, Timezone = 31, Officeenabled = 0, Officeopt = 0, Adaenabled = 0, Adaopt = 0, Overrideblocked = 0, Overrideprivacy = 0, Author_Ch = null, Office_Ch = 0, Ada_Ch = 0, Ocid = -1, I2c = -1, Zonein = -1, Zoneout = -1, Areain = 0, Areaout = 0, Serialnumber = null, Reqlevel = 1, Createdtime = null, Initialdate_Ch = null, Expirationdate_Ch = null, W_Onlinestatus = "Unknown", W_Aprotocolconfig = null, W_Ap_Phy_Addr = 0, W_Alive_Data = null, W_Event_Mode_Data = null, W_Polling_Mode_Data = null, W_Signal_Strenght = -129, W_Pending_Tasks = 0, W_Last_Changes = null, W_Com_Type = "Hybrid mode", W_Displayonsecuritymonitor = 1, Alarmnotificationcounter = 0, W_Phyapp_Assigned = 0, Batterylevel = 0, Batterychangedate = DateTime.Now, _AllowedEvt1 = 0, _AllowedEvt2 = 0, _WtimeUnit = 0, _WtimeInterval = 0, _WcontactTime = 0, _IsAchieved = 0, W_Ap_Phy_Addr2 = 0, _Voltage = 0 }; integ.Locktable.Add(Loc); integ.SaveChanges(); } } return(Content(HttpStatusCode.OK, "Saved successfully")); } catch (Exception ex) { return(Content(HttpStatusCode.NotFound, ex.Message)); } }