private void btn_Delivered_Click(object sender, EventArgs e) { try { if (grid_DeliOrds.Rows.Count != 1) { SalesOrderDBaccess SO = new SalesOrderDBaccess(); String status = "Delivered"; int Status = SO.UpdateSalesOrderStatus(grid_DeliOrds.CurrentRow.Cells["sale_id"].Value.ToString(), status); if (Status == 1) { MetroMessageBox.Show(this, "\n\nUpdated succesfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MetroMessageBox.Show(this, "\n\nUpdation Fail", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } catch (SqlException) { MetroMessageBox.Show(this, "\n\nConnecton Failed", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (FormatException) { MetroMessageBox.Show(this, "\n\nInvalid Format", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (OutOfMemoryException) { MetroMessageBox.Show(this, "\n\nInsuffisent memory", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception) { MetroMessageBox.Show(this, "\n\nERROR", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_PlaceOrder_Click(object sender, EventArgs e) { try { SalesOrderDBaccess SO = new SalesOrderDBaccess(); if (String.IsNullOrEmpty(txt_OrderClientEmail.Text) || String.IsNullOrEmpty(txt_OrderClientContact.Text)) { MetroMessageBox.Show(this, "\n\nPlease Select Approved Purchase Order To Place Order", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (rbn_clientEmail.Checked == false && rbn_clientContact.Checked == false) { MetroMessageBox.Show(this, "\n\nPlease Select Communication Method To Place Order", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { String status = "Placed"; String SaleId = grid_AppOdr.CurrentRow.Cells["sale_id"].Value.ToString(); int Status = SO.UpdateSalesOrderStatus(SaleId, status); if (Status == 1) { MetroMessageBox.Show(this, "\n\nOrder Is Placed", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MetroMessageBox.Show(this, "\n\nFail To Place", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } String Sts = "Approved"; grid_AppOdr.DataSource = SO.getSpecialSalesOrders(Sts); if (rbn_clientEmail.Checked) { try { MailMessage message = new MailMessage(); SmtpClient smtp = new SmtpClient(); message.From = new MailAddress("*****@*****.**"); message.To.Add(new MailAddress(txt_OrderClientEmail.Text)); message.Subject = "Order No " + grid_AppOdr.CurrentRow.Cells["sale_id"].Value.ToString(); message.Body = "Your Order Is Placed"; smtp.Port = 587; smtp.Host = "smtp.gmail.com"; smtp.EnableSsl = true; smtp.UseDefaultCredentials = false; smtp.Credentials = new NetworkCredential("*****@*****.**", "0763854323xyz"); smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.Send(message); MetroMessageBox.Show(this, "\n\nE-mail Sent", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (SqlException) { MetroMessageBox.Show(this, "\n\nConnecton Failed", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (FormatException) { MetroMessageBox.Show(this, "\n\nInvalid Format", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (OutOfMemoryException) { MetroMessageBox.Show(this, "\n\nInsuffisent memory", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception) { MetroMessageBox.Show(this, "\n\nERROR", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } catch (SqlException) { MetroMessageBox.Show(this, "\n\nConnecton Failed", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (FormatException) { MetroMessageBox.Show(this, "\n\nInvalid Format", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (OutOfMemoryException) { MetroMessageBox.Show(this, "\n\nInsuffisent memory", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception) { MetroMessageBox.Show(this, "\n\nERROR", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } }