void ReadBasicRadioChannels()
{
if (File.Exists("RadioChannels/RadioChannels.txt"))
{
StreamReader sr = new StreamReader("RadioChannels/Radiochannels.txt", System.Text.Encoding.UTF8);
try
{
while (!sr.EndOfStream)
{
string row = sr.ReadLine().Trim();
string rowStreamLink = row.Split(';')[0].Trim();
string rowChannelName = row.Split(';')[1].Trim();
if (!WPE.Radio.Any(x => x.UserID.Equals(ActualUser.IDLogin) && x.StreamLink.Trim().Equals(rowStreamLink.Trim()) && x.ChannelName.Trim().Equals(rowChannelName.Trim())))
{
Models.Radio r = new Models.Radio();
r.UserID = ActualUser.IDLogin;
r.StreamLink = row.Split(';')[0].Trim();
r.ChannelName = row.Split(';')[1].Trim();
WPE.Radio.Add(r);
}
}
sr.Close();
WPE.SaveChanges();
}
catch (Exception ex)
{
sr.Close();
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem("Error", ex.Message, PackIconKind.Error);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, false);
msb.Show();
}
}
}
internal void DeleteExpense(object sender, System.Windows.Input.MouseButtonEventArgs e)
{
int id = 0;
Int32.TryParse((sender as PackIcon).DataContext.ToString(), out id);
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem((rm as ResourceManager).GetString("Message_Delete_Title"), (rm as ResourceManager).GetString("Message_DeleteExp"), PackIconKind.WarningCircle);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, true);
if (msb.ShowDialog() == true)
{
if (WPE.WeddingExpenses.Any(x => x.ID.Equals(id)))
{
WPE.Dispose();
WPE = new Models.WeddingPlannerEntities();
var ex = new Models.WeddingExpenses {
ID = id
};
WPE.WeddingExpenses.Attach(ex);
WPE.WeddingExpenses.Remove(ex);
WPE.SaveChanges();
CreateExpenseList((rm as ResourceManager));
}
}
}
void DeletePicture(int id)
{
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem((rm as ResourceManager).GetString("Message_Delete_Title"), (rm as ResourceManager).GetString("Message_DeletePics"), PackIconKind.WarningCircle);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, true);
if (msb.ShowDialog() == true)
{
System.Windows.Input.Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;
if (WPE.WeddingVenueImages.Any(x => x.ID.Equals(id)))
{
WPE.Dispose();
WPE = new Models.WeddingPlannerEntities();
Models.WeddingVenueImages wvi = WPE.WeddingVenueImages.FirstOrDefault(x => x.ID.Equals(id));
WPE.WeddingVenueImages.Attach(wvi);
WPE.WeddingVenueImages.Remove(wvi);
WPE.SaveChanges();
int delindex = p.FindIndex(x => x.ID.Equals(wvi.ID));
p.Remove(p.FirstOrDefault(x => x.ID.Equals(wvi.ID)));
Bitimages.RemoveAt(delindex);
PicsBox.ItemsSource = null;
PicsBox.ItemsSource = p;
}
}
System.Windows.Input.Mouse.OverrideCursor = null;
}
void insertImageData(string[] imageNames)
{
try
{
if (imageNames != null)
{
System.Windows.Input.Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;
FileStream fs = null;
for (int i = 0; i < imageNames.Length; i++)
{
fs = new FileStream(imageNames[i], FileMode.Open, FileAccess.Read);
byte[] imgByteArr = new byte[fs.Length];
fs.Read(imgByteArr, 0, Convert.ToInt32(fs.Length));
Models.WeddingVenueImages wvi = new Models.WeddingVenueImages();
wvi.WeddingVenueID = VenueIDs[CB_Venue.SelectedIndex];
wvi.Image = imgByteArr;
wvi.ImageName = imageNames[i].Split(new[] { @"\" }, StringSplitOptions.None).Last();
WPE.WeddingVenueImages.Add(wvi);
WPE.SaveChanges();
}
fs.Close();
ShowPics((rm as ResourceManager));
System.Windows.Input.Mouse.OverrideCursor = null;
}
}
catch (Exception ex)
{
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem("Error", ex.Message, PackIconKind.Error);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, false);
msb.Show();
System.Windows.Input.Mouse.OverrideCursor = null;
}
}
internal void DeleteCLick(object sender, System.Windows.Input.MouseButtonEventArgs e)
{
int id = 0;
Int32.TryParse((string)(sender as PackIcon).DataContext, out id);
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem((rm as ResourceManager).GetString("Message_Delete_Title"), (rm as ResourceManager).GetString("Message_DeleteContact"), PackIconKind.WarningCircle);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, true);
if (msb.ShowDialog() == true)
{
if (WPE.Contacts.FirstOrDefault(x => x.Con_ID.Equals(id)) != null)
{
WPE.Dispose();
WPE = new Models.WeddingPlannerEntities();
var cont = new Models.Contacts {
Con_ID = id
};
WPE.Contacts.Attach(cont);
WPE.Contacts.Remove(cont);
WPE.SaveChanges();
CreateContactList();
}
}
}
void LoadDayEntrys()
{
try
{
if (calendarEdit.SelectedDate.Value != null)
{
Models.Calendar c = CalArray.FirstOrDefault(x => x.UserID.Equals(ActualUser.IDLogin) && x.Date.Equals(calendarEdit.SelectedDate.Value));
if (c != null && FrameContent != null)
{
FrameContent.Content = new Pages.CalendarItems(c, rm, ResourceNames, this);
}
else if (FrameContent != null)
{
c = new Models.Calendar();
c.Date = calendarEdit.SelectedDate.Value;
c.UserID = ActualUser.IDLogin;
FrameContent.Content = new Pages.CalendarItems(c, rm, ResourceNames, this);
}
}
}
catch (Exception ex)
{
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem("Error", ex.Message, PackIconKind.Error);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, false);
msb.Show();
}
}
void DownloadPicture(int id)
{
System.Windows.Input.Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;
SaveFileDialog dialog = new SaveFileDialog();
dialog.FileName = p.FirstOrDefault(x => x.ID.Equals(id)).Title;
dialog.Filter = "Jpeg Image(.jpeg) | *.jpeg |Png Image(.png) | *.png |Bitmap Image (.bmp) | *.bmp |Gif Image(.gif) | *.gif |Tiff Image(.tiff) | *.tiff |Wmf Image(.wmf) | *.wmf";
dialog.DefaultExt = "jpeg";
if (dialog.ShowDialog() == true)
{
BitmapImage drawImage = Bitimages[p.FindIndex(x => x.ID.Equals(id))];
MemoryStream outStream = new MemoryStream();
BitmapEncoder enc = new BmpBitmapEncoder();
enc.Frames.Add(BitmapFrame.Create(drawImage));
enc.Save(outStream);
System.Drawing.Bitmap bitmap = new System.Drawing.Bitmap(outStream);
System.Drawing.Imaging.ImageFormat iformat;
switch (dialog.FilterIndex)
{
case 1:
iformat = System.Drawing.Imaging.ImageFormat.Jpeg;
break;
case 2:
iformat = System.Drawing.Imaging.ImageFormat.Png;
break;
case 3:
iformat = System.Drawing.Imaging.ImageFormat.Bmp;
break;
case 4:
iformat = System.Drawing.Imaging.ImageFormat.Gif;
break;
case 5:
iformat = System.Drawing.Imaging.ImageFormat.Tiff;
break;
case 6:
iformat = System.Drawing.Imaging.ImageFormat.Wmf;
break;
default:
iformat = System.Drawing.Imaging.ImageFormat.Jpeg;
break;
}
bitmap.Save(dialog.FileName, iformat);
ViewModel.WinMessageBoxItem wmsgbi = new ViewModel.WinMessageBoxItem((rm as ResourceManager).GetString("MessageBoxSaveTitle"), (rm as ResourceManager).GetString("MessageBoxSaveText"), MaterialDesignThemes.Wpf.PackIconKind.InformationCircle);
Windows.WinMessageBox wmsg = new Windows.WinMessageBox(wmsgbi, (rm as ResourceManager), ResourceNames, false);
wmsg.Show();
}
System.Windows.Input.Mouse.OverrideCursor = null;
}
internal void Exit_Click(object sender, RoutedEventArgs e)
{
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem(rm.GetString("ExitWarning"), rm.GetString("Exit"), PackIconKind.QuestionMarkRhombus);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, true);
if (msb.ShowDialog() == true)
{
System.Windows.Application.Current.Shutdown();
}
}
internal void Back_Click(object sender, RoutedEventArgs e)
{
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem(rm.GetString("Message_LogoutTitle"), rm.GetString("Message_LogoutText"), PackIconKind.QuestionMarkRhombus);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, true);
if (msb.ShowDialog() == true)
{
main.RadioPlayerStop();
MainWindow m = new MainWindow(ResourceNames, Hun, sound);
m.Show();
this.Close();
}
}
public WinMessageBox(ViewModel.WinMessageBoxItem WMsbI, ResourceManager _rm, string[] _ResourceNames, bool?IsYesNo)
{
InitializeComponent();
rm = _rm;
ResourceNames = _ResourceNames;
this.DataContext = WMsbI;
if (IsYesNo == false || IsYesNo == null)
{
BT_Yes.Visibility = Visibility.Hidden;
BT_No.Visibility = Visibility.Hidden;
BT_Ok.Visibility = Visibility.Visible;
}
}
void DeleteVenueAndPictures()
{
if (CB_Venue.SelectedIndex > -1)
{
int VenID = VenueIDs[CB_Venue.SelectedIndex];
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem((rm as ResourceManager).GetString("Message_Delete_Title"), (rm as ResourceManager).GetString("Message_DeleteVenue"), PackIconKind.WarningCircle);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, true);
if (msb.ShowDialog() == true)
{
if (WPE.WeddingVenue.Any(x => x.ID.Equals(VenID)))
{
WPE.Dispose();
WPE = new Models.WeddingPlannerEntities();
var ven = new Models.WeddingVenue {
ID = VenID
};
if (WPE.WeddingExpenses.Any(x => x.VenueID.Equals(ven.ID)))
{
wmsb = new ViewModel.WinMessageBoxItem((rm as ResourceManager).GetString("Message_Delete_Title"), (rm as ResourceManager).GetString("Message_DeleteExpense"), PackIconKind.WarningCircle);
msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, null);
if (msb.ShowDialog() == true)
{
WPE.WeddingExpenses.RemoveRange(WPE.WeddingExpenses.Where(X => X.VenueID.Equals(ven.ID)));
WPE.SaveChanges();
}
else
{
return;
}
}
if (WPE.WeddingVenueImages.Any(x => x.WeddingVenueID.Equals(ven.ID)))
{
WPE.WeddingVenueImages.RemoveRange(WPE.WeddingVenueImages.Where(x => x.WeddingVenueID.Equals(ven.ID)));
WPE.SaveChanges();
}
WPE.WeddingVenue.Attach(ven);
WPE.WeddingVenue.Remove(ven);
p.Clear();
Bitimages.Clear();
WPE.SaveChanges();
CB_Reload();
}
}
}
}
internal System.Net.IPAddress GetIPAddress(System.Resources.ResourceManager rm, string[] ResourceNames)
{
System.Net.IPAddress[] hostAddresses = System.Net.Dns.GetHostAddresses("");
foreach (System.Net.IPAddress hostAddress in hostAddresses)
{
if (hostAddress.AddressFamily == System.Net.Sockets.AddressFamily.InterNetwork &&
!System.Net.IPAddress.IsLoopback(hostAddress) &&
!hostAddress.ToString().StartsWith("169.254."))
{
return(hostAddress);
}
}
ViewModel.WinMessageBoxItem wmgbi = new ViewModel.WinMessageBoxItem(rm.GetString("Message_InternetConnectionTitle"), rm.GetString("Message_InternetConnection"), MaterialDesignThemes.Wpf.PackIconKind.MicrosoftInternetExplorer);
WinMessageBox wmsgb = new WinMessageBox(wmgbi, rm, ResourceNames, false);
wmsgb.Show();
return(null);
}
void Tooltip_Delete_PreviewMouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem((rm as ResourceManager).GetString("Message_Delete_Title"), (rm as ResourceManager).GetString("Message_DeleteRadioChannel"), MaterialDesignThemes.Wpf.PackIconKind.WarningCircle);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, true);
if (msb.ShowDialog() == true)
{
int indexofChannel = CB_RadioList.SelectedIndex;
Models.Radio rad = RadioStuffs[indexofChannel];
WPE.Radio.Attach(rad);
WPE.Radio.Remove(rad);
WPE.SaveChanges();
CB_Reload();
if (CB_RadioList.Items.Count > 0)
{
CB_RadioList.SelectedIndex = indexofChannel > 0 ? indexofChannel - 1 : 0;
h.Tbl_Radio.Text = "♫ " + RadioStuffs[CB_RadioList.SelectedIndex].ChannelName.Trim() + " ♫";
}
}
}
void BrowsePictures()
{
try
{
OpenFileDialog fldlg = new OpenFileDialog();
fldlg.Multiselect = true;
fldlg.InitialDirectory = Environment.SpecialFolder.MyPictures.ToString();
fldlg.Filter = (rm as ResourceManager).GetString("Dialog_ImageFiles") + "(*.jpg; *.jpeg; *.png; *.gif; *.bmp)| *.jpg; *.jpeg; *.png; *.gif; *.bmp";
if (fldlg.ShowDialog() == true)
{
insertImageData(fldlg.FileNames);
}
fldlg = null;
}
catch (Exception ex)
{
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem("Error", ex.Message, PackIconKind.Error);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, false);
msb.Show();
}
}
internal bool IsFileLocked(FileInfo file, System.Resources.ResourceManager rm, string[] ResourceNames)
{
try
{
if (File.Exists(file.FullName))
{
using (FileStream stream = file.Open(FileMode.Open, FileAccess.Read, FileShare.None))
{
stream.Close();
}
}
}
catch (IOException)
{
ViewModel.WinMessageBoxItem wmsgi = new ViewModel.WinMessageBoxItem((rm as System.Resources.ResourceManager).GetString("Message_FileIsOpenTitle"), (rm as System.Resources.ResourceManager).GetString("Message_FileIsOpenText"), MaterialDesignThemes.Wpf.PackIconKind.WarningLights);
Windows.WinMessageBox wmsgb = new WinMessageBox(wmsgi, rm, ResourceNames, false);
wmsgb.Show();
return(true);
}
return(false);
}
internal void BrowsePictures()
{
try
{
OpenFileDialog fldlg = new OpenFileDialog();
fldlg.InitialDirectory = Environment.SpecialFolder.MyPictures.ToString();
fldlg.Filter = (rm as ResourceManager).GetString("Dialog_ImageFiles") + "(*.jpg; *.jpeg; *.png; *.gif; *.bmp)| *.jpg; *.jpeg; *.png; *.gif; *.bmp";
if (fldlg.ShowDialog() == true)
{
System.Windows.Input.Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;
System.IO.FileStream fs = null;
fs = new System.IO.FileStream(fldlg.FileName, System.IO.FileMode.Open, System.IO.FileAccess.Read);
byte[] imgByteArr = new byte[fs.Length];
fs.Read(imgByteArr, 0, Convert.ToInt32(fs.Length));
h.ImageBetrothed.Source = f.CreateBitmapFromBytes(imgByteArr);
if (wedd != null)
{
Models.WeddingData wd = wedd;
wd.Image = imgByteArr;
WPE.SaveChanges();
}
BetrothedImage = imgByteArr;
fs.Close();
fldlg = null;
System.Windows.Input.Mouse.OverrideCursor = null;
}
fldlg = null;
}
catch (Exception ex)
{
System.Windows.Input.Mouse.OverrideCursor = null;
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem("Error", ex.Message, MaterialDesignThemes.Wpf.PackIconKind.Error);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, false);
msb.Show();
}
}
internal void DeleteCLick(object sender, System.Windows.Input.MouseButtonEventArgs e)
{
int id = 0;
Int32.TryParse((string)(sender as PackIcon).DataContext, out id);
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem((rm as ResourceManager).GetString("Message_Delete_Title"), (rm as ResourceManager).GetString("Message_Delete"), PackIconKind.WarningCircle);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), Resourcenames, true);
if (msb.ShowDialog() == true)
{
if (WPE.CalendarLogEntrys.Any(x => x.ID.Equals(id)))
{
WPE.Dispose();
WPE = new Models.WeddingPlannerEntities();
var Logentry = WPE.CalendarLogEntrys.FirstOrDefault(x => x.ID.Equals(id));
WPE.CalendarLogEntrys.Attach(Logentry);
WPE.CalendarLogEntrys.Remove(Logentry);
WPE.SaveChanges();
if (!WPE.CalendarLogEntrys.Any(x => x.CalID.Equals(Logentry.CalID)))
{
var cal = WPE.Calendar.FirstOrDefault(x => x.ID.Equals(Logentry.CalID));
WPE.Calendar.Attach(cal);
WPE.Calendar.Remove(cal);
WPE.SaveChanges();
int Userid = Cal.UserID;
DateTime Date = Cal.Date;
Cal = new Models.Calendar();
Cal.ID = 0;
Cal.UserID = Userid;
Cal.Date = Date;
}
CreateList();
}
}
}
void CreateExcelDocument()
{
System.Windows.Input.Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbooks xlWorkBooks = xlApp.Workbooks;
Microsoft.Office.Interop.Excel.Workbook xlWorkBook = xlWorkBooks.Add(1);
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
try
{
xlWorkSheet.Name = (rm as ResourceManager).GetString("LB_Expenses");
xlWorkSheet.Cells[1, 1] = exitems[CB_Offer.SelectedIndex].Venue.Trim() + " - " + exitems[CB_Offer.SelectedIndex].Address.Trim();
Microsoft.Office.Interop.Excel.Range formatRange = xlWorkSheet.get_Range("A1", "D1");
formatRange.Font.Bold = true;
formatRange.WrapText = true;
xlWorkSheet.Range["a1", "D1"].Merge();
string rang = "A1:" + "D" + (expList.Count + 3);
xlWorkSheet.get_Range(rang).Cells.Font.Name = "Comic Sans MS";
xlWorkSheet.Range[rang].Font.Size = 16;
xlWorkSheet.Range[rang].Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Pink);
xlWorkSheet.Range[rang].Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
xlWorkSheet.Range[rang].Borders.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);
formatRange = xlWorkSheet.get_Range(rang);
formatRange.BorderAround(Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous,
Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic,
Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic);
xlWorkSheet.Range[rang].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
xlWorkSheet.Range[rang].VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
xlWorkSheet.Cells[2, 1] = LB_Expense.Content;
xlWorkSheet.Cells[2, 2] = LB_Cost.Content;
xlWorkSheet.Cells[2, 3] = LB_Count.Content;
xlWorkSheet.Cells[2, 4] = (rm as ResourceManager).GetString("LB_Amount");
int sum = 0;
for (int i = 0; i < expList.Count; i++)
{
xlWorkSheet.Cells[3 + i, 1] = expList[i].ExpenseName.Trim();;
xlWorkSheet.Cells[3 + i, 2] = f.StringCurrencyFormat(expList[i].Expense.ToString());
xlWorkSheet.Cells[3 + i, 3] = f.StringCurrencyFormat(expList[i].Count.ToString());
xlWorkSheet.Cells[3 + i, 4] = f.StringCurrencyFormat((expList[i].Expense * expList[i].Count).ToString());
xlWorkSheet.Cells[3 + i, 2].NumberFormat = "0";
xlWorkSheet.Cells[3 + i, 3].NumberFormat = "0";
xlWorkSheet.Cells[3 + i, 4].NumberFormat = "0";
sum += expList[i].Expense * expList[i].Count;
}
xlWorkSheet.Range["A" + (expList.Count + 3), "C" + (expList.Count + 3)].Merge();
xlWorkSheet.Cells[expList.Count + 3, 1] = (rm as ResourceManager).GetString("LB_Amount");
xlWorkSheet.Cells[expList.Count + 3, 4] = f.StringCurrencyFormat(sum.ToString());
xlWorkSheet.get_Range(rang).Columns.AutoFit();
rang = "A" + (expList.Count + 3) + ":" + "D" + (expList.Count + 3);
formatRange = xlWorkSheet.get_Range(rang);
formatRange.BorderAround(Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous,
Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic,
Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic);
xlWorkSheet.Range[rang].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
xlWorkSheet.Range[rang].VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
xlApp.DisplayAlerts = false;
Microsoft.Win32.SaveFileDialog saveFileDialog = new Microsoft.Win32.SaveFileDialog();
int venlenght = exitems[CB_Offer.SelectedIndex].Venue.Length;
int addlenght = exitems[CB_Offer.SelectedIndex].Address.Length;
saveFileDialog.FileName = (rm as ResourceManager).GetString("LB_Expenses") + "_" + exitems[CB_Offer.SelectedIndex].Venue.Substring(0, venlenght < 15 ? venlenght:15) + "_" + exitems[CB_Offer.SelectedIndex].Address.Substring(0, addlenght < 15 ? addlenght:15);
saveFileDialog.Filter = (rm as ResourceManager).GetString("SaveFileDialogFilter");
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.Title = (rm as ResourceManager).GetString("SaveFileDialogTitle");
if (saveFileDialog.ShowDialog() == true)
{
System.IO.FileInfo file = new System.IO.FileInfo(saveFileDialog.FileName);
if (f.IsFileLocked(file, (rm as ResourceManager), ResourceNames) == false)
{
xlWorkBook.SaveAs(saveFileDialog.FileName);
ViewModel.WinMessageBoxItem wmsgbi = new ViewModel.WinMessageBoxItem((rm as ResourceManager).GetString("MessageBoxSaveTitle"), (rm as ResourceManager).GetString("MessageBoxSaveText"), MaterialDesignThemes.Wpf.PackIconKind.InformationCircle);
Windows.WinMessageBox wmsg = new Windows.WinMessageBox(wmsgbi, (rm as ResourceManager), ResourceNames, false);
wmsg.Show();
}
}
xlWorkBook.Close(false, Type.Missing, Type.Missing);
xlApp.Quit();
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkSheet);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkBook);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlApp);
}
catch (Exception ex)
{
System.Windows.Input.Mouse.OverrideCursor = null;
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem("Error", ex.Message, MaterialDesignThemes.Wpf.PackIconKind.Error);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, false);
msb.Show();
xlWorkBook.Close(false, Type.Missing, Type.Missing);
xlApp.Quit();
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkSheet);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkBook);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlApp);
}
System.Windows.Input.Mouse.OverrideCursor = null;
}
void DownloadAllVenuePicture()
{
if (CB_Venue.SelectedIndex > -1)
{
SaveFileDialog dialog = new SaveFileDialog();
int venid = VenueIDs[CB_Venue.SelectedIndex];
string folder = Venues.FirstOrDefault(x => x.ID.Equals(venid)).Wedding_Venue.Trim();
dialog.FileName = folder.Split('.')[0];
dialog.Filter = "Jpeg Image(.jpeg) | *.jpeg |Png Image(.png) | *.png |Bitmap Image (.bmp) | *.bmp |Gif Image(.gif) | *.gif |Tiff Image(.tiff) | *.tiff |Wmf Image(.wmf) | *.wmf";
dialog.DefaultExt = "Jpeg";
if (dialog.ShowDialog() == true)
{
System.Windows.Input.Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;
System.Drawing.Imaging.ImageFormat iformat;
switch (dialog.FilterIndex)
{
case 1:
iformat = System.Drawing.Imaging.ImageFormat.Jpeg;
break;
case 2:
iformat = System.Drawing.Imaging.ImageFormat.Png;
break;
case 3:
iformat = System.Drawing.Imaging.ImageFormat.Bmp;
break;
case 4:
iformat = System.Drawing.Imaging.ImageFormat.Gif;
break;
case 5:
iformat = System.Drawing.Imaging.ImageFormat.Tiff;
break;
case 6:
iformat = System.Drawing.Imaging.ImageFormat.Wmf;
break;
default:
iformat = System.Drawing.Imaging.ImageFormat.Jpeg;
break;
}
for (int i = 0; i < Bitimages.Count; i++)
{
if (!File.Exists(dialog.FileName.Split('.')[0]))
{
System.IO.Directory.CreateDirectory(dialog.FileName.Split('.')[0]);
}
BitmapImage drawImage = Bitimages[i];
MemoryStream outStream = new MemoryStream();
BitmapEncoder enc = new BmpBitmapEncoder();
enc.Frames.Add(BitmapFrame.Create(drawImage));
enc.Save(outStream);
System.Drawing.Bitmap bitmap = new System.Drawing.Bitmap(outStream);
bitmap.Save(dialog.FileName.Split('.')[0] + @"\" + p[i].Title.Split('.')[0] + "." + iformat.ToString(), iformat);
}
ViewModel.WinMessageBoxItem wmsgbi = new ViewModel.WinMessageBoxItem((rm as ResourceManager).GetString("MessageBoxSaveTitle"), (rm as ResourceManager).GetString("MessageBoxSaveText"), MaterialDesignThemes.Wpf.PackIconKind.InformationCircle);
Windows.WinMessageBox wmsg = new Windows.WinMessageBox(wmsgbi, (rm as ResourceManager), ResourceNames, false);
wmsg.Show();
System.Windows.Input.Mouse.OverrideCursor = null;
}
}
}
void CreateExcelDocument()
{
System.Windows.Input.Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbooks xlWorkBooks = xlApp.Workbooks;
Microsoft.Office.Interop.Excel.Workbook xlWorkBook = xlWorkBooks.Add(1);
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
try
{
xlWorkSheet.Name = LB_Guests.Content.ToString();
xlWorkSheet.Cells[1, 1] = LB_Bride.Content;
xlWorkSheet.Cells[1, 4] = LB_Groom.Content;
Microsoft.Office.Interop.Excel.Range formatRange = xlWorkSheet.get_Range("A1", "D1");
formatRange.Font.Bold = true;
formatRange.WrapText = true;
xlWorkSheet.Range["a1", "b1"].Merge();
xlWorkSheet.Range["d1", "e1"].Merge();
List <Models.Guests> GroomGuestList = guestList.Where(x => x.Bride_Groom.Equals(0)).ToList();
List <Models.Guests> BrideGuestList = guestList.Where(x => x.Bride_Groom.Equals(1)).ToList();
string rang = "A1:" + "E" + (BrideGuestList.Count >= GroomGuestList.Count ? (BrideGuestList.Count + 1).ToString() : (GroomGuestList.Count + 1).ToString());
xlWorkSheet.get_Range(rang).Cells.Font.Name = "Comic Sans MS";
xlWorkSheet.Range[rang].Font.Size = 16;
xlWorkSheet.Range[rang].Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Pink);
xlWorkSheet.Range[rang].Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
xlWorkSheet.Range[rang].Borders.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);
formatRange = xlWorkSheet.get_Range(rang);
formatRange.BorderAround(Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous,
Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic,
Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic);
xlWorkSheet.Range[rang].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
xlWorkSheet.Range[rang].VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
for (int i = 0; i < BrideGuestList.Count; i++)
{
xlWorkSheet.Cells[2 + i, 1] = BrideGuestList[i].Guest_Name.Trim();
xlWorkSheet.Cells[2 + i, 2] = BrideGuestList[i].Guest_Count;
xlWorkSheet.Cells[2 + i, 2].NumberFormat = "0";
}
for (int i = 0; i < GroomGuestList.Count; i++)
{
xlWorkSheet.Cells[2 + i, 4] = GroomGuestList[i].Guest_Name.Trim();
xlWorkSheet.Cells[2 + i, 5] = GroomGuestList[i].Guest_Count;
xlWorkSheet.Cells[2 + i, 5].NumberFormat = "0";
}
xlWorkSheet.get_Range(rang).Columns.AutoFit();
xlApp.DisplayAlerts = false;
Microsoft.Win32.SaveFileDialog saveFileDialog = new Microsoft.Win32.SaveFileDialog();
saveFileDialog.FileName = (rm as ResourceManager).GetString("Menu_Guests");
saveFileDialog.Filter = (rm as ResourceManager).GetString("SaveFileDialogFilter");
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.Title = (rm as ResourceManager).GetString("SaveFileDialogTitle");
if (saveFileDialog.ShowDialog() == true)
{
System.IO.FileInfo file = new System.IO.FileInfo(saveFileDialog.FileName);
if (f.IsFileLocked(file, (rm as ResourceManager), ResourceNames) == false)
{
xlWorkBook.SaveAs(saveFileDialog.FileName);
ViewModel.WinMessageBoxItem wmsgbi = new ViewModel.WinMessageBoxItem((rm as ResourceManager).GetString("MessageBoxSaveTitle"), (rm as ResourceManager).GetString("MessageBoxSaveText"), MaterialDesignThemes.Wpf.PackIconKind.InformationCircle);
Windows.WinMessageBox wmsg = new Windows.WinMessageBox(wmsgbi, (rm as ResourceManager), ResourceNames, false);
wmsg.Show();
}
}
xlWorkBook.Close(false, Type.Missing, Type.Missing);
xlApp.Quit();
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkSheet);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkBook);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlApp);
}
catch (Exception ex)
{
System.Windows.Input.Mouse.OverrideCursor = null;
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem("Error", ex.Message, MaterialDesignThemes.Wpf.PackIconKind.Error);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, false);
msb.Show();
xlWorkBook.Close(false, Type.Missing, Type.Missing);
xlApp.Quit();
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkSheet);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkBook);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlApp);
}
System.Windows.Input.Mouse.OverrideCursor = null;
}
void CreateExcelDocument()
{
System.Windows.Input.Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbooks xlWorkBooks = xlApp.Workbooks;
Microsoft.Office.Interop.Excel.Workbook xlWorkBook = xlWorkBooks.Add(1);
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
try
{
string FirstVenue = exitems[CB_FirstOffer.SelectedIndex].Venue + "_" + exitems[CB_FirstOffer.SelectedIndex].Address;
string SecondVenue = exitems[CB_SecondOffer.SelectedIndex].Venue + "_" + exitems[CB_SecondOffer.SelectedIndex].Address;
xlWorkSheet.Name = FirstVenue.Substring(0, 14) + " - " + SecondVenue.Substring(0, 14);
xlWorkSheet.Cells[1, 1] = FirstVenue;
xlWorkSheet.Cells[1, 4] = SecondVenue;
Microsoft.Office.Interop.Excel.Range formatRange = xlWorkSheet.get_Range("A1", "D1");
formatRange.Font.Bold = true;
formatRange.WrapText = true;
xlWorkSheet.Range["a1", "b1"].Merge();
xlWorkSheet.Range["d1", "e1"].Merge();
string rang = "A1:" + "E" + (SecondComp.Count >= FirstComp.Count ? (SecondComp.Count + 2).ToString() : (FirstComp.Count + 2).ToString());
xlWorkSheet.get_Range(rang).Cells.Font.Name = "Comic Sans MS";
xlWorkSheet.Range[rang].Font.Size = 16;
xlWorkSheet.Range[rang].Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Pink);
xlWorkSheet.Range[rang].Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
xlWorkSheet.Range[rang].Borders.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);
formatRange = xlWorkSheet.get_Range(rang);
formatRange.BorderAround(Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous,
Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic,
Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic);
xlWorkSheet.Range[rang].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
xlWorkSheet.Range[rang].VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
for (int i = 0; i < FirstComp.Count; i++)
{
xlWorkSheet.Cells[2 + i, 1] = FirstComp[i].ExpenseName;
xlWorkSheet.Cells[2 + i, 2] = FirstComp[i].Expense;
xlWorkSheet.Cells[2 + i, 2].NumberFormat = "0";
}
for (int i = 0; i < SecondComp.Count; i++)
{
xlWorkSheet.Cells[2 + i, 4] = SecondComp[i].ExpenseName;
xlWorkSheet.Cells[2 + i, 5] = SecondComp[i].Expense;
xlWorkSheet.Cells[2 + i, 5].NumberFormat = "0";
}
xlWorkSheet.Cells[(SecondComp.Count >= FirstComp.Count ? (SecondComp.Count + 2) : (FirstComp.Count + 2)), 1] = LB_FirstAmount.Content.ToString().Split(' ')[0];
xlWorkSheet.Cells[(SecondComp.Count >= FirstComp.Count ? (SecondComp.Count + 2) : (FirstComp.Count + 2)), 2] = LB_FirstAmount.Content.ToString().Split(' ')[1];
xlWorkSheet.Cells[(SecondComp.Count >= FirstComp.Count ? (SecondComp.Count + 2) : (FirstComp.Count + 2)), 4] = LB_SecondAmount.Content.ToString().Split(' ')[0];
xlWorkSheet.Cells[(SecondComp.Count >= FirstComp.Count ? (SecondComp.Count + 2) : (FirstComp.Count + 2)), 5] = LB_SecondAmount.Content.ToString().Split(' ')[1];
xlWorkSheet.get_Range(rang).Columns.AutoFit();
rang = "A" + (SecondComp.Count >= FirstComp.Count ? (SecondComp.Count + 2).ToString() : (FirstComp.Count + 2).ToString()) + ":" + "E" + (SecondComp.Count >= FirstComp.Count ? (SecondComp.Count + 2).ToString() : (FirstComp.Count + 2).ToString());
formatRange = xlWorkSheet.get_Range(rang);
formatRange.BorderAround(Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous,
Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic,
Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic);
xlWorkSheet.Range[rang].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
xlWorkSheet.Range[rang].VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
xlApp.DisplayAlerts = false;
Microsoft.Win32.SaveFileDialog saveFileDialog = new Microsoft.Win32.SaveFileDialog();
int fvenue = FirstVenue.Length;
int svenue = SecondVenue.Length;
saveFileDialog.FileName = (rm as ResourceManager).GetString("Menu_Comparsion") + "_" + FirstVenue.Substring(0, fvenue < 15?fvenue:15) + "_" + SecondVenue.Substring(0, svenue < 15?svenue:15);
saveFileDialog.Filter = (rm as ResourceManager).GetString("SaveFileDialogFilter");
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.Title = (rm as ResourceManager).GetString("SaveFileDialogTitle");
if (saveFileDialog.ShowDialog() == true)
{
System.IO.FileInfo file = new System.IO.FileInfo(saveFileDialog.FileName);
if (f.IsFileLocked(file, (rm as ResourceManager), ResourceNames) == false)
{
xlWorkBook.SaveAs(saveFileDialog.FileName);
ViewModel.WinMessageBoxItem wmsgbi = new ViewModel.WinMessageBoxItem((rm as ResourceManager).GetString("MessageBoxSaveTitle"), (rm as ResourceManager).GetString("MessageBoxSaveText"), MaterialDesignThemes.Wpf.PackIconKind.InformationCircle);
Windows.WinMessageBox wmsg = new Windows.WinMessageBox(wmsgbi, (rm as ResourceManager), ResourceNames, false);
wmsg.Show();
}
}
xlWorkBook.Close(false, Type.Missing, Type.Missing);
xlApp.Quit();
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkSheet);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkBook);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlApp);
}
catch (Exception ex)
{
System.Windows.Input.Mouse.OverrideCursor = null;
ViewModel.WinMessageBoxItem wmsb = new ViewModel.WinMessageBoxItem("Error", ex.Message, MaterialDesignThemes.Wpf.PackIconKind.Error);
Windows.WinMessageBox msb = new Windows.WinMessageBox(wmsb, (rm as ResourceManager), ResourceNames, false);
msb.Show();
xlWorkBook.Close(false, Type.Missing, Type.Missing);
xlApp.Quit();
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkSheet);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkBook);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlApp);
}
System.Windows.Input.Mouse.OverrideCursor = null;
}
