public IHttpActionResult PutC_Group(int id, C_Group c_Group) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != c_Group.GroupNumber) { return(BadRequest()); } db.Entry(c_Group).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!C_GroupExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetC_Group(int id) { C_Group c_Group = db.C_Group.Find(id); if (c_Group == null) { return(NotFound()); } return(Ok(c_Group)); }
public IHttpActionResult DeleteC_Group(int id) { C_Group c_Group = db.C_Group.Find(id); if (c_Group == null) { return(NotFound()); } db.C_Group.Remove(c_Group); db.SaveChanges(); return(Ok(c_Group)); }
public List <C_Group> GetGroups() { var entities = new List <C_Group>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_Group_Repository_GetGroups, null)) { while (rdr.Read()) { var entity = new C_Group(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]); entity.TypeId = SqlTypeConverter.DBNullInt32Handler(rdr["TypeID"]); entity.IP = SqlTypeConverter.DBNullStringHandler(rdr["IP"]); entity.Port = SqlTypeConverter.DBNullInt32Handler(rdr["Port"]); entity.ChangeTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ChangeTime"]); entity.LastTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastTime"]); entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]); entity.Status = SqlTypeConverter.DBNullBooleanHandler(rdr["Status"]); entities.Add(entity); } } return(entities); }
public C_Group GetGroup(string id) { SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) }; parms[0].Value = SqlTypeConverter.DBNullStringChecker(id); C_Group entity = null; using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_Group_Repository_GetGroup, parms)) { if (rdr.Read()) { entity = new C_Group(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]); entity.TypeId = SqlTypeConverter.DBNullInt32Handler(rdr["TypeID"]); entity.IP = SqlTypeConverter.DBNullStringHandler(rdr["IP"]); entity.Port = SqlTypeConverter.DBNullInt32Handler(rdr["Port"]); entity.ChangeTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ChangeTime"]); entity.LastTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastTime"]); entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]); entity.Status = SqlTypeConverter.DBNullBooleanHandler(rdr["Status"]); } } return(entity); }
public string PostC_Group(C_Group MGroup) { SqlConnection conn = DBConnection.GetConnection(); SqlCommand cmd; string query; string output; try { conn.Open(); query = "insert into _Group(GroupNumber) values (" + MGroup.GroupNumber + ")"; cmd = new SqlCommand(query, conn); //read the data for that command output = cmd.ExecuteNonQuery().ToString() + " Rows Inserted"; } catch (Exception e) { output = e.Message; } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } return(output); }
public NumTable C_Receive(C_Group C_Reception) { }
public void C_Leave(C_Group C_Leaves, int NumTable) { }
public void MR_Call(C_Group TakeClient, int NumTable) { }
public void C_Install(C_Group C_Install, int NumTable) { }