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 UpdatePSTonKho(PSTonKho pstonkho)
{
string query = "UPDATE current.pstonkho SET dongia=@dongia,xuattam=@xuattam,tondau=@tondau,nhap=@nhap,xuat=@xuat,toncuoi=@toncuoi WHERE mahh=@mahh";
try
{
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
//cmd.Parameters.Add("@ID", NpgsqlDbType.Integer).Value = pstonkho.ID;
cmd.Parameters.Add("@mahh", NpgsqlDbType.Varchar).Value = pstonkho.Mahh;
cmd.Parameters.Add("@dongia", NpgsqlDbType.Numeric).Value = pstonkho.Dongia;
cmd.Parameters.Add("@xuattam", NpgsqlDbType.Numeric).Value = pstonkho.Xuattam;
cmd.Parameters.Add("@tondau", NpgsqlDbType.Numeric).Value = pstonkho.Tondau;
cmd.Parameters.Add("@nhap", NpgsqlDbType.Numeric).Value = pstonkho.Nhap;
cmd.Parameters.Add("@xuat", NpgsqlDbType.Numeric).Value = pstonkho.Xuat;
cmd.Parameters.Add("@toncuoi", NpgsqlDbType.Numeric).Value = pstonkho.Toncuoi;
cmd.ExecuteNonQuery();
conn.Close();
return(tb.update_successed);
}
catch (Exception e)
{
conn.Close();
return(e.Message);
}
}
public static string AddPSTonKho(PSTonKho pstonkho)
{
string query = "INSERT INTO current.pstonkho(mahh,dongia,xuattam,tondau,nhap,xuat,toncuoi) VALUES(@mahh,@dongia,@xuattam,@tondau,@nhap,@xuat,@toncuoi)";
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
try
{
conn.Open();
cmd.Parameters.Add("@mahh", NpgsqlDbType.Varchar).Value = pstonkho.Mahh;
cmd.Parameters.Add("@dongia", NpgsqlDbType.Numeric).Value = pstonkho.Dongia;
cmd.Parameters.Add("@xuattam", NpgsqlDbType.Numeric).Value = pstonkho.Xuattam;
cmd.Parameters.Add("@tondau", NpgsqlDbType.Numeric).Value = pstonkho.Tondau;
cmd.Parameters.Add("@nhap", NpgsqlDbType.Numeric).Value = pstonkho.Nhap;
cmd.Parameters.Add("@xuat", NpgsqlDbType.Numeric).Value = pstonkho.Xuat;
cmd.Parameters.Add("@toncuoi", NpgsqlDbType.Numeric).Value = pstonkho.Toncuoi;
cmd.ExecuteNonQuery();
conn.Close();
return(tb.add_successed);
}
catch (Exception e)
{
conn.Close();
return(e.Message);
}
}
public string ThemPSTonKho([FromBody] PSTonKho psTonKho)
{
if (psTonKho == null)
{
return("NULL");
}
return(PSTonKhoProcessor.ThemPSTonKho(psTonKho));
}
public string ThongTinPSTonKho(string id)
{
PSTonKho pstk = PSTonKhoProcessor.ThongTinPSTonKho(id);
if (pstk.Mahh == null)
{
return("NULL");
}
return(JsonConvert.SerializeObject(pstk));
}
public static PSTonKho ShowPSTonKho(string id)
{
string query = "SELECT * FROM current.pstonkho WHERE mahh=@mahh";
PSTonKho pstonkho = new PSTonKho();
try
{
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
cmd.Parameters.Add("@mahh", NpgsqlDbType.Varchar).Value = id;
var reader = cmd.ExecuteReader();
while (reader.Read())
{
pstonkho = new PSTonKho(reader.GetString(0), reader.GetDouble(1), reader.GetInt64(2), reader.GetInt64(3), reader.GetInt64(4), reader.GetInt64(5), reader.GetInt64(6));
}
conn.Close();
}
catch (Exception e)
{
conn.Close();
Console.WriteLine(e.Message);
}
return(pstonkho);
}
public static string SuaPSTonKho(PSTonKho psTonKho)
{
return(PSTonKhoRepository.UpdatePSTonKho(psTonKho));
}
public static string ThemPSTonKho(PSTonKho psTonKho)
{
return(PSTonKhoRepository.AddPSTonKho(psTonKho));
}
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 static string LuuXuatTam(PSTonKho pstonkho)
{
return("");
}
public string SuaPSTonKho([FromBody] PSTonKho psTonKho)
{
return(PSTonKhoProcessor.SuaPSTonKho(psTonKho));
}
