public void DisplayData(string transactionID = "-1")
{
try
{
//Master Data
BooksTransactionOutMaster objMaster = new BooksTransactionOutMaster();
objMaster = objMaster.GetTransactionOutMaster(transactionID);
if (objMaster != null)
{
ClearControl();
txtTranID.Text = objMaster.TransactionID;
dtpTranInDate.Value = objMaster.TransactionDate;
txtRemarks.Text = objMaster.Remarks;
//Transaction Data
BooksTransactionOutDetails tranDetails = new BooksTransactionOutDetails();
List <BooksTransactionOutDetails> list = new List <BooksTransactionOutDetails>();
list = tranDetails.GetTransactionInList(transactionID);
if (list.Count > 0)
{
int i;
foreach (BooksTransactionOutDetails obj in list)
{
i = dgvMain.RowCount;
dgvMain.RowCount = i + 1;
dgvMain.Rows[i].Cells[SNo].Value = i + 1;
dgvMain.Rows[i].Cells[BookID].Value = obj.BookMaster.BookID;
dgvMain.Rows[i].Cells[Subject].Value = obj.BookMaster.Subject;
dgvMain.Rows[i].Cells[Author].Value = obj.BookMaster.Author;
dgvMain.Rows[i].Cells[EditionYear].Value = obj.BookMaster.EditionYear;
dgvMain.Rows[i].Cells[EditionNo].Value = obj.BookMaster.EditionNo;
dgvMain.Rows[i].Cells[Unit].Value = obj.Unit;
}
}
ControlStatus(true);
}
else
{
MessageBox.Show("No Record found");
}
}
catch (Exception ex)
{
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n" + ex.Message);
}
}
private void Save()
{
bool result = false;
BooksTransactionOutMaster objOutMaster = GetTransactionOutMasterInterface();
List <BooksTransactionOutDetails> objDetailsList = GetTransactionInDetailsOutiterface();
BooksTransactionOutDetails objDetails = new BooksTransactionOutDetails();
if (AddMode)
{
result = objOutMaster.AddNewTransactionOutMaster(objOutMaster);
if (result)
{
result = objDetails.AddNewTransactionOutDetails(objDetailsList);
}
if (result)
{
result = GlobalFunction.UpdateUniqueCode("BooksTransactionOutMaster");
}
}
else if (EditMode)
{
result = objOutMaster.UpdateTransactionOutMaster(objOutMaster);
if (result)
{
result = objDetails.DeleteTransactionOutMaster(objOutMaster.TransactionID);
if (result)
{
result = objDetails.AddNewTransactionOutDetails(objDetailsList);
}
}
}
if (result == true)
{
if (AddMode)
{
MessageBox.Show("New Record added successfully");
}
else
{
MessageBox.Show("Record updated successfully");
}
ControlStatus(true);
}
else
{
MessageBox.Show("Errror Occurs!");
}
}
public List <BooksTransactionOutDetails> GetTransactionInList(string transactionID)
{
List <BooksTransactionOutDetails> list = null;
string commandText = OleDBHelper.GetQueryText("BooksTransactionOutDetails_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 <BooksTransactionOutDetails>();
BooksMasterHandler objBookMasterHandler = new BooksMasterHandler();
//Now lets populate the employee details into the list of employees
foreach (DataRow row in table.Rows)
{
BooksTransactionOutDetails obj = new BooksTransactionOutDetails();
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 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 bool UpdateTransactionOutDetails(BooksTransactionOutDetails book)
{
return(true);
}
