public int UpdationOrder(PurchaseOrderForm orderData)
{
try
{
using (SDNPurchasingDBEntities entities = new SDNPurchasingDBEntities())
{
PurchaseOrder obj = entities.PurchaseOrders.Where(e => e.PO_No == orderData.Order.OrderNo
).SingleOrDefault();
if (obj != null)
{
//obj.ID = orderData.Order.ID;
obj.Sup_Id = orderData.Order.SupplierID;
// obj.PO_Conv_to_PO = orderData.Order.PO_Conv_to_PO;
// obj.PO_Conv_to_PI = orderData.Order.PO_Conv_to_PI;
obj.PO_Date = orderData.Order.OrderDate;
obj.PO_GST_Amt = Convert.ToDecimal(orderData.Order.TotalTax);
obj.PO_No = orderData.Order.OrderNo;
obj.PO_TandC = orderData.Order.TermsAndConditions;
obj.PO_Tot_aft_Tax = Convert.ToDecimal(orderData.Order.TotalAfterTax);
obj.PO_Tot_bef_Tax = Convert.ToDecimal(orderData.Order.TotalBeforeTax);
//obj.PO_Valid_for = orderData.Order.ValidForDays;
obj.PO_Del_Date = orderData.Order.DeliveryDate;
obj.Exc_Inc_GST = orderData.Order.ExcIncGST;
obj.ModifiedDate = DateTime.Now;
entities.SaveChanges();
}
var objPurchase = entities.PurchaseOrderDetails.Where
(e => e.PO_ID == obj.ID).ToList();
if (objPurchase != null)
{
foreach (var item in objPurchase)
{
int PSId = Convert.ToInt32(item.PO_No);
if (PSId != 0)
{
ProductsAndService ps = entities.ProductsAndServices.SingleOrDefault(e => e.ID == PSId);
if (ps != null)
{
ps.PandS_Qty_on_PO = ps.PandS_Qty_on_PO - item.PO_Qty;
entities.SaveChanges();
}
}
entities.PurchaseOrderDetails.Remove(item);
entities.SaveChanges();
}
}
PurchaseOrderDetail PODetails;
if (orderData.OrderDetails != null)
{
foreach (PurchaseOrderDetailEntity PODetailEntity in orderData.OrderDetails)
{
PODetails = new PurchaseOrderDetail();
PODetails.PO_ID = obj.ID;
PODetails.PO_No = PODetailEntity.PONo;
PODetails.PandS_Code = PODetailEntity.PandSCode;
PODetails.PandS_Name = PODetailEntity.PandSName;
PODetails.PO_Amount = PODetailEntity.POAmount;
PODetails.PO_Discount = PODetailEntity.PODiscount;
PODetails.PO_No = PODetailEntity.PONo;
PODetails.PO_Price = Convert.ToDecimal(PODetailEntity.POPrice);
PODetails.PO_Qty = PODetailEntity.POQty;
PODetails.GST_Code = PODetailEntity.GSTCode;
PODetails.GST_Rate = PODetailEntity.GSTRate;
entities.PurchaseOrderDetails.Add(PODetails);
entities.SaveChanges();
int PSId = Convert.ToInt32(PODetailEntity.PONo);
if (PSId != 0)
{
ProductsAndService ps = entities.ProductsAndServices.SingleOrDefault(e => e.ID == PSId);
if (ps != null)
{
ps.PandS_Qty_on_PO = ps.PandS_Qty_on_PO + PODetailEntity.POQty;
entities.SaveChanges();
}
}
}
}
return(obj.ID);
}
}
catch (Exception ex)
{
throw ex;
}
}
public int UpdationOrder(PurchaseOrderForm quotationData)
{
IPurchaseOrderBL poBL = new PurchaseOrderBL();
return(poBL.UpdationOrder(quotationData));
}
//public int ConvertToPurchaseOrder(PurchaseOrderForm poForm)
//{
// IPurchaseOrderBL poBL = new PurchaseOrderBL();
// return poBL.ConvertToPurchaseOrder(poForm);
//}
public int ConvertToPurchaseInvoice(PurchaseOrderForm quotationData)
{
IPurchaseOrderBL poBL = new PurchaseOrderBL();
return(poBL.ConvertToPurchaseInvoice(quotationData));
}
private void InitForm(string mode)
{
Form newForm;
DataGridViewRow selectedRow = new DataGridViewRow();
if (mode.Equals("Edit"))
{
try
{
selectedRow = DgvGeneric.SelectedRows[0];
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
MessageBox.Show(
text: "Debes seleccionar una fila",
caption: "Error",
buttons: MessageBoxButtons.OK,
icon: MessageBoxIcon.Error);
return;
}
}
switch (activeGrid)
{
case 0:
newForm = new EmployeeForm(mode, selectedRow);
newForm.ShowDialog();
break;
case 1:
newForm = new DepartmentForm(mode, selectedRow);
newForm.ShowDialog();
break;
case 2:
newForm = new ItemForm(mode, selectedRow);
newForm.ShowDialog();
break;
case 3:
newForm = new BrandForm(mode, selectedRow);
newForm.ShowDialog();
break;
case 4:
newForm = new UnitForm(mode, selectedRow);
newForm.ShowDialog();
break;
case 5:
newForm = new ProviderForm(mode, selectedRow);
newForm.ShowDialog();
break;
case 6:
newForm = new ItemRequestForm(mode, selectedRow);
newForm.ShowDialog();
break;
case 7:
newForm = new PurchaseOrderForm(mode, selectedRow);
newForm.ShowDialog();
break;
case 8:
newForm = new UserForm(mode, selectedRow);
newForm.ShowDialog();
break;
}
}
public PurchaseOrderForm GetPrintPurchaseOrder(string pino)
{
PurchaseOrderForm pif = new PurchaseOrderForm();
try
{
using (SASEntitiesEDM entities = new SASEntitiesEDM())
{
var pi = (from pis in entities.PurchaseOrders
join Sup in entities.Suppliers on pis.Sup_Id equals Sup.ID
where pis.PO_No == pino && (pis.IsDeleted == false || pis.IsDeleted == null)
select new PurchaseOrderEntity
{
ID = pis.ID,
SupplierID = pis.Sup_Id,
SupplierName = Sup.Sup_Name,
SupplierBillAddress1 = Sup.Sup_Bill_to_line1,
SupplierBillAddress2 = Sup.Sup_Bill_to_line2,
SupplierBillAddressCity = Sup.Sup_Bill_to_city,
SupplierBillAddressState = Sup.Sup_Bill_to_state,
SupplierBillAddressCountary = Sup.Sup_Bill_to_country,
SupplierShipPostCode = Sup.Sup_Bill_to_post_code,
SupplierTelephone = Sup.Sup_Telephone,
OrderNo = pis.PO_No,
OrderDate = pis.PO_Date,
DeliveryDate = pis.PO_Del_Date,
PurchaseInvoiceNo = pis.Conv_to_No,
TermsAndConditions = pis.PO_TandC,
TotalBeforeTax = pis.PO_Tot_bef_Tax,
TotalTax = pis.PO_GST_Amt,
TotalAfterTax = pis.PO_Tot_aft_Tax,
ExcIncGST = pis.Exc_Inc_GST
}).SingleOrDefault();
//var PaymentDueDate1 =pi.InvoiceDate.AddDays(Convert.ToInt32(pi.CreditDays));
if (pi != null)
{
pif.Order = pi;
}
//for comapany details
var company = (from com in entities.CompanyDetails
where (com.IsDeleted == false || com.IsDeleted == null)
select new PurchaseOrderEntity
{
CompanyName = com.Comp_Name,
CompanyRegNumber = com.Comp_Reg_No,
CompanyLogo = com.Comp_Logo,
CompanyGstNumber = com.Comp_GST_Reg_No,
CompanyBillToAddressLine1 = com.Comp_Bill_to_line1,
CompanyBillToAddressLine2 = com.Comp_Bill_to_line2,
CompanyBillToCity = com.Comp_Bill_to_city,
CompanyBillToState = com.Comp_Bill_to_state,
CompanyBillToCountary = com.Comp_Bill_to_country,
CompanyBillToPostCode = com.Comp_Bill_to_post_code,
CompanyShipToAddressLine1 = com.Comp_Ship_to_line1,
CompanyShipToAddressLine2 = com.Comp_Ship_to_line2,
CompanyShipToCity = com.Comp_Ship_to_city,
CompanyShipToState = com.Comp_Ship_to_state,
CompanyShipToCountary = com.Comp_Ship_to_country,
CompanyShipToPostCode = com.Comp_Ship_to_post_code,
CompanyEmail = com.Comp_Email,
CompanyFax = com.Comp_Fax
}).SingleOrDefault();
pif.Order.CompanyName = company.CompanyName;
pif.Order.CompanyLogo = company.CompanyLogo;
pif.Order.CompanyRegNumber = company.CompanyRegNumber;
pif.Order.CompanyGstNumber = company.CompanyGstNumber;
pif.Order.CompanyBillToAddressLine1 = company.CompanyBillToAddressLine1;
pif.Order.CompanyBillToAddressLine2 = company.CompanyBillToAddressLine2;
pif.Order.CompanyBillToCity = company.CompanyBillToCity;
pif.Order.CompanyBillToState = company.CompanyBillToState;
pif.Order.CompanyBillToCountary = company.CompanyBillToCountary;
pif.Order.CompanyBillToPostCode = company.CompanyBillToPostCode;
pif.Order.CompanyShipToAddressLine1 = company.CompanyShipToAddressLine1;
pif.Order.CompanyShipToAddressLine2 = company.CompanyShipToAddressLine2;
pif.Order.CompanyShipToCity = company.CompanyShipToCity;
pif.Order.CompanyShipToState = company.CompanyShipToState;
pif.Order.CompanyShipToCountary = company.CompanyShipToCountary;
pif.Order.CompanyShipToPostCode = company.CompanyShipToPostCode;
pif.Order.CompanyEmail = company.CompanyEmail;
pif.Order.CompanyFax = company.CompanyFax;
//end for comapany details
//option details
var optiondata = (from option in entities.Options
select new PurchaseOrderEntity
{
CurrencyCode = option.Currency_Code
}).SingleOrDefault();
pif.Order.CurrencyCode = optiondata.CurrencyCode;
//end options details
var pid = (from pids in entities.PurchaseOrderDetails
where pids.PO_ID == pi.ID
select new PurchaseOrderDetailEntity
{
ID = pids.ID,
POID = pids.PO_ID,
PONo = pids.PO_No,
PandSCode = pids.PandS_Code,
PandSName = pids.PandS_Name,
POQty = pids.PO_Qty,
Price = pids.PO_Price,
PODiscount = pids.PO_Discount,
POAmount = pids.PO_Amount,
GSTRate = pids.GST_Rate,
GSTCode = pids.GST_Code
}).ToList <PurchaseOrderDetailEntity>();
if (pid != null)
{
pif.OrderDetails = pid;
}
return(pif);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This method is used to get Purchase Order details
/// </summary>
/// <param name="pqId"></param>
/// <returns></returns>
public PurchaseOrderForm GetPurchaseOrder(string pqno)
{
PurchaseOrderForm pqf = new PurchaseOrderForm();
try
{
using (SASEntitiesEDM entities = new SASEntitiesEDM())
{
var pq = (from pqs in entities.PurchaseOrders
where pqs.PO_No == pqno && (pqs.IsDeleted == false || pqs.IsDeleted == null)
select new PurchaseOrderEntity
{
ID = pqs.ID,
SupplierID = pqs.Sup_Id,
OrderNo = pqs.PO_No,
OrderDate = pqs.PO_Date,
//ValidForDays = pqs.PO_Valid_for,
TermsAndConditions = pqs.PO_TandC,
TotalBeforeTax = pqs.PO_Tot_bef_Tax,
TotalTax = pqs.PO_GST_Amt,
TotalAfterTax = pqs.PO_Tot_aft_Tax,
ExcIncGST = pqs.Exc_Inc_GST,
PO_Conv_to_PI = pqs.PO_Conv_to_PI,
DeliveryDate = pqs.PO_Del_Date,
Status = pqs.PO_Status
//PO_Conv_to_PO = pqs.PO_Conv_to_PO
}).SingleOrDefault();
if (pq != null)
{
pqf.Order = pq;
}
var pqd = (from pqds in entities.PurchaseOrderDetails
where pqds.PO_ID == pq.ID
select new PurchaseOrderDetailEntity
{
ID = pqds.ID,
POID = pqds.PO_ID,
PONo = pqds.PO_No,
PandSCode = pqds.PandS_Code,
PandSName = pqds.PandS_Name,
POQty = pqds.PO_Qty,
Price = pqds.PO_Price,
PODiscount = pqds.PO_Discount,
POAmount = pqds.PO_Amount,
GSTRate = pqds.GST_Rate
}).ToList <PurchaseOrderDetailEntity>();
if (pqd != null)
{
pqf.OrderDetails = pqd;
}
return(pqf);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This method is used to convert the Purchase order to order
/// </summary>
/// <param name="orderData"></param>
/// <returns></returns>
public int ConvertToPurchaseOrder(PurchaseOrderForm orderData)
{
int autoId = 0;
//Add purchase order
PurchaseOrder obj = new PurchaseOrder();
//obj.ID = orderData.Order.ID;
obj.Sup_Id = orderData.Order.SupplierID;
obj.PO_Date = orderData.Order.OrderDate;
obj.PO_Del_Date = DateTime.Now;
obj.PO_GST_Amt = Convert.ToDecimal(orderData.Order.TotalTax);
obj.PO_No = "PO-" + GetLastOrderNo();
obj.PO_TandC = orderData.Order.TermsAndConditions;
obj.PO_Tot_aft_Tax = Convert.ToDecimal(orderData.Order.TotalAfterTax);
obj.PO_Tot_bef_Tax = Convert.ToDecimal(orderData.Order.TotalBeforeTax);
obj.Exc_Inc_GST = orderData.Order.ExcIncGST;
obj.IsDeleted = false;
try
{
using (SASEntitiesEDM entities = new SASEntitiesEDM())
{
if (entities.PurchaseOrders.AsNoTracking().FirstOrDefault(x => x.ID == orderData.Order.ID) == null)
{
//obj.CreatedBy = orderData.POModel.CreatedBy;
obj.CreatedDate = DateTime.Now;
entities.PurchaseOrders.Add(obj);
entities.SaveChanges();
autoId = obj.ID;
}
else
{
// obj.ModifiedBy = orderData.POModel.ModifiedBy;
obj.ModifiedDate = DateTime.Now;
entities.Entry(obj).State = EntityState.Modified;
autoId = entities.SaveChanges();
}
if (autoId > 0)
{
PurchaseOrderDetail PODetails;
if (orderData.OrderDetails != null)
{
foreach (PurchaseOrderDetailEntity PODetailEntity in orderData.OrderDetails)
{
PODetails = new PurchaseOrderDetail();
PODetails.PO_ID = autoId;
PODetails.PO_No = PODetailEntity.PONo;
PODetails.PandS_Code = PODetailEntity.PandSCode;
PODetails.PandS_Name = PODetailEntity.PandSName;
PODetails.PO_Amount = PODetailEntity.POAmount;
PODetails.PO_Discount = PODetailEntity.PODiscount;
PODetails.PO_No = PODetailEntity.PONo;
PODetails.PO_Price = Convert.ToDecimal(PODetailEntity.POPrice);
PODetails.PO_Qty = PODetailEntity.POQty;
PODetails.GST_Code = PODetailEntity.GSTCode;
PODetails.GST_Rate = PODetailEntity.GSTRate;
if (entities.PurchaseOrderDetails.AsNoTracking().FirstOrDefault(x => x.ID == PODetailEntity.ID) == null)
{
entities.PurchaseOrderDetails.Add(PODetails);
entities.SaveChanges();
}
else
{
entities.Entry(PODetails).State = EntityState.Modified;
entities.SaveChanges();
}
}
}
PurchaseOrder objQ = entities.PurchaseOrders.Where(e => e.PO_No == orderData.Order.OrderNo
).SingleOrDefault();
if (objQ != null)
{
//objQ.PO_Conv_to_PO = true;
objQ.ModifiedDate = DateTime.Now;
entities.SaveChanges();
}
}
}
return(autoId);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This method is used to add or edit purchase order
/// </summary>
/// <param name="orderData"></param>
/// <returns></returns>
public int AddUpdateOrder(PurchaseOrderForm orderData)
{
int autoId = 0;
//Add purchase order
PurchaseOrder obj = new PurchaseOrder();
obj.ID = orderData.Order.ID;
obj.Sup_Id = orderData.Order.SupplierID;
//obj.PO_Conv_to_PO = orderData.Order.PO_Conv_to_PO;
obj.PO_Conv_to_PI = orderData.Order.PO_Conv_to_PI;
//obj.PO_Date = orderData.Order.OrderDate;
obj.PO_Date = orderData.Order.OrderDate;
obj.PO_GST_Amt = Convert.ToDecimal(orderData.Order.TotalTax);
obj.PO_No = orderData.Order.OrderNo;
obj.PO_TandC = orderData.Order.TermsAndConditions;
obj.PO_Tot_aft_Tax = Convert.ToDecimal(orderData.Order.TotalAfterTax);
obj.PO_Tot_bef_Tax = Convert.ToDecimal(orderData.Order.TotalBeforeTax);
obj.PO_Status = Convert.ToByte(PO_Status.unDeposited);
obj.PO_Del_Date = orderData.Order.DeliveryDate;
obj.Exc_Inc_GST = orderData.Order.ExcIncGST;
obj.IsDeleted = false;
try
{
using (SASEntitiesEDM entities = new SASEntitiesEDM())
{
if (entities.PurchaseOrders.AsNoTracking().FirstOrDefault(x => x.ID == orderData.Order.ID) == null)
{
//obj.CreatedBy = orderData.POModel.CreatedBy;
obj.CreatedDate = DateTime.Now;
entities.PurchaseOrders.Add(obj);
entities.SaveChanges();
autoId = obj.ID;
}
else
{
// obj.ModifiedBy = orderData.POModel.ModifiedBy;
obj.ModifiedDate = DateTime.Now;
entities.Entry(obj).State = EntityState.Modified;
autoId = entities.SaveChanges();
}
if (autoId > 0)
{
PurchaseOrderDetail PODetails;
if (orderData.OrderDetails != null)
{
foreach (PurchaseOrderDetailEntity PODetailEntity in orderData.OrderDetails)
{
PODetails = new PurchaseOrderDetail();
PODetails.PO_ID = autoId;
PODetails.PO_No = PODetailEntity.PONo;
PODetails.PandS_Code = PODetailEntity.PandSCode;
PODetails.PandS_Name = PODetailEntity.PandSName;
PODetails.PO_Amount = PODetailEntity.POAmount;
PODetails.PO_Discount = PODetailEntity.PODiscount;
PODetails.PO_No = PODetailEntity.PONo;
PODetails.PO_Price = Convert.ToDecimal(PODetailEntity.POPrice);
PODetails.PO_Qty = PODetailEntity.POQty;
PODetails.GST_Code = PODetailEntity.GSTCode;
PODetails.GST_Rate = PODetailEntity.GSTRate;
if (entities.PurchaseOrderDetails.AsNoTracking().FirstOrDefault(x => x.ID == PODetailEntity.ID) == null)
{
entities.PurchaseOrderDetails.Add(PODetails);
entities.SaveChanges();
}
else
{
entities.Entry(PODetails).State = EntityState.Modified;
entities.SaveChanges();
}
int PSId = Convert.ToInt32(PODetailEntity.PONo);
if (PSId != 0)
{
ProductsAndService ps = entities.ProductsAndServices.SingleOrDefault(e => e.ID == PSId);
if (ps != null)
{
ps.PandS_Qty_on_PO = ps.PandS_Qty_on_PO + PODetailEntity.POQty;
entities.SaveChanges();
}
}
}
}
}
}
return(autoId);
}
catch (Exception ex)
{
throw ex;
}
}
