Esempio n. 1
0
 public static void ItemStatuses()
 {
     q = ItemStatus.ListUpload("SELECT * FROM productStatus ");
     AdvancedForm._Form1.FeedBack("Uploading product status... " + q.Count);
     foreach (var h in q)
     {
         string Query = "DELETE from productStatus WHERE id ='" + h.Id + "'";
         MySQL.Query(Query);
         ItemStatus p = new ItemStatus(h.Id, h.FollowID, h.Title, h.Status, h.Details, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "true", Helper.CompanyID);
         if (MySQL.Insert(p) != "")
         {
             AdvancedForm._Form1.FeedBack("Uploading ... " + h.Details.ToString());
             ItemReview u = new ItemReview(h.Id, h.FollowID, h.Title, h.Status, h.Details, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "true", Helper.CompanyID);
             DBConnect.UpdateMySql(u, h.Id);
             AdvancedForm._Form1.FeedBack("Updating .. " + h.Details.ToString());
         }
     }
     AdvancedForm._Form1.FeedBack("Uploading product status Complete");
 }