/// <summary>
/// Method is used to insert the customer details in DB
/// </summary>
/// <param name="customer"></param>
public void InsertCustomerDetails(CustomerModelLib.Customer customer)
{
List <string> CustomerEmails = GetCustomer();
try
{
if (!IsCustomerExist(customer.EmailId, CustomerEmails))
{
using (ChatBotDataModelDataContext dbcontext = new ChatBotDataModelDataContext())
{
ChatBotModelLib.Customer customerObj = new ChatBotModelLib.Customer();
customerObj.customer_email = customer.EmailId;
customerObj.customer_name = customer.Name;
customerObj.customer_phone = customer.Phone;
dbcontext.Customers.InsertOnSubmit(customerObj);
dbcontext.SubmitChanges();
}
}
int MonitorNo = GetMonitorIdByMonitorName(customer.MonitorName);
InsertCustomerPreference(customer.EmailId, MonitorNo);
}
catch (Exception ex)
{
#pragma warning disable S3445 // Exceptions should not be explicitly rethrown
throw ex;
#pragma warning restore S3445 // Exceptions should not be explicitly rethrown
}
}
/// <summary>
/// Method is used for inserting the customer and thier Monitor preference
/// </summary>
/// <param name="email"></param>
/// <param name="monitor_no"></param>
private void InsertCustomerPreference(string email, int monitor_no)
{
using (ChatBotDataModelDataContext dbcontext = new ChatBotDataModelDataContext())
{
ChatBotModelLib.MonitorsPreference monitorObj = new ChatBotModelLib.MonitorsPreference();
monitorObj.customer_email = email;
monitorObj.monitors_no = monitor_no;
monitorObj.check_in = DateTime.Now;
dbcontext.MonitorsPreferences.InsertOnSubmit(monitorObj);
dbcontext.SubmitChanges();
}
}
public List <string> GetAllSelectedItems(int Feature_No, string FeatureValue)
{
var FeatureDictionary = dataref.ReadAttributes();
string Feature;
if (Feature_No == 0)
{
Feature = "FirstFeature";
}
else
{
try
{
Feature = FeatureDictionary[Feature_No];
}
catch (Exception ex)
{
throw ex;
}
}
List <string> Selectedlist = new List <string>();
if (!Feature.Equals(string.Empty) && !FeatureValue.Equals(string.Empty))
{
using (ChatBotDataModelDataContext dbcontext = new ChatBotDataModelDataContext())
{
if (Feature.Equals("FirstFeature") && FeatureValue.Equals("FirstValue"))
{
var Selectedtems = dbcontext.ChatbotTable_s.Select("monitors_name");
foreach (var Item in Selectedtems)
{
Selectedlist.Add(Item.ToString());
}
}
else
{
var Selectedtems = dbcontext.ChatbotTable_s.Where(Feature + "=\"" + FeatureValue + "\"").Select("monitors_name");
foreach (var Item in Selectedtems)
{
Selectedlist.Add(Item.ToString());
}
}
}
}
else
{
throw new ArgumentException("String Empty");
}
return(Selectedlist);
}
/// <summary>
/// Method is used to get all the customer from the Db
/// </summary>
/// <returns>list of customer</returns>
public List <string> GetCustomer()
{
List <string> CustomerEmails = new List <string>();
using (ChatBotDataModelDataContext dbcontext = new ChatBotDataModelDataContext())
{
IQueryable SelectedCustomersEmail = dbcontext.Customers.Select("customer_email");
foreach (var email in SelectedCustomersEmail)
{
CustomerEmails.Add(email.ToString());
}
return(CustomerEmails);
}
}
/// <summary>
/// Method is used to get monitor no from the DB.
/// </summary>
/// <param name="monitorName"></param>
/// <returns>monitor nomber</returns>
private int GetMonitorIdByMonitorName(string monitorName)
{
using (ChatBotDataModelDataContext dbcontext = new ChatBotDataModelDataContext())
{
string MonitorNameFeild = "monitors_name";
string MonitorNumber = null;
var number = dbcontext.Monitors.Where(MonitorNameFeild + "=\"" + monitorName + "\"").Select("monitors_no");
foreach (var item in number)
{
MonitorNumber = item.ToString();
}
return(int.Parse(MonitorNumber));
}
}
public Dictionary <int, string> ReadAttributes()
{
Dictionary <int, string> FeaturesDictionary = new Dictionary <int, string>();
using (ChatBotDataModelDataContext dbcontext = new ChatBotDataModelDataContext())
{
var columnnames = from t in typeof(Monitor).GetProperties() select t.Name;
int i = 0;
foreach (var c in columnnames)
{
FeaturesDictionary.Add(i, c.ToString());
i = i + 1;
}
}
return(FeaturesDictionary);
}
public List <string> ReadData(Dictionary <int, string> FeaturesDictionary, Dictionary <int, string> AnswerDictionary, int QuestionNumber)
{
List <string> options = new List <string>();
using (ChatBotDataModelDataContext dbcontext = new ChatBotDataModelDataContext())
{
IQueryable optionsQueryable;
if (QuestionNumber == 1)
{
optionsQueryable = dbcontext.Monitors.Where(FeaturesDictionary[QuestionNumber] + "!=\"" + null + "\"").Select(FeaturesDictionary[QuestionNumber]).Distinct();
}
else
{
int feature_no = AnswerDictionary.Keys.Max();
optionsQueryable = dbcontext.Monitors.Where(FeaturesDictionary[feature_no] + "=\"" + AnswerDictionary[feature_no] + "\"").Where(FeaturesDictionary[QuestionNumber] + "!=\"" + null + "\"").Select(FeaturesDictionary[QuestionNumber]).Distinct();
}
foreach (var option in optionsQueryable)
{
options.Add(option.ToString());
}
return(options);
}
}
