Exemple #1
0
        //private void FillRekapTotalTransactionByItemDataSource(string transStatus)
        //{
        //    bs = new BindingSource();
        //    bs.Clear();
        //    if (!transStatus.Equals(lbl_Param1.Name))
        //        bs.DataSource = DataMaster.GetListEq(typeof(VTotalTransactionByItem), VTotalTransactionByItem.ColumnNames.TransactionStatus, transStatus);
        //    else
        //        bs.DataSource = DataMaster.GetAll(typeof(VTotalTransactionByItem));

        //    reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionByItem", bs));
        //}

        private void FillTransactionTotalSource(string transStatus, DateTime from, DateTime to)
        {
            bs = new BindingSource();
            bs.Clear();
            if (!transStatus.Equals(lbl_Param1.Name))
            {
                bs.DataSource = DataMaster.GetListBetweenEqValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to, VTotalTransactionDetail.ColumnNames.TransactionStatus, transStatus);
            }
            else
            {
                bs.DataSource = DataMaster.GetListBetweenValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to);
            }

            reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDetail", bs));

            ReportParameter[] parameters = new ReportParameter[3];
            parameters[0] = new ReportParameter("Report_Parameter_DateFrom", from.ToString("f"));
            parameters[1] = new ReportParameter("Report_Parameter_DateTo", to.ToString("f"));
            parameters[2] = new ReportParameter("Report_Parameter_Status", transStatus);
            reportViewer1.LocalReport.SetParameters(parameters);

            bs = new BindingSource();
            bs.Clear();
            if (transStatus.Equals(lbl_Param1.Name) || transStatus.Equals(ListOfTransaction.Sales.ToString()) || transStatus.Equals(ListOfTransaction.SalesVIP.ToString()))
            {
                bs.DataSource = DataMaster.GetListBetweenEqValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to, TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString());
            }
            else
            {
                bs.DataSource = DataMaster.GetListBetweenEqValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to, TTransaction.ColumnNames.TransactionStatus, transStatus);
            }

            reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_TTransaction", bs));
        }
        private void FillUserLogSource(DateTime from, DateTime to, string p)
        {
            bs = new BindingSource();
            bs.Clear();
            if (!string.IsNullOrEmpty(p))
            {
                bs.DataSource = DataMaster.GetListBetweenEqValue(typeof(TLog), TLog.ColumnNames.LogDate, from, to, TLog.ColumnNames.LogUser, p);
            }
            else
            {
                bs.DataSource = DataMaster.GetListBetweenValue(typeof(TLog), TLog.ColumnNames.LogDate, from, to);
            }

            reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_TLog", bs));
        }
