public int KhoiTao_DonHang()
{
int id = 0;
using (var db = _connection.GetConnection())
{
id = db.ExecuteScalar <int>("INSERT INTO info.ThongTinKhachHang(IsInit) OUTPUT INSERTED.Id VALUES(@isInit)", new
{
isInit = false
});
}
return(id);
}
private void LapDat(DTO.LapDat lapDat)
{
Call(lapDat);
using (var db = _connection.GetConnection())
{
db.Execute("INSERT INTO setting.LapDat(ThongTinKhachHangId,SoDienThoai,TenKhachHang,DiaChiGiaoHang,NgayLapDat) VALUES(@ThongTinKhachHangId,@SoDienThoai,@TenKhachHang,@DiaChiGiaoHang,@NgayLapDat);", new
{
lapDat.ThongTinKhachHangId,
lapDat.SoDienThoai,
lapDat.TenKhachHang,
lapDat.DiaChiGiaoHang,
NgayLapDat = DateTime.Now
});
}
//producer publish message
_producer.Publish(new Message_Customer
{
Id = lapDat.ThongTinKhachHangId,
CustomerAddress = lapDat.DiaChiGiaoHang,
CustomerName = lapDat.TenKhachHang,
PhoneNumber = lapDat.SoDienThoai,
Status = Status.Da_Lap_Dat
});
}
private void GiaoHang(DTO.GiaoHang giaoHang)
{
Call(giaoHang);
using (var db = _connection.GetConnection())
{
db.Execute("INSERT INTO shipping.GiaoHang(ThongTinKhachHangId,SoDienThoai,TenKhachHang,DiaChiGiaoHang,NgayGiao) VALUES(@ThongTinKhachHangId,@SoDienThoai,@TenKhachHang,@DiaChiGiaoHang,@NgayGiao);", new
{
giaoHang.ThongTinKhachHangId,
giaoHang.SoDienThoai,
giaoHang.TenKhachHang,
giaoHang.DiaChiGiaoHang,
giaoHang.NgayGiao
});
}
// producer publish message
_producer.Publish(new Message_Customer
{
Id = giaoHang.ThongTinKhachHangId,
CustomerAddress = giaoHang.DiaChiGiaoHang,
CustomerName = giaoHang.TenKhachHang,
PhoneNumber = giaoHang.SoDienThoai,
Status = Status.Da_Giao_Hang
});
}
private void ChamSoc(DTO.ChamSocKhachHang chamSocKhachHang)
{
Call(chamSocKhachHang);
using (var db = _connection.GetConnection())
{
db.Execute("INSERT INTO cs.ChamSocKhachHang(ThongTinKhachHangId,SoDienThoai,TenKhachHang,DiaChi,NgayChamSoc) VALUES(@ThongTinKhachHangId,@SoDienThoai,@TenKhachHang,@DiaChi,@NgayChamSoc);", new
{
chamSocKhachHang.ThongTinKhachHangId,
chamSocKhachHang.SoDienThoai,
chamSocKhachHang.TenKhachHang,
chamSocKhachHang.DiaChi,
chamSocKhachHang.NgayChamSoc
});
}
//producer publish message
_producer.Publish(new Message_Customer
{
Id = chamSocKhachHang.ThongTinKhachHangId,
CustomerAddress = chamSocKhachHang.DiaChi,
CustomerName = chamSocKhachHang.TenKhachHang,
PhoneNumber = chamSocKhachHang.SoDienThoai,
Status = Status.Da_CSKH
});
}
private void CapNhat_TrangThai(int id, string trangthai)
{
using (var db = _connection.GetConnection())
{
//db.Get()
db.Execute("UPDATE info.ThongTinKhachHang SET TrangThai=@TrangThai WHERE Id=@Id;", new
{
TrangThai = trangthai,
Id = id
});
}
}
