public CadreDidactice GetCadru(int id)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
conn.Open();
string query = "select * from CadreDidactice where id='" + id + "'";
var com = new SqlCommand(query, conn);
SqlDataReader reader = com.ExecuteReader();
CadreDidactice cadru = null;
while (reader.Read())
{
cadru = new CadreDidactice
{
id = Int32.Parse((reader["id"]).ToString()),
Departament = string.IsNullOrEmpty((reader["Departament"].ToString())) ? 0 : Int32.Parse((reader["Departament"]).ToString()),
nume = reader["nume"].ToString(),
prenume = reader["prenume"].ToString(),
titular = Int32.Parse((reader["titular"]).ToString()),
Pozitia = string.IsNullOrEmpty((reader["Pozitia"].ToString())) ? 0 : Int32.Parse((reader["Pozitia"]).ToString())
};
}
conn.Close();
return(cadru);
}
public HttpResponseMessage Update(int id, [FromBody] CadreDidactice cadru)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
conn.Open();
string query = "update CadreDidactice set Departament=@dep, nume=@nume,prenume=@prenume,titular=@titular,Pozitia=@poz where id='" + id + "'";
var com = new SqlCommand(query, conn);
CadreDidactice cadru1 = GetCadru(id);
if (cadru1.nume == cadru.nume && cadru1.prenume == cadru.prenume && cadru1.Departament == cadru.Departament && cadru1.titular == cadru.titular && cadru1.Pozitia == cadru.Pozitia)
//if (object.Equals(cadru1,cadru))
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Nu sunt campuri de actualizat"));
}
else
{
int idDB = Get(id);
if (idDB == 0)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Persoana nu exista"));
}
else
{
com.Parameters.AddWithValue("@dep", cadru.Departament);
com.Parameters.AddWithValue("@nume", cadru.nume);
com.Parameters.AddWithValue("@prenume", cadru.prenume);
com.Parameters.AddWithValue("@titular", cadru.titular);
com.Parameters.AddWithValue("@poz", cadru.Pozitia);
com.ExecuteNonQuery();
conn.Close();
return(Request.CreateResponse(HttpStatusCode.OK, cadru));
}
}
}
public HttpResponseMessage Insert([FromBody] CadreDidactice cadru)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
conn.Open();
string query = "insert into CadreDidactice(Departament,nume,prenume,titular,Pozitia) values (@dep,@nume,@prenume,@titular,@poz)";
var com = new SqlCommand(query, conn);
com.Parameters.AddWithValue("@dep", cadru.Departament);
com.Parameters.AddWithValue("@nume", cadru.nume);
com.Parameters.AddWithValue("@prenume", cadru.prenume);
com.Parameters.AddWithValue("@titular", cadru.titular);
com.Parameters.AddWithValue("@poz", cadru.Pozitia);
com.ExecuteNonQuery();
conn.Close();
return(Request.CreateResponse(HttpStatusCode.OK, cadru));
}
