public static string UpdatePSChiTietThuoc(PSChiTietThuoc pschitietthuoc)
{
string query = "UPDATE current.pschitietthuoc SET Idpsthuoc=@Idpsthuoc,Iddienbien=@Iddienbien,mabn=@mabn,maba=@maba,makhoa=@makhoa,mahh=@mahh,dongia=@dongia,soluong=@soluong,thanhtien=@thanhtien WHERE ID=@ID";
try
{
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
cmd.Parameters.Add("@ID", NpgsqlDbType.Integer).Value = pschitietthuoc.ID;
cmd.Parameters.Add("@Idpsthuoc", NpgsqlDbType.Varchar).Value = pschitietthuoc.Idpsthuoc;
cmd.Parameters.Add("@Iddienbien", NpgsqlDbType.Varchar).Value = pschitietthuoc.Iddienbien;
cmd.Parameters.Add("@mabn", NpgsqlDbType.Varchar).Value = pschitietthuoc.Mabn;
cmd.Parameters.Add("@maba", NpgsqlDbType.Varchar).Value = pschitietthuoc.Maba;
cmd.Parameters.Add("@makhoa", NpgsqlDbType.Varchar).Value = pschitietthuoc.Makhoa;
cmd.Parameters.Add("@mahh", NpgsqlDbType.Varchar).Value = pschitietthuoc.Mahh;
cmd.Parameters.Add("@dongia", NpgsqlDbType.Numeric).Value = pschitietthuoc.Dongia;
cmd.Parameters.Add("@soluong", NpgsqlDbType.Numeric).Value = pschitietthuoc.Soluong;
cmd.Parameters.Add("@thanhtien", NpgsqlDbType.Numeric).Value = pschitietthuoc.Thanhtien;
cmd.ExecuteNonQuery();
conn.Close();
return(tb.update_successed);
}
catch (Exception e)
{
conn.Close();
return(e.Message);
}
}
public static string PhatThuoc(PSChiTietThuoc pschitietthuoc)
{
// return JsonConvert.SerializeObject(pschitietthuoc);
var mathuoc = pschitietthuoc.Mahh;
var soluong = pschitietthuoc.Soluong;
try
{
PSTonKho pstonkho = PSTonKhoRepository.ShowPSTonKho(mathuoc);
var xuattam = pstonkho.Xuattam - soluong;
if (xuattam >= 0)
{
pstonkho.Xuattam = xuattam;
}
if (pstonkho.Xuattam >= pstonkho.Xuat + soluong)
{
pstonkho.Xuat = pstonkho.Xuat + soluong;
}
pstonkho.Toncuoi = pstonkho.Tondau + pstonkho.Xuattam;
PSTonKhoRepository.UpdatePSTonKho(pstonkho);
return(JsonConvert.SerializeObject(PSTonKhoRepository.ShowPSTonKho(mathuoc)));
}
catch (Exception e)
{
conn.Close();
return(e.Message);
}
}
public static string AddPSChiTietThuoc(PSChiTietThuoc pschitietthuoc)
{
string query = "INSERT INTO current.pschitietthuoc(Idpsthuoc,Iddienbien,mabn,maba,makhoa,mahh,dongia,soluong,thanhtien) VALUES(@Idpsthuoc,@Iddienbien,@mabn,@maba,@makhoa,@mahh,@dongia,@soluong,@thanhtien)";
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
try
{
var dongia = pschitietthuoc.Dongia;
var soluong = pschitietthuoc.Soluong;
conn.Open();
cmd.Parameters.Add("@Idpsthuoc", NpgsqlDbType.Varchar).Value = pschitietthuoc.Idpsthuoc;
cmd.Parameters.Add("@Iddienbien", NpgsqlDbType.Varchar).Value = pschitietthuoc.Iddienbien;
cmd.Parameters.Add("@mabn", NpgsqlDbType.Varchar).Value = pschitietthuoc.Mabn;
cmd.Parameters.Add("@maba", NpgsqlDbType.Varchar).Value = pschitietthuoc.Maba;
cmd.Parameters.Add("@makhoa", NpgsqlDbType.Varchar).Value = pschitietthuoc.Makhoa;
cmd.Parameters.Add("@mahh", NpgsqlDbType.Varchar).Value = pschitietthuoc.Mahh;
cmd.Parameters.Add("@dongia", NpgsqlDbType.Numeric).Value = pschitietthuoc.Dongia;
cmd.Parameters.Add("@soluong", NpgsqlDbType.Numeric).Value = pschitietthuoc.Soluong;
cmd.Parameters.Add("@thanhtien", NpgsqlDbType.Numeric).Value = dongia * soluong;
cmd.ExecuteNonQuery();
conn.Close();
return(tb.add_successed);
}
catch (Exception e)
{
conn.Close();
return(e.Message);
}
}
public string ThongTinPSChiTietThuoc(int id)
{
PSChiTietThuoc psctt = PSChiTietThuocProcessor.ThongTinPSChiTietThuoc(id);
if (psctt.ID == 0)
{
return("NULL");
}
return(JsonConvert.SerializeObject(psctt));
}
public static PSChiTietThuoc ShowPSChiTietThuoc(int id)
{
PSChiTietThuoc pschitietthuoc = new PSChiTietThuoc();
string query = "SELECT * FROM current.pschitietthuoc 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())
{
pschitietthuoc = new PSChiTietThuoc(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetDouble(7), reader.GetInt64(8), reader.GetDouble(9));
}
conn.Close();
}
catch (Exception e)
{
conn.Close();
Console.WriteLine(e.Message);
}
return(pschitietthuoc);
}
public string SuaPSChiTietThuoc([FromBody] PSChiTietThuoc pschitietthuoc)
{
return(PSChiTietThuocProcessor.SuaPSChiTietThuoc(pschitietthuoc));
}
public string ThemPSChiTietThuoc([FromBody] PSChiTietThuoc pschitietthuoc)
{
//return JsonConvert.SerializeObject(pschitietthuoc);
return(PSChiTietThuocProcessor.ThemPSChiTietThuoc(pschitietthuoc));
}
public string XuatTam([FromBody] PSChiTietThuoc pschitietthuoc)
{
// return JsonConvert.SerializeObject(pschitietthuoc);
return(QuanLyTonKhoRepository.XuatTam(pschitietthuoc));
}
public static string HuyXuatTam(PSChiTietThuoc pschitietthuoc)
{
// return JsonConvert.SerializeObject(pschitietthuoc);
try
{
DienBien dienbien = DienBienRepository.ShowDienBienFromDB(pschitietthuoc.Iddienbien);
//kiểm tra diễn biến có tòn tại ko
if (dienbien.Iddienbien == null)
{
return("Mã diễn biên không tôn tại");
}
if (dienbien.Mabn != pschitietthuoc.Mabn)
{
}
if (dienbien.Maba != pschitietthuoc.Maba)
{
}
if (dienbien.Makhoa != pschitietthuoc.Makhoa)
{
}
var mathuoc = pschitietthuoc.Mahh;
var dongia = pschitietthuoc.Dongia;
var soluong = pschitietthuoc.Soluong;
var thanhtien = pschitietthuoc.Thanhtien;
//kiem tra ma thuoc co ton tai trong pstonkho
var thuoctonkho = PSTonKhoRepository.ShowPSTonKho(mathuoc); // lấy thông tin từ bảng pstonkho
if (thuoctonkho.Mahh == null)
{
return("Mã thuốc không tôn tại trong tồn kho");
}
if (dongia != thuoctonkho.Dongia)
{
return("Sai đơn giá");
}
//kiem tra thanh tien
var sotien = dongia * soluong;
/* if (thanhtien != sotien)
* {
* // return sotien + "khác" + thanhtien + ": client và server tính khác nhau";
* }*/
//kiểm tra lại số thuốc trong pstonkho lần nữa
PSTonKho pstonkho = PSTonKhoRepository.ShowPSTonKho(mathuoc);
//if (pstonkho.Xuattam + soluong <= pstonkho.Tondau)
pstonkho.Xuattam -= soluong;
pstonkho.Tondau += soluong;
PSTonKhoRepository.UpdatePSTonKho(pstonkho);
return(JsonConvert.SerializeObject(PSTonKhoRepository.ShowPSTonKho(mathuoc)));
}
catch (Exception e)
{
conn.Close();
return(e.Message);
}
}
public string PhatThuoc([FromBody] PSChiTietThuoc pschitietthuoc)
{
return(QuanLyTonKhoRepository.PhatThuoc(pschitietthuoc));
}
public static string SuaPSChiTietThuoc(PSChiTietThuoc pschitietthuoc)
{
return(PSChiTietThuocRepository.UpdatePSChiTietThuoc(pschitietthuoc));
}
public static string ThemPSChiTietThuoc(PSChiTietThuoc pschitietthuoc)
{
return(PSChiTietThuocRepository.AddPSChiTietThuoc(pschitietthuoc));
}
