public static string AddBNNoiTru(BNNoiTru bnnoitru)
{
string query = "INSERT INTO current.bnnoitru(mabn,maba,makhoa,maicd,tenicd,maicdp,tenicdp) VALUES(@mabn,@maba,@makhoa,@maicd,@tenicd,@maicdp,@tenicdp)";
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
try
{
conn.Open();
cmd.Parameters.Add("@mabn", NpgsqlDbType.Varchar).Value = bnnoitru.Mabn;
cmd.Parameters.Add("@maba", NpgsqlDbType.Varchar).Value = bnnoitru.Maba;
cmd.Parameters.Add("@makhoa", NpgsqlDbType.Varchar).Value = bnnoitru.Makhoa;
cmd.Parameters.Add("@maicd", NpgsqlDbType.Varchar).Value = bnnoitru.Maicd;
cmd.Parameters.Add("@tenicd", NpgsqlDbType.Varchar).Value = bnnoitru.Tenicdp;
cmd.Parameters.Add("@maicdp", NpgsqlDbType.Varchar).Value = bnnoitru.Maicdp;
cmd.Parameters.Add("@tenicdp", NpgsqlDbType.Varchar).Value = bnnoitru.Tenicdp;
cmd.ExecuteNonQuery();
conn.Close();
return(tb.add_successed);
}
catch (Exception e)
{
conn.Close();
return(e.Message);
}
}
public static string UpdateBNNoiTru(BNNoiTru bnnoitru)
{
string query = "UPDATE current.bnnoitru SET mabn=@mabn,maba=@maba,makhoa=@makhoa,maicd=@maicd,tenicd=@tenicd,maicdp=@maicdp,tenicdp=@tenicdp WHERE ID=@ID";
try
{
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
cmd.Parameters.Add("@ID", NpgsqlDbType.Integer).Value = bnnoitru.ID;
cmd.Parameters.Add("@mabn", NpgsqlDbType.Varchar).Value = bnnoitru.Mabn;
cmd.Parameters.Add("@maba", NpgsqlDbType.Varchar).Value = bnnoitru.Maba;
cmd.Parameters.Add("@makhoa", NpgsqlDbType.Varchar).Value = bnnoitru.Makhoa;
cmd.Parameters.Add("@maicd", NpgsqlDbType.Varchar).Value = bnnoitru.Maicd;
cmd.Parameters.Add("@tenicd", NpgsqlDbType.Varchar).Value = bnnoitru.Tenicdp;
cmd.Parameters.Add("@maicdp", NpgsqlDbType.Varchar).Value = bnnoitru.Maicdp;
cmd.Parameters.Add("@tenicdp", NpgsqlDbType.Varchar).Value = bnnoitru.Tenicdp;
cmd.ExecuteNonQuery();
conn.Close();
return(tb.update_successed);
}
catch (Exception e)
{
conn.Close();
return(e.Message);
}
}
public string ThongTinBNNoiTru(int id)
{
BNNoiTru bn = BNNoiTruProcessor.ThongTinBNNoiTru(id);
if (bn.Mabn == null)
{
return("NULL");
}
return(JsonConvert.SerializeObject(bn));
}
public string ThemBNNoiTru([FromBody] BNNoiTru BNNoiTru)
{
if (BNNoiTru.Mabn == "")
{
return("Chưa nhập mã bệnh nhân");
}
if (BNNoiTru.Maba == "")
{
return("Chua nhập mã bệnh án");
}
if (BNNoiTru.Makhoa == "")
{
return("Chưa nhập mã khoa");
}
return(BNNoiTruProcessor.ThemBNNoiTru(BNNoiTru));
}
public static BNNoiTru ShowBNNoiTru(int id)
{
BNNoiTru bnnoitru = new BNNoiTru();
string query = "SELECT * FROM current.bnnoitru WHERE ID=@ID";
try
{
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
cmd.Parameters.Add("@ID", NpgsqlDbType.Integer).Value = id;
var reader = cmd.ExecuteReader();
while (reader.Read())
{
bnnoitru = new BNNoiTru(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7));
}
conn.Close();
}
catch (Exception e)
{
conn.Close();
Console.WriteLine(e.Message);
}
return(bnnoitru);
}
public static string SuaBNNoiTru(BNNoiTru bnnoitru)
{
return(BNNoiTruRepository.UpdateBNNoiTru(bnnoitru));
}
public static string ThemBNNoiTru(BNNoiTru bnnoitru)
{
return(BNNoiTruRepository.AddBNNoiTru(bnnoitru));
}
public string SuaBNNoiTru([FromBody] BNNoiTru BNNoiTru)
{
return(BNNoiTruProcessor.SuaBNNoiTru(BNNoiTru));
}
