private Client CheckClient(Client client)
{
OpenConnection();
SqlCmd.CommandText = @"SELECT * FROM clients WHERE login = @login and password = @password";
SqlCmd.Parameters.Add(new SQLiteParameter("@login")
{
Value = client.Login
});
SqlCmd.Parameters.Add(new SQLiteParameter("@password")
{
Value = client.Password
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
if (reader.Read())
{
client = new Client(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetInt32(5), reader.GetString(6), reader.GetString(7), reader.GetString(8), reader.GetString(9),
reader.GetString(10), reader.GetDouble(11), reader.GetInt32(12));
reader.Close();
CloseConnection();
return(client);
}
else
{
return(null);
}
}
public List <Manufacturers> BindAllManufacturers()
{
List <Manufacturers> manufacturersListObj = new List <Manufacturers>();
using (SqlConnection)
{
SqlCmd.CommandText = "select ManufacturersID, ManufacturersName from Table_Manufacturers";
SqlConnection.Open();
SqlDataReader sqlDataReaderObj = SqlCmd.ExecuteReader();
if (sqlDataReaderObj.HasRows)
{
Int16 serial = 0;
while (sqlDataReaderObj.Read())
{
Manufacturers manufacturerObj = new Manufacturers();
manufacturerObj.SerialID = ++serial;
manufacturerObj.ManufacturerID = sqlDataReaderObj["ManufacturersID"].ToString();
manufacturerObj.ManufacturerName = sqlDataReaderObj["ManufacturersName"].ToString();
manufacturersListObj.Add(manufacturerObj);
}
}
sqlDataReaderObj.Close();
}
return(manufacturersListObj);
}
/**
* méthode qui lit dans la base de données tous les élèves
* retour : la liste de tous les élèves
*/
// ********* LISTER TOUS *******************
public override List <Rencontre> ListerTous()
{
List <Rencontre> liste = new List <Rencontre>();
try
{
SqlCmd.CommandText =
"select idr, phase, NumEquipe1, NumEquipe2, NumArbitre, NumTable, NumGagnant, score " +
"from rencontres " +
"order by idr asc ";
SqlCmd.Parameters.Clear();
SqlDataReader sqlReader = SqlCmd.ExecuteReader();
while (sqlReader.Read() == true)
{
liste.Add(new Rencontre(Convert.ToInt32(sqlReader["idr"]),
Convert.ToString(sqlReader["phase"]),
Convert.ToInt32(sqlReader["NumEquipe1"]),
Convert.ToInt32(sqlReader["NumEquipe2"]),
Convert.ToInt32(sqlReader["NumArbitre"]),
Convert.ToInt32(sqlReader["NumTable"]),
Convert.ToInt32(sqlReader["NumGagnant"]),
Convert.ToString(sqlReader["score"])));
}
sqlReader.Close();
}
catch (Exception e)
{
throw new ExceptionAccesBD(e.Message);
}
return(liste);
}
// ********** AJOUTER UN JOUEUR ************************
public override void Ajouter(Joueur obj)
{
try
{
int idj;
SqlCmd.CommandText = "select max(idj) + 1 from joueurs";
SqlCmd.Parameters.Clear();
SqlDataReader sqlReader = SqlCmd.ExecuteReader();
sqlReader.Read();
if (sqlReader[0] == DBNull.Value)
{
idj = 1;
}
else
{
idj = Convert.ToInt32(sqlReader[0]);
}
sqlReader.Close();
SqlCmd.CommandText =
"insert into joueurs(idj,nom,prenom,style,nomImage) " +
"values(@idj,@nom,@prenom,@style,@nomImage)";
SqlCmd.Parameters.Clear();
SqlCmd.Parameters.Add("@idj", SqlDbType.Int).Value = idj;
SqlCmd.Parameters.Add("@nom", SqlDbType.VarChar).Value = obj.Nom;
SqlCmd.Parameters.Add("@prenom", SqlDbType.VarChar).Value = obj.Prenom;
SqlCmd.Parameters.Add("@style", SqlDbType.VarChar).Value = obj.Style;
SqlCmd.Parameters.Add("@nomImage", SqlDbType.VarChar).Value = obj.NomImage;
SqlCmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw new ExceptionAccesBD(e.Message);
}
}
public void UpdateCashback(Client client, double cback)
{
double newCash;
if (cashback == 0.0)
{
newCash = cback;
}
else
{
newCash = client.Cashback + cback;
}
OpenConnection();
SqlCmd.CommandText = @"UPDATE clients SET cashback = @cashback WHERE client_id = @clientid";
SqlCmd.Parameters.Add(new SQLiteParameter("@cashback")
{
Value = newCash
});
SqlCmd.Parameters.Add(new SQLiteParameter("@clientid")
{
Value = client.Id
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
CloseConnection();
}
// ********* LISTER TOUS *******************
public override List <Arbitre> ListerTous()
{
List <Arbitre> liste = new List <Arbitre>();
try
{
SqlCmd.CommandText =
"select ida, nom, prenom, experience " +
"from arbitres " +
"order by ida asc ";
SqlCmd.Parameters.Clear();
SqlDataReader sqlReader = SqlCmd.ExecuteReader();
while (sqlReader.Read() == true)
{
liste.Add(new Arbitre(Convert.ToInt32(sqlReader["ida"]),
Convert.ToString(sqlReader["nom"]),
Convert.ToString(sqlReader["prenom"]),
Convert.ToInt32(sqlReader["experience"])));
}
sqlReader.Close();
}
catch (Exception e)
{
throw new ExceptionAccesBD(e.Message);
}
return(liste);
}
public Company GetCompanyById(int compId)
{
OpenConnection();
SqlCmd.CommandText = @"SELECT * FROM companies WHERE company_id = @companyId";
SqlCmd.Parameters.Add(new SQLiteParameter("@companyId")
{
Value = compId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
if (reader.Read())
{
Company comp = new Company(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetString(5), reader.GetString(6), reader.GetString(7));
reader.Close();
CloseConnection();
return(comp);
}
else
{
return(null);
}
}
public List <SubCatagory> BindSubCatagoryAccordingToSelectedMainCatagory(string selectedMainCatagoryID)
{
List <SubCatagory> subCatagoryListObj = new List <SubCatagory>();
using (SqlConnection)
{
SqlCmd.CommandText = "select SubCatagoryID, SubCatagoryName from Table_SubCatagory where MainCatagoryID = '" + selectedMainCatagoryID + "'";
SqlConnection.Open();
SqlDataReader sqlDataReaderObj = SqlCmd.ExecuteReader();
if (sqlDataReaderObj.HasRows)
{
while (sqlDataReaderObj.Read())
{
SubCatagory subCatagoryObj = new SubCatagory();
subCatagoryObj.SubCatagoryID = sqlDataReaderObj["SubCatagoryID"].ToString();
subCatagoryObj.SubCatagoryName = sqlDataReaderObj["SubCatagoryName"].ToString();
subCatagoryListObj.Add(subCatagoryObj);
}
}
sqlDataReaderObj.Close();
}
return(subCatagoryListObj);
}
public List <Manufacturers> BindAllManufacturers()
{
List <Manufacturers> manufacturersListObj = new List <Manufacturers>();
try
{
SqlCmd.CommandText = "select ManufacturersID, ManufacturersName from Table_Manufacturers";
SqlConnection.Open();
SqlDataReader sqldataReaderObj = SqlCmd.ExecuteReader();
if (sqldataReaderObj.HasRows)
{
while (sqldataReaderObj.Read())
{
Manufacturers manufacturersObj = new Manufacturers();
//manufacturersObj.ID = (int)sqldataReaderObj["ID"];
manufacturersObj.ManufacturerID = sqldataReaderObj["ManufacturersID"].ToString();
manufacturersObj.ManufacturerName = sqldataReaderObj["ManufacturersName"].ToString();
manufacturersListObj.Add(manufacturersObj);
}
}
sqldataReaderObj.Close();
}
catch (Exception ex)
{
}
finally
{
SqlConnection.Close();
}
return(manufacturersListObj);
}
// ********* LISTER TOUS *******************
public override List <Table> ListerTous()
{
List <Table> liste = new List <Table>();
try
{
SqlCmd.CommandText =
"select idt, position " +
"from tables " +
"order by idt asc ";
SqlCmd.Parameters.Clear();
SqlDataReader sqlReader = SqlCmd.ExecuteReader();
while (sqlReader.Read() == true)
{
liste.Add(new Table(Convert.ToInt32(sqlReader["idt"]),
Convert.ToInt32(sqlReader["position"])));
}
sqlReader.Close();
}
catch (Exception e)
{
throw new ExceptionAccesBD(e.Message);
}
return(liste);
}
/**
* // ********* LISTER TOUS *******************
*/
public override List <Joueur> ListerTous()
{
List <Joueur> liste = new List <Joueur>();
try
{
SqlCmd.CommandText =
"select idj, nom, prenom, style, nomImage " +
"from joueurs " +
"order by nom asc";
SqlCmd.Parameters.Clear();
SqlDataReader sqlReader = SqlCmd.ExecuteReader();
while (sqlReader.Read() == true)
{
liste.Add(new Joueur(Convert.ToInt32(sqlReader["idj"]),
Convert.ToString(sqlReader["nom"]),
Convert.ToString(sqlReader["prenom"]),
Convert.ToString(sqlReader["style"]),
Convert.ToString(sqlReader["nomImage"])));
}
sqlReader.Close();
}
catch (Exception e)
{
throw new ExceptionAccesBD(e.Message);
}
return(liste);
}
public void UpdateMoneyBox(Client client, double mbox)
{
double newCash;
if (mbox == 0.0)
{
newCash = mbox;
}
else
{
newCash = client.Moneybox + mbox;
}
OpenConnection();
SqlCmd.CommandText = @"UPDATE clients SET moneybox = @moneybox WHERE client_id = @clientid";
SqlCmd.Parameters.Add(new SQLiteParameter("@moneybox")
{
Value = newCash
});
SqlCmd.Parameters.Add(new SQLiteParameter("@clientid")
{
Value = client.Id
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
CloseConnection();
}
private Admin CheckAdmin(Admin admin)
{
OpenConnection();
SqlCmd.CommandText = @"SELECT * FROM admins WHERE password = @password";
SqlCmd.Parameters.Add(new SQLiteParameter("@password")
{
Value = admin.Password
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
if (reader.Read())
{
admin = new Admin(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetInt32(5), reader.GetString(6), reader.GetString(7), reader.GetString(8), reader.GetString(9));
reader.Close();
CloseConnection();
return(admin);
}
else
{
return(null);
}
}
public Client GetClientById(int clientId)
{
OpenConnection();
SqlCmd.CommandText = @"SELECT * FROM clients WHERE client_id = @clientId";
SqlCmd.Parameters.Add(new SQLiteParameter("@clientId")
{
Value = clientId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
if (reader.Read())
{
Client client = new Client(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetInt32(5), reader.GetString(6), reader.GetString(7), reader.GetString(8), reader.GetString(9),
reader.GetString(10), reader.GetDouble(11), reader.GetInt32(12));
reader.Close();
CloseConnection();
return(client);
}
else
{
return(null);
}
}
private Company CheckCompany(Company comp)
{
OpenConnection();
SqlCmd.CommandText = @"SELECT * FROM companies WHERE login = @login and password = @password";
SqlCmd.Parameters.Add(new SQLiteParameter("@login")
{
Value = comp.Login
});
SqlCmd.Parameters.Add(new SQLiteParameter("@password")
{
Value = comp.Password
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
if (reader.Read())
{
comp = new Company(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetString(5), reader.GetString(6), reader.GetString(7));
reader.Close();
CloseConnection();
return(comp);
}
else
{
return(null);
}
}
// ********** AJOUTER UNE EQUIPE ************************
public override void Ajouter(Equipe obj)
{
try
{
int ide;
SqlCmd.CommandText = "select max(ide) + 1 from equipe";
SqlCmd.Parameters.Clear();
SqlDataReader sqlReader = SqlCmd.ExecuteReader();
sqlReader.Read();
if (sqlReader[0] == DBNull.Value)
{
ide = 1;
}
else
{
ide = Convert.ToInt32(sqlReader[0]);
}
sqlReader.Close();
SqlCmd.CommandText =
"insert into equipe(ide,nom,joueur1,joueur2) " +
"values(@ide,@nom,@joueur1,@joueur2)";
SqlCmd.Parameters.Clear();
SqlCmd.Parameters.Add("@ide", SqlDbType.Int).Value = ide;
SqlCmd.Parameters.Add("@nom", SqlDbType.VarChar).Value = obj.Nom;
SqlCmd.Parameters.Add("@joueur1", SqlDbType.Int).Value = obj.Joueur1;
SqlCmd.Parameters.Add("@joueur2", SqlDbType.Int).Value = obj.Joueur2;
SqlCmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw new ExceptionAccesBD(e.Message);
}
}
/**
* méthode qui lit dans la base de données tous les élèves
* retour : la liste de tous les élèves
*/
// ********* LISTER TOUS *******************
public override List <Equipe> ListerTous()
{
List <Equipe> liste = new List <Equipe>();
try
{
SqlCmd.CommandText =
"select ide, nom, joueur1, joueur2 " +
"from equipe " +
"order by ide asc ";
SqlCmd.Parameters.Clear();
SqlDataReader sqlReader = SqlCmd.ExecuteReader();
while (sqlReader.Read() == true)
{
liste.Add(new Equipe(Convert.ToInt32(sqlReader["ide"]),
Convert.ToString(sqlReader["nom"]),
Convert.ToInt32(sqlReader["joueur1"]),
Convert.ToInt32(sqlReader["joueur2"])));
}
sqlReader.Close();
}
catch (Exception e)
{
throw new ExceptionAccesBD(e.Message);
}
return(liste);
}
public List <CatagotyViewModel> BindAllMainCatagoryAndSubCatagoty()
{
List <CatagotyViewModel> catagoryViewModelListObj = new List <CatagotyViewModel>();
//try
//{
using (SqlConnection)
{
SqlCmd.CommandText = "select *from vwCatagoryWithSubCatagory";
SqlConnection.Open();
SqlDataReader sqlDataReaderObj = SqlCmd.ExecuteReader();
if (sqlDataReaderObj.HasRows)
{
Int16 serial = 0;
while (sqlDataReaderObj.Read())
{
CatagotyViewModel catagoryViewModelObj = new CatagotyViewModel();
catagoryViewModelObj.SerialID = ++serial;
catagoryViewModelObj.SubCatagoryID = sqlDataReaderObj["SubCatagoryID"].ToString();
catagoryViewModelObj.SubCatagoryName = sqlDataReaderObj["SubCatagoryName"].ToString();
catagoryViewModelObj.MainCatagoryID = sqlDataReaderObj["CatagoryID"].ToString();
catagoryViewModelObj.MainCatagoryName = sqlDataReaderObj["CatagoryName"].ToString();
catagoryViewModelListObj.Add(catagoryViewModelObj);
}
}
sqlDataReaderObj.Close();
}
return(catagoryViewModelListObj);
}
public Card GetCurrentCard(Card card)
{
OpenConnection();
SqlCmd.CommandText = @"SELECT * FROM cards WHERE cardnumber = @cardnumber";
SqlCmd.Parameters.Add(new SQLiteParameter("@cardnumber")
{
Value = card.CardNumber
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
if (reader.Read())
{
card = new Card(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3),
reader.GetInt32(4), reader.GetString(5), reader.GetString(6), reader.GetInt32(7), reader.GetInt32(8), CheckConfirm(reader.GetInt32(9)));
reader.Close();
CloseConnection();
return(card);
}
else
{
return(null);
}
}
public List <MainCatagory> GetAllMainCatagory()
{
List <MainCatagory> mainCatagoryListObj = new List <MainCatagory>();
using (SqlConnection)
{
SqlCmd.CommandText = "select CatagoryID, CatagoryName from Table_Catagory";
SqlConnection.Open();
SqlDataReader sqldataReaderObj = SqlCmd.ExecuteReader();
if (sqldataReaderObj.HasRows)
{
while (sqldataReaderObj.Read())
{
MainCatagory mainCatagoryObj = new MainCatagory();
mainCatagoryObj.CatagoryID = sqldataReaderObj["CatagoryID"].ToString();
mainCatagoryObj.CatagoryName = sqldataReaderObj["CatagoryName"].ToString();
mainCatagoryListObj.Add(mainCatagoryObj);
}
}
sqldataReaderObj.Close();
}
return(mainCatagoryListObj);
}
public void DeleteSelectedCard(int cardId)
{
OpenConnection();
SqlCmd.CommandText = @"DELETE FROM cards WHERE card_id = @smthid";
SqlCmd.Parameters.Add(new SQLiteParameter("@smthid")
{
Value = cardId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader = SqlCmd.ExecuteReader();
CloseConnection();
}
public void DeleteSelectedDeposit(int depositId)
{
OpenConnection();
SqlCmd.CommandText = @"DELETE FROM deposits WHERE deposit_id = @smthid";
SqlCmd.Parameters.Add(new SQLiteParameter("@smthid")
{
Value = depositId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
CloseConnection();
}
private void DeleteRequest(int req_id)
{
OpenConnection();
SqlCmd.CommandText = @"DELETE FROM requests WHERE request_id = @reqId";
SqlCmd.Parameters.Add(new SQLiteParameter("@reqId")
{
Value = req_id
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
CloseConnection();
}
//333333333333333
public List <ProductViewThumbnail> BindAllProductInfo()
{
List <ProductViewThumbnail> productDetailViewListtObj = new List <ProductViewThumbnail>();
try
{
SqlCmd.CommandText = "spSelectProductsViewInfo";
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlConnection.Open();
SqlDataReader sqldataReaderObj = SqlCmd.ExecuteReader();
if (sqldataReaderObj.HasRows)
{
while (sqldataReaderObj.Read())
{
ProductViewThumbnail productDetailViewThumbnailObj = new ProductViewThumbnail();
productDetailViewThumbnailObj.ProductID = sqldataReaderObj["ProductID"].ToString();
productDetailViewThumbnailObj.ManufacturerID = sqldataReaderObj["ManufacturersName"].ToString();
productDetailViewThumbnailObj.ProductPrice = (int)sqldataReaderObj["ProductPrice"];
productDetailViewThumbnailObj.ProductDiscountPrice = (int)sqldataReaderObj["ProductDiscountPrice"];
productDetailViewThumbnailObj.ProductImageID = sqldataReaderObj["ProductImageID"].ToString();
productDetailViewThumbnailObj.ProductImageNameExtention = sqldataReaderObj["ProductImageNameExtention"].ToString();
productDetailViewThumbnailObj.RAM = sqldataReaderObj["RAM"].ToString();
productDetailViewThumbnailObj.CPU = sqldataReaderObj["CPU"].ToString();
productDetailViewThumbnailObj.Chipset = sqldataReaderObj["Chipset"].ToString();
productDetailViewThumbnailObj.PrimaryCamera = sqldataReaderObj["PrimaryCamera"].ToString();
productDetailViewThumbnailObj.SecondryCamera = sqldataReaderObj["SecondryCamera"].ToString();
productDetailViewThumbnailObj.OS = sqldataReaderObj["OS"].ToString();
productDetailViewThumbnailObj.ProductColor = sqldataReaderObj["ProductColor"].ToString();
productDetailViewThumbnailObj.ProductFreeDeliveryStatus = sqldataReaderObj["ProductFreeDeliveryStatus"].ToString();
productDetailViewThumbnailObj.Product30DaysReturnStatus = sqldataReaderObj["Product30DaysReturnStatus"].ToString();
productDetailViewThumbnailObj.ProductQuantity = sqldataReaderObj["ProductQuantity"].ToString();
productDetailViewListtObj.Add(productDetailViewThumbnailObj);
}
}
sqldataReaderObj.Close();
}
catch (Exception ex)
{
}
finally
{
SqlConnection.Close();
}
return(productDetailViewListtObj);
}
public void DeleteSelectedItem(string descr, int smthId, int reqId)
{
OpenConnection();
if (descr == null)
{
throw new ArgumentNullException(nameof(descr));
}
if (descr.Contains("credit"))
{
SqlCmd.CommandText = @"DELETE FROM credits WHERE credit_id = @smthid";
SqlCmd.Parameters.Add(new SQLiteParameter("@smthid")
{
Value = smthId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
}
else if (descr.Contains("deposit"))
{
SqlCmd.CommandText = @"DELETE FROM deposits WHERE deposit_id = @smthid";
SqlCmd.Parameters.Add(new SQLiteParameter("@smthid")
{
Value = smthId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
}
else if (descr.Contains("card"))
{
SqlCmd.CommandText = @"DELETE FROM cards WHERE card_id = @smthid";
SqlCmd.Parameters.Add(new SQLiteParameter("@smthid")
{
Value = smthId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
}
CloseConnection();
DeleteRequest(reqId);
}
public void UpdateLogin(string data, Client client)
{
OpenConnection();
SqlCmd.CommandText = @"UPDATE clients SET login = @login WHERE client_id = @clientid";
SqlCmd.Parameters.Add(new SQLiteParameter("@login")
{
Value = data
});
SqlCmd.Parameters.Add(new SQLiteParameter("@clientid")
{
Value = client.Id
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
CloseConnection();
}
public void UpdateCardMoney(Card card, int moneyg)
{
OpenConnection();
SqlCmd.CommandText = @"UPDATE cards SET money = @money WHERE card_id = @cardid";
SqlCmd.Parameters.Add(new SQLiteParameter("@money")
{
Value = moneyg
});
SqlCmd.Parameters.Add(new SQLiteParameter("@cardid")
{
Value = card.Id
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
CloseConnection();
}
public List <ProductViewThumbnail> SearchProductByProductName(string searchedItem)
{
List <ProductViewThumbnail> productViewThumbnailListObj = new List <ProductViewThumbnail>();
using (SqlConnection)
//try
{
SqlCmd.CommandText = "spSearchProductByProductName";
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@SearchItem", searchedItem);
SqlConnection.Open();
SqlDataReader sqldataReaderObj = SqlCmd.ExecuteReader();
if (sqldataReaderObj.HasRows)
{
while (sqldataReaderObj.Read())
{
ProductViewThumbnail productViewThumbnailObj = new ProductViewThumbnail();
productViewThumbnailObj.ProductID = sqldataReaderObj["ProductID"].ToString();
productViewThumbnailObj.ManufacturerID = sqldataReaderObj["ManufacturersName"].ToString();
productViewThumbnailObj.ProductPrice = (int)sqldataReaderObj["ProductPrice"];
productViewThumbnailObj.ProductDiscountPrice = (int)sqldataReaderObj["ProductDiscountPrice"];
productViewThumbnailObj.ProductImageID = sqldataReaderObj["ProductImageID"].ToString();
productViewThumbnailObj.ProductImageNameExtention = sqldataReaderObj["ProductImageNameExtention"].ToString();
//productViewThumbnailObj.ProductID = sqldataReaderObj["ProductID"].ToString();
productViewThumbnailListObj.Add(productViewThumbnailObj);
}
}
sqldataReaderObj.Close();
}
//catch (Exception ex)
//{
//}
//finally
//{
// SqlConnection.Close();
//}
return(productViewThumbnailListObj);
}
public void ParseDescription(string descr, int smthId, int reqId)
{
OpenConnection();
if (descr.Contains("credit"))
{
SqlCmd.CommandText = @"UPDATE credits SET isConfirm = 1 WHERE credit_id = @smthid";
SqlCmd.Parameters.Add(new SQLiteParameter("@smthid")
{
Value = smthId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
}
else if (descr.Contains("deposit"))
{
SqlCmd.CommandText = @"UPDATE deposits SET isConfirm = 1 WHERE deposit_id = @smthid";
SqlCmd.Parameters.Add(new SQLiteParameter("@smthid")
{
Value = smthId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
}
else if (descr.Contains("card"))
{
SqlCmd.CommandText = @"UPDATE cards SET isConfirm = 1 WHERE card_id = @smthid";
SqlCmd.Parameters.Add(new SQLiteParameter("@smthid")
{
Value = smthId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
}
CloseConnection();
DeleteRequest(reqId);
}
public void DeleteSelectedItem(int smthId, string descr)
{
OpenConnection();
if (descr.Contains("credit"))
{
SqlCmd.CommandText = @"DELETE FROM credits WHERE credit_id = @smthid";
SqlCmd.Parameters.Add(new SQLiteParameter("@smthid")
{
Value = smthId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
}
else if (descr.Contains("deposit"))
{
SqlCmd.CommandText = @"DELETE FROM deposits WHERE deposit_id = @smthid";
SqlCmd.Parameters.Add(new SQLiteParameter("@smthid")
{
Value = smthId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
}
else if (descr.Contains("card"))
{
SqlCmd.CommandText = @"DELETE FROM cards WHERE card_id = @smthid";
SqlCmd.Parameters.Add(new SQLiteParameter("@smthid")
{
Value = smthId
});
SqlCmd.ExecuteNonQuery();
SQLiteDataReader reader;
reader = SqlCmd.ExecuteReader();
reader.Close();
}
CloseConnection();
}
