public static void Update(TransferOrder obj, IOrganizationService myService)
{
try
{
string entityName = "bsd_transferorder";
service = myService;
if (string.IsNullOrEmpty(obj.RecId.Trim()))
{
throw new Exception("Product Receipt is not null");
}
string transferOrderid = Util.retrivestringvaluelookup(entityName, "bsd_codeax", obj.RecId.Trim(), service);
if (transferOrderid != null)
{
foreach (var item in obj.TransferOrderProduct)
{
if (item != null)
{
string transferOrderProductid = Util.retriveLookup("bsd_transferorderproduct", "bsd_recid", item.RecId.Trim(), service);
if (transferOrderProductid != null)
{
decimal bsd_standardquantity = 0.001m;
decimal bsd_priceofshipping = 0m;
Entity transferOrderProduct = service.Retrieve("bsd_transferorderproduct", Guid.Parse(transferOrderProductid), new ColumnSet(true));
Entity TransferOrderProduct_Update = new Entity("bsd_transferorderproduct", Guid.Parse(transferOrderProductid));
TransferOrderProduct_Update["bsd_quantity"] = item.bsd_quantity;
if (transferOrderProduct.HasValue("bsd_standardquantity"))
{
bsd_standardquantity = (decimal)transferOrderProduct["bsd_standardquantity"];
}
if (transferOrderProduct.HasValue("bsd_priceofshipping"))
{
bsd_priceofshipping = ((Money)transferOrderProduct["bsd_priceofshipping"]).Value;
}
TransferOrderProduct_Update["bsd_totalweight"] = (decimal)(item.bsd_quantity);
TransferOrderProduct_Update["bsd_totalpriceshipping"] = new Money(bsd_priceofshipping * bsd_standardquantity * item.bsd_quantity);
service.Update(TransferOrderProduct_Update);
}
}
}
UpdateTransferOder(Guid.Parse(transferOrderid), entityName);
}
else
{
throw new Exception(obj.bsd_name.Trim() + " Purchase Order Id not found in CRM");
}
}
catch (Exception ex)
{
throw new Exception("CRM " + ex.Message);
}
}
public static void Create(TransferOrder obj, IOrganizationService myService)
{
string trace = "start";
try
{
decimal priceofshipping = 0m;
string entityName = "bsd_transferorder";
service = myService;
if (obj.bsd_name == null)
{
throw new Exception("Purchase Order Id is not null");
}
if (obj.bsd_vendorid == null)
{
throw new Exception("Vendor Id is not null");
}
if (obj.bsd_tosite == null)
{
throw new Exception("To site Id is not null");
}
string guid = Util.retriveLookup(entityName, "bsd_codeax", obj.RecId.Trim(), service);
if (guid != null)
{
throw new Exception(obj.RecId.Trim() + " Product Receipt existed in CRM");
}
Entity transferOrder = new Entity(entityName);
transferOrder["bsd_type"] = new OptionSetValue(861450001);//Purchase Order Type
transferOrder["bsd_name"] = obj.bsd_name.Trim();
transferOrder["bsd_codeax"] = obj.RecId.Trim();
transferOrder["bsd_totalpriceporter"] = new Money(0);
if (obj.bsd_receiptdate != null)
{
transferOrder["bsd_receiptdate"] = obj.bsd_receiptdate;
}
//if (obj.bsd_shipdate != null)
// transferOrder["bsd_shipdate"] = obj.bsd_shipdate;
if (obj.bsd_vendorid != null)
{
transferOrder["bsd_vendorid"] = obj.bsd_vendorid;
}
if (obj.bsd_vendorname != null)
{
transferOrder["bsd_vendorname"] = obj.bsd_vendorname;
}
if (obj.bsd_vendoraddress != null)
{
transferOrder["bsd_vendoraddress"] = obj.bsd_vendoraddress;
}
string siteid = Util.retriveLookup("bsd_site", "bsd_code", obj.bsd_tosite, service);
if (siteid == null)
{
throw new Exception(obj.bsd_tosite + " Site not found in CRM");
}
transferOrder["bsd_tosite"] = new EntityReference("bsd_site", Guid.Parse(siteid));
string warehouseId = Util.retriveLookup("bsd_warehouseentity", "bsd_warehouseid", obj.bsd_towarehouse, service);
if (warehouseId != null)
{
transferOrder["bsd_towarehouse"] = new EntityReference("bsd_warehouseentity", Guid.Parse(warehouseId));
}
Guid transferOrderId = service.Create(transferOrder);
foreach (var item in obj.TransferOrderProduct)
{
if (item != null)
{
Entity bsd_carrierpartner = null; Entity product = null;
Entity transferOrderProduct = new Entity("bsd_transferorderproduct");
transferOrderProduct["bsd_transferorder"] = new EntityReference(entityName, transferOrderId);
if (item.productnumber != null)
{
product = Util.getProduct(item.productnumber.Trim(), service);
}
else
{
throw new Exception("Product number is not null");
}
transferOrderProduct["bsd_name"] = item.productname;
if (product != null)
{
transferOrderProduct["bsd_product"] = new EntityReference(product.LogicalName, product.Id);
// transferOrderProduct["bsd_unit"] = (EntityReference)product["defaultuomid"];
transferOrderProduct["bsd_name"] = product["name"];
}
transferOrderProduct["bsd_codeax"] = obj.RecId;
transferOrderProduct["bsd_recid"] = item.RecId;
transferOrderProduct["bsd_unit"] = Util.getUnitDefault_Configdefault(service);
transferOrderProduct["bsd_productid"] = item.productnumber.Trim().ToUpper();
transferOrderProduct["bsd_quantity"] = item.bsd_quantity;
transferOrderProduct["bsd_deliveryfee"] = true;//item.bsd_deliveryfee;
transferOrderProduct["bsd_porter"] = item.bsd_porter;
transferOrderProduct["bsd_driver"] = item.bsd_driver;
if (item.bsd_carrierpartner != null)
{
bsd_carrierpartner = Util.getAccount(item.bsd_carrierpartner, service);
transferOrderProduct["bsd_carrierpartner"] = new EntityReference(bsd_carrierpartner.LogicalName, bsd_carrierpartner.Id);
}
else
{
throw new Exception("Carrier partner is not null");
}
EntityReference ref_carrierpartner = (EntityReference)transferOrderProduct["bsd_carrierpartner"];
transferOrderProduct["bsd_totalpriceporter"] = new Money(0);
decimal bsd_truckload = 0m;
if (item.bsd_truckload.ToString() != null)
{
bsd_truckload = item.bsd_truckload;
}
transferOrderProduct["bsd_truckload"] = bsd_truckload;
if (item.bsd_licenseplate != null)
{
transferOrderProduct["bsd_licenseplate"] = item.bsd_licenseplate;
}
int bsd_deliverymethod = 861450000;//Ton
if (item.bsd_deliverymethod != null)
{
if (item.bsd_deliverymethod.ToLower() == "trip" || item.bsd_deliverymethod.ToLower() == "861450001")
{
bsd_deliverymethod = 861450001;
}
}
transferOrderProduct["bsd_deliverymethod"] = new OptionSetValue(bsd_deliverymethod);
DateTime date = Util.RetrieveLocalTimeFromUTCTime(DateTime.Now, service);
#region Kiểm tra cung đường
int deliverymethod = ((OptionSetValue)transferOrderProduct["bsd_deliverymethod"]).Value;
// EntityReference ref_unitshipping = getUnitShipping_Configdefault();
bool port = transferOrderProduct.HasValue("bsd_porter") ? (bool)transferOrderProduct["bsd_porter"] : false;
EntityCollection etc_route = Util.getRouteTypePurChaseOrder(service, Guid.Parse(siteid), obj.bsd_vendorid);
if (etc_route.Entities.Any())
{
foreach (var item_route in etc_route.Entities)
{
string condition_order = "";
string condition_main = "";
#region Ton
if (deliverymethod == 861450000)
{
if (port)
{
condition_order = @"<order attribute = 'bsd_priceunitporter' descending = 'false' />
<order attribute='bsd_priceofton' descending='false' />";
}
else
{
condition_order = @"<order attribute='bsd_priceofton' descending='false' />";
}
condition_main = @"<condition attribute='bsd_deliverymethod' operator='eq' value='861450000' />";
// <condition attribute = 'bsd_unit' operator= 'eq' uitype = 'uom' value = '" + ref_unitshipping.Id + @"' /> ";
}
#endregion
#region Trip
else if (deliverymethod == 861450001)
{
if (port)
{
condition_order = @"<order attribute='bsd_pricetripporter' descending='false' />
<order attribute='bsd_priceoftrip' descending='false' />";
}
else
{
condition_order = @"<order attribute='bsd_priceoftrip' descending='false' />";
}
condition_main = "<condition attribute='bsd_deliverymethod' operator='eq' value='861450001' />";
}
#endregion
trace = "1";
EntityCollection etc_shippingpricelist = Util.getShippingPriceList(date, condition_order, condition_main, item_route.Id, ref_carrierpartner.Id, service);
trace = "2";
if (etc_shippingpricelist.Entities.Any())
{
Entity ent_ShiPriLst = etc_shippingpricelist.Entities.FirstOrDefault();
if (deliverymethod == 861450001) // Trip
{
bool trip_truck = false;
foreach (var shipping in etc_shippingpricelist.Entities)
{
if (shipping.HasValue("bsd_truckload"))
{
EntityReference Rf_truck_Load = (EntityReference)shipping["bsd_truckload"];
Entity Entity_truckload = service.Retrieve(Rf_truck_Load.LogicalName, Rf_truck_Load.Id, new ColumnSet(true));
if (Entity_truckload.HasValue("bsd_weight"))
{
if ((Decimal)Entity_truckload["bsd_weight"] == item.bsd_truckload)
{
trip_truck = true;
ent_ShiPriLst = shipping;
break;
}
}
}
}
if (trip_truck == false)
{
throw new Exception("Truck load not found in Shipping price list in CRM");
}
}
EntityReference ref_ShiPriLst = new EntityReference(ent_ShiPriLst.LogicalName, ent_ShiPriLst.Id);
if (port)
{
if (ent_ShiPriLst.HasValue("bsd_priceunitporter"))
{
transferOrderProduct["bsd_priceofshipping"] = ent_ShiPriLst["bsd_priceunitporter"];
}
else if (ent_ShiPriLst.HasValue("bsd_pricetripporter"))
{
transferOrderProduct["bsd_priceofshipping"] = ent_ShiPriLst["bsd_pricetripporter"];
}
}
else
{
if (ent_ShiPriLst.HasValue("bsd_priceofton"))
{
transferOrderProduct["bsd_priceofshipping"] = ent_ShiPriLst["bsd_priceofton"];
}
else if (ent_ShiPriLst.HasValue("bsd_priceoftrip"))
{
transferOrderProduct["bsd_priceofshipping"] = ent_ShiPriLst["bsd_priceoftrip"];
}
}
if (transferOrderProduct.HasValue("bsd_priceofshipping"))
{
transferOrderProduct["bsd_shippingpricelist"] = ref_ShiPriLst;
break;
}
}
}
if (!transferOrderProduct.HasValue("bsd_priceofshipping"))
{
throw new Exception("Shipping price list is not defined");
}
else
{
if (deliverymethod == 861450001)
{
transferOrderProduct["bsd_totalpriceshipping"] = transferOrderProduct["bsd_priceofshipping"];
}
}
}
else
{
throw new Exception("Route is not defined!");
}
EntityReference ref_shippingpricelist = (EntityReference)transferOrderProduct["bsd_shippingpricelist"];
Entity shippingpricelist = service.Retrieve(ref_shippingpricelist.LogicalName, ref_shippingpricelist.Id, new ColumnSet(true));
decimal priceshipping_pro = 0m;
decimal qty_transferorderproduct = item.bsd_quantity;
decimal factor = 0.001m;
#region Ton, tính tổng giá vận chuyển của product
if (deliverymethod == 861450000)//Ton
{
priceofshipping = ((Money)transferOrderProduct["bsd_priceofshipping"]).Value;
// factor = getFactor_UnitConversion(product, unit, ref_unitconfig);
priceshipping_pro = priceofshipping * factor * qty_transferorderproduct;
transferOrderProduct["bsd_totalpriceshipping"] = new Money(priceshipping_pro);
}
#endregion
#region tính total weight
transferOrderProduct["bsd_standardquantity"] = factor;
factor = 1m;
transferOrderProduct["bsd_totalweight"] = factor * qty_transferorderproduct;
#endregion
#endregion '
trace = "3";
service.Create(transferOrderProduct);
trace = "4";
}
}
trace = "5";
UpdateTransferOder(transferOrderId, entityName);
trace = "6";
}
catch (Exception ex)
{
throw new Exception("CRM Plugin:" + ex.Message);
}
}