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