public void AddPO(PO PO)
{
// Initialize SPROC
SqlConnection conn = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("SPPOInsert", conn);
cmd.CommandType = CommandType.StoredProcedure;
// Add Parameters
cmd.Parameters.AddWithValue("@PoNumber", PO.PoNumber);
cmd.Parameters.AddWithValue("@CustomerID", PO.CustomerID);
cmd.Parameters.AddWithValue("@PartNumber", PO.PartNumber);
cmd.Parameters.AddWithValue("@TrackingNumber", PO.TrackingNumber);
cmd.Parameters.AddWithValue("@ReceiveDate", PO.ReceiveDate);
cmd.Parameters.AddWithValue("@HotPart", PO.HotPart);
cmd.Parameters.AddWithValue("@Color", PO.Color);
cmd.Parameters.AddWithValue("@Comments", PO.Comments);
cmd.Parameters.AddWithValue("@InitialQty", PO.InitialQty);
cmd.Parameters.AddWithValue("@OnHandQty", PO.OnHandQty);
cmd.Parameters.AddWithValue("@InventoryQty", PO.InventoryQty);
cmd.Parameters.AddWithValue("@FabRejectQty", PO.FabRejectQty);
cmd.Parameters.AddWithValue("@PaintRejectQty", PO.PaintRejectQty);
cmd.Parameters.AddWithValue("@POStatus", PO.POStatus);
cmd.Parameters.AddWithValue("@RcvComment", PO.RcvComment);
cmd.Parameters.AddWithValue("@InvComment", PO.InvComment);
cmd.Parameters.AddWithValue("@ShipComment", PO.ShipComment);
cmd.Parameters.AddWithValue("@ShipTo", PO.ShipTo);
cmd.Parameters.AddWithValue("@BillTo", PO.BillTo);
cmd.Parameters.AddWithValue("@ShippedQty", PO.ShippedQty);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
reload();
}
private void button1_Click(object sender, EventArgs e)
{
//Save
if ((PoNum.Text != "") && (InitQty.Text != ""))
{
PO tPO = Form2Object();
if (cid == 0)
{
POL.AddPO(tPO);
PO tPO2 = new PO();
tPO2 = POL.FindPO(tPO.CustomerID, tPO.PartNumber, tPO.ReceiveDate, tPO.PoNumber);
cid = tPO.Id;
}
else
{
tPO.Id = cid;
POL.UpdatePO(tPO);
}
MessageBox.Show("PO has Been Saved");
ClearRcv(sender, e);
}
else
{
MessageBox.Show("Must have PO Number and Inital Quantity");
}
}
public static PO PopulatePOFromSqlDataReader(SqlDataReader dr)
{
PO pO = new PO();
pO.Id = Convert.ToInt32(dr["Id"]);
pO.PoNumber = Convert.ToString(dr["PoNumber"]);
pO.CustomerID = Convert.ToInt32(dr["CustomerID"]);
pO.PartNumber = Convert.ToString(dr["PartNumber"]);
pO.TrackingNumber = Convert.ToString(dr["TrackingNumber"]);
pO.ReceiveDate = Convert.ToDateTime(dr["ReceiveDate"]);
pO.HotPart = Convert.ToString(dr["HotPart"]);
pO.Color = Convert.ToString(dr["Color"]);
pO.Comments = Convert.ToString(dr["Comments"]);
pO.InitialQty = Convert.ToInt32(dr["InitialQty"]);
pO.OnHandQty = Convert.ToInt32(dr["OnHandQty"]);
pO.InventoryQty = Convert.ToInt32(dr["InventoryQty"]);
pO.FabRejectQty = Convert.ToInt32(dr["FabRejectQty"]);
pO.PaintRejectQty = Convert.ToInt32(dr["PaintRejectQty"]);
pO.ShippedQty = Convert.ToInt32(dr["ShippedQty"]);
pO.POStatus = Convert.ToString(dr["POStatus"]);
pO.RcvComment = Convert.ToString(dr["RcvComment"]);
pO.InvComment = Convert.ToString(dr["InvComment"]);
pO.ShipComment = Convert.ToString(dr["ShipComment"]);
pO.ShipTo = Convert.ToInt32(dr["ShipTo"]);
pO.BillTo = Convert.ToInt32(dr["BillTo"]);
if (dr["CloseDate"] != System.DBNull.Value)
{
pO.CloseDate = Convert.ToDateTime(dr["CloseDate"]);
}
if (dr["LastShipDate"] != System.DBNull.Value)
{
pO.LastShipDate = Convert.ToDateTime(dr["LastShipDate"]);
}
return pO;
}
public void AddPO(PO po)
{
initRcvQty += po.InitialQty;
shippedQty += po.ShippedQty;
onHandQty += po.InventoryQty;
backOrderQty += po.OnHandQty;
}
private void button1_Click(object sender, EventArgs e)
{
DataGridViewRow item = dataGridView1.SelectedRows[0];
String PONum = item.Cells[0].Value.ToString();
DateTime rcv = DateTime.Parse(item.Cells[2].Value.ToString());
rcvPO = pList.FindPO(CustID, PartNum, rcv, PONum);
this.Hide();
}
public void UpdatePO(PO PO)
{
// Initialize SPROC
SqlConnection conn = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("SPPOUpdate", conn);
cmd.CommandType = CommandType.StoredProcedure;
// Update Parameters
cmd.Parameters.AddWithValue("@Id", PO.Id);
cmd.Parameters.AddWithValue("@PoNumber", PO.PoNumber);
cmd.Parameters.AddWithValue("@CustomerID", PO.CustomerID);
cmd.Parameters.AddWithValue("@PartNumber", PO.PartNumber);
cmd.Parameters.AddWithValue("@TrackingNumber", PO.TrackingNumber);
cmd.Parameters.AddWithValue("@ReceiveDate", PO.ReceiveDate);
cmd.Parameters.AddWithValue("@HotPart", PO.HotPart);
cmd.Parameters.AddWithValue("@Color", PO.Color);
cmd.Parameters.AddWithValue("@Comments", PO.Comments);
cmd.Parameters.AddWithValue("@InitialQty", PO.InitialQty);
cmd.Parameters.AddWithValue("@OnHandQty", PO.OnHandQty);
cmd.Parameters.AddWithValue("@InventoryQty", PO.InventoryQty);
cmd.Parameters.AddWithValue("@FabRejectQty", PO.FabRejectQty);
cmd.Parameters.AddWithValue("@PaintRejectQty", PO.PaintRejectQty);
cmd.Parameters.AddWithValue("@ShippedQty", PO.ShippedQty);
cmd.Parameters.AddWithValue("@POStatus", PO.POStatus);
cmd.Parameters.AddWithValue("@RcvComment", PO.RcvComment);
cmd.Parameters.AddWithValue("@InvComment", PO.InvComment);
cmd.Parameters.AddWithValue("@ShipComment", PO.ShipComment);
cmd.Parameters.AddWithValue("@ShipTo", PO.ShipTo);
cmd.Parameters.AddWithValue("@BillTo", PO.BillTo);
if (PO.CloseDate == null)
{
cmd.Parameters.AddWithValue("@CloseDate", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@CloseDate", PO.CloseDate);
}
if (PO.LastShipDate == null)
{
cmd.Parameters.AddWithValue("@LastShipDate", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@LastShipDate", PO.LastShipDate);
}
cmd.Parameters.AddWithValue("@DaysAtAFI", PO.GetDaysatAFI());
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
reload();
}
public PO GetPOByID(PO POID)
{
// Initialize SPROC
SqlConnection conn = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("SPGETPOID", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = null;
PO pO = null;
// GetByID Parameters
cmd.Parameters.AddWithValue("@POID", POID);
// Execute
conn.Open();
reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (reader.Read())
{
pO = PopulatePOFromSqlDataReader(reader);
}
conn.Close();
return pO;
}
private PO Form2Object()
{
Customer TCust = CustList.SearchCustomer(CustCombo.Text);
string hotpart ="N";
if(HotPartCB.Checked)
{
hotpart ="Y";
}
PO po = new PO(PoNum.Text,TCust.ID,PartCombo.Text,Tracking.Text,RcvDate.Value,hotpart,Colorlbl.Text,int.Parse(InitQty.Text),RcvComments.Text);
po.OnHandQty = po.InitialQty;
return po;
}
private void PopGrid(PO po)
{
DataGridViewRow item = new DataGridViewRow();
item.CreateCells(InvPOGrid);
item.Cells[0].Value = po.PoNumber;
item.Cells[1].Value = po.ReceiveDate;
item.Cells[2].Value = po.InitialQty;
item.Cells[3].Value = po.FabRejectQty;
item.Cells[4].Value = po.PaintRejectQty;
item.Cells[5].Value = po.InventoryQty;
item.Cells[6].Value = po.ShippedQty;
item.Cells[7].Value = po.POStatus;
item.Cells[8].Value = po.Id;
item.Cells[9].Value = po.OnHandQty;
if (item.Cells[2].Value.ToString() == "")
{
item.Cells[2].Value = "0";
}
if (item.Cells[3].Value.ToString() == "")
{
item.Cells[3].Value = "0";
}
if (item.Cells[4].Value.ToString() == "")
{
item.Cells[4].Value = "0";
}
if (item.Cells[5].Value.ToString() == "")
{
item.Cells[5].Value = "0";
}
if (item.Cells[6].Value.ToString() == "")
{
item.Cells[6].Value = "0";
}
InvPOGrid.Rows.Add(item);
}
private int PopGrid(PO po)
{
int totalavqty = 0;
DataGridViewRow item = new DataGridViewRow();
item.CreateCells(OpenPOGrid);
item.Cells[0].Value = po.PoNumber;
item.Cells[1].Value = po.ReceiveDate;
item.Cells[2].Value = po.InventoryQty;
item.Cells[3].Value = po.PaintRejectQty;
item.Cells[4].Value = po.FabRejectQty;
item.Cells[5].Value = po.OnHandQty;
item.Cells[6].Value = po.InvComment;
if (item.Cells[2].Value.ToString() == "")
{
item.Cells[2].Value = "0";
}
if (item.Cells[3].Value.ToString() == "")
{
item.Cells[3].Value = "0";
}
if (item.Cells[4].Value.ToString() == "")
{
item.Cells[4].Value = "0";
}
if (item.Cells[5].Value.ToString() == "")
{
item.Cells[5].Value = "0";
}
if (item.Cells[6].Value.ToString() != "")
{
item.Cells[7].Value = "*";
}
else
{
item.Cells[7].Value = "";
}
totalavqty = totalavqty + int.Parse(item.Cells[5].Value.ToString());
OpenPOGrid.Rows.Add(item);
return totalavqty;
}