public static string getCustomerInfoBy(int ID) { String customerName = ""; SqlConnection connection = MarinaDB.GetConnection(); try { string sql = "SELECT FirstName + ' ' + LastName as FullName "; sql += "FROM Customer WHERE ID = " + ID; SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (reader.Read()) { customerName = reader["FullName"].ToString(); } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { connection.Close(); } return(customerName); }
public static List <string> getSlipsByCustomer(int ID) { List <string> result = new List <string>(); SqlConnection connection = MarinaDB.GetConnection(); try { string sql = "SELECT SlipID FROM Lease WHERE CustomerID = " + ID; SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (reader.Read()) { result.Add(reader["SlipID"].ToString()); } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { connection.Close(); } return(result); }
public static List <string> getSlipInfoBy(int ID) { List <string> result = new List <string>(); SqlConnection connection = MarinaDB.GetConnection(); try { string sql = "SELECT s.ID, s.Length, s.Width, d.Name, d.ElectricalService, d.WaterService "; sql += "FROM Slip s "; sql += "JOIN DOCK d on s.DockID = d.ID "; sql += "WHERE s.ID = " + ID; SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (reader.Read()) { result.Add(reader["ID"].ToString()); //0 result.Add(reader["Length"].ToString()); //1 result.Add(reader["Width"].ToString()); //2 result.Add(reader["Name"].ToString()); //3 result.Add(reader["ElectricalService"].ToString()); //4 result.Add(reader["WaterService"].ToString()); //5 } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { connection.Close(); } return(result); }
public static string CustomerName(int ID) { string Name = ""; //string Lastname = ""; SqlConnection connection = MarinaDB.GetConnection(); try { string sql = " select FirstName, LastName FROM Customer where ID =" + ID.ToString(); SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (reader.Read()) { Name = reader["FirstName"].ToString() + " " + reader["LastName"].ToString(); } } catch (Exception ex) { } finally { connection.Close(); } return(Name); }