Exemple #3
0
 private void FillVStokCard(DateTime DateFrom, DateTime DateTo)
 {
     bs            = new BindingSource();
     bs.DataSource = DataMaster.GetListBetweenValue(typeof(VStokCard), VStokCard.ColumnNames.StokCardDate, DateFrom, DateTo);
     reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VStokCard", bs));
 }
        private void buttonOK_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Anda yakin melakukan tutup hari?", "Konfirmasi tutup hari", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
            {
                return;
            }

            pb_Loading.Visible  = true;
            lbl_Loading.Visible = true;

            pb_Loading.Maximum = 5;
            pb_Loading.Value   = 0;
            this.Refresh();

            DateTime from = dt_ClosingFrom.Value;
            DateTime to   = dt_ClosingTo.Value;

            IList              listEmployee = DataMaster.GetAll(typeof(MEmployee));
            MEmployee          emp;
            IList              listTrans;
            TTransaction       trans;
            IList              listDet;
            TTransactionDetail transDet;
            TRekapTransaction  rekapTrans;
            TRekapCommission   rekapCom;

            decimal          refereePrice = 0;
            string           billiardItem = "Rental Meja";
            TBilliardSetting bilSet       = (TBilliardSetting)DataMaster.GetObjectByProperty(typeof(TBilliardSetting), TBilliardSetting.ColumnNames.SettingId, AppCode.AssemblyProduct);

            if (bilSet == null)
            {
                MessageBox.Show("Setting untuk menghitung komisi wasit tidak terdaftar, \n Hubungi supervisor anda untuk konfigurasi sistem. \n Atau klik menu Tools - Konfigurasi Program", "Konfirmasi tutup hari", MessageBoxButtons.OK);
                return;
            }
            else
            {
                if (bilSet.RefereeBonus == 0)
                {
                    MessageBox.Show("Bonus wasit 0, \n Hubungi supervisor anda untuk konfigurasi sistem. \n Atau klik menu Tools - Konfigurasi Program", "Konfirmasi tutup hari", MessageBoxButtons.OK);
                    return;
                }
                else
                {
                    refereePrice = bilSet.RefereeBonus;
                }
            }


            decimal totSales         = 0;
            decimal totSalesVIP      = 0;
            decimal totReturSales    = 0;
            decimal totReturSalesVIP = 0;
            decimal totPurchase      = 0;
            decimal totReturPurchase = 0;
            decimal totCorrection    = 0;
            decimal q = 0;

            decimal totDuration;
            decimal totBonus;


            pb_Loading.Value = 1;

            //looping for available employee
            for (int i = 0; i < listEmployee.Count; i++)
            {
                emp       = (MEmployee)listEmployee[i];
                listTrans = DataMaster.GetListBetweenEqValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to, TTransaction.ColumnNames.EmployeeId, emp.EmployeeId);
                if (listTrans.Count > 0)
                {
                    totDuration = 0;
                    totBonus    = 0;

                    //looping for list transaction
                    for (int j = 0; j < listTrans.Count; j++)
                    {
                        trans = (TTransaction)listTrans[j];

                        //searching transaction detail for billiard item
                        listDet = DataMaster.GetListLikeEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId, TTransactionDetail.ColumnNames.ItemId, billiardItem + "%");

                        if (listDet.Count > 0)
                        {
                            transDet = (TTransactionDetail)listDet[0];

                            if (transDet != null)
                            {
                                totDuration += transDet.Quantity;
                                totBonus    += transDet.Quantity * refereePrice;
                            }
                        }
                    }
                    totBonus = Math.Floor(totBonus / bilSet.FullfillPrice) * bilSet.FullfillPrice;

                    rekapCom                 = new TRekapCommission();
                    rekapCom.EmployeeId      = emp.EmployeeId;
                    rekapCom.RefereePrice    = refereePrice;
                    rekapCom.RefereePriceVip = refereePrice;

                    rekapCom.RekapBonus    = totBonus;
                    rekapCom.RekapDateFrom = from;
                    rekapCom.RekapDateTo   = to;

                    //duration in minutes
                    rekapCom.RekapTotalDuration = totDuration * 60;
                    rekapCom.ModifiedBy         = lbl_UserName.Text;
                    rekapCom.ModifiedDate       = DateTime.Now;
                    DataMaster.SavePersistence(rekapCom);
                }
            }

            //trans does not have referee
            listTrans = DataMaster.GetListBetweenEqValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to, TTransaction.ColumnNames.EmployeeId, string.Empty);
            if (listTrans.Count > 0)
            {
                totDuration = 0;
                totBonus    = 0;

                //looping for list transaction
                for (int j = 0; j < listTrans.Count; j++)
                {
                    trans = (TTransaction)listTrans[j];

                    //searching transaction detail for billiard item
                    listDet = DataMaster.GetListLikeEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId, TTransactionDetail.ColumnNames.ItemId, billiardItem + "%");

                    if (listDet.Count > 0)
                    {
                        transDet = (TTransactionDetail)listDet[0];
                        if (transDet != null)
                        {
                            totDuration += transDet.Quantity;
                            totBonus    += transDet.Quantity * refereePrice;
                        }
                    }
                }
                totBonus = Math.Floor(totBonus / bilSet.FullfillPrice) * bilSet.FullfillPrice;

                rekapCom                 = new TRekapCommission();
                rekapCom.EmployeeId      = string.Empty;
                rekapCom.RefereePrice    = refereePrice;
                rekapCom.RefereePriceVip = refereePrice;

                rekapCom.RekapBonus    = totBonus;
                rekapCom.RekapDateFrom = from;
                rekapCom.RekapDateTo   = to;
                //duration in minutes
                rekapCom.RekapTotalDuration = totDuration * 60;
                rekapCom.ModifiedBy         = lbl_UserName.Text;
                rekapCom.ModifiedDate       = DateTime.Now;
                DataMaster.SavePersistence(rekapCom);
            }


            pb_Loading.Value = 3;
            //sum transaction grand total by date
            listTrans = DataMaster.GetListBetweenValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to);

            for (int j = 0; j < listTrans.Count; j++)
            {
                trans = (TTransaction)listTrans[j];

                if (trans.TransactionStatus.Equals(ListOfTransaction.Sales.ToString()))
                {
                    totSales += trans.TransactionGrandTotal;
                }
                else if (trans.TransactionStatus.Equals(ListOfTransaction.SalesVIP.ToString()))
                {
                    totSalesVIP += trans.TransactionGrandTotal;
                }
                else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturSales.ToString()))
                {
                    totReturSales += trans.TransactionGrandTotal;
                }
                else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturSalesVIP.ToString()))
                {
                    totReturSalesVIP += trans.TransactionGrandTotal;
                }
                else if (trans.TransactionStatus.Equals(ListOfTransaction.Purchase.ToString()))
                {
                    totPurchase += trans.TransactionGrandTotal;
                }
                else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturPurchase.ToString()))
                {
                    totReturPurchase += trans.TransactionGrandTotal;
                }
                else if (trans.TransactionStatus.Equals(ListOfTransaction.Correction.ToString()))
                {
                    listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId);

                    for (int k = 0; k < listDet.Count; k++)
                    {
                        transDet = (TTransactionDetail)listDet[k];
                        q        = transDet.Quantity;
                        if (transDet.Quantity < 0)
                        {
                            q = transDet.Quantity * -1;
                        }
                        totCorrection += q;
                    }
                }
            }

            pb_Loading.Value              = 4;
            rekapTrans                    = new TRekapTransaction();
            rekapTrans.RekapDateFrom      = from;
            rekapTrans.RekapDateTo        = to;
            rekapTrans.TotalCorrection    = totCorrection;
            rekapTrans.TotalPurchase      = totPurchase;
            rekapTrans.TotalReturPurchase = totReturPurchase;
            rekapTrans.TotalReturSales    = totReturSales;
            rekapTrans.TotalReturSalesVip = totReturSalesVIP;
            rekapTrans.TotalSales         = totSales;
            rekapTrans.TotalSalesVip      = totSalesVIP;
            rekapTrans.ModifiedBy         = lbl_UserName.Text;
            rekapTrans.ModifiedDate       = DateTime.Now;
            DataMaster.SavePersistence(rekapTrans);


            pb_Loading.Value = 5;

            pb_Loading.Visible  = false;
            lbl_Loading.Visible = false;
            buttonOK.Enabled    = false;

            FormViewReport f_ViewReport = new FormViewReport();

            f_ViewReport.lbl_TempReport.Text = ListOfReports.ReportListTransaction.ToString();
            f_ViewReport.lbl_Param1.Text     = ListOfTransaction.Sales.ToString();
            f_ViewReport.lbl_Param2.Text     = dt_ClosingFrom.Value.ToString();
            f_ViewReport.lbl_Param3.Text     = dt_ClosingTo.Value.ToString();

            f_ViewReport.StartPosition = FormStartPosition.WindowsDefaultLocation;
            f_ViewReport.WindowState   = FormWindowState.Maximized;
            f_ViewReport.Show();
        }
