public decimal Customer_Insert(Customer_Info p_Customer_Info)
{
try
{
return(CommonData.c_serviceWCF.Customer_Insert(p_Customer_Info.Customer_Name, p_Customer_Info.Phone, p_Customer_Info.Fax, p_Customer_Info.Identity_Card,
p_Customer_Info.Address, p_Customer_Info.Tax_Code, p_Customer_Info.Customer_Type, p_Customer_Info.Is_Person, p_Customer_Info.Position));
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
return(-1);
}
}
// GET: Customer_Info/Edit/5
public async Task <ActionResult> Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Customer_Info customer_Info = await db.Customer_Info.FindAsync(id);
if (customer_Info == null)
{
return(HttpNotFound());
}
return(View(customer_Info));
}
protected void Button1_Click(object sender, EventArgs e)
{
using (projectEntities1 context = new projectEntities1())
{
Customer_Info _insert = new Customer_Info();
_insert.Customer_Name = TextBox1.Text;
_insert.Email = TextBox2.Text;
_insert.Customer_Password = TextBox3.Text;
_insert.Phone_No = Decimal.Parse(TextBox4.Text);
context.Customer_Info.Add(_insert);
context.SaveChanges();
}
Response.Redirect("Log-In.aspx");
}
// GET: Customer_Info/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Customer_Info customer_Info = db.Customer_Info.Find(id);
if (customer_Info == null)
{
return(HttpNotFound());
}
return(View(customer_Info));
}
public decimal Customer_Insert(Customer_Info p_Customer_Info)
{
try
{
Traces_Log_Controllers _traceControler = new Traces_Log_Controllers();
_traceControler.Trace_Insert("CUSTOMER", "INSERT", p_Customer_Info.Created_By, p_Customer_Info);
return(CommonData.c_serviceWCF.Customer_Insert(p_Customer_Info.Customer_Name, p_Customer_Info.Phone, p_Customer_Info.Fax, p_Customer_Info.Identity_Card,
p_Customer_Info.Address, p_Customer_Info.Tax_Code, p_Customer_Info.Customer_Type, p_Customer_Info.Is_Person, p_Customer_Info.Position));
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
return(-1);
}
}
/// <summary>
/// Tạo khách hàng mới theo tên, địa chỉ và số CMT
/// </summary>
/// <param name="custName">Tên đầy đủ khách hàng</param>
/// <param name="custAdd">Địa chỉ khách hàng</param>
/// <param name="custCert">số CMT hoặc hộ chiếu</param>
/// <returns>=0 nếu không thành công
/// #0 nếu thành công</returns>
protected int Insert(string branch, string userlogin, string custName, string custAdd, string custCert)
{
var ci = new Customer_Info
{
ID = GenerateNewCustId(),
Name = custName,
Address = custAdd,
Cust_Cert = custCert,
Approved = true,
ApprovedTime = DateTime.Now,
UserCreate = userlogin,
Branch_ID = branch
};
return(Insert(ci));
}
public int Insert_Auth(Customer_Info custInfo)
{
SetError(0, String.Empty);
if (custInfo == null)
{
SetError(98, "Invalid data input");
return(Error_Number);
}
if (string.IsNullOrEmpty(custInfo.ID))
{
SetError(98, "Customer Id is null or empty");
return(Error_Number);
}
if (string.IsNullOrEmpty(custInfo.Name))
{
SetError(98, "Customer name is null or empty");
return(Error_Number);
}
if (string.IsNullOrEmpty(custInfo.Cust_Cert))
{
SetError(98, "Customer identity card number is null or empty");
return(Error_Number);
}
if (string.IsNullOrEmpty(custInfo.UserCreate))
{
SetError(98, "User Create is null or empty");
return(Error_Number);
}
if (custInfo.Approved == true && custInfo.ApprovedTime < custInfo.DateCreated)
{
SetError(98, "Invalid ApprovedTime");
return(Error_Number);
}
if (custInfo.DateCreated > custInfo.LastUpdate)
{
SetError(98, "Invalid DateCreated");
return(Error_Number);
}
// Kiểm tra sự tồn tại của chứng minh nhân dân.
if (base.GetCustomerByCert(custInfo.Cust_Cert) != null)
{
SetError(4, "Identity card number of duplicate");
return(Error_Number);
}
return(Error_Number);
}
public int Approved_Auth(string custId)
{
SetError(0, String.Empty);
Customer_Info custInfo = base.GetCustomerById(custId);
if (custInfo == null)
{
SetError(1, "Customer not find");
return(Error_Number);
}
if (custInfo.Approved == true)
{
SetError(5, "Customer approved");
return(Error_Number);
}
return(Error_Number);
}
public bool Customer_Update(decimal Customer_Id, Customer_Info p_Customer_Info, Customer_Info p_old)
{
try
{
Traces_Log_Controllers _traceControler = new Traces_Log_Controllers();
_traceControler.Trace_Insert("CUSTOMER", "UPDATE", p_Customer_Info.Modifi_By, p_Customer_Info, p_old);
return(CommonData.c_serviceWCF.Customer_Update(Customer_Id, p_Customer_Info.Customer_Name, p_Customer_Info.Phone, p_Customer_Info.Fax, p_Customer_Info.Identity_Card,
p_Customer_Info.Address, p_Customer_Info.Tax_Code, p_Customer_Info.Customer_Type, p_Customer_Info.Is_Person, p_Customer_Info.Position));
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
return(false);
}
}
public new int Insert(Customer_Info custInfo)
{
int result = Insert_Auth(custInfo);
if (result != 0)
{
return(result);
}
if (base.Insert(custInfo) != 0)
{
SetError(0, String.Empty);
}
else
{
SetError(99, _dalCust.GetException.Message);
}
return(Error_Number);
}
/// <summary>
/// hàm dùng cho EventsSetter trong form display
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void DoubleClick(object sender, RoutedEventArgs e)
{
try
{
Customer_Info _Customer_Info = (Customer_Info)dgrProduct.SelectedItem;
if (_Customer_Info != null)
{
c_Customer_Info_Search = _Customer_Info;
c_ok = 1;
this.Close();
}
e.Handled = true;
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
}
}
void Export_Payment()
{
try
{
c_row_select = dgrContract.SelectedIndex;
Contract_Info _Contract_Info = (Contract_Info)dgrContract.SelectedItem;
if (_Contract_Info == null)
{
return;
}
List <Fees_Revenue_Info> _lst = _Fees_Revenue_Controller.Fees_Revenue_GetByContract(_Contract_Info.Contract_Id);
Fees_Revenue_Info _Fees_Revenue_Info = new Fees_Revenue_Info();
bool _is_not_pay = false;
// kiểm tra xem đã thanh toán hết chưa
foreach (Fees_Revenue_Info item in _lst)
{
if (item.Pay_Status == (decimal)Enum_Fee_Status.No_Pay)
{
_is_not_pay = true;
_Fees_Revenue_Info = item;
break;
}
}
if (_is_not_pay == false)
{
NoteBox.Show("Đã thanh toán hết, không thể yêu cầu thanh toán", "", NoteBoxLevel.Error);
return;
}
Estate_Object_Info _Estate_Object_Info = _Estate_Object_Controller.Estate_Object_GetById(_Contract_Info.Estate_Id, (decimal)Enum_Contract_Type.Renter);
Customer_Info _Customer_Info = _Customer_Controller.Customer_GetById(_Contract_Info.Object_Id);
CommonFunction.Export_payment(_Contract_Info, _Customer_Info, _Estate_Object_Info, _Fees_Revenue_Info);
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
}
}
private void btnSearchCustomer_Click(object sender, RoutedEventArgs e)
{
try
{
frmSearch_Customer _frmSearch_Customer = new frmSearch_Customer();
_frmSearch_Customer.Owner = Window.GetWindow(this);
_frmSearch_Customer.ShowDialog();
if (_frmSearch_Customer.c_ok == 1)
{
c_Customer_Info = _frmSearch_Customer.c_Customer_Info_Search;
txtCustomer_Name.Text = c_Customer_Info.Customer_Name;
txtPhone.Text = c_Customer_Info.Phone;
txtAddress.Text = c_Customer_Info.Address;
}
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
}
}
Customer_Info Get_Customer_Info()
{
try
{
Customer_Info _Customer_Info = new Customer_Info();
_Customer_Info.Customer_Name = txtCustomer_Name.Text;
_Customer_Info.Address = txtAddress.Text;
_Customer_Info.Phone = txtPhone.Text;
_Customer_Info.Identity_Card = txtIdentity_Card.Text;
_Customer_Info.Fax = txtFax.Text;
_Customer_Info.Is_Person = Convert.ToDecimal(cboType.SelectedValue);
_Customer_Info.Tax_Code = txtTaxCode.Text;
_Customer_Info.Position = txtPosition.Text;
return(_Customer_Info);
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
return(null);
}
}
int Insert_Customer()
{
try
{
decimal _kq = 0;
Customer_Controller _Customer_Controller = new Customer_Controller();
List <Customer_Info> _lst = _Customer_Controller.Search_Customer(txtCustomer_Name.Text, txtPhone.Text);
if (_lst.Count == 0)
{
Customer_Info _Customer_Info = new Customer_Info();
_Customer_Info.Customer_Name = txtCustomer_Name.Text;
_Customer_Info.Phone = txtPhone.Text;
_Customer_Info.Address = txtAddress.Text;
if (!_Customer_Controller.Customer_Insert(_Customer_Info, ref _kq))
{
// Thêm mới
NoteBox.Show("Lỗi rồi Nắng. Thêm mới khách hàng ko thành công", "", NoteBoxLevel.Error);
return(-1);
}
else
{
return(Convert.ToInt32(_kq));
}
}
else if (_lst.Count == 1)
{
return(_lst[0].Customer_Id);
}
return(Convert.ToInt32(_kq));
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
return(-1);
}
}
Customer_Info Get_Customer_Info()
{
try
{
Customer_Info _Customer_Info = new Customer_Info();
_Customer_Info.Customer_Name = txtRenter_Name.Text;
_Customer_Info.Address = txtAddress.Text;
_Customer_Info.Phone = txtPhone.Text;
_Customer_Info.Identity_Card = txtIdentity_Card.Text;
_Customer_Info.Fax = txtFax.Text;
_Customer_Info.Customer_Type = (decimal)Enum_Contract_Type.Tenant;
_Customer_Info.Is_Person = 0;
_Customer_Info.Tax_Code = txtTaxCode.Text;
_Customer_Info.Position = txtPosition.Text;
return(_Customer_Info);
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
return(null);
}
}
void Accept()
{
try
{
if (Customer_CheckValidate() == false)
{
return;
}
MessageBoxResult result = NoteBox.Show("Bạn có muốn thêm khách hàng này hay không?", "Thông báo", NoteBoxLevel.Question);
if (MessageBoxResult.Yes != result)
{
return;
}
Customer_Info _Customer_Info = Get_Customer_Info();
if (_Customer_Info == null)
{
NoteBox.Show("Lỗi khởi tạo khách thuê nhà", "", NoteBoxLevel.Error);
return;
}
if (c_Customer_Controller.Customer_Update(c_Customer_Info.Customer_Id, _Customer_Info, c_Customer_Info) == false)
{
NoteBox.Show("Lỗi cập nhật mới khách thuê nhà", "", NoteBoxLevel.Error);
return;
}
c_id_insert = c_Customer_Info.Customer_Id;
NoteBox.Show("Sửa dữ liệu thành công", "");
this.Close();
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
}
}
void Delete_Contract()
{
try
{
c_row_select = dgrRenter.SelectedIndex;
Customer_Info _Customer_Info = (Customer_Info)dgrRenter.SelectedItem;
if (_Customer_Info == null)
{
return;
}
if (c_Customer_Controller.Customer_Check_In_Contract(_Customer_Info.Customer_Id) == false)
{
NoteBox.Show("Tồn tại khách hàng trong hợp đồng, không thể xóa", "", NoteBoxLevel.Error);
return;
}
MessageBoxResult result = NoteBox.Show("Bạn chắc chắn muốn xóa khách hàng này hay không?", "Thông báo", NoteBoxLevel.Question);
if (MessageBoxResult.Yes == result)
{
if (c_Customer_Controller.Customer_Delete(_Customer_Info.Customer_Id))
{
NoteBox.Show("Xóa dữ liệu thành công");
Search();
DBMemory.LoadFeeRender();
}
}
else
{
DataGridHelper.NVSFocus(dgrRenter, c_row_select, 0);
}
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
}
}
void Customer_Update()
{
c_row_select = dgrCustomer.SelectedIndex;
Customer_Info _Customer_Info = (Customer_Info)dgrCustomer.SelectedItem;
if (_Customer_Info == null)
{
return;
}
frmCreate_Customer _frmCreate_Customer = new frmCreate_Customer();
_frmCreate_Customer.c_type = Convert.ToInt16(Form_Type.Update);
_frmCreate_Customer.c_Customer_Info = _Customer_Info;
_frmCreate_Customer.Owner = Window.GetWindow(this);
_frmCreate_Customer.ShowDialog();
if (_frmCreate_Customer.c_id_insert != 0)
{
LoadData();
}
DataGridHelper.NVSFocus(dgrCustomer, c_row_select, 0);
}
void Insert_Customer()
{
try
{
Customer_Insert _Customer_Insert = new Customer_Insert();
_Customer_Insert.Owner = Window.GetWindow(this);
_Customer_Insert.ShowDialog();
if (_Customer_Insert.c_id_insert != 0)
{
Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;
Search();
DBMemory.LoadFeeRender();
for (int i = 0; i < c_lst.Count; i++)
{
Customer_Info ui = (Customer_Info)c_lst[i];
if (ui.Customer_Id == _Customer_Insert.c_id_insert)
{
c_row_select = i;
_Customer_Insert.c_id_insert = 0;
break;
}
}
}
Mouse.OverrideCursor = null;
DataGridHelper.NVSFocus(dgrRenter, c_row_select, 0);
}
catch (Exception ex)
{
Mouse.OverrideCursor = null;
CommonData.log.Error(ex.ToString());
}
}
void Customer_View()
{
try
{
c_row_select = dgrCustomer.SelectedIndex;
Customer_Info _Customer_Info = (Customer_Info)dgrCustomer.SelectedItem;
if (_Customer_Info == null)
{
return;
}
View_Customer_Product _View_Customer_Product = new View_Customer_Product();
_View_Customer_Product.c_Customer_Info = _Customer_Info;
_View_Customer_Product.Owner = Window.GetWindow(this);
_View_Customer_Product.ShowDialog();
DataGridHelper.NVSFocus(dgrCustomer, c_row_select, 0);
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
}
}
public static int Update(Customer_Info obj)
{
return(dal_cust.Update(obj));
}
public static int Insert(Customer_Info obj)
{
return(dal_cust.Insert(obj));
}
void Accept()
{
try
{
if (Tenat_CheckValidate() == false)
{
return;
}
MessageBoxResult result = NoteBox.Show("Bạn có muốn thêm hợp đồng này hay không?", "Thông báo", NoteBoxLevel.Question);
if (MessageBoxResult.Yes != result)
{
return;
}
#region Thêm mới khách hàng
Customer_Info _Customer_Info = Get_Customer_Info();
if (_Customer_Info == null)
{
NoteBox.Show("Lỗi khởi tạo khách cho thuê nhà", "", NoteBoxLevel.Error);
return;
}
decimal _customer_id = -1;
// kiểm tra xem thằng tên khách hàng đó và số đt đó đã có trong db chưa
// nếu có rồi thì ko insert nữa
string _name = txtRenter_Name.Text.ToUpper();
if (_name == "")
{
_name = CommonData.c_All_Value;
}
string _phone = txtPhone.Text.ToUpper();
if (_phone == "")
{
_phone = CommonData.c_All_Value;
}
List <Customer_Info> _lst = c_Customer_Controller.Customer_Search(_name, _phone);
if (_lst.Count > 0)
{
// có rồi thì sử dụng luôn
// update ngược thông tin lại
if (c_Customer_Controller.Customer_Update(_lst[0].Customer_Id, _Customer_Info) == false)
{
NoteBox.Show("Lỗi cập nhật mới khách thuê nhà", "", NoteBoxLevel.Error);
return;
}
_customer_id = _lst[0].Customer_Id;
}
else
{
// không có thì thêm mới
_customer_id = c_Customer_Controller.Customer_Insert(_Customer_Info);
if (_customer_id == -1)
{
NoteBox.Show("Lỗi thêm mới khách thuê nhà", "", NoteBoxLevel.Error);
return;
}
}
#endregion
#region Hợp đồng
Contract_Info _Contract_Info = Get_Contract_Info(_customer_id);
if (_Contract_Info == null)
{
NoteBox.Show("Lỗi khởi tạo hợp đồng thuê nhà", "", NoteBoxLevel.Error);
return;
}
decimal _contract_id = _Contract_Controller.Contract_Insert(_Contract_Info);
if (_contract_id == -1)
{
NoteBox.Show("Lỗi thêm mới hợp đồng cho thuê nhà", "", NoteBoxLevel.Error);
c_Customer_Controller.Customer_Delete(_customer_id);
return;
}
#endregion
#region Phí môi giới
foreach (Fees_Revenue_Info _Fees_Revenue_Info in c_lst_Fee)
{
_Fees_Revenue_Info.Contract_Id = _contract_id;
_Fees_Revenue_Info.Object_Id = _customer_id;
_Fees_Revenue_Info.Object_Type = (decimal)Enum_Contract_Type.Tenant;
_Fees_Revenue_Info.Currency = Convert.ToDecimal(cboCurrency.SelectedValue);
_Fees_Revenue_Info.Fee = 0;
_Fees_Revenue_Info.Debit_Amount = _Fees_Revenue_Info.Fee_Expected - _Fees_Revenue_Info.Fee;
_Fees_Revenue_Info.Is_Extend = 0;
_Fees_Revenue_Info.Fee_Vnd = 0;
if (_Fees_Revenue_Info.Fee != 0)
{
_Fees_Revenue_Info.Pay_Status = (decimal)Enum_Fee_Status.Payed;
}
if (_Fees_Revenue_Controller.Fees_Revenue_Insert(_Fees_Revenue_Info) == false)
{
NoteBox.Show("Lỗi thanh toán", "", NoteBoxLevel.Error);
c_Customer_Controller.Customer_Delete(_customer_id);
_Contract_Controller.Contract_Delete(_contract_id);
_Fees_Revenue_Controller.Fees_Revenue_DeleteByContract(_contract_id);
return;
}
}
#endregion
c_id_insert = _contract_id;
NoteBox.Show("Thêm mới dữ liệu thành công", "");
this.Close();
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
}
}
/// <summary>
/// Mở tài khoản theo Categories và mã khách hàng
/// </summary>
/// <param name="categories">Mã sản phẩm</param>
/// <param name="custId">Mã khách hàng</param>
/// <returns>chuỗi ký tự thông tin tài khoản chi tiết được mở theo định dạng
/// xml hoặc chuối ký tự lỗi định dạng xml</returns>
public xml_response Insert(string categories, string custId)
{
try
{
_res = new xml_response();
_res.function_name = this.ToString() + string.Format(".Insert({0},{1})", categories, custId);
Customer bcust = new Customer();
Customer_Info custInfo = bcust.GetCustomerByID(custId);
if (custInfo == null)
{
_res.SetError("01", "Customer can not find");
if (logger.IsErrorEnabled)
{
logger.Error(string.Format("{0}\t{1}", _res.error_code, _res.error_msg));
}
return(_res);
}
else
{
if (custInfo.Active == false)
{
_res.SetError("03", "Customers have not been approved");
if (logger.IsErrorEnabled)
{
logger.Error(string.Format("{0}\t{1}", _res.error_code, _res.error_msg));
}
return(_res);
}
}
Categories dalCat = new Categories();
Categories_Info catInfo = dalCat.GetCategoriesByID(categories);
if (catInfo == null)
{
_res.SetError("98", string.Format("Categories Id {0} can not find", categories));
if (logger.IsErrorEnabled)
{
logger.Error(string.Format("{0}\t{1}", _res.error_code, _res.error_msg));
}
return(_res);
}
Account_Info acInfo = GetAccountBy(_channel.Branch, categories, custId);
if (acInfo == null)
{
// Khởi tạo thông tin mở tài khoản.
acInfo = new Account_Info();
acInfo.Name = custInfo.Name; // tên tài khoản.
acInfo.Customer_ID = custInfo.ID; // Mã khách hàng.
acInfo.Branch_ID = _channel.Branch;
acInfo.Categories = categories;
acInfo.Ccy = _channel.Currency_Code;
acInfo.Account_GL = catInfo.Account_GL.Account_ID;
acInfo.CreditDebit = catInfo.Account_GL.CreditDebit;
acInfo.Approved = true;
acInfo.ApprovedTime = DateTime.Now;
acInfo.UserCreate = _channel.UserLogin;
acInfo.Account_ID = GenerateNewAccountId(acInfo.Branch_ID, acInfo.Categories);
acInfo.Open_Date = DateTime.Now;
acInfo.Last_Date = DateTime.Now;
// thực hiện mở tài khoản.
if (Insert(acInfo) == 0)
{
_res.Accounts = acInfo.RenderXML();
}
else
{
// Lấy nội dung lỗi
_res.SetError("99", dalAc.GetException.Message);
if (logger.IsErrorEnabled)
{
logger.Error(string.Format("{0}\t{1}", _res.error_code, _res.error_msg));
}
return(_res);
}
}
else
{
// tài khoản đã được mở
_res.SetError("12", "Account opened");
if (logger.IsErrorEnabled)
{
logger.Error(string.Format("{0}\t{1}", _res.error_code, _res.error_msg));
}
}
}
catch (Exception ex)
{
_res.SetError("99", ex.Message);
if (logger.IsErrorEnabled)
{
logger.Error(string.Format("{0}\t{1}", _res.error_code, _res.error_msg));
}
}
return(_res);
}
void Accept()
{
try
{
if (Customer_CheckValidate() == false)
{
return;
}
MessageBoxResult result = NoteBox.Show("Bạn có muốn thêm khách hàng này hay không?", "Thông báo", NoteBoxLevel.Question);
if (MessageBoxResult.Yes != result)
{
return;
}
#region Thêm mới khách hàng
Customer_Info _Customer_Info = Get_Customer_Info();
if (_Customer_Info == null)
{
NoteBox.Show("Lỗi khởi tạo khách thuê nhà", "", NoteBoxLevel.Error);
return;
}
decimal _customer_id = -1;
// kiểm tra xem thằng tên khách hàng đó và số đt đó đã có trong db chưa
// nếu có rồi thì ko insert nữa
string _name = txtCustomer_Name.Text.ToUpper();
if (_name == "")
{
_name = CommonData.c_All_Value;
}
string _phone = txtPhone.Text.ToUpper();
if (_phone == "")
{
_phone = CommonData.c_All_Value;
}
List <Customer_Info> _lst = c_Customer_Controller.Customer_Search(_name, _phone);
if (_lst.Count > 0)
{
NoteBox.Show("Đã tồn tại khách hàng", "", NoteBoxLevel.Error);
return;
}
else
{
// không có thì thêm mới
_customer_id = c_Customer_Controller.Customer_Insert(_Customer_Info);
if (_customer_id == -1)
{
NoteBox.Show("Lỗi thêm mới khách thuê nhà", "", NoteBoxLevel.Error);
return;
}
}
#endregion
c_id_insert = _customer_id;
NoteBox.Show("Thêm mới dữ liệu thành công", "");
this.Close();
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
}
}
void LoadData()
{
try
{
List <AllCode_Info> _lst_Currency = DBMemory.AllCode_GetBy_CdNameCdType("CONTRACT", "CURENCY");
cboCurrency.ItemsSource = _lst_Currency;
cboCurrency.DisplayMemberPath = "Content";
cboCurrency.SelectedValuePath = "CdValue";
List <AllCode_Info> _lst_Term = DBMemory.AllCode_GetBy_CdNameCdType("FEE", "TERM");
cboTerm.ItemsSource = _lst_Term;
cboTerm.DisplayMemberPath = "Content";
cboTerm.SelectedValuePath = "CdValue";
cboTerm_Extend.ItemsSource = _lst_Term;
cboTerm_Extend.DisplayMemberPath = "Content";
cboTerm_Extend.SelectedValuePath = "CdValue";
List <AllCode_Info> _lst_C_T = DBMemory.AllCode_GetBy_CdNameCdType("CONTRACT", "STATUS");
cboStatus.ItemsSource = _lst_C_T;
cboStatus.DisplayMemberPath = "Content";
cboStatus.SelectedValuePath = "CdValue";
Estate_Object_Info _Estate_Object_Info = _Estate_Object_Controller.Estate_Object_GetById(c_Contract_Info.Estate_Id, (decimal)Enum_Contract_Type.Tenant);
if (_Estate_Object_Info != null)
{
lbl_Estate_Name.Content = _Estate_Object_Info.Estate_Name;
lbl_Estate_Code.Content = _Estate_Object_Info.Estate_Code;
lbl_Estate_Type_Name.Content = _Estate_Object_Info.Estate_Type_Name;
lbl_Estate_Area.Content = _Estate_Object_Info.Area;
lbl_Address.Content = _Estate_Object_Info.Address;
}
Customer_Info _Customer_Info = c_Customer_Controller.Customer_GetById(c_Contract_Info.Object_Id);
if (_Customer_Info != null)
{
txtRenter_Name.Text = _Customer_Info.Customer_Name;
txtAddress.Text = _Customer_Info.Address;
txtPhone.Text = _Customer_Info.Phone;
txtFax.Text = _Customer_Info.Fax;
txtPosition.Text = _Customer_Info.Position;
txtTaxCode.Text = _Customer_Info.Tax_Code;
txtIdentity_Card.Text = _Customer_Info.Identity_Card;
}
txtRepresentive.Text = c_Contract_Info.Representive;
txtUsers.Text = c_Contract_Info.Users;
txtContract_Code.Text = c_Contract_Info.Contract_Code;
dpContractDate.Text = c_Contract_Info.Contract_Date.ToString("dd/MM/yyyy");
cboCurrency.SelectedValue = c_Contract_Info.Currency;
dpFromDate.Text = c_Contract_Info.Contract_FromDate.ToString("dd/MM/yyyy");
dpToDate.Text = c_Contract_Info.Contract_ToDate.ToString("dd/MM/yyyy");
txtFee.Text = c_Contract_Info.Fee.ToString("#,##0.#");
txtPrice.Text = c_Contract_Info.Price.ToString("#,##0.#");
cboTerm.SelectedValue = c_Contract_Info.Term;
cboStatus.SelectedValue = c_Contract_Info.Status;
c_max_number_extend = _Extend_Contract_Controller.Get_Number_ExtendContract(c_Contract_Info.Contract_Id);
List <Extend_Contract_Info> _lst_ex = new List <Extend_Contract_Info>();
if (c_max_number_extend == 0)
{
tabExtendInfo.Visibility = Visibility.Collapsed;
}
else
{
tabExtendInfo.Visibility = Visibility.Visible;
_lst_ex = _Extend_Contract_Controller.Extend_Contract_GetByContractId(c_Contract_Info.Contract_Id);
dgrExtend.ItemsSource = _lst_ex;
}
List <Fees_Revenue_Info> c_lst_Fee = new List <Fees_Revenue_Info>();
List <Fees_Revenue_Info> c_lst_Fee_Extend = new List <Fees_Revenue_Info>();
if (c_Contract_Info.Status == (decimal)Enum_Contract_Status.Gia_Han)
{
if (_lst_ex.Count > 0)
{
txtFeeOnePay_Extend.Text = _lst_ex[0].FeeOnePay.ToString("#,##0.#");
txtFee_Extend.Text = _lst_ex[0].Fee.ToString("#,##0.#");
dpFromDate_Extend.Text = _lst_ex[0].Contract_FromDate.ToString("dd/MM/yyyy");
dpToDate_Extend.Text = _lst_ex[0].Contract_ToDate.ToString("dd/MM/yyyy");
cboTerm_Extend.SelectedValue = _lst_ex[0].Term;
}
tabExtend.Visibility = Visibility.Visible;
List <Fees_Revenue_Info> _lst = _Fees_Revenue_Controller.Fees_Revenue_GetByContract(c_Contract_Info.Contract_Id);
foreach (Fees_Revenue_Info item in _lst)
{
if (item.Is_Extend == c_max_number_extend)
{
c_lst_Fee_Extend.Add(item);
}
else
{
c_lst_Fee.Add(item);
}
}
}
else
{
tabExtend.Visibility = Visibility.Collapsed;
c_lst_Fee = _Fees_Revenue_Controller.Fees_Revenue_GetByContract(c_Contract_Info.Contract_Id);
}
dgrFee.ItemsSource = c_lst_Fee;
dgrFee_Extend.ItemsSource = c_lst_Fee_Extend;
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
}
}
void Accept()
{
try
{
if (!CheckValidate_F())
{
return;
}
Customer_Controller _Customer_Controller = new Customer_Controller();
if (c_type == Convert.ToInt16(Form_Type.Insert))
{
MessageBoxResult result = NoteBox.Show("Bạn chắc chắn muốn thêm mới khách hàng " + txtName.Text + " hay không?", "Thông báo", NoteBoxLevel.Question);
if (MessageBoxResult.Yes == result)
{
Customer_Info _Customer_Info = new Customer_Info();
_Customer_Info.Customer_Name = txtName.Text;
_Customer_Info.Phone = txtPhone.Text;
_Customer_Info.Address = txtAddress.Text;
decimal _id = 0;
if (_Customer_Controller.Customer_Insert(_Customer_Info, ref _id))
{
NoteBox.Show("Thêm mới thành công");
c_id_insert = _id;
this.Close();
}
else
{
NoteBox.Show("Có lỗi trong quá trình thêm mới", "", NoteBoxLevel.Error);
}
}
}
else
{
MessageBoxResult result = NoteBox.Show("Bạn chắc chắn muốn cập nhật hay không?", "Thông báo", NoteBoxLevel.Question);
if (MessageBoxResult.Yes == result)
{
Customer_Info _Customer_Info = new Customer_Info();
_Customer_Info.Customer_Name = txtName.Text;
_Customer_Info.Phone = txtPhone.Text;
_Customer_Info.Address = txtAddress.Text;
if (_Customer_Controller.Customer_Update(c_Customer_Info.Customer_Id, _Customer_Info))
{
NoteBox.Show("Cập nhật dữ liệu thành công");
c_id_insert = 1;
this.Close();
}
else
{
NoteBox.Show("Có lỗi trong quá trình cập nhật dữ liệu", "", NoteBoxLevel.Error);
}
}
}
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
}
}
void Export_Payment()
{
try
{
Fee_Report_Info _Fees_Revenue_Info = (Fee_Report_Info)dgrContract.SelectedItem;
if (_Fees_Revenue_Info == null)
{
return;
}
Customer_Info _Customer_Info = _Customer_Controller.Customer_GetById(_Fees_Revenue_Info.Object_Id);
Estate_Object_Info _Estate_Object_Info = _Estate_Object_Controller.Estate_Object_GetById(_Fees_Revenue_Info.Estate_Id, _Fees_Revenue_Info.Contract_Type);
#region Kết xuất
FlexCel.Report.FlexCelReport flcReport = new FlexCel.Report.FlexCelReport();
string _path = CommonData.ExcelDesignFilePath;
string _fileExcelName = "Payment_Request_VND.xls";
if (_Fees_Revenue_Info.Currency == (decimal)Enum_Contract_Currency.USD)
{
_fileExcelName = "Payment_Request_USD.xls";
}
_path += _fileExcelName;
CommonFunction.SetValueExportByString(ref flcReport, "CurrentDate", DateTime.Now.ToString("dd/MM/yyyy"));
CommonFunction.SetValueExportByString(ref flcReport, "Tenat_Name", _Customer_Info.Customer_Name);
CommonFunction.SetValueExportByString(ref flcReport, "Address", _Customer_Info.Address);
CommonFunction.SetValueExportByString(ref flcReport, "Users", _Fees_Revenue_Info.Users);
CommonFunction.SetValueExportByString(ref flcReport, "TaxCode", _Customer_Info.Tax_Code);
CommonFunction.SetValueExportByString(ref flcReport, "Estate_Name", _Estate_Object_Info.Estate_Name);
CommonFunction.SetValueExportByString(ref flcReport, "Contract_FromDate", _Fees_Revenue_Info.Contract_FromDate.ToString("dd/MM/yyyy"));
CommonFunction.SetValueExportByString(ref flcReport, "Contract_ToDate", _Fees_Revenue_Info.Contract_ToDate.ToString("dd/MM/yyyy"));
//decimal _VAT_Fee = Math.Round(_Fees_Revenue_Info.Fee_Expected * 10 / 100);
//decimal _Fee = _Fees_Revenue_Info.Fee_Expected - _VAT_Fee;
//decimal _p = 110 / 100;
//decimal _Fee = _Fees_Revenue_Info.Fee_Expected / _p;
//decimal _VAT_Fee = Math.Round(_Fee * 10 / 100);
decimal _Fee = (_Fees_Revenue_Info.Fee_Expected / 110) * 100;
decimal _VAT_Fee = Math.Round(_Fee * 10 / 100);
CommonFunction.SetValueExportByString(ref flcReport, "Fee", _Fee.ToString("###,##0"));
CommonFunction.SetValueExportByString(ref flcReport, "VAT_Fee", _VAT_Fee.ToString("###,##0"));
CommonFunction.SetValueExportByString(ref flcReport, "Total_Fee", _Fees_Revenue_Info.Fee_Expected.ToString("###,##0"));
if (_Fees_Revenue_Info.Contract_Type == (decimal)Enum_Contract_Type.Tenant)
{
#region Kỳ thanh toán
string _Kytt = "Thanh toán phí MG lần " + _Fees_Revenue_Info.Number_Payment
+ " từ ngày " + _Fees_Revenue_Info.HanChuyenTien.ToString("dd/MM/yyyy") + " đến ngày " +
_Fees_Revenue_Info.HanChuyenTien.AddDays(30).ToString("dd/MM/yyyy");
if (_Fees_Revenue_Info.Term == (decimal)Enum_Fee_Maturity.One)
{
_Kytt = "Thanh toán phí MG lần " + _Fees_Revenue_Info.Number_Payment
+ " từ ngày " + _Fees_Revenue_Info.HanChuyenTien.ToString("dd/MM/yyyy") + " đến ngày " +
_Fees_Revenue_Info.HanChuyenTien.AddDays(30).ToString("dd/MM/yyyy");
}
else if (_Fees_Revenue_Info.Term == (decimal)Enum_Fee_Maturity.One_Month)
{
_Kytt = "Thanh toán phí MG lần " + _Fees_Revenue_Info.Number_Payment
+ " từ ngày " + _Fees_Revenue_Info.HanChuyenTien.ToString("dd/MM/yyyy") + " đến ngày " +
_Fees_Revenue_Info.HanChuyenTien.AddMonths(1).ToString("dd/MM/yyyy");
}
else if (_Fees_Revenue_Info.Term == (decimal)Enum_Fee_Maturity.Three_Month)
{
_Kytt = "Thanh toán phí MG lần " + _Fees_Revenue_Info.Number_Payment
+ " từ ngày " + _Fees_Revenue_Info.HanChuyenTien.ToString("dd/MM/yyyy") + " đến ngày " +
_Fees_Revenue_Info.HanChuyenTien.AddMonths(3).ToString("dd/MM/yyyy");
}
else if (_Fees_Revenue_Info.Term == (decimal)Enum_Fee_Maturity.Six_Month)
{
_Kytt = "Thanh toán phí MG lần " + _Fees_Revenue_Info.Number_Payment
+ " từ ngày " + _Fees_Revenue_Info.HanChuyenTien.ToString("dd/MM/yyyy") + " đến ngày " +
_Fees_Revenue_Info.HanChuyenTien.AddMonths(6).ToString("dd/MM/yyyy");
}
else if (_Fees_Revenue_Info.Term == (decimal)Enum_Fee_Maturity.One_Year)
{
_Kytt = "Thanh toán phí MG lần " + _Fees_Revenue_Info.Number_Payment
+ " từ ngày " + _Fees_Revenue_Info.HanChuyenTien.ToString("dd/MM/yyyy") + " đến ngày " +
_Fees_Revenue_Info.HanChuyenTien.AddYears(1).ToString("dd/MM/yyyy");
}
CommonFunction.SetValueExportByString(ref flcReport, "KyThanhToan", _Kytt);
#endregion
}
else
{
CommonFunction.SetValueExportByString(ref flcReport, "KyThanhToan", "");
}
DateTime _dt_from = DateTime.Now;
DateTime _dt_To = _dt_from.AddDays(30);
CommonFunction.SetValueExportByString(ref flcReport, "From", _dt_from.ToString("dd/MM/yyyy"));
CommonFunction.SetValueExportByString(ref flcReport, "To", _dt_To.ToString("dd/MM/yyyy"));
//CommonFunction.SetValueExportByString(ref flcReport, "From", _Fees_Revenue_Info.HanChuyenTien.ToString("dd/MM/yyyy"));
//CommonFunction.SetValueExportByString(ref flcReport, "To", _Fees_Revenue_Info.HanChuyenTien.AddDays(30).ToString("dd/MM/yyyy"));
if (_Fees_Revenue_Info.Price != 0)
{
CommonFunction.SetValueExportByString(ref flcReport, "Price", _Fees_Revenue_Info.Price.ToString("###,##0"));
}
else
{
CommonFunction.SetValueExportByString(ref flcReport, "Price", "");
}
string _tienBangChu = ConvertData.ConvertMoneyToStr(Convert.ToDouble(_Fees_Revenue_Info.Fee_Expected));
if (_Fees_Revenue_Info.Currency == (decimal)Enum_Contract_Currency.USD)
{
_tienBangChu = c_Contract_Controller.Convert_Dola(_Fees_Revenue_Info.Fee_Expected);
}
if (_Fees_Revenue_Info.Currency == (decimal)Enum_Contract_Currency.USD)
{
CommonFunction.SetValueExportByString(ref flcReport, "VND", _Fees_Revenue_Info.Fee_Vnd.ToString("###,##0"));
}
CommonFunction.SetValueExportByString(ref flcReport, "BangChu", _tienBangChu.ToLower());
System.Windows.Forms.SaveFileDialog saveReport = new System.Windows.Forms.SaveFileDialog();
saveReport.Filter = "Excel files (*.xls)|*.xls";
if (saveReport.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
CommonFunction.ExportExcel(flcReport, _path, saveReport);
}
#endregion
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
}
}
void LoadData()
{
try
{
List <AllCode_Info> _lst_C_T = DBMemory.AllCode_GetBy_CdNameCdType("CONTRACT", "STATUS");
cboStatus.ItemsSource = _lst_C_T;
cboStatus.DisplayMemberPath = "Content";
cboStatus.SelectedValuePath = "CdValue";
List <AllCode_Info> _lst_Currency = DBMemory.AllCode_GetBy_CdNameCdType("CONTRACT", "CURENCY");
cboCurrency.ItemsSource = _lst_Currency;
cboCurrency.DisplayMemberPath = "Content";
cboCurrency.SelectedValuePath = "CdValue";
Estate_Object_Info _Estate_Object_Info = _Estate_Object_Controller.Estate_Object_GetById(c_Contract_Info.Estate_Id, (decimal)Enum_Contract_Type.Renter);
lbl_Estate_Name.Content = _Estate_Object_Info.Estate_Name;
lbl_Estate_Code.Content = _Estate_Object_Info.Estate_Code;
lbl_Estate_Type_Name.Content = _Estate_Object_Info.Estate_Type_Name;
lbl_Estate_Area.Content = _Estate_Object_Info.Area;
lbl_Address.Content = _Estate_Object_Info.Address;
Customer_Info _Customer_Info = c_Customer_Controller.Customer_GetById(c_Contract_Info.Object_Id);
if (_Customer_Info != null)
{
txtRenter_Name.Text = _Customer_Info.Customer_Name;
txtAddress.Text = _Customer_Info.Address;
txtPhone.Text = _Customer_Info.Phone;
txtFax.Text = _Customer_Info.Fax;
txtRepresentive.Text = c_Contract_Info.Representive;
txtUsers.Text = c_Contract_Info.Users;
txtTaxCode.Text = _Customer_Info.Tax_Code;
txtIdentity_Card.Text = _Customer_Info.Identity_Card;
}
txtContract_Code.Text = c_Contract_Info.Contract_Code;
txtContract_Name.Text = c_Contract_Info.Contract_Name;
dpContractDate.Text = c_Contract_Info.Contract_Date.ToString("dd/MM/yyyy");
txtPrice.Text = c_Contract_Info.Price.ToString("#,##0.#");
cboCurrency.SelectedValue = c_Contract_Info.Currency;
#region Fee VND
if (c_Contract_Info.Currency == (decimal)Enum_Contract_Currency.USD)
{
if (c_Contract_Info.Status == (decimal)Enum_Contract_Status.Gia_Han)
{
lblThanhTien_Extend.Visibility = Visibility.Visible;
txtFee_Vnd_Extend.Visibility = Visibility.Visible;
lblVND_Extend.Visibility = Visibility.Visible;
lblThanhTien.Visibility = Visibility.Collapsed;
txtFee_Vnd.Visibility = Visibility.Collapsed;
lblVND.Visibility = Visibility.Collapsed;
}
else
{
lblThanhTien.Visibility = Visibility.Visible;
txtFee_Vnd.Visibility = Visibility.Visible;
lblVND.Visibility = Visibility.Visible;
lblThanhTien_Extend.Visibility = Visibility.Collapsed;
txtFee_Vnd_Extend.Visibility = Visibility.Collapsed;
lblVND_Extend.Visibility = Visibility.Collapsed;
}
}
else
{
lblThanhTien.Visibility = Visibility.Collapsed;
txtFee_Vnd.Visibility = Visibility.Collapsed;
lblVND.Visibility = Visibility.Collapsed;
lblThanhTien_Extend.Visibility = Visibility.Collapsed;
txtFee_Vnd_Extend.Visibility = Visibility.Collapsed;
lblVND_Extend.Visibility = Visibility.Collapsed;
}
#endregion
dpFromDate.Text = c_Contract_Info.Contract_FromDate.ToString("dd/MM/yyyy");
dpToDate.Text = c_Contract_Info.Contract_ToDate.ToString("dd/MM/yyyy");
cboStatus.SelectedValue = c_Contract_Info.Status;
txtFee.Text = c_Contract_Info.Fee.ToString("#,##0.#");
List <Fees_Revenue_Info> c_lst_Fee = new List <Fees_Revenue_Info>();
List <Fees_Revenue_Info> c_lst_Fee_Extend = new List <Fees_Revenue_Info>();
if (c_Contract_Info.Status == (decimal)Enum_Contract_Status.Gia_Han)
{
Extend_Contract_Controller _Extend_Contract_Controller = new Extend_Contract_Controller();
List <Extend_Contract_Info> _lst_ex = _Extend_Contract_Controller.Extend_Contract_GetByContractId(c_Contract_Info.Contract_Id);
if (_lst_ex.Count > 0)
{
txtFeeOnePay_Extend.Text = _lst_ex[0].FeeOnePay.ToString("#,##0.#");
txtFee_Extend.Text = _lst_ex[0].Fee.ToString("#,##0.#");
dpFromDate_Extend.Text = _lst_ex[0].Contract_FromDate.ToString("dd/MM/yyyy");
dpToDate_Extend.Text = _lst_ex[0].Contract_ToDate.ToString("dd/MM/yyyy");
}
tabExtend.Visibility = Visibility.Visible;
List <Fees_Revenue_Info> _lst = _Fees_Revenue_Controller.Fees_Revenue_GetByContract(c_Contract_Info.Contract_Id);
foreach (Fees_Revenue_Info item in _lst)
{
if (item.Is_Extend == 1)
{
c_lst_Fee_Extend.Add(item);
}
else
{
c_lst_Fee.Add(item);
}
}
txtFee_Vnd_Extend.Text = c_lst_Fee_Extend[c_lst_Fee_Extend.Count - 1].Fee_Vnd.ToString("#,##0.#");
txtFee_Vnd_Extend.Focusable = false;
txtFee_Vnd_Extend.IsHitTestVisible = false;
}
else
{
tabExtend.Visibility = Visibility.Collapsed;
c_lst_Fee = _Fees_Revenue_Controller.Fees_Revenue_GetByContract(c_Contract_Info.Contract_Id);
txtFee_Vnd.Text = c_lst_Fee[c_lst_Fee.Count - 1].Fee_Vnd.ToString("#,##0.#");
txtFee_Vnd.Focusable = false;
txtFee_Vnd.IsHitTestVisible = false;
}
dgrFee.ItemsSource = c_lst_Fee;
dgrFee_Extend.ItemsSource = c_lst_Fee_Extend;
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
}
}
