public static DTO.DonHangTamDTO SelectDonHangTamByMaDonHangTam(string strMaDonHangTam)
{
DTO.DonHangTamDTO dhtDTO = new DTO.DonHangTamDTO();
try
{
var parameters = new List <SQLiteParameter>
{
new SQLiteParameter("@MaDonHangTam", strMaDonHangTam)
};
var dt = DataAccessHelper.ExecuteQuery
(
"SELECT NgayDatHang,TenNguoiBan,LienHeNguoiBan,SDTNguoiBan,DiaDiemNhanHang," +
"TenNguoiMua,SDTNguoiMua,DiaDiemGiaoHang,TienThuHo,GhiChu" +
" FROM DONHANGTAM WHERE MaDonHangTam=@MaDonHangTam"
, parameters
);
var dr = dt.Rows[0];
dhtDTO.MaDonHangTam = dr["MaDonHangTam"].ToString();
dhtDTO.NgayDatHang = DateTime.Parse(dr["NgayDatHang"].ToString());
dhtDTO.TenNguoiBan = dr["TenNguoiBan"].ToString();
dhtDTO.LienHeNguoiBan = dr["LienHeNguoiBan"].ToString();
dhtDTO.SDTNguoiBan = dr["SDTNguoiBan"].ToString();
dhtDTO.DiaDiemGiao = dr["DiaDiemGiaoHang"].ToString();
dhtDTO.TenNguoiMua = dr["TenNguoiMua"].ToString();
dhtDTO.SDTNguoiMua = dr["SDTNguoiMua"].ToString();
dhtDTO.DiaDiemNhan = dr["DiaDiemNhanHang"].ToString();
dhtDTO.TienThuHo = double.Parse(dr["TienThuHo"].ToString());
dhtDTO.GhiChu = dr["GhiChu"].ToString();
}
catch (Exception ex)
{
throw ex;
}
return(dhtDTO);
}
public DonHangTamDTO(DonHangTamDTO donhangtam)
{
_strSDTNguoiBan = donhangtam.SDTNguoiBan;
_strMaDonHangTam = donhangtam.MaDonHangTam;
_dtNgayDatHang = donhangtam._dtNgayDatHang;
_strTenNguoiBan = donhangtam._strTenNguoiBan;
_strLienHeNguoiBan = donhangtam._strLienHeNguoiBan;
_strDiaDiemNhanHang = donhangtam._strDiaDiemNhanHang;
_strTenNguoiMua = donhangtam._strTenNguoiMua;
_strSDTNguoiMua = donhangtam._strSDTNguoiMua;
_strDiaDiemGiaoHang = donhangtam._strDiaDiemGiaoHang;
_doubleTienThuHo = donhangtam._doubleTienThuHo;
_strGhiChu = donhangtam._strGhiChu;
}
public static bool SuaDonHangTam(DTO.DonHangTamDTO dhtDTO)
{
bool result = false;
try
{
var parameters = new List <SQLiteParameter>
{
new SQLiteParameter("@MaDonHangTam", dhtDTO.MaDonHangTam),
new SQLiteParameter("@NgayDatHang", dhtDTO.NgayDatHang.Date),
new SQLiteParameter("@TenNguoiBan", dhtDTO.TenNguoiBan),
new SQLiteParameter("@LienHeNguoiBan", dhtDTO.LienHeNguoiBan),
new SQLiteParameter("@SDTNguoiBan", dhtDTO.SDTNguoiBan),
new SQLiteParameter("@DiaDiemNhanHang", dhtDTO.DiaDiemNhan),
new SQLiteParameter("@TenNguoiMua", dhtDTO.TenNguoiMua),
new SQLiteParameter("@SDTNguoiMua", dhtDTO.SDTNguoiMua),
new SQLiteParameter("@DiaDiemGiaoHang", dhtDTO.DiaDiemGiao),
new SQLiteParameter("@TienThuHo", dhtDTO.TienThuHo),
new SQLiteParameter("@GhiChu", dhtDTO.GhiChu),
};
var n = DataAccessHelper.ExecuteNonQuery(
"UPDATE DONHANGTAM SET " +
"NgayDatHang=@NgayDatHang," +
"TenNguoiBan=@TenNguoiBan," +
"LienHeNguoiBan=@LienHeNguoiBan," +
"SDTNguoiBan=@SDTNguoiBan" +
"DiaDiemNhanHang=@DiaDiemNhanHang," +
"TenNguoiMua=@TenNguoiMua," +
"SDTNguoiMua=@SDTNguoiMua," +
"DiaDiemGiaoHang=@DiaDiemGiaoHang," +
"TienThuHo=@TienThuHo," +
"GhiChu=@GhiChu " +
"WHERE MaDonHangTam=@MaDonHangTam",
parameters
);
if (n == 1)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool ThemDonHangTam(DTO.DonHangTamDTO dhtDTO)
{
var result = false;
try
{
var parameters = new List <SQLiteParameter>
{
new SQLiteParameter("@MaDonHangTam", dhtDTO.MaDonHangTam),
new SQLiteParameter("@NgayDatHang", dhtDTO.NgayDatHang.Date),
new SQLiteParameter("@TenNguoiBan", dhtDTO.TenNguoiBan),
new SQLiteParameter("@LienHeNguoiBan", dhtDTO.LienHeNguoiBan),
new SQLiteParameter("@SDTNguoiBan", dhtDTO.SDTNguoiBan),
new SQLiteParameter("@DiaDiemNhanHang", dhtDTO.DiaDiemNhan),
new SQLiteParameter("@TenNguoiMua", dhtDTO.TenNguoiMua),
new SQLiteParameter("@SDTNguoiMua", dhtDTO.SDTNguoiMua),
new SQLiteParameter("@DiaDiemGiaoHang", dhtDTO.DiaDiemGiao),
new SQLiteParameter("@TienThuHo", dhtDTO.TienThuHo),
new SQLiteParameter("@GhiChu", dhtDTO.GhiChu),
};
var n = DataAccessHelper.ExecuteNonQuery
(
"INSERT INTO DONHANGTAM VALUES(@MaDonHangTam,@NgayDatHang,@TenNguoiBan,@LienHeNguoiBan,@SDTNguoiBan,@DiaDiemNhanHang, @TenNguoiMua,@SDTNguoiMua,@DiaDiemGiaoHang,@TienThuHo,@GhiChu)",
parameters
);
if (n == 1)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
