private List <TransactionInDetails> GetTransactionInDetailsInterface()
{
List <TransactionInDetails> objTrasList = new List <TransactionInDetails>();
int rowCount = dgvMain.RowCount;
TransactionInDetails obj;
ItemMaster objItemMaster;
for (int rowIndex = 0; rowIndex < rowCount; rowIndex++)
{
obj = new TransactionInDetails();
obj.TransactionID = txtTranID.Text;
obj.Unit = Convert.ToInt32(dgvMain.Rows[rowIndex].Cells[Unit].Value);
obj.Rate = Convert.ToInt32(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_rptTransactionIn(string transactionInID)
{
try
{
//Original tested
ReportDataSource rptDataSource;
string reportPath = ReportPath + "rptTransactionIn.rdlc";
reportViewer1.LocalReport.ReportPath = reportPath;
reportViewer1.LocalReport.DataSources.Clear();
TransactionInDataSet ds = new TransactionInDataSet();
TransactionInDetails obj = new TransactionInDetails();
DataTable dt = obj.GetReportTransactionIn(transactionInID);
// DataTable dt = ds.Tables["dtTransactionIn"];
ds.Tables["dtTransactionIn"].Merge(dt);
rptDataSource = new ReportDataSource("DataSet1", ds.Tables["dtTransactionIn"]);
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
TransactionInMaster objMasterHandler = new TransactionInMaster();
TransactionInMaster objMaster = objMasterHandler.GetTransactionInMaster(transactionID);
if (objMaster != null)
{
txtTranID.Text = objMaster.TransactionID;
dtpTranInDate.Value = objMaster.TransactionDate;
txtRemarks.Text = objMaster.Remarks;
//Transaction Data
TransactionInDetails tranDetailsHandler = new TransactionInDetails();
List <TransactionInDetails> list = new List <TransactionInDetails>();
list = tranDetailsHandler.GetTransactionInList(transactionID);
if ((list != null))
{
if (list.Count > 0)
{
int i;
foreach (TransactionInDetails 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);
}
}
public List <TransactionInDetails> GetTransactionInList(string transactionID)
{
List <TransactionInDetails> list = null;
string commandText = OleDBHelper.GetQueryText("TransactionInDetails_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 <TransactionInDetails>();
ItemMaster itemHandler = new ItemMaster();
//Now lets populate the employee details into the list of employees
foreach (DataRow row in table.Rows)
{
TransactionInDetails obj = new TransactionInDetails();
obj.TransactionID = Convert.ToString(row["TransactionID"]);
obj.ItemMaster = itemHandler.GetItemMasterDetails(Convert.ToString(row["ItemID"]));
obj.Unit = Convert.ToInt32(row["Unit"]);
obj.Rate = Convert.ToDecimal(Convert.IsDBNull(row["Rate"]) ? 0 : row["Rate"]);
obj.Amount = Convert.ToDecimal(Convert.IsDBNull(row["Amount"]) ? 0 : row["Amount"]);
//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 frmReportViewer_Load(object sender, System.EventArgs e)
{
ReportDataSource rptDataSource;
try
{
//Original tested
string reportPath = @"E:\Dinesh Demo Project\ColdStorage\ColdStorage\Reports\rptTransactionIn.rdlc";
reportViewer1.LocalReport.ReportPath = reportPath;
reportViewer1.LocalReport.DataSources.Clear();
TransactionInDataSet ds = new TransactionInDataSet();
//ListDataSet.BooksMasterDataSetTableAdapters.BooksMasterTableAdapter da = new ListDataSet.BooksMasterDataSetTableAdapters.BooksMasterTableAdapter();
TransactionInDetails obj = new TransactionInDetails();
DataTable datatable = obj.GetReportTransactionIn("IN000001");
// DataTable dt = ds.Tables["dtTransactionIn"];
ds.Tables["dtTransactionIn"].Merge(datatable);
string str;
rptDataSource = new ReportDataSource("DataSet1", ds.Tables["dtTransactionIn"]);
reportViewer1.LocalReport.DataSources.Add(rptDataSource);
reportViewer1.RefreshReport();
reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Save()
{
bool result = false;
TransactionInMaster objTransactionInMaster = GetTransactionInMasterInterface();
TransactionInMaster masterhandler = new TransactionInMaster();
List <TransactionInDetails> objDetailsList = GetTransactionInDetailsInterface();
TransactionInDetails objDetailsHandler = new TransactionInDetails();
//Inventory obj;
if (AddMode)
{
result = masterhandler.AddNewTransactionInMaster(objTransactionInMaster);
if (result)
{
result = objDetailsHandler.AddNewTransactionInDetails(objDetailsList);
}
if (result)
{
result = GlobalFunction.UpdateUniqueCode("TransactionInMaster");
}
// obj = new Inventory();
//if (result)
//{
// result = obj.AddInventory(objDetailsList);
//}
}
else if (EditMode)
{
// obj = new Inventory();
result = masterhandler.UpdateTransactionIn(objTransactionInMaster);
//if (result)
//{
// result = obj.UpdateInventory(objBooksTransactionInMaster.TransactionID, objDetailsList);
//}
if (result)
{
result = objDetailsHandler.DeleteTransactionInDetails(objTransactionInMaster.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 bool UpdateTransactionInDetails(TransactionInDetails book)
{
return(true);
}
