Пример #1
0
        public JsonResult ts_ship_stock(string[] asset)
        {
            string message = "";

            //format the tsg sku to the ss format



            // channel = channel.Replace("TSG_", "HW-");



            for (int i = 0; i < asset.Length; i++)
            {
                try
                {
                    string temp_asset   = asset[i];
                    var    db           = new db_a094d4_icdbEntities1();
                    var    update_asset = db.ts_stock.Where(s => s.ictag == temp_asset).First();
                    update_asset.status = "Shipped";
                    db.SaveChanges();
                    message += "<p style='color:green'>" + asset[i] + " Sucessfully Marked as Shipped</p>";
                }

                catch (Exception e) {
                    message += "<p style='color:red'>" + asset[i] + e.InnerException.InnerException.Message + "</p>";
                }
            }

            db.Dispose();

            return(Json(message, JsonRequestBehavior.AllowGet));
        }
Пример #2
0
        public JsonResult get_asset_data(int asset)
        {
            var db          = new db_a094d4_icdbEntities1();
            var rediscovery = (from t in db.rediscovery where t.ictag == asset select t).FirstOrDefault();
            var discovery   = (from t in db.discovery where t.ictag == asset select t).FirstOrDefault();
            var img         = (from t in db.production_log where t.ictags == asset.ToString() select t).FirstOrDefault();

            return(Json(new { discovery = discovery, rediscovery = rediscovery, img = img }, JsonRequestBehavior.AllowGet));
        }
Пример #3
0
        public bool update_rma(string rma_num, string finding)
        {
            bool   sucessful = false;
            string userName;
            string password;

            userName = "******";
            password = "******";
            //use default binding and address from app.config
            // string securityToken = "xxxxxxxxxxxxxxx";
            LoginResult   currentLoginResult = null;
            SforceService sfdcBinding        = null;

            var edit_case = (from t in db.rma where t.rma_number == rma_num select t).FirstOrDefault();

            using (var db = new db_a094d4_icdbEntities1())
            {
                db.Database.ExecuteSqlCommand("Update rma set production_finding = '" + finding + "' where rma_number ='" + rma_num + "'");
            }


            sfdcBinding                              = new SforceService();
            currentLoginResult                       = sfdcBinding.login(userName, password);
            sfdcBinding.Url                          = currentLoginResult.serverUrl;
            sfdcBinding.SessionHeaderValue           = new SessionHeader();
            sfdcBinding.SessionHeaderValue.sessionId = currentLoginResult.sessionId;
            var update_case = new Case();

            update_case.Reviewed_by_Production__c          = true;
            update_case.Reviewed_by_Production__cSpecified = true;
            update_case.Id = edit_case.id;
            update_case.Production_Findings__c = finding;



            SaveResult[] saveResults = sfdcBinding.update(new sObject[] { update_case });

            string result = "";

            if (saveResults[0].success)
            {
                sucessful = true;
                result    = "The update of Lead ID " + saveResults[0].id + " was succesful";
            }
            else
            {
                sucessful = false;
                result    = "There was an error updating the Lead. The error returned was " + saveResults[0].errors[0].message;
            }



            return(sucessful);
        }
