public static EtsyItem ConvertEtsyItemDb(string listing)
{
List <EtsyItemDb> res = ORM.EtsyItemDbs.Where(r => r.Listing_Id == listing).ToList();
if (res.Count > 0)
{
EtsyItemDb e = res[0];
EtsyItem etsyItem = new EtsyItem();
etsyItem.Listing_Id = e.Listing_Id;
etsyItem.Title = e.Title;
etsyItem.Price = e.Price;
etsyItem.Currency_Code = e.Currency_Code;
etsyItem.Item_Length = e.Item_Length;
etsyItem.Item_Width = e.Item_Width;
etsyItem.Item_Height = e.Item_Height;
etsyItem.Item_Dimensions_unit = e.Item_Dimensions_Unit;
etsyItem.Url = e.Url;
etsyItem.ImageThumbUrl = e.ImageThumbUrl;
etsyItem.ImageFullUrl = e.ImageFullUrl;
etsyItem.Description = e.Description;
return(etsyItem);
}
else
{
return(new EtsyItem());
}
}
// GET: UnSpaceDb
public ActionResult SaveUserSpace(UserSpace userSpace)
{
List <EtsyItem> furnList = new List <EtsyItem>();
if (TempData["prevPage"] != null)
{
TempData["prevPage"] = TempData["prevPage"];
}
if (TempData["nextPage"] != null)
{
TempData["nextPage"] = TempData["nextPage"];
}
if (TempData["SearchQ"] != null)
{
TempData["SearchQ"] = TempData["SearchQ"];
}
if (TempData["furnList"] != null)
{
furnList = (List <EtsyItem>)TempData["furnList"];
}
UserSpace result = ORM.UserSpaces.SingleOrDefault(u => u.UserId == userSpace.UserId && u.Name == userSpace.Name);
if (result != null)
{
result.Listing = userSpace.Listing;
result.QRCode = userSpace.QRCode;
result.Name = userSpace.Name;
result.SpaceDimensions = userSpace.SpaceDimensions;
result.Positions = userSpace.Positions;
try
{
ORM.SaveChanges();
}
catch (DbEntityValidationException e)
{
string error = e.Message;
}
}
else
{
ORM.UserSpaces.Add(userSpace);
try
{
ORM.SaveChanges();
}
catch (DbEntityValidationException e)
{
string error = e.Message;
}
}
foreach (EtsyItem e in furnList)
{
List <EtsyItemDb> res = ORM.EtsyItemDbs.Where(r => r.Listing_Id == e.Listing_Id).ToList();
if (res.Count == 0)
{
EtsyItemDb dbItem = new EtsyItemDb();
dbItem.Listing_Id = e.Listing_Id;
dbItem.Title = e.Title;
dbItem.Price = e.Price;
dbItem.Currency_Code = e.Currency_Code;
dbItem.Item_Length = e.Item_Length;
dbItem.Item_Width = e.Item_Width;
dbItem.Item_Height = e.Item_Height;
dbItem.Item_Dimensions_Unit = e.Item_Dimensions_unit;
dbItem.Url = e.Url;
dbItem.ImageThumbUrl = e.ImageThumbUrl;
dbItem.ImageFullUrl = e.ImageFullUrl;
dbItem.Description = e.Description;
ORM.EtsyItemDbs.Add(dbItem);
try
{
ORM.SaveChanges();
}
catch (DbEntityValidationException err)
{
string error = err.Message;
}
}
}
return(RedirectToAction("Index", "Space"));
}