public override string ToString()
 {
     return($"=======MAILITEM=======\n" +
            $"Entry ID: {EntryID}\n" +
            $"Folder Entry ID: {FolderEntryID}\n" +
            $"Folder Name: {FolderPath}\n" +
            $"Subject: {Subject}\n" +
            $"Received Date: {ReceivedDate.ToString("dd/MM/yyyy hh:mm:ss")}\n" +
            $"From: {From}\n" +
            $"To: {To}\n" +
            $"CC: {CC}\n" +
            $"======================\n");
 }
Exemple #2
0
        private void metroButton1_Click(object sender, EventArgs e)
        {
            //variables;
            string  ProductName;
            int     ProductQuantity;
            string  SupplierName;
            int     ReceivedStatus;
            decimal OrderCost;
            string  ReceivedDate;
            string  Received;

            SqlConnection sqlcon = new SqlConnection(Globals_Class.ConnectionString);

            sqlcon.Open();
            string        cmd    = "Select ProductName, ProductQuantity, SupplierName, ReceivedStatus, OrderCost, ReceivedDate FROM ReceiveSupplierOrder";
            SqlCommand    sqlcom = new SqlCommand(cmd, sqlcon);
            SqlDataReader reader;

            reader = sqlcom.ExecuteReader();
            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    ProductName     = (reader["ProductName"].ToString());
                    ProductQuantity = Convert.ToInt32((reader["ProductQuantity"]));
                    SupplierName    = (reader["SupplierName"].ToString());
                    ReceivedStatus  = Convert.ToInt32((reader["ReceivedStatus"]));
                    OrderCost       = Convert.ToDecimal((reader["OrderCost"]));
                    ReceivedDate    = (reader["ReceivedDate"].ToString());
                    if (ReceivedStatus == 1)
                    {
                        Received = "Yes";
                    }
                    else
                    {
                        Received = "No";
                    }

                    Details += "\n" + "Product Name:" + " " + ProductName + "\n" + "Quantity Ordered:" + " " + ProductQuantity.ToString() + "\n" + "Supplier Name:" + " " + SupplierName + "\n" + "Received Status:" + " " + Received + "\n" + "Order Cost:" + " " + OrderCost.ToString() + "\n" + "Received Date:" + " " + ReceivedDate.ToString() + "\n";
                }
            }

            reader.Close();
            sqlcon.Close();
            documentWriter();
        }