/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Create new Customer and return Customer id auto increment
/// </summary>
/// <param name="pCustomer">Customer</param>
public int Create(Customer pCustomer)
{
IDbDataParameter[] parameters = {
MakeParameter("@Code", DbType.String, 10),
MakeParameter("@Name", DbType.String, 200),
MakeParameter("@ADDRESS", DbType.String, 400),
MakeParameter("@TEL", DbType.String, 20),
MakeParameter("@FAX", DbType.String, 20),
MakeParameter("@WEB", DbType.String, 400),
MakeParameter("@EMAIL", DbType.String, 400),
MakeParameter("@CONTACT_NAME", DbType.String, 200),
MakeParameter("@CONTACT_TEL", DbType.String, 20),
MakeParameter("@CONTACT_EMAIL", DbType.String, 400)
};
parameters[0].Value = pCustomer.Code;
parameters[1].Value = pCustomer.Name;
parameters[2].Value = pCustomer.Adress;
parameters[3].Value = pCustomer.Tel;
parameters[4].Value = pCustomer.Fax;
parameters[5].Value = pCustomer.Web;
parameters[6].Value = pCustomer.Email;
parameters[7].Value = pCustomer.ContactName;
parameters[8].Value = pCustomer.ContactTel;
parameters[9].Value = pCustomer.ContactEmail;
int rowAffected = 0;
return RunProcedure("sp_ADV_Customer_INSERT", parameters, out rowAffected);
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Process add Customer in UI
/// </summary>
/// <param name="pCustomer">Customer</param>
public void AddCustomerUI(Customer pCustomer)
{
// Add row to grid
DataRow row = ((DataView)mdgrCustomer.DataSource).Table.NewRow();
row["Customer_ID"] = pCustomer.CustomerID;
row["CODE"] = pCustomer.Code;
row["NAME"] = pCustomer.Name;
row["ADDRESS"] = pCustomer.Adress;
row["TEL"] = pCustomer.Tel;
row["FAX"] = pCustomer.Fax;
row["WEB"] = pCustomer.Web;
row["EMAIL"] = pCustomer.Email;
row["CONTACT_NAME"] = pCustomer.ContactName;
row["CONTACT_TEL"] = pCustomer.ContactTel;
row["CONTACT_EMAIL"] = pCustomer.ContactEmail;
row["##STT##"] = mdgrCustomer.Rows.Count + 1;
((DataView)mdgrCustomer.DataSource).Table.Rows.Add(row);
// change current row to last row
mdgrCustomer.CurrentCell = mdgrCustomer.Rows[mdgrCustomer.RowCount - 1].Cells[0];
mdgrCustomer.CurrentRow.Selected = true;
SetButtonStatus();
// Change current row to the new row
//mdgrCustomer.CurrentRow.Selected = false;
//mintCurrentRow = mdgrCustomer.RowCount - 1;
//mdgrCustomer.Rows[mdgrCustomer.RowCount - 1].Selected = true;
//GenSTT();
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Constrctor to update selected Customer
/// </summary>
public FrmCustomerItem(FrmCustomer frmCustomer, Customer pCustomer)
: this()
{
mfrmCustomer = frmCustomer;
mCustomer = pCustomer;
//mOldCustomer = System.Clo
mblnUpdate = true;
this.Text = "Cap nhat khach hang";
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Delete 1 Customer with Customer_id
/// </summary>
/// <param name="pCustomer">Customer</param>
public int Delete(Customer pCustomer)
{
IDbDataParameter[] parameters = {
MakeParameter("@Customer_ID", DbType.Int32, 10)
};
parameters[0].Value = pCustomer.CustomerID;
int rowAffected = 0;
RunProcedure("sp_ADV_Customer_DELETE", parameters, out rowAffected);
return rowAffected;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Insert 1 Customer and return Customer_id auto increment
/// </summary>
public int Add(Customer pCustomer)
{
PrCustomer Customer = new PrCustomer(Connection);
int intCustomerID = -1;
try
{
Open();
intCustomerID = Customer.Create(pCustomer);
Commit();
}
catch (Exception exp)
{
Rollback();
throw exp;
}
finally
{
Close();
}
return intCustomerID;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Delete 1 Customer with Customer_id
/// </summary>
public int Delete(Customer pCustomer)
{
PrCustomer Customer = new PrCustomer(Connection);
int intRowAffected = 0;
try
{
Open();
intRowAffected = Customer.Delete(pCustomer);
Commit();
}
catch (Exception exp)
{
Rollback();
throw exp;
}
finally
{
Close();
}
return intRowAffected;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Retrieves all Customer
/// </summary>
public DataSet Retrieves(Customer pCustomer)
{
PrCustomer Customer = new PrCustomer(Connection);
try
{
Open();
return Customer.Search(pCustomer);
}
catch (Exception exp)
{
throw exp;
}
finally
{
Close();
}
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Searh Customer by many param
/// </summary>
public DataSet Search(Customer pCustomer)
{
IDbDataParameter[] parameters = {
MakeParameter("@CUSTOMER_ID", DbType.Int32, 4),
MakeParameter("@CODE", DbType.String, 10),
MakeParameter("@NAME", DbType.String, 200)
};
parameters[0].Value = (pCustomer.CustomerID < 0) ? (object)DBNull.Value : (object)pCustomer.CustomerID;
parameters[1].Value = (pCustomer.Code == null) ? (object)DBNull.Value : (object)pCustomer.Code;
parameters[2].Value = (pCustomer.Name == null) ? (object)DBNull.Value : (object)pCustomer.Name;
return RunProcedure("sp_ADV_Customer_SELECT_SEARCH", parameters, "ADV_Customer");
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: make search param depend on combo box
/// </summary>
private Customer MakeSearchParam()
{
Customer customer = new Customer();
customer.CustomerID = -1;
customer.Code = (mcboSearch.SelectedIndex == 1) ? mtxtSearch.Text.Trim() : null;
customer.Name = (mcboSearch.SelectedIndex == 2) ? mtxtSearch.Text.Trim() : null;
return customer;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Update new Customer in UI
/// </summary>
/// <param name="pCustomer">Customer</param>
public void UpdateCustomerUI(Customer pCustomer)
{
// Update from data to row in grid
mdgrCustomer.CurrentRow.Cells["NAME"].Value = pCustomer.Name;
mdgrCustomer.CurrentRow.Cells["CODE"].Value = pCustomer.Code;
mdgrCustomer.CurrentRow.Cells["ADDRESS"].Value = pCustomer.Adress;
mdgrCustomer.CurrentRow.Cells["TEL"].Value = pCustomer.Tel;
mdgrCustomer.CurrentRow.Cells["FAX"].Value = pCustomer.Fax;
mdgrCustomer.CurrentRow.Cells["WEB"].Value = pCustomer.Web;
mdgrCustomer.CurrentRow.Cells["EMAIL"].Value = pCustomer.Email;
mdgrCustomer.CurrentRow.Cells["CONTACT_NAME"].Value = pCustomer.ContactName;
mdgrCustomer.CurrentRow.Cells["CONTACT_TEL"].Value = pCustomer.ContactTel;
mdgrCustomer.CurrentRow.Cells["CONTACT_EMAIL"].Value = pCustomer.ContactEmail;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Get current Customer from grid
/// </summary>
/// <param name="return">Customer</param>
public Customer GetCurrentCustomer()
{
// Get current row data into Customer
Customer Customer = new Customer();
Customer.CustomerID = ((Int32)mdgrCustomer.CurrentRow.Cells["Customer_ID"].Value);
Customer.Code = (String)mdgrCustomer.CurrentRow.Cells["CODE"].Value;
Customer.Name = (String)mdgrCustomer.CurrentRow.Cells["NAME"].Value;
Customer.Adress = (String)mdgrCustomer.CurrentRow.Cells["ADDRESS"].Value;
Customer.Tel = (String)mdgrCustomer.CurrentRow.Cells["TEL"].Value;
Customer.Fax = (String)mdgrCustomer.CurrentRow.Cells["FAX"].Value;
Customer.Web = (String)mdgrCustomer.CurrentRow.Cells["WEB"].Value;
Customer.Email = (String)mdgrCustomer.CurrentRow.Cells["EMAIL"].Value;
Customer.ContactName = (String)mdgrCustomer.CurrentRow.Cells["CONTACT_NAME"].Value;
Customer.ContactTel = (String)mdgrCustomer.CurrentRow.Cells["CONTACT_TEL"].Value;
Customer.ContactEmail = (String)mdgrCustomer.CurrentRow.Cells["CONTACT_EMAIL"].Value;
//Customer.CustomerID = ((Int32)mdgrCustomer["Customer_ID", mintCurrentRow].Value);
//Customer.Code = (String)mdgrCustomer["CODE", mintCurrentRow].Value;
//Customer.Name = (String)mdgrCustomer["NAME", mintCurrentRow].Value;
//Customer.Adress = (String)mdgrCustomer["ADDRESS", mintCurrentRow].Value;
//Customer.Tel = (String)mdgrCustomer["TEL", mintCurrentRow].Value;
//Customer.Fax = (String)mdgrCustomer["FAX", mintCurrentRow].Value;
//Customer.Web = (String)mdgrCustomer["WEB", mintCurrentRow].Value;
//Customer.Email = (String)mdgrCustomer["EMAIL", mintCurrentRow].Value;
//Customer.ContactName = (String)mdgrCustomer["CONTACT_NAME", mintCurrentRow].Value;
//Customer.ContactTel = (String)mdgrCustomer["CONTACT_TEL", mintCurrentRow].Value;
//Customer.ContactEmail = (String)mdgrCustomer["CONTACT_EMAIL", mintCurrentRow].Value;
// Return
return Customer;
}
