public Cust_Class getById(int Id)
{
try
{
string query = "SELECT * FROM tb_customer WHERE id_cust = " + Id + ";";
OpenConnection();
Cust_Class hasil = myConn.Query <Cust_Class>(query, new { id_cust = Id }).FirstOrDefault();
closeConnection();
return(hasil);
}
catch (Exception ex)
{
throw ex;
}
}
public Cust_Class getByUsername(String Username)
{
try
{
string query = "SELECT * FROM tb_customer WHERE username = '******';";
OpenConnection();
Cust_Class hasil = myConn.Query <Cust_Class>(query, new { username = Username }).FirstOrDefault();
closeConnection();
return(hasil);
}
catch (Exception ex)
{
throw ex;
}
}
public void insertNewCustomer(Cust_Class cust)
{
try
{
string nama_cust = cust.Nama_cust;
string username = cust.Username;
string email = cust.Email;
string password = cust.Password;
string query = "INSERT INTO tb_customer VALUES (null,'" + nama_cust + "','" + username + "'" + " ,'"
+ email + "','" + password + "');";
OpenConnection();
var hasil = myConn.Execute(query);
closeConnection();
} catch (Exception ex)
{
throw ex;
}
}