public static void Insert(Serve serve)
{
ConnectionString str = new ConnectionString();
SqlConnection conn = new SqlConnection();
str.Open(conn);
SqlCommand cmd = new SqlCommand("", conn);
cmd.CommandText = "INSERT INTO serve(name, passport, experience, cafe_idcafe";
string values = "VALUES( @_name, @_passport, @_experience, @_cafe_idcafe";
cmd.Parameters.AddWithValue("_name", serve.name);
cmd.Parameters.AddWithValue("_passport", serve.passport);
cmd.Parameters.AddWithValue("_experience", serve.experience);
cmd.Parameters.AddWithValue("_cafe_idcafe", serve.cafe.idcafe);
if (serve.education != null)
{
cmd.CommandText += ", education";
values += ", @_education";
cmd.Parameters.AddWithValue("_education", serve.education);
}
cmd.CommandText += ") " + values + ");";
//conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public static void Update(int id, Serve newServe)
{
ConnectionString str = new ConnectionString();
SqlConnection conn = new SqlConnection();
str.Open(conn);
SqlCommand cmd = new SqlCommand("", conn);
cmd.CommandText = "Update serve SET name = @_name, passport = @_passport, experience = @_experience, cafe_idcafe = @_cafe_idcafe";
cmd.Parameters.AddWithValue("_name", newServe.name);
cmd.Parameters.AddWithValue("_passport", newServe.passport);
cmd.Parameters.AddWithValue("_experience", newServe.experience);
cmd.Parameters.AddWithValue("_cafe_idcafe", newServe.cafe.idcafe);
if (newServe.education != null)
{
cmd.CommandText += ", education = @_education";
cmd.Parameters.AddWithValue("_education", newServe.education);
}
else
{
cmd.CommandText += ", education = NULL";
}
cmd.CommandText += " WHERE idserve = @id";
cmd.Parameters.AddWithValue("id", id);
//conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
private static Post Read(SqlDataReader postReader)
{
Post newOne = new Post();
newOne.idpost = postReader.GetInt32(0);
newOne.title = postReader.GetString(1);
newOne.salary = postReader.GetInt32(2);
try
{
newOne.serve = Serve.Get(postReader.GetInt32(3));
//newOne.serve_idserve = postReader.GetInt32(3);
}
catch (System.Data.SqlTypes.SqlNullValueException)
{
newOne.serve = null;
}
return(newOne);
}
private static Serve Read(SqlDataReader serReader)
{
Serve newOne = new Serve();
newOne.idserve = serReader.GetInt32(0);
newOne.name = serReader.GetString(1);
newOne.passport = serReader.GetInt32(2);
try
{
newOne.education = serReader.GetString(3);
}
catch (System.Data.SqlTypes.SqlNullValueException)
{
newOne.education = null;
}
newOne.experience = serReader.GetInt32(4);
newOne.cafe = Cafe.Get(serReader.GetInt32(5));
//newOne.cafe_idcafe = serReader.GetInt32(5);
return(newOne);
}
