public bool update_Profile()
{
try
{
cls_conection obj1 = new cls_conection();
SqlConnection myConnection = new SqlConnection(obj1.getConnection());
myConnection.Open();
if (myConnection.State == ConnectionState.Closed)
{
myConnection.Open();
}
SqlCommand oCmd = new SqlCommand("UPDATE Data_Admin SET first_name=@ffirst_name,last_name=@flast_name,number_phone=@fnumber_phone,country=@fcountry,city=@fcity,address=@faddress,zip_code=@fzip_code WHERE FK_ID_admin=@fkame", myConnection);
oCmd.Parameters.AddWithValue("@fkame", ID1);
oCmd.Parameters.AddWithValue("@ffirst_name", First_Name);
oCmd.Parameters.AddWithValue("@flast_name", Last_Name);
oCmd.Parameters.AddWithValue("@fnumber_phone", Number_Phone);
oCmd.Parameters.AddWithValue("@fcountry", Country);
oCmd.Parameters.AddWithValue("@fcity", City);
oCmd.Parameters.AddWithValue("@faddress", Address);
oCmd.Parameters.AddWithValue("@fzip_code", Zip_Code);
oCmd.ExecuteNonQuery();
myConnection.Close();
return(true);
}
catch (Exception ex)
{
msg = ex.ToString();
return(false);
//Response.Write("<script>alert('" + ex.Message + "');</script>");
}
}
public cls_operations_admin select_Profile(string fName)
{
cls_conection obj1 = new cls_conection();
cls_operations_admin matchingPerson = new cls_operations_admin(0, "", "", "", "", "", "", "");
using (SqlConnection myConnection = new SqlConnection(obj1.getConnection()))
{
string oString = "SELECT first_name,last_name,number_phone,country,city,address,zip_code FROM Data_Admin WHERE FK_ID_admin=@fName";
SqlCommand oCmd = new SqlCommand(oString, myConnection);
oCmd.Parameters.AddWithValue("@fname", fName);
myConnection.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
//I got problem getting the PRIMARY KEY and the FOREIGN KEY
//matchingPerson.Fk_id_cat = Int32.Parse(oReader["ID_prod"].ToString());
matchingPerson.First_Name = oReader["first_name"].ToString();
matchingPerson.Last_Name = oReader["last_name"].ToString();
matchingPerson.Number_Phone = oReader["number_phone"].ToString();
matchingPerson.Country = oReader["country"].ToString();
matchingPerson.City = oReader["city"].ToString();
matchingPerson.Address = oReader["address"].ToString();
matchingPerson.Zip_Code = oReader["zip_code"].ToString();
}
myConnection.Close();
}
}
return(matchingPerson);
}
public bool Delete(string id)
{
try
{
cls_conection obj1 = new cls_conection();
SqlConnection myConnection = new SqlConnection(obj1.getConnection());
myConnection.Open();
if (myConnection.State == ConnectionState.Closed)
{
myConnection.Open();
}
SqlCommand oCmd = new SqlCommand("DELETE FROM Products WHERE ID_prod=@fkame", myConnection);
oCmd.Parameters.AddWithValue("@fkame", id);
oCmd.ExecuteNonQuery();
myConnection.Close();
return(true);
}
catch (Exception ex)
{
msg = ex.ToString();
return(false);
}
}
public cls_operations_admin Select(string fName)
{
cls_conection obj1 = new cls_conection();
cls_operations_admin matchingPerson = new cls_operations_admin();
using (SqlConnection myConnection = new SqlConnection(obj1.getConnection()))
{
string oString = "Select name,brand,price,description,photo,current_stock from Products where ID_prod=@fName";
SqlCommand oCmd = new SqlCommand(oString, myConnection);
oCmd.Parameters.AddWithValue("@fname", fName);
myConnection.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
//I got problem getting the PRIMARY KEY and the FOREIGN KEY
//matchingPerson.Fk_id_cat = Int32.Parse(oReader["ID_prod"].ToString());
matchingPerson.Name = oReader["name"].ToString();
matchingPerson.Brand = oReader["brand"].ToString();
matchingPerson.Price = float.Parse(oReader["price"].ToString());
matchingPerson.Description = oReader["description"].ToString();
matchingPerson.Photo = oReader["photo"].ToString();
matchingPerson.Current_stock = Int32.Parse(oReader["current_stock"].ToString());
}
myConnection.Close();
}
}
return(matchingPerson);
}
public cls_operations_user select_Profile1(string fName)
{
cls_conection obj1 = new cls_conection();
cls_operations_user matchingPerson = new cls_operations_user(0, "", "", "", "");
using (SqlConnection myConnection = new SqlConnection(obj1.getConnection()))
{
string oString = "SELECT * FROM Billing_user WHERE FK_ID_user=@fName";
SqlCommand oCmd = new SqlCommand(oString, myConnection);
oCmd.Parameters.AddWithValue("@fname", fName);
myConnection.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
//I got problem getting the PRIMARY KEY and the FOREIGN KEY
//matchingPerson.Fk_id_cat = Int32.Parse(oReader["ID_prod"].ToString());
matchingPerson.Number = oReader["number"].ToString();
matchingPerson.type = oReader["type"].ToString();
matchingPerson.Date_end = oReader["date_end"].ToString();
matchingPerson.Code_security = oReader["code_security"].ToString();
}
myConnection.Close();
}
}
return(matchingPerson);
}
public bool Updatek()
{
try
{
cls_conection obj1 = new cls_conection();
SqlConnection myConnection = new SqlConnection(obj1.getConnection());
myConnection.Open();
if (myConnection.State == ConnectionState.Closed)
{
myConnection.Open();
}
SqlCommand oCmd = new SqlCommand(@"UPDATE Products set name=@fname,brand=@fbrand,price=@fprice,description=@fdescription,photo=@fphoto,current_stock=@fcurrent_stock where ID_prod=@fkame", myConnection);
oCmd.Parameters.AddWithValue("@fkame", ID);
oCmd.Parameters.AddWithValue("@fname", Name);
oCmd.Parameters.AddWithValue("@fbrand", Brand);
oCmd.Parameters.AddWithValue("@fprice", Price);
oCmd.Parameters.AddWithValue("@fdescription", Description);
oCmd.Parameters.AddWithValue("@fphoto", Photo);
oCmd.Parameters.AddWithValue("@fcurrent_stock", Current_stock);
oCmd.ExecuteNonQuery();
myConnection.Close();
return(true);
}
catch (Exception ex)
{
// Console.WriteLine(ex);
msg = ex.ToString();
return(false);
//Response.Write("<script>alert('" + ex.Message + "');</script>");
}
/*
* conectar(table);
* DataRow fila;
* if (Data.Tables[0].Rows.Count > 0)
* {
*
* }else if(Data.Tables[0].Rows.Count == 0)
* {
*
* } */
}