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 DataSet RemoveSaleInoviceItem(dhDBnames objDBNames, dhSaleItem objInvoiceItem)
{
DataSet ds;
ds = objDALGeneral.RemoveSaleInoviceItem(objDBNames, objInvoiceItem);
return(ds);
}
public DataSet InsertUpdateItem(dhDBnames objDBNames, dhItems ObjItem)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateItem(objDBNames, ObjItem);
return(ds);
}
public DataSet GetSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice)
{
DataSet ds;
ds = objDALGeneral.GetSaleInovice(objDBNames, objInvoice);
return(ds);
}
//private void ListViewMenu_SelectionChanged(object sender, SelectionChangedEventArgs e)
//{
// UserControl usc = null;
// GridMain.Children.Clear();
// switch (((ListViewItem)((ListView)sender).SelectedItem).Name)
// {
// case "ItemHome":
// usc = new PartyView();
// GridMain.Children.Add(usc);
// break;
// case "ItemCreate":
// usc = new PartyView();
// GridMain.Children.Add(usc);
// break;
// default:
// break;
// }
//}
private void LoadComponent()
{
dhDBnames objDBNames = new dhDBnames();
objDBNames.ServerName = System.Configuration.ConfigurationManager.AppSettings["ServerName"].ToString();
objDBNames.Default_DB_Name = System.Configuration.ConfigurationManager.AppSettings["DBName"].ToString();
objDBNames.DBUser = System.Configuration.ConfigurationManager.AppSettings["DBUser"].ToString();
objDBNames.DBPassword = System.Configuration.ConfigurationManager.AppSettings["DBPassword"].ToString();
string path = AppDomain.CurrentDomain.BaseDirectory;//System.Reflection.Assembly.GetExecutingAssembly().Location;
objDBNames.XmlFilePath = path + "XMLFiles\\" + System.Configuration.ConfigurationManager.AppSettings["DBXmlFilePath"].ToString();
Globalized.ObjDbName = objDBNames;
if (Globalized.objAppPreference == null)
{
dsGeneral.dtAppPreferenceDataTable dtApp = iFacede.GetAppPreference(Globalized.ObjDbName, objAppPreference);
ObservableCollection <dhAppPreference> sequence = ReflectionUtility.DataTableToObservableCollection <dhAppPreference>(dtApp);
if (sequence.Count > 0)
{
objAppPreference = sequence[0];
//objAppPreference.ImgCompanyLogo = (System.Byte[])dtApp.Rows[0]["ImgCompanyLogo"];
objAppPreference.VEnableModules = string.IsNullOrEmpty(dtApp.Rows[0]["vEnableModules"].ToString()) ? "" : dtApp.Rows[0]["vEnableModules"].ToString();
objAppPreference.ImgCompanyLogo = !string.IsNullOrEmpty(dtApp.Rows[0]["imgCompanyLogo"].ToString()) ? (byte[])dtApp.Rows[0]["imgCompanyLogo"] : null;
objAppPreference.VCompanyName = !string.IsNullOrEmpty(dtApp.Rows[0]["vCompanyName"].ToString()) ? dtApp.Rows[0]["VCompanyName"].ToString() : null;
Globalized.objAppPreference = objAppPreference;
// cstmUtilities.LoadImage(Globalized.objAppPreference.ImgCompanyLogo, Image1);
// this.AppName.Text = String.IsNullOrEmpty(Globalized.objAppPreference.VApplicationName) ? "POS" : Globalized.objAppPreference.VApplicationName;
this.CompanyName.Text = String.IsNullOrEmpty(Globalized.objAppPreference.VCompanyName) ? "ABFA" : Globalized.objAppPreference.VCompanyName;
// ModernWindow Obj = (ModernWindow)Application.Current.MainWindow;
// Obj.Title = String.IsNullOrEmpty(Globalized.objAppPreference.VApplicationName) ? "POS" : Globalized.objAppPreference.VApplicationName;
////this.lblErrorMsg.Visibility = Visibility.Hidden;
////this.UserName.Text = "";
////this.Password.Password = "";
//= sequence;
}
else
{
Globalized.SetMsg("Application is Not Initialized Properly please contact support team. ", MsgType.Error);
// lblErrorMsg.Visibility = System.Windows.Visibility.Visible;
// Globalized.ShowMsg(lblErrorMsg);
}
}
//byte[] img = (byte[])objAppPreference.ImgCompanyLogo;
//MemoryStream str = new MemoryStream();
// str.Write(img, 0, img.Length);
// BitmapImage bit = new BitmapImage(str);
//byte[] objimg = (byte[])objAppPreference.ImgCompanyLogo;
//imgCompanyLogo.DataContext = ImageFromBytearray(objimg);
// byte[] bytImageDataBytes = objAppPreference.ImgCompanyLogo;
//// byte[] bytImageDataBytes = (byte[])objAppPreference.ImgCompanyLogo.;
// System.IO.MemoryStream ms = new System.IO.MemoryStream(bytImageDataBytes);
// ms.Seek(0, System.IO.SeekOrigin.Begin);
// BitmapImage newBitmapImage = new BitmapImage();
// newBitmapImage.BeginInit();
// newBitmapImage.StreamSource = ms;
// newBitmapImage.EndInit();
// imgCompanyLogo.Source = newBitmapImage;//ConvertToImage(objAppPreference.ImgCompanyLogo);
}
public DataSet InsertUpdateAccounts(dhDBnames objDBNames, dhAccount objAccounts)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateAccounts(objDBNames, objAccounts);
return(ds);
}
internal DataSet CheckItemInvoiced(dhDBnames objDBNames, dhInvoice objInvoice)
{
DataSet ds;
ds = objDALGeneral.CheckItemInvoiced(objDBNames, objInvoice);
return(ds);
}
public DataSet InsertUpdateParty(dhDBnames objDBNames, dhParty objParty)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateParty(objDBNames, objParty);
return(ds);
}
public DataSet InsertUpdateSalary(dhDBnames objDBNames, dhSalary objSalary)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateSalary(objDBNames, objSalary);
return(ds);
}
internal DataSet RemoveSaleInovice(dhDBnames dhDBnames, dhInvoice objInvoice)
{
DataSet ds;
ds = objDALGeneral.RemoveSaleInovice(dhDBnames, objInvoice);
return(ds);
}
public DataSet AddEditUser(dhDBnames objDBNames, dhUsers objUser)
{
DataSet ds;
ds = objDALGeneral.AddEditUser(objDBNames, objUser);
return(ds);
}
public dhUsers Authentication(dhDBnames objDBNames, dhUsers objUser)
{
dsGeneral.dtAppUserDataTable dt = objDALGeneral.GetUser(objDBNames, objUser);
if (dt.Rows.Count == 1)
{
ObservableCollection <dhUsers> sequence = ReflectionUtility.DataTableToObservableCollection <dhUsers>(dt);
if (sequence.Count > 0)
{
objUser = sequence[0];
}
objUser.LoginStatus = true;
//objUser.IUserid = Convert.ToInt32(dt.Rows[0]["iUserID"].ToString());
//objUser.VfName = dt.Rows[0]["vfName"].ToString();
//objUser.VlName = dt.Rows[0]["vlName"].ToString();
//objUser.DDOB = Convert.ToDateTime(dt.Rows[0]["dDOB"].ToString());
//objUser.VUserType = dt.Rows[0]["vUserType"].ToString();
//objUser.VLogin = dt.Rows[0]["vLogin"].ToString();
//objUser.VPassword = dt.Rows[0]["vPassword"].ToString();
}
else
{
objUser.LoginStatus = false;
}
return(objUser);
}
public DataSet InsertUpdateJournalDetail(dhDBnames objDBNames, dhJournalDetail objJournalDetail)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateJournalDetail(objDBNames, objJournalDetail);
return(ds);
}
public void RemoveItem(DataGrid objDataGrid, dhSaleItem objectToRemove, dhDBnames ObjDbName, bool?isDraft)
{
ItemsList updatedList = new ItemsList();
var row = blUtil.GetDataGridRows(objDataGrid);
foreach (DataGridRow r in row)
{
dhSaleItem gridRowObject = (dhSaleItem)r.Item;
updatedList.Add(gridRowObject);
}
//ftotalamountTextBox.Text = total.ToString();
if (isDraft == true)
{
blInvoice objblInovice = new blInvoice();
objectToRemove.BIsDraft = isDraft;
DataSet ds = objblInovice.RemoveSaleInoviceItem(ObjDbName, objectToRemove);
updatedList.Remove(objectToRemove);
//bl objblItems = null;
}
else
{
updatedList.Remove(objectToRemove);
}
objDataGrid.ItemsSource = updatedList;
}
internal DataSet InsertUpdateCostumer(dhDBnames objDBNames, dhCostumer objCostumer)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateCostumer(objDBNames, objCostumer);
return(ds);
}
public DataSet InsertUpdateSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateSaleInovice(objDBNames, objInvoice);
return(ds);
}
public DataSet InsertUpdateEmployee(dhDBnames objDBNames, dhEmployee objEmployee)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateEmployee(objDBNames, objEmployee);
return(ds);
}
//= null ;
static Globalized()
{
ObjCurrentUser = null;
ObjDbName = null;
GlobalMsg = new AppMassage();
ObjPrefernce = new dhPreference();
}
internal DataSet InsertUpdateAppPreference(dhDBnames objDBNames, dhAppPreference objPreference)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateAppPreference(objDBNames, objPreference);
return(ds);
}
internal DataSet InsertUpdateStock(dhDBnames objDBNames, dhItemStock objStock)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateStock(objDBNames, objStock);
return(ds);
}
public DataTable GetTransactionsList(dhDBnames objDBNames, dhTransactionList objTransactionsList)
{
// dsGeneral ds = new dsGeneral();
DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objTransactionsList, "xmlGetTransactionsList");
return(dsreturn.Tables.Count > 0 ? dsreturn.Tables[0] : null);
}
internal ObservableCollection <dhModule> GetUserSubMenu(dhDBnames objDBNames, dhAppPreference objAppPreference, dhUsers objuser, dhModule objdhModule)
{
DataTable temp = new DataTable();
blModule ObjblModule = new blModule();
dhModule objModule = new dhModule();
ObservableCollection <dhModule> MenuModule = new ObservableCollection <dhModule>();
if ((objAppPreference != null) && (objAppPreference.VEnableModules != "") && (objuser != null))
{
#region "Allowed Menu"
objModule.AllowdModule = objAppPreference.VEnableModules;
dsGeneral.dtPosModuleDataTable dtm = ObjblModule.GetModule(objDBNames, objModule);
EnumerableRowCollection <dsGeneral.dtPosModuleRow> result2 = from r in dtm.AsEnumerable()
where (r.Field <int>("iModuleParentID") == objdhModule.IModuleID) && (r.Field <bool>("bIsActive") == true)
select r;
// if there are any allowed
int CountRow = result2.Count <dsGeneral.dtPosModuleRow>();
if (CountRow > 0)
{
DataTable dtResult2 = result2.CopyToDataTable();
ObservableCollection <dhModule> sequence = ReflectionUtility.DataTableToObservableCollection <dhModule>(dtResult2);
if (sequence.Count > 0)
{
foreach (dhModule Module in sequence)
{
string strDisplayName = Module.VDisplayName;
if (objuser.VAllowdModule == null)
{
if (objuser.VUserType == "Super")
{
objuser.VAllowdModule = objAppPreference.VEnableModules;
}
else
{
throw new ApplicationException("Disable User or have no rights.");
}
}
List <string> RootIds = objuser.VAllowdModule.Split(',').ToList <string>();
string RootAllowdUserID = RootIds.Distinct <string>().Cast <string>().Where(i => i.Equals(Module.IModuleID.ToString())).SingleOrDefault();
List <string> RootEnableModulesIds = objAppPreference.VEnableModules.Split(',').ToList <string>();
string RootAppEnableModulesId = RootEnableModulesIds.Distinct <string>().Cast <string>().Where(i => i.Equals(Module.IModuleID.ToString())).SingleOrDefault();
if ((RootAllowdUserID == null) || (RootAppEnableModulesId == null))
{
continue;
}
MenuModule.Add(Module);
}
}// end of dhModule sequence
}
#endregion
}
return(MenuModule);
}
public void GetSaleMan(dhDBnames objDBNames, dhSaleMan objSaleMan, ComboBox objSaleManList)
{
dsGeneral.dtPosSaleManDataTable dt = objDALGeneral.GetSaleMan(objDBNames, objSaleMan);
objSaleManList.ItemsSource = dt;
objSaleManList.DisplayMemberPath = "vSaleManName";
objSaleManList.SelectedValuePath = "iSaleManID";
}
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);
}
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.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.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);
}
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);
}
/// <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.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);
}
