//retrieve products of a manufacturer from database public List <ProductProperties> getManufacturerProductsList(ProductProperties manufacturer) { DataSet resultDataset; List <ProductProperties> manufacturerProducts = new List <ProductProperties>(); try { string selectQueryString = "SELECT PRODUCT.PRODUCT_ID,PRODUCT_TYPE,PRODUCT.PRODUCT_NAME,PRODUCT.PRODUCT_CURRENT_COUNT,PRODUCT.PRICE_PER_UNIT,PRODUCT.MINIMUM_COUNT,MANUFACTURER.MANUFACTURER_ID, MANUFACTURER.MANUFACTURER_NAME,MANUFACTURER_DETAIL FROM PRODUCT INNER JOIN MANUFACTURER ON PRODUCT.MANUFACTURER_ID = MANUFACTURER.MANUFACTURER_ID WHERE MANUFACTURER.MANUFACTURER_ID = @MANFACTURERID ORDER BY MANUFACTURER.MANUFACTURER_NAME;"; List <KeyValuePair <string, string> > tableQueryData = new List <KeyValuePair <string, string> >(); tableQueryData.Add(new KeyValuePair <string, string>("@MANFACTURERID", manufacturer.Manufacturer_Id)); resultDataset = DatabaseConnectionHandler.executeSelectQuery(selectQueryString, tableQueryData); }catch (Exception ex) { Console.WriteLine(ex.StackTrace); } return(manufacturerProducts); }
//reduce product count based on order item count when customer submitting the order public bool reduceProductCount(List <ProductProperties> productInfo) { string updateQueryString = "UPDATE PRODUCT SET PRODUCT_CURRENT_COUNT=PRODUCT_CURRENT_COUNT-@ORDER_COUNT WHERE PRODUCT_ID=@PRODUCTID"; bool result = false; foreach (ProductProperties props in productInfo) { List <KeyValuePair <string, string> > tableQueryData = new List <KeyValuePair <string, string> >(); string key = props.Product_Id; int value = props.Product_Current_Count; tableQueryData.Add(new KeyValuePair <string, string>("@ORDER_COUNT", value.ToString())); tableQueryData.Add(new KeyValuePair <string, string>("@PRODUCTID", key.ToString())); result = DatabaseConnectionHandler.executeUpdateQuery(updateQueryString, tableQueryData); } return(result); }
//Deactivating vendor from vendor table, with this method respective vendor users profile also deactivated public bool removeCustomerInfo(CustomerProperties oldVendorInfo, string userInfo) { string updateQueryString = null; bool result = false; if (oldVendorInfo.Vendor_Id != null) { updateQueryString = "UPDATE VENDOR SET VENDOR_STATUS='INACTIVE',MODIFIED_BY=@MODIFIED_BY,MODIFIED_DATE=@MODIFIED_DATE WHERE VENDOR_ID=@VENDOR_ID;"; List <KeyValuePair <string, string> > tableParameters = new List <KeyValuePair <string, string> >(); tableParameters.Add(new KeyValuePair <string, string>("@VENDOR_ID", oldVendorInfo.Vendor_Id)); tableParameters.Add(new KeyValuePair <string, string>("@MODIFIED_BY", userInfo)); tableParameters.Add(new KeyValuePair <string, string>("@MODIFIED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); result = DatabaseConnectionHandler.executeUpdateQuery(updateQueryString, tableParameters); } return(result); }
//Modify the single user profile public bool updateUserInfo(UserInformationProperties userInfo) { string updateQueryString = null; bool result = false; List <KeyValuePair <string, string> > tableQueryData = new List <KeyValuePair <string, string> >(); if ((userInfo.Address != null) && (userInfo.Contact != null) && (userInfo.EMail_Id != null)) { updateQueryString = "UPDATE USER_TABLE SET ADDRESS=@ADDRESS,CONTACT=@CONTACT,EMAIL_ID=@EMAIL_ID WHERE USER_ID=@USER_ID;"; tableQueryData.Add(new KeyValuePair <string, string>("@ADDRESS", userInfo.Address)); tableQueryData.Add(new KeyValuePair <string, string>("@CONTACT", userInfo.Contact)); tableQueryData.Add(new KeyValuePair <string, string>("@EMAIL_ID", userInfo.EMail_Id)); tableQueryData.Add(new KeyValuePair <string, string>("@USER_ID", userInfo.User_Id)); result = DatabaseConnectionHandler.executeUpdateQuery(updateQueryString, tableQueryData); } return(result); }
//deactive/remove the manufacturer from database public bool deActivateManufacturer(ManufacturerProperties manufacturerProperties, string userInfo) { bool result = false; try { string updateQueryString = "UPDATE MANUFACTURER SET MANUFACTURER_STATUS=@STATUS,MODIFIED_BY=@MODIFIED_BY,MODIFIED_DATE=@MODIFIED_DATE WHERE MANUFACTURER_ID=@MANUFACTURER_ID"; List <KeyValuePair <string, string> > tableQueryData = new List <KeyValuePair <string, string> >(); tableQueryData.Add(new KeyValuePair <string, string>("@STATUS", manufacturerProperties.Manufacturer_Status)); tableQueryData.Add(new KeyValuePair <string, string>("@MANUFACTURER_ID", manufacturerProperties.Manufacturer_Id)); tableQueryData.Add(new KeyValuePair <string, string>("@MODIFIED_BY", userInfo)); tableQueryData.Add(new KeyValuePair <string, string>("@MODIFIED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); result = DatabaseConnectionHandler.executeUpdateQuery(updateQueryString, tableQueryData); }catch (Exception ex) { Console.WriteLine(ex.StackTrace); } return(result); }
//Add new discount information in discount table public bool addNewDiscountRate(DiscountProperties discountInfo, string UserInfo) { bool result = false; if (discountInfo != null) { string insertQueryString = "INSERT INTO DISCOUNT(DISCOUNT_ID,DISCOUNT_RATE,CREATED_BY,CREATED_DATE,MODIFY_BY,MODIFY_DATE) VALUES (@DISCOUNT_ID,@DISCOUNT_RATE,@CREATED_BY,@CREATED_DATE,@MODIFY_BY,@MODIFY_DATE)"; List <KeyValuePair <string, string> > tableParameter = new List <KeyValuePair <string, string> >(); tableParameter.Add(new KeyValuePair <string, string>("@DISCOUNT_ID", discountInfo.Discount_Id)); tableParameter.Add(new KeyValuePair <string, string>("@DISCOUNT_RATE", discountInfo.Discount_Rate)); tableParameter.Add(new KeyValuePair <string, string>("@CREATED_BY", UserInfo)); tableParameter.Add(new KeyValuePair <string, string>("@CREATED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); tableParameter.Add(new KeyValuePair <string, string>("@MODIFY_BY", UserInfo)); tableParameter.Add(new KeyValuePair <string, string>("@MODIFY_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); result = DatabaseConnectionHandler.executeInsertDbQuery(insertQueryString, tableParameter); } return(result); }
//Retrieve multiple user information from database public List <UserInformationProperties> getMultipleUserInfo(string userStatus) { DataSet dataset = new DataSet(); List <UserInformationProperties> usersList = new List <UserInformationProperties>(); string selectQueryString = null; if (userStatus.Equals("ALL")) { selectQueryString = "SELECT NAME,CONTACT,ADDRESS,EMAIL_ID,USER_ID,ROLE,IS_VENDOR,VENDOR_ID,VENDOR_NAME,STATUS,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE FROM USER_TABLE"; dataset = DatabaseConnectionHandler.executeSelectQuery(selectQueryString, null); } else { selectQueryString = "SELECT NAME,CONTACT,ADDRESS,EMAIL_ID,ROLE,USER_ID,IS_VENDOR,VENDOR_ID,VENDOR_NAME,STATUS,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE FROM USER_TABLE WHERE STATUS=@STATUS"; List <KeyValuePair <string, string> > tableQueryData = new List <KeyValuePair <string, string> >(); tableQueryData.Add(new KeyValuePair <string, string>("@STATUS", userStatus)); dataset = DatabaseConnectionHandler.executeSelectQuery(selectQueryString, tableQueryData); } if (dataset != null) { foreach (DataRow row in dataset.Tables[0].Rows) { UserInformationProperties userinformation = new UserInformationProperties(); userinformation.Name = row["Name"].ToString(); userinformation.Contact = row["Contact"].ToString(); userinformation.Address = row["Address"].ToString(); userinformation.EMail_Id = row["Email_id"].ToString(); userinformation.User_Id = row["User_Id"].ToString(); userinformation.Role = row["Role"].ToString(); userinformation.Is_Vendor = row["Is_Vendor"].ToString(); userinformation.Vendor_ID = row["Vendor_Id"].ToString(); userinformation.Vendor_Name = row["Vendor_Name"].ToString(); userinformation.Status = row["Status"].ToString(); userinformation.Created_By = row["Created_By"].ToString(); userinformation.Created_date = row["Created_date"].ToString(); userinformation.Modified_By = row["Modified_By"].ToString(); userinformation.Modified_Date = row["Modified_Date"].ToString(); usersList.Add(userinformation); } } return(usersList); }
//Add new manufacturer in inventory public bool addNewManufacturer(ManufacturerProperties manufacturerInfo, string userInfo) { bool result = false; try { string insertNewManufacturerQuery = "INSERT INTO MANUFACTURER(MANUFACTURER_ID,MANUFACTURER_NAME,MANUFACTURER_DETAIL,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,MANUFACTURER_STATUS) VALUES(@MANUFACTURER_ID,@MANUFACTURER_NAME,@MANUFACTURER_DETAIL,@CREATED_BY,@CREATED_DATE,@MODIFIED_BY,@MODIFIED_DATE,@MANUFACTURER_STATUS)"; List <KeyValuePair <string, string> > tableQueryData = new List <KeyValuePair <string, string> >(); tableQueryData.Add(new KeyValuePair <string, string>("@MANUFACTURER_ID", manufacturerInfo.Manufacturer_Id)); tableQueryData.Add(new KeyValuePair <string, string>("@MANUFACTURER_NAME", manufacturerInfo.Manufacturer_Name)); tableQueryData.Add(new KeyValuePair <string, string>("@MANUFACTURER_DETAIL", manufacturerInfo.Manufacturer_Detail)); tableQueryData.Add(new KeyValuePair <string, string>("@CREATED_BY", userInfo)); tableQueryData.Add(new KeyValuePair <string, string>("@CREATED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); tableQueryData.Add(new KeyValuePair <string, string>("@MODIFIED_BY", userInfo)); tableQueryData.Add(new KeyValuePair <string, string>("@MODIFIED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); tableQueryData.Add(new KeyValuePair <string, string>("@MANUFACTURER_STATUS", manufacturerInfo.Manufacturer_Status)); result = DatabaseConnectionHandler.executeInsertDbQuery(insertNewManufacturerQuery, tableQueryData); }catch (Exception ex) { Console.WriteLine(ex.StackTrace); } return(result); }
//updating information in vendor profile public bool modifyCustomerInfo(CustomerProperties existingVendorInfo, string userInfo) { string updateQueryString = null; bool result = false; List <KeyValuePair <string, string> > tableParameters = new List <KeyValuePair <string, string> >(); if ((existingVendorInfo.Vendor_Address != null) && (existingVendorInfo.Vendor_Contact != null) && (existingVendorInfo.Vendor_EMail_Id != null)) { updateQueryString = "UPDATE VENDOR SET VENDOR_ADDRESS=@VENDOR_ADDRESS,VENDOR_CONTACT=@VENDOR_CONTACT,VENDOR_EMAIL_ID=@VENDOR_EMAIL_ID,MODIFIED_BY=@MODIFIED_BY,MODIFIED_DATE=@MODIFIED_DATE,VENDOR_STATUS=@VENDOR_STATUS WHERE VENDOR_ID=@VENDOR_ID;"; tableParameters.Add(new KeyValuePair <string, string>("@VENDOR_ADDRESS", existingVendorInfo.Vendor_Address)); tableParameters.Add(new KeyValuePair <string, string>("@VENDOR_CONTACT", existingVendorInfo.Vendor_Contact)); tableParameters.Add(new KeyValuePair <string, string>("@VENDOR_EMAIL_ID", existingVendorInfo.Vendor_EMail_Id)); tableParameters.Add(new KeyValuePair <string, string>("@MODIFIED_BY", userInfo)); tableParameters.Add(new KeyValuePair <string, string>("@MODIFIED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); tableParameters.Add(new KeyValuePair <string, string>("@VENDOR_ID", existingVendorInfo.Vendor_Id)); tableParameters.Add(new KeyValuePair <string, string>("@VENDOR_STATUS", existingVendorInfo.Vendor_Status)); result = DatabaseConnectionHandler.executeUpdateQuery(updateQueryString, tableParameters); } return(result); }
public static DiscountProperties getDiscountOfCustomer(string vendor_Discount_Id) { System.Data.DataSet dataset = new System.Data.DataSet(); DiscountProperties discount = new DiscountProperties(); string selectQueryString = "SELECT DISCOUNT_RATE,DISCOUNT_ID FROM DISCOUNT WHERE DISCOUNT_ID=@DISCOUNT_ID;"; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >(); parameters.Add(new KeyValuePair <string, string>("@DISCOUNT_ID", vendor_Discount_Id)); dataset = DatabaseConnectionHandler.executeSelectQuery(selectQueryString, parameters); if (dataset != null) { foreach (System.Data.DataRow row in dataset.Tables[0].Rows) { discount.Discount_Id = row["Discount_Id"].ToString(); discount.Discount_Rate = row["Discount_Rate"].ToString(); } } return(discount); }
public bool submitOrderReturn(OrderReturnProperties saveOrderReturnInfo) { string insertQueryString = "INSERT INTO RETURN_ORDER(RETURN_ORDER_ID,ORDER_ID,VENDOR_ID,USER_ID,PRODUCT_ID,PRODUCT_TYPE,COUNT,PRICE_PER_UNIT,RETURN_DESCRIPTION,RETURN_STATUS,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE) VALUES(@RETURN_ORDER_ID,@ORDER_ID,@VENDOR_ID,@USER_ID,@PRODUCT_ID,@PRODUCT_TYPE,@COUNT,@PRICE_PER_UNIT,@RETURN_DESCRIPTION,@RETURN_STATUS,@CREATED_BY,@CREATED_DATE,@MODIFIED_BY,@MODIFIED_DATE)"; List <KeyValuePair <string, string> > queryParameter = new List <KeyValuePair <string, string> >(); queryParameter.Add(new KeyValuePair <string, string>("@RETURN_ORDER_ID", saveOrderReturnInfo.Return_Order_Id)); queryParameter.Add(new KeyValuePair <string, string>("@ORDER_ID", saveOrderReturnInfo.Order_Id)); queryParameter.Add(new KeyValuePair <string, string>("@USER_ID", saveOrderReturnInfo.User_Id)); queryParameter.Add(new KeyValuePair <string, string>("@VENDOR_ID", saveOrderReturnInfo.Vendor_Id)); queryParameter.Add(new KeyValuePair <string, string>("@PRODUCT_ID", saveOrderReturnInfo.Product_Id)); queryParameter.Add(new KeyValuePair <string, string>("@PRODUCT_TYPE", saveOrderReturnInfo.Product_Type)); queryParameter.Add(new KeyValuePair <string, string>("@COUNT", saveOrderReturnInfo.Count.ToString())); queryParameter.Add(new KeyValuePair <string, string>("@PRICE_PER_UNIT", saveOrderReturnInfo.Price_Per_Unit.ToString())); queryParameter.Add(new KeyValuePair <string, string>("@RETURN_DESCRIPTION", saveOrderReturnInfo.Return_Description)); queryParameter.Add(new KeyValuePair <string, string>("@RETURN_STATUS", saveOrderReturnInfo.Return_Status)); queryParameter.Add(new KeyValuePair <string, string>("@CREATED_BY", saveOrderReturnInfo.Created_By)); queryParameter.Add(new KeyValuePair <string, string>("@CREATED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); queryParameter.Add(new KeyValuePair <string, string>("@MODIFIED_BY", saveOrderReturnInfo.Created_By)); queryParameter.Add(new KeyValuePair <string, string>("@MODIFIED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); return(DatabaseConnectionHandler.executeInsertDbQuery(insertQueryString, queryParameter)); }
// Adding new product in Inventory public bool addNewProduct(ProductProperties productInfo, string userInfo) { string insertNewProductQuery = "INSERT INTO PRODUCT (PRODUCT_ID,PRODUCT_NAME,PRODUCT_TYPE,MANUFACTURER_ID,PRODUCT_CURRENT_COUNT,MINIMUM_COUNT,PRICE_PER_UNIT,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE) VALUES(@PRODUCT_ID,@PRODUCT_NAME,@PRODUCT_TYPE,@MANUFACTURER_ID,@PRODUCT_CURRENT_COUNT,@MINIMUM_COUNT,@PRICE_PER_UNIT,@CREATED_BY,@CREATED_DATE,@MODIFIED_BY,@MODIFIED_DATE)"; bool resultStatus = false; List <KeyValuePair <string, string> > tableParamsValues = new List <KeyValuePair <string, string> >(); tableParamsValues.Add(new KeyValuePair <string, string>("@PRODUCT_ID", productInfo.Product_Id)); tableParamsValues.Add(new KeyValuePair <string, string>("@PRODUCT_NAME", productInfo.Product_Name)); tableParamsValues.Add(new KeyValuePair <string, string>("@PRODUCT_TYPE", productInfo.Product_Type)); tableParamsValues.Add(new KeyValuePair <string, string>("@MANUFACTURER_ID", productInfo.Manufacturer_Id)); tableParamsValues.Add(new KeyValuePair <string, string>("@PRODUCT_CURRENT_COUNT", Convert.ToString(productInfo.Product_Current_Count))); tableParamsValues.Add(new KeyValuePair <string, string>("@MINIMUM_COUNT", Convert.ToString(productInfo.Minimum_Count))); tableParamsValues.Add(new KeyValuePair <string, string>("@PRICE_PER_UNIT", Convert.ToString(productInfo.Price_Per_Unit))); tableParamsValues.Add(new KeyValuePair <string, string>("@CREATED_BY", userInfo)); tableParamsValues.Add(new KeyValuePair <string, string>("@CREATED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); tableParamsValues.Add(new KeyValuePair <string, string>("@MODIFIED_BY", userInfo)); tableParamsValues.Add(new KeyValuePair <string, string>("@MODIFIED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); resultStatus = DatabaseConnectionHandler.executeInsertDbQuery(insertNewProductQuery, tableParamsValues); return(resultStatus); }
//Validate user login with database public UserInformationProperties validateUserLogin(LoginProperties userCreds) { DataSet reader; List <KeyValuePair <string, string> > tableQueryData = new List <KeyValuePair <string, string> >(); UserInformationProperties userProfileInformation = new UserInformationProperties(); try { string queryString = "SELECT NAME,CONTACT,ADDRESS,EMAIL_ID,USER_ID,PASSWORD,ROLE,IS_VENDOR,VENDOR_ID,VENDOR_NAME,STATUS FROM USER_TABLE WHERE USER_ID=@USERID AND PASSWORD=@PASSWORD AND STATUS='ACTIVE'"; tableQueryData.Add(new KeyValuePair <string, string>("@USERID", userCreds.Username)); tableQueryData.Add(new KeyValuePair <string, string>("@PASSWORD", userCreds.Password)); reader = DatabaseConnectionHandler.executeSelectQuery(queryString, tableQueryData); if (reader != null) { userProfileInformation = getSingleUserInfo(userCreds.Username); } } catch (Exception ex) { Console.WriteLine("Login issue occured", ex.Message); } return(userProfileInformation); }
//Add new vendor in Vendor table public bool addCustomerInfo(CustomerProperties newVendorInfo, string userInfo) { bool result = false; string insertQueryString = "INSERT INTO VENDOR(VENDOR_NAME,VENDOR_ID,VENDOR_ADDRESS,VENDOR_CONTACT,VENDOR_EMAIL_ID,VENDOR_STATUS,VENDOR_DISCOUNT_ID,VENDOR_BALANCE_AMOUNT,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE) VALUES (@VENDOR_NAME,@VENDOR_ID,@VENDOR_ADDRESS,@VENDOR_CONTACT,@VENDOR_EMAIL_ID,@VENDOR_STATUS,@VENDOR_DISCOUNT_ID,@VENDOR_BALANCE_AMOUNT,@CREATED_BY,@CREATED_DATE,@MODIFIED_BY,@MODIFIED_DATE)"; List <KeyValuePair <string, string> > tableParameter = new List <KeyValuePair <string, string> >(); tableParameter.Add(new KeyValuePair <string, string>("@VENDOR_NAME", newVendorInfo.Vendor_Name)); tableParameter.Add(new KeyValuePair <string, string>("@VENDOR_ID", newVendorInfo.Vendor_Id)); tableParameter.Add(new KeyValuePair <string, string>("@VENDOR_ADDRESS", newVendorInfo.Vendor_Address)); tableParameter.Add(new KeyValuePair <string, string>("@VENDOR_CONTACT", newVendorInfo.Vendor_Contact)); tableParameter.Add(new KeyValuePair <string, string>("@VENDOR_EMAIL_ID", newVendorInfo.Vendor_EMail_Id)); tableParameter.Add(new KeyValuePair <string, string>("@VENDOR_STATUS", newVendorInfo.Vendor_Status)); tableParameter.Add(new KeyValuePair <string, string>("@VENDOR_DISCOUNT_ID", newVendorInfo.Vendor_Discount_ID)); tableParameter.Add(new KeyValuePair <string, string>("@VENDOR_BALANCE_AMOUNT", newVendorInfo.Vendor_Balance_Amount.ToString())); tableParameter.Add(new KeyValuePair <string, string>("@CREATED_BY", userInfo)); tableParameter.Add(new KeyValuePair <string, string>("@CREATED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); tableParameter.Add(new KeyValuePair <string, string>("@MODIFIED_BY", userInfo)); tableParameter.Add(new KeyValuePair <string, string>("@MODIFIED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime)); result = DatabaseConnectionHandler.executeInsertDbQuery(insertQueryString, tableParameter); return(result); }
//retrieving multiple vendor profile information from vendor table public List <CustomerProperties> getMultipleCustomerInfo(string vendorStatus) { DataSet dataset = new DataSet(); List <CustomerProperties> customerList = new List <CustomerProperties>(); string selectQueryString = null; if (vendorStatus.Equals("ALL")) { selectQueryString = "SELECT VENDOR_NAME,VENDOR_ID,VENDOR_ADDRESS,VENDOR_CONTACT,VENDOR_EMAIL_ID,VENDOR_STATUS,VENDOR_DISCOUNT_ID,VENDOR_BALANCE_AMOUNT FROM VENDOR"; dataset = DatabaseConnectionHandler.executeSelectQuery(selectQueryString, null); } else { selectQueryString = "SELECT VENDOR_NAME,VENDOR_ID,VENDOR_ADDRESS,VENDOR_CONTACT,VENDOR_EMAIL_ID,VENDOR_STATUS,VENDOR_DISCOUNT_ID,VENDOR_BALANCE_AMOUNT FROM VENDOR WHERE VENDOR_STATUS=@STATUS"; List <KeyValuePair <string, string> > tableQueryData = new List <KeyValuePair <string, string> >(); tableQueryData.Add(new KeyValuePair <string, string>("@STATUS", vendorStatus)); dataset = DatabaseConnectionHandler.executeSelectQuery(selectQueryString, tableQueryData); } if (dataset != null) { foreach (DataRow row in dataset.Tables[0].Rows) { CustomerProperties vendorInfo = new CustomerProperties(); vendorInfo.Vendor_Name = row["Vendor_Name"].ToString(); vendorInfo.Vendor_Id = row["Vendor_Id"].ToString(); vendorInfo.Vendor_Address = row["Vendor_Address"].ToString(); vendorInfo.Vendor_Contact = row["Vendor_Contact"].ToString(); vendorInfo.Vendor_EMail_Id = row["Vendor_Email_Id"].ToString(); vendorInfo.Vendor_Status = row["Vendor_Status"].ToString(); vendorInfo.Vendor_Discount_ID = row["Vendor_Discount_ID"].ToString(); vendorInfo.Vendor_Balance_Amount = Convert.ToDouble(row["Vendor_Balance_Amount"].ToString()); customerList.Add(vendorInfo); } } return(customerList); }