private List <TransactionOutDetails> GetTransactionOutDetailsInterface() { List <TransactionOutDetails> objTrasList = new List <TransactionOutDetails>(); int rowCount = dgvMain.RowCount; TransactionOutDetails obj; ItemMaster objItemMaster; for (int rowIndex = 0; rowIndex < rowCount; rowIndex++) { obj = new TransactionOutDetails(); obj.TransactionID = txtTranID.Text; obj.Unit = Convert.ToInt32(dgvMain.Rows[rowIndex].Cells[Unit].Value); obj.Rate = Convert.ToDecimal(dgvMain.Rows[rowIndex].Cells[Rate].Value); obj.Amount = Convert.ToInt32(dgvMain.Rows[rowIndex].Cells[Amount].Value); objItemMaster = new ItemMaster(); objItemMaster.ItemID = Convert.ToString(dgvMain.Rows[rowIndex].Cells[ItemID].Value); obj.ItemMaster = objItemMaster; objTrasList.Add(obj); } return(objTrasList); }
public void Generate_rptTransactionOut(string transactionOutID) { try { //Original tested ReportDataSource rptDataSource; string reportPath = ReportPath + "rptTransactionOut.rdlc"; reportViewer1.LocalReport.ReportPath = reportPath; reportViewer1.LocalReport.DataSources.Clear(); TransactionOutDataSet ds = new TransactionOutDataSet(); TransactionOutDetails obj = new TransactionOutDetails(); DataTable datatable = obj.GetReportTransactionOut(transactionOutID); // DataTable dt = ds.Tables["dtTransactionIn"]; ds.Tables["dtTransactionOut"].Merge(datatable); rptDataSource = new ReportDataSource("DataSet1", ds.Tables["dtTransactionOut"]); reportViewer1.LocalReport.DataSources.Add(rptDataSource); reportViewer1.RefreshReport(); reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void DisplayData(string transactionID = "-1") { try { ClearControl(); //Master Data TransactionOutMaster objMasterHandler = new TransactionOutMaster(); TransactionOutMaster objMaster = objMasterHandler.GetTransactionOutMaster(transactionID); if (objMaster != null) { txtTranID.Text = objMaster.TransactionID; dtpTranInDate.Value = objMaster.TransactionDate; txtRemarks.Text = objMaster.Remarks; //Transaction Data TransactionOutDetails tranDetailsHandler = new TransactionOutDetails(); List <TransactionOutDetails> list = new List <TransactionOutDetails>(); list = tranDetailsHandler.GetTransactionInList(transactionID); if ((list != null)) { if (list.Count > 0) { int i; foreach (TransactionOutDetails obj in list) { i = dgvMain.RowCount; dgvMain.RowCount = i + 1; dgvMain.Rows[i].Cells[SNo].Value = i + 1; dgvMain.Rows[i].Cells[ItemID].Value = obj.ItemMaster.ItemID; dgvMain.Rows[i].Cells[ItemName].Value = obj.ItemMaster.ItemName; //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 List <TransactionOutDetails> GetTransactionInList(string transactionID) { List <TransactionOutDetails> list = null; string commandText = OleDBHelper.GetQueryText("TransactionOutDetails_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 <TransactionOutDetails>(); ItemMaster objBookMasterHandler = new ItemMaster(); //Now lets populate the employee details into the list of employees foreach (DataRow row in table.Rows) { TransactionOutDetails obj = new TransactionOutDetails(); obj.TransactionID = Convert.ToString(row["TransactionID"]); obj.ItemMaster = objBookMasterHandler.GetItemMasterDetails(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; TransactionOutMaster objTransactionOutMaster = GetTransactionOutMasterInterface(); TransactionOutMaster masterhandler = new TransactionOutMaster(); List <TransactionOutDetails> objDetailsList = GetTransactionOutDetailsInterface(); TransactionOutDetails objDetailsHandler = new TransactionOutDetails(); //Inventory obj; if (AddMode) { result = masterhandler.AddNewTransactionOutMaster(objTransactionOutMaster); if (result) { result = objDetailsHandler.AddNewTransactionOutDetails(objDetailsList); } if (result) { result = GlobalFunction.UpdateUniqueCode("TransactionOutMaster"); } // obj = new Inventory(); //if (result) //{ // result = obj.AddInventory(objDetailsList); //} } else if (EditMode) { // obj = new Inventory(); result = masterhandler.UpdateTransactionOutMaster(objTransactionOutMaster); //if (result) //{ // result = obj.UpdateInventory(objBooksTransactionOutMaster.TransactionID, objDetailsList); //} if (result) { result = objDetailsHandler.DeleteTransactionOutMaster(objTransactionOutMaster.TransactionID); if (result) { result = objDetailsHandler.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 bool UpdateTransactionOutDetails(TransactionOutDetails book) { return(true); }
public void DisplayData(string transactionID = "-1") { try { ClearControl(); //Master Data TransactionOutMaster objMasterHandler = new TransactionOutMaster(); TransactionOutMaster objMaster = objMasterHandler.GetTransactionOutMaster(transactionID); if (objMaster != null) { txtTranID.Text = objMaster.TransactionID; dtpTranInDate.Value = objMaster.TransactionDate; if (objMaster.Amount > 0) { txtAmount.Text = Convert.ToString(objMaster.Amount); } txtRemarks.Text = objMaster.Remarks; PartyID = objMaster.PartyID; //Party details PartyMaster objPartyMaster = new PartyMaster(); PartyMaster partyMaster = new PartyMaster(); partyMaster = objPartyMaster.GetPartyMasterDetails(PartyID); if (partyMaster != null) { txtPartyName.Text = partyMaster.PartyName; txtContactNo.Text = partyMaster.ContactNo; txtAddress.Text = partyMaster.Address; } else { txtPartyName.Text = ""; txtContactNo.Text = ""; txtAddress.Text = ""; } //Transaction Data TransactionOutDetails tranDetailsHandler = new TransactionOutDetails(); List <TransactionOutDetails> list = new List <TransactionOutDetails>(); list = tranDetailsHandler.GetTransactionInList(transactionID); if ((list != null)) { if (list.Count > 0) { int i; foreach (TransactionOutDetails obj in list) { i = dgvMain.RowCount; dgvMain.RowCount = i + 1; dgvMain.Rows[i].Cells[SNo].Value = i + 1; dgvMain.Rows[i].Cells[ItemID].Value = obj.ItemMaster.ItemID; dgvMain.Rows[i].Cells[ItemName].Value = obj.ItemMaster.ItemName; //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; if (obj.Rate > 0) { dgvMain.Rows[i].Cells[Rate].Value = obj.Rate; } if (obj.Amount > 0) { dgvMain.Rows[i].Cells[Amount].Value = obj.Amount; } } } } } ControlStatus(true); } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n" + ex.Message); } }