private void btnPost_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsmLoanApplication", "Post")) { return; } string _LoanApplicationId = dgvList.CurrentRow.Cells[0].Value.ToString(); DataTable _dt = loLoanApplication.getLoanApplicationStatus(_LoanApplicationId); if (_dt.Rows.Count > 0) { foreach (DataRow _drStatus in _dt.Rows) { if (_drStatus[0].ToString() == "In Process") { MessageBoxUI _mbStatus = new MessageBoxUI("You cannot post an IN PROCESS application!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } else if (_drStatus[0].ToString() == "Cancelled") { MessageBoxUI _mbStatus = new MessageBoxUI("You cannot post a CANCELLED application!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } else if (_drStatus[0].ToString() == "Posted") { MessageBoxUI _mbStatus = new MessageBoxUI("Loan application is already POSTED!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } } } else { MessageBoxUI _mbStatus = new MessageBoxUI("Loan Application Id does not exist!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } if (dgvList.Rows.Count > 0) { DialogResult _dr = new DialogResult(); MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue posting this Loan Application record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo); _mb.ShowDialog(); _dr = _mb.Operation; if (_dr == DialogResult.Yes) { try { if (loLoanApplication.post(_LoanApplicationId)) { //create loan application detail foreach (DataRow _drHeader in loLoanApplication.getAllData("", _LoanApplicationId, "").Rows) { string _PaymentFrequency = _drHeader["Payment Frequency"].ToString(); int _Terms = int.Parse(_drHeader["Terms"].ToString()); DateTime _StartDate = DateTime.Parse(_drHeader["Start Date"].ToString()); DateTime _MaturityDate = DateTime.Parse(_drHeader["Maturity Date"].ToString()); decimal _TotalAmountDue = decimal.Parse(_drHeader["Total Amount Due"].ToString()); decimal _InstallmentAmountDue = decimal.Parse(_drHeader["Installment Amount Due"].ToString()); decimal _OriginalTotalAmountDue = decimal.Parse(_drHeader["Total Amount Due"].ToString()); loLoanApplicationDetail.DetailId = ""; loLoanApplicationDetail.LoanApplicationId = _LoanApplicationId; loLoanApplicationDetail.SeqNo = 0; loLoanApplicationDetail.Date = _StartDate; loLoanApplicationDetail.AmountDue = _TotalAmountDue; loLoanApplicationDetail.InstallmentAmount = _InstallmentAmountDue; loLoanApplicationDetail.PaymentAmount = 0; loLoanApplicationDetail.RunningBalance = _OriginalTotalAmountDue; loLoanApplicationDetail.NewBalance = 0; loLoanApplicationDetail.Variance = 0; loLoanApplicationDetail.PastDueReason = ""; loLoanApplicationDetail.Remarks = ""; loLoanApplicationDetail.UserId = GlobalVariables.UserId; loLoanApplicationDetail.save(GlobalVariables.Operation.Add); int i = 1; for (DateTime _startDate = _StartDate.AddDays(1); _startDate <= _MaturityDate;) { loLoanApplicationDetail.DetailId = ""; loLoanApplicationDetail.LoanApplicationId = _LoanApplicationId; loLoanApplicationDetail.SeqNo = i; loLoanApplicationDetail.Date = _startDate; loLoanApplicationDetail.AmountDue = _TotalAmountDue - _InstallmentAmountDue; loLoanApplicationDetail.InstallmentAmount = _InstallmentAmountDue; loLoanApplicationDetail.PaymentAmount = 0; loLoanApplicationDetail.RunningBalance = _OriginalTotalAmountDue; loLoanApplicationDetail.NewBalance = 0; loLoanApplicationDetail.Variance = 0; loLoanApplicationDetail.PastDueReason = ""; loLoanApplicationDetail.Remarks = ""; loLoanApplicationDetail.UserId = GlobalVariables.UserId; loLoanApplicationDetail.save(GlobalVariables.Operation.Add); _startDate = _startDate.AddDays(1); _TotalAmountDue = _TotalAmountDue - _InstallmentAmountDue; i++; } } //lacking post to accounting system... MessageBoxUI _mb1 = new MessageBoxUI("Loan Application record has been successfully posted!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK); _mb1.ShowDialog(); refresh(); } } catch (Exception ex) { MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); mb.ShowDialog(); return; } } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnApprove_Click"); em.ShowDialog(); return; } }
private void btnSave_Click(object sender, EventArgs e) { try { loBranch.Id = lId; loBranch.Code = txtCode.Text; loBranch.Description = GlobalFunctions.replaceChar(txtDescription.Text); try { loBranch.AreaId = cboArea.SelectedValue.ToString(); } catch { MessageBoxUI _mb = new MessageBoxUI("You must select an Area!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); cboArea.Focus(); return; } try { loBranch.BranchManager = cboBranchManager.SelectedValue.ToString(); } catch { MessageBoxUI _mb = new MessageBoxUI("You must select a Branch Manager!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); cboBranchManager.Focus(); return; } loBranch.Remarks = GlobalFunctions.replaceChar(txtRemarks.Text); loBranch.UserId = GlobalVariables.UserId; string _Id = loBranch.save(lOperation); if (_Id != "") { MessageBoxUI _mb = new MessageBoxUI("Branch has been saved successfully!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK); _mb.showDialog(); lRecords[0] = _Id; lRecords[1] = txtCode.Text; lRecords[2] = txtDescription.Text; lRecords[3] = cboArea.Text; lRecords[4] = cboBranchManager.Text; lRecords[5] = txtRemarks.Text; object[] _params = { lRecords }; if (lOperation == GlobalVariables.Operation.Edit) { ParentList.GetType().GetMethod("updateData").Invoke(ParentList, _params); this.Close(); } else { ParentList.GetType().GetMethod("addData").Invoke(ParentList, _params); clear(); } } else { MessageBoxUI _mb = new MessageBoxUI("Failure to save the record!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); return; } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click"); em.ShowDialog(); return; } }
private void btnSave_Click(object sender, EventArgs e) { try { if (decimal.Parse(txtTotalQtyOut.Text) == 0) { MessageBoxUI _mb1 = new MessageBoxUI("Totals of Qty must not be Zero(0)!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb1.showDialog(); return; } string _CustomerId = ""; try { _CustomerId = cboCustomer.SelectedValue.ToString(); } catch { _CustomerId = ""; } DialogResult _dr = new DialogResult(); MessageBoxUI _mb = new MessageBoxUI("Continue saving this Stock Withdrawal?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo); _mb.ShowDialog(); _dr = _mb.Operation; if (_dr == DialogResult.Yes) { loInventory.Id = lInventoryId; loInventory.Date = dtpDate.Value; loInventory.Type = "Stock Withdrawal"; loInventory.POId = ""; try { loInventory.SOId = cboSalesOrder.Text; } catch { loInventory.SOId = ""; } loInventory.STInId = ""; loInventory.STOutId = ""; loInventory.Reference = GlobalFunctions.replaceChar(txtReference.Text); loInventory.CustomerId = _CustomerId; loInventory.SupplierId = "0"; loInventory.TotalPOQty = 0; loInventory.TotalQtyIn = 0; loInventory.TotalSOQty = decimal.Parse(txtTotalSOQty.Text); loInventory.TotalQtyOut = decimal.Parse(txtTotalQtyOut.Text); loInventory.TotalVariance = decimal.Parse(txtTotalVariance.Text); loInventory.FromLocationId = ""; loInventory.ToLocationId = ""; loInventory.Remarks = GlobalFunctions.replaceChar(txtRemarks.Text); loInventory.UserId = GlobalVariables.UserId; try { string _InventoryId = loInventory.save(lOperation); if (_InventoryId != "") { for (int i = 0; i < dgvDetail.Rows.Count; i++) { if (dgvDetail.Rows[i].Cells["Status"].Value.ToString() == "Add") { try { loInventoryDetail.DetailId = dgvDetail.Rows[i].Cells[0].Value.ToString(); } catch { loInventoryDetail.DetailId = ""; } try { loInventoryDetail.InventoryId = _InventoryId; loInventoryDetail.PODetailId = "0"; loInventoryDetail.SODetailId = dgvDetail.Rows[i].Cells[1].Value.ToString(); loInventoryDetail.StockId = dgvDetail.Rows[i].Cells[2].Value.ToString(); loInventoryDetail.LocationId = dgvDetail.Rows[i].Cells[6].Value.ToString(); loInventoryDetail.POQty = 0; loInventoryDetail.QtyIn = 0; loInventoryDetail.SOQty = decimal.Parse(dgvDetail.Rows[i].Cells[8].Value.ToString()); loInventoryDetail.QtyOut = decimal.Parse(dgvDetail.Rows[i].Cells[9].Value.ToString()); loInventoryDetail.Variance = decimal.Parse(dgvDetail.Rows[i].Cells[10].Value.ToString()); loInventoryDetail.Remarks = dgvDetail.Rows[i].Cells[11].Value.ToString(); loInventoryDetail.UserId = GlobalVariables.UserId; loInventoryDetail.save(GlobalVariables.Operation.Add); } catch { } } else if (dgvDetail.Rows[i].Cells["Status"].Value.ToString() == "Edit") { try { loInventoryDetail.DetailId = dgvDetail.Rows[i].Cells[0].Value.ToString(); } catch { loInventoryDetail.DetailId = ""; } try { loInventoryDetail.InventoryId = _InventoryId; loInventoryDetail.PODetailId = "0"; loInventoryDetail.SODetailId = dgvDetail.Rows[i].Cells[1].Value.ToString(); loInventoryDetail.StockId = dgvDetail.Rows[i].Cells[2].Value.ToString(); loInventoryDetail.LocationId = dgvDetail.Rows[i].Cells[6].Value.ToString(); loInventoryDetail.POQty = 0; loInventoryDetail.QtyIn = 0; loInventoryDetail.SOQty = decimal.Parse(dgvDetail.Rows[i].Cells[8].Value.ToString()); loInventoryDetail.QtyOut = decimal.Parse(dgvDetail.Rows[i].Cells[9].Value.ToString()); loInventoryDetail.Variance = decimal.Parse(dgvDetail.Rows[i].Cells[10].Value.ToString()); loInventoryDetail.Remarks = dgvDetail.Rows[i].Cells[11].Value.ToString(); loInventoryDetail.UserId = GlobalVariables.UserId; loInventoryDetail.save(GlobalVariables.Operation.Edit); } catch { } } else if (dgvDetail.Rows[i].Cells["Status"].Value.ToString() == "Delete") { loInventoryDetail.remove(dgvDetail.Rows[i].Cells[0].Value.ToString()); } } if (txtId.Text == _InventoryId) { MessageBoxUI _mb2 = new MessageBoxUI("Stock Withdrawal has been saved successfully!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK); _mb2.showDialog(); } else { MessageBoxUI _mb2 = new MessageBoxUI("Stock Withdrawal has been saved successfully! New Stock Withdrawal Id : " + _InventoryId, GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK); _mb2.showDialog(); } //previewDetail(_InventoryId); object[] _params = { "Stock Withdrawal" }; ParentList.GetType().GetMethod("refresh").Invoke(ParentList, _params); this.Close(); } } catch (Exception ex) { if (ex.Message.Contains("Unclosed quotation mark after the character string")) { MessageBoxUI _mb3 = new MessageBoxUI("Do not use this character( ' ).", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb3.showDialog(); return; } else { MessageBoxUI _mb3 = new MessageBoxUI(ex.Message, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb3.showDialog(); return; } } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click"); em.ShowDialog(); return; } }
private void btnSave_Click(object sender, EventArgs e) { try { loEmployee.Id = lId; loEmployee.EmployeeNo = GlobalFunctions.replaceChar(txtEmployeeNo.Text); loEmployee.Lastname = GlobalFunctions.replaceChar(txtLastname.Text); loEmployee.Firstname = GlobalFunctions.replaceChar(txtFirstname.Text); loEmployee.Middlename = GlobalFunctions.replaceChar(txtMiddlename.Text); loEmployee.Active = chkActive.Checked ? "Y" : "N"; loEmployee.BiometricsIdNo = GlobalFunctions.replaceChar(txtBiometricsIdNo.Text); try { loEmployee.EmploymentTypeId = cboEmploymentType.SelectedValue.ToString(); } catch { loEmployee.EmploymentTypeId = "0"; } try { loEmployee.DesignationId = cboDesignation.SelectedValue.ToString(); } catch { loEmployee.DesignationId = "0"; } try { loEmployee.DepartmentId = cboDepartment.SelectedValue.ToString(); } catch { loEmployee.DepartmentId = "0"; } loEmployee.NoWorkSchedule = chkActive.Checked ? "Y" : "N"; try { loEmployee.WorkScheduleId = cboWorkSchedule.SelectedValue.ToString(); } catch { loEmployee.WorkScheduleId = "0"; } loEmployee.Birthday = dtpBirthday.Value; loEmployee.EmailAddress = GlobalFunctions.replaceChar(txtEmailAddress.Text); loEmployee.TIN = GlobalFunctions.replaceChar(txtTIN.Text); loEmployee.TINDeducted = chkTINDeducted.Checked ? "Y" : "N"; loEmployee.PhilHealthId = GlobalFunctions.replaceChar(txtPhilHealthId.Text); loEmployee.PhilHealthDeducted = chkPhilHealthDeducted.Checked ? "Y" : "N"; loEmployee.SSSId = GlobalFunctions.replaceChar(txtSSSId.Text); loEmployee.SSSDeducted = chkSSSDeducted.Checked ? "Y" : "N"; loEmployee.PagibigId = GlobalFunctions.replaceChar(txtPagibigId.Text); loEmployee.PagibigDeducted = chkPagibigDeducted.Checked ? "Y" : "N"; loEmployee.PagibigEmployeeShare = decimal.Parse(txtPagibigEmployeeShare.Text); loEmployee.PagibigEmployerShare = decimal.Parse(txtPagibigEmployerShare.Text); loEmployee.NoOfDependent = int.Parse(txtNoOfDependent.Text); loEmployee.RateType = cboRateType.Text; loEmployee.BasicPay = decimal.Parse(txtBasicPay.Text); try { loEmployee.ImmediateSupervisor = cboImmediateSupervisor.SelectedValue.ToString(); } catch { loEmployee.ImmediateSupervisor = "0"; } loEmployee.Remarks = GlobalFunctions.replaceChar(txtRemarks.Text); loEmployee.UserId = GlobalVariables.UserId; string _Id = loEmployee.save(lOperation); if (_Id != "") { MessageBoxUI _mb = new MessageBoxUI("Employee has been saved successfully!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK); _mb.showDialog(); lRecords[0] = _Id; lRecords[1] = txtEmployeeNo.Text; lRecords[2] = txtLastname.Text; lRecords[3] = txtFirstname.Text; lRecords[4] = txtMiddlename.Text; lRecords[5] = chkActive.Checked ? "Y" : "N"; lRecords[6] = txtBiometricsIdNo.Text; lRecords[7] = cboEmploymentType.Text; lRecords[8] = cboDesignation.Text; lRecords[9] = cboDepartment.Text; lRecords[10] = chkNoWorkSchedule.Checked ? "Y" : "N"; lRecords[11] = cboWorkSchedule.Text; lRecords[12] = string.Format("{0:MM-dd-yyyy}", dtpBirthday.Value); lRecords[13] = txtEmailAddress.Text; lRecords[14] = txtTIN.Text; lRecords[15] = chkTINDeducted.Checked ? "Y" : "N"; lRecords[16] = txtPhilHealthId.Text; lRecords[17] = chkPhilHealthDeducted.Checked ? "Y" : "N"; lRecords[18] = txtSSSId.Text; lRecords[19] = chkSSSDeducted.Checked ? "Y" : "N"; lRecords[20] = txtPagibigId.Text; lRecords[21] = chkPagibigDeducted.Checked ? "Y" : "N"; lRecords[22] = decimal.Parse(txtPagibigEmployeeShare.Text).ToString(); lRecords[23] = decimal.Parse(txtPagibigEmployerShare.Text).ToString(); lRecords[24] = int.Parse(txtNoOfDependent.Text).ToString(); lRecords[25] = cboRateType.Text; lRecords[26] = decimal.Parse(txtBasicPay.Text).ToString(); lRecords[27] = cboImmediateSupervisor.Text; lRecords[28] = txtRemarks.Text; object[] _params = { lRecords }; if (lOperation == GlobalVariables.Operation.Edit) { ParentList.GetType().GetMethod("updateData").Invoke(ParentList, _params); this.Close(); } else { ParentList.GetType().GetMethod("addData").Invoke(ParentList, _params); clear(); } } else { MessageBoxUI _mb = new MessageBoxUI("Failure to save the record!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); return; } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click"); em.ShowDialog(); return; } }
private void btnCancel_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsmGeneralJournal", "Cancel")) { return; } foreach (DataRow _drStatus in loJournalEntry.getJournalEntryStatus(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows) { if (_drStatus[0].ToString() == "N") { MessageBoxUI _mbStatus = new MessageBoxUI("You cannot cancel an UNPOSTED Journal Entry!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } if (_drStatus[2].ToString() == "Y") { MessageBoxUI _mbStatus = new MessageBoxUI("Journal Entry is already cancelled!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } if (_drStatus[1].ToString() == GlobalVariables.Username || _drStatus[4].ToString() == GlobalVariables.Username) { MessageBoxUI _mbStatus = new MessageBoxUI("You cannot CANCEL a Journal Entry you preprared/posted!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } } if (dgvList.Rows.Count > 0) { DialogResult _dr = new DialogResult(); MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue cancelling this Journal Entry record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo); _mb.ShowDialog(); _dr = _mb.Operation; if (_dr == DialogResult.Yes) { AccountingCancelReasonUI loReason = new AccountingCancelReasonUI(); loReason.ShowDialog(); if (loReason.lReason == "") { MessageBoxUI _mb1 = new MessageBoxUI("You must have a reason in cancelling entry!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb1.ShowDialog(); return; } else { if (loJournalEntry.cancel(dgvList.CurrentRow.Cells[0].Value.ToString(), loReason.lReason)) { MessageBoxUI _mb1 = new MessageBoxUI("Journal Entry record has been successfully cancelled!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK); _mb1.ShowDialog(); refresh(); } else { } } } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnCancel_Click"); em.ShowDialog(); return; } }
private void btnPreview_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsmSalesInventory", "Preview")) { return; } try { DataTable _dtByDate = loPOSTransactionDetail.getSalesInventory(dtpFromDate.Value, dtpToDate.Value); if (_dtByDate.Rows.Count > 0) { loSalesInventoryRpt.SetDataSource(GlobalVariables.DTCompanyLogo); loSalesInventoryRpt.Database.Tables[1].SetDataSource(_dtByDate); loSalesInventoryRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName); loSalesInventoryRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress); loSalesInventoryRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber); loSalesInventoryRpt.SetParameterValue("Username", GlobalVariables.Userfullname); loSalesInventoryRpt.SetParameterValue("DateFrom", string.Format("{0:MM-dd-yyyy}", dtpFromDate.Value)); loSalesInventoryRpt.SetParameterValue("DateTo", string.Format("{0:MM-dd-yyyy}", dtpToDate.Value)); loSalesInventoryRpt.SetParameterValue("Title", "Sales Inventory - By Date"); loSalesInventoryRpt.SetParameterValue("SubTitle", "Sales Inventory - By Date"); crvByDate.ReportSource = loSalesInventoryRpt; } DataTable _dtBy = loPOSTransactionDetail.getSalesInventoryBy(dtpFromDate.Value, dtpToDate.Value); if (_dtBy.Rows.Count > 0) { loSalesInventoryByCustomerRpt.SetDataSource(GlobalVariables.DTCompanyLogo); loSalesInventoryByCustomerRpt.Database.Tables[1].SetDataSource(_dtBy); loSalesInventoryByCustomerRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName); loSalesInventoryByCustomerRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress); loSalesInventoryByCustomerRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber); loSalesInventoryByCustomerRpt.SetParameterValue("Username", GlobalVariables.Userfullname); loSalesInventoryByCustomerRpt.SetParameterValue("DateFrom", string.Format("{0:MM-dd-yyyy}", dtpFromDate.Value)); loSalesInventoryByCustomerRpt.SetParameterValue("DateTo", string.Format("{0:MM-dd-yyyy}", dtpToDate.Value)); loSalesInventoryByCustomerRpt.SetParameterValue("Title", "Sales Inventory - By Customer"); loSalesInventoryByCustomerRpt.SetParameterValue("SubTitle", "Sales Inventory - By Customer"); crvByCustomer.ReportSource = loSalesInventoryByCustomerRpt; } if (_dtBy.Rows.Count > 0) { loSalesInventoryByCategoryRpt.SetDataSource(GlobalVariables.DTCompanyLogo); loSalesInventoryByCategoryRpt.Database.Tables[1].SetDataSource(_dtBy); loSalesInventoryByCategoryRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName); loSalesInventoryByCategoryRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress); loSalesInventoryByCategoryRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber); loSalesInventoryByCategoryRpt.SetParameterValue("Username", GlobalVariables.Userfullname); loSalesInventoryByCategoryRpt.SetParameterValue("DateFrom", string.Format("{0:MM-dd-yyyy}", dtpFromDate.Value)); loSalesInventoryByCategoryRpt.SetParameterValue("DateTo", string.Format("{0:MM-dd-yyyy}", dtpToDate.Value)); loSalesInventoryByCategoryRpt.SetParameterValue("Title", "Sales Inventory - By Category"); loSalesInventoryByCategoryRpt.SetParameterValue("SubTitle", "Sales Inventory - By Category"); crvByCategory.ReportSource = loSalesInventoryByCategoryRpt; } } catch (Exception ex) { throw ex; } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnRefresh_Click"); em.ShowDialog(); return; } }
private void btnFinalize_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsmStockReceiving", "Finalize")) { return; } string _POId = ""; foreach (DataRow _drStatus in loInventory.getInventoryStatus(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows) { _POId = _drStatus["POId"].ToString(); if (_drStatus["Final"].ToString() == "Y") { MessageBoxUI _mbStatus = new MessageBoxUI("Stock Inventory is already FINALIZED!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } } if (dgvList.Rows.Count > 0) { DialogResult _dr = new DialogResult(); MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue finalizing this Stock Inventory record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo); _mb.ShowDialog(); _dr = _mb.Operation; if (_dr == DialogResult.Yes) { if (loInventory.final(dgvList.CurrentRow.Cells[0].Value.ToString())) { //update PO Detail foreach (DataRow _dr1 in loInventoryDetail.getInventoryDetails("", dgvList.CurrentRow.Cells[0].Value.ToString()).Rows) { //update Qty loPurchaseOrderDetail.updateQtyInPurchaseOrderDetail(_dr1["PODetailId"].ToString(), decimal.Parse(_dr1["Qty In"].ToString()), decimal.Parse(_dr1["Variance"].ToString())); //updtae TotalPrice decimal _totalPrice = 0; foreach (DataRow _dr2 in loPurchaseOrderDetail.getPurchaseOrderDetail(_dr1["PODetailId"].ToString()).Rows) { _totalPrice = decimal.Parse(_dr2["Qty In"].ToString()) * decimal.Parse(_dr2["Unit Price"].ToString()); loPurchaseOrderDetail.updateTotalPricePurchaseOrderDetail(_dr1["PODetailId"].ToString(), _totalPrice); } } //update PO Header Qty and Amount decimal _totalQtyIn = 0; decimal _totalVariance = 0; decimal _totalAmount = 0; foreach (DataRow _dr3 in loPurchaseOrderDetail.getPurchaseOrderDetails("", _POId).Rows) { _totalQtyIn += decimal.Parse(_dr3["Qty In"].ToString()); _totalVariance += decimal.Parse(_dr3["Qty Variance"].ToString()); _totalAmount += decimal.Parse(_dr3["Total Price"].ToString()); } loPurchaseOrder.updatePOTotalAmount(_POId, _totalQtyIn, _totalVariance, _totalAmount); MessageBoxUI _mb1 = new MessageBoxUI("Stock Inventory record has been successfully finalized!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK); _mb1.ShowDialog(); previewInventoryDetail(dgvList.CurrentRow.Cells[0].Value.ToString()); //sendEmailToCreator(); refresh("Stock Receiving"); } else { } } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnFinalize_Click"); em.ShowDialog(); return; } }
private void btnPost_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsmSalesOrder", "Post")) { return; } foreach (DataRow _drStatus in loSalesOrder.getSalesOrderStatus(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows) { if (_drStatus["Final"].ToString() == "N") { MessageBoxUI _mbStatus = new MessageBoxUI("Sales Order must be FINALIZED!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } else if (_drStatus["Cancel"].ToString() == "Y") { MessageBoxUI _mbStatus = new MessageBoxUI("You cannot post a CANCELLED Sales Order!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } else if (_drStatus["Post"].ToString() == "Y") { MessageBoxUI _mbStatus = new MessageBoxUI("Sales Order is already POSTED!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } else if (decimal.Parse(_drStatus["TotalQtyOut"].ToString()) <= 0) { MessageBoxUI _mbStatus = new MessageBoxUI("Total Qty OUT must be greater than or equal to zero(0)!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } /* if (_drStatus[4].ToString() == GlobalVariables.Username) { MessageBoxUI _mbStatus = new MessageBoxUI("You cannot FINALIZE a Sales Order you preprared!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } */ /* if (_drStatus["SWId"].ToString() == "") { MessageBoxUI _mbStatus = new MessageBoxUI("Stocks Withdrawal must precedes finalization!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } */ } if (dgvList.Rows.Count > 0) { DialogResult _dr = new DialogResult(); MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue posting this Sales Order record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo); _mb.ShowDialog(); _dr = _mb.Operation; if (_dr == DialogResult.Yes) { if (loSalesOrder.post(dgvList.CurrentRow.Cells[0].Value.ToString())) { foreach (DataRow _drSO in loSalesOrder.getAllData("", dgvList.CurrentRow.Cells[0].Value.ToString(), "").Rows) { insertJournalEntry(dgvList.CurrentRow.Cells[0].Value.ToString(), decimal.Parse(_drSO["Total Amount"].ToString()), _drSO["CustomerId"].ToString(), _drSO["Customer"].ToString(), "Sales from Sales Order (SOId:" + _drSO["Id"].ToString() + ")."); } MessageBoxUI _mb1 = new MessageBoxUI("Sales Order record has been successfully posted!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK); _mb1.ShowDialog(); //previewSalesOrderDetail(dgvList.CurrentRow.Cells[0].Value.ToString()); //sendEmailToCreator(); refresh(); } else { } } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnPost_Click"); em.ShowDialog(); return; } }
private void PurchaseOrderDetailUI_Load(object sender, EventArgs e) { try { this.BackColor = Color.FromArgb(int.Parse(GlobalVariables.FormBackColor)); try { cboSupplier.DataSource = loSupplier.getAllData("ViewAll", "", ""); cboSupplier.DisplayMember = "Name"; cboSupplier.ValueMember = "Id"; cboSupplier.SelectedIndex = -1; } catch { } try { cboRequestedBy.DataSource = loEmployee.getEmployeeNames(); cboRequestedBy.DisplayMember = "Employee Name"; cboRequestedBy.ValueMember = "Id"; cboRequestedBy.SelectedIndex = -1; } catch { } if (lOperation == GlobalVariables.Operation.Edit) { foreach (DataRow _dr in loPurchaseOrder.getAllData("", lPurchaseOrderId, "").Rows) { txtId.Text = _dr["Id"].ToString(); dtpDate.Value = GlobalFunctions.ConvertToDate(_dr["Date"].ToString()); txtReference.Text = _dr["Reference"].ToString(); try { cboSupplier.SelectedValue = _dr["SupplierId"].ToString(); } catch { cboSupplier.Text = ""; } cboPurchaseRequest.Text = _dr["P.R. Id"].ToString(); txtTerms.Text = _dr["Terms"].ToString(); dtpDueDate.Value = GlobalFunctions.ConvertToDate(_dr["Due Date"].ToString()); txtInstructions.Text = _dr["Instructions"].ToString(); try { cboRequestedBy.SelectedValue = _dr["RequestedBy"].ToString(); } catch { cboRequestedBy.Text = ""; } dtpDateNeeded.Value = GlobalFunctions.ConvertToDate(_dr["Date Needed"].ToString()); lblTotalPOQty.Text = string.Format("{0:n}", decimal.Parse(_dr["Total P.O. Qty"].ToString())); lblTotalQtyIn.Text = string.Format("{0:n}", decimal.Parse(_dr["Total Qty In"].ToString())); lblTotalQtyVariance.Text = string.Format("{0:n}", decimal.Parse(_dr["Total Qty Variance"].ToString())); txtTotalAmount.Text = string.Format("{0:n}", decimal.Parse(_dr["Total Amount"].ToString())); txtRemarks.Text = _dr["Remarks"].ToString(); foreach (DataRow _drDetails in loPurchaseOrderDetail.getPurchaseOrderDetails("", lPurchaseOrderId).Rows) { int i = dgvDetailStockInventory.Rows.Add(); dgvDetailStockInventory.Rows[i].Cells["Id"].Value = _drDetails["Id"].ToString(); dgvDetailStockInventory.Rows[i].Cells["StockId"].Value = _drDetails["StockId"].ToString(); dgvDetailStockInventory.Rows[i].Cells["StockCode"].Value = _drDetails["Stock Code"].ToString(); dgvDetailStockInventory.Rows[i].Cells["StockDescription"].Value = _drDetails["Stock Description"].ToString(); dgvDetailStockInventory.Rows[i].Cells["Unit"].Value = _drDetails["Unit"].ToString(); dgvDetailStockInventory.Rows[i].Cells["LocationId"].Value = _drDetails["LocationId"].ToString(); dgvDetailStockInventory.Rows[i].Cells["Location"].Value = _drDetails["Location"].ToString(); dgvDetailStockInventory.Rows[i].Cells["POQty"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["P.O. Qty"].ToString())); dgvDetailStockInventory.Rows[i].Cells["QtyIn"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Qty In"].ToString())); dgvDetailStockInventory.Rows[i].Cells["QtyVariance"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Qty Variance"].ToString())); dgvDetailStockInventory.Rows[i].Cells["UnitPrice"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Unit Price"].ToString())); dgvDetailStockInventory.Rows[i].Cells["DiscountId"].Value = _drDetails["DiscountId"].ToString(); dgvDetailStockInventory.Rows[i].Cells["Discount"].Value = _drDetails["Discount"].ToString(); dgvDetailStockInventory.Rows[i].Cells["DiscountAmount"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Discount Amount"].ToString())); dgvDetailStockInventory.Rows[i].Cells["TotalPrice"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Total Price"].ToString())); dgvDetailStockInventory.Rows[i].Cells["Remarks"].Value = _drDetails["Remarks"].ToString(); dgvDetailStockInventory.Rows[i].Cells["Status"].Value = "Saved"; } computeTotalAmount(); cboSupplier.Enabled = false; cboPurchaseRequest.Enabled = false; btnLookUpPurchaseRequest.Enabled = false; } } else { foreach (DataRow _dr in loCommon.getNextTabelSequenceId("PurchaseOrder").Rows) { txtId.Text = _dr[0].ToString(); } cboSupplier.Focus(); } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "PurchaseOrderDetailUI_Load"); em.ShowDialog(); return; } }
private void dgvList_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { try { if (this.dgvList.Columns[e.ColumnIndex].Name == "Id" || this.dgvList.Columns[e.ColumnIndex].Name == "Terms" || this.dgvList.Columns[e.ColumnIndex].Name == "Reference" || this.dgvList.Columns[e.ColumnIndex].Name == "P.Q. Id") { if (e.Value != null) { e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; } } else if (this.dgvList.Columns[e.ColumnIndex].Name == "Total S.O. Qty" || this.dgvList.Columns[e.ColumnIndex].Name == "Total Amount" || this.dgvList.Columns[e.ColumnIndex].Name == "Running Balance" || this.dgvList.Columns[e.ColumnIndex].Name == "Total Qty Out" || this.dgvList.Columns[e.ColumnIndex].Name == "Total Qty Variance") { if (e.Value != null) { e.Value = string.Format("{0:n}", decimal.Parse(e.Value.ToString())); e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } } else if (this.dgvList.Columns[e.ColumnIndex].Name == "Final") { if (e.Value != null) { e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; if (e.Value.ToString() == "N") { e.CellStyle.BackColor = Color.Green; } } } if (this.dgvList.Columns[e.ColumnIndex].Name == "Cancel") { if (e.Value != null) { e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; if (e.Value.ToString() == "Y") { e.CellStyle.BackColor = Color.Red; } } } if (this.dgvList.Columns[e.ColumnIndex].Name == "Post") { if (e.Value != null) { e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; if (e.Value.ToString() == "N") { e.CellStyle.BackColor = Color.Blue; } } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "dgvList_CellFormatting"); em.ShowDialog(); return; } }
private void btnCancel_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsmSalesOrder", "Cancel")) { return; } foreach (DataRow _drStatus in loSalesOrder.getSalesOrderStatus(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows) { if (_drStatus["Final"].ToString() == "N") { MessageBoxUI _mbStatus = new MessageBoxUI("Sales Order must be FINALIZED to be cancelled!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } if (_drStatus["Cancel"].ToString() == "Y") { MessageBoxUI _mbStatus = new MessageBoxUI("Sales Order is already cancelled!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } if (_drStatus["Post"].ToString() == "Y") { MessageBoxUI _mbStatus = new MessageBoxUI("You cannot cancel a POSTED Sales Order!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } /* if (_drStatus[1].ToString() == GlobalVariables.Username || _drStatus[4].ToString() == GlobalVariables.Username) { MessageBoxUI _mbStatus = new MessageBoxUI("You cannot CANCEL a Sales Order you preprared/finalized!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } */ } if (dgvList.Rows.Count > 0) { DialogResult _dr = new DialogResult(); MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue cancelling this Sales Order record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo); _mb.ShowDialog(); _dr = _mb.Operation; if (_dr == DialogResult.Yes) { SalesCancelReasonUI loSalesCancelReason = new SalesCancelReasonUI(); loSalesCancelReason.ShowDialog(); if (loSalesCancelReason.lReason == "") { MessageBoxUI _mb1 = new MessageBoxUI("You must have a reason in cancelling entry!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb1.ShowDialog(); return; } else { if (loSalesOrder.cancel(dgvList.CurrentRow.Cells[0].Value.ToString(), loSalesCancelReason.lReason)) { foreach (DataRow _drSO in loJournalEntry.getJournalEntryBySOId(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows) { loJournalEntry.cancel(_drSO[0].ToString(), loSalesCancelReason.lReason); } MessageBoxUI _mb1 = new MessageBoxUI("Sales Order record has been successfully cancelled!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK); _mb1.ShowDialog(); refresh(); } else { } } } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnCancel_Click"); em.ShowDialog(); return; } }
private void btnSearch_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsm" + lType.Name, "Search")) { return; } string _DisplayFields = ""; string _WhereFields = ""; string _Alias = ""; switch (lType.Name) { case "Client": _DisplayFields = "SELECT Id,Lastname,Firstname,Middlename,Nickname,CellphoneNo AS `Cellphone No.`, " + "DATE_FORMAT(Birthday,'%m-%d-%Y') AS `Date`, " + "SitioPurokStreet AS `Sitio/Purok/Street`,Barangay,TownCity AS `Town/City`, " + "Province,YearsOfStay AS `Years of Stay`,HomeType AS `Home Type`,Remarks " + "FROM `client` "; _WhereFields = " AND `Status` = 'Active' ORDER BY Lastname,Firstname ASC;"; _Alias = ""; break; case "Area": _DisplayFields = "SELECT a.Id,a.Code,a.Description, " + "CONCAT(e.Firstname,' ',SUBSTRING(e.Middlename, 1, 1),'. ',e.Lastname) AS `Area Manager`,a.Remarks " + "FROM `area` a " + "LEFT JOIN employee e " + "ON a.AreaManager = e.Id "; _WhereFields = " AND a.Status = 'Active' ORDER BY a.Description ASC;"; _Alias = ""; break; case "Branch": _DisplayFields = "SELECT b.Id,b.Code,b.Description,a.Description AS `Area`, " + "CONCAT(e.Firstname,' ',SUBSTRING(e.Middlename, 1, 1),'. ',e.Lastname) AS `Branch Manager`,b.Remarks " + "FROM branch b " + "LEFT JOIN `area` a " + "ON b.AreaId = a.Id " + "LEFT JOIN employee e " + "ON b.BranchManager = e.Id "; _WhereFields = " AND b.Status = 'Active' ORDER BY b.Description ASC;"; _Alias = ""; break; case "Zone": _DisplayFields = "SELECT z.Id,z.Description,b.Description AS `Branch`,z.Remarks " + "FROM zone z " + "LEFT JOIN branch b " + "ON z.BranchId = b.Id "; _WhereFields = " AND z.Status = 'Active' ORDER BY z.Description ASC;"; _Alias = ""; break; case "Collector": _DisplayFields = "SELECT c.Id,CONCAT(e.Firstname,' ',SUBSTRING(e.Middlename, 1, 1),'. ',e.Lastname) AS `Employee Name`, " + "b.Description AS Branch, c.Remarks " + "FROM collector c " + "LEFT JOIN employee e " + "ON c.EmployeeId = e.Id " + "LEFT JOIN branch b " + "ON c.BranchId = b.Id "; _WhereFields = " AND c.Status = 'Active' ORDER BY e.Firstname ASC;"; _Alias = ""; break; case "Product": _DisplayFields = "SELECT Id,`Code`,Description,PaymentFrequency AS `Payment Frequency`, " + "Terms,InterestRate AS `Interest Rate`,ServiceFeeRate AS `Service Fee Rate`,Remarks " + "FROM product "; _WhereFields = " AND `Status` = 'Active' ORDER BY Description ASC;"; _Alias = ""; break; } loSearches.lAlias = _Alias; loSearches.ShowDialog(); if (loSearches.lFromShow) { ldtShow = loCommon.getDataFromSearch(_DisplayFields + loSearches.lQuery + _WhereFields); GlobalFunctions.refreshGrid(ref dgvLists, ldtShow); lFromRefresh = false; } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSearch_Click"); em.ShowDialog(); return; } }
private void btnUpdate_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsm" + lType.Name, "Update")) { return; } for (int i = 0; i < lCountCol; i++) { lRecord[i] = dgvLists.CurrentRow.Cells[i].Value.ToString(); } if (lRecord.Length > 0) { if (lRecord[0].ToString() != "") { switch (lType.Name) { case "Client": ClientDetailUI loClientDetail = new ClientDetailUI(lRecord); loClientDetail.ParentList = this; loClientDetail.ShowDialog(); break; case "Area": AreaDetailUI loAreaDetail = new AreaDetailUI(lRecord); loAreaDetail.ParentList = this; loAreaDetail.ShowDialog(); break; case "Branch": BranchDetailUI loBranchDetail = new BranchDetailUI(lRecord); loBranchDetail.ParentList = this; loBranchDetail.ShowDialog(); break; case "Zone": ZoneDetailUI loZoneDetail = new ZoneDetailUI(lRecord); loZoneDetail.ParentList = this; loZoneDetail.ShowDialog(); break; case "Collector": CollectorDetailUI loCollectorDetail = new CollectorDetailUI(lRecord); loCollectorDetail.ParentList = this; loCollectorDetail.ShowDialog(); break; case "Product": ProductDetailUI loProductDetail = new ProductDetailUI(lRecord); loProductDetail.ParentList = this; loProductDetail.ShowDialog(); break; } } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnUpdate_Click"); em.ShowDialog(); return; } }
private void btnFinalize_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsmPurchaseOrder", "Finalize")) { return; } foreach (DataRow _drStatus in loPurchaseOrder.getPurchaseOrderStatus(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows) { if (_drStatus[0].ToString() == "Y") { MessageBoxUI _mbStatus = new MessageBoxUI("Purchase Order is already FINALIZED!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } /* * if (_drStatus[4].ToString() == GlobalVariables.Username) * { * MessageBoxUI _mbStatus = new MessageBoxUI("You cannot FINALIZE a Purchase Order you preprared!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); * _mbStatus.ShowDialog(); * return; * } */ /* * if (_drStatus["SRId"].ToString() == "") * { * MessageBoxUI _mbStatus = new MessageBoxUI("Stocks Receiving must precedes finalization!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); * _mbStatus.ShowDialog(); * return; * } */ } if (dgvList.Rows.Count > 0) { DialogResult _dr = new DialogResult(); MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue finalizing this Purchase Order record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo); _mb.ShowDialog(); _dr = _mb.Operation; if (_dr == DialogResult.Yes) { if (loPurchaseOrder.finalize(dgvList.CurrentRow.Cells[0].Value.ToString())) { MessageBoxUI _mb1 = new MessageBoxUI("Purchase Order record has been successfully finalized!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK); _mb1.ShowDialog(); previewPurchaseOrderDetail(dgvList.CurrentRow.Cells[0].Value.ToString()); //sendEmailToCreator(); refresh(); } else { } } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnFinalize_Click"); em.ShowDialog(); return; } }
private void CashReceiptVoucherUI_Load(object sender, EventArgs e) { try { this.BackColor = Color.FromArgb(int.Parse(GlobalVariables.FormBackColor)); txtFinancialYear.Text = GlobalVariables.CurrentFinancialYear; cboCustomer.DataSource = loCustomer.getAllData("ViewAll", "", ""); cboCustomer.DisplayMember = "Name"; cboCustomer.ValueMember = "Id"; cboCustomer.SelectedIndex = -1; if (lOperation == GlobalVariables.Operation.Edit) { foreach (DataRow _dr in loJournalEntry.getAllData("", "", lJournalEntryId, "").Rows) { txtFinancialYear.Text = _dr["F.Y."].ToString(); dtpDatePrepared.Value = GlobalFunctions.ConvertToDate(_dr["Date Prepared"].ToString()); txtExplanation.Text = _dr["Explanation"].ToString(); txtTotalDebit.Text = string.Format("{0:n}", decimal.Parse(_dr["Total Debit"].ToString())); txtTotalCredit.Text = string.Format("{0:n}", decimal.Parse(_dr["Total Credit"].ToString())); txtReference.Text = _dr["Reference"].ToString(); try { cboCustomer.SelectedValue = _dr["CustomerId"].ToString(); } catch { cboCustomer.SelectedIndex = -1; } txtRemarks.Text = _dr["Remarks"].ToString(); //get journal entry foreach (DataRow _drDetails in loJournalEntryDetail.getJournalEntryDetails("", lJournalEntryId).Rows) { int i = dgvDetail.Rows.Add(); dgvDetail.Rows[i].Cells["Id"].Value = _drDetails["Id"].ToString(); dgvDetail.Rows[i].Cells["AccountId"].Value = _drDetails["AccountId"].ToString(); dgvDetail.Rows[i].Cells["AccountCode"].Value = _drDetails["Account Code"].ToString(); dgvDetail.Rows[i].Cells["AccountTitle"].Value = _drDetails["Account Title"].ToString(); dgvDetail.Rows[i].Cells["Debit"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Debit"].ToString())); dgvDetail.Rows[i].Cells["Credit"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Credit"].ToString())); dgvDetail.Rows[i].Cells["Subsidiary"].Value = _drDetails["Subsidiary"].ToString(); dgvDetail.Rows[i].Cells["SubsidiaryId"].Value = _drDetails["SubsidiaryId"].ToString(); dgvDetail.Rows[i].Cells["Description"].Value = _drDetails["Subsidiary Description"].ToString(); dgvDetail.Rows[i].Cells["Remarks"].Value = _drDetails["Remarks"].ToString(); dgvDetail.Rows[i].Cells["Status"].Value = "Saved"; } //get payment receipt foreach (DataRow _drDetails in loCashReceiptDetail.getCashReceiptDetails(lJournalEntryId).Rows) { int i = dgvDetailPaymentReceipt.Rows.Add(); dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptId"].Value = _drDetails["Id"].ToString(); dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptSOId"].Value = _drDetails["S.O. Id"].ToString(); dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptAmountDue"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Amount Due"].ToString())); dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptPaymentAmount"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Payment Amount"].ToString())); dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptBalance"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Balance"].ToString())); dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptRemarks"].Value = _drDetails["Remarks"].ToString(); dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptStatus"].Value = "Saved"; } computeTotal(); } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "CashReceiptVoucherUI_Load"); em.ShowDialog(); return; } }
private void btnSave_Click(object sender, EventArgs e) { try { if (decimal.Parse(lblTotalPOQty.Text) == 0) { MessageBoxUI _mb1 = new MessageBoxUI("Totals of P.O. Qty must not be Zero(0)!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb1.showDialog(); return; } string _SupplierId = ""; string _Employee = ""; try { _SupplierId = cboSupplier.SelectedValue.ToString(); } catch { MessageBoxUI _mb1 = new MessageBoxUI("You must select a Supplier!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb1.showDialog(); cboSupplier.Focus(); return; } try { _Employee = cboRequestedBy.SelectedValue.ToString(); } catch { _Employee = ""; } DialogResult _dr = new DialogResult(); MessageBoxUI _mb = new MessageBoxUI("Continue saving this Purchase Order?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo); _mb.ShowDialog(); _dr = _mb.Operation; if (_dr == DialogResult.Yes) { loPurchaseOrder.Id = lPurchaseOrderId; loPurchaseOrder.Date = dtpDate.Value; try { loPurchaseOrder.PRId = cboPurchaseRequest.SelectedValue.ToString(); } catch { loPurchaseOrder.PRId = ""; } loPurchaseOrder.Reference = GlobalFunctions.replaceChar(txtReference.Text); loPurchaseOrder.SupplierId = _SupplierId; try { loPurchaseOrder.Terms = int.Parse(txtTerms.Text); } catch { loPurchaseOrder.Terms = 0; } loPurchaseOrder.DueDate = dtpDueDate.Value; loPurchaseOrder.Instructions = GlobalFunctions.replaceChar(txtInstructions.Text); loPurchaseOrder.RequestedBy = _Employee; loPurchaseOrder.DateNeeded = dtpDateNeeded.Value; loPurchaseOrder.TotalPOQty = decimal.Parse(lblTotalPOQty.Text); loPurchaseOrder.TotalQtyIn = decimal.Parse(lblTotalQtyIn.Text); loPurchaseOrder.TotalQtyVariance = decimal.Parse(lblTotalQtyVariance.Text); loPurchaseOrder.TotalAmount = decimal.Parse(txtTotalAmount.Text); loPurchaseOrder.Remarks = GlobalFunctions.replaceChar(txtRemarks.Text); loPurchaseOrder.UserId = GlobalVariables.UserId; string _PurchaseOrderId = loPurchaseOrder.save(lOperation); if (_PurchaseOrderId != "") { for (int i = 0; i < dgvDetailStockInventory.Rows.Count; i++) { if (dgvDetailStockInventory.Rows[i].Cells["Status"].Value.ToString() == "Add") { try { loPurchaseOrderDetail.DetailId = dgvDetailStockInventory.Rows[i].Cells["Id"].Value.ToString(); } catch { loPurchaseOrderDetail.DetailId = ""; } try { loPurchaseOrderDetail.PurchaseOrderId = _PurchaseOrderId; loPurchaseOrderDetail.StockId = dgvDetailStockInventory.Rows[i].Cells["StockId"].Value.ToString(); loPurchaseOrderDetail.LocationId = dgvDetailStockInventory.Rows[i].Cells["LocationId"].Value.ToString(); loPurchaseOrderDetail.POQty = decimal.Parse(dgvDetailStockInventory.Rows[i].Cells["POQty"].Value.ToString()); loPurchaseOrderDetail.QtyIn = decimal.Parse(dgvDetailStockInventory.Rows[i].Cells["QtyIn"].Value.ToString()); loPurchaseOrderDetail.QtyVariance = decimal.Parse(dgvDetailStockInventory.Rows[i].Cells["QtyVariance"].Value.ToString()); loPurchaseOrderDetail.UnitPrice = decimal.Parse(dgvDetailStockInventory.Rows[i].Cells["UnitPrice"].Value.ToString()); loPurchaseOrderDetail.DiscountId = dgvDetailStockInventory.Rows[i].Cells["DiscountId"].Value.ToString(); loPurchaseOrderDetail.DiscountAmount = decimal.Parse(dgvDetailStockInventory.Rows[i].Cells["DiscountAmount"].Value.ToString()); loPurchaseOrderDetail.TotalPrice = decimal.Parse(dgvDetailStockInventory.Rows[i].Cells["TotalPrice"].Value.ToString()); loPurchaseOrderDetail.Remarks = dgvDetailStockInventory.Rows[i].Cells["Remarks"].Value.ToString(); loPurchaseOrderDetail.UserId = GlobalVariables.UserId; loPurchaseOrderDetail.save(GlobalVariables.Operation.Add); } catch { } } else if (dgvDetailStockInventory.Rows[i].Cells["Status"].Value.ToString() == "Edit") { try { loPurchaseOrderDetail.DetailId = dgvDetailStockInventory.Rows[i].Cells["Id"].Value.ToString(); } catch { loPurchaseOrderDetail.DetailId = ""; } loPurchaseOrderDetail.PurchaseOrderId = _PurchaseOrderId; loPurchaseOrderDetail.StockId = dgvDetailStockInventory.Rows[i].Cells["StockId"].Value.ToString(); loPurchaseOrderDetail.LocationId = dgvDetailStockInventory.Rows[i].Cells["LocationId"].Value.ToString(); loPurchaseOrderDetail.POQty = decimal.Parse(dgvDetailStockInventory.Rows[i].Cells["POQty"].Value.ToString()); loPurchaseOrderDetail.QtyIn = decimal.Parse(dgvDetailStockInventory.Rows[i].Cells["QtyIn"].Value.ToString()); loPurchaseOrderDetail.QtyVariance = decimal.Parse(dgvDetailStockInventory.Rows[i].Cells["QtyVariance"].Value.ToString()); loPurchaseOrderDetail.UnitPrice = decimal.Parse(dgvDetailStockInventory.Rows[i].Cells["UnitPrice"].Value.ToString()); loPurchaseOrderDetail.DiscountId = dgvDetailStockInventory.Rows[i].Cells["DiscountId"].Value.ToString(); loPurchaseOrderDetail.DiscountAmount = decimal.Parse(dgvDetailStockInventory.Rows[i].Cells["DiscountAmount"].Value.ToString()); loPurchaseOrderDetail.TotalPrice = decimal.Parse(dgvDetailStockInventory.Rows[i].Cells["TotalPrice"].Value.ToString()); loPurchaseOrderDetail.Remarks = dgvDetailStockInventory.Rows[i].Cells["Remarks"].Value.ToString(); loPurchaseOrderDetail.UserId = GlobalVariables.UserId; loPurchaseOrderDetail.save(GlobalVariables.Operation.Edit); } else if (dgvDetailStockInventory.Rows[i].Cells["Status"].Value.ToString() == "Delete") { loPurchaseOrderDetail.remove(dgvDetailStockInventory.Rows[i].Cells[0].Value.ToString()); } } if (txtId.Text == _PurchaseOrderId) { MessageBoxUI _mb2 = new MessageBoxUI("Purchase Order has been saved successfully!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK); _mb2.showDialog(); } else { MessageBoxUI _mb2 = new MessageBoxUI("Purchase Order has been saved successfully! New Purchase Order ID. : " + _PurchaseOrderId, GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK); _mb2.showDialog(); } //previewDetail(_PurchaseOrderId); object[] _params = { }; ParentList.GetType().GetMethod("refresh").Invoke(ParentList, _params); this.Close(); } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click"); em.ShowDialog(); return; } }
private void btnProcess_Click(object sender, EventArgs e) { try { dgvDetail.Rows.Clear(); dgvDetailPaymentReceipt.Rows.Clear(); string _customerId = ""; try { _customerId = cboCustomer.SelectedValue.ToString(); } catch { MessageBoxUI _mb = new MessageBoxUI("You must select a Customer!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); return; } //insert debit account string[] lRecordDebitData = new string[11]; lRecordDebitData[0] = ""; //detail id lRecordDebitData[1] = GlobalVariables.CRDebitAccount; //coa id lRecordDebitData[2] = ""; lRecordDebitData[3] = ""; foreach (DataRow _dr in loChartOfAccount.getAllData("", GlobalVariables.CRDebitAccount, "").Rows) { lRecordDebitData[2] = _dr["Code"].ToString(); //coa code lRecordDebitData[3] = _dr["Account Title"].ToString(); //coa title } lRecordDebitData[4] = string.Format("{0:n}", decimal.Parse(txtPaymentReceipt.Text)); //debit lRecordDebitData[5] = "0.00"; //credit lRecordDebitData[6] = "Bank"; //subsidiary lRecordDebitData[7] = ""; //subsidiary id/code lRecordDebitData[8] = ""; //subsidiary description lRecordDebitData[9] = ""; //remarks lRecordDebitData[10] = "Add"; addData(lRecordDebitData); //insert credit account string[] lRecordCreditData = new string[11]; lRecordCreditData[0] = ""; //detail id lRecordCreditData[1] = GlobalVariables.CRCreditAccount; //coa id lRecordCreditData[2] = ""; lRecordCreditData[3] = ""; foreach (DataRow _dr in loChartOfAccount.getAllData("", GlobalVariables.CRCreditAccount, "").Rows) { lRecordCreditData[2] = _dr["Code"].ToString(); //coa code lRecordCreditData[3] = _dr["Account Title"].ToString(); //coa title } lRecordCreditData[4] = "0.00"; //debit lRecordCreditData[5] = string.Format("{0:n}", decimal.Parse(txtPaymentReceipt.Text)); //credit lRecordCreditData[6] = "Customer"; //subsidiary lRecordCreditData[7] = _customerId; //subsidiary id/code lRecordCreditData[8] = cboCustomer.Text; //subsidiary description lRecordCreditData[9] = ""; //remarks lRecordCreditData[10] = "Add"; addData(lRecordCreditData); //insert payment receive decimal _paymentbalance = decimal.Parse(txtPaymentReceipt.Text); foreach (DataRow _dr in loSalesOrder.getCashReceiptSOByCustomer(_customerId, "").Rows) { if (_paymentbalance != 0) { if (decimal.Parse(_dr["Running Balance"].ToString()) == _paymentbalance) { string[] lRecordPaymentData = new string[7]; lRecordPaymentData[0] = ""; //detail lRecordPaymentData[1] = _dr["Id"].ToString(); // sales order id lRecordPaymentData[2] = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString())); // amount due lRecordPaymentData[3] = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString())); // payment amount lRecordPaymentData[4] = "0.00"; // balance lRecordPaymentData[5] = ""; // remarks lRecordPaymentData[6] = "Add"; addDataReceipt(lRecordPaymentData, true); _paymentbalance = decimal.Parse(_dr["Running Balance"].ToString()) - _paymentbalance; } else if (decimal.Parse(_dr["Running Balance"].ToString()) > _paymentbalance) { string[] lRecordPaymentData = new string[7]; lRecordPaymentData[0] = ""; //detail lRecordPaymentData[1] = _dr["Id"].ToString(); // sales order id lRecordPaymentData[2] = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString())); // amount due lRecordPaymentData[3] = string.Format("{0:n}", _paymentbalance); // payment amount lRecordPaymentData[4] = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString()) - _paymentbalance); // balance lRecordPaymentData[5] = ""; // remarks lRecordPaymentData[6] = "Add"; addDataReceipt(lRecordPaymentData, true); _paymentbalance = 0; } else if (decimal.Parse(_dr["Running Balance"].ToString()) < _paymentbalance) { string[] lRecordPaymentData = new string[7]; lRecordPaymentData[0] = ""; //detail lRecordPaymentData[1] = _dr["Id"].ToString(); // sales order id lRecordPaymentData[2] = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString())); // amount due lRecordPaymentData[3] = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString())); // payment amount lRecordPaymentData[4] = string.Format("{0:n}", 0); // balance lRecordPaymentData[5] = ""; // remarks lRecordPaymentData[6] = "Add"; addDataReceipt(lRecordPaymentData, true); _paymentbalance = _paymentbalance - decimal.Parse(_dr["Running Balance"].ToString()); } } } if (_paymentbalance > 0) { MessageBoxUI _mb = new MessageBoxUI("OVER PAYMENT! " + string.Format("{0:n}", _paymentbalance), GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); return; } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnProcess_Click"); em.ShowDialog(); return; } }
private void btnSave_Click(object sender, EventArgs e) { try { if (dgvDetailList.Rows.Count == 0) { MessageBoxUI _mb1 = new MessageBoxUI("Record count must not be Zero(0)!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb1.showDialog(); return; } string _BranchId = "0"; try { _BranchId = cboBranch.SelectedValue.ToString(); } catch { _BranchId = "0"; } if (_BranchId == "0") { MessageBoxUI _mb1 = new MessageBoxUI("You must select a branch!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb1.showDialog(); return; } DialogResult _dr = new DialogResult(); MessageBoxUI _mb = new MessageBoxUI("Continue closing this End of Day?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo); _mb.ShowDialog(); _dr = _mb.Operation; if (_dr == DialogResult.Yes) { loLoanEndOfDay.Id = ""; loLoanEndOfDay.Date = dtpDate.Value; loLoanEndOfDay.BranchId = _BranchId; loLoanEndOfDay.TotalAmountDue = decimal.Parse(txtTotalAmountDue.Text); loLoanEndOfDay.TotalRunningBalance = decimal.Parse(txtTotalRunningBalance.Text); loLoanEndOfDay.TotalCollection = decimal.Parse(txtTotalCollection.Text); loLoanEndOfDay.TotalVariance = decimal.Parse(txtTotalVariance.Text); loLoanEndOfDay.TotalLoanRelease = decimal.Parse(txtTotalLoanRelease.Text); loLoanEndOfDay.TotalServiceFee = decimal.Parse(txtTotalServiceFee.Text); loLoanEndOfDay.EndedBy = GlobalVariables.UserId; loLoanEndOfDay.Remarks = GlobalFunctions.replaceChar(txtRemarks.Text); loLoanEndOfDay.UserId = GlobalVariables.UserId; try { string _LoanEODId = loLoanEndOfDay.save(lOperation); if (_LoanEODId != "") { for (int i = 0; i < dgvDetailList.Rows.Count; i++) { try { loLoanEndOfDayDetail.DetailId = ""; loLoanEndOfDayDetail.LoanEndOfDayId = _LoanEODId; loLoanEndOfDayDetail.CollectorId = dgvDetailList.Rows[i].Cells["CollectorId"].Value.ToString(); loLoanEndOfDayDetail.TotalAmountDue = decimal.Parse(dgvDetailList.Rows[i].Cells["TotalAmountDue"].Value.ToString()); loLoanEndOfDayDetail.TotalRunningBalance = decimal.Parse(dgvDetailList.Rows[i].Cells["TotalRunningBalance"].Value.ToString()); loLoanEndOfDayDetail.TotalCollection = decimal.Parse(dgvDetailList.Rows[i].Cells["TotalCollection"].Value.ToString()); loLoanEndOfDayDetail.TotalVariance = decimal.Parse(dgvDetailList.Rows[i].Cells["TotalVariance"].Value.ToString()); loLoanEndOfDayDetail.TotalLoanRelease = decimal.Parse(dgvDetailList.Rows[i].Cells["TotalLoanRelease"].Value.ToString()); loLoanEndOfDayDetail.TotalServiceFee = decimal.Parse(dgvDetailList.Rows[i].Cells["TotalServiceFee"].Value.ToString()); string _remarks = ""; try { _remarks = dgvDetailList.Rows[i].Cells["Remarks"].Value.ToString(); } catch { _remarks = ""; } loLoanEndOfDayDetail.Remarks = _remarks; loLoanEndOfDayDetail.UserId = GlobalVariables.UserId; loLoanEndOfDayDetail.save(GlobalVariables.Operation.Add); } catch { } } //update list foreach (DataRow _drList in loLoanApplicationDetail.getEODLoanApplicationDetailList(dtpDate.Value, _BranchId).Rows) { loLoanApplicationDetail.updateEODLoanTransactionDetail(_drList[0].ToString(), _LoanEODId); } #region "Insert to Accounting" string _financialYear = "", _journalEntryId = ""; try { foreach (DataRow _drAccounting in loCommon.getCurrentFinancialYear().Rows) { _financialYear = _drAccounting[0].ToString(); } //insert Collections _journalEntryId = loCommon.insertJournalEntryFromOutside(_financialYear, "GJ", "JV", "", dtpDate.Value, "Lending Collection", 0, 0, "", "", "", GlobalVariables.UserId, ""); loCommon.insertJournalEntryDetailFromOutside(_journalEntryId, GlobalVariables.CollectionsDebit, decimal.Parse(txtTotalCollection.Text), 0, "", "", "", "", GlobalVariables.UserId); loCommon.insertJournalEntryDetailFromOutside(_journalEntryId, GlobalVariables.CollectionsCredit, 0, decimal.Parse(txtTotalCollection.Text), "", "", "", "", GlobalVariables.UserId); //insert Releases _journalEntryId = loCommon.insertJournalEntryFromOutside(_financialYear, "GJ", "JV", "", dtpDate.Value, "Lending Releases", 0, 0, "", "", "", GlobalVariables.UserId, ""); loCommon.insertJournalEntryDetailFromOutside(_journalEntryId, GlobalVariables.ReleasesDebit, decimal.Parse(txtTotalLoanRelease.Text), 0, "", "", "", "", GlobalVariables.UserId); loCommon.insertJournalEntryDetailFromOutside(_journalEntryId, GlobalVariables.ReleasesCredit, 0, decimal.Parse(txtTotalLoanRelease.Text), "", "", "", "", GlobalVariables.UserId); //insert Service Fees _journalEntryId = loCommon.insertJournalEntryFromOutside(_financialYear, "GJ", "JV", "", dtpDate.Value, "Lending Service Fees", 0, 0, "", "", "", GlobalVariables.UserId, ""); loCommon.insertJournalEntryDetailFromOutside(_journalEntryId, GlobalVariables.ServiceFeesDebit, decimal.Parse(txtTotalServiceFee.Text), 0, "", "", "", "", GlobalVariables.UserId); loCommon.insertJournalEntryDetailFromOutside(_journalEntryId, GlobalVariables.ServiceFeesCredit, 0, decimal.Parse(txtTotalServiceFee.Text), "", "", "", "", GlobalVariables.UserId); } catch { } #endregion MessageBoxUI _mb2 = new MessageBoxUI("End of Day has been closed successfully!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK); _mb2.showDialog(); object[] _params = { _BranchId }; ParentList.GetType().GetMethod("refresh").Invoke(ParentList, _params); this.Close(); } } catch (Exception ex) { if (ex.Message.Contains("Unclosed quotation mark after the character string")) { MessageBoxUI _mb3 = new MessageBoxUI("Do not use this character( ' ).", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb3.showDialog(); return; } else { MessageBoxUI _mb3 = new MessageBoxUI(ex.Message, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb3.showDialog(); return; } } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click"); em.ShowDialog(); return; } }
private void MDIFrameWork_Load(object sender, EventArgs e) { try { this.Text += " [" + GlobalVariables.CurrentConnection + "]"; pnlMenu.BackColor = Color.FromArgb(int.Parse(GlobalVariables.SecondaryColor)); getGlobalVariablesData(); try { byte[] hextobyte = GlobalFunctions.HexToBytes(GlobalVariables.ScreenSaverImage); pctScreenSaver.BackgroundImage = GlobalFunctions.ConvertByteArrayToImage(hextobyte); pctScreenSaver.BackgroundImageLayout = ImageLayout.Stretch; } catch { } try { byte[] hextobyteLogo = GlobalFunctions.HexToBytes(GlobalVariables.CompanyLogo); pctLogo.BackgroundImage = GlobalFunctions.ConvertByteArrayToImage(hextobyteLogo); } catch { } try { switch (GlobalVariables.TabAlignment) { case "Top": tbcNSites_V.Alignment = TabAlignment.Top; break; case "Bottom": tbcNSites_V.Alignment = TabAlignment.Bottom; break; case "Left": tbcNSites_V.Alignment = TabAlignment.Left; break; case "Right": tbcNSites_V.Alignment = TabAlignment.Right; break; default: tbcNSites_V.Alignment = TabAlignment.Top; break; } } catch (Exception ex) { throw ex; } lblUsername.Text = "Welcome! " + GlobalVariables.Userfullname; lblDateTime.Text = DateTime.Now.ToLongDateString(); lblOwnerName.UseMnemonic = false; lblOwnerName.Text = GlobalVariables.CompanyName; lblApplicationName.Text = GlobalVariables.ApplicationName; if (GlobalVariables.Username != "admin" && GlobalVariables.Username != "technicalsupport") { disabledMenuStrip(); enabledMenuStrip(); } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "MDIFrameWork_Load"); em.ShowDialog(); Application.Exit(); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (txtDebit.Text == "0.00" && txtCredit.Text == "0.00") { MessageBoxUI _mbStatus = new MessageBoxUI("You must input an amount on Debit or Credit!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } lRecordData[0] = lDetailId; try { lRecordData[1] = cboChartOfAccount.SelectedValue.ToString(); } catch { MessageBoxUI _mbStatus = new MessageBoxUI("You must select a correct Account Title!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); cboChartOfAccount.Focus(); return; } lRecordData[2] = "";//chart of account code try { foreach (DataRow _dr in loChartOfAccount.getAllData("", cboChartOfAccount.SelectedValue.ToString(), "").Rows) { lRecordData[2] = _dr["Code"].ToString();//chart of account code } } catch { lRecordData[2] = ""; } lRecordData[3] = cboChartOfAccount.Text; lRecordData[4] = string.Format("{0:n}", decimal.Parse(txtDebit.Text)); lRecordData[5] = string.Format("{0:n}", decimal.Parse(txtCredit.Text)); lRecordData[6] = lblSubsidiary.Text; if (lblSubsidiary.Text != "") { try { lRecordData[7] = cboSubsidiary.SelectedValue.ToString(); lRecordData[8] = cboSubsidiary.Text; } catch { if (cboSubsidiary.Items.Count > 0) { MessageBoxUI _mbError = new MessageBoxUI("You must select a correct " + lblSubsidiary.Text + "!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mbError.ShowDialog(); cboSubsidiary.Focus(); return; } else { lRecordData[7] = ""; lRecordData[8] = ""; } } } else { lRecordData[7] = ""; lRecordData[8] = ""; } lRecordData[9] = GlobalFunctions.replaceChar(txtRemarks.Text); object[] _params = { lRecordData }; if (lOperator == "Add") { lRecordData[10] = "Add"; ParentList.GetType().GetMethod("addData").Invoke(ParentList, _params); MessageBoxUI _mbStatus = new MessageBoxUI("Successfully added!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); clear(); } else if (lOperator == "Edit") { lRecordData[10] = "Edit"; ParentList.GetType().GetMethod("updateData").Invoke(ParentList, _params); Close(); } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click"); em.ShowDialog(); return; } }
private void EmployeeDetailUI_Load(object sender, EventArgs e) { try { this.BackColor = Color.FromArgb(int.Parse(GlobalVariables.FormBackColor)); try { cboEmploymentType.DataSource = loEmploymentType.getAllData("ViewAll", "", ""); cboEmploymentType.DisplayMember = "Description"; cboEmploymentType.ValueMember = "Id"; cboEmploymentType.SelectedIndex = -1; } catch { } try { cboDesignation.DataSource = loDesignation.getAllData("ViewAll", "", ""); cboDesignation.DisplayMember = "Description"; cboDesignation.ValueMember = "Id"; cboDesignation.SelectedIndex = -1; } catch { } try { cboDepartment.DataSource = loDepartment.getAllData("ViewAll", "", ""); cboDepartment.DisplayMember = "Description"; cboDepartment.ValueMember = "Id"; cboDepartment.SelectedIndex = -1; } catch { } try { cboImmediateSupervisor.DataSource = loEmployee.getEmployeeNames(); cboImmediateSupervisor.DisplayMember = "Employee Name"; cboImmediateSupervisor.ValueMember = "Id"; cboImmediateSupervisor.SelectedIndex = -1; } catch { } if (lOperation == GlobalVariables.Operation.Edit) { foreach (DataRow _dr in loEmployee.getAllData("", lRecords[0].ToString(), "").Rows) { lId = _dr["Id"].ToString(); txtEmployeeNo.Text = _dr["Employee No."].ToString(); txtLastname.Text = _dr["Lastname"].ToString(); txtFirstname.Text = _dr["Firstname"].ToString(); txtMiddlename.Text = _dr["Middlename"].ToString(); chkActive.Checked = _dr["Active"].ToString() == "Y" ? true : false; txtBiometricsIdNo.Text = _dr["Biometrics Id No."].ToString(); cboEmploymentType.Text = _dr["Employment Type"].ToString(); cboDesignation.Text = _dr["Designation"].ToString(); cboDepartment.Text = _dr["Department"].ToString(); chkNoWorkSchedule.Checked = _dr["No Work Schedule"].ToString() == "Y" ? true : false; cboWorkSchedule.Text = _dr["Work Schedule"].ToString(); dtpBirthday.Value = DateTime.Parse(_dr["Birthday"].ToString()); txtEmailAddress.Text = _dr["Email Address"].ToString(); txtTIN.Text = _dr["TIN"].ToString(); chkTINDeducted.Checked = _dr["TIN Deducted"].ToString() == "Y" ? true : false; txtPhilHealthId.Text = _dr["PhilHealth Id"].ToString(); chkPhilHealthDeducted.Checked = _dr["PhilHealth Deducted"].ToString() == "Y" ? true : false; txtSSSId.Text = _dr["SSS Id"].ToString(); chkSSSDeducted.Checked = _dr["SSS Deducted"].ToString() == "Y" ? true : false; txtPagibigId.Text = _dr["Pagibig Id"].ToString(); chkPagibigDeducted.Checked = _dr["Pagibig Deducted"].ToString() == "Y" ? true : false; txtPagibigEmployeeShare.Text = string.Format("{0:n}", decimal.Parse(_dr["Pagibig(Employee Share)"].ToString())); txtPagibigEmployerShare.Text = string.Format("{0:n}", decimal.Parse(_dr["Pagibig(Employer Share)"].ToString())); txtNoOfDependent.Text = _dr["No. of Dependent"].ToString(); cboRateType.Text = _dr["Rate Type"].ToString(); txtBasicPay.Text = string.Format("{0:n}", decimal.Parse(_dr["Basic Pay"].ToString())); cboImmediateSupervisor.Text = _dr["Immediate Supervisor"].ToString(); txtRemarks.Text = _dr["Remarks"].ToString(); } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "EmployeeDetailUI_Load"); em.ShowDialog(); return; } }
private void btnSave_Click(object sender, EventArgs e) { try { loUser.Id = lRecordData[0]; if (txtUsername.Text != "") { loUser.Username = GlobalFunctions.replaceChar(txtUsername.Text); } else { MessageBoxUI ms = new MessageBoxUI("Username must have a value!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK); ms.showDialog(); txtUsername.Focus(); return; } loUser.Password = txtPassword.Text; try { loUser.EmployeeId = cboEmployee.SelectedValue.ToString(); } catch { loUser.EmployeeId = ""; } try { loUser.UserGroupId = cboUserGroup.SelectedValue.ToString(); } catch { loUser.UserGroupId = ""; } loUser.Remarks = txtRemarks.Text; loUser.UserId = GlobalVariables.UserId; string _Id = loUser.saveUser(lOperation); if (_Id != "") { MessageBoxUI _mb = new MessageBoxUI("User has been saved successfully!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK); _mb.showDialog(); lRecordData[0] = _Id; lRecordData[1] = txtUsername.Text; lRecordData[2] = cboEmployee.Text; lRecordData[3] = cboUserGroup.Text; lRecordData[4] = txtRemarks.Text; object[] _params = { lRecordData }; if (lOperation == GlobalVariables.Operation.Edit) { ParentList.GetType().GetMethod("updateData").Invoke(ParentList, _params); this.Close(); } else { ParentList.GetType().GetMethod("addData").Invoke(ParentList, _params); clear(); } } else { MessageBoxUI _mb = new MessageBoxUI("Failure to save the record!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); return; } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click"); em.ShowDialog(); return; } }
private void btnSave_Click(object sender, EventArgs e) { try { if (decimal.Parse(txtQtyOUT.Text) == 0) { MessageBoxUI _mbStatus = new MessageBoxUI("Qty must not be Zero(0)!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } lRecordData[0] = lDetailId; lRecordData[1] = lSODetailId; try { lRecordData[2] = cboStockDescription.SelectedValue.ToString(); } catch { MessageBoxUI _mbStatus = new MessageBoxUI("You must select a correct Stock!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); cboStockDescription.Focus(); return; } lRecordData[3] = txtStockCode.Text; lRecordData[4] = cboStockDescription.Text; lRecordData[5] = txtUnit.Text; try { lRecordData[6] = cboLocation.SelectedValue.ToString(); } catch { lRecordData[6] = ""; } lRecordData[7] = cboLocation.Text; lRecordData[8] = string.Format("{0:n}", decimal.Parse(txtSOQty.Text)); lRecordData[9] = string.Format("{0:n}", decimal.Parse(txtQtyOUT.Text)); lRecordData[10] = string.Format("{0:n}", decimal.Parse(txtVariance.Text)); lRecordData[11] = GlobalFunctions.replaceChar(txtRemarks.Text); object[] _params = { lRecordData }; if (lOperator == "Add") { lRecordData[12] = "Add"; ParentList.GetType().GetMethod("addData").Invoke(ParentList, _params); MessageBoxUI _mbStatus = new MessageBoxUI("Successfully added!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); clear(); } else if (lOperator == "Edit") { lRecordData[12] = "Edit"; ParentList.GetType().GetMethod("updateData").Invoke(ParentList, _params); this.Close(); } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click"); em.ShowDialog(); return; } }
private void btnSearch_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsm" + lType.Name, "Search")) { return; } string _DisplayFields = ""; string _WhereFields = ""; string _Alias = ""; switch (lType.Name) { case "SalesDiscount": _DisplayFields = "SELECT Id,`Code`,Description,`Type`,`Value`,Remarks " + "FROM salesdiscount "; _WhereFields = " AND `Status` = 'Active' ORDER BY Description ASC;"; _Alias = ""; break; case "ModeOfPayment": _DisplayFields = "SELECT Id,`Code`,Description,`Default`,CashPayment AS ` Cash Payment`,Remarks " + "FROM modeofpayment "; _WhereFields = " AND `Status` = 'Active' ORDER BY Description ASC;"; _Alias = ""; break; case "SalesPerson": _DisplayFields = "SELECT Id,`Name`,Address,ContactNo,EmailAddress AS `Email Address`,Remarks " + "FROM salesperson "; _WhereFields = " AND `Status` = 'Active' ORDER BY `Name` ASC;"; _Alias = ""; break; case "Cashier": _DisplayFields = "SELECT c.Id,c.`Code`,c.`Name`,u.Username,c.Remarks " + "FROM cashier c " + "LEFT JOIN `user` u " + "ON c.UserId = u.Id "; _WhereFields = " AND c.`Status` = 'Active' ORDER BY c.`Name` ASC;"; _Alias = ""; break; } loSearches.lAlias = _Alias; loSearches.ShowDialog(); if (loSearches.lFromShow) { ldtShow = loCommon.getDataFromSearch(_DisplayFields + loSearches.lQuery + _WhereFields); GlobalFunctions.refreshGrid(ref dgvLists, ldtShow); lFromRefresh = false; } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSearch_Click"); em.ShowDialog(); return; } }
private void tsmiRequestToCheckAndPost_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsmGeneralJournal", "Request to Check and Post")) { return; } string pCompanyCode = ""; foreach (DataRow _drStatus in loJournalEntry.getJournalEntryStatus(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows) { pCompanyCode = _drStatus["Company"].ToString(); if (_drStatus[0].ToString() == "Y") { MessageBoxUI _mbStatus = new MessageBoxUI("You cannot repost a posted Journal Entry!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } } /* * foreach (DataRow _dr in loJournalEntry.getAccountantEmailAddress(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows) * { * string _form = dgvList.CurrentRow.Cells[5].Value.ToString(); * string _bodyhead = "<h3>Journal Entry Id : " + dgvList.CurrentRow.Cells[0].Value.ToString() + "</h3>" + * "<h4>Form : Journal Voucher</h4>" + * "<h4>Company : " + dgvList.CurrentRow.Cells[3].Value.ToString() + "</h4>" + * "<h4>Date Prepared : " + dgvList.CurrentRow.Cells[7].Value.ToString() + "</h4>" + * "<h4>Explanation : " + dgvList.CurrentRow.Cells[8].Value.ToString() + "</h4>" + * "<h4>Total Debit : " + dgvList.CurrentRow.Cells[9].Value.ToString() + "</h4>" + * "<h4>Total Credit : " + dgvList.CurrentRow.Cells[10].Value.ToString() + "</h4>" + * "<h4>Prepared By : " + dgvList.CurrentRow.Cells[16].Value.ToString() + "</h4>" + * "</br> " + * "<table border=\"1\">"; * * string _bodyDetailHeader = "<tr>" + * "<th>Account Code</th>" +//1 * "<th>Account Title</th>" +//2 * "<th>Debit</th>" +//3 * "<th>Credit</th>" +//4 * "<th>Subsidiary</th>" +//5 * "<th>Description</th>" +//6 * "<th>Remarks</th>" +//7 * "</tr>"; * string _bodycontent = ""; * foreach (DataRow _drbody in loJournalEntryDetail.getJournalEntryDetails(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows) * { * _bodycontent += "<tr>" + * "<td>" + _drbody[1].ToString() + "</td>" + * "<td>" + _drbody[2].ToString() + "</td>" + * "<td align=\"right\">" + string.Format("{0:n}", decimal.Parse(_drbody[3].ToString())) + "</td>" + * "<td align=\"right\">" + string.Format("{0:n}", decimal.Parse(_drbody[4].ToString())) + "</td>" + * "<td align=\"center\">" + _drbody[5].ToString() + "</td>" + * "<td>" + _drbody[6].ToString() + "</td>" + * "<td align=\"center\">" + _drbody[7].ToString() + "</td>" + * "</tr>"; * } * * try * { * if (_dr[1].ToString() != "") * { * string[] emailAdd = _dr[1].ToString().Split(','); * for (int i = 0; i < emailAdd.Length; i++) * { * foreach (DataRow _dr1 in loJournalEntry.getCheckAccountantEmailAddress(emailAdd[i], pCompanyCode).Rows) * { * if (int.Parse(_dr1[0].ToString()) > 0) * { * GlobalFunctions.SendEmail(emailAdd[i], "", "Request to Check and Post (J.E. Id : " + dgvList.CurrentRow.Cells[0].Value.ToString() + ")", _bodyhead + _bodyDetailHeader + _bodycontent); * } * } * } * } * } * catch { } * }*/ } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "tsmiRequestToCheckAndPost_Click"); em.ShowDialog(); return; } }
private void btnPreview_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsm" + lType.Name, "Preview")) { return; } if (dgvLists.Rows.Count != 0) { switch (lType.Name) { case "SalesDiscount": SalesDiscountRpt loSalesDiscountRpt = new SalesDiscountRpt(); loSalesDiscountRpt.SetDataSource(GlobalVariables.DTCompanyLogo); loSalesDiscountRpt.Database.Tables[1].SetDataSource(ldtShow); loSalesDiscountRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName); loSalesDiscountRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress); loSalesDiscountRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber); loSalesDiscountRpt.SetParameterValue("Username", GlobalVariables.Userfullname); loSalesDiscountRpt.SetParameterValue("Title", "Sales Discount List"); loSalesDiscountRpt.SetParameterValue("SubTitle", "Sales Discount List"); try { if (loSearches.lAlias == "") { loSalesDiscountRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "")); } else { loSalesDiscountRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, "")); } } catch { loSalesDiscountRpt.SetParameterValue("QueryString", ""); } loReportViewer.crystalReportViewer.ReportSource = loSalesDiscountRpt; loReportViewer.ShowDialog(); break; case "SalesPerson": SalesPersonRpt loSalesPersonRpt = new SalesPersonRpt(); loSalesPersonRpt.SetDataSource(GlobalVariables.DTCompanyLogo); loSalesPersonRpt.Database.Tables[1].SetDataSource(ldtShow); loSalesPersonRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName); loSalesPersonRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress); loSalesPersonRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber); loSalesPersonRpt.SetParameterValue("Username", GlobalVariables.Userfullname); loSalesPersonRpt.SetParameterValue("Title", "Sales Person List"); loSalesPersonRpt.SetParameterValue("SubTitle", "Sales Person List"); try { if (loSearches.lAlias == "") { loSalesPersonRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "")); } else { loSalesPersonRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, "")); } } catch { loSalesPersonRpt.SetParameterValue("QueryString", ""); } loReportViewer.crystalReportViewer.ReportSource = loSalesPersonRpt; loReportViewer.ShowDialog(); break; } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnPreview_Click"); em.ShowDialog(); return; } }
private void StockWithdrawalDetailUI_Load(object sender, EventArgs e) { try { this.BackColor = Color.FromArgb(int.Parse(GlobalVariables.FormBackColor)); try { cboCustomer.DataSource = loCustomer.getAllData("ViewAll", "", ""); cboCustomer.DisplayMember = "Name"; cboCustomer.ValueMember = "Id"; cboCustomer.SelectedIndex = -1; } catch { } if (lOperation == GlobalVariables.Operation.Edit) { foreach (DataRow _dr in loInventory.getAllData("", "", lInventoryId, "").Rows) { txtId.Text = _dr["Id"].ToString(); dtpDate.Value = GlobalFunctions.ConvertToDate(_dr["Date"].ToString()); txtReference.Text = _dr["Reference"].ToString(); lSalesOrderId = _dr["S.O. Id"].ToString(); cboCustomer.Text = _dr["Customer"].ToString(); cboSalesOrder.Text = _dr["S.O. Id"].ToString(); txtTotalSOQty.Text = string.Format("{0:n}", decimal.Parse(_dr["Total S.O. Qty"].ToString())); txtTotalQtyOut.Text = string.Format("{0:n}", decimal.Parse(_dr["Total Qty Out"].ToString())); txtTotalVariance.Text = string.Format("{0:n}", decimal.Parse(_dr["Total Variance"].ToString())); txtRemarks.Text = _dr["Remarks"].ToString(); foreach (DataRow _drDetails in loInventoryDetail.getInventoryDetails("", lInventoryId).Rows) { int i = dgvDetail.Rows.Add(); dgvDetail.Rows[i].Cells["Id"].Value = _drDetails["Id"].ToString(); dgvDetail.Rows[i].Cells["SODetailId"].Value = _drDetails["SODetailId"].ToString(); dgvDetail.Rows[i].Cells["StockId"].Value = _drDetails["StockId"].ToString(); dgvDetail.Rows[i].Cells["StockCode"].Value = _drDetails["Stock Code"].ToString(); dgvDetail.Rows[i].Cells["StockDescription"].Value = _drDetails["Stock Description"].ToString(); dgvDetail.Rows[i].Cells["Unit"].Value = _drDetails["Unit"].ToString(); dgvDetail.Rows[i].Cells["LocationId"].Value = _drDetails["LocationId"].ToString(); dgvDetail.Rows[i].Cells["Location"].Value = _drDetails["Location"].ToString(); dgvDetail.Rows[i].Cells["SOQty"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["S.O. Qty"].ToString())); dgvDetail.Rows[i].Cells["QtyOut"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Qty Out"].ToString())); dgvDetail.Rows[i].Cells["Variance"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Variance"].ToString())); dgvDetail.Rows[i].Cells["Remarks"].Value = _drDetails["Remarks"].ToString(); dgvDetail.Rows[i].Cells["Status"].Value = "Saved"; } computeTotalQty(); } } else { foreach (DataRow _dr in loCommon.getNextTabelSequenceId("Inventory").Rows) { txtId.Text = _dr[0].ToString(); } cboCustomer.Focus(); } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "StockWithdrawalDetailUI_Load"); em.ShowDialog(); return; } }
private void btnSave_Click(object sender, EventArgs e) { try { if (dgvDetail.Rows.Count == 0) { MessageBoxUI _mb = new MessageBoxUI("Journal Entry must a record!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); return; } if (dgvDetailPaymentReceipt.Rows.Count == 0) { MessageBoxUI _mb = new MessageBoxUI("Payment Receipt must a record!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); return; } if (decimal.Parse(txtTotalDebit.Text) != decimal.Parse(txtTotalCredit.Text)) { MessageBoxUI _mb = new MessageBoxUI("Totals of Debit and Credit must be equal!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); return; } if (decimal.Parse(txtTotalDebit.Text) == 0 && decimal.Parse(txtTotalCredit.Text) == 0) { MessageBoxUI _mb = new MessageBoxUI("Totals of Debit and Credit must not be Zero(0)!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); return; } if (dtpDatePrepared.Value.Year != int.Parse(GlobalVariables.CurrentFinancialYear)) { MessageBoxUI _mb = new MessageBoxUI("Date Prepared must be within Current Financial Year!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); return; } /* * if (decimal.Parse(txtTotalPaymentAmount.Text) == 0) * { * MessageBoxUI _mb1 = new MessageBoxUI("Totals Payment Amount must not be Zero(0)!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); * _mb1.showDialog(); * return; * } */ //check if subsidiary has value for (int i = 0; i < dgvDetail.Rows.Count; i++) { if (dgvDetail.Rows[i].Cells["Subsidiary"].Value.ToString() != "" && dgvDetail.Rows[i].Cells["SubsidiaryId"].Value.ToString() == "") { MessageBoxUI _mb1 = new MessageBoxUI("Subsidiary " + dgvDetail.Rows[i].Cells["Subsidiary"].Value.ToString() + " must have a value!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb1.showDialog(); return; } } if (decimal.Parse(lblJournalEntryAmount.Text) != decimal.Parse(lblReceiptsAmount.Text)) { MessageBoxUI _mb1 = new MessageBoxUI("Totals of Amount is not equal!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb1.showDialog(); return; } loJournalEntry.JournalEntryId = lJournalEntryId; loJournalEntry.FinancialYear = int.Parse(txtFinancialYear.Text); loJournalEntry.Journal = "CRJ"; loJournalEntry.Form = "RV"; loJournalEntry.VoucherNo = ""; loJournalEntry.DatePrepared = dtpDatePrepared.Value; loJournalEntry.Explanation = GlobalFunctions.replaceChar(txtExplanation.Text); loJournalEntry.TotalDebit = decimal.Parse(txtTotalDebit.Text); loJournalEntry.TotalCredit = decimal.Parse(txtTotalCredit.Text); loJournalEntry.Reference = txtReference.Text; loJournalEntry.SupplierId = ""; try { loJournalEntry.CustomerId = cboCustomer.SelectedValue.ToString(); } catch { MessageBoxUI _mb = new MessageBoxUI("Customer must have a value!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); cboCustomer.Focus(); return; } loJournalEntry.BegBal = "N"; loJournalEntry.Adjustment = "N"; loJournalEntry.ClosingEntry = "N"; loJournalEntry.PreparedBy = GlobalVariables.Username; loJournalEntry.Remarks = GlobalFunctions.replaceChar(txtRemarks.Text); loJournalEntry.SOId = "0"; loJournalEntry.POId = "0"; loJournalEntry.UserId = GlobalVariables.UserId; string _JournalEntryId = loJournalEntry.save(lOperation); if (_JournalEntryId != "") { //insert journal entry detail for (int i = 0; i < dgvDetail.Rows.Count; i++) { if (dgvDetail.Rows[i].Cells["Status"].Value.ToString() == "Add") { loJournalEntryDetail.DetailId = dgvDetail.Rows[i].Cells["Id"].Value.ToString(); loJournalEntryDetail.JournalEntryId = _JournalEntryId; loJournalEntryDetail.AccountId = dgvDetail.Rows[i].Cells["AccountId"].Value.ToString(); loJournalEntryDetail.Debit = decimal.Parse(dgvDetail.Rows[i].Cells["Debit"].Value.ToString()); loJournalEntryDetail.Credit = decimal.Parse(dgvDetail.Rows[i].Cells["Credit"].Value.ToString()); loJournalEntryDetail.Subsidiary = dgvDetail.Rows[i].Cells["Subsidiary"].Value.ToString(); loJournalEntryDetail.SubsidiaryId = dgvDetail.Rows[i].Cells["SubsidiaryId"].Value.ToString(); loJournalEntryDetail.SubsidiaryDescription = dgvDetail.Rows[i].Cells["Description"].Value.ToString(); loJournalEntryDetail.Remarks = dgvDetail.Rows[i].Cells["Remarks"].Value.ToString(); loJournalEntryDetail.UserId = GlobalVariables.UserId; loJournalEntryDetail.save(GlobalVariables.Operation.Add); } else if (dgvDetail.Rows[i].Cells["Status"].Value.ToString() == "Edit") { loJournalEntryDetail.DetailId = dgvDetail.Rows[i].Cells["Id"].Value.ToString(); loJournalEntryDetail.JournalEntryId = _JournalEntryId; loJournalEntryDetail.AccountId = dgvDetail.Rows[i].Cells["AccountId"].Value.ToString(); loJournalEntryDetail.Debit = decimal.Parse(dgvDetail.Rows[i].Cells["Debit"].Value.ToString()); loJournalEntryDetail.Credit = decimal.Parse(dgvDetail.Rows[i].Cells["Credit"].Value.ToString()); loJournalEntryDetail.Subsidiary = dgvDetail.Rows[i].Cells["Subsidiary"].Value.ToString(); loJournalEntryDetail.SubsidiaryId = dgvDetail.Rows[i].Cells["SubsidiaryId"].Value.ToString(); loJournalEntryDetail.SubsidiaryDescription = dgvDetail.Rows[i].Cells["Description"].Value.ToString(); loJournalEntryDetail.Remarks = dgvDetail.Rows[i].Cells["Remarks"].Value.ToString(); loJournalEntryDetail.UserId = GlobalVariables.UserId; loJournalEntryDetail.save(GlobalVariables.Operation.Edit); } else if (dgvDetail.Rows[i].Cells["Status"].Value.ToString() == "Delete") { loJournalEntryDetail.remove(dgvDetail.Rows[i].Cells[0].Value.ToString()); } } //insert payment receipt detail for (int i = 0; i < dgvDetailPaymentReceipt.Rows.Count; i++) { if (dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptStatus"].Value.ToString() == "Add") { try { loCashReceiptDetail.DetailId = dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptId"].Value.ToString(); } catch { loCashReceiptDetail.DetailId = ""; } try { loCashReceiptDetail.JournalEntryId = _JournalEntryId; loCashReceiptDetail.SalesOrderId = dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptSOId"].Value.ToString(); loCashReceiptDetail.AmountDue = decimal.Parse(dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptAmountDue"].Value.ToString()); loCashReceiptDetail.PaymentAmount = decimal.Parse(dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptPaymentAmount"].Value.ToString()); loCashReceiptDetail.Balance = decimal.Parse(dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptBalance"].Value.ToString()); loCashReceiptDetail.Remarks = dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptRemarks"].Value.ToString(); loCashReceiptDetail.UserId = GlobalVariables.UserId; loCashReceiptDetail.save(GlobalVariables.Operation.Add); } catch { } } else if (dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptStatus"].Value.ToString() == "Edit") { try { loCashReceiptDetail.DetailId = dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptId"].Value.ToString(); } catch { loCashReceiptDetail.DetailId = ""; } loCashReceiptDetail.JournalEntryId = _JournalEntryId; loCashReceiptDetail.SalesOrderId = dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptSOId"].Value.ToString(); loCashReceiptDetail.AmountDue = decimal.Parse(dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptAmountDue"].Value.ToString()); loCashReceiptDetail.PaymentAmount = decimal.Parse(dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptPaymentAmount"].Value.ToString()); loCashReceiptDetail.Balance = decimal.Parse(dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptBalance"].Value.ToString()); loCashReceiptDetail.Remarks = dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptRemarks"].Value.ToString(); loCashReceiptDetail.UserId = GlobalVariables.UserId; loCashReceiptDetail.save(GlobalVariables.Operation.Edit); } else if (dgvDetailPaymentReceipt.Rows[i].Cells["ReceiptStatus"].Value.ToString() == "Delete") { loCashReceiptDetail.remove(dgvDetailPaymentReceipt.Rows[i].Cells[0].Value.ToString()); } } MessageBoxUI _mb = new MessageBoxUI("Journal Entry has been saved successfully!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK); _mb.showDialog(); try { if (lOperation == GlobalVariables.Operation.Edit) { //sendEmailForPosting(_JournalEntryId, cboCompany.SelectedValue.ToString(), cboCompany.Text, string.Format("{0:MM-dd-yyyy}", dtpDatePrepared.Value), txtExplanation.Text, decimal.Parse(txtTotalDebit.Text), decimal.Parse(txtTotalCredit.Text), cboPayor.Text, GlobalVariables.Userfullname); } } catch { MessageBoxUI _mb1 = new MessageBoxUI("Failure to send email", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb1.showDialog(); } ParentList.GetType().GetMethod("refresh").Invoke(ParentList, null); this.Close(); } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click"); em.ShowDialog(); return; } }
private void btnPost_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsmGeneralJournal", "Post")) { return; } foreach (DataRow _drStatus in loJournalEntry.getJournalEntryStatus(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows) { if (_drStatus[0].ToString() == "Y") { MessageBoxUI _mbStatus = new MessageBoxUI("Journal Entry is already POSTED!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } /* * if (_drStatus[4].ToString() == GlobalVariables.Username) * { * MessageBoxUI _mbStatus = new MessageBoxUI("You cannot POST a Journal Entry you preprared!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); * _mbStatus.ShowDialog(); * return; * } */ } if (dgvList.Rows.Count > 0) { DialogResult _dr = new DialogResult(); MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue posting this Journal Entry record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo); _mb.ShowDialog(); _dr = _mb.Operation; if (_dr == DialogResult.Yes) { try { if (loJournalEntry.post(dgvList.CurrentRow.Cells[0].Value.ToString())) { MessageBoxUI _mb1 = new MessageBoxUI("Journal Entry record has been successfully posted!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK); _mb1.ShowDialog(); previewDetail(dgvList.CurrentRow.Cells[0].Value.ToString()); //sendEmailToCreator(); refresh(); } } catch (Exception ex) { MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); mb.ShowDialog(); return; } } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnPost_Click"); em.ShowDialog(); return; } }
private void btnCancel_Click(object sender, EventArgs e) { try { if (!GlobalFunctions.checkRights("tsmLoanApplication", "Cancel")) { return; } DataTable _dt = loLoanApplication.getLoanApplicationStatus(dgvList.CurrentRow.Cells[0].Value.ToString()); if (_dt.Rows.Count > 0) { foreach (DataRow _drStatus in _dt.Rows) { if (_drStatus[0].ToString() == "In Process") { MessageBoxUI _mbStatus = new MessageBoxUI("Only APPROVED application can be Cancelled!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } else if (_drStatus[0].ToString() == "Cancelled") { MessageBoxUI _mbStatus = new MessageBoxUI("Loan application is already CANCELLED!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } else if (_drStatus[0].ToString() == "Posted") { MessageBoxUI _mbStatus = new MessageBoxUI("You cannot cancel a POSTED application!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } } } else { MessageBoxUI _mbStatus = new MessageBoxUI("Loan Application Id does not exist!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK); _mbStatus.ShowDialog(); return; } if (dgvList.Rows.Count > 0) { DialogResult _dr = new DialogResult(); MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue cancelling this Loan Application?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo); _mb.ShowDialog(); _dr = _mb.Operation; if (_dr == DialogResult.Yes) { LendingCancelReasonUI loLendingCancelReason = new LendingCancelReasonUI(); loLendingCancelReason.ShowDialog(); if (loLendingCancelReason.lReason == "") { MessageBoxUI _mb1 = new MessageBoxUI("You must have a reason in cancelling entry!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb1.ShowDialog(); return; } else { if (loLoanApplication.cancel(dgvList.CurrentRow.Cells[0].Value.ToString(), loLendingCancelReason.lReason)) { MessageBoxUI _mb1 = new MessageBoxUI("Loan Application record has been successfully cancelled!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK); _mb1.ShowDialog(); refresh(); } } } } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnApprove_Click"); em.ShowDialog(); return; } }