Exemple #5
0
        private void buttonOK_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Anda yakin melakukan tutup periode?", "Konfirmasi tutup periode", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
            {
                return;
            }

            ModuleControlSettings.SaveLog(ListOfAction.Insert, dt_ClosingFrom.Value.ToLongDateString() + ";" + dt_ClosingTo.Value.ToLongDateString(), ListOfTable.TRekapTransaction, lbl_UserName.Text);

            pb_Loading.Visible  = true;
            lbl_Loading.Visible = true;

            pb_Loading.Maximum = 5;
            pb_Loading.Value   = 0;
            this.Refresh();

            DateTime from = dt_ClosingFrom.Value;
            DateTime to   = dt_ClosingTo.Value;

            IList              listTrans;
            TTransaction       trans;
            IList              listDet;
            TTransactionDetail transDet;
            TRekapTransaction  rekapTrans;

            decimal totSales         = 0;
            decimal totSalesVIP      = 0;
            decimal totReturSales    = 0;
            decimal totReturSalesVIP = 0;
            decimal totPurchase      = 0;
            decimal totReturPurchase = 0;
            decimal totCorrection    = 0;
            decimal q = 0;

            pb_Loading.Value = 1;

            //sum transaction grand total by date
            listTrans = DataMaster.GetListBetweenValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to);

            for (int j = 0; j < listTrans.Count; j++)
            {
                trans = (TTransaction)listTrans[j];

                if (trans.TransactionStatus.Equals(ListOfTransaction.Sales.ToString()))
                {
                    totSales += trans.TransactionGrandTotal;
                }
                else if (trans.TransactionStatus.Equals(ListOfTransaction.SalesVIP.ToString()))
                {
                    totSalesVIP += trans.TransactionGrandTotal;
                }
                else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturSales.ToString()))
                {
                    totReturSales += trans.TransactionGrandTotal;
                }
                else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturSalesVIP.ToString()))
                {
                    totReturSalesVIP += trans.TransactionGrandTotal;
                }
                else if (trans.TransactionStatus.Equals(ListOfTransaction.Purchase.ToString()))
                {
                    totPurchase += trans.TransactionGrandTotal;
                }
                else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturPurchase.ToString()))
                {
                    totReturPurchase += trans.TransactionGrandTotal;
                }
                else if (trans.TransactionStatus.Equals(ListOfTransaction.Correction.ToString()))
                {
                    listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId);

                    for (int k = 0; k < listDet.Count; k++)
                    {
                        transDet = (TTransactionDetail)listDet[k];
                        q        = transDet.Quantity;
                        if (transDet.Quantity < 0)
                        {
                            q = transDet.Quantity * -1;
                        }
                        totCorrection += q;
                    }
                }
            }

            rekapTrans = new TRekapTransaction();
            rekapTrans.RekapDateFrom      = from;
            rekapTrans.RekapDateTo        = to;
            rekapTrans.TotalCorrection    = totCorrection;
            rekapTrans.TotalPurchase      = totPurchase;
            rekapTrans.TotalReturPurchase = totReturPurchase;
            rekapTrans.TotalReturSales    = totReturSales;
            rekapTrans.TotalReturSalesVip = totReturSalesVIP;
            rekapTrans.TotalSales         = totSales;
            rekapTrans.TotalSalesVip      = totSalesVIP;
            rekapTrans.ModifiedBy         = lbl_UserName.Text;
            rekapTrans.ModifiedDate       = DateTime.Now;
            DataMaster.SavePersistence(rekapTrans);

            pb_Loading.Value = 4;
            ////delete before transaction
            //listTrans = DataMaster.GetListLessThan(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from);
            //for (int j = 0; j < listTrans.Count; j++)
            //{
            //    trans = (TTransaction)listTrans[j];
            //    DataMaster.Delete(trans);

            //    listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId);

            //    for (int k = 0; k < listDet.Count; k++)
            //    {
            //        transDet = (TTransactionDetail)listDet[k];
            //        DataMaster.Delete(transDet);
            //    }
            //}

            pb_Loading.Value = 5;

            pb_Loading.Visible = false;
            //lbl_Loading.Visible = false;

            buttonOK.Enabled = false;
            lbl_Loading.Text = "Tutup periode berhasil dilakukan.";

            try
            {
                System.Threading.Thread.Sleep(2000);
            }
            catch (Exception)
            {
            }

            f_ViewReport = new FormViewReport();

            f_ViewReport.lbl_TempReport.Text = ListOfReports.ReportTransactionTotal.ToString();
            // f_ViewReport.lbl_Param1.Text = ListOfTransaction.Sales.ToString();
            f_ViewReport.lbl_Param2.Text = dt_ClosingFrom.Value.ToString();
            f_ViewReport.lbl_Param3.Text = dt_ClosingTo.Value.ToString();

            f_ViewReport.StartPosition = FormStartPosition.WindowsDefaultLocation;
            f_ViewReport.WindowState   = FormWindowState.Maximized;
            f_ViewReport.Show();

            f_ViewReport.reportViewer1.RefreshReport();

            //export to excel
            string       exportDir = Application.StartupPath;
            TCafeSetting cafeSet   = (TCafeSetting)DataMaster.GetObjectByProperty(typeof(TCafeSetting), TCafeSetting.ColumnNames.SettingId, AppCode.AssemblyProduct);

            if (cafeSet != null)
            {
                exportDir = cafeSet.ExportedDir;
            }

            string fileName = exportDir + "\\Cafe " + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";

            Warning[] warnings;
            string[]  streamids;
            string    mimeType;
            string    encoding;
            string    filenameExtension;

            byte[] bytes = f_ViewReport.reportViewer1.LocalReport.Render(
                "Excel", null, out mimeType, out encoding, out filenameExtension,
                out streamids, out warnings);

            using (FileStream fs = new FileStream(fileName, FileMode.Create))
            {
                fs.Write(bytes, 0, bytes.Length);
            }

            if (MessageBox.Show("Laporan berhasil diekspor ke \n " + fileName + "\n Buka file?", "Ekspor Laporan ke File Excel", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
            {
                //Excel.Application exc = new Excel.Application;
                //Excel.Workbook wb = exc.Workbooks.Open(
                //System.IO.File.OpenRead(fileName);
                try
                {
                    System.Diagnostics.Process.Start(fileName);
                }
                catch (Exception)
                {
                    MessageBox.Show("File hasil ekspor gagal dibuka. Silahkan buka secara manual di lokasi hasil ekspor laporan.",
                                    "Laporan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
        }
Exemple #6
0
 private void FillVTotalTransactionDataSource(DateTime DateFrom, DateTime DateTo)
 {
     bs            = new BindingSource();
     bs.DataSource = DataMaster.GetListBetweenValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, DateFrom, DateTo);
     reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDetail", bs));
 }
Exemple #7
0
        private void CalculateItemValue()
        {
            //IList listGudang = DataMaster.GetAll(typeof(MGudang));
            //MGudang gud;

            //IList listItemStok;
            //ItemGudangStok stok;
            //MItem item;

            //decimal itemvalue = 0;

            //for (int i = 0; i < listGudang.Count; i++)
            //{
            //    gud = (MGudang)listGudang[i];
            //    listItemStok = DataMaster.GetListEq(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.GudangId, gud.GudangId);
            //    for (int j = 0; j < listItemStok.Count; j++)
            //    {
            //        stok = (ItemGudangStok)listItemStok[j];
            //        item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, stok.ItemId);
            //        if (item != null)
            //        {
            //            itemvalue += stok.ItemStok * item.ItemPricePurchaseAvg;
            //        }
            //    }
            //}

            IList              listTrans = DataMaster.GetListBetweenValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to);
            IList              listDet;
            TTransaction       trans;
            TTransactionDetail det;

            decimal salesTot       = 0;
            decimal retSalesTot    = 0;
            decimal hppSalesTot    = 0;
            decimal hppRetSalesTot = 0;

            //decimal purTot = 0;
            //decimal retPurTot = 0;

            for (int i = 0; i < listTrans.Count; i++)
            {
                trans = (TTransaction)listTrans[i];

                if (trans.TransactionStatus == ListOfTransaction.Sales.ToString() || trans.TransactionStatus == ListOfTransaction.Service.ToString() || trans.TransactionStatus == ListOfTransaction.ReturSales.ToString())
                {
                    if (trans.TransactionStatus == ListOfTransaction.Sales.ToString() || trans.TransactionStatus == ListOfTransaction.Service.ToString())
                    {
                        salesTot += trans.TransactionGrandTotal;
                    }
                    else if (trans.TransactionStatus == ListOfTransaction.ReturSales.ToString())
                    {
                        retSalesTot += trans.TransactionGrandTotal;
                    }


                    listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId);
                    for (int j = 0; j < listDet.Count; j++)
                    {
                        det = (TTransactionDetail)listDet[j];
                        if (trans.TransactionStatus == ListOfTransaction.Sales.ToString() || trans.TransactionStatus == ListOfTransaction.Service.ToString())
                        {
                            hppSalesTot += det.CostPrice;
                        }
                        else if (trans.TransactionStatus == ListOfTransaction.ReturSales.ToString())
                        {
                            hppRetSalesTot += det.CostPrice;
                        }
                    }
                }
                //else if (trans.TransactionStatus == ListOfTransaction.ReturSales.ToString())
                //    retSalesTot += trans.TransactionGrandTotal;
                //else if (trans.TransactionStatus == ListOfTransaction.Purchase.ToString())
                //    purTot += trans.TransactionGrandTotal;
                //else if (trans.TransactionStatus == ListOfTransaction.ReturPurchase.ToString())
                //    retPurTot += trans.TransactionGrandTotal;
            }

            decimal salesNet = salesTot - retSalesTot;
            decimal hppNet   = hppSalesTot - hppRetSalesTot;
            decimal laba     = salesNet - hppNet;

            ListViewItem v = new ListViewItem();

            v.Text = "Penjualan";
            v.SubItems.Add(salesTot.ToString("N"));
            listView1.Items.Add(v);

            v      = new ListViewItem();
            v.Text = "Retur Penjualan";
            v.SubItems.Add(retSalesTot.ToString("N"));
            listView1.Items.Add(v);

            v      = new ListViewItem();
            v.Text = string.Empty;
            v.SubItems.Add("--------------------------");
            listView1.Items.Add(v);

            v      = new ListViewItem();
            v.Text = "Penjualan Bersih";
            v.SubItems.Add(string.Empty);
            v.SubItems.Add(salesNet.ToString("N"));
            listView1.Items.Add(v);


            //v = new ListViewItem();
            //v.Text = "Pembelian";
            //v.SubItems.Add(purTot.ToString("N"));
            //listView1.Items.Add(v);

            //v = new ListViewItem();
            //v.Text = "Retur Pembelian";
            //v.SubItems.Add(retPurTot.ToString("N"));
            //listView1.Items.Add(v);

            //v = new ListViewItem();
            //v.Text = string.Empty;
            //v.SubItems.Add("--------------------------");
            //listView1.Items.Add(v);

            //v = new ListViewItem();
            //v.Text = "Pembelian Bersih";
            //v.SubItems.Add(string.Empty);
            //v.SubItems.Add(purNet.ToString("N"));
            //listView1.Items.Add(v);

            v      = new ListViewItem();
            v.Text = "Harga Pokok Penjualan Periode " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString();
            v.SubItems.Add(string.Empty);
            v.SubItems.Add(hppNet.ToString("N"));
            listView1.Items.Add(v);

            v      = new ListViewItem();
            v.Text = string.Empty;
            v.SubItems.Add(string.Empty);
            v.SubItems.Add("--------------------------");
            listView1.Items.Add(v);

            v      = new ListViewItem();
            v.Text = "Laba / Rugi";
            v.SubItems.Add(string.Empty);
            v.SubItems.Add(laba.ToString("N"));
            listView1.Items.Add(v);

            SaveRekap(listAcc.Sales, "Penjualan", salesTot);
            SaveRekap(listAcc.ReturSales, "Retur Penjualan", retSalesTot);
            SaveRekap(listAcc.SalesNet, "Penjualan Bersih", salesNet);
            SaveRekap(listAcc.HPP, "Harga Pokok Penjualan", hppNet);
            SaveRekap(listAcc.RugiLaba, "Laba / Rugi", laba);


            //string voucherno = AppCode.GetVoucherNo();

            //TJournal jur = new TJournal();
            //jur.JournalDate = DateTime.Today;
            //jur.JournalDesc = "Persediaan barang akhir bulan " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString();
            //jur.JournalJumlah = itemvalue;
            //jur.JournalPic = string.Empty;
            //jur.JournalStatus = ListOfJournalStatus.Debet.ToString();
            //jur.SubAccountId = AppCode.GetPersediaanAccountNo();
            //jur.VoucherNo = voucherno;
            //jur.ModifiedBy = lbl_UserName.Text;
            //jur.ModifiedDate = DateTime.Now;
            //AppCode.SaveTJournal(jur);

            //jur = new TJournal();
            //jur.JournalDate = DateTime.Today;
            //jur.JournalDesc = "Ikhtiar Rugi Laba bulan " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString();
            //jur.JournalJumlah = itemvalue;
            //jur.JournalPic = string.Empty;
            //jur.JournalStatus = ListOfJournalStatus.Kredit.ToString();
            //jur.SubAccountId = AppCode.GetIkhtiarRLAccountNo();
            //jur.VoucherNo = voucherno;
            //jur.ModifiedBy = lbl_UserName.Text;
            //jur.ModifiedDate = DateTime.Now;
            //AppCode.SaveTJournal(jur);
        }