/// <summary>
/// Get a supplier
/// </summary>
/// <param name="inItem">input info supplier to search</param>
/// <returns></returns>
public pts_supplier GetSupplier(pts_supplier inItem)
{
//SQL library
PSQL SQL = new PSQL();
string query = string.Empty;
//Open SQL connection
SQL.Open();
//SQL query string
query = "select supplier_id, supplier_cd, supplier_name, supplier_tel, supplier_fax, supplier_address, registration_date_time,registration_user_cd ";
query += "from pts_supplier where 1=1 ";
if (inItem.supplier_id > 0)
{
query += "and supplier_id ='" + inItem.supplier_id + "' ";
}
if (!string.IsNullOrEmpty(inItem.supplier_cd))
{
query += "and supplier_cd ='" + inItem.supplier_cd + "' ";
}
if (!string.IsNullOrEmpty(inItem.supplier_name))
{
query += "and supplier_name ='" + inItem.supplier_name + "' ";
}
//Execute reader for read database
IDataReader reader = SQL.Command(query).ExecuteReader();
reader.Read();
pts_supplier outItem = new pts_supplier
{
supplier_id = (int)reader["supplier_id"],
supplier_cd = reader["supplier_cd"].ToString(),
supplier_name = reader["supplier_name"].ToString(),
supplier_tel = reader["supplier_tel"].ToString(),
supplier_fax = reader["supplier_fax"].ToString(),
supplier_address = reader["supplier_address"].ToString(),
registration_date_time = (DateTime)reader["registration_date_time"],
registration_user_cd = reader["registration_user_cd"].ToString()
};
reader.Close();
query = string.Empty;
//Close SQL connection
SQL.Close();
return(outItem);
}
/// <summary>
/// Update supplier
/// </summary>
/// <param name="UpSupplier"></param>
/// <returns></returns>
public int UpdateSuplier(pts_supplier UpSupplier)
{
//SQL library
PSQL SQL = new PSQL();
string query = string.Empty;
//Open SQL connection
SQL.Open();
//SQL query string
query = "UPDATE pts_supplier SET supplier_cd='" + UpSupplier.supplier_cd + "', supplier_name='" + UpSupplier.supplier_name;
query += "', supplier_tel ='" + UpSupplier.supplier_tel + "', supplier_fax ='" + UpSupplier.supplier_fax;
query += "', supplier_address ='" + UpSupplier.supplier_address + "',registration_user_cd ='" + UpSupplier.registration_user_cd;
query += "', registration_date_time = now() where supplier_cd ='" + UpSupplier.supplier_cd + "'";
//Execute non query for read database
int result = SQL.Command(query).ExecuteNonQuery();
query = string.Empty;
return(result);
}
/// <summary>
/// Add supplier item
/// </summary>
/// <param name="addptssupplier"></param>
/// <returns></returns>
public int AddSupplier(pts_supplier addptssupplier)
{
//SQL library
PSQL SQL = new PSQL();
string query = string.Empty;
//Open SQL connection
SQL.Open();
//SQL query string
query = "INSERT INTO pts_supplier(supplier_cd, supplier_name, supplier_tel, supplier_fax, supplier_address, registration_user_cd)";
query += "VALUES ('" + addptssupplier.supplier_cd + "','" + addptssupplier.supplier_name + "','";
query += addptssupplier.supplier_tel + "','" + addptssupplier.supplier_fax + "','" + addptssupplier.supplier_address + "','";
query += addptssupplier.registration_user_cd + "')";
//Execute non query for read database
int result = SQL.Command(query).ExecuteNonQuery();
query = string.Empty;
return(result);
}
/// <summary>
/// Get list supplier from database with supplier code
/// </summary>
/// <param name="supplier_code">string.empty if get all supplier in database</param>
public void GetListSupplier(string supplier_code)
{
//SQL library
PSQL SQL = new PSQL();
string query = string.Empty;
listSupplier = new List <pts_supplier>();
//Open SQL connection
SQL.Open();
//SQL query string
query = "select supplier_id, supplier_cd, supplier_name, supplier_tel, supplier_fax, supplier_address, registration_date_time,registration_user_cd ";
query += "from pts_supplier where 1=1 ";
if (!string.IsNullOrEmpty(supplier_code))
{
query += "and supplier_cd = '" + supplier_code + "' ";
}
query += "order by supplier_cd";
//Execute reader for read database
IDataReader reader = SQL.Command(query).ExecuteReader();
query = string.Empty;
while (reader.Read())
{
//Get an item
pts_supplier outItem = new pts_supplier
{
supplier_id = (int)reader["supplier_id"],
supplier_cd = reader["supplier_cd"].ToString(),
supplier_name = reader["supplier_name"].ToString(),
supplier_tel = reader["supplier_tel"].ToString(),
supplier_fax = reader["supplier_fax"].ToString(),
supplier_address = reader["supplier_address"].ToString(),
registration_date_time = (DateTime)reader["registration_date_time"],
registration_user_cd = reader["registration_user_cd"].ToString()
};
//Add item into list
listSupplier.Add(outItem);
}
reader.Close();
//Close SQL connection
SQL.Close();
}
