//UPDATE ADDRESS SET address = 'nueva' WHERE idAddress = 1
public static void NewAddress(string newAddress, int idAddress)
{
string query = String.Format(
"UPDATE ADDRESS SET address='{0}' WHERE idaddress='{1}';", newAddress, idAddress
);
ConectionDB.ExecuteNonQuery(query);
}
public static void Delete(string user)
{
string query = String.Format(
"DELETE FROM APPUSER WHERE userName='******';", user
);
ConectionDB.ExecuteNonQuery(query);
}
public static void NewPassword(string usuario, string nuevaContra)
{
string sql = String.Format(
"update APPUSER set password='******' where userName='******';",
nuevaContra, usuario);
ConectionDB.ExecuteNonQuery(sql);
}
public static void DeleteBusiness(string name)
{
string query = String.Format(
"DELETE FROM BUSINESS WHERE name = '{0}'; ", name
);
ConectionDB.ExecuteNonQuery(query);
}
public static void CreateUser(string name, string userName)
{
string query = String.Format(
"INSERT INTO APPUSER(fullname,username,password,userType) " +
"VALUES('{0}','{1}','{2}', false);", name, userName, name
);
ConectionDB.ExecuteNonQuery(query);
}
public static void AddOrder(DateTime order, int idProduct, int idAddress)
{
string query = String.Format(
"INSERT INTO APPORDER(createDate,idProduct,idAddress) " + "VALUES('{0}','{1}','{2}');", order, idProduct, idAddress
);
ConectionDB.ExecuteNonQuery(query);
}
public static void DeleteAddress(int idAddress)
{
string query = String.Format(
"DELETE FROM ADDRESS WHERE idAddress='{0}';", idAddress
);
ConectionDB.ExecuteNonQuery(query);
}
public static void Address(int idUser, string address)
{
string query = String.Format(
"INSERT INTO ADDRESS(idUser,address)" + "VALUES('{0}', '{1}');", idUser, address
);
ConectionDB.ExecuteNonQuery(query);
}
public static void AddBusiness(string name, string description)
{
string query = String.Format(
"INSERT INTO BUSINESS(name, description) " + "VALUES('{0}','{1}'); ", name, description
);
ConectionDB.ExecuteNonQuery(query);
}
public static void EliminateOrder(int id)
{
string query = String.Format(
"DELETE FROM APPORDER WHERE idOrder = '{0}';", id
);
ConectionDB.ExecuteNonQuery(query);
}
private void btnRefreshDirection_Click(object sender, EventArgs e)
{
var aux = Convert.ToInt32(user.idUser);
string query = String.Format(
"SELECT idAddress, Address FROM ADDRESS WHERE idUser = '******';", aux);
var view = ConectionDB.ExecuteQuery(query);
dgvDirection.DataSource = view;
}
private void button3_Click(object sender, EventArgs e)
{
var aux = Convert.ToInt32(user.idUser);
string query = String.Format(
"SELECT ao.idOrder, ao.createDate, pr.name, au.fullname, ad.address" +
"FROM APPORDER ao, ADDRESS ad, PRODUCT pr, APPUSER au" +
"WHERE ao.idProduct = pr.idProduct" +
"AND ao.idAddress = ad.idAddress" +
"AND ad.'{0}' = au.'{0}';", aux);
var view = ConectionDB.ExecuteQuery(query);
dgvOrderUser.DataSource = view;
}
public static List <Address> getLista()
{
string query = "SELECT * FROM ADDRESS";
DataTable dt = ConectionDB.ExecuteQuery(query);
List <Address> list = new List <Address>();
foreach (DataRow row in dt.Rows)
{
Address a = new Address();
a.idAddress = Convert.ToInt32(row[0].ToString());
a.idUser = Convert.ToInt32(row[1].ToString());
a.address = row[2].ToString();
list.Add(a);
}
return(list);
}
public static List <Business> getLista()
{
string query = "SELECT * FROM BUSINESS";
DataTable dt = ConectionDB.ExecuteQuery(query);
List <Business> list = new List <Business>();
foreach (DataRow row in dt.Rows)
{
Business b = new Business();
b.idBusiness = Convert.ToInt32(row[0].ToString());
b.name = row[1].ToString();
b.description = row[2].ToString();
list.Add(b);
}
return(list);
}
public static List <appOrder> getLista()
{
string query = "SELECT * FROM APPORDER";
DataTable dt = ConectionDB.ExecuteQuery(query);
List <appOrder> list = new List <appOrder>();
foreach (DataRow row in dt.Rows)
{
appOrder ap = new appOrder();
ap.idOrder = Convert.ToInt32(row[0].ToString());
ap.createDate = Convert.ToDateTime(row[1].ToString());
ap.idProduct = Convert.ToInt32(row[2].ToString());
ap.idAddress = Convert.ToInt32(row[3].ToString());
list.Add(ap);
}
return(list);
}
public static List <appUser> getLista()
{
string query = "SELECT * FROM APPUSER";
DataTable dt = ConectionDB.ExecuteQuery(query);
List <appUser> list = new List <appUser>();
foreach (DataRow row in dt.Rows)
{
appUser au = new appUser();
au.idUser = Convert.ToInt32(row[0].ToString());
au.fullName = row[1].ToString();
au.userName = row[2].ToString();
au.password = row[3].ToString();
au.userType = Convert.ToBoolean(row[4].ToString());
list.Add(au);
}
return(list);
}
