public static List <PurchaseOrderDetail> AcceptSupply(int PONumber)
{
List <PurchaseOrderDetail> pli = new List <PurchaseOrderDetail>();
pli = PurchaseOrderDAO.AcceptSupply(PONumber);
return(pli);
}
public static void changeToAcknowledge(int pn)
{
UniversityStoreEntities context = new UniversityStoreEntities();
var q = from x in context.PurchaseOrderDetails
where x.PONumber == pn && x.PurchaseOrder.Status == STATUS_PENDING
select x;
PurchaseOrderDetail a = q.First <PurchaseOrderDetail>();
a.PurchaseOrder.Status = STATUS_ACKNOWLEGED;
PurchaseOrderDAO.changequantityinstock(pn);
context.SaveChanges();
}
public static void changeStatus(int pn)
{
PurchaseOrderDAO.changeToAcknowledge(pn);
PurchaseOrderDAO.changequantityinstock(pn);
}
/** added by wu
* */
public static List <Object> getAllOd(int pn)
{
return(PurchaseOrderDAO.getAllOrder(pn));
}
public static void ChangeStatusToApproved(int ponumber)
{
PurchaseOrderDAO.ChangeStatusToApproved(ponumber);
PurchaseOrderDAO.changequantityinstock(ponumber);
}
public static List <PurchaseOrder> getsupplies(String SupplierID)
{
List <PurchaseOrder> po = PurchaseOrderDAO.getsupplies(SupplierID);
return(po);
}
public static List <PurchaseOrderDetail> GetPendingItemsList(int poNumber)
{
return(PurchaseOrderDAO.GetPendingItemsList(poNumber));
}
public static ArrayList GetPendingPurchaseOrder()
{
return(PurchaseOrderDAO.GetPendingPurchaseOrders());
}
//public static void GetSupplyOrder(String[] PID, String[] SuppID, int[] QNTY, String[] SuppID2, int[] QNTY2, String[] SuppID3, int[] QNTY3)
//{
//UniversityStoreEntities context = new UniversityStoreEntities();
//int i = 0; int j = 0;
//PurchaseOrder pomain = new PurchaseOrder();
//PurchaseOrder pomain2 = new PurchaseOrder();
//PurchaseOrder pomain3 = new PurchaseOrder();
//List<PurchaseOrderDetail> lpod = new List<PurchaseOrderDetail>();
//List<PurchaseOrderDetail> lpod2 = new List<PurchaseOrderDetail>();
//List<PurchaseOrderDetail> lpod3 = new List<PurchaseOrderDetail>();
//foreach (String p in PID)
//{
// var q = from x in context.Products
// where x.ItemNumber == p
// select x;
// PurchaseOrder po = new PurchaseOrder();
// if (SuppID[i].Equals(q.First<Product>().Supplier1ID) || SuppID[i].Equals(q.First<Product>().Supplier2ID) || SuppID[i].Equals(q.First<Product>().Supplier3ID))
// {
// if (SuppID[i].Equals(q.First<Product>().Supplier1ID))
// {
// po.SupplierCode = q.First<Product>().Supplier1ID;
// po.DateCreated = DateTime.Now;
// po.Status = "Pending";
// pomain = po;
// }
// else if (SuppID[i].Equals(q.First<Product>().Supplier2ID))
// {
// po.SupplierCode = q.First<Product>().Supplier2ID;
// po.DateCreated = DateTime.Now;
// po.Status = "Pending";
// pomain2 = po;
// }
// else if (SuppID[i].Equals(q.First<Product>().Supplier3ID))
// {
// po.SupplierCode = q.First<Product>().Supplier3ID;
// po.DateCreated = DateTime.Now;
// po.Status = "Pending";
// pomain3 = po;
// }
// if (SuppID[i].Equals(q.First<Product>().Supplier1ID))
// {
// PurchaseOrderDetail pod = new PurchaseOrderDetail();
// var q1 = from x in context.Products
// where x.ItemNumber == p
// select x;
// pod.ItemNumber = p;
// pod.Description = q.First<Product>().Description;
// pod.Quantity = QNTY[i];
// String g = q1.First<Product>().Supplier1ID;
// var z = from x in context.SupplyDetails
// where x.SupplierCode == g && x.ItemNumber == p
// select x;
// SupplyDetail s = z.First<SupplyDetail>();
// pod.Price = s.Price;
// lpod.Add(pod);
// }
// else if (SuppID[i].Equals(q.First<Product>().Supplier2ID))
// {
// PurchaseOrderDetail pod = new PurchaseOrderDetail();
// var q1 = from x in context.Products
// where x.ItemNumber == p
// select x;
// pod.ItemNumber = p;
// pod.Description = q.First<Product>().Description;
// pod.Quantity = QNTY[i];
// String g = q1.First<Product>().Supplier2ID;
// var z = from x in context.SupplyDetails
// where x.SupplierCode == g && x.ItemNumber == p
// select x;
// pod.Price = z.First<SupplyDetail>().Price;
// lpod2.Add(pod);
// }
// else if (SuppID[i].Equals(q.First<Product>().Supplier3ID))
// {
// PurchaseOrderDetail pod = new PurchaseOrderDetail();
// var q1 = from x in context.Products
// where x.ItemNumber == p
// select x;
// pod.ItemNumber = p;
// pod.Description = q1.First<Product>().Description;
// pod.Quantity = QNTY[i];
// String g = q1.First<Product>().Supplier3ID;
// var z = from x in context.SupplyDetails
// where x.SupplierCode == g && x.ItemNumber == p
// select x;
// pod.Price = z.First<SupplyDetail>().Price;
// lpod3.Add(pod);
// }
// }
// i++;
//}
//foreach (String p in PID)
//{
// PurchaseOrder po2 = new PurchaseOrder();
// var q = from x in context.Products
// where x.ItemNumber == p
// select x;
// if (SuppID2[j].Equals(q.First<Product>().Supplier1ID) || SuppID2[j].Equals(q.First<Product>().Supplier2ID) || SuppID2[j].Equals(q.First<Product>().Supplier3ID))
// {
// String t = q.First<Product>().Supplier1ID;
// if (SuppID2[j].Equals(q.First<Product>().Supplier1ID))
// {
// po2.SupplierCode = q.First<Product>().Supplier1ID;
// po2.DateCreated = DateTime.Now;
// po2.Status = "Pending";
// pomain = po2;
// }
// else if (SuppID2[j].Equals(q.First<Product>().Supplier2ID))
// {
// po2.SupplierCode = q.First<Product>().Supplier2ID;
// po2.DateCreated = DateTime.Now;
// po2.Status = "Pending";
// pomain2 = po2;
// }
// else if (SuppID2[j].Equals(q.First<Product>().Supplier3ID))
// {
// po2.SupplierCode = q.First<Product>().Supplier3ID;
// po2.DateCreated = DateTime.Now;
// po2.Status = "Pending";
// pomain3 = po2;
// pomain3 = po2;
// }
// if (SuppID2[j].Equals(q.First<Product>().Supplier1ID) && QNTY2[j] > 0)
// {
// PurchaseOrderDetail pod2 = new PurchaseOrderDetail();
// var q2 = from x in context.Products
// where x.ItemNumber == p
// select x;
// pod2.ItemNumber = p;
// pod2.Description = q2.First<Product>().Description;
// pod2.Quantity = QNTY2[j];
// String g = q2.First<Product>().Supplier1ID;
// var z = from x in context.SupplyDetails
// where x.SupplierCode == g && x.ItemNumber == p
// select x;
// pod2.Price = z.First<SupplyDetail>().Price;
// lpod.Add(pod2);
// }
// else if (SuppID2[j].Equals(q.First<Product>().Supplier2ID) && QNTY2[j] > 0)
// {
// PurchaseOrderDetail pod2 = new PurchaseOrderDetail();
// var q2 = from x in context.Products
// where x.ItemNumber == p
// select x;
// pod2.ItemNumber = p;
// pod2.Description = q2.First<Product>().Description;
// pod2.Quantity = QNTY2[j];
// String g = q2.First<Product>().Supplier2ID;
// var z = from x in context.SupplyDetails
// where x.SupplierCode == g && x.ItemNumber == p
// select x;
// pod2.Price = z.First<SupplyDetail>().Price;
// lpod2.Add(pod2);
// }
// else if (SuppID2[j].Equals(q.First<Product>().Supplier3ID) && QNTY2[j] > 0)
// {
// PurchaseOrderDetail pod2 = new PurchaseOrderDetail();
// var q2 = from x in context.Products
// where x.ItemNumber == p
// select x;
// pod2.ItemNumber = p;
// pod2.Description = q2.First<Product>().Description;
// pod2.Quantity = QNTY2[j];
// String g = q2.First<Product>().Supplier3ID;
// var z = from x in context.SupplyDetails
// where x.SupplierCode == g && x.ItemNumber == p
// select x;
// pod2.Price = z.First<SupplyDetail>().Price;
// lpod3.Add(pod2);
// }
// }
// j++;
//}
//int k = 0;
//foreach (String p in PID)
//{
// PurchaseOrder po3 = new PurchaseOrder();
// var q = from x in context.Products
// where x.ItemNumber == p
// select x;
// if (SuppID3[k].Equals(q.First<Product>().Supplier1ID) || SuppID3[k].Equals(q.First<Product>().Supplier2ID) || SuppID3[k].Equals(q.First<Product>().Supplier3ID))
// {
// if (SuppID3[k].Equals(q.First<Product>().Supplier1ID))
// {
// po3.SupplierCode = q.First<Product>().Supplier1ID;
// po3.DateCreated = DateTime.Now;
// po3.Status = "Pending";
// pomain = po3;
// }
// else if (SuppID3[k].Equals(q.First<Product>().Supplier2ID))
// {
// po3.SupplierCode = q.First<Product>().Supplier2ID;
// po3.DateCreated = DateTime.Now;
// po3.Status = "Pending";
// pomain2 = po3;
// }
// else if (SuppID3[k].Equals(q.First<Product>().Supplier3ID))
// {
// po3.SupplierCode = q.First<Product>().Supplier3ID;
// po3.DateCreated = DateTime.Now;
// po3.Status = "Pending";
// pomain3 = po3;
// }
// if (SuppID3[k].Equals(q.First<Product>().Supplier1ID) && QNTY3[k] > 0)
// {
// PurchaseOrderDetail pod3 = new PurchaseOrderDetail();
// var q3 = from x in context.Products
// where x.ItemNumber == p
// select x;
// pod3.ItemNumber = p;
// pod3.Description = q3.First<Product>().Description;
// pod3.Quantity = QNTY3[k];
// String g = q3.First<Product>().Supplier1ID;
// var z = from x in context.SupplyDetails
// where x.SupplierCode == g && x.ItemNumber == p
// select x;
// pod3.Price = z.First<SupplyDetail>().Price;
// lpod.Add(pod3);
// }
// else if (SuppID3[k].Equals(q.First<Product>().Supplier2ID) && QNTY3[k] > 0)
// {
// PurchaseOrderDetail pod3 = new PurchaseOrderDetail();
// var q3 = from x in context.Products
// where x.ItemNumber == p
// select x;
// pod3.ItemNumber = p;
// pod3.Description = q3.First<Product>().Description;
// pod3.Quantity = QNTY3[k];
// String g = q3.First<Product>().Supplier2ID;
// var z = from x in context.SupplyDetails
// where x.SupplierCode == g && x.ItemNumber == p
// select x;
// pod3.Price = z.First<SupplyDetail>().Price;
// lpod2.Add(pod3);
// }
// else if (SuppID3[k].Equals(q.First<Product>().Supplier3ID) && QNTY3[k] > 0)
// {
// PurchaseOrderDetail pod3 = new PurchaseOrderDetail();
// var q3 = from x in context.Products
// where x.ItemNumber == p
// select x;
// pod3.ItemNumber = p;
// pod3.Description = q3.First<Product>().Description;
// pod3.Quantity = QNTY3[k];
// String g = q3.First<Product>().Supplier3ID;
// var z = from x in context.SupplyDetails
// where x.SupplierCode == g && x.ItemNumber == p
// select x;
// pod3.Price = z.First<SupplyDetail>().Price;
// lpod3.Add(pod3);
// }
// }
// k++;
//}
//if (pomain.SupplierCode != null&& lpod.Count>0)
// PurchaseOrderDAO.CreatePurchaseOrder(pomain, lpod);
//if (pomain2.SupplierCode != null&&lpod2.Count>0)
// PurchaseOrderDAO.CreatePurchaseOrder(pomain2, lpod2);
//if (pomain3.SupplierCode != null&&lpod3.Count>0)
// PurchaseOrderDAO.CreatePurchaseOrder(pomain3, lpod3);
public static void GetSupplyOrder(String[] PID, String[] SuppID, int[] QNTY, String[] SuppID2, int[] QNTY2, String[] SuppID3, int[] QNTY3)
{
List <PurchaseOrder> po = new List <PurchaseOrder>();
List <string> currentSuppylists = new List <string>();
List <Int32> supplierPOid = new List <Int32>();
//PurchaseOrder pon = new PurchaseOrder();
List <PurchaseOrderDetail> pod = new List <PurchaseOrderDetail>();
UniversityStoreEntities context = new UniversityStoreEntities();
int i = 0; int j = 0;
foreach (String s in PID)
{
var q = from x in context.Products
where x.ItemNumber == s
select x;
Product product = q.First <Product>();
string description = product.Description;
if (SuppID[i].Equals(q.First <Product>().Supplier1ID) || SuppID[i].Equals(q.First <Product>().Supplier2ID) || SuppID[i].Equals(q.First <Product>().Supplier3ID))
{
if (SuppID[i].Equals(q.First <Product>().Supplier1ID))
{
string supplir = SuppID[i];
var kk = from x in context.SupplyDetails
where x.SupplierCode == supplir && x.ItemNumber == s
select x;
SupplyDetail ssd = kk.First <SupplyDetail>();
string priceee = ssd.Price.ToString();
string supID = q.First <Product>().Supplier1ID;
if (currentSuppylists.Contains(supID))
{
int pos = currentSuppylists.IndexOf(supID);
int ppid = supplierPOid[pos];
PurchaseOrderDAO.generateDetails(ppid, priceee, s, QNTY[i], description);
}
else
{
int pid = PurchaseOrderDAO.generatePO(supID);
supplierPOid.Add(pid);
currentSuppylists.Add(supID);
PurchaseOrderDAO.generateDetails(pid, priceee, s, QNTY[i], description);
}
}
if (SuppID[i].Equals(q.First <Product>().Supplier2ID))
{
string supplir = SuppID[i];
var kk = from x in context.SupplyDetails
where x.SupplierCode == supplir && x.ItemNumber == s
select x;
SupplyDetail ssd = kk.First <SupplyDetail>();
string priceee = ssd.Price.ToString();
string supID = q.First <Product>().Supplier2ID;
if (currentSuppylists.Contains(supID))
{
int pos = currentSuppylists.IndexOf(supID);
int ppid = supplierPOid[pos];
PurchaseOrderDAO.generateDetails(ppid, priceee, s, QNTY[i], description);
}
else
{
int pid = PurchaseOrderDAO.generatePO(supID);
supplierPOid.Add(pid);
currentSuppylists.Add(supID);
PurchaseOrderDAO.generateDetails(pid, priceee, s, QNTY[i], description);
}
}
if (SuppID[i].Equals(q.First <Product>().Supplier3ID))
{
string supplir = SuppID[i];
var kk = from x in context.SupplyDetails
where x.SupplierCode == supplir && x.ItemNumber == s
select x;
SupplyDetail ssd = kk.First <SupplyDetail>();
string priceee = ssd.Price.ToString();
string supID = q.First <Product>().Supplier3ID;
if (currentSuppylists.Contains(supID))
{
int pos = currentSuppylists.IndexOf(supID);
int ppid = supplierPOid[pos];
PurchaseOrderDAO.generateDetails(ppid, priceee, s, QNTY2[i], description);
}
else
{
int pid = PurchaseOrderDAO.generatePO(supID);
supplierPOid.Add(pid);
currentSuppylists.Add(supID);
PurchaseOrderDAO.generateDetails(pid, priceee, s, QNTY[i], description);
}
}
}
if (SuppID2[i].Equals(q.First <Product>().Supplier1ID) || SuppID2[i].Equals(q.First <Product>().Supplier2ID) || SuppID2[i].Equals(q.First <Product>().Supplier3ID))
{
if (SuppID2[i].Equals(q.First <Product>().Supplier1ID))
{
string supplir = SuppID2[i];
var kk = from x in context.SupplyDetails
where x.SupplierCode == supplir && x.ItemNumber == s
select x;
SupplyDetail ssd = kk.First <SupplyDetail>();
string priceee = ssd.Price.ToString();
string supID = q.First <Product>().Supplier1ID;
if (currentSuppylists.Contains(supID))
{
int pos = currentSuppylists.IndexOf(supID);
int ppid = supplierPOid[pos];
PurchaseOrderDAO.generateDetails(ppid, priceee, s, QNTY2[i], description);
}
else
{
int pid = PurchaseOrderDAO.generatePO(supID);
supplierPOid.Add(pid);
currentSuppylists.Add(supID);
PurchaseOrderDAO.generateDetails(pid, priceee, s, QNTY2[i], description);
}
}
if (SuppID2[i].Equals(q.First <Product>().Supplier2ID))
{
string supplir = SuppID2[i];
var kk = from x in context.SupplyDetails
where x.SupplierCode == supplir && x.ItemNumber == s
select x;
SupplyDetail ssd = kk.First <SupplyDetail>();
string priceee = ssd.Price.ToString();
string supID = q.First <Product>().Supplier2ID;
if (currentSuppylists.Contains(supID))
{
int pos = currentSuppylists.IndexOf(supID);
int ppid = supplierPOid[pos];
PurchaseOrderDAO.generateDetails(ppid, priceee, s, QNTY2[i], description);
}
else
{
int pid = PurchaseOrderDAO.generatePO(supID);
supplierPOid.Add(pid);
currentSuppylists.Add(supID);
PurchaseOrderDAO.generateDetails(pid, priceee, s, QNTY2[i], description);
}
}
if (SuppID2[i].Equals(q.First <Product>().Supplier3ID))
{
string supplir = SuppID2[i];
var kk = from x in context.SupplyDetails
where x.SupplierCode == supplir && x.ItemNumber == s
select x;
SupplyDetail ssd = kk.First <SupplyDetail>();
string priceee = ssd.Price.ToString();
string supID = q.First <Product>().Supplier3ID;
if (currentSuppylists.Contains(supID))
{
int pos = currentSuppylists.IndexOf(supID);
int ppid = supplierPOid[pos];
PurchaseOrderDAO.generateDetails(ppid, priceee, s, QNTY2[i], description);
}
else
{
int pid = PurchaseOrderDAO.generatePO(supID);
currentSuppylists.Add(supID);
supplierPOid.Add(pid);
PurchaseOrderDAO.generateDetails(pid, priceee, s, QNTY2[i], description);
}
}
}
if (SuppID3[i].Equals(q.First <Product>().Supplier1ID) || SuppID3[i].Equals(q.First <Product>().Supplier2ID) || SuppID3[i].Equals(q.First <Product>().Supplier3ID))
{
if (SuppID3[i].Equals(q.First <Product>().Supplier1ID))
{
string supplir = SuppID3[i];
var kk = from x in context.SupplyDetails
where x.SupplierCode == supplir && x.ItemNumber == s
select x;
SupplyDetail ssd = kk.First <SupplyDetail>();
string priceee = ssd.Price.ToString();
string supID = q.First <Product>().Supplier1ID;
if (currentSuppylists.Contains(supID))
{
int pos = currentSuppylists.IndexOf(supID);
int ppid = supplierPOid[pos];
PurchaseOrderDAO.generateDetails(ppid, priceee, s, QNTY3[i], description);
}
else
{
int pid = PurchaseOrderDAO.generatePO(supID);
currentSuppylists.Add(supID);
supplierPOid.Add(pid);
PurchaseOrderDAO.generateDetails(pid, priceee, s, QNTY3[i], description);
}
}
if (SuppID3[i].Equals(q.First <Product>().Supplier2ID))
{
string supplir = SuppID3[i];
var kk = from x in context.SupplyDetails
where x.SupplierCode == supplir && x.ItemNumber == s
select x;
SupplyDetail ssd = kk.First <SupplyDetail>();
string priceee = ssd.Price.ToString();
string supID = q.First <Product>().Supplier2ID;
if (currentSuppylists.Contains(supID))
{
int pos = currentSuppylists.IndexOf(supID);
int ppid = supplierPOid[pos];
PurchaseOrderDAO.generateDetails(ppid, priceee, s, QNTY3[i], description);
}
else
{
int pid = PurchaseOrderDAO.generatePO(supID);
currentSuppylists.Add(supID);
supplierPOid.Add(pid);
PurchaseOrderDAO.generateDetails(pid, priceee, s, QNTY3[i], description);
}
}
if (SuppID3[i].Equals(q.First <Product>().Supplier3ID))
{
string supplir = SuppID[i];
var kk = from x in context.SupplyDetails
where x.SupplierCode == supplir && x.ItemNumber == s
select x;
SupplyDetail ssd = kk.First <SupplyDetail>();
string priceee = ssd.Price.ToString();
string supID = q.First <Product>().Supplier3ID;
if (currentSuppylists.Contains(supID))
{
int pos = currentSuppylists.IndexOf(supID);
int ppid = supplierPOid[pos];
PurchaseOrderDAO.generateDetails(ppid, priceee, s, QNTY3[i], description);
}
else
{
int pid = PurchaseOrderDAO.generatePO(supID);
currentSuppylists.Add(supID);
supplierPOid.Add(pid);
PurchaseOrderDAO.generateDetails(pid, priceee, s, QNTY3[i], description);
}
}
}
i++;
}
//if (pomain.SupplierCode != null)
// PurchaseOrderDAO.CreatePurchaseOrder(pomain, lpod);
//if (pomain2.SupplierCode != null)
// PurchaseOrderDAO.CreatePurchaseOrder(pomain2, lpod2);
//if (pomain3.SupplierCode != null)
// PurchaseOrderDAO.CreatePurchaseOrder(pomain3, lpod3);
}
public static void GetSupplyOrder(String[] PID, String[] SuppID, int[] QNTY, String[] SuppID2, int[] QNTY2, String[] SuppID3, int[] QNTY3)
{
int i = 0; int j = 0;
PurchaseOrder pomain = new PurchaseOrder();
PurchaseOrder pomain2 = new PurchaseOrder();
PurchaseOrder pomain3 = new PurchaseOrder();
List <PurchaseOrderDetail> lpod = new List <PurchaseOrderDetail>();
List <PurchaseOrderDetail> lpod2 = new List <PurchaseOrderDetail>();
List <PurchaseOrderDetail> lpod3 = new List <PurchaseOrderDetail>();
foreach (String p in PID)
{
var q = from x in context.Products
where x.ItemNumber == p
select x;
PurchaseOrder po = new PurchaseOrder();
if (SuppID[i].Equals(q.First <Product>().Supplier1ID) || SuppID[i].Equals(q.First <Product>().Supplier2ID) || SuppID[i].Equals(q.First <Product>().Supplier3ID))
{
if (SuppID[i].Equals(q.First <Product>().Supplier1ID))
{
po.SupplierCode = q.First <Product>().Supplier1ID;
po.DateCreated = DateTime.Now;
po.Status = "Pending";
pomain = po;
}
else if (SuppID[i].Equals(q.First <Product>().Supplier2ID))
{
po.SupplierCode = q.First <Product>().Supplier2ID;
po.DateCreated = DateTime.Now;
po.Status = "Pending";
pomain2 = po;
}
else if (SuppID[i].Equals(q.First <Product>().Supplier3ID))
{
po.SupplierCode = q.First <Product>().Supplier3ID;
po.DateCreated = DateTime.Now;
po.Status = "Pending";
pomain3 = po;
}
if (SuppID[i].Equals(q.First <Product>().Supplier1ID))
{
PurchaseOrderDetail pod = new PurchaseOrderDetail();
var q1 = from x in context.Products
where x.ItemNumber == p
select x;
pod.ItemNumber = p;
pod.Description = q.First <Product>().Description;
pod.Quantity = QNTY[i];
String g = q1.First <Product>().Supplier1ID;
var z = from x in context.SupplyDetails
where x.SupplierCode == g && x.ItemNumber == p
select x;
SupplyDetail s = z.First <SupplyDetail>();
pod.Price = s.Price;
lpod.Add(pod);
}
else if (SuppID[i].Equals(q.First <Product>().Supplier2ID))
{
PurchaseOrderDetail pod = new PurchaseOrderDetail();
var q1 = from x in context.Products
where x.ItemNumber == p
select x;
pod.ItemNumber = p;
pod.Description = q.First <Product>().Description;
pod.Quantity = QNTY[i];
String g = q1.First <Product>().Supplier2ID;
var z = from x in context.SupplyDetails
where x.SupplierCode == g && x.ItemNumber == p
select x;
pod.Price = z.First <SupplyDetail>().Price;
lpod2.Add(pod);
}
else if (SuppID[i].Equals(q.First <Product>().Supplier3ID))
{
PurchaseOrderDetail pod = new PurchaseOrderDetail();
var q1 = from x in context.Products
where x.ItemNumber == p
select x;
pod.ItemNumber = p;
pod.Description = q1.First <Product>().Description;
pod.Quantity = QNTY[i];
String g = q1.First <Product>().Supplier3ID;
var z = from x in context.SupplyDetails
where x.SupplierCode == g && x.ItemNumber == p
select x;
pod.Price = z.First <SupplyDetail>().Price;
lpod3.Add(pod);
}
}
i++;
}
foreach (String p in PID)
{
PurchaseOrder po2 = new PurchaseOrder();
var q = from x in context.Products
where x.ItemNumber == p
select x;
if (SuppID2[j].Equals(q.First <Product>().Supplier1ID) || SuppID2[j].Equals(q.First <Product>().Supplier2ID) || SuppID2[j].Equals(q.First <Product>().Supplier3ID))
{
String t = q.First <Product>().Supplier1ID;
if (SuppID2[j].Equals(q.First <Product>().Supplier1ID))
{
po2.SupplierCode = q.First <Product>().Supplier1ID;
po2.DateCreated = DateTime.Now;
po2.Status = "Pending";
pomain = po2;
}
else if (SuppID2[j].Equals(q.First <Product>().Supplier2ID))
{
po2.SupplierCode = q.First <Product>().Supplier2ID;
po2.DateCreated = DateTime.Now;
po2.Status = "Pending";
pomain2 = po2;
}
else if (SuppID2[j].Equals(q.First <Product>().Supplier3ID))
{
po2.SupplierCode = q.First <Product>().Supplier3ID;
po2.DateCreated = DateTime.Now;
po2.Status = "Pending";
pomain3 = po2;
}
if (SuppID2[j].Equals(q.First <Product>().Supplier1ID) && QNTY2[j] > 0)
{
PurchaseOrderDetail pod2 = new PurchaseOrderDetail();
var q2 = from x in context.Products
where x.ItemNumber == p
select x;
pod2.ItemNumber = p;
pod2.Description = q2.First <Product>().Description;
pod2.Quantity = QNTY2[j];
String g = q2.First <Product>().Supplier1ID;
var z = from x in context.SupplyDetails
where x.SupplierCode == g && x.ItemNumber == p
select x;
pod2.Price = z.First <SupplyDetail>().Price;
lpod.Add(pod2);
}
else if (SuppID2[j].Equals(q.First <Product>().Supplier2ID) && QNTY2[j] > 0)
{
PurchaseOrderDetail pod2 = new PurchaseOrderDetail();
var q2 = from x in context.Products
where x.ItemNumber == p
select x;
pod2.ItemNumber = p;
pod2.Description = q2.First <Product>().Description;
pod2.Quantity = QNTY2[j];
String g = q2.First <Product>().Supplier2ID;
var z = from x in context.SupplyDetails
where x.SupplierCode == g && x.ItemNumber == p
select x;
pod2.Price = z.First <SupplyDetail>().Price;
lpod2.Add(pod2);
}
else if (SuppID2[j].Equals(q.First <Product>().Supplier3ID) && QNTY2[j] > 0)
{
PurchaseOrderDetail pod2 = new PurchaseOrderDetail();
var q2 = from x in context.Products
where x.ItemNumber == p
select x;
pod2.ItemNumber = p;
pod2.Description = q2.First <Product>().Description;
pod2.Quantity = QNTY2[j];
String g = q2.First <Product>().Supplier3ID;
var z = from x in context.SupplyDetails
where x.SupplierCode == g && x.ItemNumber == p
select x;
pod2.Price = z.First <SupplyDetail>().Price;
lpod3.Add(pod2);
}
}
j++;
}
int k = 0;
foreach (String p in PID)
{
PurchaseOrder po3 = new PurchaseOrder();
var q = from x in context.Products
where x.ItemNumber == p
select x;
if (SuppID3[k].Equals(q.First <Product>().Supplier1ID) || SuppID3[k].Equals(q.First <Product>().Supplier2ID) || SuppID3[k].Equals(q.First <Product>().Supplier3ID))
{
if (SuppID3[k].Equals(q.First <Product>().Supplier1ID))
{
po3.SupplierCode = q.First <Product>().Supplier1ID;
po3.DateCreated = DateTime.Now;
po3.Status = "Pending";
pomain = po3;
}
else if (SuppID3[k].Equals(q.First <Product>().Supplier2ID))
{
po3.SupplierCode = q.First <Product>().Supplier2ID;
po3.DateCreated = DateTime.Now;
po3.Status = "Pending";
pomain2 = po3;
}
else if (SuppID3[k].Equals(q.First <Product>().Supplier3ID))
{
po3.SupplierCode = q.First <Product>().Supplier3ID;
po3.DateCreated = DateTime.Now;
po3.Status = "Pending";
pomain3 = po3;
}
if (SuppID3[k].Equals(q.First <Product>().Supplier1ID) && QNTY3[k] > 0)
{
PurchaseOrderDetail pod3 = new PurchaseOrderDetail();
var q3 = from x in context.Products
where x.ItemNumber == p
select x;
pod3.ItemNumber = p;
pod3.Description = q3.First <Product>().Description;
pod3.Quantity = QNTY3[k];
String g = q3.First <Product>().Supplier1ID;
var z = from x in context.SupplyDetails
where x.SupplierCode == g && x.ItemNumber == p
select x;
pod3.Price = z.First <SupplyDetail>().Price;
lpod.Add(pod3);
}
else if (SuppID3[k].Equals(q.First <Product>().Supplier2ID) && QNTY3[k] > 0)
{
PurchaseOrderDetail pod3 = new PurchaseOrderDetail();
var q3 = from x in context.Products
where x.ItemNumber == p
select x;
pod3.ItemNumber = p;
pod3.Description = q3.First <Product>().Description;
pod3.Quantity = QNTY3[k];
String g = q3.First <Product>().Supplier2ID;
var z = from x in context.SupplyDetails
where x.SupplierCode == g && x.ItemNumber == p
select x;
pod3.Price = z.First <SupplyDetail>().Price;
lpod2.Add(pod3);
}
else if (SuppID3[k].Equals(q.First <Product>().Supplier3ID) && QNTY3[k] > 0)
{
PurchaseOrderDetail pod3 = new PurchaseOrderDetail();
var q3 = from x in context.Products
where x.ItemNumber == p
select x;
pod3.ItemNumber = p;
pod3.Description = q3.First <Product>().Description;
pod3.Quantity = QNTY3[k];
String g = q3.First <Product>().Supplier3ID;
var z = from x in context.SupplyDetails
where x.SupplierCode == g && x.ItemNumber == p
select x;
pod3.Price = z.First <SupplyDetail>().Price;
lpod3.Add(pod3);
}
}
k++;
}
if (pomain.SupplierCode != null)
{
PurchaseOrderDAO.CreatePurchaseOrder(pomain, lpod);
}
if (pomain2.SupplierCode != null)
{
PurchaseOrderDAO.CreatePurchaseOrder(pomain2, lpod2);
}
if (pomain3.SupplierCode != null)
{
PurchaseOrderDAO.CreatePurchaseOrder(pomain3, lpod3);
}
}
