public void DisplayData(string bookID = "-1")
{
try
{
ClearControl();
//Master Data
BooksMasterHandler objHandler = new BooksMasterHandler();
BooksMaster obj = objHandler.GetBooksMasterDetails(bookID);
if (obj != null)
{
SetBook(obj);
ControlStatus(true);
}
else
{
MessageBox.Show("No record exist");
}
}
catch (Exception ex)
{
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n" + ex.Message);
}
}
public BooksMaster GetBooksMasterDetails(String bookID)
{
BooksMaster obj = null;
string commandText = OleDBHelper.GetQueryText("BooksMaster_SelectID", QueryType.Procedures);
OleDbParameter[] parameters = new OleDbParameter[]
{
new OleDbParameter("@BookID", bookID)
};
using (DataTable table = OleDBHelper.ExecuteParamerizedSelectCommand(commandText, CommandType.Text, parameters))
{
//check if any record exist or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of employees
obj = new BooksMaster();
obj.BookID = Convert.ToString(table.Rows[0]["BookID"]);
obj.ISBN = Convert.ToString(table.Rows[0]["ISBN"]);
obj.Title = Convert.ToString(table.Rows[0]["Title"]);
obj.Subject = Convert.ToString(table.Rows[0]["Subject"]);
obj.Author = Convert.ToString(table.Rows[0]["Author"]);
obj.Publication = Convert.ToString(table.Rows[0]["Publication"]);
obj.EditionNo = Convert.ToInt32(table.Rows[0]["EditionNo"]);
obj.EditionYear = Convert.ToInt32(table.Rows[0]["EditionYear"]);
obj.Price = Convert.ToInt32(table.Rows[0]["Price"]);
}
}
return(obj);
}
private void Save()
{
bool result = false;
BooksMaster book = GetBook();
BooksMasterHandler handler = new BooksMasterHandler();
if (AddMode)
{
result = handler.AddNewBooksMaster(book);
if (result)
{
result = GlobalFunction.UpdateUniqueCode("BooksMaster");
}
}
else if (EditMode)
{
result = handler.UpdateBooksMaster(book);
}
if (result == true)
{
MessageBox.Show("New Account created");
}
else
{
MessageBox.Show("Errror Occurs!");
}
}
private void SetBook(BooksMaster obj)
{
txtBookId.Text = obj.BookID;
txtISBN.Text = obj.ISBN;
txtTitle.Text = obj.Title;
txtSubject.Text = obj.Subject;
txtAuthorName.Text = obj.Author;
txtPublication.Text = obj.Publication;
txtEditionNo.Text = Convert.ToString(obj.EditionNo);
txtEditionYear.Text = Convert.ToString(obj.EditionYear);
txtPrice.Text = Convert.ToString(obj.Price);
}
private void AddItemToGrid(BooksMaster item)
{
int i = dgvMain.RowCount;
dgvMain.RowCount = i + 1;
dgvMain.Rows[i].Cells[SNo].Value = i + 1;
dgvMain.Rows[i].Cells[BookID].Value = item.BookID;
dgvMain.Rows[i].Cells[Subject].Value = item.Subject;
dgvMain.Rows[i].Cells[Author].Value = item.Author;
dgvMain.Rows[i].Cells[EditionYear].Value = item.EditionYear;
dgvMain.Rows[i].Cells[EditionNo].Value = item.EditionNo;
}
public List <BooksMaster> SearchBooksMasterList(string searchText)
{
searchText = "%" + searchText + "%";
List <BooksMaster> list = null;
string commandText = OleDBHelper.GetQueryText("Search_BooksMaster", QueryType.Procedures);
OleDbParameter[] parameters = new OleDbParameter[]
{
new OleDbParameter("@BookID", searchText),
new OleDbParameter("@ISBN", searchText),
new OleDbParameter("@Title]", searchText),
new OleDbParameter("@Subject", searchText),
new OleDbParameter("@Author", searchText),
new OleDbParameter("@Publication", searchText)
//new OleDbParameter("@EditionNo", searchText),
//new OleDbParameter("@EditionYear", searchText)
//new OleDbParameter("@Price", book.Price),
};
using (DataTable table = OleDBHelper.ExecuteParamerizedSelectCommand(commandText, CommandType.Text, parameters))
{
//check if any record exist or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of employees
list = new List <BooksMaster>();
//Now lets populate the employee details into the list of employees
foreach (DataRow row in table.Rows)
{
BooksMaster obj = new BooksMaster();
obj.BookID = Convert.ToString(row["BookID"]);
obj.ISBN = Convert.ToString(row["ISBN"]);
obj.Title = Convert.ToString(row["Title"]);
obj.Subject = Convert.ToString(row["Subject"]);
obj.Author = Convert.ToString(row["Author"]);
obj.Publication = Convert.ToString(row["Publication"]);
obj.EditionNo = Convert.ToInt32(row["EditionNo"]);
obj.EditionYear = Convert.ToInt32(row["EditionYear"]);
obj.Price = Convert.ToInt32(row["Price"]);
list.Add(obj);
}
}
}
return(list);
}
private BooksMaster GetBook()
{
BooksMaster book = new BooksMaster();
book.BookID = txtBookId.Text;
book.ISBN = txtISBN.Text;
book.Title = txtTitle.Text;
book.Subject = txtSubject.Text;
book.Author = txtAuthorName.Text;
book.Publication = txtPublication.Text;
book.EditionNo = Convert.ToInt32(txtEditionNo.Text);
book.EditionYear = Convert.ToInt32(txtEditionYear.Text);
book.Price = Convert.ToInt32(txtPrice.Text);
return(book);
}
private void cmdAddItem_Click(object sender, EventArgs e)
{
ProcessInterface();
if (AddMode || EditMode)
{
BooksMasterHandler handler = new BooksMasterHandler();
if (_bookID != "")
{
bookMasterItem = handler.GetBooksMasterDetails(_bookID);
AddItemToGrid(bookMasterItem);
}
//CalculateTotalAmount();
}
}
public bool AddNewBooksMaster(BooksMaster book)
{
OleDbParameter[] parameters = new OleDbParameter[]
{
new OleDbParameter("@BookID", book.BookID),
new OleDbParameter("@ISBN", book.ISBN),
new OleDbParameter("@Title", book.Title),
new OleDbParameter("@Title", book.Subject),
new OleDbParameter("@Author", book.Author),
new OleDbParameter("@Publication", book.Publication),
new OleDbParameter("@EditionNo", book.EditionNo),
new OleDbParameter("@EditionYear", book.EditionYear),
new OleDbParameter("@Price", book.Price),
new OleDbParameter("@CreatedOn", GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now))
};
string commandText = OleDBHelper.GetQueryText("BooksMaster_Insert", QueryType.Procedures);
return(OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters));
}
private void Save()
{
bool result = false;
BooksMaster book = GetBook();
BooksMasterHandler handler = new BooksMasterHandler();
if (AddMode)
{
result = handler.AddNewBooksMaster(book);
if (result)
{
result = GlobalFunction.UpdateUniqueCode("BooksMaster");
}
}
else if (EditMode)
{
result = handler.UpdateBooksMaster(book);
}
if (result == true)
{
if (AddMode)
{
MessageBox.Show("New Record added successfully");
}
else
{
MessageBox.Show("Record is updated successfully");
}
ControlStatus(true);
}
else
{
MessageBox.Show("Errror Occurs!");
}
}
private List <BooksTransactionOutDetails> GetTransactionInDetailsOutiterface()
{
List <BooksTransactionOutDetails> objTrasList = new List <BooksTransactionOutDetails>();
int rowCount = dgvMain.RowCount;
BooksTransactionOutDetails obj;
BooksMaster objbookMaster;
for (int rowIndex = 0; rowIndex < rowCount; rowIndex++)
{
obj = new BooksTransactionOutDetails();
obj.TransactionID = txtTranID.Text;
obj.Unit = Convert.ToInt32(dgvMain.Rows[rowIndex].Cells[Unit].Value);
objbookMaster = new BooksMaster();
objbookMaster.BookID = Convert.ToString(dgvMain.Rows[rowIndex].Cells[BookID].Value);
obj.BookMaster = objbookMaster;
objTrasList.Add(obj);
}
return(objTrasList);
}
public List <BooksMaster> GetBooksMasterList()
{
List <BooksMaster> list = null;
string commandText = OleDBHelper.GetQueryText("BooksMaster_SelectAll", QueryType.Views);
using (DataTable table = OleDBHelper.ExecuteSelectCommand(commandText, CommandType.Text))
{
//check if any record exist or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of employees
list = new List <BooksMaster>();
//Now lets populate the employee details into the list of employees
foreach (DataRow row in table.Rows)
{
BooksMaster obj = new BooksMaster();
obj.BookID = Convert.ToString(row["BookID"]);
obj.ISBN = Convert.ToString(row["ISBN"]);
obj.Title = Convert.ToString(row["Title"]);
obj.Subject = Convert.ToString(row["Subject"]);
obj.Author = Convert.ToString(row["Author"]);
obj.Publication = Convert.ToString(row["Publication"]);
obj.EditionNo = Convert.ToInt32(row["EditionNo"]);
obj.EditionYear = Convert.ToInt32(row["EditionYear"]);
obj.Price = Convert.ToInt32(row["Price"]);
list.Add(obj);
}
}
}
return(list);
}
public BooksMaster GetBooksMasterDetails(String bookID)
{
BooksMaster books = null;
return(books);
}
// Same can be used for deactive user
public bool DeleteBooksMaster(BooksMaster book)
{
return(true);
}
public bool UpdateBooksMaster(BooksMaster book)
{
return(true);
}
