private void Save()
{
bool result = false;
BooksTransactionInMaster objBooksTransactionInMaster = GetTransactionInMasterInterface();
BooksTransactionInMasterHandler masterhandler = new BooksTransactionInMasterHandler();
List <BooksTransactionInDetails> objDetailsList = GetTransactionInDetailsInterface();
BooksTransactionInDetailsHandler objDetailsHandler = new BooksTransactionInDetailsHandler();
if (AddMode)
{
result = masterhandler.AddNewTransactionInMaster(objBooksTransactionInMaster);
if (result)
{
result = objDetailsHandler.AddNewTransactionInDetails(objDetailsList);
}
if (result)
{
result = GlobalFunction.UpdateUniqueCode("BooksTransactionInMaster");
}
}
else if (EditMode)
{
result = masterhandler.UpdateTransactionIn(objBooksTransactionInMaster);
if (result)
{
result = objDetailsHandler.DeleteTransactionInDetails(objBooksTransactionInMaster.TransactionID);
if (result)
{
result = objDetailsHandler.AddNewTransactionInDetails(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 void DisplayData(string transactionID = "-1")
{
try
{
ClearControl();
//Master Data
BooksTransactionInMasterHandler objMasterHandler = new BooksTransactionInMasterHandler();
BooksTransactionInMaster objMaster = objMasterHandler.GetTransactionInMaster(transactionID);
txtTranID.Text = objMaster.TransactionID;
dtpTranInDate.Value = objMaster.TransactionDate;
txtRemarks.Text = objMaster.Remarks;
//Transaction Data
BooksTransactionInDetailsHandler tranDetailsHandler = new BooksTransactionInDetailsHandler();
List <BooksTransactionInDetails> list = new List <BooksTransactionInDetails>();
list = tranDetailsHandler.GetTransactionInList(transactionID);
if (list.Count > 0)
{
int i;
foreach (BooksTransactionInDetails 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);
}
catch (Exception ex)
{
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n" + ex.Message);
}
}
public void DisplayTrasactionList()
{
//string fromDate = dtpFromDate.Value.ToString("MM/dd/yyyy");
//string toDate = dtpToDate.Value.AddDays(1).ToString("MM/dd/yyyy");
//if (!dateFilter)
//{
// dtpFromDate.Value = DateTime.Now.Date.AddDays(-7);
// dtpToDate.Value = DateTime.Now.Date;
// fromDate = dtpFromDate.Value.ToString("MM/dd/yyyy");
// toDate = DateTime.Now.Date.AddDays(1).ToString("MM/dd/yyyy");
//}
try
{
List <BooksTransactionInMaster> list = new List <BooksTransactionInMaster>();
BooksTransactionInMasterHandler masterHandler = new BooksTransactionInMasterHandler();
list = masterHandler.GetTransactionInMasterList();
ListViewItem lvi = new ListViewItem();
if (list.Count > 0)
{
foreach (BooksTransactionInMaster obj in list)
{
lvi = new ListViewItem(obj.TransactionID);
lvi.SubItems.Add(Convert.ToString(obj.TransactionDate));
lvi.SubItems.Add(obj.Remarks);
listView1.Items.Add(lvi);
}
}
}
catch (Exception ex)
{
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n" + ex.Message);
}
}
public void DisplayTrasactionList()
{
//string fromDate = dtpFromDate.Value.ToString("MM/dd/yyyy");
//string toDate = dtpToDate.Value.AddDays(1).ToString("MM/dd/yyyy");
//if (!dateFilter)
//{
// dtpFromDate.Value = DateTime.Now.Date.AddDays(-7);
// dtpToDate.Value = DateTime.Now.Date;
// fromDate = dtpFromDate.Value.ToString("MM/dd/yyyy");
// toDate = DateTime.Now.Date.AddDays(1).ToString("MM/dd/yyyy");
//}
try
{
List <BooksTransactionInMaster> list = new List <BooksTransactionInMaster>();
BooksTransactionInMasterHandler masterHandler = new BooksTransactionInMasterHandler();
list = masterHandler.GetTransactionInMasterList();
ListViewItem lvi = new ListViewItem();
if (list.Count > 0)
{
foreach (BooksTransactionInMaster obj in list)
{
lvi = new ListViewItem(obj.TransactionID);
lvi.SubItems.Add(Convert.ToString(obj.TransactionDate));
lvi.SubItems.Add(obj.Remarks);
listView1.Items.Add(lvi);
}
}
////if (dateFilter)// filder by date
////{
//str = "SELECT TransactionID, CustomerName, TotalAmount, SaleDate, Remarks FROM SaleMaster WHERE (SaleDate>=#" + fromDate + "# And SaleDate<=#" + toDate + "#) ORDER BY TransactionID";
////}
////else // Default
////{
//// str = "SELECT TransactionID, CustomerName, TotalAmount, SaleDate, Remarks FROM SaleMaster ORDER BY TransactionID";
////}
//dt = DBService.GetDataTable(str);
//rowCount = dt.Rows.Count;
//if (rowCount > 0)
//{
// for (int i = 0; i < rowCount; i++)
// {
// //share details
// //dgvSearch.RowCount += 1;
// dgvSearch.RowCount = i + 1;
// dgvSearch.Rows[i].Cells[0].Value = i + 1;
// dgvSearch.Rows[i].Cells[1].Value = Convert.ToString(dt.Rows[i]["TransactionID"]);
// dgvSearch.Rows[i].Cells[2].Value = Convert.ToString(dt.Rows[i]["CustomerName"]);
// dgvSearch.Rows[i].Cells[3].Value = Convert.ToDouble(dt.Rows[i]["TotalAmount"]);
// dgvSearch.Rows[i].Cells[4].Value = Convert.IsDBNull(dt.Rows[i]["SaleDate"]) ? DateTime.Now.Date : ((System.DateTime)(dt.Rows[i]["SaleDate"]));
// dgvSearch.Rows[i].Cells[5].Value = Convert.ToString(dt.Rows[i]["Remarks"]);
// totalSearchSale = totalSearchSale + Convert.ToDouble(dgvSearch.Rows[i].Cells[3].Value);
// }
//}
//else
//{
// dgvSearch.RowCount = 0;
//}
//// lblTotalSearchSale.Text = Convert.ToString(totalSearchSale);
//lblTotalSearchSale.Text = GlobalFunction.GetCurrencyFormat(totalSearchSale, false, true);
}
catch (Exception ex)
{
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n" + ex.Message);
}
}
