protected void btnRegist_Click(object sender, EventArgs e)
{
if (this.isbn.Text.Trim().Length == 0)
{
return;
}
//DB登録用値取得
var isbn = this.isbn.Text;
var location = this.Location.Text;
PAAPI api = new PAAPI();
string message;
string status;
try
{
var url = api.CreateRequestUrl(isbn);
var response = api.GetResponse(url);
var booktag = api.ParseResponse(response);
using (BookshelfDSDataContext db = new BookshelfDSDataContext())
{
var existsRecord = db.Books.FirstOrDefault(s => s.ISBN == booktag.ISBN);
if (existsRecord == null)
{
status = "新規：";
booktag.Location = location;
db.Books.InsertOnSubmit(booktag);
}
else
{
status = "更新：";
//変更しそうなものだけ更新
existsRecord.ListPrice = booktag.ListPrice;
existsRecord.MediumImageURL = booktag.MediumImageURL;
existsRecord.TinyImageURL = booktag.TinyImageURL;
existsRecord.DetailPageURL = booktag.DetailPageURL;
existsRecord.Location = location;
}
db.SubmitChanges();
}
message = status + booktag.Title;
}
catch (ArgumentException ae)
{
this.isbn.Text = "";
message = "◆◇◆◇エラー◆◇◆◇" + ae.Message;
}
catch (HttpParseException hpe)
{
message = "◆◇◆◇エラー◆◇◆◇" + hpe.Message;
}
catch (SqlException se)
{
message = "◆◇◆◇エラー◆◇◆◇" + se.Message;
}
this.isbn.Text = "";
this.LabelMessage.Text += message + "</br>";
}
/// <summary>
/// 書籍削除イベント
/// このメソッドは未使用、GridViewでOnRowCommandイベントを発生させたときに利用する
/// データの削除は、CommandName="Delete" と、DataKeyNames="ISBN" の機能で実現している。
/// </summary>
protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)
{
var isbn = e.CommandArgument.ToString();
using (BookshelfDSDataContext db = new BookshelfDSDataContext())
{
var existsRecord = db.Books.FirstOrDefault(s => s.ISBN == isbn);
if (existsRecord != null)
{
db.Books.DeleteOnSubmit(existsRecord);
db.SubmitChanges();
}
}
this.GridView1.DataBind();
}
