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