public static List <Configuration> GetWebserviceObjectProperties(WebserviceObject webserviceObject)
{
List <Configuration> configurations = new List <Configuration>();
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = das.SERVICE_VIEW_GET_WEBSERVICE_PROPERTIES;
command.Parameters.AddWithValue(ConfigurationDAO.AT_WEBSERVICE_OBJECT_ID,
webserviceObject.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
configurations.Add(new Configuration(reader,
Configuration.View.GetWebserviceObjectProperties));
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "GetWebserviceObjectProperties(WebserviceObject webserviceObject)", webserviceObject.id.ToString());
}
}
return(configurations);
}
public void GetRoles()
{
WebserviceObject wsObj = WebserviceCalls.GetRoles();
List <Role> rolesList = new List <Role>();
if (wsObj.Success)
{
foreach (Role obj in (List <object>)wsObj.Response)
{
rolesList.Add(obj);
}
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
this.rolesList = rolesList;
ObservableCollection <object> oList;
oList = new ObservableCollection <object>(rolesList);
dgRoles.ItemsSource = oList;
}
private static List <WebserviceObject> getSingleWebserviceObject(WebserviceObject webserviceObject)
{
List <WebserviceObject> webserviceObjects = new List <WebserviceObject>();
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = das.GET_SINGLE_WEBSERVICE_OBJECT;
command.Parameters.AddWithValue(WebserviceObjectDAO.AT_ID, webserviceObject.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
webserviceObjects.Add(new WebserviceObject(reader));
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "getSingleWebserviceObject(WebserviceObject WebserviceObject)", webserviceObject.id.ToString());
}
}
return(webserviceObjects);
}
public void GetUsers()
{
WebserviceObject wsObj = WebserviceCalls.GetUsers();
List <User> usersList = new List <User>();
if (wsObj.Success)
{
foreach (User obj in (List <object>)wsObj.Response)
{
usersList.Add(obj);
}
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
this.usersList = usersList;
ObservableCollection <object> oList;
oList = new ObservableCollection <object>(usersList);
dgUsers.ItemsSource = oList;
}
public void GetOrders()
{
WebserviceObject wsObj = WebserviceCalls.GetOrdersAdmin();
List <Order> ordersTimeList = new List <Order>();
if (wsObj.Success)
{
foreach (Order obj in (List <object>)wsObj.Response)
{
ordersTimeList.Add(obj);
}
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
this.ordersTimeList = ordersTimeList;
ObservableCollection <object> oList;
oList = new ObservableCollection <object>(ordersTimeList);
dgOrdersTime.ItemsSource = oList;
}
private static bool deleteWebserviceObject(WebserviceObject webserviceObject)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = das.DELETE_WEBSERVICE_OBJECT;
command.Parameters.AddWithValue(WebserviceObjectDAO.AT_ID, webserviceObject.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
webserviceObject.id = DAOUtility.GetData <int>(reader, WebserviceObjectDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "DeleteWebserviceObject()", webserviceObject.id.ToString());
}
}
return(true);
}
public CreateOrderWindow(OrdersWindow ordersWindow, User user)
{
InitializeComponent();
this.user = user;
this.ordersWindow = ordersWindow;
WebserviceObject wsObj = WebserviceCalls.GetCustomers();
List <Customer> customersList = new List <Customer>();
if (wsObj.Success)
{
foreach (Customer obj in (List <object>)wsObj.Response)
{
customersList.Add(obj);
}
this.customersList = customersList;
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
List <string> names = customersList.Select(x => x.Name).ToList();
cbbCustomers.ItemsSource = names;
}
public void GetOrders()
{
WebserviceObject wsObj = WebserviceCalls.GetOrders(user.UserId);
List <Order> orderList = new List <Order>();
if (wsObj.Success)
{
foreach (Order obj in (List <object>)wsObj.Response)
{
orderList.Add(obj);
}
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
ObservableCollection <object> oList;
oList = new ObservableCollection <object>(orderList);
dgOrders.ItemsSource = oList;
dgOrders_SelectionChanged(null, null);
}
public static List <WebservicePropertySet> GetIncomingWebservicePropertySets(WebserviceObject webserviceObject, List <WebservicePropertySet> webservicePropertySets)
{
List <WebservicePropertySet> tempWebservicePropertySets = new List <WebservicePropertySet>();
tempWebservicePropertySets = webservicePropertySets;
tempWebservicePropertySets = tempWebservicePropertySets.FindAll(p => p.webserviceObjectId == webserviceObject.id);
return(tempWebservicePropertySets);
}
private void btnLogin_Click(object sender, RoutedEventArgs e)
{
WebserviceObject wsObj = WebserviceCalls.CheckLogin(tbUsername.Text, tbPassword.Password);
if (wsObj.Success)
{
MainWindow mainWindow = new MainWindow((User)wsObj.Response);
mainWindow.Show();
this.Close();
// Go to next window
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
}
public static void newWebServiceInstanceAndTables()
{
// creates a new web service instance
WebserviceInstance webserviceInstance = new WebserviceInstance()
{
communicationId = 18,
credentialId = 7,
ipAddress = "172.31.100.103",
server = "https://shcappprod.shc.shcnet.pri/WSShieldsApps/ShieldsApps_MSFTONLY.svc",
name = "WSShieldsApps"
};
// should have an id
webserviceInstance = WebserviceInstanceDAO.PostUpdate(webserviceInstance);
// create new web service objects
List <String> lines = new List <string>();
lines = File.ReadAllLines(@"C:\Users\chrisb\Documents\ApplicationDevelopment\Working\HL7Broker.root\HL7Broker\HL7BrokerConsoleTest\NewWebServiceObjects.txt").ToList();
lines.ForEach(delegate(String line)
{
WebserviceObject webserviceObject = new WebserviceObject()
{
id = 0,
name = line,
webserviceInstanceId = webserviceInstance.id
};
// post update new service object
webserviceObject = WebserviceObjectDAO.PostUpdate(webserviceObject);
// write out the identities to process the columns
Console.WriteLine(webserviceObject.name + "->" + webserviceObject.id);
});
Console.Read();
}
private void btnCreate_Click(object sender, RoutedEventArgs e)
{
if (tbFirstName.Text == "" || tbLastname.Text == "" || (tbPassword.Text == "" && tbPassword.Visibility == Visibility.Visible) || cbbAdmin.SelectedItem == null)
{
MessageBox.Show("Please fill out the fields");
return;
}
string firstname = tbFirstName.Text;
string lastname = tbLastname.Text;
string password = tbPassword.Text;
bool admin = bool.Parse(cbbAdmin.SelectedItem.ToString());
WebserviceObject wsObj = new WebserviceObject();
if (resetPassword)
{
wsObj = WebserviceCalls.ResetPassword(user.UserId, password);
}
else if (user != null)
{
wsObj = WebserviceCalls.UpdateUser(user.UserId, firstname, lastname, admin);
}
else
{
wsObj = WebserviceCalls.CreateUser(firstname, lastname, admin, password);
}
if (wsObj.Success)
{
adminControlWindow.GetUsers();
Close();
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
}
/***********************************************************************/
// FUNCTIONS
/***********************************************************************/
#region Functions
/***********************************************************/
// Gets the timeregistrations for user logged in
/***********************************************************/
public void GetTimeRegistrations()
{
WebserviceObject wsObj = WebserviceCalls.GetTimeRegistrations(user.UserId);
ObservableCollection <TimeRegistration> list = new ObservableCollection <TimeRegistration>();
foreach (TimeRegistration obj in (List <object>)wsObj.Response)
{
list.Add(obj);
}
list = new ObservableCollection <TimeRegistration>(from o in list orderby DateTime.Parse(o.StartTime) descending select o);
var tr = (from o in list where o.EndTime == "" select o).FirstOrDefault();
if (tr != null)
{
list.Remove(tr);
list.Insert(0, tr);
}
dgTimeRegistrations.ItemsSource = list;
}
private void btnDeleteOrderRole_Click(object sender, RoutedEventArgs e)
{
if (dgOrderRoles.SelectedIndex == -1)
{
MessageBox.Show("Please select an order relation");
return;
}
ObservableCollection<object> list = (ObservableCollection<object>)dgOrderRoles.ItemsSource;
var orderRole = (OrderRole)list[dgOrderRoles.SelectedIndex];
WebserviceObject wsObj = WebserviceCalls.DeleteOrderRole(orderRole.OrderRoleId, orderRole.OrderId);
if (wsObj.Success)
{
GetOrderRoles();
ordersWindow.GetOrders();
}
else
MessageBox.Show(wsObj.Response.ToString());
}
public void GetOrderRoles()
{
WebserviceObject wsObj = WebserviceCalls.GetOrderRoles(order.OrderId);
List<OrderRole> orderRoleList = new List<OrderRole>();
if (wsObj.Success)
{
foreach (OrderRole obj in (List<object>)wsObj.Response)
orderRoleList.Add(obj);
}
else
MessageBox.Show(wsObj.Response.ToString());
orderRoleList = orderRoleList.OrderBy(x => x.Name).ToList();
ObservableCollection<object> oList;
oList = new ObservableCollection<object>(orderRoleList);
dgOrderRoles.ItemsSource = oList;
ordersWindow.GetOrders();
}
private void btnCreate_Click(object sender, RoutedEventArgs e)
{
if (tbOrderName.Text == "" || tbOrderDescription.Text == "" || cbbCustomers.SelectedItem == null)
{
MessageBox.Show("Please fill out the fields");
return;
}
string name = tbOrderName.Text;
string description = tbOrderDescription.Text;
int customerId = customersList[cbbCustomers.SelectedIndex].CustomerId;
WebserviceObject wsObj = WebserviceCalls.CreateOrder(user.UserId, name, description, customerId);
if (wsObj.Success)
{
ordersWindow.GetOrders();
Close();
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
}
private void btnCreate_Click(object sender, RoutedEventArgs e)
{
if (tbCustomerName.Text == "")
{
MessageBox.Show("Please fill out the field");
return;
}
string name = tbCustomerName.Text;
WebserviceObject wsObj = new WebserviceObject();
wsObj = WebserviceCalls.CreateCustomer(name);
if (wsObj.Success)
{
adminControlWindow.GetCustomers();
Close();
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
}
public void GetTimeRegistratedOnOrder()
{
WebserviceObject wsObj = WebserviceCalls.GetTimeRegistratedPerUserOnOrder(order.OrderId);
List <TimeRegistrated> timeRegistratedList = new List <TimeRegistrated>();
if (wsObj.Success)
{
foreach (TimeRegistrated obj in (List <object>)wsObj.Response)
{
timeRegistratedList.Add(obj);
}
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
ObservableCollection <object> oList;
oList = new ObservableCollection <object>(timeRegistratedList);
dgTimeRegistratedOnOrder.ItemsSource = oList;
}
/***********************************************************/
// Order ID textbox keydown
/***********************************************************/
private void tbOrderId_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
if (tbOrderId.Text == "")
{
MessageBox.Show("Please give an order ID");
return;
}
int orderId = int.Parse(tbOrderId.Text);
WebserviceObject wsObj = WebserviceCalls.GetOrder(user.UserId, orderId);
if (wsObj.Success)
{
SetOrderId((Order)wsObj.Response);
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
}
}
private static WebserviceObject postUpdateWebserviceObject(WebserviceObject webserviceObject)
{
SysDataAccessCredential dac = DAOUtility.GetSysCredentials();
DataAccess das = new DataAccess();
using (SqlConnection conn = new SqlConnection(DAOUtility.GetConnectionString(dac)))
{
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = das.PUT_WEBSERVICE_OBJECT;
command.Parameters.AddWithValue(WebserviceObjectDAO.WEBSERVICE_INSTANCE_ID, webserviceObject.webserviceInstanceId);
command.Parameters.AddWithValue(WebserviceObjectDAO.AT_NAME, webserviceObject.name);
command.Parameters.AddWithValue(WebserviceObjectDAO.AT_ID, webserviceObject.id);
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
webserviceObject.id = DAOUtility.GetData <int>(reader, WebserviceObjectDAO.ID);
}
}
}
catch (Exception e)
{
ErrorLogger.LogError(e, "postUpdateWebserviceObject()", webserviceObject.id.ToString());
}
}
return(webserviceObject);
}
public static List <WebserviceObject> Get(WebserviceObject webserviceObject)
{
return(getSingleWebserviceObject(webserviceObject));
}
public static WebserviceObject PostUpdate(WebserviceObject webserviceObject)
{
return(postUpdateWebserviceObject(webserviceObject));
}
public static bool Delete(WebserviceObject webserviceObject)
{
return(deleteWebserviceObject(webserviceObject));
}
public CreateOrderRelationWindow(AdministrateRolesWindow administrateRolesWindow, Order order, OrderRole orderRole)
{
InitializeComponent();
this.administrateRolesWindow = administrateRolesWindow;
this.orderRole = orderRole;
this.order = order;
WebserviceObject wsObj = WebserviceCalls.GetUsers();
List <User> usersList = new List <User>();
if (wsObj.Success)
{
foreach (User obj in (List <object>)wsObj.Response)
{
usersList.Add(obj);
}
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
ObservableCollection <object> oList = new ObservableCollection <object>(usersList);
dgUsers.ItemsSource = oList;
wsObj = WebserviceCalls.GetRoles();
List <Role> rolesList = new List <Role>();
if (wsObj.Success)
{
foreach (Role obj in (List <object>)wsObj.Response)
{
rolesList.Add(obj);
}
}
else
{
MessageBox.Show(wsObj.Response.ToString());
}
oList = new ObservableCollection <object>(rolesList);
dgRoles.ItemsSource = oList;
if (orderRole != null)
{
Title = "TimeRegistrationApp - Update order relation";
btnCreate.Content = "Update order relation";
var user = usersList.Where(x => x.UserId == orderRole.UserId).FirstOrDefault();
dgUsers.SelectedItem = user;
var role = rolesList.Where(x => x.RoleId == orderRole.RoleId).FirstOrDefault();
dgRoles.SelectedItem = role;
dgUsers.IsEnabled = false;
}
}
