//Get List Of Sales Voucher Details In List public List <TransListModel> GetAllSalesVoucherMaster() { List <TransListModel> lstModel = new List <TransListModel>(); TransListModel objList; StringBuilder sbQuery = new StringBuilder(); sbQuery.AppendLine("SELECT m.SalesVoucher_Id, i.Id,m.SaleDate,m.VoucherNumber, i.ITM_ID, i.Qty, i.Unit,i.Amount,im.ITEM_Name,am.ACC_NAME FROM salesvoucher_master AS m"); sbQuery.AppendLine("INNER JOIN salesvoucher_itemdetails AS i ON m.SalesVoucher_Id=i.SalesVoucher_Id"); sbQuery.AppendLine("left join itemmaster as im ON i.itm_id=im.ITM_ID"); sbQuery.AppendLine("left join accountmaster am ON am.Ac_ID = m.LedgerId;"); System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(sbQuery.ToString(), _dbHelper.GetConnObject()); while (dr.Read()) { objList = new TransListModel(); objList.trans_sales_id = Convert.ToInt32(dr["SalesVoucher_Id"]); objList.item_id = Convert.ToInt32(dr["Id"]); objList.saledate = Convert.ToDateTime(dr["SaleDate"]); objList.voucherno = Convert.ToInt32(dr["VoucherNumber"]); objList.party = Convert.ToString(dr["ACC_NAME"]); objList.item = Convert.ToString(dr["ITEM_Name"].ToString() == null?string.Empty: dr["ITEM_Name"].ToString()); objList.qty = Convert.ToInt32(dr["Qty"]); objList.unit = Convert.ToString(dr["Unit"]); objList.amount = Convert.ToDecimal(dr["Amount"]); lstModel.Add(objList); } return(lstModel); }
public List <TransListModel> GetAllUnassemble() { List <TransListModel> lstModel = new List <TransListModel>(); TransListModel objList; StringBuilder sbQuery = new StringBuilder(); sbQuery.Append("SELECT t.Unassemble_id, i.itemid, t.UA_date, t.series, t.voucherno,i.item,i.qty,i.unit,i.price,i.amount,i.totalqty, i.totalamount FROM trans_Unassemble_Voucher AS t "); sbQuery.Append("INNER JOIN trans_Unassemble_items AS i ON t.Unassemble_Id=i.Unassemble_Id;"); System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(sbQuery.ToString(), _dbHelper.GetConnObject()); while (dr.Read()) { objList = new TransListModel(); objList.trans_sales_id = Convert.ToInt32(dr["Unassemble_Id"]); objList.item_id = Convert.ToInt32(dr["itemid"]); objList.saledate = Convert.ToDateTime(dr["UA_Date"]); objList.series = Convert.ToString(dr["series"]); objList.voucherno = Convert.ToInt32(dr["VoucherNo"]); objList.item = Convert.ToString(dr["item"]); objList.qty = Convert.ToInt32(dr["qty"]); objList.unit = Convert.ToString(dr["unit"]); objList.price = Convert.ToInt32(dr["price"]); objList.amount = Convert.ToInt32(dr["amount"]); objList.totalqty = Convert.ToInt32((dr["totalqty"])); objList.totalamount = Convert.ToInt32((dr["totalamount"])); lstModel.Add(objList); } return(lstModel); }
//Get List Of Purchase Vouchers Details In List public List <TransListModel> GetAllPurchaseVoucherMaster() { List <TransListModel> lstModel = new List <TransListModel>(); TransListModel objList; StringBuilder sbQuery = new StringBuilder(); sbQuery.AppendLine("SELECT m.PurcVoucher_Id, i.Id,m.PurcDate,m.VoucherNumber, i.ITM_ID, i.Qty, i.Unit,im.ITEM_Name,am.ACC_NAME FROM purchasevoucher_master AS m"); sbQuery.AppendLine("INNER JOIN purchasevoucher_itemdetails AS i ON m.PurcVoucher_Id=i.PurcVoucher_Id"); sbQuery.AppendLine("left join itemmaster as im ON i.itm_id=im.ITM_ID"); sbQuery.AppendLine("left join accountmaster am ON am.Ac_ID = m.LedgerId;"); System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(sbQuery.ToString(), _dbHelper.GetConnObject()); while (dr.Read()) { objList = new TransListModel(); objList.PurcVchId = Convert.ToInt64(dr["PurcVoucher_Id"]); //objList.item_id = Convert.ToInt32(dr["ItemId"]); objList.Purcdate = Convert.ToDateTime(dr["PurcDate"]); objList.voucherno = Convert.ToInt32(dr["VoucherNumber"]); objList.party = Convert.ToString(dr["ACC_NAME"]); objList.item = Convert.ToString(dr["ITEM_Name"]); objList.qty = Convert.ToInt32(dr["Qty"]); objList.unit = Convert.ToString(dr["Unit"]); lstModel.Add(objList); } return(lstModel); }