//look up public List <ClubMember> ClubMemberStringQuery(stringFields field, string value) { if (field == stringFields.memberID) { return(clubMember_Linq_DAL.clubMemberIDQuery(Convert.ToInt32(value))); } else if (field == stringFields.teudatZehute) { return(clubMember_Linq_DAL.clubMemberTeudatZehuteQuery(Convert.ToInt32(value))); } else if (field == stringFields.firstName) { return(clubMember_Linq_DAL.clubMemberFirstNameQuery(value)); } else if (field == stringFields.lastName) { return(clubMember_Linq_DAL.clubMemberLastNameQuery(value)); } else if (field == stringFields.gender) { return(clubMember_Linq_DAL.clubMemberGenderQuery((Gender)Enum.Parse(typeof(Gender), value))); } else { Console.WriteLine("WORNG SEARCH PARAMETERS"); return(null); } }
/********************************************************************************************************/ /******************************************* QUERYS *************************************************/ /* * the following methods direct the query according to stringFields / rangeFields field variable's value */ //look up public List <Employee> employeeStringQuery(stringFields field, string value, List <Employee> listE = null) { if (field == stringFields.teudatZehute) { return(employee_Linq_DAL.employeeIDQuery(Convert.ToInt32(value), listE)); } else if (field == stringFields.departmentID) { return(employee_Linq_DAL.employeeDPIDQuery(Convert.ToInt32(value), listE)); } else if (field == stringFields.supervisorID) { return(employee_Linq_DAL.employeeSupervisorIDQuery(Convert.ToInt32(value), listE)); } else if (field == stringFields.firstName) { return(employee_Linq_DAL.employeeFirstNameQuery(value, listE)); } else if (field == stringFields.lastName) { return(employee_Linq_DAL.employeeLastNameQuery(value, listE)); } else if (field == stringFields.gender) { return(employee_Linq_DAL.employeeGenderQuery((Gender)Enum.Parse(typeof(Gender), value), listE)); } else { Console.WriteLine("WORNG SEARCH PARAMETERS"); return(null); } }
public List <Product> productStringQuery(stringFields field, string value, List <Product> listP = null) { if (field == stringFields.inventoryID) { return(product_Linq_DAL.productInventoryIDQuery(Convert.ToInt32(value), listP)); } else if (field == stringFields.location) { return(product_Linq_DAL.productLocationQuery(Convert.ToInt32(value), listP)); } else if (field == stringFields.name) { return(product_Linq_DAL.productNameQuery(value, listP)); } else if (field == stringFields.type) { return(product_Linq_DAL.productTypeQuery((Backend.Type)Enum.Parse(typeof(Backend.Type), value), listP)); } else if (field == stringFields.inStock) { return(product_Linq_DAL.productInStockQuery((InStock)Enum.Parse(typeof(InStock), value), listP)); } else { Console.WriteLine("WORNG SEARCH PARAMETERS"); return(null); } }
/********************************************* <END> ADD/REMOVE/EDIT <END> ****************************************************/ /*********************************************************** QUERYS **************************************************************/ /********* STRING QUERY ***********/ /* * will direct the query requested to the correct function in the this.itsDAL interface * and return a list containing the query results: * all the club members where field equals value */ public List <ClubMember> queryByString(stringFields field, string value) { if (field == stringFields.firstName || field == stringFields.lastName || field == stringFields.memberID || field == stringFields.teudatZehute || field == stringFields.gender) { return(itsDAL.ClubMemberStringQuery(field, value)); } Console.WriteLine("WORNG SEARCH PARAMETERS"); return(null); }
/****************************** <END> ADD/REMOVE/EDIT <END> ***********************************/ /**************************************** QUERYS ************************************************/ /******** STRING QUERY *********/ /* * will direct the query requested to the correct function in the this.itsDAL interface * and return a list containing the query results: * a list of all the transactions where field equals value */ public List <Transaction> queryByString(stringFields field, string value) { if (field == stringFields.transactionID || field == stringFields.is_A_Return || field == stringFields.paymentMethod) { return(itsDAL.transactionStringQuery(field, value)); } Console.WriteLine("WRONG SEARCH PARAMETERS"); return(null); }
/************************************* QUERYS *******************************************/ /******* STRING QUERY ********/ /* * will direct the query requested to the correct function in the this.itsDAL interface * and return a list containing the query results: * all departments where field equals value */ public List <Department> queryByString(stringFields field, string value) { if (field == stringFields.departmentID || field == stringFields.name) { return(itsDAL.departmentStringQuery(field, value)); } Console.WriteLine("WRONG SEARCH PARAMETERS"); return(null); }
/****************************** <END> ADD/REMOVE/EDIT <END> **********************************/ /*************************************** QUERYS *****************************************/ /*********** STRING QUERY ***************/ /* * will direct the query requested to the correct function in the this.itsDAL interface * and return a list containing the query results: * a list of all the users where field equals value */ public List <User> queryByString(stringFields field, string value) { if (field == stringFields.userName) { return(itsDAL.userStringQuery(field, value)); } Console.WriteLine("WRONG SEARCH PARAMETERS"); return(null); }
/*************************************** <END> ADD/REMOVE/EDIT <END> **************************************/ /************************************************ QUERYS ******************************************************/ /********** STRING QUERY ***********/ /* * will direct the query requested to the correct function in the this.itsDAL interface * and return a list containing the query results: * a list of all the products where field equals value */ public List <Product> queryByString(stringFields field, string value, List <Product> listP = null) { if (field == stringFields.name || field == stringFields.type || field == stringFields.inventoryID || field == stringFields.location || field == stringFields.inStock) { List <Product> tempPList = itsDAL.productStringQuery(field, value, listP); EmphsizeTopSeller(tempPList); return(tempPList); } Console.WriteLine("WRONG SEARCH PARAMETERS"); return(null); }
//look up public List <User> userStringQuery(stringFields field, string value) { if (field == stringFields.userName) { return(user_Linq_DAL.userNameQuery(value)); } else { Console.WriteLine("WORNG SEARCH PARAMETERS"); return(null); } }
/******************************* <END> ADD/EDIT/REMOVE <END> ******************************************/ /************************************* QUERYS ***************************************/ /********** STRING QUERY **************/ /* * will direct the query requested to the correct function in the this.itsDAL interface * and return a list containing the query results: * a list of all the employees where field equals value */ public List <Employee> queryByString(stringFields field, string value, List <Employee> list = null) { if (field == stringFields.teudatZehute || field == stringFields.firstName || field == stringFields.lastName || field == stringFields.departmentID || field == stringFields.supervisorID || field == stringFields.gender) { if (list == null) { return(itsDAL.employeeStringQuery(field, value, list)); } } Console.WriteLine("WRONG SEARCH PARAMETERS"); return(null); }
//look up public List <Department> departmentStringQuery(stringFields field, string value) { if (field == stringFields.name) { return(department_Linq_DAL.departmentNameQuery(value)); } else if (field == stringFields.departmentID) { return(department_Linq_DAL.departmentIDQuery(Convert.ToInt32(value))); } else { Console.WriteLine("WORNG SEARCH PARAMETERS"); return(null); } }
/********** STRING QUERY ************/ /* * will direct the query requested to the correct function according to the instance of clas (recieved in function) * and return a list containing the query results: * a list of objects where: field == Value */ public List <object> queryByString(Classes clas, stringFields field, string value, List <object> listO = null) { if (clas == Classes.ClubMember) { return(clubMember_bl.queryByString(field, value).Cast <object>().ToList()); } else if (clas == Classes.Department) { return(department_bl.queryByString(field, value).Cast <object>().ToList()); } else if (clas == Classes.Employee) { if (listO != null) { return(employee_bl.queryByString(field, value, listO.Cast <Employee>().ToList()).Cast <object>().ToList()); } else { return(employee_bl.queryByString(field, value).Cast <object>().ToList()); } } else if (clas == Classes.Product) { if (listO != null) { return(prod_bl.queryByString(field, value, listO.Cast <Product>().ToList()).Cast <object>().ToList()); } else { return(prod_bl.queryByString(field, value).Cast <object>().ToList()); } } else if (clas == Classes.Transaction) { return(transaction_bl.queryByString(field, value).Cast <object>().ToList()); } else if (clas == Classes.User) { return(user_bl.queryByString(field, value).Cast <object>().ToList()); } else { Console.WriteLine("WRONG SEARCH PARAMETERS"); return(null); } }
//look up public List <Transaction> transactionStringQuery(stringFields field, string value) { if (field == stringFields.transactionID) { return(transaction_Linq_DAL.transactionIDQuery(Convert.ToInt32(value))); } else if (field == stringFields.is_A_Return) { return(transaction_Linq_DAL.transactionIsAReturnQuery(Convert.ToBoolean(value))); } else if (field == stringFields.paymentMethod) { return(transaction_Linq_DAL.transactionPaymentMethodQuery((PaymentMethod)Enum.Parse(typeof(PaymentMethod), value))); } else { Console.WriteLine("WORNG SEARCH PARAMETERS"); return(null); } }