public static string ValidateLogin(string email, string password, string path)
{
DataSet ds = new DataSet(); string custId = string.Empty;
PredictCustomerDbo algorithmDBO = new PredictCustomerDbo();
ds = algorithmDBO.GetData(path);
if (ds != null && ds.Tables.Count > 0)
{
DataRow[] row = ds.Tables[1].Select("CustEmail='" + email + "' and Cust_Password='******'");
if (row != null && row.Length > 0)
custId = row[0]["CustId"].ToString();
}
return custId;
}
public bool Processdataforcustomer(string custid,string path)
{
DataSet ds = new DataSet();
PredictCustomerDbo algorithmDBO = new PredictCustomerDbo();
ds = algorithmDBO.GetData(path);
if (ds != null && ds.Tables.Count > 0)
{
custProfile = new List<CustProfile>();
foreach (DataRow dr in ds.Tables[2].Select("Cust_Id='" + custid + "'"))
{
CustProfile c = new CustProfile();
AssignDataRow(dr, c);
custProfile.Add(c);
}
customerInfo = new List<CustomerInfo>();
foreach (DataRow dr in ds.Tables[3].Select("Cust_Id='" + custid + "'"))
{
CustomerInfo c1 = new CustomerInfo();
AssignDataRow(dr, c1);
customerInfo.Add(c1);
}
usageDetail = new List<UsageDetail>();
foreach (DataRow dr in ds.Tables[5].Select("Cust_Id='" + custid + "'"))
{
UsageDetail c2 = new UsageDetail();
AssignDataRow(dr, c2);
usageDetail.Add(c2);
}
if (productDetails == null || productDetails.Count == 0)
{
productDetails = new List<Product>();
foreach (DataRow dr in ds.Tables[4].Rows)
{
Product p = new Product();
AssignDataRow(dr, p);
productDetails.Add(p);
}
}
if (bundleDetails == null || bundleDetails.Count == 0)
{
bundleDetails = new List<BundleProduct>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
BundleProduct p = new BundleProduct();
AssignDataRow(dr, p);
bundleDetails.Add(p);
}
}
existingCustomerProducts = new List<Product>();
foreach (var item in custProfile)
{
var prod = getProductsByID(Convert.ToInt32(item.Product_Id));
if (prod != null)
existingCustomerProducts.Add(prod);
}
bundleComps = new List<string>();
bundleComps = (from prod in existingCustomerProducts
where prod.Category != "BUNDLE"
select prod.Category).Distinct().ToList();
}
return true;
}
