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)
{
}
