public async Task <String> CreateNewVendorLogo(vendorFileData vendorLogo) { string loginUserId = await _LoginHelper.GetLoginUserId(); string messageDocuments = ""; string messageAlreadyDocuments = ""; try { List <IFormFile> files = vendorLogo.vendorDocuments; foreach (var formFile in files) { if (formFile.Length > 0) { awsS3Helper.UploadToS3(formFile.FileName, formFile.OpenReadStream(), S3bucket, S3folder); int ref_id = Int32.Parse(vendorLogo.Vendor_id); JObject vendorDocuments = new JObject(); vendorDocuments.Add("vendor_id", ref_id); vendorDocuments.Add("logo", formFile.FileName); await _BadgerApiHelper.GenericPutAsyncString <String>(vendorDocuments.ToString(Formatting.None), "/vendor/updatespecific/" + vendorLogo.Vendor_id); } } return(messageDocuments + " \r\n " + messageAlreadyDocuments); } catch (Exception ex) { return("0"); } }
public async Task <bool> CreateBarcode([FromBody] JObject json) { string inserted = string.Empty; // Add/Update Barcode Range JObject bar = new JObject(); string barcode_from = json.Value <string>("barcode_from"); string barcode_to = json.Value <string>("barcode_to"); string size = json.Value <string>("size"); string idStr = json.Value <string>("id"); string updatedBy = await _LoginHelper.GetLoginUserId(); if (idStr == "") { bar.Add("created_by", Convert.ToInt32(updatedBy)); idStr = "-1"; } Int32 id = int.Parse(idStr); bar.Add("id", id); bar.Add("size", size); bar.Add("barcode_from", barcode_from); bar.Add("barcode_to", barcode_to); if (idStr != "-1") { bar.Add("updated_by", Convert.ToInt32(updatedBy)); bar.Add("updated_at", _common.DateConvertToTimeStamp(DateTime.Now.ToShortDateString())); } inserted = await _BadgerApiHelper.GenericPostAsyncString <string>(bar.ToString(Formatting.None), "/barcode/createorupdate"); return(Convert.ToBoolean(inserted)); }
public async Task <IActionResult> Logout() { string user_id = await _LoginHelper.GetLoginUserId(); if (await _LoginHelper.Logout(user_id)) { return(RedirectToAction("Dologin", "Auth")); } else { return(RedirectToAction("Index", "PurchaseOrders")); } }
public async Task <string> UpdateAttributes([FromBody] JObject json) { int category_id = json.Value <Int32>("category_id"); JArray added = json.Value <JArray>("tag_added"); JArray newAdded = new JArray(); List <CategoryOptions> categories = new List <CategoryOptions>(); string updatedBy = await _LoginHelper.GetLoginUserId(); foreach (var item in added) { JObject cat = new JObject(); cat.Add("attribute_id", Convert.ToInt32(item.Value <Int32>())); cat.Add("category_id", category_id); cat.Add("created_by", Convert.ToInt32(updatedBy)); cat.Add("updated_by", Convert.ToInt32(updatedBy)); cat.Add("created_at", _common.GetTimeStemp()); newAdded.Add(cat); } string insert_status = "True"; if (added.Count > 0) { insert_status = await _BadgerApiHelper.GenericPostAsyncString <string>(newAdded.ToString(Formatting.None), "/CategoryOption/createCategoryOption"); } JArray removed = json.Value <JArray>("tag_removed"); JArray newRemoved = new JArray(); foreach (var item in removed) { JObject cat = new JObject(); cat.Add("attribute_id", Convert.ToInt32(item.Value <Int32>())); cat.Add("category_id", category_id); newRemoved.Add(cat); } string delete_status = "True"; if (newRemoved.Count > 0) { delete_status = await _BadgerApiHelper.GenericPostAsyncString <string>(newRemoved.ToString(Formatting.None), "/CategoryOption/deleteCategoryOption"); } if (insert_status.ToLower() == "true" && delete_status.ToLower() == "true") { return("true"); } else { return("false"); } }
public async Task <string> addProductInPhotoshoot(int photoshoot_id, [FromBody] PhotoshootWithItems photoshoot) { string user_id = await _ILoginHelper.GetLoginUserId(); var assignPhotoshoot = new ProductPhotoshoots(); assignPhotoshoot.photoshoot_id = photoshoot_id; assignPhotoshoot.product_shoot_status_id = 1; assignPhotoshoot.updated_by = int.Parse(user_id); assignPhotoshoot.updated_at = _common.GetTimeStemp(); assignPhotoshoot.products = photoshoot.products; assignPhotoshoot.items = photoshoot.items; // await _BadgerApiHelper.PostAsync<string>(photoshoot.items, "/photoshoots/bulkupdatebarcode"); var AssignPhotoshootStatus = await _BadgerApiHelper.PostAsync <string>(assignPhotoshoot, "/photoshoots/StartProductPhotoshoot"); return(AssignPhotoshootStatus); }
public async Task <string> UpdateAttributes([FromBody] JObject json, int productId) { JArray product_subtype_ids = new JArray(); string user_id = await _LoginHelper.GetLoginUserId(); List <Fabric> _fabrics = new List <Fabric>(); JObject product = new JObject(); product.Add("size_and_fit_id", json.Value <string>("size_fit")); product.Add("product_retail", json.Value <string>("product_retail")); product.Add("product_name", json.Value <string>("product_name")); product.Add("product_cost", json.Value <string>("product_cost")); product.Add("product_discount", json.Value <string>("product_discount")); product.Add("product_detail_1", json.Value <string>("product_detail_1")); product.Add("product_detail_2", json.Value <string>("product_detail_2")); product.Add("product_detail_3", json.Value <string>("product_detail_3")); product.Add("product_detail_4", json.Value <string>("product_detail_4")); product.Add("is_ready", json.Value <bool>("is_ready")); product.Add("pairProductIds", json.Value <string>("pairProductIds")); product.Add("RemovePairWithProductIds", json.Value <string>("RemovePairWithProductIds")); product.Add("otherColorsProductIds", json.Value <string>("otherColorsProductIds")); product.Add("RemoveOtherColorProductIds", json.Value <string>("RemoveOtherColorProductIds")); product.Add("photoshootStatus", json.Value <string>("photoshootStatus")); product.Add("photoshootStatusOld", json.Value <string>("photoshootStatusOld")); product.Add("updated_by", user_id); product.Add("updated_at", _common.GetTimeStemp()); _fabrics = json.Value <JArray>("fabricArray").ToObject <List <Fabric> >(); string returnStatus = await _BadgerApiHelper.GenericPutAsyncString <string>(product.ToString(Formatting.None), "/Product/UpdateAttributes/" + productId.ToString()); if (json["product_subtype_ids"] != null) { product_subtype_ids = (JArray)json["product_subtype_ids"]; } 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", productId); 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"); } string sku = ""; string tagAddedIds = json.Value <string>("tagAddedIds"); if (tagAddedIds != "") { int countComma = tagAddedIds.Count(c => c == ','); if (countComma > 0) { var ids = tagAddedIds.Split(","); foreach (var tagId in ids) { JObject product_attr = new JObject(); Int16 attribute_id = Int16.Parse(tagId); product_attr.Add("attribute_id", attribute_id); product_attr.Add("product_id", productId); product_attr.Add("value", ""); product_attr.Add("created_by", user_id); product_attr.Add("created_at", _common.GetTimeStemp()); String attr_value_id = await _BadgerApiHelper.GenericPostAsyncString <String>(product_attr.ToString(Formatting.None), "/attributevalues/create"); JObject product_attr_value = new JObject(); product_attr_value.Add("product_id", productId); product_attr_value.Add("attribute_id", attribute_id); product_attr_value.Add("value_id", attr_value_id); product_attr_value.Add("created_by", user_id); // product_attr_value.Add("created_at", _common.GetTimeStemp()); need to create in DB String product_attribute_value_id = await _BadgerApiHelper.GenericPostAsyncString <String>(product_attr_value.ToString(Formatting.None), "/product/createAttributesValues"); JObject product_attribute_obj = new JObject(); product_attribute_obj.Add("product_id", productId); product_attribute_obj.Add("attribute_id", attribute_id); product_attribute_obj.Add("value_id", attr_value_id); product_attribute_obj.Add("sku", sku); product_attribute_obj.Add("created_by", user_id); //product_attribute_obj.Add("created_at", _common.GetTimeStemp()); need to create in DB String product_attribute_id = await _BadgerApiHelper.GenericPostAsyncString <String>(product_attribute_obj.ToString(Formatting.None), "/product/createProductAttribute"); } } else { } } if (_fabrics.Count() > 0) { await _ProductHelper.UpdateFabric(_fabrics, int.Parse(user_id)); } if (json.Value <string>("photoshootStatus") != json.Value <string>("photoshootStatusOld")) { JObject photoshoot = new JObject(); photoshoot.Add("product_shoot_status_id", json.Value <string>("photoshootStatus")); photoshoot.Add("updated_by", user_id); photoshoot.Add("updated_at", _common.GetTimeStemp()); await _BadgerApiHelper.GenericPutAsyncString <string>(photoshoot.ToString(Formatting.None), "/Photoshoots/UpdatePhotoshootProductStatus/" + productId.ToString()); } if (json.Value <string>("oldInternalNotes") != json.Value <string>("internalNotes")) { JObject productNote = new JObject(); productNote.Add("ref_id", productId); productNote.Add("note", json.Value <string>("internalNotes")); productNote.Add("created_by", Int32.Parse(user_id)); await _BadgerApiHelper.GenericPostAsyncString <String>(productNote.ToString(Formatting.None), "/product/notecreate"); } return("success"); }
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); }