public void ViewReport()
{
XtraReportPROGRESS_ITEMS progressReport = new XtraReportPROGRESS_ITEMS();
PROJECT_REPORT dbProjectReport = loaderCollection.GetObject <PROJECT_REPORT>();
if (dbProjectReport != null)
{
string reportString = dbProjectReport.REPORT.ToString();
using (StreamWriter sw = new StreamWriter(new MemoryStream()))
{
sw.Write(reportString);
sw.Flush();
progressReport.LoadLayout(sw.BaseStream);
}
}
PROJECTSummaryBuilder projectSummaryBuilder = new PROJECTSummaryBuilder(currentPROJECTSummary);
CalculateStatsForReport(projectSummaryBuilder);
progressReport.AssignProperties(currentPROJECTSummary, loadPROGRESS.PROJECT.NAME);
DocumentPreviewWindow previewWindow = new DocumentPreviewWindow();
previewWindow.PreviewControl.DocumentSource = progressReport;
previewWindow.WindowStartupLocation = WindowStartupLocation.CenterScreen;
previewWindow.WindowState = WindowState.Maximized;
progressReport.RequestParameters = false;
progressReport.CreateDocument(true);
previewWindow.ShowDialog();
}
private void OnPrint()
{
XtraReport report;
if (IsByCustomer)
{
report = new SalesReport();
if (SelectedCustomer != null)
{
report.DataSource = Transactions.Where(c => c.Customer.Id == SelectedCustomer.Id).ToList();
}
}
else
{
report = new AllTransactionReport();
report.DataSource = Transactions;
}
var window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument(true);
report.PrintingSystem.Document.AutoFitToPagesWidth = 1;
window.WindowStartupLocation = WindowStartupLocation.CenterScreen;
window.WindowState = WindowState.Maximized;
window.ShowDialog();
}
public void ViewReport()
{
XtraReportBASELINE_ITEMS baselineReport = new XtraReportBASELINE_ITEMS();
PROJECT_REPORT dbProjectReport = loaderCollection.GetObject <PROJECT_REPORT>();
if (dbProjectReport != null)
{
string reportString = dbProjectReport.REPORT.ToString();
using (StreamWriter sw = new StreamWriter(new MemoryStream()))
{
sw.Write(reportString);
sw.Flush();
baselineReport.LoadLayout(sw.BaseStream);
}
}
//make sure disciplines are all populated
PopulateNavigationalProperties();
baselineReport.AssignProperties(loadPROJECT, loadBASELINE, MainViewModel.Entities);
DocumentPreviewWindow previewWindow = new DocumentPreviewWindow();
previewWindow.PreviewControl.DocumentSource = baselineReport;
previewWindow.WindowStartupLocation = WindowStartupLocation.CenterScreen;
previewWindow.WindowState = WindowState.Maximized;
baselineReport.RequestParameters = false;
baselineReport.CreateDocument(true);
previewWindow.ShowDialog();
}
private void btnExport_Click(object sender, RoutedEventArgs e)
{
DateTime dtBegin = (DateTime)deBegin.EditValue;
DateTime dtEnd = (DateTime)deEnd.EditValue;
string formatString = "dd.MM.yy HH_mm";
DocumentPreviewWindow preview = new DocumentPreviewWindow();
CollectionViewLink link = new CollectionViewLink();
link.PrintingSystem.ExportOptions.PrintPreview.DefaultExportFormat = DevExpress.XtraPrinting.PrintingSystemCommand.ExportXlsx;
link.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = string.Format("{0} (с {1} по {2})", Item.Description, dtBegin.ToString(formatString), dtEnd.ToString(formatString));
link.PaperKind = DevExpress.Xpf.Drawing.Printing.PaperKind.A4;
link.Margins.Bottom = link.Margins.Top = link.Margins.Left = link.Margins.Right = 10;
link.ExportServiceUri = string.Format("http://{0}/ExportService.svc", Global.Default.ServerIPAddress);
LinkPreviewModel model = new LinkPreviewModel(link);
CollectionViewSource collectionViewSource = new CollectionViewSource
{
Source = Trends
};
link.CollectionView = collectionViewSource.View;
link.DetailTemplate = (DataTemplate)Resources["trendDataTemplate"];
link.ReportHeaderTemplate = (DataTemplate)Resources["trendHeaderTemplate"];
preview.Model = model;
link.CreateDocument(false);
preview.ShowDialog();
}
private void _bbidocgiareport_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
MemBerAll report = new MemBerAll();
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument(true);
window.ShowDialog();
}
private void ShowPreview(object sender, RoutedEventArgs e)
{
Report report = new Report();
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument(true);
window.ShowDialog();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
DocumentPreviewWindow preview = new DocumentPreviewWindow();
PrintableControlLink link = new PrintableControlLink(view);
LinkPreviewModel model = new LinkPreviewModel(link);
preview.Model = model;
link.CreateDocument(true);
preview.ShowDialog();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
RichEditDocumentServer documentServer = new RichEditDocumentServer();
documentServer.Text = "RichEditDocumentServer Print Preview.";
LegacyPrintableComponentLink link = new LegacyPrintableComponentLink(documentServer);
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = link;
link.CreateDocument(false);
window.ShowDialog();
}
private void PrintXtraReport()
{
var xtraReport = new XtraReport2();
var window = new DocumentPreviewWindow {
WindowStartupLocation = WindowStartupLocation.CenterScreen
};
window.PreviewControl.DocumentSource = xtraReport;
xtraReport.CreateDocument(true);
window.ShowDialog();
}
private void ShowPrintPreview(GridControl grid)
{
DocumentPreviewWindow preview = new DocumentPreviewWindow();
PrintableControlLink link = new PrintableControlLink(grid.View as DevExpress.Xpf.Printing.IPrintableControl);
link.ExportServiceUri = "../ExportService1.svc";
LinkPreviewModel model = new LinkPreviewModel(link);
preview.Model = model;
link.CreateDocument(false);
preview.ShowDialog();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
DocumentPreviewWindow preview = new DocumentPreviewWindow();
PrintableControlLink link = new PrintableControlLink(grid.View as DevExpress.Xpf.Printing.IPrintableControl);
link.ExportServiceUri = "../ExportService1.svc";
LinkPreviewModel model = new LinkPreviewModel(link);
preview.Model = model;
link.CreateDocument(true);
preview.ShowDialog();
}
public void ShowPreview(string serviceUri, string reportName)
{
ReportServicePreviewModel model = new ReportServicePreviewModel(serviceUri);
model.ReportName = reportName;
DocumentPreviewWindow preview = new DocumentPreviewWindow()
{
Model = model
};
model.CreateDocument();
preview.ShowDialog();
}
private void button1_Click(object sender, RoutedEventArgs e)
{
ReportHelper.ReportGeneratonHelper helper = new ReportHelper.ReportGeneratonHelper();
XtraReport report = helper.GenerateReport(grid, grid.ItemsSource);
DocumentPreviewWindow dp = new DocumentPreviewWindow()
{
Owner = this
};
dp.PreviewControl.DocumentSource = report;
report.CreateDocument(false);
dp.ShowDialog();
}
private void button1_Click(object sender, RoutedEventArgs e)
{
SimpleLink link = new SimpleLink("ListViewDocument");
DocumentPreviewWindow preview = new DocumentPreviewWindow();
preview.PreviewControl.DocumentSource = link;
link.PageHeaderTemplate = (DataTemplate)Resources["printHeaderTemplate"];
link.DetailTemplate = (DataTemplate)Resources["printDataTemplate"];
link.DetailCount = listView1.Items.Count;
link.CreateDetail += new EventHandler <CreateAreaEventArgs>(link_CreateDetail);
link.CreateDocument(true);
preview.ShowDialog();
}
private void ShowPreview(object sender, RoutedEventArgs e)
{
RemoteDocumentSource remoteSource = new RemoteDocumentSource();
remoteSource.ServiceUri = @"http://localhost:50786/ReportService1.svc";
remoteSource.ReportName = "ReportService.Reports.Report, Reporting";
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = remoteSource;
remoteSource.CreateDocument();
window.ShowDialog();
}
private void ShowPreview(object sender, RoutedEventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
if (ofd.ShowDialog() == true)
{
Report report = new Report();
report.xrRichText1.Rtf = File.ReadAllText(ofd.FileName);
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument(true);
window.ShowDialog();
}
}
public void Print(Window ownerWindow)
{
//TableViewAllEmployees.ShowPrintPreviewDialog(ownerWindow);
using (var print = new PrintableControlLink(TableViewAllEmployees))
{
var preview = new DocumentPreviewWindow
{
Owner = ownerWindow,
Model = new LinkPreviewModel(print)
};
print.CreateDocument(true);
preview.FlowDirection = FlowDirection.RightToLeft;
preview.ShowDialog();
}
}
private void btnExport_Click(object sender, RoutedEventArgs e)
{
//Global.Default.ShowForm(ref ExportDocumentPanel, "Форма экспорта данных.", "/WebControl;component/Forms/DataGridExport.xaml", new Size(800, 600), true, this);
DateTime dtBegin = (DateTime)deBegin.EditValue;
DateTime dtEnd = (DateTime)deEnd.EditValue;
string formatString = "dd.MM.yy HH_mm";
DocumentPreviewWindow preview = new DocumentPreviewWindow();
PrintableControlLink link = new PrintableControlLink(gridControl.View as DevExpress.Xpf.Printing.IPrintableControl);
link.PrintingSystem.ExportOptions.PrintPreview.DefaultExportFormat = DevExpress.XtraPrinting.PrintingSystemCommand.ExportXlsx;
link.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = string.Format("Отчет Ангидрит. МТБ. (с {0} по {1})", dtBegin.ToString(formatString), dtEnd.ToString(formatString));
link.PaperKind = DevExpress.Xpf.Drawing.Printing.PaperKind.A4;
link.Margins.Bottom = link.Margins.Top = link.Margins.Left = link.Margins.Right = 10;
link.ExportServiceUri = string.Format("http://{0}/ExportService.svc", Global.Default.ServerIPAddress);
LinkPreviewModel model = new LinkPreviewModel(link);
preview.Model = model;
link.CreateDocument(false);
preview.ShowDialog();
}
private void Window_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.F1)
{
XtraReport1 report = new XtraReport1();
SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
FF.FileName = Properties.Settings.Default.path;
((SqlDataSource)report.DataSource).ConnectionParameters = FF;
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
DocumentPreviewWindow windoww = new DocumentPreviewWindow()
{
Model = model
};
report.CreateDocument(true);
windoww.ShowDialog();
//using (ReportPrintTool printTool = new ReportPrintTool(report))
//{
// printTool.Print();
// //or printTool.PrintDialog();
//}
}
}
private void _reportprint_Click(object sender, RoutedEventArgs e)
{
if (_rdall.IsChecked == true)
{
if (_rccahaitc.IsChecked == true)
{
BooksLoanAll report = new BooksLoanAll();
//report.FilterString = "[DaTra] = false";
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument(true);
window.ShowDialog();
}
if (_rddatratc.IsChecked == true)
{
BooksLoanAll report = new BooksLoanAll();
report.FilterString = "[DaTra] = true";
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument(true);
window.ShowDialog();
}
if (_rdchuatratc.IsChecked == true)
{
BooksLoanAll report = new BooksLoanAll();
report.FilterString = "[DaTra] = false";
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument(true);
window.ShowDialog();
}
}
if (_rdsachmember.IsChecked == true)
{
if (_cbbtendocgia.SelectedItem == null)
{
MessageBox.Show("Chon Doi Tuong", "Thong Bao", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (_ckcahai.IsChecked == true)
{
BookLoanByMemBer report = new BookLoanByMemBer((_cbbtendocgia.SelectedItem as View_Models.DocGia).MaDocGia);
//report.FilterString = "[DaTra] = false";
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument(true);
window.ShowDialog();
}
if (_ckchuatra.IsChecked == true)
{
BookLoanByMemBer report = new BookLoanByMemBer((_cbbtendocgia.SelectedItem as View_Models.DocGia).MaDocGia);
report.FilterString = "[DaTra] = false";
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument(true);
window.ShowDialog();
}
if (_ckdatra.IsChecked == true)
{
BookLoanByMemBer report = new BookLoanByMemBer((_cbbtendocgia.SelectedItem as View_Models.DocGia).MaDocGia);
report.FilterString = "[DaTra] = true";
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument(true);
window.ShowDialog();
}
}
}
private void Print_Click(object sender, RoutedEventArgs e)
{
var SumPricee = new FunctionsOfSum();
var Fa_delete = new Assest.OrcDataAcess();
var FA = new Assest.OrcDataAcess();
try
{
double afo = 0;
var Filtring = new List <string>();
foreach (string item in PriceList)
{
Filtring.Add(item.Replace("SAR", ""));
}
var accc = new Assest.OrcDataAcess();
List <string> L0 = new List <string>();
List <string> L1 = new List <string>();
List <string> L2 = new List <string>();
List <string> L3 = new List <string>();
List <string> L4 = new List <string>();
List <string> L5 = new List <string>();
List <string> L6 = new List <string>(); //
List <string> L7 = new List <string>(); //dis
List <string> L8 = new List <string>(); //pricef
List <string> L9 = new List <string>(); //dat
/*
*
*
*
*/
DataTable tt = new DataTable();
accc.Show(tt);
// Finall_Price = (Double)((Price * Discount) / 100) - Price;
foreach (DataRow r in tt.Rows)
{
L1.Add(r.Field <string>("NAME"));
L2.Add(r.Field <string>("BARCODE"));
L3.Add(r.Field <string>("PRICE_A"));
L4.Add(r.Field <string>("PRICE"));
L5.Add(r.Field <string>("ID"));
L6.Add(r.Field <string>("QUANTITY"));
L7.Add(r.Field <string>("Dis"));
L8.Add(r.Field <string>("Price_F"));
}
tt.Clear();
accc.show3(tt);
foreach (DataRow r in tt.Rows)
{
L0.Add(r.Field <String>("NUMF"));
}
foreach (string asf in Filtring)
{
afo += double.Parse(asf);
}
PriceList.Add(afo.ToString());
Pricce.Text = "SAR " + afo.ToString();
var RepHelper = new ReportHelper();
var ILIST = new List <ReportHelper>();
ILIST.Add(new ReportHelper()
{
Getprice_ = Pricce.Text
});
XtraReport3 report = new XtraReport3();
SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db";
((SqlDataSource)report.DataSource).ConnectionParameters = FF;
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
DocumentPreviewWindow windoww = new DocumentPreviewWindow()
{
Model = model
};
report.CreateDocument(true);
windoww.ShowDialog();
string id_3 = "";
//int finalprice = int.Parse(SumPricee.sumPrice().Replace("SAR", "").Replace(",", ""));
//double Ristt = double.Parse(afo.ToString().Replace("SAR", "").Replace(",", ""));
//double FInaal = finalprice + Ristt;
for (int i = 0; i < L1.Count; i++)
{
if (L1[i] == Name.Text)
{
id_3 = L5[i];
}
}
List <int> sawf = new List <int>();
foreach (string d in L0)
{
sawf.Add(int.Parse(d));
}
#region Convert Days to arabic language
string dayoftheweek = "";
switch (DateTime.Now.DayOfWeek)
{
case DayOfWeek.Sunday:
{
dayoftheweek = ".الاحد";
break;
}
case DayOfWeek.Monday:
{
dayoftheweek = ".الاثنين";
break;
}
case DayOfWeek.Thursday:
{
dayoftheweek = ".الخميس";
break;
}
case DayOfWeek.Saturday:
{
dayoftheweek = ".السبت";
break;
}
case DayOfWeek.Friday:
{
dayoftheweek = "الجمعة.";
break;
}
case DayOfWeek.Tuesday:
{
dayoftheweek = "الثلاثاء.";
break;
}
case DayOfWeek.Wednesday:
{
dayoftheweek = "الاربعاء.";
break;
}
}
#endregion
if (L0.Count == 0)
{
//null
}
else
{
numfa = sawf.Max() + 1;
}
if (sawf.Count == 0)
{
UmAlQuraCalendar um = new UmAlQuraCalendar();
String CurrentDate = (int.Parse(DateTime.Now.Year.ToString()) < 1600) ? DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() :
um.GetYear(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetMonth(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetDayOfMonth(DateTime.Parse(DateTime.Now.ToString())).ToString();
for (int i = 0; i < L1.Count; i++)
{
double Price = 0;
double Discount = 0;
double Finall_Price = 0;
string Result = "";
DateTime dtttt = new DateTime();
for (int ii = 0; ii < asdf.Count; ii++)
{
if (L1[i] == asdf[ii])
{
accc.insert3(CurrentDate, L1[i], getwholeprice(i, L4, L7), L5[i], L6[i], L3[i], L2[i], numfa.ToString(), dayoftheweek, Pricce.Text);
Price = (String.IsNullOrEmpty(L4[i].Replace("SAR", ""))) ? 0 : (Double)Double.Parse(double.Parse(L4[i].Replace("SAR", "")).ToString().Replace("SAR", ""));
Discount = (String.IsNullOrEmpty(L7[i].Replace("%", ""))) ? 0 : (Double)Double.Parse(double.Parse(L7[i].Replace("%", "")).ToString().Replace("%", ""));
Finall_Price = (Double)((Price * Discount) / 100) - Price;
Finall_Price = Finall_Price * int.Parse(L6[i]);
Result = "SAR " + Finall_Price.ToString("N2").Replace("-", "");
var mainwi = new MainWindow(L1[i], L4[i], L6[i], L2[i], L3[i], L5[i], L7[i], Result);
mainwi.EDIT_MAX();
}
/*
*
* L1.Add(r.Field<string>("NAME"));
* L2.Add(r.Field<string>("BARCODE"));
* L3.Add(r.Field<string>("PRICE_A"));
* L4.Add(r.Field<string>("PRICE"));
* L5.Add(r.Field<string>("ID"));
* L6.Add(r.Field<string>("QUANTITY"));
* L7.Add(r.Field<string>("Dis"));
* L8.Add(r.Field<string>("Price_F"));
*/
}
}
if (GID.Count > 0)
{
for (int i = 0; i < GID.Count; i++)
{
FA.Delete(GID[i]);
}
}
}
else
{
#region Date
UmAlQuraCalendar um = new UmAlQuraCalendar();
String CurrentDate = (int.Parse(DateTime.Now.Year.ToString()) < 1600) ? DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() :
um.GetYear(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetMonth(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetDayOfMonth(DateTime.Parse(DateTime.Now.ToString())).ToString();
#endregion
for (int i = 0; i < L1.Count; i++)
{
double Price = 0;
double Discount = 0;
double Finall_Price = 0;
string Result = "";
DateTime dtttt = new DateTime();
for (int ii = 0; ii < asdf.Count; ii++)
{
if (L1[i] == asdf[ii])
{
accc.insert3(CurrentDate, L1[i], getwholeprice(i, L4, L7), L5[i], L6[i], L3[i], L2[i], numfa.ToString(), dayoftheweek, Pricce.Text);
Price = (String.IsNullOrEmpty(L4[i].Replace("SAR", ""))) ? 0 : (Double)Double.Parse(double.Parse(L4[i].Replace("SAR", "")).ToString().Replace("SAR", ""));
Discount = (String.IsNullOrEmpty(L7[i].Replace("%", ""))) ? 0 : (Double)Double.Parse(double.Parse(L7[i].Replace("%", "")).ToString().Replace("%", ""));
Finall_Price = (Double)((Price * Discount) / 100) - Price;
Finall_Price = Finall_Price * int.Parse(L6[i]);
Result = "SAR " + Finall_Price.ToString("N2").Replace("-", "");
var mainwi = new MainWindow(L1[i], L4[i], L6[i], L2[i], L3[i], L5[i], L7[i], Result);
mainwi.EDIT_MAX();
}
}
}
if (GID.Count > 0)
{
for (int i = 0; i < GID.Count; i++)
{
FA.Updating_QUa("0", GID[i].ToString());
}
}
}
asdf.Clear();
for (int i = 0; i < PriceList.Count; i++)
{
Fa_delete._Delete(double.Parse(PriceList[i].Replace("SAR", "").Replace(",", "")));
}
}
catch (Exception ex) { System.Windows.MessageBox.Show(ex.Message + ":" + ex.HResult.ToString()); }
DD.ItemsSource = "";
Observ.Clear();
NameList.Clear();
PriceList.Clear();
}
private void _btnchangepass_Click(object sender, RoutedEventArgs e)
{
//if (_btnchangepass.Content.Equals("Change Pass"))
//{
// _btnchangepass.Content = "Save";
// passwordBox1.IsEnabled = true;
// passwordBox.Clear();
// passwordBox1.ToolTip = "Nhập Lại Pass";
// _btncancelsavepass.Visibility = Visibility.Visible;
// _btncancelsavepass.IsEnabled = true;
// passwordBox.Focus();
// return;
//}
//string warning = "";
//if (String.IsNullOrWhiteSpace(passwordBox.Password))
//{
// warning += "Nhập password." + '\n';
//}
//if (String.IsNullOrWhiteSpace(passwordBox1.Password))
//{
// warning += "Pass nhập lại không đúng." + '\n';
//}
//if (!warning.Equals(""))
//{
// MessageBox.Show(warning,
// "Cập Nhật Pass",
// MessageBoxButton.OK,
// MessageBoxImage.Warning);
// return;
//}
//try
//{
// if (passwordBox.Password == passwordBox1.Password)
// {
// UserController us = new UserController();
// View_Models.User user = us.GetById(Id);
// user.PASSWORD = passwordBox.Password.Trim();
// if (us.Edit(user))
// {
// MessageBox.Show("Cập Nhật thành công", "Cập Nhật Password", MessageBoxButton.OK, MessageBoxImage.Information);
// }
// else
// {
// MessageBox.Show("Cập Nhật thất bại", "Cập Nhật Password", MessageBoxButton.OK, MessageBoxImage.Information);
// }
// }
// else
// {
// MessageBox.Show("Pass word nhập lại không trùng khớp", "Cập Nhật Password", MessageBoxButton.OK, MessageBoxImage.Information); return;
// }
// _btnchangepass.Content = "Change Pass";
// passwordBox1.IsEnabled = false;
// passwordBox1.Clear();
//}
//catch { }
BookLoanByMemBer report = new BookLoanByMemBer("DG003");
report.FilterString = "[DaTra] = false";
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument(true);
window.ShowDialog();
}
private async void PrivewDoucmentPrinter_Click(object sender, RoutedEventArgs e)
{
if (IS_SELECTED)
{
if (PrintHelper.Print.IsMounth_)
{
PrintHelper.Print.GET_STRATED();
var Dataopp = new Assest.OrcDataAcess();
XtraReport4 report = new XtraReport4();
SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db";
((SqlDataSource)report.DataSource).ConnectionParameters = FF;
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
DocumentPreviewWindow windoww = new DocumentPreviewWindow()
{
Model = model
};
report.CreateDocument(true);
windoww.ShowDialog();
Dataopp.Delete4();
}
else if (PrintHelper.Print.IsYear_)
{
PrintHelper.Print.GET_STRATED();
var Dataopp = new Assest.OrcDataAcess();
XtraReport4 report = new XtraReport4();
SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db";
((SqlDataSource)report.DataSource).ConnectionParameters = FF;
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
DocumentPreviewWindow windoww = new DocumentPreviewWindow()
{
Model = model
};
report.CreateDocument(true);
windoww.ShowDialog();
Dataopp.Delete4();
}
else if (PrintHelper.Print.IsDay_)
{
PrintHelper.Print.GET_STRATED();
var Dataopp = new Assest.OrcDataAcess();
XtraReport4 report = new XtraReport4();
SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db";
((SqlDataSource)report.DataSource).ConnectionParameters = FF;
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
DocumentPreviewWindow windoww = new DocumentPreviewWindow()
{
Model = model
};
report.CreateDocument(true);
windoww.ShowDialog();
Dataopp.Delete4();
}
else if (!PrintHelper.Print.IsDay_ &&
!PrintHelper.Print.IsMounth_ &&
!PrintHelper.Print.IsYear_)
{
SYear();
PrintHelper.Print.GET_STRATED();
var Dataopp = new Assest.OrcDataAcess();
XtraReport4 report = new XtraReport4();
SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db";
((SqlDataSource)report.DataSource).ConnectionParameters = FF;
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
DocumentPreviewWindow windoww = new DocumentPreviewWindow()
{
Model = model
};
report.CreateDocument(true);
windoww.ShowDialog();
Dataopp.Delete4();
}
}
else if (!is_Repair_Selected)
{
XtraReport1 report = new XtraReport1();
SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db";
((SqlDataSource)report.DataSource).ConnectionParameters = FF;
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
DocumentPreviewWindow windoww = new DocumentPreviewWindow()
{
Model = model
};
report.CreateDocument(true);
windoww.ShowDialog();
}
if (is_Repair_Selected)
{
if (Encode1.Text == "/d")
{
NewModel(type_of_date.day);
PrintHelper.Print.IsMounth_ = false;
PrintHelper.Print.IsDay_ = true;
PrintHelper.Print.IsYear_ = false;
Reports.XtraReport5 report = new Reports.XtraReport5();
SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db";
((SqlDataSource)report.DataSource).ConnectionParameters = FF;
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
DocumentPreviewWindow windoww = new DocumentPreviewWindow()
{
Model = model
};
report.CreateDocument(true);
windoww.ShowDialog();
mo.Delete1();
PrintHelper.Print.IsMounth_ = false;
PrintHelper.Print.IsDay_ = false;
PrintHelper.Print.IsYear_ = false;
}
else if (Encode1.Text == "/m")
{
NewModel(type_of_date.month);
PrintHelper.Print.IsMounth_ = true;
PrintHelper.Print.IsDay_ = false;
PrintHelper.Print.IsYear_ = false;
Reports.XtraReport5 report = new Reports.XtraReport5();
SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db";
((SqlDataSource)report.DataSource).ConnectionParameters = FF;
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
DocumentPreviewWindow windoww = new DocumentPreviewWindow()
{
Model = model
};
report.CreateDocument(true);
windoww.ShowDialog();
mo.Delete1();
PrintHelper.Print.IsMounth_ = false;
PrintHelper.Print.IsDay_ = false;
PrintHelper.Print.IsYear_ = false;
}
else if (Encode1.Text == "/y")
{
NewModel(type_of_date.year);
PrintHelper.Print.IsMounth_ = false;
PrintHelper.Print.IsDay_ = false;
PrintHelper.Print.IsYear_ = true;
Reports.XtraReport5 report = new Reports.XtraReport5();
SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db";
((SqlDataSource)report.DataSource).ConnectionParameters = FF;
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
DocumentPreviewWindow windoww = new DocumentPreviewWindow()
{
Model = model
};
report.CreateDocument(true);
windoww.ShowDialog();
mo.Delete1();
PrintHelper.Print.IsMounth_ = false;
PrintHelper.Print.IsDay_ = false;
PrintHelper.Print.IsYear_ = false;
}
else if (String.IsNullOrEmpty(Encode1.Text))
{
NewModel(type_of_date.year);
PrintHelper.Print.IsMounth_ = false;
PrintHelper.Print.IsDay_ = false;
PrintHelper.Print.IsYear_ = true;
Reports.XtraReport5 report = new Reports.XtraReport5();
SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db";
((SqlDataSource)report.DataSource).ConnectionParameters = FF;
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
DocumentPreviewWindow windoww = new DocumentPreviewWindow()
{
Model = model
};
report.CreateDocument(true);
windoww.ShowDialog();
mo.Delete1();
PrintHelper.Print.IsMounth_ = false;
PrintHelper.Print.IsDay_ = false;
PrintHelper.Print.IsYear_ = false;
}
else
{
//later
}
}
}
/*
* private System.Drawing.Image fQRCode(string mQRTitle, string mQRData){
* try{
* // Dim QRPath As String
* BarcodeSettings QRSetting = new BarcodeSettings();
* QRSetting.Type = BarCodeType.QRCode;
* QRSetting.Data = mQRData;
* QRSetting.Data2D = mQRTitle;
* QRSetting.QRCodeDataMode = QRCodeDataMode.AlphaNumber;
*
* QRSetting.ResolutionType = ResolutionType.Graphics;
* QRSetting.Unit = System.Drawing.GraphicsUnit.Millimeter;
* QRSetting.DpiX = 300;
* QRSetting.DpiY = 300;
*
* QRSetting.BarHeight = 25;
* QRSetting.HasBorder = false;
* QRSetting.BorderWidth = 1;
*
* QRSetting.ImageHeight = 25; // 2.53 Inch | 64.2 Inch |128mm | 480 Pixel
* QRSetting.ImageWidth = 25;
* QRSetting.AutoResize = true;
*
* QRSetting.X = 0.5F;
* QRSetting.QRCodeECL = QRCodeECL.H;
* QRSetting.TopMargin = 1;
* QRSetting.LeftMargin = 1;
* QRSetting.RightMargin = 1;
* QRSetting.BottomMargin = 1;
* QRSetting.ForeColor = System.Drawing.Color.Black;
* // QRSetting.ForeColor = Color.CadetBlue
*
* System.Drawing.Font myFont = new System.Drawing.Font("Verdana", 8);
* QRSetting.TextFont = myFont;
* QRSetting.ShowText = false;
* QRSetting.TopText = mQRTitle;
* QRSetting.TopTextColor = System.Drawing.Color.Green;
* QRSetting.ShowTextOnBottom = false;
*
* BarCodeGenerator QRGer = new BarCodeGenerator(QRSetting);
* System.Drawing.Image Img = QRGer.GenerateImage();
*
* // 'Dim QRBitmap As System.Drawing.Bitmap = oQR.GetGraphic(20)
* System.IO.MemoryStream oMS = new System.IO.MemoryStream();
* Img.Save(oMS, System.Drawing.Imaging.ImageFormat.Png);
* return Img;
* }
* catch (Exception ex)
* {
* return null;
* }
* }
*/
#endregion
public void rptInMaVach(DataTable oTblSP, Boolean isDG = false, Boolean isMaQR = true, String isMauIn = "25_15")
{
try
{
if (oTblSP == null || oTblSP.Rows.Count <= 0)
{
Utils.showMessage(String.Format("Bạn chưa chọn sản phẩm cần tạo mã {0}", isMaQR == true ? " QRCode.." : " Vạch.."), "Lưu ý");
return;
}
SqlParameter[] arrPara = new SqlParameter[5];
arrPara[0] = new SqlParameter("@tblMasp", SqlDbType.Structured);
arrPara[0].Value = oTblSP;
arrPara[1] = new SqlParameter("@Loai", SqlDbType.TinyInt);
arrPara[1].Value = isMaQR == true ? 0 : 1;
arrPara[2] = new SqlParameter("@Cogia", SqlDbType.Bit);
arrPara[2].Value = isDG == true ? 1 : 0;
arrPara[3] = new SqlParameter("@Denngay", SqlDbType.NVarChar, 15);
arrPara[3].Value = MTGlobal.MT_DENNGAY;
arrPara[4] = new SqlParameter("@Nguoidung", SqlDbType.NVarChar, 50);
arrPara[4].Value = MTGlobal.MT_USER_LOGIN;
DataTable otblMaCode = new MTSQLServer().wRead("rptDM_InMaQRCode", arrPara);
if (otblMaCode != null)
{
switch (isMauIn)
{
case "25_15":
rptHH_QRCode_25_15 oReport = new rptHH_QRCode_25_15();
oReport.InitMacode(isMaQR);
oReport.DataSource = otblMaCode;
oReport.BindData();
SetCustomPageQR(oReport, isMauIn);
setFormatReport(oReport);
XtraReportPreviewModel model = new XtraReportPreviewModel(oReport);
model.AutoShowParametersPanel = false;
DocumentPreviewWindow oPrev = new DocumentPreviewWindow()
{
Model = model
};
oPrev.WindowStyle = System.Windows.WindowStyle.SingleBorderWindow;
oPrev.WindowState = System.Windows.WindowState.Normal;
oPrev.WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
oPrev.Title = "IN MÃ VẠCH";
oPrev.ShowDialog();
break;
//3TEM/ROW
case "35_22":
/*
* Spire.Barcode.BarcodeSettings.ApplyKey("3GZHB-UT3PY-9YAGD-EXYS6-PREGK");
* DataTable oTblCode = new DataTable();
* oTblCode.Columns.Add("Macode", typeof(System.String));
* oTblCode.Columns.Add("MacodeText", typeof(System.String));
* oTblCode.Columns.Add("PicCode", typeof(System.Drawing.Image));
* foreach (DataRow vR in otblMaCode.Rows) {
* DataRow dR = oTblCode.NewRow();
* dR["Macode"] = vR["Macode"];
* dR["MacodeText"] = vR["MacodeText"];
* dR["PicCode"] =fQRCode(vR["MacodeText"].ToString(),vR["Macode"].ToString());
* oTblCode.Rows.Add(dR);
*
* }
* oTblCode.AcceptChanges();
* rptHH_QRCode_3temImg_35_22 oReport3t = new rptHH_QRCode_3temImg_35_22();
* oReport3t.InitMacode(isMaQR);
* oReport3t.DataSource = oTblCode;
* oReport3t.BindData();
* SetCustomPageQR(oReport3t, isMauIn);
* setFormatReport(oReport3t);
*
* PrintPreview oPreview3t = new PrintPreview();
* oPreview3t.report = oReport3t;
*
* oPreview3t.Show();
* break;
*/
if (isMaQR)
{
rptHH_QRCode_35_22 oRptQRcode3T = new rptHH_QRCode_35_22();
oRptQRcode3T.InitMacode(isMaQR);
oRptQRcode3T.DataSource = otblMaCode;
oRptQRcode3T.BindData();
SetCustomPageQR(oRptQRcode3T, isMauIn);
setFormatReport(oRptQRcode3T);
PrintPreview oPreviewQR = new PrintPreview();
oPreviewQR.report = oRptQRcode3T;
oPreviewQR.ShowDialog();
/*
* XtraReportPreviewModel model2 = new XtraReportPreviewModel(oRptQRcode3T);
* model2.AutoShowParametersPanel = false;
* DocumentPreviewWindow oPrev2 = new DocumentPreviewWindow() { Model = model2 };
* oPrev2.UpdateLayout();
*
* oPrev2.WindowStyle = System.Windows.WindowStyle.SingleBorderWindow;
* oPrev2.WindowState = System.Windows.WindowState.Normal;
* oPrev2.WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
* oPrev2.Title = "IN MÃ QRCODE";
* //oPrev2.Topmost = true;
* oPrev2.ShowDialog(); */
}
else
{
rptHH_Barcode_35_22 oRptBarcode3T = new rptHH_Barcode_35_22();
oRptBarcode3T.InitMacode(isMaQR);
oRptBarcode3T.DataSource = otblMaCode;
oRptBarcode3T.BindData();
XtraReportPreviewModel model2 = new XtraReportPreviewModel(oRptBarcode3T);
model2.AutoShowParametersPanel = false;
DocumentPreviewWindow oPrev2 = new DocumentPreviewWindow()
{
Model = model2
};
//oRptBarcode3T.CreateDocument(false);
oPrev2.WindowStyle = System.Windows.WindowStyle.SingleBorderWindow;
oPrev2.WindowState = System.Windows.WindowState.Normal;
oPrev2.WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
oPrev2.Title = "IN MÃ VẠCH";
//oPrev2.Topmost = true;
//SetCustomPageQR(oRptBarcode3T, isMauIn);
setFormatReport(oRptBarcode3T);
oPrev2.ShowDialog();
}
break;
case "30_30":
rptHH_QRCode_30_30 oReport30 = new rptHH_QRCode_30_30();
oReport30.InitMacode(isMaQR);
oReport30.DataSource = otblMaCode;
oReport30.BindData();
setFormatReport(oReport30);
SetCustomPageQR(oReport30);
PrintPreview oPreview30 = new PrintPreview();
oPreview30.report = oReport30;
oPreview30.ShowDialog();
break;
}
}
else
{
Utils.showMessage("Không thể đọc dữ liệu tạo mã vạch..", "Thông báo");
}
}
catch { }
}
private void _btnadd_Click(object sender, RoutedEventArgs e)
{
if (_btnadd.Content.Equals("Add new"))
{
_btnadd.Content = "Hoàn tất";
_btnadd_cancel.IsEnabled = true;
_btnadd_cancel.Visibility = Visibility.Visible;
_btnsave.IsEnabled = false;
_btndelete.IsEnabled = false;
_btndelete.IsEnabled = false;
_btnload.IsEnabled = false;
gridSachMuon.IsEnabled = false;
_txtmamuon.Clear();
_txtsoluongmuon.Clear();
_txttiencoc.Clear();
_datemuon.Clear();
_datetra.Clear();
_checkdatra.IsChecked = false;
_cbbtendocgia.SelectedItem = null;
_cbbtensach.SelectedItem = null;
return;
}
string warning = "";
if (String.IsNullOrWhiteSpace(_txtsoluongmuon.Text))
{
warning += "Vui lòng nhập Số Lượng Sách Mượn." + '\n';
}
if (String.IsNullOrWhiteSpace(_txttiencoc.Text))
{
warning += "Vui lòng nhập tiền cọc." + '\n';
}
if (String.IsNullOrWhiteSpace(_cbbtendocgia.Text))
{
warning += "Vui lòng Chọn Độc Giả." + '\n';
}
if (String.IsNullOrWhiteSpace(_cbbtensach.Text))
{
warning += "Vui lòng Chọn Tên Sách." + '\n';
}
if (!warning.Equals(""))
{
MessageBox.Show(
warning,
"Thêm mới Sách Mượn",
MessageBoxButton.OK,
MessageBoxImage.Warning);
return;
}
MuonSach sach = new MuonSach();
try
{
sach.SoLuongMuon = Convert.ToInt16(_txtsoluongmuon.Text);
sach.TienCoc = Convert.ToDecimal(_txttiencoc.Text);
if (_checkdatra.IsChecked == true)
{
sach.DaTra = true;
}
else
{
sach.DaTra = false;
}
if (_datemuon.Text.Equals("") == false && _datetra.Text.Equals("") == false)
{
try
{
sach.NgayMuon = DateTime.Today;
sach.NgayHen = Convert.ToDateTime(_datetra.Text);
}
catch { }
}
else
{
sach.NgayMuon = DateTime.Today;
sach.NgayHen = DateTime.Today;
}
}
catch
{
}
if (_cbbtendocgia.SelectedItem != null)
{
sach.MaDocGia = (_cbbtendocgia.SelectedItem as View_Models.DocGia).MaDocGia;
}
if (_cbbtensach.SelectedItem != null)
{
sach.MaSach = (_cbbtensach.SelectedItem as View_Models.Sach).MaSach;
}
Sach temp = _cbbtensach.SelectedItem as Sach;
int slcm = sachControll.CheckChoMuon(temp);
if (slcm == 0)
{
warning += "Sách trong kho đã hết" + '\n';
}
if (slcm < sach.SoLuongMuon)
{
warning += "Sách trong kho còn:" + slcm + '\n';
}
if (!warning.Equals(""))
{
MessageBox.Show(
warning,
"Thêm mới Sách Mượn",
MessageBoxButton.OK,
MessageBoxImage.Warning);
return;
}
if (sachMuonControll.Add(sach))
{
Sach sachtemp = sachControll.GetById(sach.MaSach);
sachtemp.LuongDaMuon = sachMuonControll.GetTongSachMuon(sachtemp) == null? 0: sachMuonControll.GetTongSachMuon(sachtemp).Value;
sachControll.Edit(sachtemp);
DocGia dgtemp = docGiaControll.GetById(sach.MaDocGia);
dgtemp.TienKiGui = sachMuonControll.GetTongTienCoc(dgtemp) == null ? 0 : sachMuonControll.GetTongTienCoc(dgtemp).Value;
docGiaControll.Edit(dgtemp);
MessageBox.Show(
"Thêm mới thành công",
"Thêm mới Sách Muọn",
MessageBoxButton.OK,
MessageBoxImage.Information);
MessageBoxResult re;
re = MessageBox.Show("Bạn có muốn in phiếu không", "In Phiếu", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (re == MessageBoxResult.Yes)
{
BookLoanPhieuMuon report = new BookLoanPhieuMuon(sach.MaDocGia, sach.NgayMuon);
report.FilterString = "[DaTra] = false";
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument(true);
window.ShowDialog();
}
}
else
{
MessageBox.Show(
"Thêm mới thất bại",
"Thêm mới Sách Mượn",
MessageBoxButton.OK,
MessageBoxImage.Error);
}
_btnadd.Content = "Add new";
_btnadd_cancel.IsEnabled = false;
_btnadd_cancel.Visibility = Visibility.Hidden;
_btnsave.IsEnabled = true;
_btndelete.IsEnabled = true;
_btnload.IsEnabled = true;
gridSachMuon.IsEnabled = true;
LoadSachMuonTable();
}