private void securityNumbersToolStripMenuItem_Click(object sender, EventArgs e) { var numbers = Database.Query("learner_details", "Division = '" + clsGlobal.loggedOnUserDivison + "' AND NOT SecNumber =''"); if (numbers.Tables[0].Rows.Count == 0) { MessageBox.Show("No Security Numbers found for this college"); return; } var report = new rptSecNum(); report.SetDataSource(numbers); report.DataDefinition.FormulaFields["Division"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; var frmReport = new frmReport(report) { Text = "Security Numbers" }; frmReport.ShowDialog(); //numbers.WriteXmlSchema("C:\\Schema.xml"); }
private void btnReqReg_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { DataTable dt = new DataTable(); dt = clsStatics.GetProjDetails(Convert.ToInt32(clsStatics.IsNullCheck(ReqListView.GetFocusedRowCellValue("CostCentreId"), clsStatics.datatypes.vartypenumeric))); string strReportPath = ""; frmReport objReport = new frmReport(); if (m_iCCId != 0) { strReportPath = Application.StartupPath + "\\VAReqRegisterCC.Rpt"; } else { strReportPath = Application.StartupPath + "\\VAReqRegister.Rpt"; } ReportDocument cryRpt = new ReportDocument(); string fstring = ""; //string frmdat = string.Format("{0:dd/MMM/yyyy}", Convert.ToDateTime(dxFromDate.EditValue)); //string tdat = string.Format("{0:dd/MMM/yyyy}", Convert.ToDateTime(dxToDate.EditValue)); //fstring = "Detailed PO Register From " + frmdat + " To " + tdat; cryRpt.Load(strReportPath); string[] DataFiles = new string[] { BsfGlobal.g_sMMSDBName, BsfGlobal.g_sMMSDBName, BsfGlobal.g_sMMSDBName, BsfGlobal.g_sRateAnalDBName, BsfGlobal.g_sMMSDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sMMSDBName, BsfGlobal.g_sMMSDBName }; objReport.ReportConvert(cryRpt, DataFiles); objReport.rptViewer.ReportSource = null; objReport.rptViewer.ReportSource = cryRpt; if (m_iCCId != 0) { cryRpt.SetParameterValue("CCId", m_iCCId); } cryRpt.SetParameterValue("VMDB", BsfGlobal.g_sVendorDBName); cryRpt.SetParameterValue("MMSDB", BsfGlobal.g_sMMSDBName); cryRpt.SetParameterValue("WFDB", BsfGlobal.g_sWorkFlowDBName); if (dt.Rows.Count > 0) { cryRpt.DataDefinition.FormulaFields["CompCaption"].Text = " '" + dt.Rows[0]["CompanyName"].ToString() + "'"; } cryRpt.DataDefinition.FormulaFields["FString"].Text = " '" + fstring + "'"; objReport.rptViewer.Refresh(); objReport.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void reactivationToolStripMenuItem_Click_1(object sender, EventArgs e) { var number = new frmSubmitText("Learner Number", "Please enter learner number"); number.ShowDialog(); while (Database.Count("learner_details", "LearnerNumber = '" + number.Selection + "' AND Division = '" + clsGlobal.loggedOnUserDivison + "'") == 0) { if (number.Selection == "***") return; MessageBox.Show("Invalid Learner Number", "Error"); number.ShowDialog(); } string reactivate = MessageBox.Show("Would you like to request a re-activation?", "Re-Activation Request", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes ? "Yes" : "No"; var Data = Database.Row("learner_details", "LearnerNumber = '" + number.Selection + "' AND Division = '" + clsGlobal.loggedOnUserDivison + "'"); var report = new rptEnquiry(); report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; report.DataDefinition.FormulaFields["clerk"].Text = "\"" + clsGlobal.loggedOnUser + "\""; report.DataDefinition.FormulaFields["learnerName"].Text = "\"" + Data["Name"] + " " + Data["Surname"] + "\""; report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number.Selection + "\""; report.DataDefinition.FormulaFields["reactivate"].Text = "\"" +reactivate + "\""; var frmReport = new frmReport(report) { Text = "Enquiry on Handover / Re-Activation" }; frmReport.ShowDialog(); }
private void handOverToolStripMenuItem_Click(object sender, EventArgs e) { var number = new frmSubmitText("Please enter Learner Number:", "Please enter Learner Number:"); number.ShowDialog(); var learner = new frmSubmitText("Please enter amount:", "Please enter amount"); learner.ShowDialog(); if (learner.Selection == "***" || number.Selection == "***") return; DataRow data; try { data = Database.Row("learner_details a, enrollments b, enrollmentscourses c, courses d", "a.Division = '" + clsGlobal.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "' AND b.LearnerKey = a.LearnerKey AND c.idEnrollments = b.idEnrollments AND" + " d.idCourses = c.idCourses"); } catch { MessageBox.Show("Error Finding Student."); return; } var report = new rptSny(); report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; report.DataDefinition.FormulaFields["ClientNr"].Text = "\"" + Database.Retrieve("division","DivisionAbrev = '" + clsGlobal.loggedOnUserDivison +"'","SnyVen") + "\""; report.DataDefinition.FormulaFields["RespSurname"].Text = "\"" + data["RespPartySurname"] + "\""; report.DataDefinition.FormulaFields["Employer"].Text = "\"" + data["RespPartyEmployer"] + "\""; report.DataDefinition.FormulaFields["RespName"].Text = "\"" + data["RespPartyName"] + "\""; report.DataDefinition.FormulaFields["Title"].Text = "\"" + data["RespPartyTitle"] + "\""; report.DataDefinition.FormulaFields["HandOverDate"].Text = "\"" + DateTime.Now.ToLongDateString() + "\""; report.DataDefinition.FormulaFields["Amount"].Text = "\"" + learner.Selection + "\""; report.DataDefinition.FormulaFields["RespID"].Text = "\"" + data["RespPartyID"] + "\""; report.DataDefinition.FormulaFields["Name"].Text = "\"" + data["Name"] + "\""; report.DataDefinition.FormulaFields["Surname"].Text = "\"" + data["Surname"] + "\""; report.DataDefinition.FormulaFields["ID"].Text = "\"" + data["ID"] + "\""; report.DataDefinition.FormulaFields["LearnerNr"].Text = "\"" + number.Selection + "\""; report.DataDefinition.FormulaFields["startDate"].Text = "\"" + data["respPartyStreet"] + "\""; report.DataDefinition.FormulaFields["RespPartyAdd"].Text = "\"" + data["respPartyStreet"] + "\"+Chr(13)+\" " + data["RespPartySubburb"] + "\"+Chr(13)+\" " + data["RespPartyCity"] + "\"+Chr(13)+\" " + data["RespPartyCountry"] + "\"+Chr(13)+\" " + data["RespPartyCode"] +"\""; report.DataDefinition.FormulaFields["Add"].Text = "\"" + data["Street"] + "\"+Chr(13)+\" " + data["Subburb"] + "\"+Chr(13)+\" " + data["City"] + "\"+Chr(13)+\" " + data["Country"] + "\"+Chr(13)+\" " + data["postCode"] + "\""; report.DataDefinition.FormulaFields["PostalAdd"].Text = "\"" + data["PostalStreet"] + "\"+Chr(13)+\" " + data["PostalSubburb"] + "\"+Chr(13)+\" " + data["PostalCity"] + "\"+Chr(13)+\" " + data["PostalCountry"] + "\"+Chr(13)+\" " + data["PostalCode"] + "\""; report.DataDefinition.FormulaFields["RespTelWork"].Text = "\"" + data["RespPartyTel2"] + "\""; report.DataDefinition.FormulaFields["RespTel"].Text = "\"" + data["RespPartyTel1"] + "\""; report.DataDefinition.FormulaFields["RespCell"].Text = "\"" + data["RespPartyCell"] + "\""; report.DataDefinition.FormulaFields["TelWork"].Text = "\"" + data["Tel1"] + "\""; report.DataDefinition.FormulaFields["Tel"].Text = "\"" + data["Tel2"] + "\""; report.DataDefinition.FormulaFields["Cell"].Text = "\"" + data["Cell"] + "\""; var frmReport = new frmReport(report) { Text = "Hand Over Request" }; frmReport.ShowDialog(); }
private void btnEdit_Click(object sender, EventArgs e) { if (impfunc.VALIDATION_BLANK(txtBillNo) == true) { return; } if ((btnEdit.Text == "Edit(F4)")) { impfunc.ADD_EDIT_FUNCTION("EDIT", btnAdd, btnEdit, btnDelete, grpContainer, GroupBox1, grpPayMent); cboParty.Enabled = false; txtBillNo.Focus(); } else { if (impfunc.VALIDATION_BLANK(cboParty) == true) { cboParty.Focus(); return; } if ((double.Parse(txtAmount.Text) == 0)) { MessageBox.Show("Please select atleast one Bill.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); dg.Focus(); return; } if ((double.Parse(txtTotalPaid.Text) < 1)) { MessageBox.Show("Paid amount must be greater than zero.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); txtCashPaid.Focus(); return; } int counter = 0; for (int i = 0; (i <= (DTEDIT.Rows.Count - 1)); i++) { if ((dgEdit.Rows[i].Cells[0].Value != null)) { counter++; } } if ((counter > 1)) { if ((double.Parse(txtBalance.Text) > 0)) { MessageBox.Show("Paid amount must be equal to Net Amount.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); txtCashPaid.Focus(); return; } } EXIST_COUNT = Convert.ToInt32(impfunc.GET_ONEFIELD(impfunc.cnn, "PAYMENT_MASTER", "COUNT(PAYMENTMASTERID)", ("PAYMENTMASTERID=" + MASTERID))); if ((EXIST_COUNT != 1)) { MessageBox.Show("Please select bill properly !", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if ((impfunc.EXISTS_RECORD(impfunc.cnn, "PAYMENT_MASTER", "PAYMENTNO", ("COMPANYID=" + (impfunc._COMPANYID + (" AND PAYMENTNO=" + (txtBillNo.Text.Trim() + (" and PAYMENTMASTERID<>" + MASTERID))))), false) == true)) { txtBillNo.Text = impfunc.GENERATE_MAX(impfunc.cnn, "PAYMENT_MASTER", "PAYMENTNO", ("COMPANYID=" + (impfunc._COMPANYID + ""))).ToString(); } try { int LEDGERBANKID = 0; if ((cboPaymode.Text == "CASH")) { LEDGERBANKID = 4; } else if ((cboPaymode.Text == "BANK")) { if (impfunc.VALIDATION_BLANK(cboBank) == true) { return; } LEDGERBANKID = Convert.ToInt32(cboBank.SelectedValue); } else if ((cboPaymode.Text == "BOTH")) { if (impfunc.VALIDATION_BLANK(cboBank) == true) { return; } LEDGERBANKID = Convert.ToInt32(cboBank.SelectedValue); } impfunc._Command = new SqlCommand(); impfunc._Command.Connection = impfunc.cnn; impfunc.OPENCONNECTION(); impfunc._TR = impfunc.cnn.BeginTransaction(IsolationLevel.ReadCommitted); impfunc._Command.Transaction = impfunc._TR; impfunc.UPDATE_RECORDS(impfunc.cnn, "PAYMENT_MASTER", impfunc._TR, "PAYMENTNO", "PAYMENTDATE", "LEDGERID", "DESCRIPTION", "PAYMODE", "BANKID", "BRANCH", "CHQNO", "CHQDATE", "CASHPAID", "CARDPAID", "TOTALPAID", txtBillNo.Text, dtpBillDate.Value.Date.ToString("dd/MMM/yyyy"), cboParty.SelectedValue.ToString(), txtDescription.Text, cboPaymode.Text, LEDGERBANKID.ToString(), txtBranch.Text.Trim(), txtChqNo.Text.Trim(), dtpCardDate.Value.Date.ToString("dd/MMM/yyyy"), txtCashPaid.Text, txtCardPaid.Text, txtTotalPaid.Text, "PAYMENTMASTERID", MASTERID); impfunc.DELETE_RECORDS(impfunc.cnn, "PAYMENT_SLAVE_PURCHASE", impfunc._TR, "PAYMENTMASTERID", MASTERID); for (int I = 0; (I <= (DTEDIT.Rows.Count - 1)); I++) { if ((dgEdit.Rows[I].Cells[0].Value != null)) { impfunc.SAVE_RECORDS(impfunc.cnn, "PAYMENT_SLAVE_PURCHASE", impfunc._TR, "PAYMENTMASTERID", "PURCHASEMASTERID", "PAIDAMOUNT", MASTERID.ToString(), dgEdit.Rows[I].Cells["colPurchaseMasterIdEdit"].Value.ToString(), ((counter > 1) ? dgEdit.Rows[I].Cells["colPaidByThisReceipt"].Value : double.Parse(txtTotalPaid.Text)).ToString()); // If counter > 1 Or Val(txtBalance.Text) < 1 Then // UPDATE_RECORDS(cnn, "SALE_MASTER", _TR, "PAIDSTATUS", 1, "SALEMASTERID", dgEdit.Rows(I).Cells("colSaleMasterIdEdit").Value) // End If // Else // UPDATE_RECORDS(cnn, "SALE_MASTER", _TR, "PAIDSTATUS", 0, "SALEMASTERID", dgEdit.Rows(I).Cells("colSaleMasterIdEdit").Value) } } impfunc.DELETE_FROM_JOURNAL(impfunc.cnn, impfunc._TR, ("VTYPE=\'PURCHASE PAYMENT\' and TRANSACTIONID =" + MASTERID)); SAVE_JOURNAL(); impfunc._TR.Commit(); frmReport frm = new frmReport(); rptfunc.ViewReport(frm.cr, "PAYMENT.rpt", "", "PAYMENTMASTERID", MASTERID.ToString(), 0, frm); frm.Show(); //frmReportFullPage frm = new frmReportFullPage(); //Check_ChildForm(Mainform); //// Add_ChildAtTab(frm, Mainform) //ViewReport(frm.cr, "PAYMENT.rpt", "", false, frm, ("PAYMENTMASTERID=" + MASTERID)); //Add_ChildAtTab(frm, Mainform); btnReset_Click(e, e); } catch (Exception ex) { MessageBox.Show(("ERROR: " + (ex.Message + ("\r\n" + "PLEASE CONTACT Mr. Amit Tiwari")))); impfunc._TR.Rollback(); } finally { impfunc.CLOSECONNECTION(); } } }
private void bankConfirmationLetterToolStripMenuItem_Click(object sender, EventArgs e) { var number = new frmSubmitText("Learner Number", "Please enter learner number"); number.ShowDialog(); while (Database.Count("learner_details", "LearnerNumber = '" + number.Selection + "' AND Division = '" + clsGlobal.loggedOnUserDivison + "'") == 0) { if (number.Selection == "***") return; MessageBox.Show("Invalid Learner Number", "Error"); number.ShowDialog(); } clsFunctions.WriteLog("Generated confirmation letter for learner: " + number.Selection); var date = new frmSubmitDate("Submit Date", "Please select Expiry Date"); date.ShowDialog(); if (date.status) { var report = new rptConfrimationLetter(); var data = Database.Row("learner_details a, enrollments b, enrollmentscourses c, courses d", "a.Division = '" + clsGlobal.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "' AND b.LearnerKey = a.LearnerKey AND c.idEnrollments = b.idEnrollments AND" + " d.idCourses = c.idCourses and not d.Type = 'CC'"); report.DataDefinition.FormulaFields["registrationDate"].Text = "\"" + data["regDate1"] + "\""; //report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number.Selection + "\""; report.DataDefinition.FormulaFields["principle"].Text = "\"" + clsGlobal.DivisionPrinciple + "\""; report.DataDefinition.FormulaFields["name"].Text = "\"" + Convert.ToString(data["Name"]) + " " + Convert.ToString(data["Surname"]) + "\""; report.DataDefinition.FormulaFields["reverseName"].Text = "\"" + Convert.ToString(data["surname"]) + ", " + Convert.ToString(data["name"]) + "\""; report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; report.DataDefinition.FormulaFields["ID"].Text = "\"" + Convert.ToString(data["ID"]) + "\""; report.DataDefinition.FormulaFields["expiryDate"].Text = "\"" + date.Selection.ToString("yyyyMMdd") + "\""; report.DataDefinition.FormulaFields["learnerType"].Text = "\"" + (MessageBox.Show("Is this a part time learner?","Part Time Learner",MessageBoxButtons.YesNo)==DialogResult.Yes?"Part Time":"Full Time") + "\""; //report.DataDefinition.FormulaFields["respParty"].Text = "\"" + clsGlobal.loggedOnUser + "\""; //report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; //logs.WriteXml(@"C:\tmpXml.xml"); var frmReport = new frmReport(report) {Text = "Bank Confirmation Request"}; frmReport.ShowDialog(); } }
private void assessmentCoverSheetToolStripMenuItem_Click(object sender, EventArgs e) { var dateSelect = new frmCoverSheet("Select Date", "Select Date"); dateSelect.ShowDialog(); do { //dateSelect.status = false; if (!dateSelect.creditBearing) { var cover = Database.Query("enrollments e, learner_details l, results r, components c, enrollmentcomponents z", "e.LearnerKey = l.LearnerKEy AND r.idEnrollments = e.idEnrollments AND c.idCourseComponents = r.idCourseComponents "+ "AND z.idCourseComponents = LEFT(r.idCourseComponents,(LOCATE('-EX',r.idCourseComponents)-1)) "+ "AND z.idEnrollments = e.idEnrollments AND c.ComponentAbrev = 'EX' AND active is Null" + " AND capturedDate = '" + dateSelect.Selection.ToString("yyyyMMdd") + "' AND l.Division = '" + clsGlobal.loggedOnUserDivison + "'", "l.Surname, l.LearnerNumber, r.idCourseComponents, z.serialNumber, c.Name, r.FinalMark, r.PracMark, z.Result", true, "enrollments e, learner_details l, results r, components c"); //cover.WriteXmlSchema(@"C:\temp_schema.xml"); var report = new rptAssessmentCoverSheet(); report.SetDataSource(cover); report.DataDefinition.FormulaFields["ExamDate"].Text = "\"" + dateSelect.Selection.ToString("dd/MM/yyyy") + "\""; report.DataDefinition.FormulaFields["College"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; report.DataDefinition.FormulaFields["totalNumber"].Text = "\"" + cover.Tables[0].Rows.Count + "\""; var frmReport = new frmReport(report) { Text = "Assessment Cover Sheet" }; frmReport.ShowDialog(); dateSelect.ShowDialog(); } else { var cover = Database.Query( "enrollments e, learner_details l, enrollmentComponents r, components c", "e.LearnerKey = l.LearnerKEy AND r.idEnrollments = e.idEnrollments AND c.idCourseComponents = r.idCourseComponents AND c.ComponentAbrev = 'PROJ' " + " AND resultDate = '" + dateSelect.Selection.ToString("yyyyMMdd") + "' AND l.Division = '" + clsGlobal.loggedOnUserDivison + "'", "l.Surname, l.LearnerNumber, r.idCourseComponents, r.serialNumber, c.Name, r.Result, r.resultDate"); var report = new rptAssessmentCoverSheetCredit(); report.SetDataSource(cover); report.DataDefinition.FormulaFields["ExamDate"].Text = "\"" + dateSelect.Selection.ToString("dd/MM/yyyy") + "\""; report.DataDefinition.FormulaFields["College"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; report.DataDefinition.FormulaFields["totalNumber"].Text = "\"" + cover.Tables[0].Rows.Count + "\""; var frmReport = new frmReport(report) { Text = "Assessment Cover Sheet" }; frmReport.ShowDialog(); dateSelect.ShowDialog(); } } while (dateSelect.status); }
private void bieu_01(bool prn) { ds = m.get_data("select id from " + user + ".bieu_01 where " + m.for_ngay("ngay", "'dd/mm/yyyy'") + " between to_date('" + s_tu + "','dd/mm/yyyy') and to_date('" + s_den + "','dd/mm/yyyy')" + " order by ngay desc"); if (ds.Tables[0].Rows.Count != 0) { decimal l_id = decimal.Parse(ds.Tables[0].Rows[0][0].ToString()); sql = "select a.ma,b.stt,b.ten,a.c01,a.c02,a.c03,a.c04,"; sql += "a.c05,a.c06,a.c07,a.c08,a.c09,a.c10,a.c11,a.c12,"; sql += "a.c13,a.c14,a.c15,a.c16,a.c17,a.c18,a.c19,a.c20,"; sql += "a.c21,a.c22,a.c23 "; sql += " from " + user + ".bieu_01 a," + user + ".dm_01 b where a.ma=b.ma and a.id=" + l_id; sql += " order by b.loai,b.kp,a.ma"; if (bPhatsinh) { ds = m.get_data(sql); } else { ds = m.get_data("select * from " + user + "." + s_table + " order by loai,kp,ma"); DataRow[] dr; foreach (DataRow r in m.get_data(sql).Tables[0].Rows) { dr = ds.Tables[0].Select("ma=" + int.Parse(r["ma"].ToString())); if (dr != null) { dr[0]["c01"] = r["c01"].ToString(); dr[0]["c02"] = r["c02"].ToString(); dr[0]["c03"] = r["c03"].ToString(); dr[0]["c04"] = r["c04"].ToString(); dr[0]["c05"] = r["c05"].ToString(); dr[0]["c06"] = r["c06"].ToString(); dr[0]["c07"] = r["c07"].ToString(); dr[0]["c08"] = r["c08"].ToString(); dr[0]["c09"] = r["c09"].ToString(); dr[0]["c10"] = r["c10"].ToString(); dr[0]["c11"] = r["c11"].ToString(); dr[0]["c12"] = r["c12"].ToString(); dr[0]["c13"] = r["c13"].ToString(); dr[0]["c14"] = r["c14"].ToString(); dr[0]["c15"] = r["c15"].ToString(); dr[0]["c16"] = r["c16"].ToString(); dr[0]["c17"] = r["c17"].ToString(); dr[0]["c18"] = r["c18"].ToString(); dr[0]["c19"] = r["c19"].ToString(); dr[0]["c20"] = r["c20"].ToString(); dr[0]["c21"] = r["c21"].ToString(); dr[0]["c22"] = r["c22"].ToString(); dr[0]["c23"] = r["c23"].ToString(); } } } if (m.getrowbyid(ds.Tables[0], "c01+c02+c03+c04+c05+c06+c07+c08+c09+c10+c11+c12+c13+c14+c15+c16+c17+c18+c19+c20+c21+c22+c23>0") == null) { MessageBox.Show(lan.Change_language_MessageText("Không có số liệu !"), LibMedi.AccessData.Msg); } else { if (prn) { p.Printer(m, ds, "bieu_01.rpt", title.ToUpper(), 2); } else { frmReport f = new frmReport(m, ds, title.ToUpper(), "bieu_01.rpt"); f.ShowDialog(this); } } } else { MessageBox.Show(lan.Change_language_MessageText("Không có số liệu !"), LibMedi.AccessData.Msg); } }
private void reportsToolStripMenuItem_Click(object sender, EventArgs e) { frmReport frm = new frmReport(); frm.MdiParent = this; frm.Show(); }
private void btnReport_Click(object sender, EventArgs e) { frmReport fReport = new frmReport(); fReport.ShowDialog(); }
/// <summary> /// On print button click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPrint_Click(object sender, EventArgs e) { try { frmReport crptReport = new frmReport(); DataSet ds = new DataSet(); DataTable dtblFormat2 = new DataTable(); DataTable dtblTotal = new DataTable(); CompanySP spCompany = new CompanySP(); DataTable dtblCompany = new DataTable(); dtblCompany = spCompany.CompanyViewAll(); if (dgvVatreturn.Rows.Count > 0) { if (dtblFill.Rows.Count > 0) { DataTable dtblReportFill = new DataTable(); dtblReportFill.Columns.Add("SlNO"); dtblReportFill.Columns.Add("Invoice No"); dtblReportFill.Columns.Add("Date"); dtblReportFill.Columns.Add("Party Name"); dtblReportFill.Columns.Add("Mailing Name"); dtblReportFill.Columns.Add("Tin No"); dtblReportFill.Columns.Add("qt"); dtblReportFill.Columns.Add("Sales Amound"); dtblReportFill.Columns.Add("Tax Amount"); dtblReportFill.Columns.Add("Cess"); dtblReportFill.Columns.Add("Net Amount"); dtblReportFill.Columns.Add("billDiscount"); dtblReportFill.Columns.Add("grandtotal"); for (int i = 0; i < dgvVatreturn.Rows.Count; i++) { DataRow drow = dtblReportFill.NewRow(); if (dgvVatreturn.Rows[i].Cells["dgvtxtSlno"].Value != null) { drow["SlNO"] = dgvVatreturn.Rows[i].Cells["dgvtxtSlno"].Value.ToString(); } if (dgvVatreturn.Rows[i].Cells["dgvtxtInvoiceNo"].Value != null) { drow["Invoice No"] = dgvVatreturn.Rows[i].Cells["dgvtxtInvoiceNo"].Value.ToString(); } if (dgvVatreturn.Rows[i].Cells["dgvtxtDate"].Value != null) { drow["Date"] = dgvVatreturn.Rows[i].Cells["dgvtxtDate"].Value.ToString(); } if (dgvVatreturn.Rows[i].Cells["dgvtxtPartyName"].Value != null) { drow["Party Name"] = dgvVatreturn.Rows[i].Cells["dgvtxtPartyName"].Value.ToString(); } if (dgvVatreturn.Rows[i].Cells["dgvtxtMailingName"].Value.ToString() != string.Empty) { drow["Mailing Name"] = dgvVatreturn.Rows[i].Cells["dgvtxtMailingName"].Value.ToString(); } if (dgvVatreturn.Rows[i].Cells["dgvtxtTinNo"].Value != null) { drow["Tin No"] = dgvVatreturn.Rows[i].Cells["dgvtxtTinNo"].Value.ToString(); } if (dgvVatreturn.Rows[i].Cells["dgvtxtQty"].Value != null) { drow["qt"] = dgvVatreturn.Rows[i].Cells["dgvtxtQty"].Value.ToString(); } if (dgvVatreturn.Rows[i].Cells["dgvtxtSalesAmount"].Value != null) { drow["Sales Amound"] = dgvVatreturn.Rows[i].Cells["dgvtxtSalesAmount"].Value.ToString(); } if (dgvVatreturn.Rows[i].Cells["dgvtxtTaxAmount"].Value != null) { drow["Tax Amount"] = dgvVatreturn.Rows[i].Cells["dgvtxtTaxAmount"].Value.ToString(); } if (dgvVatreturn.Rows[i].Cells["dgvtxtCess"].Value != null) { drow["Cess"] = dgvVatreturn.Rows[i].Cells["dgvtxtCess"].Value.ToString(); } if (dgvVatreturn.Rows[i].Cells["dgvtxtNetAmount"].Value != null) { drow["Net Amount"] = dgvVatreturn.Rows[i].Cells["dgvtxtNetAmount"].Value.ToString(); } if (dgvVatreturn.Rows[i].Cells["dgvtxtbillDiscount"].Value != null) { drow["billDiscount"] = dgvVatreturn.Rows[i].Cells["dgvtxtbillDiscount"].Value.ToString(); } if (dgvVatreturn.Rows[i].Cells["dgvtxtGrandTotal"].Value != null) { drow["grandtotal"] = dgvVatreturn.Rows[i].Cells["dgvtxtGrandTotal"].Value.ToString(); } dtblReportFill.Rows.Add(drow); } ds.Tables.Add(dtblReportFill); ds.Tables.Add(dtblCompany); crptReport.vatreturnReport(ds); } else { VoucherTypeSP spVoucher = new VoucherTypeSP(); dtblFormat2 = spVoucher.VatGridFill(DateTime.Parse(dtpFrmDate.Text), DateTime.Parse(dtpToDate.Text), cmbTypeofVoucher.Text, Convert.ToDecimal(cmbVouchertype.SelectedValue.ToString()), strformat, cmbTax.Text); if (dgvVatreturn.Rows.Count > 1) { dtblTotal.Columns.Add("taxableamt"); dtblTotal.Columns.Add("taxAmount"); DataRow dr1 = dtblTotal.NewRow(); dr1["taxableamt"] = dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 2].Cells["dgvtxtTaxableAmount"].Value.ToString(); dr1["taxAmount"] = dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 2].Cells["dgvtxttax"].Value.ToString(); dtblTotal.Rows.Add(dr1); ds.Tables.Add(dtblCompany); ds.Tables.Add(dtblFormat2); ds.Tables.Add(dtblTotal); crptReport.vatreturnReportFormat(ds); } } } else { MessageBox.Show("No data found", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("VRR:14" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void pictureBox2_Click(object sender, EventArgs e) { frmReport frm = new frmReport(); frm.Show(); }
private void prepareReportsToolStripMenuItem_Click(object sender, EventArgs e) { frmReport frm = new frmReport(); frm.Show(); }
private void btnPrint_Click(object sender, EventArgs e) { frmReport report = new frmReport("Sales", (DataTable)myGrid1.DataSource); report.ShowDialog(); }
private void transfersToolStripMenuItem_Click(object sender, EventArgs e) { var number = new frmSubmitText("Learner Number", "Please enter learner number"); number.ShowDialog(); while(Database.Count("learner_details","LearnerNumber = '" + number.Selection + "' AND Division = '" + clsGlobal.loggedOnUserDivison + "'") == 0) { if (number.Selection == "***") return; MessageBox.Show("Invalid Learner Number", "Error"); number.ShowDialog(); } var divisions = Database.Retrieve("division"); var theList = new ArrayList(); foreach (DataRow theRow in divisions.Tables[0].Rows) { theList.Add(Convert.ToString(theRow["DivisionName"])); } var select = new frmSelectSingle("Division", "Please select division", theList); select.ShowDialog(); var report = new rptTransfer(); var data = Database.Row("learner_details a, enrollments b, enrollmentscourses c, courses d, paymentinfo e", "a.Division = '" + clsGlobal.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "' AND b.LearnerKey = a.LearnerKey AND c.idEnrollments = b.idEnrollments AND"+ " e.idEnrollments = c.idEnrollments AND d.idCourses = c.idCourses"); report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number.Selection + "\""; report.DataDefinition.FormulaFields["transferBranch"].Text = "\"" + select.Selection + "\""; report.DataDefinition.FormulaFields["learnerName"].Text = "\"" + Convert.ToString(data["Name"]) + " " + Convert.ToString(data["Surname"]) + "\""; report.DataDefinition.FormulaFields["learnerTel"].Text = "\"" + Convert.ToString(data["Tel1"]) + "\""; report.DataDefinition.FormulaFields["Date"].Text = "\"" + DateTime.Now.ToString("dd/MM/yyyy") + "\""; report.DataDefinition.FormulaFields["Branch"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; report.DataDefinition.FormulaFields["clerk"].Text = "\"" + clsGlobal.LoggedOnUser + "\""; report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; report.DataDefinition.FormulaFields["coursePrice"].Text = "\"" + Convert.ToString(data["totalContractPrice"]) + "\""; //report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; //logs.WriteXml(@"C:\tmpXml.xml"); var frmReport = new frmReport(report) {Text = "Transfer Request"}; frmReport.ShowDialog(); }
private void mnuListFriends_Click(object sender, EventArgs e) { frmReport myFriendReport = new frmReport(this); myFriendReport.ShowDialog(); }
private void withdrawToolStripMenuItem_Click(object sender, EventArgs e) { var number = new frmSubmitText("Learner Number", "Please enter learner number"); number.ShowDialog(); while (Database.Count("learner_details", "LearnerNumber = '" + number.Selection + "' AND Division = '" + clsGlobal.loggedOnUserDivison + "'") == 0) { if (number.Selection == "***") return; MessageBox.Show("Invalid Learner Number", "Error"); number.ShowDialog(); } var reason = new frmSubmitText("Reason", "Please enter reason forwithdrawel"); reason.ShowDialog(); if (reason.Selection == "***") return; var Data = Database.Row("learner_details", "LearnerNumber = '" + number.Selection + "' AND Division = '" + clsGlobal.loggedOnUserDivison + "'"); var report = new rptWithdrawn(); report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; report.DataDefinition.FormulaFields["clerk"].Text = "\"" + clsGlobal.loggedOnUser + "\""; report.DataDefinition.FormulaFields["Name"].Text = "\"" + Data["Name"] + " " +Data["Surname"] + "\""; report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number.Selection + "\""; report.DataDefinition.FormulaFields["Reason"].Text = "\"" + reason.Selection + "\""; var frmReport = new frmReport(report) { Text = "Withdrawel Request" }; frmReport.ShowDialog(); }
private void tsbLoad_Click(object sender, EventArgs e) { if (cmbProject.SelectedIndex == -1) { return; } else if (cmbStatus.SelectedIndex == -1) { return; } else if (dTPFromDate.Value == Convert.ToDateTime("7/5/2019 2:46 PM")) { return; } else if (dTPToDate.Value == Convert.ToDateTime("7/5/2019 2:46 PM")) { return; } frmReport frm = new frmReport(); if (processtype == ProcessType.Allocations) { frm.reportType = ReportType.Allocations; } else if (processtype == ProcessType.Cancellations) { frm.reportType = ReportType.Cancellations; } else if (processtype == ProcessType.Reactivations) { frm.reportType = ReportType.Reactivations; } else if (processtype == ProcessType.Transfer) { frm.reportType = ReportType.Transfer; } else if (processtype == ProcessType.Refund) { frm.reportType = ReportType.Refund; } frm.strProjectID = cmbProject.Text; frm.dtFromDate = dTPFromDate.Value; frm.dtToDate = dTPToDate.Value; //0 if (cmbStatus.Text == "All") { frm.intStatusCode = -1; } //1 else if (cmbStatus.Text == "Pending") { frm.intStatusCode = 1; } //2 else if (cmbStatus.Text == "Approved") { frm.intStatusCode = 2; } else if (cmbStatus.Text == "Rejected") { frm.intStatusCode = 3; } frm.Show(); }
private void courseChangeToolStripMenuItem_Click(object sender, EventArgs e) { var number = new frmSubmitText("Learner Number", "Please enter learner number"); number.ShowDialog(); while (Database.Count("learner_details", "LearnerNumber = '" + number.Selection + "' AND Division = '" + clsGlobal.loggedOnUserDivison + "'") == 0) { if (number.Selection == "***") return; MessageBox.Show("Invalid Learner Number", "Error"); number.ShowDialog(); } var reason = new frmSubmitText("Reason", "Please enter reason for course change"); reason.ShowDialog(); var list = new ArrayList(); var courses = Database.Query("courses", "Not Type = 'CC'"); foreach (DataRow theRow in courses.Tables["courses"].Rows) { list.Add(theRow["Name"]); } var frmSelect = new frmSelectSingle("Select Course", "New Course to Enroll In", list); frmSelect.ShowDialog(); if (frmSelect.Selection == "***" || reason.Selection == "***") return; var report = new rptCourseChange(); var data = Database.Row("learner_details a, enrollments b, enrollmentscourses c, courses d", "a.Division = '" + clsGlobal.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "' AND b.LearnerKey = a.LearnerKey AND c.idEnrollments = b.idEnrollments AND" + " d.idCourses = c.idCourses"); report.DataDefinition.FormulaFields["date"].Text = "\"" + DateTime.Now.ToLongDateString() + "\""; report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; report.DataDefinition.FormulaFields["principle"].Text = "\"" + clsGlobal.DivisionPrinciple + "\""; report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number.Selection + "\""; report.DataDefinition.FormulaFields["reason"].Text = "\"" + reason.Selection + "\""; report.DataDefinition.FormulaFields["currentProgramme"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; report.DataDefinition.FormulaFields["learnerName"].Text = "\"" + Convert.ToString(data["Name"]) + " " + Convert.ToString(data["Surname"]) + "\""; report.DataDefinition.FormulaFields["newProgram"].Text = "\"" + frmSelect.Selection + "\""; //report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; //logs.WriteXml(@"C:\tmpXml.xml"); var frmReport = new frmReport(report) { Text = "Cancellation Request" }; frmReport.ShowDialog(); }
private void toolStripButton1_Click(object sender, EventArgs e) { frmReport frm = new frmReport(); frm.MdiParent = this; frm.Show(); }
private void diplomaToolStripMenuItem_Click(object sender, EventArgs e) { var number = new frmSubmitText("Learner Number", "Please enter learner number"); number.ShowDialog(); while (Database.Count("learner_details", "LearnerNumber = '" + number.Selection + "' AND Division = '" + clsGlobal.loggedOnUserDivison + "'") == 0) { if (number.Selection == "***") return; MessageBox.Show("Invalid Learner Number", "Error"); number.ShowDialog(); } var report = new rptDiploma(); var data = Database.Row("learner_details a, enrollments b, enrollmentscourses c, courses d", "a.Division = '" + clsGlobal.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "' AND b.LearnerKey = a.LearnerKey AND c.idEnrollments = b.idEnrollments AND" + " d.idCourses = c.idCourses"); report.DataDefinition.FormulaFields["date"].Text = "\"" + DateTime.Now.ToLongDateString() + "\""; report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number.Selection + "\""; report.DataDefinition.FormulaFields["principle"].Text = "\"" + clsGlobal.DivisionPrinciple + "\""; report.DataDefinition.FormulaFields["learnerName"].Text = "\"" + Convert.ToString(data["Name"]) + "\""; report.DataDefinition.FormulaFields["surname"].Text = "\"" + Convert.ToString(data["Surname"]) + "\""; report.DataDefinition.FormulaFields["diplomaName"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; report.DataDefinition.FormulaFields["respParty"].Text = "\"" + clsGlobal.loggedOnUser + "\""; //report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; //logs.WriteXml(@"C:\tmpXml.xml"); var frmReport = new frmReport(report) { Text = "Cancellation Request" }; frmReport.ShowDialog(); }
private void RepBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { dynamic row = RepGridView.GetFocusedRow(); if (row == null) { return; } var frm = new frmReport((int)row.RepId); switch ((int)row.RepId) { case 1: frm.OutDocGroupBox.Visible = false; frm.OnDateGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 2: frm.InDocGroupBox.Visible = false; frm.OnDateGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; frm.StatusPanel.Visible = true; break; case 39: case 3: frm.DocTypeGroupBox2.Visible = false; frm.InDocGroupBox.Visible = false; frm.OnDateGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; frm.GroupKontragentPanel.Visible = true; break; case 14: frm.InDocGroupBox.Visible = false; frm.OnDateGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; frm.GroupKontragentPanel.Visible = true; break; case 4: frm.DocTypeGroupBox2.Visible = false; frm.OutDocGroupBox.Visible = false; frm.OnDateGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 25: frm.OutDocGroupBox.Visible = false; frm.OnDateGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 26: frm.OnDateGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 30: case 8: frm.OnDateGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.GRPGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 5: case 6: frm.KontragentPanel.Visible = false; frm.PeriodGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.GRPGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 18: case 7: frm.PeriodGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 9: case 19: frm.OnDateGroupBox.Visible = false; frm.GRPGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; frm.GroupKontragentPanel.Visible = true; break; case 10: frm.DocTypeGroupBox2.Visible = false; frm.OnDateGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 11: frm.DocTypeGroupBox2.Visible = false; frm.KontragentPanel.Visible = false; frm.OnDateGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.GRPGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.MatGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 13: frm.DocTypeGroupBox2.Visible = false; frm.OnDateGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 15: frm.DocTypeGroupBox2.Visible = false; frm.OnDateGroupBox.Visible = false; frm.GRPGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; frm.WHGroupBox.Visible = false; break; case 16: frm.DocTypeGroupBox2.Visible = false; frm.OnDateGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.GRPGroupBox.Visible = false; break; case 17: case 23: frm.DocTypeGroupBox2.Visible = false; frm.KontragentPanel.Visible = false; frm.OnDateGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.GRPGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.MatGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; break; case 20: frm.DocTypeGroupBox2.Visible = false; frm.OnDateGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.GrpComboBox.Properties.DataSource = new List <object>() { new { GrpId = 0, Name = "Усі" } }.Concat(new BaseEntities().SvcGroup.Where(w => w.Deleted == 0).Select(s => new { s.GrpId, s.Name }).ToList()); frm.ChargeGroupBox.Visible = false; break; case 28: frm.OnDateGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; frm.GroupKontragentPanel.Visible = true; break; case 27: frm.OnDateGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; frm.GroupKontragentPanel.Visible = true; frm.PersonPanel.Visible = true; break; case 29: frm.OutDocGroupBox.Visible = false; frm.OnDateGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; break; case 31: frm.OnDateGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.WHGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 32: frm.OnDateGroupBox.Visible = false; frm.GRPGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.WHGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 33: frm.OnDateGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 34: frm.PeriodGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.GRPGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 35: frm.OnDateGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 36: frm.KontragentPanel.Visible = false; frm.PeriodGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.GRPGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 37: frm.OnDateGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.GRPGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; break; case 38: frm.OnDateGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.GRPGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; frm.WHGroupBox.Visible = false; break; case 22: frm.PersonPanel.Visible = true; frm.OnDateGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.GRPGroupBox.Visible = false; frm.KontragentPanel.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; frm.WHGroupBox.Visible = false; break; case 40: frm.PersonPanel.Visible = false; frm.GRPGroupBox.Visible = false; // frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.PeriodGroupBox.Visible = false; break; case 41: frm.OnDateGroupBox.Visible = false; frm.GroupKontragentPanel.Visible = true; frm.PersonPanel.Visible = false; frm.GRPGroupBox.Visible = false; frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.KontragentPanel.Visible = false; break; case 42: frm.InDocGroupBox.Visible = false; frm.OnDateGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.ChargeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.WHGroupBox.Visible = false; frm.KontragentPanel.Visible = false; break; case 43: frm.OnDateGroupBox.Visible = false; frm.PersonPanel.Visible = false; frm.GRPGroupBox.Visible = false; // frm.MatGroupBox.Visible = false; frm.DocTypeGroupBox.Visible = false; frm.DocTypeGroupBox2.Visible = false; frm.ChargeGroupBox.Visible = false; frm.WHGroupBox.Visible = false; frm.GroupKontragentPanel.Visible = true; frm.KontragentPanel.Visible = false; break; } frm.Text = row.Name; frm.ShowDialog(); }
private void btnAdd_Click(object sender, EventArgs e) { if ((btnAdd.Text == "Add(F3)")) { impfunc.ADD_EDIT_FUNCTION("ADD", btnAdd, btnEdit, btnDelete, grpContainer, GroupBox1, grpPayMent); CLEAT_CONT(); txtBillNo.Text = impfunc.GENERATE_MAX(impfunc.cnn, "PAYMENT_MASTER", "PAYMENTNO", ("COMPANYID=" + (impfunc._COMPANYID + ""))).ToString(); txtBillNo.Focus(); FILL_TABLE(); if ((Convert.ToInt32(cboParty.SelectedValue) > 0)) { cboParty_SelectionChangeCommitted(e, e); } } else { if (impfunc.VALIDATION_BLANK(cboParty) == true) { cboParty.Focus(); return; } if ((double.Parse(txtAmount.Text) == 0)) { MessageBox.Show("Please select atleast one Bill.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); dg.Focus(); return; } if ((double.Parse(txtTotalPaid.Text) < 1)) { MessageBox.Show("Paid amount must be greater than zero..", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); txtCashPaid.Focus(); return; } int counter = 0; for (int i = 0; (i <= (DV.Count - 1)); i++) { if ((dg.Rows[i].Cells[0].Value != null)) { counter++; } } if ((counter > 1)) { if ((double.Parse(txtBalance.Text) > 0)) { MessageBox.Show("Paid amount must be equal to Net Amount.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); txtCashPaid.Focus(); return; } } if (impfunc.EXISTS_RECORD(impfunc.cnn, "PAYMENT_MASTER", "PAYMENTNO", ("COMPANYID=" + (impfunc._COMPANYID + (" AND PAYMENTNO=" + (txtBillNo.Text.Trim() + "")))), false) == true) { txtBillNo.Text = impfunc.GENERATE_MAX(impfunc.cnn, "PAYMENT_MASTER", "PAYMENTNO", ("COMPANYID=" + (impfunc._COMPANYID + ""))).ToString(); } try { int LEDGERBANKID = 0; if ((cboPaymode.Text == "CASH")) { LEDGERBANKID = 4; } else if ((cboPaymode.Text == "BANK")) { if (impfunc.VALIDATION_BLANK(cboBank) == true) { return; } LEDGERBANKID = Convert.ToInt32(cboBank.SelectedValue); } else if ((cboPaymode.Text == "BOTH")) { if (impfunc.VALIDATION_BLANK(cboBank) == true) { return; } LEDGERBANKID = Convert.ToInt32(cboBank.SelectedValue); } impfunc._Command = new SqlCommand(); impfunc._Command.Connection = impfunc.cnn; impfunc.OPENCONNECTION(); impfunc._TR = impfunc.cnn.BeginTransaction(IsolationLevel.ReadCommitted); impfunc._Command.Transaction = impfunc._TR; impfunc.SAVE_RECORDS(impfunc.cnn, "PAYMENT_MASTER", impfunc._TR, "PAYMENTNO", "PAYMENTDATE", "LEDGERID", "DESCRIPTION", "PAYMODE", "BANKID", "BRANCH", "CHQNO", "CHQDATE", "CASHPAID", "CARDPAID", "TOTALPAID", "TABLENAME", "COMPANYID", txtBillNo.Text, dtpBillDate.Value.Date.ToString("dd/MMM/yyyy"), cboParty.SelectedValue.ToString(), txtDescription.Text, cboPaymode.Text, LEDGERBANKID.ToString(), txtBranch.Text.Trim(), txtChqNo.Text.Trim(), dtpCardDate.Value.Date.ToString("dd/MMM/yyyy"), txtCashPaid.Text, txtCardPaid.Text, txtTotalPaid.Text, "PURCHASE_MASTER", impfunc._COMPANYID.ToString()); MASTERID = Convert.ToInt32(impfunc.GET_ID_AFTER_SAVE(impfunc.cnn, "PAYMENT_MASTER", impfunc._TR)); for (int I = 0; (I <= (DV.Count - 1)); I++) { if ((dg.Rows[I].Cells[0].Value != null)) { impfunc.SAVE_RECORDS(impfunc.cnn, "PAYMENT_SLAVE_PURCHASE", impfunc._TR, "PAYMENTMASTERID", "PURCHASEMASTERID", "PAIDAMOUNT", MASTERID.ToString(), dg.Rows[I].Cells["colPurchaseMasterId"].Value.ToString(), ((counter > 1) ? dg.Rows[I].Cells["colBalance"].Value.ToString() : txtTotalPaid.Text)); // If counter > 1 Or Val(txtBalance.Text) < 1 Then // UPDATE_RECORDS(cnn, "SALE_MASTER", _TR, "PAIDSTATUS", 1, "SALEMASTERID", dg.Rows(I).Cells("colSaleMasterId").Value) // End If } } SAVE_JOURNAL(); impfunc._TR.Commit(); frmReport frm = new frmReport(); rptfunc.ViewReport(frm.cr, "PAYMENT.rpt", "", "PAYMENTMASTERID", MASTERID.ToString(), 0, frm); frm.Show(); btnReset_Click(e, e); } catch (Exception ex) { MessageBox.Show(("ERROR: " + (ex.Message + ("\r\n" + "PLEASE CONTACT Mr. Amit Tiwari")))); impfunc._TR.Rollback(); } finally { impfunc.CLOSECONNECTION(); } } }
private void learnersDriversBooksToolStripMenuItem_Click(object sender, EventArgs e) { var books = Database.Query("driversserials d JOIN learner_details l ON d.LearnerKey = l.LearnerKey", "division = '" + clsGlobal.loggedOnUserDivisionAbrev + "'"); //books.WriteXmlSchema("C:\\temp_schema.xml"); var report = new rptDriversSerials(); report.SetDataSource(books); report.DataDefinition.FormulaFields["college"].Text = "\"" + clsGlobal.LoggedOnUserDivision + "\""; var frmReport = new frmReport(report) { Text = "Learner's\\Driver's Serial Numbers" }; frmReport.ShowDialog(); }
private void btnChart_Click(object sender, EventArgs e) { frmReport report = new frmReport(); changeLayer(report); }
private void btnReportRevenue_Click(object sender, EventArgs e) { frmReport frm = new frmReport(cboSelectthienboat.SelectedValue.ToString(), dtmFromDate.Value, dtmToDate.Value); frm.ShowDialog(); }