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