private void Button_Click(object sender, RoutedEventArgs e)
{
ConfigurationCashHelper.Update();
PassJournalTranslator.ConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=PassJournal_1;Integrated Security=True;Language='English'";
var report = new WorkingTimeReport();
var filter = new WorkingTimeReportFilter()
{
//SortColumn = "Number",
//PassCardForcing = false,
//PassCardLocked = false,
//UseArchive = true,
//Organisations = new List<Guid>() { new Guid("F6E5DA71-C4D7-4421-94A9-F5F7ED7DDF7E") },
//PeriodType = ReportPeriodType.Month,
//DateTimeFrom = new DateTime(2015,01,01),
//DateTimeTo = DateTime.Today.AddDays(1),
};
filter.Timestamp = DateTime.Now;
filter.User = WindowsIdentity.GetCurrent().Name;
report.ApplyFilter(filter);
var model = new XtraReportPreviewModel(report)
{
IsParametersPanelVisible = false,
AutoShowParametersPanel = false,
IsDocumentMapVisible = false,
ZoomMode = new ZoomFitModeItem(ZoomFitMode.WholePage),
};
documentViewer1.Model = model;
report.CreateDocument();
}
public MainWindowViewModel()
{
PreviewModel = new XtraReportPreviewModel(report);
PreviewModel.PreviewMouseMove += model_PreviewMouseMove;
PreviewModel.PreviewClick += model_PreviewClick;
report.CreateDocument();
}
public BaseViewModel(Guid divisionId)
{
UserDivision = db.Division.FirstOrDefault(x => x.ID == divisionId);
CreateReportCore(delegate(IReport report)
{
reportPreviewModel = CreateReportPreviewModel(report);
});
}
void documentMap_SelectedItemChanged(object sender, RoutedPropertyChangedEventArgs <object> e)
{
XtraReportPreviewModel model = (XtraReportPreviewModel)preview.Model;
if (model != null)
{
model.DocumentMapSelectedNode = e.NewValue as DocumentMapTreeViewNode;
}
}
private void UpdatePreview()
{
XtraSchedulerReport report = new XtraSchedulerReport();
report.LoadLayout(ReportTemplateInfoSource[ActiveReportTemplateIndex].ReportTemplatePath);
adapter.TimeInterval = new TimeInterval(IntervalStart, IntervalEnd);
report.SchedulerAdapter = adapter.SchedulerAdapter;
report.CreateDocument();
PreviewModel = new XtraReportPreviewModel(report);
}
private void documentPreview1_Loaded(object sender, RoutedEventArgs e)
{
report = new XtraReport1()
{
RequestParameters = true
};
XtraReportPreviewModel model = new XtraReportPreviewModel();
model.Report = report;
report.CreateDocument();
documentPreview1.Model = model;
}
public MainWindow()
{
InitializeComponent();
this.dataSet = new CarsDBDataSet();
// Bind the scheduler storage to appointment data.
storage.AppointmentStorage.DataSource = dataSet.CarScheduling;
// Load data into the 'CarsDBDataSet.CarScheduling' table.
this.tableAdapter = new CarsDBDataSetTableAdapters.CarSchedulingTableAdapter();
this.tableAdapter.Fill(dataSet.CarScheduling);
// Create a new report instance.
XtraSchedulerReport report = new XtraSchedulerReport();
// Specify the scheduler storage for the print adapter.
printAdapter.SchedulerStorage = storage;
// Specify the time inteval and start day of week used by the print adapter to create a report.
printAdapter.TimeInterval =
new TimeInterval(new DateTime(2010, 7, 15), new DateTime(2010, 7, 30));
printAdapter.FirstDayOfWeek = FirstDayOfWeek.Tuesday;
// Implement appointment filtering.
printAdapter.ValidateAppointments +=
new AppointmentsValidationEventHandler(printAdapter_ValidateAppointments);
// Specify the print adapter which provides data for the report.
report.SchedulerAdapter = printAdapter.SchedulerAdapter;
// Create a document from the report, so the report can be displayed or printed.
report.CreateDocument();
// Create a preview model with the specified report.
XtraReportPreviewModel previewModel = new XtraReportPreviewModel(report);
// Specify the model for the DocumentPreview control.
documentPreview.Model = previewModel;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
model.AutoShowParametersPanel = false;
oDocPreview.Model = model;
//XtraPageSettingsBase oPage = report.PrintingSystem.PageSettings;
//oPage.PaperKind = System.Drawing.Printing.PaperKind.Custom;
//oPage = report.PrintingSystem.PageSettings;
//model.Report.ApplyPageSettings(oPage);
//report.PrintingSystem.SetCommandVisibility(PrintingSystemCommand.SendFile, CommandVisibility.None);
//report.PrintingSystem.SetCommandVisibility(PrintingSystemCommand.Watermark, CommandVisibility.None);
//report.CreateDocument();
//report.CreateDocument(false);
//DocumentPreviewWindow oPrev = new DocumentPreviewWindow() { Model = model };
//report.CreateDocument(false);
//oPrev.ShowDialog();
//report.CreateDocument(true);
}
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();
//}
}
}
protected virtual XtraReportPreviewModel CreateReportPreviewModel(IReport report)
{
var rr = new XtraReportPreviewModel(report);
return new XtraReportPreviewModel(report);
}
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 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 printControl1_Load(object sender, EventArgs e)
{
XtraReportPreviewModel model = new XtraReportPreviewModel(report);
model.AutoShowParametersPanel = false;
}
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
}
}
}
