public string GetGenreIdByName(string Genre)
{
Console.WriteLine("etthi");
string GenreId = "";
Dictionary <string, object> par = new Dictionary <string, object>(1);
par.Add("Genre", Genre);
DataTable lcResult =
ClsDBConnection.GetDataTable("SELECT * FROM tbl_genre WHERE GenreName = @Genre", par);
List <clsGenre1> lcGenre = new List <clsGenre1>();
if (lcResult.Rows.Count > 0)
{
foreach (DataRow dr in lcResult.Rows)
{
lcGenre.Add(new clsGenre1
{
Id = (int)dr[0],
Name = (string)dr[1],
Desc = (string)dr[2]
});
}
Console.WriteLine(GenreId);
GenreId = lcGenre[0].ToString();
return(GenreId);
}
else
{
return(null);
}
}
public List <clsBook> GetBookListByGenreId(string Genre)
{
Console.WriteLine("Gen {0}", Genre);
Dictionary <string, object> par = new Dictionary <string, object>(1);
par.Add("GenreName", Genre);
DataTable lcGenreId = ClsDBConnection.GetDataTable("SELECT GenreId FROM tbl_genre where GenreName=@GenreName", par);
Console.WriteLine(lcGenreId.Rows[0]["GenreId"]);
par.Add("Id", lcGenreId.Rows[0]["GenreId"]);
DataTable lcResult = ClsDBConnection.GetDataTable("SELECT BookName,BooksLeft,BookDesc FROM tbl_book where ct_id=@Id", par);
List <clsBook> lcBookList = new List <clsBook>();
foreach (DataRow dr in lcResult.Rows)
{
lcBookList.Add(new clsBook
{
BookName = (string)dr[0],
BooksLeft = (int)dr[1],
BookDesc = (string)dr[2]
});
}
return(lcBookList);
}
public List <clsGenre> GetGenreList()
{
DataTable lcResult = ClsDBConnection.GetDataTable("SELECT GenreId,GenreName,Description FROM tbl_genre", null);
List <clsGenre> lcGenre = new List <clsGenre>();
foreach (DataRow dr in lcResult.Rows)
{
lcGenre.Add(new clsGenre
{
Id = (int)dr[0],
Name = (string)dr[1],
Desc = (string)dr[2]
});
}
return(lcGenre);
}
public string GetBookNameByName(string BookName)
{
string Result = "";
Dictionary <string, object> par = new Dictionary <string, object>(1);
par.Add("BookName", BookName);
DataTable lcResult =
ClsDBConnection.GetDataTable("SELECT * FROM tbl_book WHERE BookName = @BookName", par);
if (lcResult.Rows.Count > 0)
{
Result = "1";
}
else
{
Result = "0";
}
return(Result);
}
public clsBook GetBookDetailsById(string BookId)
{
Console.WriteLine("ssss");
Dictionary <string, object> par = new Dictionary <string, object>(1);
par.Add("BookId", BookId);
DataTable dtBooks = ClsDBConnection.GetDataTable("SELECT * FROM tbl_book where BookId=@BookId", par);
//List<clsBook> lcBookList = new List<clsBook>();
//lcBookList.Add(new clsBook
//{
clsBook _Book = new clsBook();
_Book.BookId = (int)dtBooks.Rows[0][0];
_Book.BookName = (string)dtBooks.Rows[0][1];
_Book.AuthorName = (string)dtBooks.Rows[0][2];
_Book.ISBN = (int)dtBooks.Rows[0][3];
_Book.BookDesc = (string)dtBooks.Rows[0][4];
_Book.Price = (decimal)dtBooks.Rows[0][5];
_Book.BooksLeft = (int)dtBooks.Rows[0][6];
_Book.LastUpdatedDate = (dtBooks.Rows[0][7]).ToString();
_Book.Condition = (string)dtBooks.Rows[0][8];
_Book.GenreId = (int)dtBooks.Rows[0][9];
_Book.Antique = Convert.ToBoolean(dtBooks.Rows[0][10]);
_Book.Package = (string)dtBooks.Rows[0][11];
_Book.Weight = (decimal)dtBooks.Rows[0][12];
//});
return(_Book);
// return new clsBook()
// {
// BookId = (int)dtBooks.Rows[0][0];
//}
}
public string DeleteBook(string BookId)
{
try
{
Dictionary <string, object> par = new Dictionary <string, object>(11);
par.Add("BookId", BookId);
int lcRecCount = ClsDBConnection.Execute("DELETE FROM tbl_book WHERE BookId=@BookId", par);
if (lcRecCount == 1)
{
return("One product Deleted");
}
else
{
return("Error Unexpected product delete count: " + lcRecCount);
}
}
catch (Exception ex)
{
return("Error: " + ex.GetBaseException().Message);
}
}
public string GetGenreNameById(string GenreId)
{
string Genre = "";
Dictionary <string, object> par = new Dictionary <string, object>(1);
par.Add("GenreId", GenreId);
DataTable lcResult =
ClsDBConnection.GetDataTable("SELECT GenreName FROM tbl_genre WHERE GenreId = @GenreId", par);
if (lcResult.Rows.Count > 0)
{
Genre = lcResult.Rows[0]["GenreName"].ToString();
Console.WriteLine("Genre: {0}", Genre);
return(Genre);
}
else
{
return(null);
}
}
public string PostBook(clsBook prBook)
{
Console.WriteLine("fgfgfgf {0}", prBook.Package);
try
{
Dictionary <string, object> par = new Dictionary <string, object>(11);
par.Add("BookName", prBook.BookName);
par.Add("AuthorName", prBook.AuthorName);
par.Add("ISBN", prBook.ISBN);
par.Add("BookDesc", prBook.BookDesc);
par.Add("Price", prBook.Price.ToString());
par.Add("BooksLeft", prBook.BooksLeft.ToString());
par.Add("LastUpdatedDate", prBook.LastUpdatedDate.ToString());
par.Add("BookCondition", prBook.Condition);
par.Add("GenreId", prBook.GenreId.ToString());
par.Add("Antique", prBook.Antique.ToString());
par.Add("Package", prBook.Package);
par.Add("Weight", prBook.Weight.ToString());
Console.WriteLine("fgfgfgf tertre {0}", prBook.Package);
int lcRecCount = ClsDBConnection.Execute("INSERT INTO tbl_book " +
"(BookName, AuthorName, ISBN, BookDesc, Price, BooksLeft, LastUpdtDate, BookCondition, ct_id, Antique, Package, Weight) " +
"VALUES (@BookName, @AuthorName, @ISBN, @BookDesc, @Price, @BooksLeft, @LastUpdatedDate, @BookCondition, @GenreId, @Antique, @Package, @Weight)", par);
if (lcRecCount == 1)
{
return("One Book inserted");
}
else
{
return("Error Unexpected Book insert count: " + lcRecCount);
}
}
catch (Exception ex)
{
return("Error: " + ex.GetBaseException().Message);
}
}
public string UpdateBook(clsBook prBook)
{
try
{
Dictionary <string, object> par = new Dictionary <string, object>(11);
par.Add("BookId", prBook.BookId.ToString());
par.Add("BookName", prBook.BookName);
par.Add("AuthorName", prBook.AuthorName);
par.Add("ISBN", prBook.ISBN);
par.Add("BookDesc", prBook.BookDesc);
par.Add("Price", prBook.Price.ToString());
par.Add("BooksLeft", prBook.BooksLeft.ToString());
par.Add("LastUpdatedDate", prBook.LastUpdatedDate.ToString());
par.Add("BookCondition", prBook.Condition);
par.Add("GenreId", prBook.GenreId.ToString());
par.Add("Antique", prBook.Antique.ToString());
par.Add("Package", prBook.Package);
par.Add("Weight", prBook.Weight.ToString());
int lcRecCount = ClsDBConnection.Execute(
"UPDATE tbl_book SET BookName = @BookName, AuthorName = @AuthorName, ISBN = @ISBN, BookDesc = @BookDesc, Price = @Price, BooksLeft = @BooksLeft, LastUpdtDate = @LastUpdtDate, " +
"BookCondition = @BookCondition, ct_id = @GenreId, Antique = @Antique, Package = @Package, Weight = @Weight WHERE BookId = @BookId", par);
if (lcRecCount == 1)
{
return("One product updated");
}
else
{
return("Error Unexpected product update count: " + lcRecCount);
}
}
catch (Exception ex)
{
return("Error: " + ex.GetBaseException().Message);
}
}
