private void btn_AppOdr_Click(object sender, EventArgs e)
{
try
{
listpanel[index = 4].BringToFront();
String Sts = "Approved";
PurchaseOrderDBaccess PO = new PurchaseOrderDBaccess();
grid_AppOdr.DataSource = PO.getSpecialPurchaseOrders(Sts);
}
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_Receive_Click(object sender, EventArgs e)
{
try
{
listpanel[index = 2].BringToFront();
String status = "Placed";
PurchaseOrderDBaccess Po = new PurchaseOrderDBaccess();
grid_RecOrds.DataSource = Po.getSpecialPurchaseOrders(status);
}
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 chk_Orders_OnChange(object sender, EventArgs e)
{
try
{
SalesOrderDBaccess SO = new SalesOrderDBaccess();
PurchaseOrderDBaccess PO = new PurchaseOrderDBaccess();
if (rbn_SaleM.Checked)
{
if (chk_Orders.Checked)
{
String Status = "Delivered";
grid_PurSales.DataSource = SO.getDeliveredSalesOrders(Status);
}
else
{
grid_PurSales.DataSource = SO.getSalesOrders();
}
}
if (rbn_PurM.Checked)
{
if (chk_Orders.Checked)
{
String Status = "Received";
grid_PurSales.DataSource = PO.getRecievedPurchaseOrders(Status);
}
else
{
grid_PurSales.DataSource = PO.getPurchaseOrders();
}
}
}
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_ConfirmForApp_Click(object sender, EventArgs e)
{
try
{
if (grid_Ordrs.SelectedRows.Count < 1)
{
MetroMessageBox.Show(this, "\n\nSelect Record From Grid to proceed", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
PurchaseOrderDBaccess PO = new PurchaseOrderDBaccess();
SalesOrderDBaccess SD = new SalesOrderDBaccess();
String status = "Waiting for Approval";
String saleId = grid_Ordrs.CurrentRow.Cells["sale_id"].Value.ToString();
int Status = PO.UpdateSalesOrderStatus(saleId, status);
if (Status == 1)
{
MetroMessageBox.Show(this, "\n\nSent For Approvel", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, "\n\nFail to Sent", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
String Sts = "Pending";
grid_Ordrs.DataSource = SD.getSpecialSalesOrders(Sts);
grid_Items.DataSource = null;
}
}
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_Order_Click_1(object sender, EventArgs e)
{
try
{
listpanel[index = 1].BringToFront();
//Hide other text boxes when first time open
txt_ItemType.Visible = false;
txt_qty2.Visible = false;
btn_add2.Visible = false;
btn_remove2.Visible = false;
lb_other.Visible = false;
lb_Qty2.Visible = false;
lb_size.Visible = false;
lb_color.Visible = false;
cmb_color.Visible = false;
cmb_size.Visible = false;
//create object of SupplierDBaccess class
SupplierDBaccess SA = new SupplierDBaccess();
grid_IdNameItem.DataSource = SA.getSupplierIDNameItem();
PurchaseOrderDBaccess PO = new PurchaseOrderDBaccess();
Grid_PurchaseOrder.DataSource = PO.getAllPurchaseOrders();
grid_IdNameItem.ClearSelection();
txt_POno.Text = PO.GetPurId();
}
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_NotRec_Click(object sender, EventArgs e)
{
try
{
PurchaseOrderDBaccess PO = new PurchaseOrderDBaccess();
String status = "Not Recieved";
String PurId = grid_AppOdr.CurrentRow.Cells["pur_id"].Value.ToString();
int Status = PO.UpdatePurchaseOrderStatus(PurId, status);
if (Status == 1)
{
MetroMessageBox.Show(this, "\n\nStatus Changed", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, "\n\nUpdate Status Fail", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
String Sts = "Placed";
grid_AppOdr.DataSource = PO.getSpecialPurchaseOrders(Sts);
}
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 rbn_PurM_CheckedChanged(object sender, EventArgs e)
{
try
{
PurchaseOrderDBaccess PO = new PurchaseOrderDBaccess();
if (rbn_PurM.Checked)
{
lb_del.Visible = false;
lb_res.Visible = true;
if (chk_Orders.Checked)
{
String Status = "Received";
grid_PurSales.DataSource = PO.getRecievedPurchaseOrders(Status);
}
else
{
grid_PurSales.DataSource = PO.getPurchaseOrders();
}
}
}
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_PlaceOrds_Click(object sender, EventArgs e)
{
try
{
PurchaseOrderDBaccess PO = new PurchaseOrderDBaccess();
if (String.IsNullOrEmpty(txt_OrderSupEmail.Text) || String.IsNullOrEmpty(txt_OrderSupContact.Text))
{
MetroMessageBox.Show(this, "\n\nPlease Select Approved Purchase Order To Place Order", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (rbn_byEmail.Checked == false && rbn_byContact.Checked == false)
{
MetroMessageBox.Show(this, "\n\nPlease Select Communication Method To Place Order", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
String status = "Placed";
String PurId = grid_AppOdr.CurrentRow.Cells["pur_id"].Value.ToString();
int Status = PO.UpdatePurchaseOrderStatus(PurId, status);
if (Status == 1)
{
MetroMessageBox.Show(this, "\n\nOrder Is Placed", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, "\n\n Fail To Place", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
String Sts = "Approved";
grid_AppOdr.DataSource = PO.getSpecialPurchaseOrders(Sts);
if (rbn_byEmail.Checked)
{
try
{
MailMessage message = new MailMessage();
SmtpClient smtp = new SmtpClient();
message.From = new MailAddress("*****@*****.**");
message.To.Add(new MailAddress(txt_OrderSupEmail.Text));
message.Subject = "Order No " + grid_AppOdr.CurrentRow.Cells["pur_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);
}
}
private void btn_CreOdr_Click(object sender, EventArgs e)
{
try
{
if (datagrid_add.Rows.Count == 1)
{
MetroMessageBox.Show(this, "Add Items Before proceed", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
PurchaseOrderDBaccess PO = new PurchaseOrderDBaccess();
PurMaster PM = new PurMaster();
PM.pur_id = txt_POno.Text;
PM.sup_id = txt_OsupId.Text;
PM.pur_date = Picker_ReqDate.Value.Date;
int Status = PO.createPurOrder_master(PM);
if (Status == 1)
{
MetroMessageBox.Show(this, "\n\nOrder Success, And Sending For Approvel", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_OsupId.Text = null;
txt_OsupName.Text = null;
txt_OsupEmail.Text = null;
cmb_ItemType.Text = null;
txt_qty.Text = null;
txt_qty2.Text = null;
txt_ItemType.Text = null;
Picker_ReqDate.ResetText();
datagrid_add.Rows.Clear();
datagrid_add.ClearSelection();
grid_IdNameItem.ClearSelection();
lb_SelectSup.Visible = true;
txt_POno.Text = PO.GetPurId();
}
else
{
MetroMessageBox.Show(this, "\n\nOrder Fail", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
// PurDetails PD = new PurDetails();
// PD.pd_id =
for (int i = 0; i < (datagrid_add.Rows.Count - 1); i++)
{
PurDetails PD = new PurDetails();
PD.pd_id = PO.GetPDId();
PD.pur_id = txt_POno.Text;
PD.pd_Item_type = (datagrid_add.Rows[i].Cells["Item"].Value).ToString();
PD.Size = (datagrid_add.Rows[i].Cells["Size"].Value).ToString();
PD.color = (datagrid_add.Rows[i].Cells["Color"].Value).ToString();
PD.pd_qty = (datagrid_add.Rows[i].Cells["Qty"].Value).ToString();
int status = PO.createPurOrder_details(PD);
}
PurchaseOrderDBaccess Po = new PurchaseOrderDBaccess();
Grid_PurchaseOrder.DataSource = Po.getAllPurchaseOrders();
}
}
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);
}
}
