private void btn_OdrClr_Click(object sender, EventArgs e)
{
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;
}
private void btn_OdrClr_Click(object sender, EventArgs e)
{
txt_OcltId.Text = null;
txt_OcltName.Text = null;
txt_OcltAdd.Text = null;
txt_OcltEmail.Text = null;
txt_CintContact.Text = null;
cmb_ProType.Text = null;
cmb_ftype.Text = null;
cmb_Brand.Text = null;
cmb_Design.Text = null;
cmb_size.Text = null;
cmb_color.Text = null;
txt_qty.Text = null;
txt_odrTot.Text = null;
Picker_ReqDate.ResetText();
datagrid_add.Rows.Clear();
datagrid_add.ClearSelection();
grid_IdNameItem.ClearSelection();
lb_SelectClt.Visible = true;
}
private void btn_CreOdr_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txt_odrTot.Text))
{
MessageBox.Show("You must get Order Total", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Picker_ReqDate.Value.Date == DateTime.Today.Date)
{
MessageBox.Show("You must select a Date", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Picker_ReqDate.Value.Date <= DateTime.Today.Date)
{
MessageBox.Show("You must select a Future Date", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrEmpty(txt_OcltId.Text))
{
MessageBox.Show("You must select a Client", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
SalesOrderDBaccess SO = new SalesOrderDBaccess();
SaleMaster SM = new SaleMaster();
SM.sale_id = txt_SOno.Text;
SM.clt_id = txt_OcltId.Text;
SM.sale_date = Picker_ReqDate.Value.Date;
SM.sale_total = Convert.ToInt32(txt_odrTot.Text);
int Status = SO.createSale_master(SM);
if (Status == 1)
{
MetroMessageBox.Show(this, "\n\nOrder Created succesfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MetroMessageBox.Show(this, "\n\nOrder Creation Fail", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
grid_Sales.DataSource = SO.getSalesOrders();
txt_SOno.Text = SO.GetSaleId();
txt_OcltId.Text = null;
txt_OcltName.Text = null;
txt_OcltAdd.Text = null;
txt_OcltEmail.Text = null;
txt_CintContact.Text = null;
cmb_ProType.Text = null;
cmb_ftype.Text = null;
cmb_Brand.Text = null;
cmb_Design.Text = null;
cmb_size.Text = null;
cmb_color.Text = null;
txt_qty.Text = null;
txt_odrTot.Text = null;
Picker_ReqDate.ResetText();
datagrid_add.Rows.Clear();
datagrid_add.ClearSelection();
grid_IdNameItem.ClearSelection();
lb_SelectClt.Visible = true;
}
// PurDetails PD = new PurDetails();
// PD.pd_id =
}
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);
}
}
