public Result <ArticleDto> Add(ArticleDto article)
{
try
{
Articles newArticle;
using (db = new SuperZapatosContext())
{
newArticle = new Articles()
{
Id = article.Id,
Name = article.Name.Trim(),
Description = article.Description.Trim(),
Price = article.Price,
Store_Id = article.Store_Id,
Total_in_shelf = article.Total_in_shelf,
Total_in_vault = article.Total_in_vault
};
newArticle = db.Articles.Add(newArticle);
article.Id = newArticle.Id;
if (db.SaveChanges() > 0)
{
return new Result <ArticleDto>
{
Response = article,
Success = true,
TotalElements = 1,
Error = null
}
}
;
}
return(new Result <ArticleDto>
{
Response = null,
Success = false,
TotalElements = 0,
Error = new Error {
ErrorCode = 404, ErrorMsg = "Not Found"
}
});
}
catch (Exception ex)
{
return(new Result <ArticleDto>
{
Response = null,
Success = false,
TotalElements = 0,
Error = new Error {
ErrorCode = 500, ErrorMsg = ex.Message
}
});
}
}
public Result <StoreDto> Update(StoreDto store)
{
try
{
using (db = new SuperZapatosContext())
{
Store obj = db.Store.Find(store.Id);
if (obj != null)
{
obj.Name = store.Name.Trim();
obj.Address = store.Address.Trim();
if (db.SaveChanges() > 0)
{
return(new Result <StoreDto>
{
Response = new StoreDto {
Id = obj.Id, Address = obj.Address.Trim(), Name = obj.Name.Trim()
},
Success = true,
TotalElements = 1,
Error = null
});
}
}
}
return(new Result <StoreDto>
{
Response = null,
Success = false,
TotalElements = 0,
Error = new Error {
ErrorCode = 404, ErrorMsg = "Not Found"
}
});
}
catch (Exception ex)
{
return(new Result <StoreDto>
{
Response = null,
Success = false,
TotalElements = 0,
Error = new Error {
ErrorCode = 500, ErrorMsg = ex.Message
}
});
}
}
public Result <StoreDto> Add(StoreDto store)
{
try
{
Store newStore;
using (db = new SuperZapatosContext())
{
newStore = new Store()
{
Address = store.Address.Trim(),
Name = store.Name.Trim()
};
newStore = db.Store.Add(newStore);
store.Id = newStore.Id;
if (db.SaveChanges() > 0)
{
return new Result <StoreDto>
{
Response = store,
Success = true,
TotalElements = 1,
Error = null
}
}
;
}
return(new Result <StoreDto>
{
Response = null,
Success = false,
TotalElements = 0,
Error = new Error {
ErrorCode = 404, ErrorMsg = "Not Found"
}
});
}
catch (Exception ex)
{
return(new Result <StoreDto>
{
Response = null,
Success = false,
TotalElements = 0,
Error = new Error {
ErrorCode = 500, ErrorMsg = ex.Message
}
});
}
}
public Result <bool> Delete(int id)
{
try
{
using (db = new SuperZapatosContext())
{
Store obj = db.Store.Find(id);
if (obj != null)
{
db.Store.Remove(obj);
if (db.SaveChanges() > 0)
{
return(new Result <bool>
{
Response = true,
Success = true,
TotalElements = 1,
Error = null
});
}
}
}
return(new Result <bool>
{
Response = false,
Success = false,
TotalElements = 0,
Error = new Error {
ErrorCode = 404, ErrorMsg = "Not Found"
}
});
}
catch (Exception ex)
{
return(new Result <bool>
{
Response = false,
Success = false,
TotalElements = 0,
Error = new Error {
ErrorCode = 500, ErrorMsg = ex.Message
}
});
}
}
public void Commit()
{
_db.SaveChanges();
_transaction.Complete();
}
public Result <ArticleDto> Update(ArticleDto article)
{
try
{
using (db = new SuperZapatosContext())
{
Articles obj = db.Articles.Find(article.Id);
if (obj != null)
{
obj.Id = article.Id;
obj.Name = article.Name.Trim();
obj.Description = article.Description.Trim();
obj.Price = article.Price;
obj.Store_Id = article.Store_Id;
obj.Total_in_shelf = article.Total_in_shelf;
obj.Total_in_vault = article.Total_in_vault;
if (db.SaveChanges() > 0)
{
return(new Result <ArticleDto>
{
Response = new ArticleDto
{
Id = obj.Id,
Name = obj.Name.Trim(),
Description = obj.Description.Trim(),
Price = obj.Price,
Store_Id = obj.Store_Id,
Total_in_shelf = obj.Total_in_shelf,
Total_in_vault = obj.Total_in_vault
},
Success = true,
TotalElements = 1,
Error = null
});
}
}
}
return(new Result <ArticleDto>
{
Response = null,
Success = false,
TotalElements = 0,
Error = new Error {
ErrorCode = 404, ErrorMsg = "Not Found"
}
});
}
catch (Exception ex)
{
return(new Result <ArticleDto>
{
Response = null,
Success = false,
TotalElements = 0,
Error = new Error {
ErrorCode = 500, ErrorMsg = ex.Message
}
});
}
}