public ItemMaster GetItemMasterDetails(String itemID)
{
ItemMaster obj = null;
string commandText = OleDBHelper.GetQueryText("ItemMaster_SelectID", QueryType.Procedures);
OleDbParameter[] parameters = new OleDbParameter[]
{
new OleDbParameter("@ItemID", itemID)
};
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
obj = new ItemMaster();
obj.ItemID = Convert.ToString(table.Rows[0]["ItemID"]);
obj.ItemName = Convert.ToString(table.Rows[0]["ItemName"]);
obj.Remarks = Convert.ToString(table.Rows[0]["Remarks"]);
}
}
return(obj);
}
public BooksMaster GetBooksMasterDetails(String bookID)
{
BooksMaster obj = null;
string commandText = OleDBHelper.GetQueryText("BooksMaster_SelectID", QueryType.Procedures);
OleDbParameter[] parameters = new OleDbParameter[]
{
new OleDbParameter("@BookID", bookID)
};
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
obj = new BooksMaster();
obj.BookID = Convert.ToString(table.Rows[0]["BookID"]);
obj.ISBN = Convert.ToString(table.Rows[0]["ISBN"]);
obj.Title = Convert.ToString(table.Rows[0]["Title"]);
obj.Subject = Convert.ToString(table.Rows[0]["Subject"]);
obj.Author = Convert.ToString(table.Rows[0]["Author"]);
obj.Publication = Convert.ToString(table.Rows[0]["Publication"]);
obj.EditionNo = Convert.ToInt32(table.Rows[0]["EditionNo"]);
obj.EditionYear = Convert.ToInt32(table.Rows[0]["EditionYear"]);
obj.Price = Convert.ToInt32(table.Rows[0]["Price"]);
}
}
return(obj);
}
public PartyMaster GetPartyMasterDetails(String partyID)
{
PartyMaster obj = null;
string commandText = OleDBHelper.GetQueryText("PartyMaster_SelectID", QueryType.Procedures);
OleDbParameter[] parameters = new OleDbParameter[]
{
new OleDbParameter("@PartyID", partyID)
};
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
obj = new PartyMaster();
obj.PartyID = Convert.ToString(table.Rows[0]["PartyID"]);
obj.PartyName = Convert.ToString(table.Rows[0]["PartyName"]);
obj.PersonName = Convert.ToString(table.Rows[0]["PersonName"]);
obj.Address = Convert.ToString(table.Rows[0]["Address"]);
obj.ContactNo = Convert.ToString(table.Rows[0]["ContactNo"]);
obj.Mobile = Convert.ToString(table.Rows[0]["Mobile"]);
obj.EamilAddress = Convert.ToString(table.Rows[0]["EamilAddress"]);
obj.Remarks = Convert.ToString(table.Rows[0]["Remarks"]);
}
}
return(obj);
}
public TransactionInMaster GetTransactionInMaster(string transactionID)
{
TransactionInMaster obj = null;
string commandText = OleDBHelper.GetQueryText("TransactionInMaster_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
obj = new TransactionInMaster();
obj.TransactionID = Convert.ToString(table.Rows[0]["TransactionID"]);
obj.TransactionDate = Convert.ToDateTime(table.Rows[0]["TransactionDate"]);
obj.PartyID = Convert.ToString(table.Rows[0]["PartyID"]);
obj.Amount = Convert.ToDecimal(Convert.IsDBNull(table.Rows[0]["Amount"]) ? 0 : table.Rows[0]["Amount"]);
obj.Remarks = Convert.ToString(table.Rows[0]["Remarks"]);
}
}
return(obj);
}
public Inventory GetInventoryDetails(Inventory obj)
{
Inventory objDetails = null;
string commandText = OleDBHelper.GetQueryText("Inventory_SelectID", QueryType.Procedures);
OleDbParameter[] parameters = new OleDbParameter[]
{
new OleDbParameter("@ItemID", obj.ItemID)
//new OleDbParameter("@UnitID", obj.UnitID)
};
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
objDetails = new Inventory();
objDetails.ItemID = Convert.ToString(table.Rows[0]["ItemID"]);
objDetails.UnitID = Convert.ToString(table.Rows[0]["UnitID"]);
objDetails.LastTranID = Convert.ToString(table.Rows[0]["LastTranID"]);
objDetails.QtyIn = Convert.IsDBNull(table.Rows[0]["QtyIn"])? 0 : Convert.ToInt32(table.Rows[0]["QtyIn"]);
objDetails.QtyOut = Convert.IsDBNull(table.Rows[0]["QtyOut"]) ? 0 : Convert.ToInt32(table.Rows[0]["QtyOut"]);
objDetails.PrevBalance = Convert.IsDBNull(table.Rows[0]["PrevBalance"]) ? 0 : Convert.ToInt32(table.Rows[0]["PrevBalance"]);
objDetails.CurrBalance = Convert.IsDBNull(table.Rows[0]["CurrBalance"]) ? 0 : Convert.ToInt32(table.Rows[0]["CurrBalance"]);
}
}
return(objDetails);
}
public static DataTable GetUniqueCodeForTable(string tableName)
{
DataTable dt = new DataTable();
OleDbParameter[] parameters = new OleDbParameter[]
{
new OleDbParameter("@TableName", tableName)
};
string commandText = OleDBHelper.GetQueryText("GetUniqueCodeForTable", QueryType.Procedures);
dt = OleDBHelper.ExecuteParamerizedSelectCommand(commandText, CommandType.Text, parameters);
return(dt);
}
public List <BooksMaster> SearchBooksMasterList(string searchText)
{
searchText = "%" + searchText + "%";
List <BooksMaster> list = null;
string commandText = OleDBHelper.GetQueryText("Search_BooksMaster", QueryType.Procedures);
OleDbParameter[] parameters = new OleDbParameter[]
{
new OleDbParameter("@BookID", searchText),
new OleDbParameter("@ISBN", searchText),
new OleDbParameter("@Title]", searchText),
new OleDbParameter("@Subject", searchText),
new OleDbParameter("@Author", searchText),
new OleDbParameter("@Publication", searchText)
//new OleDbParameter("@EditionNo", searchText),
//new OleDbParameter("@EditionYear", searchText)
//new OleDbParameter("@Price", book.Price),
};
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 <BooksMaster>();
//Now lets populate the employee details into the list of employees
foreach (DataRow row in table.Rows)
{
BooksMaster obj = new BooksMaster();
obj.BookID = Convert.ToString(row["BookID"]);
obj.ISBN = Convert.ToString(row["ISBN"]);
obj.Title = Convert.ToString(row["Title"]);
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);
}
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);
}
//DataTable
public DataTable GetReportTransactionIn(string transactionID)
{
DataTable dt = null;
string commandText = OleDBHelper.GetQueryText("rptTransactionIn", 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
dt = new DataTable();
dt = table;
}
}
return(dt);
}