public async Task <IActionResult> Index()
{
VendorPagerList vendorPagerList = await _BadgerApiHelper.GenericGetAsync <VendorPagerList>("/vendor/listpageview/0/0");
dynamic VendorPageModal = new ExpandoObject();
VendorPageModal.VendorCount = vendorPagerList.Count;
VendorPageModal.VendorLists = vendorPagerList.vendorInfo;
VendorPageModal.VendorType = vendorPagerList.vendorType;
return(View("Index", VendorPageModal));
}
public async Task <IActionResult> EditAttributes(string id)
{
ProductDetailsPageData productDetailsPageData = new ProductDetailsPageData();
productDetailsPageData = await _BadgerApiHelper.GenericGetAsync <ProductDetailsPageData>("/Product/detailpage/" + id);
// dynamic AttributeListDetails = new ExpandoObject();
// VendorPageModal.VendorCount = vendorPagerList.Count;
// VendorPageModal.VendorLists = vendorPagerList.vendorInfo;
// VenderAdressandRep venderAdressandRep = await _BadgerApiHelper.GenericGetAsync<VenderAdressandRep>("/Vendor/detailsaddressandrep/103");
//VendorPageModal.Reps = venderAdressandRep.Reps;
return(View("EditAttributes", productDetailsPageData));
}
/*
* Developer: Rizwan Ali
* Date: 8-25-19
* Action:Get all tags from category option table for All Sub Category
* URL: categoryoption/GetTagsSubCategoryWise/
* Input: none
* output: List of All Tags and Categories
*/
public async Task <IActionResult> Index()
{
CategoryOptionPage categoryOption = new CategoryOptionPage();
ViewBag.SubCats = await _BadgerApiHelper.GenericGetAsync <IEnumerable <Categories> >("/CategoryOption/SubCategoryAll/");
categoryOption = await _BadgerApiHelper.GenericGetAsync <CategoryOptionPage>("/CategoryOption/CategoryOptionPage/");
ViewBag.selected = 0;
return(View(categoryOption));
}
public async Task <IActionResult> shootInProgress()
{
ProductPhotoshootInProgressPagerList photoshootInProgress = await _BadgerApiHelper.GenericGetAsync <ProductPhotoshootInProgressPagerList>("/Photoshoots/inprogress/");
string selectPhotoshootId = "0";
dynamic photoshootInProgressModal = new ExpandoObject();
photoshootInProgressModal.Lists = photoshootInProgress.photoshootsInprogress;
photoshootInProgressModal.SelectedPhotoshoot = selectPhotoshootId;
return(View("ShootInProgress", photoshootInProgressModal));
}
public async Task <IActionResult> Index()
{
dynamic barcodeRanges = await _BadgerApiHelper.GenericGetAsync <List <Barcode> >("/Barcode/getBarcodeRange/0/0");
return(View("Index", barcodeRanges));
}
public async Task <String> CreateNewStyle([FromBody] JObject json)
{
int user_id = Int32.Parse(await _ILoginHelper.GetLoginUserId());
String product_id = "";
JObject product = new JObject();
JObject vendorProduct = new JObject();
JObject allData = JObject.Parse(json.ToString());
JArray vendor_style_sku_data = new JArray();
JArray product_subtype_ids = new JArray();
if (allData["vendor_style_sku"] != null)
{
vendor_style_sku_data = (JArray)allData["vendor_style_sku"];
}
if (allData["product_subtype_ids"] != null)
{
product_subtype_ids = (JArray)allData["product_subtype_ids"];
}
Int32 product_id_current = json.Value <Int32>("product_id");
Int32 po_id = json.Value <Int32>("po_id");
Int32 vendor_id = json.Value <Int32>("vendor_id");
string product_name = json.Value <string>("product_name");
bool IsLineItemExists = json.Value <bool>("IsLineItemExists");
bool UpdateVendorType = json.Value <bool>("UpdateVendorType");
string first_sku_family = json.Value <string>("sku_family");
string vendor_color_name = json.Value <string>("vendor_color_name");
string product_cost = json.Value <string>("product_cost");
string product_name_no = json.Value <string>("product_name_no");
string product_color_code = json.Value <string>("product_color_code");
string product_retail = json.Value <string>("product_retail");
string product_url_handle = product_name.Replace(' ', '-').ToLower();
string product_type_id = json.Value <string>("product_type_id");
//default values FIXED hardcoded
int size_and_fit_id = 0;
int wash_type_id = 0;
int product_discount = 20;
int published_status = 0;
int is_on_site_status = 0;
String attr_value_id_color = "15"; // blank entry for color
int color_attribute_id = 1; // color attribute id
// item insert default values
string item_status_id = "1"; // Not Recieved
int ra_status = 0;
int barcode = 0;
int slot_number = 0;
int bag_code = 0;
product.Add("vendor_id", vendor_id);
product.Add("product_name", product_name);
product.Add("vendor_color_name", vendor_color_name);
product.Add("product_cost", product_cost);
product.Add("product_retail", product_retail);
product.Add("product_url_handle", product_url_handle);
product.Add("product_type_id", product_type_id);
product.Add("product_description", "");
product.Add("sku_family", first_sku_family);
product.Add("size_and_fit_id", size_and_fit_id);
product.Add("wash_type_id", wash_type_id);
product.Add("product_discount", product_discount);
product.Add("published_status", published_status);
product.Add("is_on_site_status", is_on_site_status);
product.Add("created_by", user_id);
product.Add("created_at", _common.GetTimeStemp());
product.Add("po_id", po_id.ToString());
vendorProduct.Add("vendor_id", vendor_id);
vendorProduct.Add("vendor_color_code", product_color_code);
vendorProduct.Add("vendor_color_name", vendor_color_name);
vendorProduct.Add("vendor_product_code", product_name_no);
vendorProduct.Add("vendor_product_name", product_name);
vendorProduct.Add("created_by", user_id);
vendorProduct.Add("created_at", _common.GetTimeStemp());
if (product_id_current > 0)
{
product_id = product_id_current.ToString(); //update on selected product id
// add new product in product table
var a = await _BadgerApiHelper.GenericPutAsyncString <String>(product.ToString(Formatting.None), "/product/updatespecific/" + product_id);
if (!string.IsNullOrEmpty(product_id))
{ //update vendor product
vendorProduct.Add("product_id", Convert.ToInt64(product_id));
var result = await _BadgerApiHelper.GenericPutAsyncString <String>(vendorProduct.ToString(Formatting.None), "/vendor/vendorproductUpdatespecific");
}
}
else
{
try
{
// add new product in product table
product_id = await _BadgerApiHelper.GenericPostAsyncString <String>(product.ToString(Formatting.None), "/product/create");
if (!string.IsNullOrEmpty(product_id))
{
vendorProduct.Add("product_id", Convert.ToInt64(product_id));
// add new vendor product in vendor product table
var temp_product_id = await _BadgerApiHelper.GenericPostAsyncString <String>(vendorProduct.ToString(Formatting.None), "/vendor/createvendorproduct");
}
}
catch (Exception ex)
{
var logger = _loggerFactory.CreateLogger("internal_error_log");
logger.LogInformation("Problem happened in making new Product, no product id genrated ");
}
}
if (UpdateVendorType)
{
JObject _vendor = new JObject();
_vendor.Add("vendor_type", 3);
_vendor.Add("updated_by", user_id);
_vendor.Add("updated_at", _common.GetTimeStemp());
String vendorStatus = await _BadgerApiHelper.GenericPutAsyncString <String>(_vendor.ToString(Formatting.None), "/vendor/updatespecific/" + vendor_id.ToString());
}
if (Int32.Parse(product_id) > 1)
{
JObject productPhotoshoot = new JObject();
productPhotoshoot.Add("photoshoot_id", 0);
productPhotoshoot.Add("product_id", product_id);
productPhotoshoot.Add("product_shoot_status_id", 0);
productPhotoshoot.Add("updated_by", 0);
productPhotoshoot.Add("updated_at", 0);
productPhotoshoot.Add("created_by", user_id);
productPhotoshoot.Add("created_at", _common.GetTimeStemp());
await _BadgerApiHelper.GenericPostAsyncString <String>(productPhotoshoot.ToString(Formatting.None), "/photoshoots/addNewPhotoshootProduct");
String product_attribute_value_id_color = await _productHelper.createProductAttributesValuesAsync(Int32.Parse(product_id), color_attribute_id, int.Parse(attr_value_id_color));
String product_attribute_id_color = await _productHelper.createProductAttributesAsync(Int32.Parse(product_id), color_attribute_id, "", product_attribute_value_id_color);
JObject used_in_obj = new JObject();
used_in_obj.Add("product_id", product_id);
used_in_obj.Add("po_id", po_id);
used_in_obj.Add("created_at", _common.GetTimeStemp());
String used_in_id = await _BadgerApiHelper.GenericPostAsyncString <String>(used_in_obj.ToString(Formatting.None), "/product/createUsedIn");
}
for (int i = 0; i < product_subtype_ids.Count(); i++)
{
string category_id = product_subtype_ids[i].Value <string>("category_id");
string action = product_subtype_ids[i].Value <string>("action");
JObject productCategories = new JObject();
productCategories.Add("product_id", product_id);
productCategories.Add("category_id", category_id);
productCategories.Add("action", action);
productCategories.Add("created_by", user_id);
productCategories.Add("created_at", _common.GetTimeStemp());
var temp_product_category_id = await _BadgerApiHelper.GenericPostAsyncString <String>(productCategories.ToString(Formatting.None), "/product/UpdateProductCategory");
}
//Checking If line items need to be deleted and is it a possibility to delete line items , if not - stop everything and return
if (IsLineItemExists)
{
var OldSkuList = vendor_style_sku_data.Where(x => x.Value <bool>("IsNewSku") == false && x.Value <int>("style_qty") < x.Value <int>("original_qty")).ToList();
for (int i = 0; i < OldSkuList.Count; i++)
{
string sku = OldSkuList[i].Value <string>("style_sku");
int style_qty = vendor_style_sku_data[i].Value <int>("style_qty");
var itemCount = await _BadgerApiHelper.GenericGetsAsync("/product/getitems/" + po_id + "/" + sku);
if (int.Parse(itemCount) < style_qty)
{
// -3 for indicating error in javascript : cannot decrease quantity of sku.
return("-3");
}
}
}
else
{
var newSkus = vendor_style_sku_data.Where(x => x.Value <bool>("IsNewSku") == true).ToList();
for (int i = 0; i < newSkus.Count; i++)
{
string sku = newSkus[i].Value <string>("style_sku");
bool SkuFound = await _BadgerApiHelper.GenericGetAsync <Boolean>("/Sku/checkskuexist/" + sku);
if (SkuFound)
{
// -4 for indicating error in javascript : sku already exists.
return("-4");
}
}
}
for (int i = 0; i < vendor_style_sku_data.Count; i++)
{
string style_vendor_size = vendor_style_sku_data[i].Value <string>("style_vendor_size");
string style_size = vendor_style_sku_data[i].Value <string>("style_size");
string style_qty = vendor_style_sku_data[i].Value <string>("style_qty");
string sku = vendor_style_sku_data[i].Value <string>("style_sku");
bool IsNewSku = vendor_style_sku_data[i].Value <bool>("IsNewSku");
int original_qty = vendor_style_sku_data[i].Value <int>("original_qty");
string sku_family = json.Value <string>("sku_family");
Int16 attribute_id = Int16.Parse(style_size);
String attr_value_id = await _productHelper.createProductAttributesAsync(Int32.Parse(product_id), attribute_id, style_vendor_size, user_id, _common.GetTimeStemp());
String product_attribute_value_id = await _productHelper.createProductAttributesValuesAsync(Int32.Parse(product_id), attribute_id, int.Parse(attr_value_id));
String product_attribute_id = await _productHelper.createProductAttributesAsync(Int32.Parse(product_id), attribute_id, sku, attr_value_id);
//// size attribute ends here
JObject Sku_obj = new JObject();
Sku_obj.Add("sku", sku);
Sku_obj.Add("vendor_id", vendor_id);
Sku_obj.Add("product_id", Int32.Parse(product_id));
String sku_id = await _BadgerApiHelper.GenericPostAsyncString <String>(Sku_obj.ToString(Formatting.None), "/sku/create");
JObject lineitem_obj = new JObject();
lineitem_obj.Add("po_id", po_id);
lineitem_obj.Add("vendor_id", vendor_id);
lineitem_obj.Add("sku", sku);
lineitem_obj.Add("product_id", Int32.Parse(product_id));
lineitem_obj.Add("line_item_cost", product_cost);
lineitem_obj.Add("line_item_retail", product_retail);
lineitem_obj.Add("line_item_type_id", product_type_id);
lineitem_obj.Add("line_item_ordered_quantity", style_qty);
lineitem_obj.Add("IsQtyIncreased", int.Parse(style_qty) < original_qty ? false : true);
lineitem_obj.Add("originalQty", original_qty);
JObject items = new JObject();
items.Add("barcode", barcode); // 0
items.Add("slot_number", slot_number); // 0
items.Add("bag_code", bag_code); // 0
items.Add("item_status_id", item_status_id); // 1
items.Add("ra_status", ra_status); // 0
items.Add("sku", sku);
items.Add("sku_id", sku_id);
items.Add("sku_family", sku_family);
items.Add("product_id", product_id);
items.Add("vendor_id", vendor_id);
items.Add("PO_id", po_id);
items.Add("original_qty", original_qty);
if (!IsLineItemExists || IsNewSku)
{
//for item when they are created
items.Add("created_at", _common.GetTimeStemp());
items.Add("created_by", user_id);
//for po line item when they are created
lineitem_obj.Add("created_by", user_id);
lineitem_obj.Add("created_at", _common.GetTimeStemp());
String item_id = await _BadgerApiHelper.GenericPostAsyncString <String>(items.ToString(Formatting.None), "/product/createitems/" + style_qty);
String line_item_id = await _BadgerApiHelper.GenericPostAsyncString <String>(lineitem_obj.ToString(Formatting.None), "/product/createLineitems");
}
else
{
//for item when they are updated
items.Add("updated_at", _common.GetTimeStemp());
items.Add("updated_by", user_id);
//for po line item when they are updated
lineitem_obj.Add("updated_by", user_id);
lineitem_obj.Add("updated_at", _common.GetTimeStemp());
int _style_qty = int.Parse(style_qty);
if (original_qty != _style_qty)
{
//Adding new items in existing Line items
String item_id = await _BadgerApiHelper.GenericPostAsyncString <String>(items.ToString(Formatting.None), "/product/updateitems/" + style_qty);
String line_item_id = await _BadgerApiHelper.GenericPostAsyncString <String>(lineitem_obj.ToString(Formatting.None), "/product/updateLineitems");
}
}
}
return(product_id);
}
public async Task <object> GetSkuSizes()
{
var skuSizesList = await _BadgerApiHelper.GenericGetAsync <object>("/attributes/list/type/1");
return(skuSizesList);
}
public async Task <String> AutoSuggest([FromBody] JObject json)
{
dynamic multipleObject = new ExpandoObject();
string[] xobject = new string[] { };
string search = json.Value <string>("search");
int searchLength = search.Length;
Boolean checkPattern = false;
/********* Barcode *********************/
if (searchLength == 8)
{
checkPattern = Regex.IsMatch(search, "^([0-9]{8})+$");
if (checkPattern == true)
{
multipleObject.barcodeList = await _BadgerApiHelper.GenericGetAsync <List <object> >("/purchaseorders/getbarcode/" + search);
}
else
{
multipleObject.barcodeList = xobject;
}
}
else
{
multipleObject.barcodeList = xobject;
}
/********* SKU *********************/
if (Regex.IsMatch(search, "(^[a-zA-Z]+[0-9]+$)|(^[a-zA-Z]+[0-9]+-{1}$)|(^[a-zA-Z]+[0-9]+-{1}[0-9]{1}$)"))
{
multipleObject.skuList = await _BadgerApiHelper.GenericGetAsync <List <object> >("/sku/getsku/" + search);
}
else
{
multipleObject.skuList = xobject;
}
/********* Style Number *********************/
if (searchLength > 3 && searchLength <= 8)
{
multipleObject.styleNumberList = await _BadgerApiHelper.GenericGetAsync <List <object> >("/vendor/getstylenumber/" + search);
}
else
{
multipleObject.styleNumberList = xobject;
}
/********* Vendor & Product *********************/
checkPattern = Regex.IsMatch(search, "^[a-zA-Z0-9_ -]+$");
if (checkPattern)
{
multipleObject.vendorList = await _BadgerApiHelper.GenericGetAsync <List <object> >("/vendor/getvendor/" + search);
multipleObject.productList = await _BadgerApiHelper.GenericGetAsync <List <object> >("/product/getproduct/" + search);
multipleObject.purchaseOrdersList = await _BadgerApiHelper.GenericGetAsync <List <object> >("/purchaseorders/getpolist/" + search);
}
else
{
multipleObject.vendorList = xobject;
multipleObject.productList = xobject;
multipleObject.purchaseOrdersList = xobject;
}
return(JsonConvert.SerializeObject(multipleObject));
}