public bool UploadPiAttachment()
{
try
{
HttpRequest rsk = HttpContext.Current.Request;
var postedFile = rsk.Files["UploadedImage"];
long purchase_order_master_id = Convert.ToInt32(rsk.Form["purchase_order_master_id"]);
string actualFileName = "";
if (postedFile == null && rsk.Form["purchase_order_master_id"].ToString() == "")
{
return(false);//no file upload
}
else
{
actualFileName = postedFile.FileName;
var xx = actualFileName.Split('.');
var ext = xx[xx.Length - 1];
var fileName = "PI_" + purchase_order_master_id + "." + ext;
var clientDir = HttpContext.Current.Server.MapPath("~/App_Data/PI_Attachments/");
var fileSavePath = Path.Combine(clientDir, fileName);
purchase_order_master oPurchaseOrderMaster = _entities.purchase_order_master.Find(purchase_order_master_id);
if (!string.IsNullOrEmpty(oPurchaseOrderMaster.pi_attachment_location))
{
var oldAttachment = oPurchaseOrderMaster.pi_attachment_location;
var fileDeletePath = Path.Combine(clientDir, oldAttachment);
if (File.Exists(fileDeletePath))
{
File.Delete(fileDeletePath);
}
}
postedFile.SaveAs(fileSavePath);
oPurchaseOrderMaster.pi_attachment_location = fileName;
_entities.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool UpdateLcNoOnPo(PurchaseOrderModel purchaseOrderModel)
{
try
{
var poMaster = purchaseOrderModel.PoMasterData;
purchase_order_master masterData = _entities.purchase_order_master.Find(poMaster.purchase_order_master_id);
masterData.lc_number = purchaseOrderModel.PoMasterData.lc_number;
_entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool ApprovePurchaseOrder(long purchase_order_master_id, long user_id)
{
try
{
purchase_order_master oPurchaseOrderMaster = _entities.purchase_order_master.Find(purchase_order_master_id);
oPurchaseOrderMaster.approve_status = "Approved";
oPurchaseOrderMaster.updated_by = user_id;
oPurchaseOrderMaster.updated_date = DateTime.Now;
_entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool DeletePurchaseOrder(long purchase_order_master_id)
{
try
{
List <grn_master> grnList =
_entities.grn_master.Where(g => g.purchase_order_master_id == purchase_order_master_id).ToList();
if (grnList.Count == 0)
{
purchase_order_master oPurchaseOrderMaster = _entities.purchase_order_master.Find(purchase_order_master_id);
oPurchaseOrderMaster.is_active = false;
oPurchaseOrderMaster.is_deleted = true;
_entities.SaveChanges();
//List<purchase_order_details> poDetailsList =
// _entities.purchase_order_details.Where(
// pd => pd.purchase_order_master_id == purchase_order_master_id).ToList();
//if (poDetailsList.Count > 0)
//{
// foreach (var item in poDetailsList)
// {
// purchase_order_details oPurchaseOrderDetails = _entities.purchase_order_details.Find(item.purchase_order_details_id);
// _entities.purchase_order_details.Attach(oPurchaseOrderDetails);
// _entities.purchase_order_details.Remove(oPurchaseOrderDetails);
// _entities.SaveChanges();
// }
//}
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool DeletePurchaseOrder(long local_purchase_order_master_id)
{
try
{
List <grn_master> grnList =
_entities.grn_master.Where(g => g.purchase_order_master_id == local_purchase_order_master_id).ToList();
if (grnList.Count == 0)
{
purchase_order_master oPurchaseOrderMaster = _entities.purchase_order_master.Find(local_purchase_order_master_id);
oPurchaseOrderMaster.is_active = false;
oPurchaseOrderMaster.is_deleted = true;
_entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool UpdatePiInfoOnPo(PurchaseOrderModel purchaseOrderModel)
{
try
{
var poMaster = purchaseOrderModel.PoMasterData;
var poDetailsList = purchaseOrderModel.PoDetailsList;
purchase_order_master masterData = _entities.purchase_order_master.Find(poMaster.purchase_order_master_id);
if (string.IsNullOrEmpty(masterData.pi_attachment_location))
{
return(false);
}
masterData.supplier_id = purchaseOrderModel.PoMasterData.supplier_id;
masterData.pi_number = purchaseOrderModel.PoMasterData.pi_number;
masterData.currency_id = purchaseOrderModel.PoMasterData.currency_id;
masterData.total_amount_including_vattax = purchaseOrderModel.PoMasterData.total_amount_including_vattax;
masterData.status = "Updated";
masterData.company_id = masterData.company_id;
masterData.order_date = masterData.order_date;
masterData.shipping_terms_id = masterData.shipping_terms_id;
masterData.expected_shipment_date = masterData.expected_shipment_date;
masterData.shipping_method_id = masterData.shipping_method_id;
masterData.vat_total = purchaseOrderModel.PoMasterData.vat_total;
masterData.terms_n_condition = purchaseOrderModel.PoMasterData.terms_n_condition;
masterData.pi_terms_n_condition = purchaseOrderModel.PoMasterData.pi_terms_n_condition;
masterData.created_by = masterData.created_by;
masterData.created_date = masterData.created_date;
masterData.updated_by = purchaseOrderModel.PoMasterData.updated_by;
masterData.updated_date = DateTime.Now;
masterData.noc_number = purchaseOrderModel.PoMasterData.noc_number;
masterData.remarks = purchaseOrderModel.PoMasterData.remarks;
masterData.batch_id = 0;
masterData.order_no = purchaseOrderModel.PoMasterData.order_no;
masterData.tax_total = purchaseOrderModel.PoMasterData.tax_total;
masterData.total_amount_without_vattax = purchaseOrderModel.PoMasterData.total_amount_without_vattax;
_entities.SaveChanges();
foreach (var item in poDetailsList)
{
purchase_order_details detailsData =
_entities.purchase_order_details.FirstOrDefault(
pd =>
pd.purchase_order_master_id == poMaster.purchase_order_master_id &&
pd.purchase_order_details_id == item.purchase_order_details_id);
if (detailsData != null)
{
detailsData.purchase_order_master_id = poMaster.purchase_order_master_id;
detailsData.product_id = item.product_id;
detailsData.unit_id = item.unit_id;
detailsData.unit_price = item.unit_price;
detailsData.quantity = item.quantity;
detailsData.amount = item.amount;
detailsData.brand_id = item.brand_id;
detailsData.color_id = item.color_id;
detailsData.pi_quantity = item.pi_quantity;
detailsData.product_version_id = item.product_version_id;
detailsData.receive_qty = detailsData.receive_qty;
detailsData.vat_amount = item.vat_amount;
detailsData.last_modified_date = detailsData.last_modified_date;
detailsData.tax_amount = item.tax_amount;
detailsData.line_total = item.line_total;
detailsData.size_id = item.size_id;
detailsData.status = item.status;
detailsData.vat_pcnt = item.vat_pcnt;
detailsData.tax_pcnt = item.tax_pcnt;
detailsData.product_category_id = item.product_category_id;
_entities.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
