private void buttonOK_Click(object sender, EventArgs e) { MSetting set = (MSetting)DataMaster.GetObjectByProperty(typeof(MSetting), MSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); set.AutoPrintSales = autoPrintSalesCheckBox.Checked; set.CompanyAddress = companyAddressTextBox.Text; set.CompanyCity = companyCityTextBox.Text; set.CompanyName = companyNameTextBox.Text; set.CompanyTelp = companyTelpTextBox.Text; set.AutoBackup = autoBackupCheckBox.Checked; set.BackupDir = backupDirTextBox.Text; set.FacturNoFormat = facturNoFormatTextBox.Text; DataMaster.UpdatePersistence(set); TBilliardSetting tbil = (TBilliardSetting)DataMaster.GetObjectByProperty(typeof(TBilliardSetting), TBilliardSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); tbil.BiliardItemPrice = biliardItemPriceNumericUpDown.Value; tbil.BiliardItemPriceMini = biliardItemPriceMiniNumericUpDown.Value; tbil.BiliardItemPriceVip = biliardItemPriceVipNumericUpDown.Value; tbil.FullfillPrice = fullfillPriceNumericUpDown.Value; tbil.MinimumPlay = minimumPlayNumericUpDown.Value; tbil.QuitTimeout = quitTimeoutNumericUpDown.Value; DataMaster.UpdatePersistence(tbil); BindData(); }
private void BindData() { set = (MSetting)DataMaster.GetObjectByProperty(typeof(MSetting), MSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); if (set != null) { mSettingDetail(); } bilSet = (TBilliardSetting)DataMaster.GetObjectByProperty(typeof(TBilliardSetting), TBilliardSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); if (bilSet != null) { billiardSettingDetail(); } bonus = (TBonus)DataMaster.GetObjectByProperty(typeof(TBonus), TBonus.ColumnNames.SettingId, AppCode.AssemblyProduct); if (bonus != null) { bonusSettingDetail(); } }
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(); }
private void buttonOK_Click(object sender, EventArgs e) { bool isSave = (set == null); if (isSave) { set = new MSetting(); } set.AutoPrintSales = autoPrintSalesCheckBox.Checked; set.CompanyAddress = companyAddressTextBox.Text; set.CompanyAddress2 = companyAddress2TextBox.Text; if (label_ImageLogoLocation.Text != label_ImageLogoLocation.Name) { if (label_ImageLogoLocation.Text != tempFileLoc) { FileInfo f = new FileInfo(label_ImageLogoLocation.Text); FileStream fs = f.OpenRead(); byte[] data = new byte[fs.Length]; fs.Read(data, 0, int.Parse(fs.Length.ToString())); fs.Flush(); fs.Close(); set.CompanyLogo = data; fs.Dispose(); } } if (label_ImageLogoLocation.Text == tempFileLoc) { try { FileInfo f = new FileInfo(label_ImageLogoLocation.Text); f.Directory.Delete(true); } catch (Exception) { } } set.CompanyFax = companyFaxTextBox.Text; set.CompanyNpwp = companyNpwpTextBox.Text; set.CompanyPkpDate = companyPkpDateDateTimePicker.Value; set.CompanyCity = companyCityTextBox.Text; set.CompanyName = companyNameTextBox.Text; set.CompanyTelp = companyTelpTextBox.Text; set.AutoBackup = autoBackupCheckBox.Checked; set.BackupDir = backupDirTextBox.Text; set.FacturNoFormat = facturNoFormatTextBox.Text; set.FacturNoLength = Convert.ToInt32(facturNoLengthNumericUpDown.Value); set.SettingId = AppCode.AssemblyProduct; set.ModifiedBy = lbl_UserName.Text; set.ModifiedDate = DateTime.Now; if (isSave) { DataMaster.SavePersistence(set); } else { DataMaster.UpdatePersistence(set); } isSave = (bilSet == null); if (isSave) { bilSet = new TBilliardSetting(); } //price periode I bilSet.BiliardItemPrice = biliardItemPriceNumericUpDown.Value; bilSet.BiliardItemPriceMini = biliardItemPriceMiniNumericUpDown.Value; bilSet.BiliardItemPriceVip = biliardItemPriceVipNumericUpDown.Value; //hour bilSet.BiliardItemHourFrom1 = Convert.ToInt32(biliardItemHourFrom1NumericUpDown.Value); bilSet.BiliardItemHourTo1 = Convert.ToInt32(biliardItemHourTo1NumericUpDown.Value); //price periode II bilSet.BiliardItemPrice2 = biliardItemPrice2NumericUpDown.Value; bilSet.BiliardItemPriceMini2 = biliardItemPriceMini2NumericUpDown.Value; bilSet.BiliardItemPriceVip2 = biliardItemPriceVip2NumericUpDown.Value; //hour bilSet.BiliardItemHourFrom2 = Convert.ToInt32(biliardItemHourFrom2NumericUpDown.Value); bilSet.BiliardItemHourTo2 = Convert.ToInt32(biliardItemHourTo2NumericUpDown.Value); //price periode III bilSet.BiliardItemPrice3 = biliardItemPrice3NumericUpDown.Value; bilSet.BiliardItemPriceMini3 = biliardItemPriceMini3NumericUpDown.Value; bilSet.BiliardItemPriceVip3 = biliardItemPriceVip3NumericUpDown.Value; //hour bilSet.BiliardItemHourFrom3 = Convert.ToInt32(biliardItemHourFrom3NumericUpDown.Value); bilSet.BiliardItemHourTo3 = Convert.ToInt32(biliardItemHourTo3NumericUpDown.Value); bilSet.FullfillPrice = fullfillPriceNumericUpDown.Value; bilSet.RefereeBonus = refereeBonusNumericUpDown.Value; bilSet.MinimumPlay = minimumPlayNumericUpDown.Value; bilSet.QuitTimeout = quitTimeoutNumericUpDown.Value; //wasit bilSet.UseReferee = useRefereeCheckBox.Checked; //waktu bilSet.ToleranceTime = toleranceTimeNumericUpDown.Value; bilSet.CalculateTime = calculateTimeNumericUpDown.Value; //setting meja common bilSet.BackColor = ColorTranslator.ToWin32(splitContainer1.Panel1.BackColor); bilSet.DeskBackColor = ColorTranslator.ToWin32(btn_Bil.BackColor); bilSet.DeskFontBold = btn_Bil.Font.Bold; bilSet.DeskFontColor = ColorTranslator.ToWin32(btn_Bil.ForeColor); bilSet.DeskFontItalic = btn_Bil.Font.Italic; bilSet.DeskFontName = btn_Bil.Font.Name; bilSet.DeskFontSize = decimal.Parse(btn_Bil.Font.Size.ToString()); bilSet.DeskFontUnderline = btn_Bil.Font.Underline; bilSet.DeskHeight = btn_Bil.Height; bilSet.DeskWidth = btn_Bil.Width; //booking bilSet.DeskBackColor1 = ColorTranslator.ToWin32(btn_Bil1.BackColor); bilSet.DeskFontBold1 = btn_Bil1.Font.Bold; bilSet.DeskFontColor1 = ColorTranslator.ToWin32(btn_Bil1.ForeColor); bilSet.DeskFontItalic1 = btn_Bil1.Font.Italic; bilSet.DeskFontName1 = btn_Bil1.Font.Name; bilSet.DeskFontSize1 = decimal.Parse(btn_Bil1.Font.Size.ToString()); bilSet.DeskFontUnderline1 = btn_Bil1.Font.Underline; //booking bilSet.DeskBackColor2 = ColorTranslator.ToWin32(btn_Bil2.BackColor); bilSet.DeskFontBold2 = btn_Bil2.Font.Bold; bilSet.DeskFontColor2 = ColorTranslator.ToWin32(btn_Bil2.ForeColor); bilSet.DeskFontItalic2 = btn_Bil2.Font.Italic; bilSet.DeskFontName2 = btn_Bil2.Font.Name; bilSet.DeskFontSize2 = decimal.Parse(btn_Bil2.Font.Size.ToString()); bilSet.DeskFontUnderline2 = btn_Bil2.Font.Underline; bilSet.ModifiedBy = lbl_UserName.Text; bilSet.ModifiedDate = DateTime.Now; bilSet.SettingId = AppCode.AssemblyProduct; if (isSave) { DataMaster.SavePersistence(bilSet); } else { DataMaster.UpdatePersistence(bilSet); } isSave = (bonus == null); if (isSave) { bonus = new TBonus(); } bonus.ItemId = itemIdTextBox.Text; bonus.Quantity = quantityNumericUpDown.Value; bonus.ModifiedBy = lbl_UserName.Text; bonus.ModifiedDate = DateTime.Now; bonus.SettingId = AppCode.AssemblyProduct; if (isSave) { DataMaster.SavePersistence(bonus); } else { DataMaster.UpdatePersistence(bonus); } BindData(); MessageBox.Show(this.Text + " berhasil disimpan !!", AppCode.AssemblyProduct, MessageBoxButtons.OK, MessageBoxIcon.Information); }