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();
}
