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 static String lastMsg = null;
public static void AccountListOptimizated()
{
if (listAccount == null)
{
listAccount = new ObservableCollection <dhAccount>();
}
// objAccount.BCloseAccount = true;//(bool)IncClosedAccount;
//objAccount.VFilterOperator = "==";
//objAccount.Balance = 0.0;
// objAccount.BIncludeNull = true;
dsGeneral.dtPosAccountsDataTable dt = iFacede.GetAccount(Globalized.ObjDbName, objAccount);
listAccount.Clear();
listAccount = ReflectionUtility.DataTableToObservableCollection <dhAccount>(dt);
}
private void Account_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
if (sender != null)
{
DataGridRow dgr = sender as DataGridRow;
// get the obect and then Invoice ID opne the Id in readonly mode
dhAccount objTodisplay = new dhAccount();
objTodisplay.IAccountid = ((dhAccount)dgr.Item).IAccountid;
dsGeneral.dtPosAccountsDataTable dtAccount = iFacede.GetAccount(Globalized.ObjDbName, objTodisplay);
ObservableCollection <dhAccount> listAccount = ReflectionUtility.DataTableToObservableCollection <dhAccount>(dtAccount);
if (listAccount.Count > 0)
{
objTodisplay = listAccount.Cast <dhAccount>().Where(i => i.IAccountid.Equals(objTodisplay.IAccountid)).SingleOrDefault();
objTodisplay.IUpdate = 1;
//dsGeneral.dtPosFinaceTypeDataTable dtF = iFacede.GetFinaceType(Globalized.ObjDbName, objTodisplay);
//objTodisplay.FinanceTypeList = ReflectionUtility.DataTableToObservableCollection<dhFinanceType>(dtF);
AddTabItem(objTodisplay);
}
}
}
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;
}
public dsGeneral.dtPosAccountsDataTable GetAccountPR(dhDBnames objDBNames, dhAccount objAccounts)
{
dsGeneral.dtPosAccountsDataTable dt = objDALGeneral.GetAccountPR(objDBNames, objAccounts);
return(dt);
}
private void loadData(dhAccount objAccount, Boolean ShowResultCount = false)
{
dsGeneral.dtPosAccountsDataTable dtAccounts = iFacede.GetAccount(Globalized.ObjDbName, objAccount);
EnumerableRowCollection <dsGeneral.dtPosAccountsRow> Filter = null;
sequence.Clear();
sequence = ReflectionUtility.DataTableToObservableCollection <dhAccount>(dtAccounts);
//if (Globalized.ObjCurrentUser.VUserType == "Super")
//{
// Filter = from r in dtAccounts.AsEnumerable()
// where (r.Field<int>("VUserType") == Module.IModuleID) && (r.Field<bool>("bIsActive") == true)
// select r;
//}
//if (Globalized.ObjCurrentUser.VUserType == "Owner")
//{
// Filter = from r in dtAccounts.AsEnumerable()
// where (r.Field<string>("VUserType") == "Admin") || (r.Field<string>("VUserType") == "AccountIn") || (r.Field<string>("VUserType") == "Owner")
// select r;
//}
//if (Globalized.ObjCurrentUser.VUserType == "Admin")
//{
// Filter = from r in dtAccounts.AsEnumerable()
// where ((r.Field<string>("VUserType") == "Admin") && (r.Field<int>("iAccountid") == Globalized.ObjCurrentUser.IAccountid) ) || (r.Field<string>("VUserType") == "AccountIn")
// select r;
//}
//if (Globalized.ObjCurrentUser.VUserType == "AccountIn")
//{
// Filter = from r in dtAccounts.AsEnumerable()
// where (r.Field<string>("VUserType") == "AccountIn") && (r.Field<int>("iAccountid") == Globalized.ObjCurrentUser.IAccountid)
// select r;
//}
if (Filter != null)
{
int CountRowInner = Filter.Count <dsGeneral.dtPosAccountsRow>();
if (CountRowInner > 0)
{
DataTable dtFilter = Filter.CopyToDataTable();
sequence = ReflectionUtility.DataTableToObservableCollection <dhAccount>(dtFilter);
}
else
{
sequence = null;
}
}
AccountList.ItemsSource = sequence;
//pageControl.PageContract = null;
//pageControl.PageContract = this;
// pageControl_PreviewPageChange(null, null);
// Globalized.ShowMsg(lblErrorMsg);
//if (Globalized.lastMsg != null)
//{
// //System.Windows.Forms.MessageBox.Show( );
// lblErrorMsg.Content = Globalized.lastMsg;
// lblErrorMsg.Visibility = System.Windows.Visibility.Visible;
// Globalized.lastMsg = null;
//}
//else
//{
// lblErrorMsg.Content = "";
// lblErrorMsg.Visibility = System.Windows.Visibility.Hidden;
//}
// show msg for local search
if ((ShowResultCount) && (sequence != null))
{
String msg = String.Format(" {0} Search Results Found", sequence.Count);
//pageControl.ReLoad();
Globalized.setException(msg, lblErrorMsg, DataHolders.MsgType.Info);
Globalized.ShowMsg(lblErrorMsg);
}
else
{
if (sequence == null)
{
String msg = String.Format(" {0} Search Results Found", 0);
Globalized.setException(msg, lblErrorMsg, DataHolders.MsgType.Info);
Globalized.ShowMsg(lblErrorMsg);
}
if (ShowResultCount == false)
{
lblErrorMsg.Visibility = Visibility.Hidden;
}
}
}
