private void FillListView()
{
List <BooksMaster> list = new List <BooksMaster>();
BooksMasterHandler handler = new BooksMasterHandler();
list = handler.GetBooksMasterList();
ListViewItem lvi = new ListViewItem();
if (list.Count > 0)
{
foreach (BooksMaster obj in list)
{
lvi = new ListViewItem(obj.BookID);
lvi.SubItems.Add(obj.ISBN);
lvi.SubItems.Add(obj.Title);
lvi.SubItems.Add(obj.Subject);
lvi.SubItems.Add(obj.Author);
lvi.SubItems.Add(obj.Publication);
lvi.SubItems.Add(Convert.ToString(obj.EditionNo));
lvi.SubItems.Add(Convert.ToString(obj.EditionYear));
lvi.SubItems.Add(Convert.ToString(obj.Price));
listView1.Items.Add(lvi);
}
}
}
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);
}
}
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 cmdAddItem_Click(object sender, EventArgs e)
{
ProcessInterface();
if (AddMode || EditMode)
{
BooksMasterHandler handler = new BooksMasterHandler();
if (_bookID != "")
{
bookMasterItem = handler.GetBooksMasterDetails(_bookID);
AddItemToGrid(bookMasterItem);
}
//CalculateTotalAmount();
}
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
string strText = txtSearch.Text;
BooksMasterHandler objHandler = new BooksMasterHandler();
List <BooksMaster> list = objHandler.SearchBooksMasterList(strText);
dgvMain.RowCount = 0;
if ((list != null) && list.Count > 0)
{
foreach (BooksMaster obj in list)
{
AddItemToGrid(obj);
}
dgvMain.Rows[0].Selected = true;
}
}
public List <BooksTransactionInDetails> GetTransactionInList(string transactionID)
{
List <BooksTransactionInDetails> list = null;
string commandText = OleDBHelper.GetQueryText("BooksTransactionInDetails_SelectID", QueryType.Procedures);
OleDbParameter[] parameters = new OleDbParameter[]
{
new OleDbParameter("@TransactionID", transactionID)
};
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 <BooksTransactionInDetails>();
BooksMasterHandler objBookMasterHandler = new BooksMasterHandler();
//Now lets populate the employee details into the list of employees
foreach (DataRow row in table.Rows)
{
BooksTransactionInDetails obj = new BooksTransactionInDetails();
obj.TransactionID = Convert.ToString(row["TransactionID"]);
obj.BookMaster = objBookMasterHandler.GetBooksMasterDetails(Convert.ToString(row["BookID"]));
obj.Unit = Convert.ToInt32(row["Unit"]);
//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 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!");
}
}
