public bool CheckItems()
{
if (!ItemsCheck.CheckTextBoxEmpty(tbMpn))
{
MessageBox.Show("Please input the MPN.");
return(false);
}
if (ItemsCheck.CheckTextBoxEmpty(tbMfg) == false)
{
MessageBox.Show("Please input the MFG.");
return(false);
}
if (ItemsCheck.CheckTextBoxEmpty(tbVendorName) == false)
{
MessageBox.Show("Please input the Vendor Name.");
return(false);
}
if (ItemsCheck.CheckTextBoxEmpty(tbContact) == false)
{
MessageBox.Show("Please input the Contact name.");
return(false);
}
if (ItemsCheck.CheckTextBoxEmpty(tbPhone) == false)
{
MessageBox.Show("Please input the Phone number.");
return(false);
}
if (ItemsCheck.CheckTextBoxEmpty(tbQuantity) == false)
{
MessageBox.Show("Please input the Quantity.");
return(false);
}
else
{
if (false == ItemsCheck.CheckIntNumber(tbQuantity))
{
MessageBox.Show("The Quantity should be an integer value");
return(false);
}
}
if (ItemsCheck.CheckTextBoxEmpty(tbPrice) == false)
{
MessageBox.Show("Please input the Price.");
return(false);
}
else
{
if (false == ItemsCheck.CheckFloatNumber(tbPrice))
{
MessageBox.Show("The Price should be a float value");
return(false);
}
}
return(true);
}
public bool CheckValues()
{
if (ItemsCheck.CheckTextBoxEmpty(tbPartNo) == false)
{
MessageBox.Show("Please input the Part number.");
return(false);
}
if (ItemsCheck.CheckTextBoxEmpty(tbMfg) == false)
{
MessageBox.Show("Please input the MFG.");
return(false);
}
if (ItemsCheck.CheckTextBoxEmpty(tbDc) == false)
{
MessageBox.Show("Please input the D/C.");
return(false);
}
if (!ItemsCheck.CheckTextBoxEmpty(tbQty))
{
MessageBox.Show("Please input the Qty value.");
tbQty.Focus();
return(false);
}
if (!ItemsCheck.CheckIntNumber(tbQty))
{
MessageBox.Show("The Qty should be an integer value.");
tbQty.Focus();
return(false);
}
if (ItemsCheck.CheckTextBoxEmpty(tbQtyShipped) && !ItemsCheck.CheckIntNumber(tbQtyShipped))
{
MessageBox.Show("The Qty Shipped should be an integer value.");
tbQtyShipped.Focus();
return(false);
}
if (!ItemsCheck.CheckTextBoxEmpty(tbUnitPrice))
{
MessageBox.Show("Please input the Unit Price.");
tbUnitPrice.Focus();
return(false);
}
if (!ItemsCheck.CheckFloatNumber(tbUnitPrice))
{
MessageBox.Show("The Unit Price should be a float value.");
tbUnitPrice.Focus();
return(false);
}
return(true);
}
private void button1_Click(object sender, EventArgs e)
{
if (!ItemsCheck.CheckTextBoxEmpty(tbMfg))
{
MessageBox.Show("Please input the MFG");
return;
}
if (!ItemsCheck.CheckTextBoxEmpty(tbMpn))
{
MessageBox.Show("Please input the MPN");
return;
}
if (!ItemsCheck.CheckIntNumber(tbQty))
{
MessageBox.Show("The QTY should be an integer value");
tbQty.Focus();
return;
}
if (!ItemsCheck.CheckTextBoxEmpty(tbPrice))
{
MessageBox.Show("Please input the Price");
return;
}
else
{
if (!ItemsCheck.CheckFloatNumber(tbPrice))
{
MessageBox.Show("The Price should be a float number");
tbPrice.Focus();
return;
}
}
var publicBomOff = new publicbomoffer
{
mfg = tbMfg.Text.Trim(),
mpn = tbMpn.Text.Trim(),
qty = int.Parse(tbQty.Text.Trim()),
price = float.Parse(tbPrice.Text.Trim()),
cpn = tbCpn.Text.Trim(),
userID = (short)UserInfo.UserId,
BomCustVendId = this.custVenId,
enerDay = DateTime.Now
};
using (BomOfferEntities entity = new BomOfferEntities())
{
entity.publicbomoffer.AddObject(publicBomOff);
entity.SaveChanges();
}
this.DialogResult = DialogResult.OK;
this.Close();
}
private bool CheckValues()
{
if (ItemsCheck.CheckTextBoxEmpty(tbVendor) == false)
{
MessageBox.Show("Please input the Vendor name");
return(false);
}
if (ItemsCheck.CheckTextBoxEmpty(tbContact) == false)
{
MessageBox.Show("Please input the Contact name");
return(false);
}
return(true);
}
private void button1_Click(object sender, EventArgs e)
{
if (!ItemsCheck.CheckTextBoxEmpty(tbCustomer))
{
MessageBox.Show("Please input the Customer Name");
return;
}
if (!ItemsCheck.CheckTextBoxEmpty(tbMfg))
{
MessageBox.Show("Please input the MFG");
return;
}
if (!ItemsCheck.CheckTextBoxEmpty(tbMpn))
{
MessageBox.Show("Please input the MPN");
return;
}
if (!ItemsCheck.CheckIntNumber(tbQty))
{
MessageBox.Show("The QTY should be an integer value");
tbQty.Focus();
return;
}
if (!ItemsCheck.CheckTextBoxEmpty(tbPrice))
{
MessageBox.Show("Please input the Price");
return;
}
else
{
if (!ItemsCheck.CheckFloatNumber(tbPrice))
{
MessageBox.Show("The Price should be a float number");
tbPrice.Focus();
return;
}
}
string sql = string.Format("insert into matchBom(customer,mfg,mpn,qty,price,cpn,buyer,bomOwner,bomdate) values('{0}','{1}','{2}',{3},{4},'{5}','{6}',{7},'{8}')", tbCustomer.Text.Trim(),
tbMfg.Text.Trim(), tbMpn.Text.Trim(), tbQty.Text.Trim(), tbPrice.Text.Trim(), tbCpn.Text.Trim(), tbBuyer.Text.Trim(), UserInfo.UserId, DateTime.Now.ToString());
db.ExecDataBySql(sql);
this.DialogResult = DialogResult.OK;
this.Close();
}
public bool ValidateValues()
{
if (!ItemsCheck.CheckTextBoxEmpty(tbName))
{
if (cvtype == 0)
{
MessageBox.Show("Please input the Customer Name");
}
if (cvtype == 1)
{
MessageBox.Show("Please input the Vendor Name");
}
return(false);
}
if (ItemsCheck.CheckTextBoxEmpty(tbRating))
{
if (!ItemsCheck.CheckIntNumber(tbRating))
{
MessageBox.Show("The Rating Should be an Integer Value (0-100).");
tbRating.Focus();
return(false);
}
if (Convert.ToInt32(tbRating.Text.Trim()) > 100 || Convert.ToInt32(tbRating.Text.Trim()) < 0)
{
MessageBox.Show("The Rating should be 0-100");
tbRating.Focus();
return(false);
}
}
if (ItemsCheck.CheckTextBoxEmpty(tbAmount) && (!ItemsCheck.CheckIntNumber(tbAmount)))
{
MessageBox.Show("The Amount should be an Integer Value.");
tbAmount.Focus();
return(false);
}
return(true);
}
private void btOK_Click(object sender, EventArgs e)
{
if (!ItemsCheck.CheckTextBoxEmpty(tbMpn))
{
MessageBox.Show("Please input the MPN");
return;
}
if (ItemsCheck.CheckTextBoxEmpty(tbQty) && !ItemsCheck.CheckIntNumber(tbQty))
{
MessageBox.Show("The QTY should be an integer value");
tbQty.Focus();
return;
}
if (ItemsCheck.CheckTextBoxEmpty(tbResale) && !ItemsCheck.CheckFloatNumber(tbResale))
{
MessageBox.Show("The Resale should be a float number");
tbResale.Focus();
return;
}
if (ItemsCheck.CheckTextBoxEmpty(tbCost) && !ItemsCheck.CheckFloatNumber(tbCost))
{
MessageBox.Show("The Cost should be a float number");
tbCost.Focus();
return;
}
string sql;
if (isNewStockItem)
{
sql = string.Format("insert into ambleStock(mpn,mfg,dc,qty,resale,cost,packing,contact,statu,notes,stockDate) values ('{0}','{1}','{2}',{3},{4},{5},'{6}','{7}','{8}','{9}','{10}')",
tbMpn.Text.Trim(), tbMfg.Text.Trim(), tbDc.Text.Trim(),
string.IsNullOrWhiteSpace(tbQty.Text.Trim()) ? "null" : tbQty.Text.Trim(),
string.IsNullOrWhiteSpace(tbResale.Text.Trim()) ? "null" : tbResale.Text.Trim(),
string.IsNullOrWhiteSpace(tbCost.Text.Trim()) ? "null" : tbCost.Text.Trim(),
tbPacking.Text.Trim(),
tbContact.Text.Trim(),
cbStatus.Text.Trim(),
tbNotes.Text.Trim(),
tbDate.Text.Trim()
);
}
else
{
sql = string.Format("update amblestock set mpn='{0}',mfg='{1}',dc='{2}',qty={3},resale={4},cost={5},packing='{6}',contact='{7}',statu='{8}',notes='{9}',stockDate='{10}' where stockId={11}",
tbMpn.Text.Trim(), tbMfg.Text.Trim(), tbDc.Text.Trim(),
string.IsNullOrWhiteSpace(tbQty.Text.Trim()) ? "null" : tbQty.Text.Trim(),
string.IsNullOrWhiteSpace(tbResale.Text.Trim()) ? "null" : tbResale.Text.Trim(),
string.IsNullOrWhiteSpace(tbCost.Text.Trim()) ? "null" : tbCost.Text.Trim(),
tbPacking.Text.Trim(),
tbContact.Text.Trim(),
cbStatus.Text.Trim(),
tbNotes.Text.Trim(),
tbDate.Text.Trim(),
this.stockId
);
}
db.ExecDataBySql(sql);
this.DialogResult = DialogResult.OK;
this.Close();
}
public bool CheckValues()
{
if (ItemsCheck.CheckTextBoxEmpty(tbPartNo) == false)
{
MessageBox.Show("Please input the Part Number.");
return(false);
}
if (!ItemsCheck.CheckTextBoxEmpty(tbMfg))
{
MessageBox.Show("Please input the MFG.");
return(false);
}
if (!ItemsCheck.CheckTextBoxEmpty(tbDc))
{
MessageBox.Show("Please input the D/C.");
return(false);
}
if (!ItemsCheck.CheckTextBoxEmpty(tbQty))
{
MessageBox.Show("Please input the Qty.");
return(false);
}
else
{
if (!ItemsCheck.CheckIntNumber(tbQty))
{
MessageBox.Show("The Qty should be an integer value.");
tbQty.Focus();
return(false);
}
}
if (ItemsCheck.CheckIntNumber(tbQtyRevd) && (!ItemsCheck.CheckIntNumber(tbQtyRevd)))
{
MessageBox.Show("The Qty Recv should be an integer value.");
tbQtyRevd.Focus();
return(false);
}
if (ItemsCheck.CheckIntNumber(tbQtyCorrected) && (!ItemsCheck.CheckIntNumber(tbQtyCorrected)))
{
MessageBox.Show("The Qty Corrected should be an integer value.");
tbQtyCorrected.Focus();
return(false);
}
if (ItemsCheck.CheckIntNumber(tbQtyAccept) && (!ItemsCheck.CheckIntNumber(tbQtyAccept)))
{
MessageBox.Show("The Qty Accept should be an integer value.");
tbQtyAccept.Focus();
return(false);
}
if (ItemsCheck.CheckIntNumber(tbQtyRejected) && (!ItemsCheck.CheckIntNumber(tbQtyRejected)))
{
MessageBox.Show("The Qty Rejected should be an integer value.");
tbQtyRejected.Focus();
return(false);
}
if (ItemsCheck.CheckIntNumber(tbQtyRtv) && (!ItemsCheck.CheckIntNumber(tbQtyRtv)))
{
MessageBox.Show("The Qty RTV should be an integer value.");
tbQtyRtv.Focus();
return(false);
}
if (ItemsCheck.CheckIntNumber(tbQcPending) && (!ItemsCheck.CheckIntNumber(tbQcPending)))
{
MessageBox.Show("The QC/Pending should be an integer value.");
tbQcPending.Focus();
return(false);
}
if (!ItemsCheck.CheckTextBoxEmpty(tbUnitPrice))
{
MessageBox.Show("Please input the Unit Price.");
tbUnitPrice.Focus();
return(false);
}
if (!ItemsCheck.CheckFloatNumber(tbUnitPrice))
{
MessageBox.Show("The Unit Price should be a float value.");
tbUnitPrice.Focus();
return(false);
}
return(true);
}
