private void loadData()
{
// get data
dsGeneral.dtAppPreferenceDataTable dt = iFacede.GetAppPreference(Globalized.ObjDbName, GlobalObjPreference);
// intialize object
if (dt.Rows.Count > 0)
{
ObservableCollection <dhAppPreference> listItem = ReflectionUtility.DataTableToObservableCollection <dhAppPreference>(dt);
if (listItem.Count > 0)
{
GlobalObjPreference = listItem.Cast <dhAppPreference>().SingleOrDefault();
GlobalObjPreference.IUpdate = 1;
// GlobalObjPreference.ImgCompanyLogo =(byte[])dt.Rows[0]["imgCompanyLogo"];
GlobalObjPreference.ImgCompanyLogo = !string.IsNullOrEmpty(dt.Rows[0]["imgCompanyLogo"].ToString()) ? (byte[])dt.Rows[0]["imgCompanyLogo"] : null;
GlobalObjPreference.VCompanyName = !string.IsNullOrEmpty(dt.Rows[0]["vCompanyName"].ToString()) ? dt.Rows[0]["VCompanyName"].ToString() : null;
GlobalObjPreference.VHeaderAdress = !string.IsNullOrEmpty(dt.Rows[0]["vHeaderAdress"].ToString()) ? dt.Rows[0]["vHeaderAdress"].ToString() : null;
GlobalObjPreference.VCompanyMobile = !string.IsNullOrEmpty(dt.Rows[0]["vCompanyMobile"].ToString()) ? dt.Rows[0]["vCompanyMobile"].ToString() : null;
// VSaleType.SelectedItem = GlobalObjPreference.VSaleType;
this.DataContext = GlobalObjPreference;
cstmUtilities.LoadImage(GlobalObjPreference.ImgCompanyLogo, image1);
//VSaleType.SelectedValue = GlobalObjPreference.VSaleType;
//Globalized.ObjPrefernce = GlobalObjPreference;
}
}
else
{
GlobalObjPreference.IUpdate = 0;
GlobalObjPreference = new dhAppPreference();
this.DataContext = GlobalObjPreference;
}
Globalized.ShowMsg(lblErrorMsg);
//Globalized.SetMsg(null);
}
internal DataSet InsertUpdateAppPreference(dhDBnames objDBNames, dhAppPreference objPreference)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateAppPreference(objDBNames, objPreference);
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 ObservableCollection <dhModule> GetUserMenu(dhDBnames objDBNames, dhAppPreference objAppPreference, dhUsers objuser = null)
{
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") == 0) && (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 grpkey = "POS"; //Module.VModuleName;
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 static DataSet InsertUpdateAppPreference(dhDBnames objDBNames, dhAppPreference objPreference)
{
try
{
DataSet var_ret;
if (objBLAppPreference == null)
{
objBLAppPreference = new blAppPreference();
}
var_ret = objBLAppPreference.InsertUpdateAppPreference(objDBNames, objPreference);
return(var_ret);
}
catch (Exception ex) { throw ex; }
}
public static ObservableCollection <dhModule> GetUserMenu(dhDBnames objDBNames = null, dhAppPreference objAppPreference = null, dhUsers objuser = null)
{
try
{
if (objBLUser == null)
{
objBLUser = new blUser();
}
return(objBLUser.GetUserMenu(objDBNames, objAppPreference, objuser));
}
catch (Exception ex) { throw ex; }
}
public static ObservableCollection <dhModule> GetUserSubMenu(dhDBnames objDbName, dhAppPreference objAppPreference, dhUsers objCurrentUser, dhModule objdhModule)
{
try
{
if (objBLUser == null)
{
objBLUser = new blUser();
}
return(objBLUser.GetUserSubMenu(objDbName, objAppPreference, objCurrentUser, objdhModule));
}
catch (Exception ex) { throw ex; }
}
public static dsGeneral.dtAppPreferenceDataTable GetAppPreference(dhDBnames objDBNames, dhAppPreference objPreference)
{
try
{
dsGeneral.dtAppPreferenceDataTable var_ret = null;
if (objBLAppPreference == null)
{
objBLAppPreference = new blAppPreference();
}
{
var_ret = objBLAppPreference.GetAppPreference(objDBNames, objPreference);
}
return(var_ret);
}
catch (Exception ex) { throw ex; }
}
public static void printDoc(string TemplateName, DataSet ReportDatatables, String ReportName, Boolean ShowPreview = false, string ReportDisc = null)
{
//DocumentViewer docview1,
try
{
ReportDocument reportDocument = new ReportDocument();
StreamReader reader = new StreamReader(new FileStream(@"Templates\" + TemplateName, FileMode.Open, FileAccess.Read));
reportDocument.XamlData = reader.ReadToEnd();
reportDocument.XamlImagePath = Path.Combine(Environment.CurrentDirectory, @"Templates\");
reader.Close();
ReportData data = new ReportData();
// Add tables to report Data
foreach (DataTable DT in ReportDatatables.Tables)
{
//if (DT.Rows.Count < 10)
//{
// DataRow abc = null;
// DT.Rows.Add(abc);
// DT.Rows.Add(abc);
// DT.Rows.Add(abc);
// DT.Rows.Add(abc);
//}
data.DataTables.Add(DT);
}
data.ReportDocumentValues.Add("PrintDate", DateTime.Now); // print date is now
dhAppPreference obj = new dhAppPreference();
dsGeneral.dtAppPreferenceDataTable dt = iFacede.GetAppPreference(Globalized.ObjDbName, obj);
data.DataTables.Add(dt);
DateTime dateTimeStart = DateTime.Now; // start time measure here
data.ReportDocumentValues.Add("ReportDisc", ReportDisc);
XpsDocument xps = reportDocument.CreateXpsDocument(data);
// chek have to show or not
if (!ShowPreview)
{
PrintDialog dlg = new PrintDialog();
dlg.PrintDocument(xps.GetFixedDocumentSequence().DocumentPaginator, ReportName);
}
else
{
PrintPreview objPre = new PrintPreview();
objPre.docview1.Document = xps.GetFixedDocumentSequence();
Window window = new Window
{
Title = "Print Preview",
Content = objPre,
Height = 800, // just added to have a smaller control (Window)
Width = 750
};
window.ShowDialog();
}
}
catch (Exception ex)
{
// show exception
MessageBox.Show(ex.Message + "\r\n\r\n" + ex.GetType() + "\r\n" + ex.StackTrace, ex.GetType().ToString(), MessageBoxButton.OK, MessageBoxImage.Stop);
}
}
private void InsertUpdatePreference()
{
//FileStream fs = new FileStream(txtFileName.Text.ToString(), FileMode.Open, FileAccess.Read);
////Initialize a byte array with size of stream
//byte[] imgByteArr = new byte[fs.Length];
////Read data from the file stream and put into the byte array
//fs.Read(imgByteArr, 0, Convert.ToInt32(fs.Length));
//fs.Close();
GetAllowdModule();
dhAppPreference objInsert = new dhAppPreference();
objInsert = (dhAppPreference)this.DataContext;
if (image1.Source != null)
{
byte[] imgByteArr = null;
if ((image1.Source.Width > 250) || (image1.Source.Height > 100)) //(!ValidFile(image1.Source, 250, 100))
{
BitmapFrame bframe = CreateResizedImage(image1.Source, 250, 150, 0);
JpegBitmapEncoder encoder = new JpegBitmapEncoder();
// encoder.Frames.Add(abc);
encoder.QualityLevel = 100;
imgByteArr = new byte[0];
using (MemoryStream stream = new MemoryStream())
{
encoder.Frames.Add(bframe);
encoder.Save(stream);
imgByteArr = stream.ToArray();
stream.Close();
}
}
else
{
BitmapFrame bframe = CreateResizedImage(image1.Source, Convert.ToInt32(image1.Source.Width), Convert.ToInt32(image1.Source.Height), 0);
JpegBitmapEncoder encoder = new JpegBitmapEncoder();
// encoder.Frames.Add(abc);
encoder.QualityLevel = 100;
imgByteArr = new byte[0];
using (MemoryStream stream = new MemoryStream())
{
encoder.Frames.Add(bframe);
encoder.Save(stream);
imgByteArr = stream.ToArray();
stream.Close();
}
}
objInsert.ImgCompanyLogo = imgByteArr;
}
else
{
objInsert.ImgCompanyLogo = null;
}
dhAppPreferenceValidator validator = new dhAppPreferenceValidator();
FluentValidation.Results.ValidationResult results = validator.Validate(objInsert);
bool validationSucceeded = results.IsValid;
IList <ValidationFailure> failures = results.Errors;
if (validationSucceeded)
{
DataSet ds = iFacede.InsertUpdateAppPreference(Globalized.ObjDbName, objInsert);
if (ds.Tables[0].Rows.Count > 0)
{
System.Media.SystemSounds.Beep.Play();
lblErrorMsg.Visibility = Visibility.Hidden;
Globalized.SetMsg("Setting Saved successfully.", MsgType.Info);
loadData();
// ModernWindow Obj = (ModernWindow)Application.Current.MainWindow;
// Obj.ContentSource = new Uri("/Pages/Setting/Setting.xaml", UriKind.Relative);
}
}
else
{
throw new ApplicationException(failures.First().ErrorMessage);
}
}
internal dsGeneral.dtAppPreferenceDataTable GetAppPreference(dhDBnames objDBNames, dhAppPreference objPreference)
{
dsGeneral.dtAppPreferenceDataTable dt = objDALGeneral.GetAppPreference(objDBNames, objPreference);
return(dt);
}
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 DataSet InsertUpdateAppPreference(dhDBnames objDBNames, dhAppPreference objPreference)
{
DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objPreference, "xmlInsertUpdateAppPreference");
return(dsreturn);
}
