static void Main(string[] args)
{
MyDataInfo mydata = new MyDataInfo();
mydata = MySQLDB.GetTestDemoData();
if (MySQLDB.InsertDataInfoWithOutDuplicate(mydata))
{
Console.WriteLine("success on step : mydata.InsertDataInfoWithOutDuplicate(mydata)");
}
else
{
Console.WriteLine("error on step : mydata.InsertDataInfoWithOutDuplicate(mydata)");
Console.WriteLine("error on mydata.ItemID = {0}", mydata.ItemID);
}
if (MySQLDB.DeleteDataInfoByItemID(mydata.ItemID))
{
if (MySQLDB.InsertDataInfo(mydata))
{
Console.WriteLine("success on step : mydb.InsertDataInfo(mydata)");
}
else
{
Console.WriteLine("error on step : mydb.InsertDataInfo(mydata)");
Console.WriteLine("error on mydata.ItemID = {0}", mydata.ItemID);
}
}
else
{
Console.WriteLine("error on step : mydb.DeleteDataInfoByItemID(mydata.ItemID)");
Console.WriteLine("error on mydata.ItemID = {0}", mydata.ItemID);
}
mydata = MySQLDB.GetDataInfoByItemId(mydata.ItemID);
if (MySQLDB.UpDateDataInfoField(mydata.ItemID, "ItemName", "XXX"))
{
Console.WriteLine("success on step : mydb.UpDateDataInfoField(mydata.ItemID, filedName, filedValue)");
}
mydata = MySQLDB.GetDataInfoByItemId(mydata.ItemID);
}
private void InitTest(int categorys, int entitys)
{
this.MainId = this.GetNextId();
using (this.ChildrenService.BulkAdd())
{
var data = MyDataInfo.CreateData(categorys, entitys);
foreach (var categoryName in data)
{
int categoryId = this.GetNextId();
var categoryViewModel = new CategoryViewModel(categoryId, this.MainId, "category" + categoryId.ToString(), null, this);
this.AddChild(categoryViewModel);
foreach (var name in categoryName.Value)
{
int id = this.GetNextId();
var personViewModel = new EntityViewModey(id, categoryId, "entity" + id.ToString(), categoryViewModel, this);
this.AddChild(personViewModel);
}
}
}
}
/// <summary>
/// SetTestDemoData
/// </summary>
/// <returns></returns>
private static MyDataInfo SetTestDemoData()
{
MyDataInfo mydata = new MyDataInfo();
mydata.ItemID = "20120424114857146";
//mydata.SKU = "";
mydata.ItemCategory = "clothing";
mydata.SubCategory = "clothing kids";
mydata.CompanyName = "walmart.com";
mydata.BrandName = "";
mydata.ItemName = "Faded Glory - Baby Girls 2-Piece Graphic Fleece Set";
mydata.ItemDescription = "100% polyester. Fleece lining. Full zip front. Long sleeves. Attached hood. Elastic waistband.";
mydata.ImgPath = "http://askbargains.com/Image/Products/20120424/20120424114857146.jpg";
mydata.ForwardLink = "http://linksynergy.walmart.com/fs-bin/click?id=CncUtE6QSJg&subid=0&offerid=183959.1&type=10&tmpid=1082&RD_PARM0=http%3A%2F%2Fwww.walmart.com%2Fip%2F17806841&RD_PARM1=http%3A%2F%2Fwww.walmart.com%2Fip%2F17806841";
mydata.OriginalPrice = "69.99";
mydata.ItemPrice = "49.99";
mydata.Promotion = "SAVE 20% OFF";
mydata.UserRated = "9";
mydata.PublishDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
mydata.ExpireDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
mydata.MetaKeyWord = "clothing,clothing kids,Faded,Glory,Baby,Girls,2,Piece,Graphic,Fleece,Set";
mydata.MetaDescription = "100% polyester. Fleece lining. Full zip front. Long sleeves. Attached hood. Elastic waistband.";
return mydata;
}
/// <summary>
/// command text of the insert data info
/// </summary>
/// <param name="da">MyDataInfo da</param>
/// <returns>string command text</returns>
private static string GetInsertDataInfoCommandText(MyDataInfo da)
{
return "INSERT INTO DataInfo (ItemID,SKU,ItemCategory,SubCategory,CompanyName,BrandName,ItemName,ItemDescription,ImgPath,ForwardLink,OriginalPrice ,ItemPrice,Promotion,UserRated,PublishDate,ExpireDate,MetaKeyWord,MetaDescription,Others1,Others2)"
+ " VALUES" + "('" + da.ItemID + "','" + da.SKU + "','" + da.ItemCategory + "','" + da.SubCategory + "','" + da.CompanyName + "','"
+ da.BrandName + "','" + da.ItemName + "','" + da.ItemDescription + "','" + da.ImgPath + "','" + da.ForwardLink + "','"
+ da.OriginalPrice + "','" + da.ItemPrice + "','" + da.Promotion + "','" + da.UserRated + "','" + da.PublishDate + "','"
+ da.ExpireDate + "','" + da.MetaKeyWord+"','"+da.MetaDescription+"','"+da.Others1 + "','" + da.Others2 + "')";
}
/// <summary>
/// delete old data which has same itemid before insert it
/// </summary>
/// <param name="mydata">MyDataInfo obj</param>
/// <returns>boolean return true with no err</returns>
public static bool InsertDataInfoWithOutDuplicate(MyDataInfo mydata)
{
if (DeleteDataInfoByItemID(mydata.ItemID))
{
if (InsertDataInfo(mydata))
{
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}
/// <summary>
/// insert data into the DataInfo table
/// </summary>
/// <param name="mydatainfo">the obj of the MyDataInfo</param>
/// <returns>bool insert data</returns>
public static bool InsertDataInfo(MyDataInfo mydata)
{
MySqlConnection conn = new MySqlConnection(dbconnection);
MySqlCommand cmd = new MySqlCommand(GetInsertDataInfoCommandText(mydata), conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return true;
}
catch (Exception e)
{
conn.Close();
Console.WriteLine("error on InsertDataInfo {0}",e.ToString());
return false;
}
}
/// <summary>
/// get data info by itemid
/// </summary>
/// <param name="itemId">itemid</param>
/// <returns>MyDataInfo obj</returns>
public static MyDataInfo GetDataInfoByItemId(string itemId)
{
MyDataInfo mydata = new MyDataInfo();
DataSet ds = new DataSet();
MySqlConnection conn = new MySqlConnection(dbconnection);
MySqlDataAdapter adapt = new MySqlDataAdapter(GetSelectDataInfoByItemIdCommandText(itemId), conn);
try
{
adapt.Fill(ds);
foreach (DataRow row in ds.Tables[0].Rows)
{
foreach (DataColumn Col in ds.Tables[0].Columns)
{
mydata.ItemID = row["ItemID"].ToString();
mydata.SKU = row["ItemID"].ToString();
mydata.ItemCategory = row["ItemCategory"].ToString();
mydata.SubCategory = row["SubCategory"].ToString();
mydata.CompanyName = row["CompanyName"].ToString();
mydata.BrandName = row["BrandName"].ToString();
mydata.ItemName = row["ItemName"].ToString();
mydata.ItemDescription = row["ItemDescription"].ToString();
mydata.ImgPath = row["ImgPath"].ToString();
mydata.ForwardLink = row["ForwardLink"].ToString();
mydata.OriginalPrice = row["OriginalPrice"].ToString();
mydata.ItemPrice = row["ItemPrice"].ToString();
mydata.Promotion = row["Promotion"].ToString();
mydata.UserRated = row["UserRated"].ToString();
mydata.PublishDate = row["PublishDate"].ToString();
mydata.ExpireDate = row["ExpireDate"].ToString();
mydata.MetaKeyWord = row["MetaKeyWord"].ToString();
mydata.MetaDescription = row["MetaDescription"].ToString();
mydata.Others1 = row["Others1"].ToString();
mydata.Others2 = row["Others2"].ToString();
}
}
}
catch (Exception e)
{
Console.WriteLine("error on GetDataInfoByItemId {0}", e.ToString());
return null;
}
return mydata;
}
public void MyData()
{
Prop1 = new MyDataInfo();
Prop2 = new MyDataInfo();
}
