public static bool RemoveCustomer(int _MaKhachSuaXe, string exception = "")
{
try
{
//ExcuteQuery
DatabaseConnectionDAO.ExcuteProcedure("RemoveCustomer", ref exception, new MySqlParameter[] { new MySqlParameter("@_MaKhachSuaXe", _MaKhachSuaXe) });
//if there is no exception
if (exception == "")
{
return(true);
}
}
catch (Exception ex)
{
exception = ex.Message;
}
return(false);
//MySqlConnection Conn = DatabaseConnectionDAO.connectionDatabase();
//MySqlCommand cmd = new MySqlCommand("RemoveCustomer", Conn);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@_MaKhachSuaXe", MySqlDbType.VarChar, 10);
//cmd.Parameters["@_MaKhachSuaXe"].Value = _MaKhachSuaXe;
//Conn.Open();
//cmd.ExecuteNonQuery();
//Conn.Close();
}
//public static void InsertCustomer(KhachSuaXeDTO kh)
//{
// MySqlConnection Conn = DatabaseConnectionDAO.connectionDatabase();
// MySqlCommand cmd = new MySqlCommand("InsertCustomer", Conn);
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("@_MaKhachSuaXe", MySqlDbType.VarChar, 10);
// cmd.Parameters.Add("@_TenChuXe", MySqlDbType.VarChar, 100);
// cmd.Parameters.Add("@_DienThoai", MySqlDbType.VarChar, 20);
// cmd.Parameters.Add("@_DiaChi", MySqlDbType.VarChar, 100);
// cmd.Parameters.Add("@_Email", MySqlDbType.VarChar, 40);
// cmd.Parameters.Add("@_TienNo", MySqlDbType.Decimal);
// cmd.Parameters["@_MaKhachSuaXe"].Value = kh.MaKhachSuaXe;
// cmd.Parameters["@_TenChuXe"].Value = kh.TenChuXe;
// cmd.Parameters["@_DienThoai"].Value = kh.DienThoai;
// cmd.Parameters["@_DiaChi"].Value = kh.DiaChi;
// cmd.Parameters["@_Email"].Value = kh.Email;
// cmd.Parameters["@_TienNo"].Value = kh.TienNo;
// Conn.Open();
// cmd.ExecuteNonQuery();
// Conn.Close();
//}
public static bool InsertCustomer(KhachSuaXeDTO kh, string exception = "")
{
try
{
//ExcuteQuery
DatabaseConnectionDAO.ExcuteProcedure("InsertCustomer", ref exception, new MySqlParameter[] { new MySqlParameter("@_MaKhachSuaXe", kh.MaKhachSuaXe), new MySqlParameter("@_TenChuXe", kh.TenChuXe), new MySqlParameter("@_DienThoai", kh.DienThoai), new MySqlParameter("@_DiaChi", kh.DiaChi), new MySqlParameter("@_Email", kh.Email), new MySqlParameter("@_TienNo", kh.TienNo) });
//if there is no exception
if (exception == "")
{
return(true);
}
}
catch (Exception ex)
{
exception = ex.Message;
}
return(false);
}
