public FrmAllocate()
{
InitializeComponent();
publicStreetGroup = this;
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.Null;
Load += OnFormLoad;
OnFormLoad(null, null);
btnSearch.Click += Bttn_Click;
btnAllocate.Click += Bttn_Click;
cboBank.KeyPress += cboBank_KeyPress;
cboPeriod.KeyPress += cboPeriod_KeyPress;
cboYears.KeyPress += cboYears_KeyPress;
}
public FrmReceiveRec()
{
InitializeComponent();
publicStreetGroup = this;
publicInstance = this;
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.Null;
Load += OnFormLoad;
txtFrom.Leave += txtFrom_Leave;
txtTo.Leave += txtTo_Leave;
bttnUpdate.Click += bttnUpdate_Click;
OnFormLoad(null, null);
gridView1.DoubleClick += gridView1_DoubleClick;
}
public FrmReceipts()
{
InitializeComponent();
publicInstance = this;
publicStreetGroup = this;
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.New;
Load += OnFormLoad;
OnFormLoad(null, null);
//cboZone.Items.Add("All Zones");
if (Program.UserID == "" || Program.UserID == null)
{
user = "******";
}
else
{
user = Program.UserID;
}
}
public FrmDemand()
{
InitializeComponent();
publicStreetGroup = this;
iTransType = TransactionTypeCode.New;
setImages();
ToolStripEvent();
Load += OnFormLoad;
temTable.Columns.Add("EReceipt", typeof(string));
temTable.Columns.Add("PaymentRefNumber", typeof(string));
temTable.Columns.Add("UserId", typeof(string));
dtsed.Columns.Add("SN", typeof(int));
dtsed.Columns.Add("PaymentRef", typeof(string));
//gridControl2.DataSource = dtsed;
//gridView3.Columns["SN"].OptionsColumn.AllowEdit = false;
//gridView3.Columns["SN"].Width = 30;
//gridView3.Columns["PaymentRef"].Width = 500;
OnFormLoad(null, null);
}
public FrmState()
{
InitializeComponent();
publicStreetGroup = this;
//if (CallOption == "1")
//{
//}
//else
//{ }
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.Null;
Load += OnFormLoad;
bttnCancel.Click += Bttn_Click;
//bttnReset.Click += Bttn_Click;
bttnUpdate.Click += Bttn_Click;
OnFormLoad(null, null);
}
public FrmLGA()
{
InitializeComponent();
//connect.ConnectionString();
publicStreetGroup = this;
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.Null;
Load += OnFormLoad;
gridView1.DoubleClick += gridView1_DoubleClick;
bttnCancel.Click += Bttn_Click;
//bttnReset.Click += Bttn_Click;
bttnUpdate.Click += Bttn_Click;
OnFormLoad(null, null);
txtStreetGroup.LostFocus += txtStreetGroup_LostFocus;
}
void OnToolStripItemsClicked(object sender, EventArgs e)
{
if (sender == tsbClose)
{
FrmReceipts.publicInstance.setDBComboProfile();
this.Close();
}
else if (sender == tsbNew)
{
iTransType = TransactionTypeCode.New;
setClear();
ShowForm();
boolIsUpdate = false;
}
else if (sender == tsbEdit)
{
iTransType = TransactionTypeCode.Edit;
if (EditRecordMode())
{
ShowForm();
boolIsUpdate = true;
}
}
else if (sender == tsbDelete)
{
tsbReload.PerformClick();
boolIsUpdate = false;
}
else if (sender == tsbReload)
{
iTransType = TransactionTypeCode.Reload; setReload();
boolIsUpdate = false;
ShowForm();
}
}
void deleteRecord(string parameter2)
{
string query = String.Format("UPDATE tblZonalRevenueOfficetemp SET IsActive = 0 WHERE OfficeCode='{0}'", parameter2);
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
db.Open();
transaction = db.BeginTransaction();
try
{
using (SqlCommand sqlCommand1 = new SqlCommand(query, db, transaction))
{
sqlCommand1.ExecuteNonQuery();
}
transaction.Commit();
Common.setMessageBox("Record Deleted Successfully ", Program.ApplicationName, 3);
setReload(); Clear();
iTransType = TransactionTypeCode.Reload;
ShowForm();
}
catch (Exception ex)
{
transaction.Rollback();
Tripous.Sys.ErrorBox(ex);
}
db.Close();
}
}
public FrmZonalTemp()
{
InitializeComponent();
publicStreetGroup = this;
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.Null;
Load += OnFormLoad;
OnFormLoad(null, null);
gridView1.DoubleClick += gridView1_DoubleClick;
txtCode.Leave += txtCode_Leave;
txtName.Leave += txtName_Leave;
//cboNature.Leave += cboNature_Leave;
bttnUpdate.Click += Bttn_Click;
}
public FrmRegVehicle()
{
InitializeComponent();
setImages();
publicStreetGroup = this;
ToolStripEvent();
iTransType = TransactionTypeCode.Null;
OnFormLoad(null, null);
colorEdit1.Properties.ShowCustomColors = false;
colorEdit1.Properties.ShowSystemColors = false;
colorEdit1.Properties.ShowWebColors = true;
txtEmail.LostFocus += txtEmail_LostFocus;
txtPlate.LostFocus += txtPlate_LostFocus;
//bttnClose.Click += bttnClose_Click;
//bttnUpdate.Click += bttnUpdate_Click;
//call gridview doubclick function
gridView1.DoubleClick += gridView1_DoubleClick;
}
public FrmReceipts()
{
InitializeComponent();
publicStreetGroup = this;
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.Null;
Load += OnFormLoad;
gridView1.DoubleClick += gridView1_DoubleClick;
bttnCancel.Click += Bttn_Click;
//bttnReset.Click += Bttn_Click;
bttnUpdate.Click += Bttn_Click;
cboBranch.EditValueChanged += cboBranch_EditValueChanged;
OnFormLoad(null, null);
}
public FrmRevenueTaxOffice()
{
InitializeComponent();
//connect.ConnectionString();
publicStreetGroup = this;
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.New;
Load += OnFormLoad;
gridView1.DoubleClick += gridView1_DoubleClick;
bttnCancel.Click += Bttn_Click;
//bttnReset.Click += Bttn_Click;
bttnUpdate.Click += Bttn_Click;
cboAgency.SelectedIndexChanged += cboAgency_SelectedIndexChanged;
cboAgency_SelectedIndexChanged(null, null);
cboNature.SelectedIndex = -1;
OnFormLoad(null, null);
}
void OnToolStripItemsClicked(object sender, EventArgs e)
{
if (sender == tsbClose)
{
MDIMains.publicMDIParent.RemoveControls();
}
else if (sender == tsbNew)
{
groupControl2.Text = "Add New Record";
iTransType = TransactionTypeCode.New;
ShowForm();
Unlockfield();
boolIsUpdate = false;
}
else if (sender == tsbEdit)
{
groupControl2.Text = "Edit Record Mode";
iTransType = TransactionTypeCode.Edit;
if (EditRecordMode())
{
ShowForm();
Unlockfield();
boolIsUpdate = true;
}
}
else if (sender == tsbDelete)
{
groupControl2.Text = "Delete Record Mode";
iTransType = TransactionTypeCode.Delete;
if (MosesClassLibrary.Utilities.Common.AskQuestion("Deleting this record will delete attached record.\nDo you want to continue?", ""))
{
}
else
{
tsbReload.PerformClick();
}
boolIsUpdate = false;
}
else if (sender == tsbReload)
{
iTransType = TransactionTypeCode.Reload;
//iTransType = TransactionTypeCode.New;
ShowForm();
Clear();
Lockfield();
}
bttnReset.PerformClick();
}
public FrmStateRef()
{
InitializeComponent();
publicStreetGroup = this;
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.Null;
Load += OnFormLoad;
bttnUpdate.Click += bttnUpdate_Click;
txtPercent.Leave += txtPercent_Leave;
txtVAT.Leave += txtVAT_Leave;
txtWTH.Leave += txtWTH_Leave;
gridView1.DoubleClick += gridView1_DoubleClick;
dtpBegin.Format = DateTimePickerFormat.Custom;
dtpBegin.CustomFormat = "dd-MM-yyyy";
OnFormLoad(null, null);
}
public FrmCashiers()
{
InitializeComponent();
publicInstance = this;
//connect.ConnectionString();
publicStreetGroup = this;
statecode = Program.stateCode;
//string query = String.Format("select statename from tblState where StateCode= '{0}' ", Program.stateCode);
//statename = extMethods.getQuery("bankcode", query);
//payref = extMethods.getQuery("TAXCODE", statecode);
//officecode = extMethods.getQuery("OFFICE", statecode);
DataTable dts = (new Logic()).getSqlStatement((String.Format("select statename,TaxCode from tblState where StateCode= '{0}' ", Program.stateCode))).Tables[0];
if (dts != null && dts.Rows.Count > 0)
{
statename = dts.Rows[0]["statename"].ToString();
payref = dts.Rows[0]["TaxCode"].ToString();
//cboAccount.Text = dts.Rows[0]["AccountNumber"].ToString();
}
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.New;
Load += OnFormLoad;
gridView1.DoubleClick += gridView1_DoubleClick;
btnAgent.Click += Bttn_Click;
btnPerson.Click += Bttn_Click;
btnGenrate.Click += Bttn_Click;
btnUpdate.Click += Bttn_Click;
btnSearch.Click += Bttn_Click;
OnFormLoad(null, null);
groupControl2.Enabled = false;
dtpDate.ValueChanged += dtpDate_ValueChanged;
chkPeriod.CheckedChanged += chkPeriod_CheckedChanged;
//NavBars.ToolStripEnableDisable(toolStrip, null, false);
}
public FrmRevenueTaxOffice()
{
InitializeComponent();
//connect.ConnectionString();
publicStreetGroup = this;
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.New;
Load += OnFormLoad;
gridView1.DoubleClick += gridView1_DoubleClick;
bttnCancel.Click += Bttn_Click;
bttnReset.Click += Bttn_Click;
bttnUpdate.Click += Bttn_Click;
OnFormLoad(null, null);
}
private void BttnUpdate_Click(object sender, EventArgs e)
{
DataTable dt;
//System.Data.DataSet ds;
using (var ds = new System.Data.DataSet())
{
string strquery = string.Format("SELECT token,Datecreated FROM Login.tblToken WHERE UserID='{0}' and ApplicationCode ='{1}' ORDER BY Datecreated ASC", Program.UserID, Program.ApplicationCode);
//connect.connect.Open();
using (SqlDataAdapter ada = new SqlDataAdapter(strquery, Logic.ConnectionString))
{
ada.Fill(ds, "table");
}
//connect.connect.Close();
dt = ds.Tables[0];
gridControl1.DataSource = dt.DefaultView;
}
gridView1.OptionsBehavior.Editable = false;
//gridView1.Columns["TransID"].Visible = false;
gridView1.Columns["Datecreated"].DisplayFormat.FormatString = "dd/MM/yyyy";
//gridView1.Columns["ElementCatCode"].Visible = false;
gridView1.BestFitColumns();
iTransType = TransactionTypeCode.Edit; ShowForm();
}
public FrmGenView()
{
InitializeComponent();
publicStreetGroup = this;
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.New;
Load += OnFormLoad;
OnFormLoad(null, null);
bttnUpdate.Click += bttnUpdate_Click;
dtpEnd.ValueChanged += dtpEnd_ValueChanged;
dtpStart.ValueChanged += dtpStart_ValueChanged;
//cboPeriods.KeyPress += cboPeriods_KeyPress;
//cboYears.KeyPress += cboYears_KeyPress;
}
public FrmRevenueType()
{
InitializeComponent();
publicStreetGroup = this;
setImages(); ToolStripEvent();
iTransType = TransactionTypeCode.New;
Load += OnFormLoad;
gridView1.DoubleClick += gridView1_DoubleClick;
bttnCancel.Click += Bttn_Click;
//bttnReset.Click += Bttn_Click;
bttnUpdate.Click += Bttn_Click;
OnFormLoad(null, null);
txtHead.Leave += txtHead_Leave;
txtSubHead.Leave += txtSubHead_Leave;
//cboAgency.Text = string.Empty;
cboCategory.SelectedIndex = -1;
cboSep.SelectedIndex = -1;
cboSubLedg.SelectedIndex = -1;
}
void OnToolStripItemsClicked(object sender, EventArgs e)
{
if (sender == tsbClose)
{
if (!IsShowDialog)
{
MDIMain.publicMDIParent.RemoveControls();
}
else
{
this.Close();
}
}
else if (sender == tsbNew)
{
//label11.Visible = false;
//txtPaymentRef.Visible = false;
//groupControl2.Text = "Add New Record";
//iTransType = TransactionTypeCode.New;
//ShowForm();
//clear();
//groupControl2.Enabled = true;
boolIsUpdate = false;
}
else if (sender == tsbEdit)
{
//groupControl2.Text = "Edit Record Mode";
iTransType = TransactionTypeCode.Edit;
//ShowForm();
boolIsUpdate = true;
}
//else if (sender == tsbDelete)
//{
// groupControl2.Text = "Delete Record Mode";
// iTransType = TransactionTypeCode.Delete;
// if (MosesClassLibrary.Utilities.Common.AskQuestion("Deleting this record will delete attached record.\nDo you want to continue?", ""))
// {
// }
// else
// tsbReload.PerformClick();
// boolIsUpdate = false;
//}
//else if (sender == tsbReload)
//{
// iTransType = TransactionTypeCode.Reload;
// ShowForm();
//}
//bttnReset.PerformClick();
}
void OnToolStripItemsClicked(object sender, EventArgs e)
{
if (sender == tsbClose)
{
MDIMain.publicMDIParent.RemoveControls();
}
//else if (sender == tsbNew)
//{
// //groupControl2.Text = "Add New Record";
// iTransType = TransactionTypeCode.New;
// ShowForm();
// //clear();
// //groupControl2.Enabled = true;
// boolIsUpdate = false;
//}
//else if (sender == tsbEdit)
//{
// //groupControl2.Text = "Edit Record Mode";
// iTransType = TransactionTypeCode.Edit;
// //groupControl2.Enabled = true;
// ShowForm();
// boolIsUpdate = true;
//}
////else if (sender == tsbDelete)
////{
//// groupControl2.Text = "Delete Record Mode";
//// iTransType = TransactionTypeCode.Delete;
//// if (MosesClassLibrary.Utilities.Common.AskQuestion("Deleting this record will delete attached record.\nDo you want to continue?", ""))
//// {
//// }
//// else
//// tsbReload.PerformClick();
//// boolIsUpdate = false;
////}
else if (sender == tsbReload)
{
iTransType = TransactionTypeCode.Reload;
//ShowForm();
rdbAgency.Checked = false;
rdbBank.Checked = false;
rdbRevOffices.Checked = false;
rdbRevType.Checked = false;
}
////bttnReset.PerformClick();
}
void gridView1_DoubleClick(object sender, EventArgs e)
{
if (EditRecordMode())
{
iTransType = TransactionTypeCode.New;
cboPosting.Text = "Non-REEMS Collections";
ShowForm();
groupControl2.Enabled = true;
boolIsUpdate = true;
}
}
void OnToolStripItemsClicked(object sender, EventArgs e)
{
if (sender == tsbClose)
{
MDIMains.publicMDIParent.RemoveControls();
}
else if (sender == tsbNew)
{
groupControl2.Text = "Add New Record";
iTransType = TransactionTypeCode.New;
ShowForm();
boolIsUpdate = false;
}
else if (sender == tsbEdit)
{
groupControl2.Text = "Edit Record Mode";
iTransType = TransactionTypeCode.Edit;
if (EditRecordMode())
{
ShowForm();
boolIsUpdate = true;
}
}
else if (sender == tsbDelete)
{
groupControl2.Text = "Disable Record Mode";
iTransType = TransactionTypeCode.Delete;
if (MosesClassLibrary.Utilities.Common.AskQuestion("Disable this record will Disable attached record.\nDo you want to continue?", ""))
{
if (string.IsNullOrEmpty(txtCode.Text.Trim()))
{
Common.setMessageBox("No Record Selected for Deleting", Program.ApplicationName, 3);
return;
}
else
{
deleteRecord(ID, (string)cboNature.SelectedValue);
}
}
else
{
tsbReload.PerformClick();
}
boolIsUpdate = false;
}
else if (sender == tsbReload)
{
iTransType = TransactionTypeCode.Reload;
ShowForm();
}
//bttnReset.PerformClick();
}
public FrmPostTransaction()
{
InitializeComponent();
publicStreetGroup = this;
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.Null;
Load += OnFormLoad;
bttnPost.Click += Bttn_Click;
bttnUpdate.Click += Bttn_Click;
bttnCancel.Click += Bttn_Click;
bttnReport.Click += Bttn_Click;
txtDateE.LostFocus += txtDateE_LostFocus;
txtCBal.LostFocus += txtCBal_LostFocus;
txtAmount.LostFocus += txtAmount_LostFocus;
OnFormLoad(null, null);
//create offline table
tableTrans.Columns.Add("Date", typeof(string));
tableTrans.Columns.Add("Transaction Description", typeof(string));
tableTrans.Columns.Add("Dr", typeof(Decimal));
tableTrans.Columns.Add("Cr", typeof(Decimal));
gridControl1.DataSource = tableTrans;
//this.Controls.Add(gridControl1);
gridControl1.BringToFront();
gridView1.OptionsBehavior.Editable = false;
gridView1.BestFitColumns();
//spECAmount.Properties.MinValue = decimal.Zero;
//spECAmount.Properties.MaxValue = decimal.MaxValue;
//spEAmount.Properties.MinValue = decimal.Zero;
//spEAmount.Properties.MaxValue = decimal.MaxValue;
//gridView1.Columns["Dr"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
//gridView1.Columns["Dr"].SummaryItem.DisplayFormat = "n2";
gridView3.DoubleClick += gridView3_DoubleClick;
}
public FrmValidateExPayDirect()
{
InitializeComponent();
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.Null;
Load += OnFormLoad;
OnFormLoad(null, null);
}
void OnToolStripItemsClicked(object sender, EventArgs e)
{
if (sender == tsbClose)
{
MDIMainForm.publicMDIParent.RemoveControls();
}
else if (sender == tsbNew)
{
groupControl1.Text = "Add New Record";
cbApplication_SelectedIndexChanged(null, null);
iTransType = TransactionTypeCode.New;
ShowForm();
boolIsUpdate = false;
txtUsername.Enabled = true;
cbApplication.SelectedIndex = -1;
//setDBComboBox();
}
else if (sender == tsbEdit)
{
if (EditRecordMode())
{
groupControl1.Text = "Edit Record Mode";
iTransType = TransactionTypeCode.Edit;
ShowForm();
boolIsUpdate = true;
txtUsername.Enabled = false;
SetIndex();
cbApplication_SelectedIndexChanged(null, null);
//setDBComboBox2();
}
}
else if (sender == tsbDelete)
{
groupControl1.Text = "Delete Record Mode";
iTransType = TransactionTypeCode.Delete;
if (MosesClassLibrary.Utilities.Common.AskQuestion("Deleting this record will delete attached record.\nDo you want to continue?", Program.ApplicationName))
{
}
tsbReload.PerformClick();
boolIsUpdate = false;
}
else if (sender == tsbReload)
{
groupControl1.Text = Program.ApplicationName;
iTransType = TransactionTypeCode.Reload;
ShowForm();
setReload();
}
bttnReset.PerformClick();
}
void OnToolStripItemsClicked(object sender, EventArgs e)
{
if (sender == tsbClose)
{
MDIMain.publicMDIParent.RemoveControls();
}
else if (sender == tsbNew)
{
groupControl2.Text = "Add New Record";
groupControl2.Enabled = true;
iTransType = TransactionTypeCode.New;
RefNumber();
boolIsUpdate = false;
}
else if (sender == tsbEdit)
{
groupControl2.Text = "Edit Record Mode";
groupControl2.Enabled = true;
iTransType = TransactionTypeCode.Edit;
//if (EditRecordMode())
//{
// //ShowForm();
// boolIsUpdate = true;
//}
}
else if (sender == tsbDelete)
{
groupControl2.Text = "Delete Record Mode";
iTransType = TransactionTypeCode.Delete;
if (MosesClassLibrary.Utilities.Common.AskQuestion("Deleting this record will delete attached record.\nDo you want to continue?", ""))
{
}
else
{
tsbReload.PerformClick();
}
boolIsUpdate = false;
}
else if (sender == tsbReload)
{
iTransType = TransactionTypeCode.Reload;
groupControl2.Enabled = false;
groupControl2.Text = " ";
gridControl1.DataSource = null;
//ShowForm();
}
//bttnReset.PerformClick();
}
void OnToolStripItemsClicked(object sender, EventArgs e)
{
if (sender == tsbClose)
{
MDIMains.publicMDIParent.RemoveControls();
}
else if (sender == tsbNew)
{
//groupControl2.Text = "Add New Record";
//iTransType = TransactionTypeCode.New;
//ShowForm();
//boolIsUpdate = false;
}
else if (sender == tsbEdit)
{
//groupControl2.Text = "Edit Record Mode";
//iTransType = TransactionTypeCode.Edit;
//if (EditRecordMode())
//{
// ShowForm();
// boolIsUpdate = true;
//}
}
else if (sender == tsbDelete)
{
//groupControl2.Text = "Disable Record Mode";
//iTransType = TransactionTypeCode.Delete;
//if (MosesClassLibrary.Utilities.Common.AskQuestion("Disable this record will delete attached record.\nDo you want to continue?", ""))
//{
// if (string.IsNullOrEmpty(ID.ToString()))
// {
// Common.setMessageBox("No Record Selected for Disable", Program.ApplicationName, 3);
// return;
// }
// else
// //deleteRecord(ID);
//}
//else
// tsbReload.PerformClick();
//boolIsUpdate = false;
}
else if (sender == tsbReload)
{
iTransType = TransactionTypeCode.Reload;
//ShowForm();
}
//bttnReset.PerformClick();
}
public FrmPostExPayDirect()
{
InitializeComponent();
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.Null;
Load += OnFormLoad;
OnFormLoad(null, null);
groupControl2.Enabled = false;
}
public FrmGeneral()
{
InitializeComponent();
publicInstance = this;
Load += OnFormLoad;
setImages();
ToolStripEvent();
iTransType = TransactionTypeCode.New;
OnFormLoad(null, null);
}
