public int InsertChiTietHoaDonReturnId(dynamic infoBill, int hoadonId, int IdKhachHang, bool isMaster)
{
DataObject.ChiTietHoaDon chitietHD = new DataObject.ChiTietHoaDon();
chitietHD.IDHoaDon = hoadonId;
chitietHD.IsMaster = isMaster ? 1 : 0;
chitietHD.tabIndex = ((int)infoBill.tabIndex) + 1;
if (chitietHD.IsMaster == 1)
{
chitietHD.IdKhachHang = IdKhachHang;
}
else
{
String hoten1 = infoBill.infoKH.hoTen;
String maKH1 = infoBill.infoKH.maKH;
String ngaySinh1 = infoBill.infoKH.ngaySinh;
String soDienThoai1 = infoBill.infoKH.soDienThoai;
String email1 = infoBill.infoKH.email;
String diaChi1 = infoBill.infoKH.diaChi;
String maquan1 = infoBill.infoKH.maquan;
chitietHD.IdKhachHang = returnIdKH(soDienThoai1, hoten1, email1, diaChi1, maquan1, ngaySinh1);
}
chitietHD.TrangThai = "Chưa xử lý";
int IdChiTietHoaHD = Servies.HoaDonServices.InsertChiTietHoaDonReturnId(chitietHD);
return(IdChiTietHoaHD);
}
public static int InsertChiTietHoaDonReturnId(DataObject.ChiTietHoaDon obj)
{
String Insert = "INSERT INTO HoaDon (IDHoaDon,IsMaster,IdKhachHang,TrangThai) VALUES (@IDHoaDon,@IsMaster,@IdKhachHang,@TrangThai);Select @@IDENTITY as newId";
SqlConnection conn = Common.Connection.SqlConnect();
SqlCommand cmd = new SqlCommand(Insert);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@IDHoaDon", obj.IDHoaDon);
cmd.Parameters.AddWithValue("@IsMaster", obj.IsMaster);
cmd.Parameters.AddWithValue("@IdKhachHang", obj.IdKhachHang);
cmd.Parameters.AddWithValue("@TrangThai", obj.TrangThai);
conn.Open();
object insertedID = cmd.ExecuteScalar();
cmd.Connection.Close();
conn.Close();
return(Convert.ToInt32(insertedID));
}
public static int getTachBill(String idHD, String IdCTHD, String IdPCTHD, String IdNgayHD, String ThanhTien)
{
SqlCommand cmd = null;
SqlCommand cmdUpdateHoaDon = null;
SqlCommand cmdInsertPCTHD = null;
SqlCommand cmdUpdatePCTHD = null;
int IdHDNew = -1;
SqlConnection conn = Common.Connection.SqlConnect();
String Select = "Select * from HoaDon where ID = " + idHD;
cmd = new SqlCommand(Select);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
conn.Open();
using (SqlDataReader oReader = cmd.ExecuteReader())
{
while (oReader.Read())
{
DataObject.HoaDon obj = new DataObject.HoaDon();
obj.IDKhachHang = Int32.Parse(oReader["IDKhachHang"].ToString());
obj.IDNguon = Int32.Parse(oReader["IDNguon"].ToString());
obj.TongTien = Convert.ToDecimal(ThanhTien);
obj.TongTienThuDuoc = Convert.ToDecimal("0");
obj.TongTienConNo = Convert.ToDecimal("0");
obj.ChietKhau = Convert.ToDecimal(oReader["ChietKhau"].ToString());
obj.TrangThai = oReader["TrangThai"].ToString();
if (oReader["NgayTao"].ToString() != "" && oReader["NgayTao"].ToString() != null)
{
String createDate = String.Format("{0:dd/MM/yyyy}", DateTime.Now.ToShortDateString());
obj.NgayTao = DateTime.Parse(createDate);
}
obj.NguoiTao = oReader["NguoiTao"].ToString();
obj.TongSoNgay = Int32.Parse(oReader["TongSoNgay"].ToString());
Decimal TongTienHD = Convert.ToDecimal(oReader["TongTien"].ToString()) - Convert.ToDecimal(ThanhTien);
IdHDNew = InsertDataReturnId(obj);
conn.Close();
//Update Lai Tien HD
String updateHoaDon = "Update HoaDon set TongTien = @TongTien where ID =@ID";
cmdUpdateHoaDon = new SqlCommand(updateHoaDon);
cmdUpdateHoaDon.CommandType = CommandType.Text;
cmdUpdateHoaDon.Connection = conn;
cmdUpdateHoaDon.Parameters.AddWithValue("@TongTien", TongTienHD);
cmdUpdateHoaDon.Parameters.AddWithValue("@ID", Convert.ToInt32(idHD));
conn.Open();
cmdUpdateHoaDon.ExecuteNonQuery();
conn.Close();
break;
}
}
String SelectChiTietHoaDon = "Select * from ChiTietHoaDon where ID = " + IdCTHD;
cmdInsertPCTHD = new SqlCommand(SelectChiTietHoaDon);
cmdInsertPCTHD.CommandType = CommandType.Text;
cmdInsertPCTHD.Connection = conn;
conn.Open();
int IdPCTHDNew = -1;
using (SqlDataReader oReader = cmdInsertPCTHD.ExecuteReader())
{
while (oReader.Read())
{
DataObject.ChiTietHoaDon obj = new DataObject.ChiTietHoaDon();
obj.IDHoaDon = IdHDNew;
obj.IdKhachHang = Int32.Parse(oReader["IdKhachHang"].ToString());
obj.IsMaster = 1;
obj.tabIndex = 1;
obj.TrangThai = oReader["TrangThai"].ToString();
IdPCTHDNew = InsertChiTietHoaDonReturnId(obj);
conn.Close();
String updatePCTHD = "Update PackageChiTietHoaDon set IDChiTietHD = " + IdPCTHDNew + " where ID = " + IdPCTHD;
cmdUpdatePCTHD = new SqlCommand(updatePCTHD);
cmdUpdatePCTHD.CommandType = CommandType.Text;
cmdUpdatePCTHD.Connection = conn;
conn.Open();
cmdUpdatePCTHD.ExecuteNonQuery();
conn.Close();
break;
}
}
return(IdHDNew);
}
