public List <DEBT> DEBT_Search(DEBT obj)
{
DataTable dt = new DataTable();
try
{
DataProvider.FillDataTable(DataProvider.ConnectionString, dt, "DEBT_Search",
obj.RefDate,
obj.RefOrgNo,
obj.RefType,
obj.RefStatus,
obj.PaymentMethod,
obj.ProductName,
obj.ExchangeRate,
obj.DueDate,
obj.Quantity,
obj.ReQuantity,
obj.Price,
obj.Amount,
obj.Payment,
obj.Balance,
obj.FAmount,
obj.IsChanged,
obj.Description
);
return(MapDEBT(dt));
}
catch (Exception ex)
{
throw ex;
}
}
public int DEBT_Update(DEBT obj, string ID)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "DEBT_Update",
new Guid(ID),
obj.RefID,
obj.RefDate,
obj.RefOrgNo,
obj.RefType,
obj.RefStatus,
obj.PaymentMethod,
obj.CustomerID,
obj.ProductID,
obj.ProductName,
obj.CurrencyID,
obj.ExchangeRate,
obj.TermID,
obj.DueDate,
obj.Quantity,
obj.ReQuantity,
obj.Price,
obj.Amount,
obj.Payment,
obj.Balance,
obj.FAmount,
obj.IsChanged,
obj.Description,
obj.Sorted,
obj.Active
));
}
catch
{
//throw ex;
return(-1);
}
}
public int DEBT_Insert(DEBT obj)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "DEBT_Insert",
obj.ID,
obj.RefID,
obj.RefDate,
obj.RefOrgNo,
obj.RefType,
obj.RefStatus,
obj.PaymentMethod,
obj.CustomerID,
obj.ProductID,
obj.ProductName,
obj.CurrencyID,
obj.ExchangeRate,
obj.TermID,
obj.DueDate,
obj.Quantity,
obj.ReQuantity,
obj.Price,
obj.Amount,
obj.Payment,
obj.Balance,
obj.FAmount,
obj.IsChanged,
obj.Description,
obj.Sorted,
obj.Active
));
}
catch (Exception ex)
{
throw ex;
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
int rs_provider, rs_provider_detail;
////
if (double.Parse(calcTienTra.Text.Trim()) > double.Parse(calcConNo.Text.Trim()))
{
calcTienTra.Text = calcConNo.Text;
}
_provider_payment.ID = Guid.NewGuid();
_provider_payment.RefID = txtSoPhieu.Text.Trim();
_provider_payment.RefDate = DateTime.Now;
_provider_payment.RefType = 42;
_provider_payment.RefStatus = 0;
_provider_payment.RefOrgNo = lookUpChungTu.Text;
_provider_payment.CurrencyID = "VND";
_provider_payment.PaymentMethod = new STOCK_INWARDController().STOCK_INWARD_Get(lookUpChungTu.Text).PaymentMethod;
_provider_payment.ExchangeRate = 1;
_provider_payment.CustomerID = MaKhachHang;
_provider_payment.CustomerName = lookUpTenKH.Text;
_provider_payment.Amount = double.Parse(calcTienTra.Text);
_provider_payment.CreatedBy = "admin";
_provider_payment.ModifiedBy = "admin";
_provider_payment.CreatedDate = DateTime.Now;
_provider_payment.ModifiedDate = _provider_payment.CreatedDate;
_provider_payment.OwnerID = "NV000001";
_provider_payment.Description = memoEdit1.Text.Trim();
_provider_payment.Active = true;
PROVIDER_PAYMENTController _provider_payment_controller = new PROVIDER_PAYMENTController();
/////
_provider_payment_detail.PaymentID = _provider_payment.ID;
_provider_payment_detail.ID = Guid.NewGuid();
_provider_payment_detail.RefOrgNo = Guid.NewGuid();
_provider_payment_detail.CurrencyID = _provider_payment.CurrencyID;
_provider_payment_detail.ExchangeRate = 1;
_provider_payment_detail.Quantity = 1;
_provider_payment_detail.Amount = double.Parse(calcSoTien.Text);
_provider_payment_detail.Debit = double.Parse(calcConNo.Text);
_provider_payment_detail.Payment = double.Parse(calcTienTra.Text);
_provider_payment_detail.Description = lookUpTenKH.Text;
PROVIDER_PAYMENT_DETAILController _provider_payment_detail_controller = new PROVIDER_PAYMENT_DETAILController();
//////
DEBT _debt = new DEBT();
DEBTController _debtcontroller = new DEBTController();
//DEBTController _debtcontroller1 = new DEBTController();
_debt = _debtcontroller.DEBT_GetbyRefID(lookUpChungTu.Text.Trim());
_debt.Payment = _debt.Payment + double.Parse(calcTienTra.Text.Trim());
_debt.Balance = _debt.Balance - double.Parse(calcTienTra.Text.Trim());
_debt.FAmount = _debt.Balance;
_provider_payment_detail.RefOrgNo = _debt.ID;
_provider_payment.PaymentMethod = _debt.PaymentMethod;
if (_debt.Payment == 0)
{
_debt.IsChanged = true;
}
if (txtSoPhieu.Text != "")
{
try
{
rs_provider = _provider_payment_controller.PROVIDER_PAYMENT_Insert(_provider_payment);
rs_provider_detail = _provider_payment_detail_controller.PROVIDER_PAYMENT_DETAIL_Insert(_provider_payment_detail);
//rs_debt = new DEBTController().DEBT_UpdateByRefId(_debt, _debt.RefID);
if (/*(rs_debt >= 1) && */ (rs_provider >= 1) && (rs_provider_detail >= 1))
{
stockinward.STOCK_INWARD_Update_RefStatus(lookUpChungTu.Text);
MessageBox.Show("Lưu Thành Công", "Cảnh Báo");
}
else
{
MessageBox.Show("Lưu Thất Bại", "Cảnh Báo");
}
}
catch
{
MessageBox.Show("Lưu Thất Bại", "Cảnh Báo");
}
}
else
{
MessageBox.Show("Chưa nhập số phiếu", "Cảnh Báo");
}
}
private List <DEBT> MapDEBT(DataTable dt)
{
List <DEBT> rs = new List <DEBT>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DEBT obj = new DEBT();
if (dt.Columns.Contains("ID"))
{
obj.ID = new Guid(dt.Rows[i]["ID"].ToString());
}
if (dt.Columns.Contains("RefID"))
{
obj.RefID = dt.Rows[i]["RefID"].ToString();
}
if (dt.Columns.Contains("RefDate"))
{
obj.RefDate = DateTime.Parse(dt.Rows[i]["RefDate"].ToString());
}
//if (dt.Columns.Contains("RefOrgNo"))
//obj.RefOrgNo = new Guid( dt.Rows[i]["RefOrgNo"].ToString());
if (dt.Columns.Contains("RefType"))
{
obj.RefType = int.Parse(dt.Rows[i]["RefType"].ToString());
}
if (dt.Columns.Contains("RefStatus"))
{
obj.RefStatus = int.Parse(dt.Rows[i]["RefStatus"].ToString());
}
if (dt.Columns.Contains("PaymentMethod"))
{
obj.PaymentMethod = new Guid(dt.Rows[i]["PaymentMethod"].ToString());
}
if (dt.Columns.Contains("CustomerID"))
{
obj.CustomerID = dt.Rows[i]["CustomerID"].ToString();
}
if (dt.Columns.Contains("ProductID"))
{
obj.ProductID = dt.Rows[i]["ProductID"].ToString();
}
if (dt.Columns.Contains("ProductName"))
{
obj.ProductName = dt.Rows[i]["ProductName"].ToString();
}
if (dt.Columns.Contains("CurrencyID"))
{
obj.CurrencyID = dt.Rows[i]["CurrencyID"].ToString();
}
if (dt.Columns.Contains("ExchangeRate"))
{
obj.ExchangeRate = double.Parse(dt.Rows[i]["ExchangeRate"].ToString());
}
if (dt.Columns.Contains("TermID"))
{
obj.TermID = dt.Rows[i]["TermID"].ToString();
}
if (dt.Columns.Contains("DueDate"))
{
obj.DueDate = DateTime.Parse(dt.Rows[i]["DueDate"].ToString());
}
if (dt.Columns.Contains("Quantity"))
{
obj.Quantity = double.Parse(dt.Rows[i]["Quantity"].ToString());
}
if (dt.Columns.Contains("ReQuantity"))
{
obj.ReQuantity = double.Parse(dt.Rows[i]["ReQuantity"].ToString());
}
if (dt.Columns.Contains("Price"))
{
obj.Price = double.Parse(dt.Rows[i]["Price"].ToString());
}
if (dt.Columns.Contains("Amount"))
{
obj.Amount = double.Parse(dt.Rows[i]["Amount"].ToString());
}
if (dt.Columns.Contains("Payment"))
{
obj.Payment = double.Parse(dt.Rows[i]["Payment"].ToString());
}
if (dt.Columns.Contains("Balance"))
{
obj.Balance = double.Parse(dt.Rows[i]["Balance"].ToString());
}
if (dt.Columns.Contains("FAmount"))
{
obj.FAmount = double.Parse(dt.Rows[i]["FAmount"].ToString());
}
if (dt.Columns.Contains("IsChanged"))
{
obj.IsChanged = bool.Parse(dt.Rows[i]["IsChanged"].ToString());
}
if (dt.Columns.Contains("Description"))
{
obj.Description = (dt.Rows[i]["Description"].ToString());
}
if (dt.Columns.Contains("Sorted"))
{
obj.Sorted = long.Parse(dt.Rows[i]["Sorted"].ToString());
}
if (dt.Columns.Contains("Active"))
{
obj.Active = bool.Parse(dt.Rows[i]["Active"].ToString());
}
rs.Add(obj);
}
return(rs);
}
