// GET: api/Admin
public IEnumerable <tblStoreInfo> Get()
{
LocalStoreEntities1 entity = new LocalStoreEntities1();
var stores = (from e in entity.tblStoreInfoes where e.AdminApprove == 0
select e).ToList();
return(stores);
}
// POST: api/Product
public void Post([FromBody] tblProductInfo value)
{
using (LocalStoreEntities1 entity = new LocalStoreEntities1())
{
entity.tblProductInfoes.Add(value);
entity.SaveChanges();
}
}
// DELETE api/values/5
public void Delete(string StoreAuthId)
{
using (LocalStoreEntities1 entity = new LocalStoreEntities1())
{
var oldStore = entity.tblStoreInfoes.Where(p => p.StoreAuthId == StoreAuthId).FirstOrDefault();
entity.tblStoreInfoes.Remove(oldStore);
entity.SaveChanges();
}
}
// GET: api/Product/5
public List <tblProductInfo> Get(string StoreAuthId)
{
List <tblProductInfo> products = null;
using (LocalStoreEntities1 entity = new LocalStoreEntities1())
{
products = entity.tblProductInfoes.Where(p => p.StoreAuthId == StoreAuthId).ToList();
}
return(products);
}
// POST api/values
public string Post([FromBody] tblStoreInfo value)
{
value.StoreAuthId = value.StoreName.Replace(" ", string.Empty) + "@LocalStore.com";
using (LocalStoreEntities1 entity = new LocalStoreEntities1())
{
entity.tblStoreInfoes.Add(value);
entity.SaveChanges();
}
return(value.StoreAuthId);
}
// GET api/values/5
public tblStoreInfo Get(string StoreAuthId)
{
tblStoreInfo store = null;
using (LocalStoreEntities1 entity = new LocalStoreEntities1())
{
store = entity.tblStoreInfoes.Where(p => p.StoreAuthId == StoreAuthId).FirstOrDefault();
}
return(store);
}
// GET: api/Fuzzy/5
public List <tblStoreInfo> Get(int searchId)
{
List <tblStoreInfo> stores = null;
using (LocalStoreEntities1 entity = new LocalStoreEntities1())
{
//stores = entity.tblStoreInfoes.Search(s => s.StoreName,
// s => s.SearchTags).ContainingAll(searchQuery).ToList();
}
return(stores);
}
// PUT: api/Product/5
public void Put(string StoreAuthId, [FromBody] tblProductInfo value)
{
using (LocalStoreEntities1 entity = new LocalStoreEntities1())
{
var products = entity.tblProductInfoes.Where(p => p.StoreAuthId == StoreAuthId).ToList <tblProductInfo>();
if (products != null)
{
//var product = products.Where(z => z.ProductId == value.ProductId).FirstOrDefault();
//if (product)
}
entity.SaveChanges();
}
}
// PUT: api/Admin/5
public int Put(int id, [FromBody] tblStoreInfo value)
{
int result = 0;//fail
using (LocalStoreEntities1 entity = new LocalStoreEntities1())
{
var foundProduct = entity.tblStoreInfoes.Where(p => p.StoreAuthId == value.StoreAuthId).FirstOrDefault();
if (foundProduct != null)
{
foundProduct.AdminApprove = value.AdminApprove;
result = entity.SaveChanges();
}
}
return(result);
}
// PUT api/values/5
public void Put(string StoreAuthId, [FromBody] tblStoreInfo value)
{
using (LocalStoreEntities1 entity = new LocalStoreEntities1())
{
var oldStore = entity.tblStoreInfoes.Where(p => p.StoreAuthId == StoreAuthId).FirstOrDefault();
if (oldStore != null)
{
oldStore.StoreName = value.StoreName;
oldStore.StoreAddress = value.StoreAddress;
oldStore.Pincode = value.Pincode;
oldStore.SearchTags = value.SearchTags;
entity.SaveChanges();
}
}
}
