public Dictionary <string, string> getOrderDataByOrderNumber(string orderNumber)
{
MSDatabaseConnector msDatabaseConnectorLW = new MSDatabaseConnector(Config.MSDbLW);
String query = $@"use [LW08v6]
select CREATED_ON, X_ORDER_CODE, X_LAST_NAME, X_FIRST_NAME, X_MIDDLE_NAME, X_EMAIL_ADDRESS,
X_CELL_PHONE_NUMBER from orders with (nolock) where X_ORDER_CODE='" + orderNumber + "'";
var results = msDatabaseConnectorLW.QueryExecutorTable(query);
Dictionary <string, string> data = new Dictionary <string, string>();
data.Add("createdOn", DateTime.Parse(results.Rows[0].ItemArray[0].ToString()).ToString("dd.MM.yyyy HH:mm"));
data.Add("lastName", results.Rows[0].ItemArray[2].ToString());
data.Add("firstName", results.Rows[0].ItemArray[3].ToString());
data.Add("middleName", results.Rows[0].ItemArray[4].ToString());
data.Add("emailAddress", results.Rows[0].ItemArray[5].ToString());
data.Add("cellPhoneNumber", results.Rows[0].ItemArray[6].ToString());
return(data);
}
public Dictionary <string, string> getOrderDataByExternalSampleNumber(string externalSampleNumber, DateTime dateFrom, DateTime dateTo)
{
MSDatabaseConnector msDatabaseConnectorLW = new MSDatabaseConnector(Config.MSDbLW);
String query = $@"use [LW08v6]
select CREATED_ON, X_ORDER_CODE, X_LAST_NAME, X_FIRST_NAME, X_MIDDLE_NAME, X_EMAIL_ADDRESS,
X_CELL_PHONE_NUMBER from orders with (nolock) where created_on>='" + dateFrom.ToString("yyyy-MM-dd") + "T00:00:00' and created_on<='" +
dateTo.ToString("yyyy-MM-dd") + "T23:59:59' and order_num in (select order_num from sample with (nolock) where x_old_sample_id='" + externalSampleNumber + "')";
var results = msDatabaseConnectorLW.QueryExecutorTable(query);
Dictionary <string, string> data = new Dictionary <string, string>();
data.Add("createdOn", DateTime.Parse(results.Rows[0].ItemArray[0].ToString()).ToString("dd.MM.yyyy HH:mm"));
data.Add("orderNumber", results.Rows[0].ItemArray[1].ToString());
data.Add("lastName", results.Rows[0].ItemArray[2].ToString());
data.Add("firstName", results.Rows[0].ItemArray[3].ToString());
data.Add("middleName", results.Rows[0].ItemArray[4].ToString());
data.Add("emailAddress", results.Rows[0].ItemArray[5].ToString());
data.Add("cellPhoneNumber", results.Rows[0].ItemArray[6].ToString());
return(data);
}
