public IActionResult Search(BookFinderVM bookFinderVM)
{
var title = bookFinderVM.Title;
var author = bookFinderVM.Author;
var publisher = bookFinderVM.Publisher;
var isbn = bookFinderVM.ISBN;
var dataPage = caribuku(title, author, publisher, isbn).Result;
return(View());
}
public JsonResult Update(int id, BookFinderVM bookFinderVM)
{
var myContent = JsonConvert.SerializeObject(bookFinderVM);
var buffer = System.Text.Encoding.UTF8.GetBytes(myContent);
var byteContent = new ByteArrayContent(buffer);
byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
Client.DefaultRequestHeaders.Add("Authorization", HttpContext.Session.GetString("Token"));
var result = Client.PutAsync("bookFinders/" + id, byteContent).Result;
return(Json(result));
}
public int Create(BookFinderVM bookFinderVM)
{
using (var conn = new SqlConnection(_connectionStrings.Value))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@paramISBN", bookFinderVM.ISBN);
parameters.Add("@paramTitle", bookFinderVM.Title);
parameters.Add("@paramAuthor", bookFinderVM.Author);
parameters.Add("@paramPublisher", bookFinderVM.Publisher);
parameters.Add("@paramPublished", bookFinderVM.Published);
parameters.Add("@paramURL", bookFinderVM.URL);
var result = conn.Execute("SP_InsertDataBook", parameters, commandType: CommandType.StoredProcedure);
return(result);
}
}
public IActionResult Insert(IFormFile file, BookFinderVM bookFinderVM)
{
var path = "C:\\hasil_upload\\";
var filePath = Path.Combine(path, file.FileName);
using (var fileStream = new FileStream(filePath, FileMode.Create))
{
file.CopyToAsync(fileStream);
}
bookFinderVM.URL = filePath;
var myContent = JsonConvert.SerializeObject(bookFinderVM);
var buffer = System.Text.Encoding.UTF8.GetBytes(myContent);
var byteContent = new ByteArrayContent(buffer);
byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
Client.DefaultRequestHeaders.Add("Authorization", HttpContext.Session.GetString("Token"));
var result = Client.PostAsync("bookFinders", byteContent).Result;
return(RedirectToAction("Dashboard", "Users", new { area = "" }));
}
public async Task <BookFinderVM> Paging(string keyword, int pageNumber, int pageSize)
{
using (var conn = new SqlConnection(_connectionStrings.Value))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@pageSize", pageSize);
parameters.Add("@pageNumber", pageNumber);
parameters.Add("@paramKeyword", keyword);
parameters.Add("@length", dbType: DbType.Int32, direction: ParameterDirection.Output);
parameters.Add("@filterLength", dbType: DbType.Int32, direction: ParameterDirection.Output);
var result = new BookFinderVM();
result.data = await conn.QueryAsync <BookFinderVM>("SP_FilterData", parameters, commandType : CommandType.StoredProcedure);
int filterlength = parameters.Get <int>("@filterLength");
result.filterLength = filterlength;
int length = parameters.Get <int>("@length");
result.length = length;
return(result);
}
}
public async Task <BookFinderVM> cari(string Title, string Author, string Publisher, long ISBN, string keyword, int pageNumber, int pageSize)
{
using (var conn = new SqlConnection(_connectionStrings.Value))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@paramTitle", Title);
parameters.Add("@paramAuthor", Author);
parameters.Add("@paramPublisher", Publisher);
parameters.Add("@paramISBN", ISBN);
parameters.Add("@pageSize", pageSize);
parameters.Add("@pageNumber", pageNumber);
parameters.Add("@paramKeyword", keyword);
parameters.Add("@length", dbType: DbType.Int32, direction: ParameterDirection.Output);
parameters.Add("@filterLength", dbType: DbType.Int32, direction: ParameterDirection.Output);
var result = new BookFinderVM();
result.data = await conn.QueryAsync <BookFinderVM>("SP_Cari_Barang", parameters, commandType : CommandType.StoredProcedure);
int filterlength = parameters.Get <int>("@filterLength");
result.filterLength = filterlength;
int length = parameters.Get <int>("@length");
result.length = length;
return(result);
}
}
public int Update(int Id, BookFinderVM bookFinderVM)
{
try
{
using (var conn = new SqlConnection(_connectionStrings.Value))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@paramId", Id);
parameters.Add("@paramISBN", bookFinderVM.ISBN);
parameters.Add("@paramTitle", bookFinderVM.Title);
parameters.Add("@paramAuthor", bookFinderVM.Author);
parameters.Add("@paramPublisher", bookFinderVM.Publisher);
parameters.Add("@paramPublished", bookFinderVM.Published);
parameters.Add("@paramURL", bookFinderVM.URL);
var result = conn.Execute("SP_UpdateDataBook", parameters, commandType: CommandType.StoredProcedure);
return(result);
}
}
catch (Exception e) {
return(0);
}
}
public ActionResult Put(int Id, BookFinderVM bookFinderVM)
{
return(Ok(_bookFinderServices.Update(Id, bookFinderVM)));
}
public ActionResult Post(BookFinderVM bookFinderVM)
{
return(Ok(_bookFinderServices.Create(bookFinderVM)));
}
public int Update(int Id, BookFinderVM bookFinderVM)
{
return(_bookFinderRepository.Update(Id, bookFinderVM));
}
public int Create(BookFinderVM bookFinderVM)
{
return(_bookFinderRepository.Create(bookFinderVM));
}