Пример #4
0
        public JsonResult search_json(string item)
        {
            List <shipstation_log> result;

            using (var db = new db_a094d4_icdbEntities1())
            {
                result = db.shipstation_log.SqlQuery("SELECT * FROM `db_a094d4_icdb`.`shipstation_log` WHERE LOWER(CONVERT(`row_id` USING utf8mb4)) LIKE '%" + item + "%' OR LOWER(CONVERT(`shipment_date` USING utf8mb4)) LIKE '%" + item + "%' OR LOWER(CONVERT(`order_id` USING utf8mb4)) LIKE '%" + item + "%' OR LOWER(CONVERT(`order_num` USING utf8mb4)) LIKE '%" + item + "%' OR LOWER(CONVERT(`item_name` USING utf8mb4)) LIKE '%" + item + "%' OR LOWER(CONVERT(`item_qty` USING utf8mb4)) LIKE '%" + item + "%' OR LOWER(CONVERT(`item_url` USING utf8mb4)) LIKE '%" + item + "%' OR LOWER(CONVERT(`custom_field_1` USING utf8mb4)) LIKE '%" + item + "%' OR LOWER(CONVERT(`custom_field_2` USING utf8mb4)) LIKE '%" + item + "%' OR LOWER(CONVERT(`custom_field_3` USING utf8mb4)) LIKE '%" + item + "%' OR LOWER(CONVERT(`status` USING utf8mb4)) LIKE '%" + item + "%' ;").ToList();
            }

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
Пример #5
0
        //add ts stock from production
        public JsonResult ts_add_stock(string[] asset)
        {
            string message       = "";
            string current_asset = "";

            //format the tsg sku to the ss format



            // channel = channel.Replace("TSG_", "HW-");



            for (int i = 0; i < asset.Length; i++)
            {
                string temp_asset = asset[i];
                var    db         = new db_a094d4_icdbEntities1();
                var    exisit     = (from t in db.ts_stock where t.ictag == temp_asset select t).FirstOrDefault();

                if (exisit == null)
                {
                    int int_asset = int.Parse(temp_asset);
                    var channel   = (from t in db.rediscovery where t.ictag == int_asset select t.pallet).FirstOrDefault();
                    if (!channel.Contains("TSG_"))
                    {
                        message += "<p style='color:red'>" + asset[i] + " has a non-TechSoup SKU</p>";
                        continue;
                    }
                    channel = channel.Replace("TSG_", "HW-");
                    ts_stock ts = new ts_stock();
                    ts.ictag      = temp_asset;
                    current_asset = temp_asset;
                    ts.sku        = channel;
                    ts.status     = "Ready_for_Shipping";
                    db.ts_stock.Add(ts);

                    db.SaveChanges();
                    message += "<p style='color:green'>" + asset[i] + " Sucessfully Added to " + channel + "</p>";
                }
                else
                {
                    message += "<p style='color:red'>" + asset[i] + " Failed to Import (possible duplicate entry)</p>";
                }
            }



            db.Dispose();

            return(Json(message, JsonRequestBehavior.AllowGet));
        }
Пример #6
0
        public JsonResult delete_pallet(string pallet)
        {
            pallet item_to_delete;
            string message = "";


            using (var remove = new db_a094d4_icdbEntities1()) {
                remove.Database.ExecuteSqlCommand(
                    "Delete from pallet where pallet_name = '" + pallet + "'");
            }


            message = pallet + " Has Been Deleted";



            return(Json(message, JsonRequestBehavior.AllowGet));
        }
Пример #7
0
        //  GET: /Manage/palletmanager
        // [HttpPost]
        public ActionResult createPallet()
        {
            db_a094d4_icdbEntities1 db = new db_a094d4_icdbEntities1();

            var data = (from p in db.pallet_master
                        select new Models.inventoryManageViewModel
            {
                pallet = p.pallet_id,
            });

            SelectList list = new SelectList(data, "pallet", "pallet");

            ViewBag.Roles = list;
            ViewBag.data  = data;



            //Loop through the forms
            for (int i = 0; i <= Request.Form.Count; i++)
            {
                var ictags = Request.Form["ictag[" + i + "]"];

                var pallet_name = Request.Form["pallet_name[" + i + "]"];

                var note = Request.Form["note[" + i + "]"];

                if ((ictags != null) && (pallet_name != null))
                {
                    db.pallet.Add(new pallet {
                        ictags = int.Parse(ictags), pallet_name = pallet_name, note = note
                    });
                    db.SaveChanges();
                }
            }

            return(View());
        }
Пример #8
0
        //add new database entry for discover data
        public ActionResult insert_asset(int asset, string brand, string model, string refrub, string download, string cpu_brand, string cpu_type, string cpu_speed, string ram, string hdd, string serial)
        {
            var cpu = cpu_brand + " " + cpu_type + " " + cpu_speed;
            var xml = mrm_xml(asset.ToString(), brand, model, hdd, ram, serial, cpu);


            var db = new db_a094d4_icdbEntities1();

            var exisit = (from t in db.discovery where t.ictag == asset select t).ToList();

            if (exisit.Count == 0)
            {
                using (db as db_a094d4_icdbEntities1) {
                    var new_entry = new discovery();
                    new_entry.brand         = brand;
                    new_entry.cpu           = cpu;
                    new_entry.hdd           = hdd;
                    new_entry.ictag         = asset;
                    new_entry.location      = null;
                    new_entry.model         = model;
                    new_entry.optical_drive = null;
                    new_entry.ram           = ram;
                    new_entry.serial        = serial;
                    new_entry.time          = DateTime.Now;

                    db.discovery.Add(new_entry);
                    db.SaveChanges();

                    TempData["message"] = "Data Imported";
                }
                if (refrub == "on")
                {
                    using (var db2 = new db_a094d4_icdbEntities1())
                    {
                        var new_entry = new rediscovery();
                        new_entry.brand         = brand;
                        new_entry.cpu           = cpu;
                        new_entry.hdd           = hdd;
                        new_entry.ictag         = asset;
                        new_entry.location      = null;
                        new_entry.model         = model;
                        new_entry.optical_drive = null;
                        new_entry.ram           = ram;
                        new_entry.serial        = serial;
                        new_entry.time          = DateTime.Now;

                        db2.rediscovery.Add(new_entry);
                        db2.SaveChanges();

                        TempData["message"] = "Discovery and Rediscovery Data Imported";
                    }
                }
                if (download == "on")
                {
                    System.IO.MemoryStream stream = new System.IO.MemoryStream();
                    XmlTextWriter          writer = new XmlTextWriter(stream, System.Text.Encoding.UTF8);
                    xml.WriteTo(writer);
                    writer.Flush();
                    Response.Clear();
                    byte[] byteArray = stream.ToArray();
                    Response.AppendHeader("Content-Disposition", "attachment; filename=" + asset.ToString() + ".xml");
                    Response.AppendHeader("Content-Length", byteArray.Length.ToString());
                    Response.ContentType = "application/octet-stream";
                    Response.BinaryWrite(byteArray);
                    writer.Close();


                    Response.End();
                }
            }

            else
            {
                TempData["message"] = "an error has occurred";
            }
            return(View());
        }
Пример #9
0
        //get year to date report


        public JsonResult get_yTd_report(string start, string end)
        {
            using (var db = new db_a094d4_icdbEntities1())
            {
                int      avg_return        = 0;
                int      avg_alltime       = 0;
                int      avg_year          = 0;
                int      avg_year_counter  = 0;
                int      avg_month         = 0;
                int      avg_month_counter = 0;
                DateTime date_start;
                DateTime date_end;
                if (start == null && end == null)
                {
                    date_start = new DateTime(2015, 1, 1);
                    date_end   = DateTime.Now.Date;
                }
                else
                {
                    date_start = DateTime.Parse(start);
                    date_end   = DateTime.Parse(end);
                }

                var alltime_C2DDK_result     = (from t in db.retail_report where t.name.Contains("MARDKC2D") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_i3DK_result      = (from t in db.retail_report where t.name.Contains("MARDKi3") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_i5DK_result      = (from t in db.retail_report where t.name.Contains("MARDKi5") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_i7DK_result      = (from t in db.retail_report where t.name.Contains("MARDKi7") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_C2DLP_result     = (from t in db.retail_report where t.name.Contains("MARLPC2D") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_i3LP_result      = (from t in db.retail_report where t.name.Contains("MARLPi3") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_i5LP_result      = (from t in db.retail_report where t.name.Contains("MARLPi5") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_i7LP_result      = (from t in db.retail_report where t.name.Contains("MARLPi7") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_mbp_result       = (from t in db.retail_report where t.name.Contains("MBP105-109") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_mb_result        = (from t in db.retail_report where t.name.Contains("MB105-109") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_idk_result       = (from t in db.retail_report where t.name.Contains("IDK105-109") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_oem_c2ddk_result = (from t in db.retail_report where t.name.Contains("OEMDKC2D") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_oem_i3DK_result  = (from t in db.retail_report where t.name.Contains("OEMDKi3") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_oem_i5DK_result  = (from t in db.retail_report where t.name.Contains("OEMDKi5") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_oem_i7DK_result  = (from t in db.retail_report where t.name.Contains("OEMDKi7") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_oem_C2DLP_result = (from t in db.retail_report where t.name.Contains("OEMLPC2D") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_oem_i3LP_result  = (from t in db.retail_report where t.name.Contains("OEMLPi3") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_oem_i5LP_result  = (from t in db.retail_report where t.name.Contains("OEMLPi5") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();
                var alltime_oem_i7LP_result  = (from t in db.retail_report where t.name.Contains("OEMLPi7") && t.type == "sale" && (t.date_sold >= date_start && t.date_sold <= date_end) select t).Count();



                var result        = db.Database.SqlQuery <date_result>("SELECT DISTINCT(date(date_sold)) as date ,count( * ) AS count FROM retail_report where type = 'sale' GROUP BY date_sold ORDER BY date_sold ASC ").ToArray();
                var return_result = db.Database.SqlQuery <date_result>("SELECT DISTINCT(date(date_sold)) as date ,count( * ) AS count FROM retail_report where type = 'return' GROUP BY date_sold ORDER BY date_sold ASC ").ToArray();
                var month         = db.Database.SqlQuery <date_result>("SELECT DISTINCT(date(date_sold)) as date ,count( * ) AS count FROM retail_report where type = 'sale' AND YEAR(date_sold) = YEAR(NOW()) AND MONTH(date_sold) = MONTH(NOW()) GROUP BY date_sold ORDER BY date_sold ASC ").ToArray();
                var year          = db.Database.SqlQuery <date_result>("SELECT DISTINCT(date(date_sold)) as date ,count( * ) AS count FROM retail_report where type = 'sale' AND YEAR(date_sold) = YEAR(NOW()) GROUP BY date_sold ORDER BY date_sold ASC ").ToArray();
                //   var result2 = db.Database.SqlQuery<string>("SELECT DISTINCT(date(date_sold)) as date FROM retail_report where type = 'sale' GROUP BY date_sold ORDER BY date_sold ASC ").ToArray();
                foreach (var item in month)
                {
                    DateTime dt = Convert.ToDateTime(item.date);
                    item.date = dt.ToString("yyyy-MM-dd");
                }
                foreach (var item in return_result)
                {
                    DateTime dt = Convert.ToDateTime(item.date);
                    item.date   = dt.ToString("yyyy-MM-dd");
                    avg_return += int.Parse(item.count);
                }
                foreach (var item in year)
                {
                    DateTime dt = Convert.ToDateTime(item.date);
                    item.date = dt.ToString("yyyy-MM-dd");
                }
                foreach (var item in result)
                {
                    DateTime dt = Convert.ToDateTime(item.date);
                    item.date = dt.ToString("yyyy-MM-dd");
                    var test_year  = DateTime.Now.Year.ToString();
                    var test_month = DateTime.Now.ToString("MM");
                    avg_alltime += int.Parse(item.count);
                    if (item.date.Contains(DateTime.Now.Year.ToString()))
                    {
                        avg_year += int.Parse(item.count);
                        avg_year_counter++;
                    }
                    if (item.date.Contains(test_year + "-" + test_month))
                    {
                        avg_month += int.Parse(item.count);
                        avg_month_counter++;
                    }
                }

                avg_month   = (avg_month / avg_month_counter);
                avg_alltime = (avg_alltime / result.Length);
                avg_year    = (avg_year / avg_year_counter);
                avg_return  = (avg_return / return_result.Length);
                return(Json(new { oem_C2Dlp_all = alltime_oem_C2DLP_result, oem_i3lp_all = alltime_oem_i3LP_result, oem_i5lp_all = alltime_oem_i5LP_result, oem_i7lp_all = alltime_oem_i7LP_result, oem_C2DDK_all = alltime_oem_c2ddk_result, oem_i3dk_all = alltime_oem_i3DK_result, oem_i5dk_all = alltime_oem_i5DK_result, oem_i7dk_all = alltime_oem_i7DK_result, C2Dlp_all = alltime_C2DLP_result, i3lp_all = alltime_i3LP_result, i5lp_all = alltime_i5LP_result, i7lp_all = alltime_i7LP_result, C2DDK_all = alltime_C2DDK_result, i3dk_all = alltime_i3DK_result, i5dk_all = alltime_i5DK_result, i7dk_all = alltime_i7DK_result, return_result = return_result, avg_return = avg_return, alltime_result = result, month_result = month, year_result = year, avg_month = avg_month, avg_alltime = avg_alltime, avg_year = avg_year, alltime_mbp = alltime_mbp_result, alltime_mb = alltime_mb_result, alltime_idk = alltime_idk_result }, JsonRequestBehavior.AllowGet));
            }
        }
Пример #10
0
        public async Task <ActionResult> get_shipment(string id)
        {
            db_a094d4_icdbEntities1 db = new db_a094d4_icdbEntities1();
            var baseAddress            = new Uri("https://ssapi.shipstation.com/");

            if (id == "interconnection123")
            {
                try
                {
                    using (var httpClient = new HttpClient {
                        BaseAddress = baseAddress
                    })
                    {
                        //Debug.Write(jj);
                        httpClient.DefaultRequestHeaders.TryAddWithoutValidation("authorization", "Basic ZmU3YzE2MGMyZjE0NDc1ZDljNWQ0ZWI2ZmMzYmRhOWU6YzRiM2RhMjlkZWZlNDgyOWJlZmRlYTExNmU1N2Q5ZTY=");
                        // var DateStart = new DateTime(2016, 12, 13);
                        var DateStart = DateTime.Today;
                        var DateEnd   = DateTime.Today.AddDays(+1);
                        // var DateEnd = new DateTime(2016, 12, 30);
                        using (var response = await httpClient.GetAsync("shipments?includeShipmentItems=true&shipDateStart=" + DateStart + "&shipDateEnd=" + DateEnd))
                        {
                            if (response.IsSuccessStatusCode != true)
                            {
                                return(View(ViewBag.message = response.RequestMessage));
                            }
                            string responseData = await response.Content.ReadAsStringAsync();

                            var result = JsonConvert.DeserializeObject <ss_order.ss_shipment_detail.Rootobject>(responseData);

                            var total_page = result.pages;

                            for (int i = 0; i < result.shipments.Length; i++)
                            {
                                if (result.shipments[i].shipmentItems != null)
                                {
                                    var order_id = result.shipments[i].orderId;
                                    await get_order_detail(order_id);
                                }
                            }
                        }
                    }


                    db.Dispose();

                    using (var db2 = new db_a094d4_icdbEntities1())
                    {
                        db2.Database.ExecuteSqlCommand(
                            "insert into process_run_time (process) values ('ShipStation')");
                    }
                }
                catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
                {
                    Exception raise = dbEx;
                    foreach (var validationErrors in dbEx.EntityValidationErrors)
                    {
                        foreach (var validationError in validationErrors.ValidationErrors)
                        {
                            string message = string.Format("{0}:{1}",
                                                           validationErrors.Entry.Entity.ToString(),
                                                           validationError.ErrorMessage);
                            // raise a new exception nesting
                            // the current instance as InnerException
                            raise = new InvalidOperationException(message, raise);
                        }
                    }
                    throw raise;
                }

                ViewBag.message = "Completed";
                return(View());
            }



            else
            {
                ViewBag.message = "Invalid ID";
                return(View());
            }
        }
Пример #11
0
        public async Task get_order_detail(int orderID)
        {
            var bb = 0;

            Thread.Sleep(1700);
            //try {
            var baseAddress            = new Uri("https://ssapi.shipstation.com/");
            db_a094d4_icdbEntities1 db = new db_a094d4_icdbEntities1();

            using (var httpClient = new HttpClient {
                BaseAddress = baseAddress
            })
            {
                httpClient.DefaultRequestHeaders.TryAddWithoutValidation("authorization", "Basic ZmU3YzE2MGMyZjE0NDc1ZDljNWQ0ZWI2ZmMzYmRhOWU6YzRiM2RhMjlkZWZlNDgyOWJlZmRlYTExNmU1N2Q5ZTY=");

                using (var response = await httpClient.GetAsync("orders/" + orderID + ""))
                {
                    string responseData = await response.Content.ReadAsStringAsync();

                    var result = JsonConvert.DeserializeObject <Models.ShipStation_orderID.Rootobject>(responseData);
                    for (int i = 0; i < result.items.Length; i++)
                    {
                        var write_table = new shipstation_log();

                        if (result.advancedOptions.customField1 == null)
                        {
                            result.advancedOptions.customField1 = "";
                        }
                        if (result.advancedOptions.customField2 == null)
                        {
                            result.advancedOptions.customField2 = "";
                        }

                        if (result.advancedOptions.customField3 == null)
                        {
                            result.advancedOptions.customField3 = "";
                        }

                        write_table.sku            = result.items[i].sku;
                        write_table.store_id       = result.advancedOptions.storeId;
                        write_table.item_name      = result.items[i].name;
                        write_table.item_qty       = result.items[i].quantity;
                        write_table.item_url       = result.items[i].imageUrl;
                        write_table.custom_field_1 = result.advancedOptions.customField1.ToString();
                        write_table.custom_field_2 = result.advancedOptions.customField2.ToString();
                        write_table.custom_field_3 = result.advancedOptions.customField3.ToString();
                        write_table.order_id       = orderID;
                        write_table.order_num      = result.orderNumber;
                        write_table.status         = result.orderStatus;
                        if (result.shipDate == null)
                        {
                            write_table.shipment_date = null;
                        }
                        else
                        {
                            write_table.shipment_date = DateTime.Parse(result.shipDate);
                        }

                        db.shipstation_log.Add(write_table);
                        db.SaveChanges();
                        Debug.WriteLine(bb++);
                        count_item(write_table);
                    }
                }
            }

            //}
            //catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
            //{
            //    Exception raise = dbEx;
            //    foreach (var validationErrors in dbEx.EntityValidationErrors)
            //    {
            //        foreach (var validationError in validationErrors.ValidationErrors)
            //        {
            //            string message = string.Format("{0}:{1}",
            //                validationErrors.Entry.Entity.ToString(),
            //                validationError.ErrorMessage);
            //            // raise a new exception nesting
            //            // the current instance as InnerException
            //            raise = new InvalidOperationException(message, raise);
            //        }
            //    }
            //    throw raise;
            //}
        }
Пример #12
0
        public ActionResult main()
        {
            using (var db = new db_a094d4_icdbEntities1())
            {
                //  var result = (from t in db.shipstation_log where t.store_id == 12171 && t.shipment_date.Contains("2016-01") select t).ToList();
                //distinct customer field 2 list
                //   var q = result.GroupBy(x => x.custom_field_2).Select(group => group.First()).ToList() ;
                //iterate that list
                //    for (int i =0;i < q.Count; i++)
                {
                    //break the fields to indiv item
                    //add number of item to SKU
                    //switch (q[i].sku) {

                    //    case "HW-48678":
                    //        hw48678 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-48680":
                    //        hw48680 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-48986":
                    //        hw48986 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-48993":
                    //        hw48993 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-48997":
                    //        hw48997 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49000":
                    //        hw49000 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49001":
                    //        hw49001 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49110":
                    //        hw49110 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49193":
                    //        hw49193 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49195":
                    //        hw49195 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49347":
                    //        hw49347 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49812":
                    //        hw49812 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49734":
                    //        hw49734 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49704":
                    //        hw49704 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49654":
                    //        hw49654 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49652":
                    //        hw49652 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49649":
                    //        hw49649 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49557":
                    //        hw49557 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //    case "HW-49555":
                    //        hw49555 += count_item(q[i].custom_field_2,int.Parse(q[i].item_qty.ToString()));
                    //        break;
                    //}
                }
            }

            return(View());
        }
Пример #13
0
        //process the item in custom fields
        public void count_item(shipstation_log entry)
        {
            try
            {
                var write_table = new ship_log();

                if (string.IsNullOrEmpty(entry.custom_field_2))
                {
                }
                else
                {
                    try {
                        string[] lines = entry.custom_field_2.Split(new string[] { "\r\n", "\n" }, StringSplitOptions.None);
                        lines = lines.Where(x => !string.IsNullOrEmpty(x)).ToArray();
                        foreach (var item in lines)
                        {
                            using (db_a094d4_icdbEntities1 db = new db_a094d4_icdbEntities1())
                            {
                                var exisit = (from t in db.ship_log where t.ictag == item select t).SingleOrDefault();
                                if (exisit == null)
                                {
                                    write_table.ictag     = item;
                                    write_table.order_id  = entry.order_id;
                                    write_table.order_num = entry.order_num;
                                    write_table.shipdate  = entry.shipment_date;
                                    write_table.sku       = entry.sku;
                                    write_table.status    = entry.status;
                                    write_table.store_id  = entry.store_id;
                                    db.ship_log.Add(write_table);
                                    db.SaveChanges();
                                }
                                var update = db.ts_stock.Where(s => s.ictag == item).FirstOrDefault();
                                if (update != null)
                                {
                                    update.status      = "Shipped";
                                    update.update_time = DateTime.Now;
                                    using (var dbCtx = new db_a094d4_icdbEntities1())
                                    {
                                        //Mark entity as modified
                                        dbCtx.Entry(update).State = System.Data.Entity.EntityState.Modified;

                                        //call SaveChanges
                                        dbCtx.SaveChanges();
                                    }
                                }
                            }
                        }
                    }

                    catch {
                        entry.custom_field_2 = "";
                    }
                }
            }
            catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
            {
                Exception raise = dbEx;
                foreach (var validationErrors in dbEx.EntityValidationErrors)
                {
                    foreach (var validationError in validationErrors.ValidationErrors)
                    {
                        string message = string.Format("{0}:{1}",
                                                       validationErrors.Entry.Entity.ToString(),
                                                       validationError.ErrorMessage);
                        // raise a new exception nesting
                        // the current instance as InnerException
                        raise = new InvalidOperationException(message, raise);
                    }
                }
                throw raise;
            }
        }