public dhItems GetdhItem(dhDBnames objDBNames, dhItems ObjItem) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBNames, ObjItem, "xmlGetItems", (DataSet)ds, "dtPosItems"); dhItems returnObject = null; dsGeneral.dtPosItemsDataTable retdt = ((dsGeneral)dsreturn).dtPosItems; foreach (DataRow row in retdt.Rows) { returnObject = new dhItems { IItemID = Convert.ToInt32(row["IItemID"]), FUnitePrice = Convert.ToDouble(row["FUnitePrice"]), VItemName = Convert.ToString(row["VItemName"]), FMaxDiscountPresent = Convert.ToDouble(row["fMaxDiscountPresent"]), FUnitPurchasePrice = Convert.ToDouble(row["fUnitPurchasePrice"]), IQuantity = 1, Ammount = Convert.ToDouble(row["FUnitePrice"]) * 1, IStockIn = Convert.ToInt32(String.IsNullOrEmpty(row["IStockIn"].ToString()) ? 0 : row["IStockIn"]), IStockOut = Convert.ToInt32(String.IsNullOrEmpty(row["IStockOut"].ToString()) ? 0 : row["IStockOut"]), ICurrantStock = Convert.ToInt32(String.IsNullOrEmpty(row["ICurrantStock"].ToString()) ? 0 : row["ICurrantStock"]), IsAvailable = Convert.ToInt32(String.IsNullOrEmpty(row["ICurrantStock"].ToString()) ? 0 : row["ICurrantStock"]) > 0? true : false, StockStatus = Convert.ToInt32(String.IsNullOrEmpty(row["ICurrantStock"].ToString()) ? 0 : row["ICurrantStock"]) > 0 ? "Available" : "Not Available", BIsEditAbleInInvoice = Convert.ToBoolean(row["BIsEditAbleInInvoice"].ToString()), }; } return(returnObject); }
public dsGeneral.dtSalaryDataTable GetSalarySheetHrEmployee(dhDBnames objDBName, dhSalary objSalary) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBName, objSalary, "xmlGetSalarySheetHrEmployee", (DataSet)ds, "dtSalary"); dsGeneral.dtSalaryDataTable retdt = ((dsGeneral)dsreturn).dtSalary; return(retdt); }
public dsGeneral.dtPosJournalDetailDataTable GetJournalDetail(dhDBnames objDBNames, dhJournalDetail objJournalDetail) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objJournalDetail, "xmlGetJournalDetail", (DataSet)ds, "dtPosJournalDetail"); dsGeneral.dtPosJournalDetailDataTable retdt = ((dsGeneral)dsreturn).dtPosJournalDetail; return(retdt); }
public dsGeneral.dtPOSCostumerDataTable GetCostumerAlert(dhDBnames objDBNames, dhCostumer objCostumer) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objCostumer, "xmlGetCostumerAlert", (DataSet)ds, "dtPOSCostumer"); dsGeneral.dtPOSCostumerDataTable retdt = ((dsGeneral)dsreturn).dtPOSCostumer; return(retdt); }
public dsGeneral.dtAppPreferenceDataTable GetAppPreference(dhDBnames objDBNames, dhAppPreference objPreference) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objPreference, "xmlGetAppPreference", (DataSet)ds, "dtAppPreference"); dsGeneral.dtAppPreferenceDataTable retdt = ((dsGeneral)dsreturn).dtAppPreference; return(retdt); }
public dsGeneral.dtPosModuleDataTable GetModule(dhDBnames objDBNames, dhModule ObjModule) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBNames, ObjModule, "xmlGetModule", (DataSet)ds, "dtPosModule"); dsGeneral.dtPosModuleDataTable retdt = ((dsGeneral)dsreturn).dtPosModule; return(retdt); }
/// <summary> /// Gets the employee. /// </summary> /// <param name="objDBName">Name of the obj DB.</param> /// <param name="objEmployee">The obj employee.</param> /// <returns></returns> public dsGeneral.dtEmployeeDataTable GetEmployee(dhDBnames objDBName, dhEmployee objEmployee) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBName, objEmployee, "xmlGetEmployee", (DataSet)ds, "dtEmployee"); dsGeneral.dtEmployeeDataTable retdt = ((dsGeneral)dsreturn).dtEmployee; return(retdt); }
public dsGeneral.dtPosPartyDataTable GetParty(dhDBnames objDBName, dhParty objParty) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBName, objParty, "xmlGetParty", (DataSet)ds, "dtPosParty"); dsGeneral.dtPosPartyDataTable retdt = ((dsGeneral)dsreturn).dtPosParty; return(retdt); }
/// <summary> /// Gets the user. /// </summary> /// <param name="objDBName">Name of the obj DB.</param> /// <param name="objUser">The obj user.</param> /// <returns></returns> public dsGeneral.dtAppUserDataTable GetUser(dhDBnames objDBName, dhUsers objUser) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBName, objUser, "xmlGetAppUser", (DataSet)ds, "dtAppUser"); dsGeneral.dtAppUserDataTable retdt = ((dsGeneral)dsreturn).dtAppUser; return(retdt); }
public dsGeneral.dtPosAccountsDataTable GetAccounts(dhDBnames objDBName, dhAccount objAccounts) { dsGeneral ds = new dsGeneral(); DataSet dsreturn; dsreturn = objDatabase.GetDataSet(objDBName, objAccounts, "xmlGetAccounts", (DataSet)ds, "dtPosAccounts"); dsGeneral.dtPosAccountsDataTable retdt = ((dsGeneral)dsreturn).dtPosAccounts; return(retdt); }
public dsGeneral.dtPosSaleManDataTable GetSaleMan(dhDBnames objDBName, dhSaleMan objSaleMan) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBName, objSaleMan, "xmlGetSaleMan", (DataSet)ds, "dtPosSaleMan"); dsGeneral.dtPosSaleManDataTable retdt = ((dsGeneral)dsreturn).dtPosSaleMan; return(retdt); }
//public dsGeneral.dtPosSaleManDataTable GetSaleMan(dhDBnames objDBName, dhSaleMan objSaleMan) //{ // dsGeneral ds = new dsGeneral(); // DataSet dsreturn = objDatabase.GetDataSet(objDBName, objSaleMan, "xmlGetSaleMan", (DataSet)ds, "dtPosSaleMan"); // dsGeneral.dtPosSaleManDataTable retdt = ((dsGeneral)dsreturn).dtPosSaleMan; // return retdt; //} #endregion public dsGeneral.dtPosStockDataTable GetItemStock(dhDBnames objDBNames, dhItemStock objStock) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objStock, "xmlGetItemStock", (DataSet)ds, "dtPosStock"); dsGeneral.dtPosStockDataTable retdt = ((dsGeneral)dsreturn).dtPosStock; return(retdt); // throw new NotImplementedException(); }
public dsGeneral.dtPosItemsDataTable GetItems(dhDBnames objDBNames, dhItems ObjItem) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBNames, ObjItem, "xmlGetItems", (DataSet)ds, "dtPosItems"); dsGeneral.dtPosItemsDataTable retdt = ((dsGeneral)dsreturn).dtPosItems; return(retdt); //dsGeneral.dtPosItemsDataTable dt = objDALGeneral.GetAllItems(objDBNames, ObjItem); //return dt; }
private void LoadReport() { DepartmentDAL obj = new DepartmentDAL(); ReportDocument crystalReport = new ReportDocument(); crystalReport.Load(Server.MapPath("crptDepartment.rpt")); dsGeneral ds = obj.LoadDepartmentReport(); crystalReport.SetDataSource(ds); CrystalReportViewer1.ReportSource = crystalReport; CrystalReportViewer1.DataBind(); }
public dsGeneral LoadDepartmentReport() { dsGeneral ds = new dsGeneral(); try { _initObjects("SP_Department"); cmd.Parameters.AddWithValue("@Action", "GetAllDepartment"); da.Fill(ds, "dttblDepartment"); } catch (Exception ex) { CloseCon(); throw ex; } finally { CloseCon(); } return(ds); }
public dhAccount GetdhAccount(dhDBnames objDBNames, dhAccount objAccount) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objAccount, "xmlGetAccounts", (DataSet)ds, "dtPosAccounts"); // dhAccount returnObject = null; dsGeneral.dtPosAccountsDataTable retdt = ((dsGeneral)dsreturn).dtPosAccounts; ObservableCollection <dhAccount> listAccount = ReflectionUtility.DataTableToObservableCollection <dhAccount>(retdt); if (listAccount.Count > 0) { return(listAccount.SingleOrDefault()); } else { return(null); } //retdt.ToList<dhAccount>(); //foreach (DataRow row in retdt.Rows) //{ // returnObject = new dhAccount // { // IItemID = Convert.ToInt32(row["IItemID"]), // FUnitePrice = Convert.ToDouble(row["FUnitePrice"]), // VItemName = Convert.ToString(row["VItemName"]), // FMaxDiscountPresent = Convert.ToDouble(row["fMaxDiscountPresent"]), // IQuantity = 1, // Ammount = Convert.ToDouble(row["FUnitePrice"]) * 1, // IStockIn = Convert.ToInt32(String.IsNullOrEmpty(row["IStockIn"].ToString()) ? 0 : row["IStockIn"]), // IStockOut = Convert.ToInt32(String.IsNullOrEmpty(row["IStockOut"].ToString()) ? 0 : row["IStockOut"]), // ICurrantStock = Convert.ToInt32(String.IsNullOrEmpty(row["ICurrantStock"].ToString()) ? 0 : row["ICurrantStock"]), // IsAvailable = Convert.ToInt32(String.IsNullOrEmpty(row["ICurrantStock"].ToString()) ? 0 : row["ICurrantStock"]) > 0 ? true : false, // StockStatus = Convert.ToInt32(String.IsNullOrEmpty(row["ICurrantStock"].ToString()) ? 0 : row["ICurrantStock"]) > 0 ? "Available" : "Not Available", // }; //} // return returnObject; }