public ActionResult addBook_DB() { string bName = Request["bookname"]; string bAuthor = Request["author"]; if ((bName == "" && bAuthor == "") || (bName != "" && bAuthor == "") || (bName == "" && bAuthor != "")) { return(RedirectToAction("addBook")); } else { book b = new book(); b.bookName = bName; b.bookAuthor = bAuthor; b.bookEdition = Request["edition"]; b.bookCategory = Request["bookCategory"]; dc.books.InsertOnSubmit(b); dc.SubmitChanges(); return(RedirectToAction("displayAllBooks")); } }
public List <book> getAll(int size, int page) { try { String query = "SELECT book.id, name, shortdes,description,language,image,published,uppoint,downpoint,account.userName,account.displayName\n" + " FROM [book] inner join account account on book.createby=account.userName ORDER BY (uppoint-downpoint) desc \n" + " OFFSET (" + page + "*" + size + "-" + size + ") ROWS FETCH NEXT " + size + " ROWS ONLY"; string query2 = "SELECT book.id, name, shortdes,description,language,image,published,uppoint,downpoint,account.userName,account.displayName FROM [book] inner join account account on book.createby = account.userName ORDER BY (uppoint-downpoint) desc OFFSET (" + page + "*" + size + "-" + size + ") ROWS FETCH NEXT " + size + " ROWS ONLY"; DataTable dataTable = dataProvider.excuteQuery(query2); List <book> list = new List <book>(); for (int i = 0; i < dataTable.Rows.Count; i++) { account a = new account(); a.username = dataTable.Rows[i]["userName"].ToString(); a.fullname = dataTable.Rows[i]["displayName"].ToString(); book S = new book(); S.id = int.Parse(dataTable.Rows[i]["id"].ToString()); S.shortDes = dataTable.Rows[i]["shortdes"].ToString(); S.name = dataTable.Rows[i]["name"].ToString(); S.des = dataTable.Rows[i]["description"].ToString(); S.language = dataTable.Rows[i]["language"].ToString(); S.img = dataTable.Rows[i]["image"].ToString(); S.upPoint = Int32.Parse(dataTable.Rows[i]["uppoint"].ToString()); S.downPoint = Int32.Parse(dataTable.Rows[i]["downpoint"].ToString()); S.createdby = a; S.pulishedDate = DateTime.Parse(dataTable.Rows[i]["published"].ToString()); list.Add(S); } return(list); } catch (Exception ex) { Console.WriteLine("Paging" + ex.Message); } return(null); }
public ActionResult AddBooks(book book) { var any = db.books.SingleOrDefault(c => c.title == book.title && c.pub_date == book.pub_date && c.publisher == book.publisher); if (any != null) { ViewBag.ExistanceError = "This book already exists"; return(View("~/Views/Books/AddBook.cshtml")); } db.books.Add(book); db.SaveChanges(); var modelquery = db.books.Select(x => new Books { Title = x.title, Publisher = x.publisher, PublicationDate = x.pub_date, Id = x.id }).ToList(); return(View("~/Views/Books/BooksView.cshtml", modelquery)); }
public List <book> getbycid(int cid, int page, int size) { try { String query = "SELECT * FROM book inner join book_categories on book.id=book_categories.bookid\n" + "inner join account account on account.userName=book.createby where book_categories.categoryid='" + cid + "'\n" + "ORDER BY book.id OFFSET (" + page + "*" + size + "-" + size + ") ROWS FETCH NEXT " + size + " ROWS ONLY"; DataTable dataTable = dataProvider.excuteQuery(query); List <book> list = new List <book>(); for (int i = 0; i < dataTable.Rows.Count; i++) { account a = new account(); a.username = dataTable.Rows[i]["userName"].ToString(); a.fullname = dataTable.Rows[i]["displayName"].ToString(); book S = new book(); S.id = int.Parse(dataTable.Rows[i]["id"].ToString()); S.shortDes = dataTable.Rows[i]["shortdes"].ToString(); S.name = dataTable.Rows[i]["name"].ToString(); S.des = dataTable.Rows[i]["description"].ToString(); S.language = dataTable.Rows[i]["language"].ToString(); S.img = dataTable.Rows[i]["image"].ToString(); S.createdby = a; S.pulishedDate = DateTime.Parse(dataTable.Rows[i]["published"].ToString()); //S.point = Int32.Parse(dataTable.Rows[i]["point"].ToString()); list.Add(S); } return(list); } catch (Exception ex) { Console.WriteLine("Searching" + ex.Message); } return(null); }
public static bool savely(book ly) { SqlConnection conn = DB.createdb(); conn.Open(); try { //SqlCommand cmd = new SqlCommand("insert into book(username,sex,qq,email,face,adddate,body,ishidden,homepage) values(@username,@sex,@qq,@email,@face,@adddate,@body,@ishidden,@homepage)", conn); SqlCommand cmd = new SqlCommand("insert into book(username,sex,body,qq,email,face,adddate,ishidden,homepage) values(@username,@sex,@body,@qq,@email,@face,@adddate,@ishidden,@homepage)", conn); cmd.Parameters.Add(new SqlParameter("@username", SqlDbType.NVarChar, 20)); cmd.Parameters["@username"].Value = ly.username; cmd.Parameters.Add(new SqlParameter("@sex", SqlDbType.NVarChar, 4)); cmd.Parameters["@sex"].Value = ly.sex; cmd.Parameters.Add("@body", SqlDbType.NVarChar, 500); cmd.Parameters["@body"].Value = ly.body; cmd.Parameters.Add("@qq", SqlDbType.NVarChar, 10); cmd.Parameters["@qq"].Value = ly.qq; cmd.Parameters.Add("@email", SqlDbType.NVarChar, 20); cmd.Parameters["@email"].Value = ly.email; cmd.Parameters.Add("@face", SqlDbType.NVarChar, 10); cmd.Parameters["@face"].Value = ly.face; cmd.Parameters.Add("@adddate", SqlDbType.DateTime, 8); cmd.Parameters["@adddate"].Value = System.DateTime.Now.ToLongTimeString(); cmd.Parameters.Add("@ishidden", SqlDbType.Bit, 1); cmd.Parameters["@ishidden"].Value = ly.ishide; cmd.Parameters.Add("@homepage", SqlDbType.NVarChar, 50); cmd.Parameters["@homepage"].Value = ly.homepage; cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch { conn.Close(); return(false); } }
protected void ButtonClearList_Click(object sender, EventArgs e) { Session["Student_Id"] = null; BookIssues = new List <book_issue>(); NameObjectCollectionBase.KeysCollection Keys = Session.Keys; for (int i = 0; i < Keys.Count; i++) { string key = Keys[i]; if (key.Contains("BookIssues_")) { Session[key] = null; Book = null; } if (key.Contains("CurrentBook_")) { Session[key] = null; BookRecord = null; } if (key.Contains("CurrentBookRecord_")) { Session[key] = null; } } /*Session["BookIssues_"+CurrentStudent.id] = null; * Book = null; * Session["CurrentBook_"+CurrentStudent.id]= null; * BookRecord = null; * Session["CurrentBookRecord_"+CurrentStudent.id] = null;*/ TextBoxStudentID.Text = ""; PanelBookIssues.Controls.Clear(); PanelBookList.Controls.Clear(); InitPage(); ShowCurrentBook(""); LabelRecordList.Text = ""; }
public bool Delete(long idbook) { book book = GetByID(idbook); try { if (book != null) { book.updatedat = DateTime.Now; book.status = -1; db.SaveChanges(); return(true); } else { return(false); } } catch { return(false); } }
public void Update(book entity) { _iConnection.ExecuteScalar <book>( "UPDATE book SET author=@author, publisher=@publisher, url=@url, entrytype=@entrytype, address=@address, edition=@edition ,bibtexkey=@bibtexkey," + "month=@month, note=@note, series=@series," + "title=@title, volume=@volume, year=@year where ID = @ID", new { entity.series, entity.entrytype, entity.bibtexkey, entity.author, entity.publisher, entity.edition, entity.month, entity.note, entity.address, entity.url, entity.title, entity.volume, entity.year, entity.ID }); }
public IHttpActionResult Deletebook(int id) { book book = db.books.Find(id); var ab = db.authors_books.FirstOrDefault(x => x.author_id == id); while (ab != null) { db.authors_books.Remove(ab); db.SaveChanges(); ab = db.authors_books.FirstOrDefault(x => x.author_id == id); } if (book == null) { return(NotFound()); } db.books.Remove(book); db.SaveChanges(); return(Ok(book)); }
public ActionResult OnPostOffer(int id) { Book = bd.objectBook(id); carts.IdBook = id; carts.login = HttpContext.User.Identity.Name; carts.NameBook = Book.Name; carts.Author = Book.Author; carts.count = count; carts.priceBook = Book.price; carts.Photo = Book.PhotoPath; carts.FullPrice = Book.price * count; carts.status = 0; carts.ID = Guid.NewGuid().ToString(); Book.count -= count; bd.update(Book); CR.Offer(carts); bd.Save(); CR.save(); return(RedirectToPage("ViewBooks")); }
public ActionResult delete(int id) { var books = new List <book>(); books.Add(new book(1, "cuon sach thu 1", "tacgia1", "/Content/images/IMG_0486.JPG")); books.Add(new book(2, "cuon sach thu 2", "tacgia2", "/Content/images/IMG_0487.JPG")); books.Add(new book(3, "cuon sach thu 3", "tacgia2", "/Content/images/IMG_0488.JPG")); book b = new book(); foreach (book i in books) { if (i.Id == id) { b = i; break; } } if (b == null) { return(HttpNotFound()); } return(View(b)); }
private static BookModel BookModelFromEntity(book book) { BookModel bm = new BookModel { author = new PersonModel { age = book.author.birth_year, name = book.author.name, sex = "male" }, name = book.name, description = book.description, isbn = book.isbn, jenres = book.jenres.Split(',').Select(s => (BookJenre)Enum.Parse(typeof(BookJenre), s)).ToList(), depositCost = book.depositCost, rentCost = book.rentCost, year = book.year, pages = book.pages, dbId = book.idBook }; return(bm); }
private void btn_Add_Click(object sender, EventArgs e) { try { Int32 pagecount = Int32.Parse(tb_Pagecount.Text); Int32 year = Int32.Parse(tb_Year.Text); book b = new book(); b.title = tb_Title.Text; b.author = tb_Author.Text; b.isbn = tb_ISBN.Text; b.publisher = tb_Publisher.Text; b.pages = pagecount; b.year = year; b.id = b.author.Substring(0, 2) + b.title.Substring(0, 3); bmc.addBook(b); Close(); } catch (System.Exception ex) { MessageBox.Show("Could not add book: \n" + ex.ToString()); } }
public HttpResponseMessage Post([FromBody] book bookModel) { if (!ModelState.IsValid) { var resposnse = Request.CreateResponse(HttpStatusCode.BadRequest); resposnse.Content = new StringContent(JsonConvert.SerializeObject(ModelState), Encoding.UTF8, "application/json"); return(resposnse); } else { //Use commented code to insert value explicitely into the identity column //var p = dbContext.books.OrderByDescending(x => x.bookId).FirstOrDefault(); //bookModel.bookId = p == null ? 0 : p.bookId + 1; //dbContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.books ON"); bookModel.readbook = bookModel.readbook == null || bookModel.readbook == "" ? "No" : bookModel.readbook; dbContext.books.Add(bookModel); dbContext.SaveChanges(); // dbContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.books OFF"); var response = Request.CreateResponse(HttpStatusCode.OK); response.Content = new StringContent(JsonConvert.SerializeObject(bookModel), Encoding.UTF8, "application/json"); return(response); } }
public ActionResult editbook(int id) { var books = new List <book>(); books.Add(new book(1, "cuon sach thu 1", "tacgia1", "/Content/images/IMG_0486.JPG")); books.Add(new book(2, "cuon sach thu 2", "tacgia2", "/Content/images/IMG_0487.JPG")); books.Add(new book(3, "cuon sach thu 3", "tacgia3", "/Content/images/IMG_0488.JPG")); book book = new book(); foreach (book b in books) { if (b.Id == id) { book = b; break; } if (book == null) { return(HttpNotFound()); } } return(View(book)); }
protected void addly_Click(object sender, EventArgs e) { book binbin = new book(); binbin.username = Server.HtmlEncode(this.username.Text); binbin.email = this.email.Text; binbin.qq = this.qq.Text; binbin.homepage = this.homepage.Text; if (this.Radboy.Checked) { binbin.sex = "men"; binbin.face = "boy"; } else { binbin.sex = "female"; binbin.face = "gril"; } binbin.body = this.lybody.Text; if (this.ishde.Checked) { binbin.ishide = true; } else { binbin.ishide = false; } Label1.Text = binbin.ishide.ToString(); if (saveinfo.savely(binbin)) { Response.Redirect("lyb.aspx"); } else { Response.Write("<script>alert('Message failed, server error!');location.herf='lyb.aspx'"); } }
//Add private void buttonAdd_Click(object sender, EventArgs e) { if (ValidateEmptyTextBox(1)) { try { projectEntities project = new projectEntities(); book book = new book(); book.ISBN = textBoxISBN.Text; book.Title = textBoxTitle.Text; book.UnitPrice = Convert.ToDouble(textBoxPrice.Text); book.YearPublished = publishYear.Value.Date; book.QOH = Convert.ToInt32(textBoxQoh.Text); book.AuthorID = Convert.ToInt32(textBoxAuthorID.Text); book.PublishID = Convert.ToInt32(textBoxPublishID.Text); book.CategoryID = Convert.ToInt32(textBoxCategoryID.Text); project.books.Add(book); project.SaveChanges(); this.DisplayBookInformation(); MessageBox.Show("Recored Inserted.."); this.ClearTextBox(); } catch (Exception ex) { MessageBox.Show("Recored Is Not Inserted..\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); this.ClearTextBox(); } } else { MessageBox.Show("Please Enter Values. ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static void Main() { book[] books = new book[10000]; int count = 0; bool finished = false; do { switch (ShowMenuAndGetOption()) { case "1": Add(ref books, ref count); break; case "2": ShowAll(books, count); break; case "3": Search(books, count); break; case "0": finished = true; break; default: WarnAboutWrongOption(); break; } }while (!finished); Console.WriteLine("Bye!"); }
protected void addly_Click(object sender, EventArgs e) { book binbin = new book(); binbin.username = Server.HtmlEncode(this.username.Text); binbin.homepage = this.homepage.Text; if (this.Radboy.Checked) { binbin.sex = "男"; binbin.face = "boy"; } else { binbin.sex = "女"; binbin.face = "gril"; } binbin.body = Request.Form["content"]; if (this.ishde.Checked) { binbin.ishide = true; } else { binbin.ishide = false; } Label1.Text = binbin.ishide.ToString(); if (saveinfo.savely(binbin)) { Response.Redirect("lybb.aspx"); } else { Response.Write("<script>alert('留言失败,服务器错误!');location.herf='lyb.aspx'"); } }
public override object Update(object Obj) { Refresh(); book book = (book)Obj; book DBBook = (book)GetById(book.id); if (DBBook == null) { return(null); } book CleanBook = (book)ObjectUtil.GetObjectValues(new string[] { "id", "title", "page", "review", "category_id", "publisher_id", "isbn", "author_id" }, book); if (CleanBook.page == null) { CleanBook.page = 0; } // dbEntities.Entry(book).CurrentValues. dbEntities.Entry(DBBook).CurrentValues.SetValues(CleanBook); dbEntities.SaveChanges(); return(book); }
public ActionResult choose(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } book book = db.books.Find(id); book tempbook = new book { ID = db2.books.Select(e => e.ID).Max() + 1, title = book.title, author = book.author, press = book.press, lenderID = book.lenderID, lendername = book.lendername, lendercontact = book.lendercontact }; db2.books.Add(tempbook); db2.SaveChanges(); db.books.Remove(book); db.SaveChanges(); return(RedirectToAction("Index")); }
public string Update(int id, [FromBody] book i) { var b = (from t in db.books where t.bid == id select t).SingleOrDefault(); if (b == null) { throw new Exception("Book Id Invalid"); } else { b.bname = i.bname; b.bgener = i.bgener; b.bprice = i.bprice; var res = db.SaveChanges(); if (res > 0) { return("Data Uploaded"); } } return("Error Updating Data"); }
// POST api/apiBook public IHttpActionResult Post(book book) { if (book == null || string.IsNullOrWhiteSpace(book.title) || string.IsNullOrWhiteSpace(book.description) || string.IsNullOrWhiteSpace(book.publication_date.ToString()) || string.IsNullOrWhiteSpace(book.isbn)) { return(Json(new { bookCreationSuccess = false, errorMessage = "Braki w następujących polach: tytuł, opis, data publikacji, isbn" })); } var credentials = Request.Headers.FirstOrDefault(x => x.Key.Equals("Authorization")).Value.ToList()[0]; if (credentials != null) { var loggedAuthor = credentials.Split('=')[0]; var token = credentials.Split('=')[1]; var authorFromToken = JWTHelper.ValidateToken(token); var groupId = db.author.FirstOrDefault(x => x.login == authorFromToken).group_id; List <setting> settings = db.group.FirstOrDefault(x => x.group_id == groupId).group_setting.Select(x => x.setting).ToList(); if (loggedAuthor == authorFromToken && settings.Any(x => x.name == "book_create")) { book.status = StatusesEnum.ACTIVE.ToString(); var newBook = db.book.Add(book); var log = db.log.Add(new log() { book_id = book.book_id, author_id = book.author_id, event_name = LogTypesEnum.CREATE.ToString(), event_date = DateTime.Now }); db.SaveChanges(); return(Json(new { bookCreationSuccess = true })); } } return(Json(new { bookCreationSuccess = false, errorMessage = "Wystąpił błąd. Przepraszamy za kłopoty techniczne" })); }
public ActionResult Add(book model) { try { DbModel db = new DbModel(); if (ModelState.IsValid) { model.IsActive = 1; db.book.Add(model); db.SaveChanges(); Request.Flash("success", "Add Success"); return(Redirect("~/book")); } ViewBag.IdCategory = new SelectList(db.category.Where(d => d.IsActive == 1), "IdCategory", "NameCategory"); return(View(model)); } catch (Exception ex) { Request.Flash("error", ex.Message); return(Redirect("~/book")); } }
public ActionResult Create([Bind(Include = "book_id,title,edition,price,publication_id,author_id,subcategory_id,pages,description,rate,availabilty,tags,uploadedImage,uploadedFile")] book book) { if (ModelState.IsValid) { book.add_date = DateTime.Now.ToString(); // Data var userName = User.Identity.GetUserName(); book.member_id = db.users.Where(x => x.UserName == userName).Select(x => x.Id).FirstOrDefault(); // Uplaod Photo ======================================================================================================= string ImageName = Path.GetFileNameWithoutExtension(book.uploadedImage.FileName); // get name string ImageExtension = Path.GetExtension(book.uploadedImage.FileName); // get extension ImageName = ImageName + '_' + DateTime.Now.ToString("yymmssfff") + ImageExtension; // Not To Repeat book.photo = "~/Uploads/Photos/books/" + ImageName; // Save To DB ImageName = Path.Combine(Server.MapPath("~/Uploads/Photos/books/"), ImageName); // Combine To Local Folder book.uploadedImage.SaveAs(ImageName); // Move it // Uplaod File ======================================================================================================= string FileName = Path.GetFileNameWithoutExtension(book.uploadedFile.FileName); // get name string FileExtension = Path.GetExtension(book.uploadedFile.FileName); // get extension FileName = FileName + '_' + DateTime.Now.ToString("yymmssfff") + FileExtension; // Not To Repeat book.File = "~/Uploads/Books/" + FileName; // Save To DB FileName = Path.Combine(Server.MapPath("~/Uploads/Books/"), FileName); // Combine To Local Folder book.uploadedFile.SaveAs(FileName); // Move it db.books.Add(book); db.SaveChanges(); TempData["Success"] = "Created Successfully!"; return(RedirectToAction("Index")); } ViewBag.author_id = new SelectList(db.authors, "author_id", "first_name", book.author_id); ViewBag.publication_id = new SelectList(db.publications, "publication_id", "name", book.publication_id); ViewBag.subcategory_id = new SelectList(db.subcategories, "subcategory_id", "subcategory_name", book.subcategory_id); ViewBag.member_id = new SelectList(db.users, "Id", "first_name", book.member_id); return(View(book)); }
private void btn_save_Click(object sender, EventArgs e) { // reset label error trước khi validate foreach (string n in arrLabelNameError) { this.Controls.Find(n, true)[0].Text = ""; } // Tạo đối tượng book book b = new book(); b.BookCode = Functions.randomString(8); // Mã sách sẽ được tạo ngẫu nhiên bằng chuỗi với độ dài 8 b.BookName = txt_bookName.Text.Replace("'", "''"); b.Price = 0; if (!string.IsNullOrEmpty(txt_price.Text)) { try { b.Price = Math.Abs(Convert.ToInt32(txt_price.Text)); } catch { lbl_error_price.Text = "Giá sách phải là số nguyên dương"; } } b.Category = cbx_category.Text.Replace("'", "''"); b.Author = txt_author.Text.Replace("'", "''"); b.PublishingBy = txt_publishingBy.Text.Replace("'", "''"); // Để kiểm tra các dữ liệu phù hợp thiết lập bởi Attribute bên Model không, thì dùng lớp ValidationContext ValidationContext context = new ValidationContext(b); // results - lưu danh sách ValidationResult, kết quả kiểm tra var result = new List <ValidationResult>(); // thực hiện kiểm tra dữ liệu bool valid = Validator.TryValidateObject(b, context, result, true); if (valid == false) { foreach (ValidationResult r in result) { // Tạo controlName bằng string string controlName = "lbl_error_" + r.MemberNames.First(); // Tìm control thông qua key string và gán messError và thay đổi màu cho label error this.Controls.Find(controlName, true)[0].Text = r.ErrorMessage; this.Controls.Find(controlName, true)[0].ForeColor = Color.Red; } } else { // Không tồn tại mã sách thì là thêm mới if (string.IsNullOrEmpty(this.bookCode)) { if (busBook.addBook(b) == true) { MessageBox.Show("Thêm mới sách thành công", "Thành Công", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("Thêm mới sách thất bại", "Thất Bại", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { b.BookCode = this.bookCode; if (busBook.updateBook(b) == true) { MessageBox.Show("Cập nhật sách thành công", "Thành Công", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("Cập nhật sách thất bại", "Thất Bại", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
public int insert(book b) { return(this.data.insert(b)); }
public DataTable booking(book ocr) { DataTable dt = new DataTable(); LogTraceWriter traceWriter = new LogTraceWriter(); SqlConnection conn = new SqlConnection(); StringBuilder str = new StringBuilder(); try { traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "booking...."); str.Append("Username:"******","); str.Append("PhoneNumber:" + ocr.PhoneNumber + ","); str.Append("EmailId:" + ocr.EmailId + ","); str.Append("src:" + ocr.src + ","); str.Append("dest:" + ocr.dest + ","); str.Append("Gender:" + ocr.Gender + ","); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString()); conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "prebooking"; cmd.Connection = conn; SqlParameter f = new SqlParameter("@flag", SqlDbType.VarChar); f.Value = ocr.flag; cmd.Parameters.Add(f); SqlParameter q = new SqlParameter("@Id", SqlDbType.Int); q.Value = ocr.Id; cmd.Parameters.Add(q); SqlParameter q1 = new SqlParameter("@Username", SqlDbType.VarChar, 50); q1.Value = ocr.Username; cmd.Parameters.Add(q1); SqlParameter c = new SqlParameter("@PhoneNumber", SqlDbType.VarChar, 20); c.Value = ocr.PhoneNumber; cmd.Parameters.Add(c); SqlParameter e = new SqlParameter("@EmailId", SqlDbType.VarChar, 50); e.Value = ocr.EmailId; cmd.Parameters.Add(e); SqlParameter b = new SqlParameter("@src", SqlDbType.VarChar, 50); b.Value = ocr.src; cmd.Parameters.Add(b); SqlParameter p = new SqlParameter("@dest", SqlDbType.VarChar, 50); p.Value = ocr.dest; cmd.Parameters.Add(p); SqlParameter m = new SqlParameter("@Gender", SqlDbType.VarChar, 50); m.Value = ocr.Gender; cmd.Parameters.Add(m); SqlParameter t = new SqlParameter("@Age", SqlDbType.Int); t.Value = ocr.Age; cmd.Parameters.Add(t); SqlParameter e2 = new SqlParameter("@Blocked", SqlDbType.VarChar, 50); e2.Value = ocr.Blocked; cmd.Parameters.Add(e2); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "booking successful...."); } catch (Exception ex) { traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "booking...." + ex.Message.ToString()); //throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); dt.Columns.Add("Code"); dt.Columns.Add("description"); DataRow dr = dt.NewRow(); dr[0] = "ERR001"; dr[1] = ex.Message; dt.Rows.Add(dr); } finally { conn.Close(); conn.Dispose(); SqlConnection.ClearPool(conn); } return(dt); }
public int update(book b) { return(this.data.update(b)); }
public int CountBook(int id) { Books = BR.objectBook(id); return(Books.count); }