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(); }