public virtual void MmsAddSOItems(int[] mms_item_ids, int[] mms_item_qtys)
{
// SOAP Authentication header
V4.SoapAuthenticationHeader authentication = new V4.SoapAuthenticationHeader();
authentication.Username = _mmsSettings.MMSusername;
authentication.Password = _mmsSettings.MMSpassword;
V4.V4SoapClient client = new V4SoapClient(V4SoapClient.EndpointConfiguration.V4Soap12);
// Output
string hello;
var mms_response = client.GetHello(authentication, out hello);
Debug.WriteLine(mms_response.ToString());
Debug.WriteLine(hello);
// Error check
if (mms_response.Success == false)
{
Debug.WriteLine("MMS comms error MmsAddSOItems");
}
// V4.MmsResponse mmsResponse = new V4.MmsResponse();
mms_response.Success = true;
string salesOrderNumber;
decimal salesOrderTotal;
// submit so items to so
mms_response = client.SubmitSalesOrderLineItems(authentication, mms_item_ids, mms_item_qtys, out salesOrderNumber, out salesOrderTotal);
if (mms_response.Success == false)
{
Debug.WriteLine("Failed to call SubmitSalesOrderLineItems in MmsAddSOItems");
}
else
{
Debug.WriteLine("Great success to call SubmitSalesOrderLineItems in MmsAddSOItems qty = " + mms_item_ids.Length.ToString());
}
}
public List <MmsItemRecord> DataReadFileBetweenPaged(DateTime from_date, DateTime until_date, string user_name, string password, int mms_page)
{
string Username = user_name;
string Password = password;
int page = 1;
V4.SoapAuthenticationHeader authentication = new V4.SoapAuthenticationHeader();
Debug.WriteLine(">>>>In DataReadFileBetweenPaged");
authentication.Username = Username;
authentication.Password = Password;
GetHelloRequest request = new GetHelloRequest();
request.SoapAuthenticationHeader = authentication;
V4.V4SoapClient client = new V4SoapClient(V4SoapClient.EndpointConfiguration.V4Soap12);
//string Username1 = "*****@*****.**";
//string Password1 = "mA1389giC";
int item_count = 0;
List <MmsItemRecord> mmsItemReturnList = new List <MmsItemRecord>();
GetHelloRequest helloRequest = new GetHelloRequest();
helloRequest.SoapAuthenticationHeader = authentication;
// Output
string hello;
var response_hello = client.GetHello(authentication, out hello);
Debug.WriteLine(response_hello.ToString());
Debug.WriteLine(hello);
//==================
//string dateInString = "01.10.2000";
//DateTime StartDate = DateTime.Parse(dateInString);
Debug.WriteLine(from_date.ToString());
Debug.WriteLine(until_date.ToString());
// Output
V4.InventoryItem[] items;
var IABresponse = client.GetInventoryItemsAddedBetween(authentication, DateTime.Now.AddDays(-10), DateTime.Now, 1, out items);
Debug.WriteLine("Added >>>");
Debug.WriteLine(items.Length.ToString());
Debug.WriteLine(IABresponse.Success.ToString());
if ((IABresponse.Success == true) &&
(items.Length > 0))
{
Debug.WriteLine(">>>> Page : " + page.ToString() + " items: " + items.Length.ToString());
for (int i = 0; i < items.Length; i++)
{
Debug.WriteLine(items[i].Title);
//++++++++++++++++++++++++++++++++++++++
MmsItemRecord mmsItem = new MmsItemRecord();
mmsItem.InternalId = items[i].InternalId;
mmsItem.ProductId = 1;
mmsItem.IsMmsDownload = false;
mmsItem.ArtistOrMagician = items[i].ArtistOrMagician;
mmsItem.DateAdded = items[i].DateAdded;
mmsItem.DateLastModified = items[i].DateLastModified;
mmsItem.HTMLDescription = items[i].HTMLDescription;
mmsItem.ImageFileName = items[i].ImageFileName;
mmsItem.ImageThumbnailFileName = items[i].ImageThumbnailFileName;
mmsItem.InternalIdLegacy = items[i].InternalIdLegacy;
mmsItem.IsMurphysItem = items[i].IsMurphysItem;
mmsItem.ISBN = items[i].ISBN;
mmsItem.MaintainMSRP = items[i].MaintainMSRP;
mmsItem.Manufacturer = items[i].Manufacturer;
mmsItem.PreSale = items[i].PreSale;
mmsItem.ProductCode = items[i].ProductCode.Trim();
mmsItem.ProductLine = items[i].ProductLine;
mmsItem.Quality = items[i].Quality;
mmsItem.QuantityAvailable = items[i].QuantityAvailable;
mmsItem.Status = items[i].Status;
mmsItem.SuggestedRetailPrice = items[i].SuggestedRetailPrice;
mmsItem.Title = items[i].Title;
mmsItem.Weight = items[i].Weight;
mmsItem.WholesalePrice = items[i].WholesalePrice;
mmsItem.Length = items[i].Length;
mmsItem.Width = items[i].Width;
mmsItem.Height = items[i].Height;
// Now add collections
if (items[i].AlternateImages != null)
{
for (int j = 0; j < items[i].AlternateImages.Length; j++)
{
if (items[i].AlternateImages[j].Name != null)
{
MmsAlternateImage altImage = new MmsAlternateImage();
altImage.Name = items[i].AlternateImages[j].Name;
altImage.DirectName = "https://www.murphysmagicsupplies.com/images_alt/" + items[i].AlternateImages[j].Name;
altImage.ThumbnailName = items[i].AlternateImages[j].ThumbnailName;
mmsItem.AlternateImages.Add(altImage);
Debug.WriteLine(" Inside Adding alt images Item: {0} >> {1}", items[i].Title, items[i].AlternateImages[j].Name);
}
}
}
if (items[i].Videos != null)
{
for (int j = 0; j < items[i].Videos.Length; j++)
{
MmsVideo mmsVideo = new MmsVideo();
mmsVideo.Fillename = items[i].Videos[j].Filename;
mmsVideo.DirectFillename = items[i].Videos[j].Filename;
mmsItem.Videos.Add(mmsVideo);
}
}
if (items[i].WholesalePriceLevels != null)
{
for (int j = 0; j < items[i].WholesalePriceLevels.Length; j++)
{
MmsWholesalePriceLevel mmsWPL = new MmsWholesalePriceLevel();
mmsWPL.Price = items[i].WholesalePriceLevels[j].Price;
mmsWPL.Quantity = items[i].WholesalePriceLevels[j].Quantity;
mmsItem.MmsWholesalePriceLevels.Add(mmsWPL);
}
}
if (items[i].Categories != null)
{
for (int j = 0; j < items[i].Categories.Length; j++)
{
MmsCategoriesRecord mmsCat = new MmsCategoriesRecord();
mmsCat.IsNewCategory = false;
mmsCat.MmsCategory = items[i].Categories[j];
mmsItem.MmsCategories.Add(mmsCat);
}
}
if (items[i].CategoriesNew != null)
{
for (int j = 0; j < items[i].CategoriesNew.Length; j++)
{
MmsCategoriesRecord mmsCat = new MmsCategoriesRecord();
mmsCat.IsNewCategory = true;
mmsCat.MmsCategory = items[i].CategoriesNew[j];
mmsItem.MmsCategories.Add(mmsCat);
}
}
if (items[i].Rating != null)
{
for (int j = 0; j < items[i].Rating.Length; j++)
{
MmsRateRecord mmsRate = new MmsRateRecord();
mmsRate.MmsRate = items[i].Rating[j];
mmsItem.MmsRates.Add(mmsRate);
}
}
if (items[i].RelatedProducts != null)
{
for (int j = 0; j < items[i].RelatedProducts.Length; j++)
{
MmsRelatedProductsRecord mmsRel = new MmsRelatedProductsRecord();
mmsRel.MmsRelatedItemRecord = items[i].RelatedProducts[j];
mmsItem.MmsRelatedProduct.Add(mmsRel);
}
}
if (items[i].Tags != null)
{
for (int j = 0; j < items[i].Tags.Length; j++)
{
MmsTagsRecord mmsTag = new MmsTagsRecord();
mmsTag.MmsTags = items[i].Tags[j];
mmsItem.MmsTags.Add(mmsTag);
}
}
Debug.WriteLine("Item Count " + item_count.ToString());
item_count++;
mmsItemReturnList.Add(mmsItem);
}
}
else
{
Debug.WriteLine("No items fetched");
}
return(mmsItemReturnList);
} // DataReadFileBetweenPaged
/// <summary>
/// WGR Gets video by product identifier
/// </summary>
/// <param name="productId">Product identifier</param>
/// <returns>Video</returns>
///
public virtual int GetMmsStockQty(Product product)
{
if (product == null)
{
return(0);
}
V4.SoapAuthenticationHeader authentication = new V4.SoapAuthenticationHeader();
authentication.Username = _mmsSettings.MMSusername;
authentication.Password = _mmsSettings.MMSpassword;
V4.V4SoapClient client = new V4SoapClient(V4SoapClient.EndpointConfiguration.V4Soap12);
// Output
string hello;
var response_hello = client.GetHello(authentication, out hello);
Debug.WriteLine(response_hello.ToString());
Debug.WriteLine(hello);
// Error check
if (response_hello.Success == false)
{
Debug.WriteLine("MMS Comms error GetMmsStockQty");
return(0);
}
var query = from p in _videoRepository.Table
where p.ProductId == product.Id
select p.MmsItemId;
var mms_item_id = query.ToList().FirstOrDefault();
Debug.WriteLine("In GetMmsStockQty mms_item_id, product_id = " + mms_item_id.ToString() + " " + product.Id.ToString());
// Get stock qty from MMS
int[] mmsItemKeys = new int[1];
int[] mmsItemQty = new int[1];
mmsItemKeys[0] = mms_item_id;
mmsItemQty[0] = 0;
// Get first page of results
var mmsResponse = client.GetInventoryItemsAvailableQuantities(authentication, mmsItemKeys, out mmsItemQty);
// Error check
if (mmsResponse.Success == false)
{
Debug.WriteLine("MMS comms Error Getting Qty in GetMmsStockQty");
return(0);
}
// Ok, now update the db with new stock qty
product.StockQuantity = mmsItemQty[0];
UpdateProduct(product);
return(mmsItemQty[0]);
}
public ActionResult MmsDataLoad()
{
// Read Items
Debug.WriteLine(">>>>In Mms_admin_conntroller");
// string Username = "******";
// string Password = "******";
string Username = _mmsSettings.MMSusername;
string Password = _mmsSettings.MMSpassword;
DateTime load_from_date = _mmsSettings.LoadFromDate;
DateTime load_until_date = _mmsSettings.LoadUntilDate;
V4.SoapAuthenticationHeader authentication = new V4.SoapAuthenticationHeader();
authentication.Username = Username;
authentication.Password = Password;
//===========
GetHelloRequest request = new GetHelloRequest();
request.SoapAuthenticationHeader = authentication;
V4.V4SoapClient client = new V4SoapClient(V4SoapClient.EndpointConfiguration.V4Soap12);
GetHelloResponse response = client.GetHelloAsync(request).Result;
//==========
Debug.WriteLine(">>>>>>>>>>>>>>>>>>>>");
Debug.WriteLine(response.message.ToString());
Debug.WriteLine(response.GetHelloResult.Success.ToString());
Debug.WriteLine(response.GetHelloResult.ToString());
Debug.WriteLine(">>>>>>>>>>>>>>>>>>>>");
MmsDataRead mmsDataRead = new MmsDataRead();
List <MmsItemRecord> mmsItemRecordList = new List <MmsItemRecord> {
};
int page = 1;
mmsItemRecordList = mmsDataRead.DataReadFileBetweenPaged(load_from_date, load_until_date, Username, Password, page); // Read new items
//var mmsItemRecordListb = mmsItemRecordLista.Result;
if (mmsItemRecordList != null)
{
Debug.WriteLine("440: Controller xx LoadLatestMmsItemsPagedInsert " + mmsItemRecordList.Count.ToString());
// MmsDataImportDirect mmsDataImportDirect = new MmsDataImportDirect;
_importManagerOverride.MmsDataImportInsert2(mmsItemRecordList);
}
else
{
Debug.WriteLine("Read no items MmsAdmin controller");
}
//ImportManagerOverride importManagerOverride = new ImportManagerOverride;
// _mmsImportManager.MmsDataImportInsert2(mmsItemRecordList);
//_importManagerOverride.MmsDataImportInsert2(mmsItemRecordList);
return(View("~/Plugins/Misc.PickupInStore2/Views/MmsConfig.cshtml"));
} // Data_Load
