public static string UpdatePSCanLanSang(PSCanLamSang cls)
{
try
{
string query = "UPDATE current.pscls SET Iddienbien=@Iddienbien,mabn=@mabn,maba=@maba,makhoa=@makhoa,macls=@macls,dongia=@dongia WHERE ID=@ID";
NpgsqlConnection conn = new NpgsqlConnection(connectstring);
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
cmd.Parameters.Add("@ID", NpgsqlDbType.Integer).Value = cls.ID;
cmd.Parameters.Add("@Iddienbien", NpgsqlDbType.Varchar).Value = cls.Iddienbien;
cmd.Parameters.Add("@mabn", NpgsqlDbType.Varchar).Value = cls.Mabn;
cmd.Parameters.Add("@maba", NpgsqlDbType.Varchar).Value = cls.Maba;
cmd.Parameters.Add("@makhoa", NpgsqlDbType.Varchar).Value = cls.Makhoa;
cmd.Parameters.Add("@macls", NpgsqlDbType.Varchar).Value = cls.Macls;
cmd.Parameters.Add("@dongia", NpgsqlDbType.Numeric).Value = cls.Dongia;
cmd.ExecuteNonQuery();
conn.Close();
return(tb.update_successed);
}
catch (Exception e)
{
conn.Close();
Console.WriteLine("loi them pscls: " + e.Message);
return(e.Message);
}
}
public static string AddPSCanLanSangToDB(PSCanLamSang cls)
{
try
{
string query = "INSERT INTO current.pscls(Iddienbien,mabn,maba,makhoa,macls,dongia) VALUES(@Iddienbien,@mabn,@maba,@makhoa,@macls,@dongia)";
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
cmd.Parameters.Add("@Iddienbien", NpgsqlDbType.Varchar).Value = cls.Iddienbien;
cmd.Parameters.Add("@mabn", NpgsqlDbType.Varchar).Value = cls.Mabn;
cmd.Parameters.Add("@maba", NpgsqlDbType.Varchar).Value = cls.Maba;
cmd.Parameters.Add("@makhoa", NpgsqlDbType.Varchar).Value = cls.Makhoa;
cmd.Parameters.Add("@macls", NpgsqlDbType.Varchar).Value = cls.Macls;
cmd.Parameters.Add("@dongia", NpgsqlDbType.Numeric).Value = cls.Dongia;
cmd.ExecuteNonQuery();
conn.Close();
return(tb.add_successed);
}
catch (Exception e)
{
conn.Close();
Console.WriteLine("loi them pscls: " + e.Message);
return(e.Message);
}
}
public string SuaThongTin([FromBody] PSCanLamSang PSCanLamSang)
{
if (PSCanLamSang == null)
{
return("NULL");
}
return(PSCanLamSangProcessor.SuaThongTinPSCLS(PSCanLamSang));
}
public string ThemCLS([FromBody] PSCanLamSang PSCanLamSang)
{
if (PSCanLamSang == null)
{
return("NULL");
}
return(PSCanLamSangProcessor.AddPSCLS(PSCanLamSang));
}
public string HienThiCLS(int id)
{
PSCanLamSang list = new PSCanLamSang();
list = PSCanLamSangProcessor.ShowPSCLS(id);
if (list.ID == 0)
{
return(null);
}
var convertedJson = JsonConvert.SerializeObject(list);
return(convertedJson);
}
public static PSCanLamSang ShowPSCanLamSangFromDB(int id)
{
// Lấy connection
// Câu truy vấn chọn hết dữ liệu từ Database
var query = "SELECT * FROM current.pscls WHERE ID=@ID";
// Tạo List chứa dữ liệu
PSCanLamSang pscls = new PSCanLamSang();
//Tạo kết nối
NpgsqlConnection conn = new NpgsqlConnection(connectstring);
// Lấy dữ liệu
try
{
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
cmd.Parameters.Add("@ID", NpgsqlDbType.Numeric).Value = id;
NpgsqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
pscls = new PSCanLamSang(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetDouble(6));
}
conn.Close();
Console.WriteLine("Thành công");
return(pscls);
}
catch (Exception e)
{
conn.Close();
Console.WriteLine(e.Message);
return(pscls);
}
}
public static string SuaThongTinPSCLS(PSCanLamSang canlamsan)
{
return(PSCanLamSangRepository.UpdatePSCanLanSang(canlamsan));
}
public static string AddPSCLS(PSCanLamSang canlamsan)
{
return(PSCanLamSangRepository.AddPSCanLanSangToDB(canlamsan));
}
