public void FinishShopping(string UserName) { SqlConnection con; try { con = connect(); da = new SqlDataAdapter(SQLQueries.FinishShopping(UserName), con); DataSet ds = new DataSet(); da.Fill(ds); } catch (Exception ex) { throw ex; } disconnect(con); }
public void DeleteProduct(string Product_list_id) { SqlConnection con; try { con = connect(); da = new SqlDataAdapter(SQLQueries.DeleteProduct(Product_list_id), con); DataSet ds = new DataSet(); da.Fill(ds); } catch (Exception ex) { throw ex; } disconnect(con); }
public void insertProductToList(Product p) { SqlConnection con; try { con = connect(); da = new SqlDataAdapter(SQLQueries.insertProductToList(p), con); DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables["Products"]; } catch (Exception ex) { throw ex; } disconnect(con); }
public DataTable GetLastPurchesd(Product p) { SqlConnection con; try { con = connect(); da = new SqlDataAdapter(SQLQueries.GetLastPurchesd(p), con); DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; } catch (Exception ex) { throw ex; } disconnect(con); return(dt); }
public DataTable CreateNewUser(List <string> UserDetailsList) { SqlConnection con; try { con = connect(); da = new SqlDataAdapter(SQLQueries.CreateNewUser(UserDetailsList), con); DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; } catch (Exception ex) { throw ex; } disconnect(con); return(dt); }
public DataTable getProducts() { SqlConnection con; try { con = connect(); da = new SqlDataAdapter(SQLQueries.getProducts(), con); DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; } catch (Exception ex) { Logger.writeToLog(LoggerLevel.ERROR, "page :DBServicesAPP.cs, function: getAnimalTypes(), exeption message: " + ex.Message); throw ex; } disconnect(con); return(dt); }
public DataTable getUserDedails(string UserName, string passwordString) { SqlConnection con; try { con = connect(); // open the connection to the database/ da = new SqlDataAdapter(SQLQueries.getUserDedails(UserName, passwordString), con); // create the data adapter DataSet ds = new DataSet(); da.Fill(ds); // Fill the datatable (in the dataset), using the Select command dt = ds.Tables[0]; // point to the cars table , which is the only table in this case } catch (Exception ex) { Logger.writeToLog(LoggerLevel.ERROR, "page :DBServicesAPP.cs, function: getVolonteerPass(), exeption message: " + ex.Message); throw ex; } disconnect(con); return(dt); }
public DataTable ShowShoppingList_byUserId(string UserId) { SqlConnection con; try { con = connect(); da = new SqlDataAdapter(SQLQueries.ShowShoppingList_byUserId(UserId), con); DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; } catch (Exception ex) { Logger.writeToLog(LoggerLevel.ERROR, "page :DBServicesAPP.cs, function: getVeg_ShoppingList(), exeption message: " + ex.Message); throw ex; } disconnect(con); return(dt); }