public bool ThuChi_Insert(ThuChi_Info p_ThuChi_Info)
{
try
{
SqlParameter[] spParameter = new SqlParameter[7];
int i = 0;
spParameter[i] = new SqlParameter("@SoHoadon", SqlDbType.NVarChar);
spParameter[i].Direction = ParameterDirection.Input;
spParameter[i].Value = p_ThuChi_Info.SoHoadon;
i++;
spParameter[i] = new SqlParameter("@Create_Date", SqlDbType.DateTime);
spParameter[i].Direction = ParameterDirection.Input;
spParameter[i].Value = p_ThuChi_Info.Create_Date;
i++;
spParameter[i] = new SqlParameter("@ThuChi", SqlDbType.Int);
spParameter[i].Direction = ParameterDirection.Input;
spParameter[i].Value = p_ThuChi_Info.ThuChi;
i++;
spParameter[i] = new SqlParameter("@Price", SqlDbType.Decimal);
spParameter[i].Direction = ParameterDirection.Input;
spParameter[i].Value = p_ThuChi_Info.Price;
i++;
spParameter[i] = new SqlParameter("@DienGiai", SqlDbType.NVarChar);
spParameter[i].Direction = ParameterDirection.Input;
spParameter[i].Value = p_ThuChi_Info.DienGiai;
i++;
spParameter[i] = new SqlParameter("@Customer_Id", SqlDbType.Int);
spParameter[i].Direction = ParameterDirection.Input;
spParameter[i].Value = p_ThuChi_Info.Customer_Id;
i++;
spParameter[i] = new SqlParameter("@Supplier_Id", SqlDbType.Int);
spParameter[i].Direction = ParameterDirection.Input;
spParameter[i].Value = p_ThuChi_Info.Supplier_Id;
SqlHelper.ExecuteNonQuery(CommonData.ConnectionString, CommandType.StoredProcedure, "proc_ThuChi_Insert", spParameter);
return(true);
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
return(false);
}
}
ThuChi_Info Get_ThuChi()
{
try
{
ThuChi_Info _ThuChi_Info = new ThuChi_Info();
_ThuChi_Info.SoHoadon = txtSoHoaDon.Text;
_ThuChi_Info.Price = Convert.ToDecimal(txtTotal_Price.Text);
_ThuChi_Info.ThuChi = Convert.ToInt16(ThuChi_Type.Nhap_Hang);
_ThuChi_Info.Create_Date = DateTime.Now;
_ThuChi_Info.DienGiai = txtNote.Text;
_ThuChi_Info.Supplier_Id = Convert.ToInt16(cboSupplier.SelectedValue);
_ThuChi_Info.Customer_Id = 0;
return(_ThuChi_Info);
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
return(null);
}
}
ThuChi_Info Get_ThuChi()
{
try
{
ThuChi_Info _ThuChi_Info = new ThuChi_Info();
_ThuChi_Info.SoHoadon = txtSaleHeader.Text;
_ThuChi_Info.Price = Convert.ToDecimal(txtPayPrice.Text);
_ThuChi_Info.ThuChi = Convert.ToInt16(ThuChi_Type.Ban_Buon);
_ThuChi_Info.Create_Date = DateTime.Now;
_ThuChi_Info.DienGiai = txtNote.Text;
_ThuChi_Info.Supplier_Id = 0;
_ThuChi_Info.Customer_Id = 0; // ID khách hàng
return(_ThuChi_Info);
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
return(null);
}
}
void Accept()
{
try
{
if (!CheckValidate())
{
return;
}
MessageBoxResult result = NoteBox.Show("Bạn có muốn tạo hóa đơn này hay không?", "Thông báo", NoteBoxLevel.Question);
if (result != MessageBoxResult.Yes)
{
return;
}
// insert vao bảng sale header
Sale_Header_Controller _Sale_Header_Controller = new Sale_Header_Controller();
List <Sale_Detail_Info> _Sale_Detail_Info = new List <Sale_Detail_Info>();
Sale_Header_Info _Sale_Header_Info = Get_Sale_Header(ref _Sale_Detail_Info);
if (_Sale_Header_Info == null)
{
NoteBox.Show("Lỗi rồi Nắng ơi", "", NoteBoxLevel.Error);
return;
}
decimal _id = 0;
if (_Sale_Header_Controller.Sale_Header_Insert(_Sale_Header_Info, ref _id))
{
#region insert vào bảng thu chi
ThuChi_Controller _ThuChi_Controller = new ThuChi_Controller();
ThuChi_Info _ThuChi_Info = Get_ThuChi();
_ThuChi_Info.Customer_Id = _Sale_Header_Info.Customer_Id;
if (_ThuChi_Info == null)
{
NoteBox.Show("Lỗi rồi Nắng ơi", "", NoteBoxLevel.Error);
_Sale_Header_Controller.Sale_Header_Delete(_id);
return;
}
if (!_ThuChi_Controller.ThuChi_Insert(_ThuChi_Info))
{
NoteBox.Show("Lỗi rồi Nắng ơi", "", NoteBoxLevel.Error);
_Sale_Header_Controller.Sale_Header_Delete(_id);
return;
}
#endregion
foreach (Sale_Detail_Info item in _Sale_Detail_Info)
{
_Sale_Header_Controller.Sale_Detail_Insert(item, _id);
_ThuChi_Controller.Update_Product_Sale_Count(item.Product_Id, item.Count, item.Color_Id);
}
Export();
NoteBox.Show("Tạo hóa đơn thành công");
this.Close();
}
else
{
NoteBox.Show("Lỗi rồi", "", NoteBoxLevel.Error);
return;
}
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
}
}
void Accept()
{
try
{
if (!CheckValidate_F())
{
return;
}
#region Insert vào bảng Items trước, trả ra mã ID vừa nhập
Product_Info _Product_Info = Get_ItemInfo_FromControl();
if (ckb_Is_XuatDu.IsChecked == true)
{
_Product_Info.Is_XuatDu = 1;
}
else
{
_Product_Info.Is_XuatDu = 0;
}
Product_Controller _Product_Controller = new Product_Controller();
ThuChi_Controller _ThuChi_Controller = new ThuChi_Controller();
if (!_Product_Controller.Product_Insert(_Product_Info, ref c_id_insert))
{
NoteBox.Show("Lỗi rồi Nắng ơi", "", NoteBoxLevel.Error);
return;
}
else
{
#region insert vào bảng thu chi
ThuChi_Info _ThuChi_Info = Get_ThuChi();
if (_ThuChi_Info == null)
{
NoteBox.Show("Lỗi rồi Nắng ơi", "", NoteBoxLevel.Error);
_Product_Controller.Product_Delete(c_id_insert);
return;
}
if (!_ThuChi_Controller.ThuChi_Insert(_ThuChi_Info))
{
NoteBox.Show("Lỗi rồi Nắng ơi", "", NoteBoxLevel.Error);
_Product_Controller.Product_Delete(c_id_insert);
return;
}
#endregion
foreach (Product_Detail_Info item in c_lst_Products_Detail)
{
item.Product_Id = c_id_insert;
if (!_Product_Controller.Product_Detail_Insert(item))
{
NoteBox.Show("Lỗi rồi", "", NoteBoxLevel.Error);
_Product_Controller.Product_Detail_Delete(c_id_insert);
_Product_Controller.Product_Delete(c_id_insert);
return;
}
}
NoteBox.Show("Thêm mới thành công");
this.c_ok = 1;
this.Close();
}
#endregion
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
}
}
