private void toolStripButton1_Click(object sender, EventArgs e)
{
panelMain.Controls.Clear();
New_invoice addinvoice = new New_invoice(un, UT1);
addinvoice.TopLevel = false;
addinvoice.Visible = true;
panelMain.Controls.Add(addinvoice);
New_invoice.tx_bcrd.Focus();
}
// public static ToolStripMenuItem rpottt = new ToolStripMenuItem();
private void Main_Load(object sender, EventArgs e)
{
logut = false; rstor = false;
//--------------------------------Close Log_main-----------------------------------//
for (int index = Application.OpenForms.Count - 1; index >= 0; index--)
{
if (Application.OpenForms[1].Name == "Log_main")
{
Application.OpenForms[1].Close();
}
}
//---------------------------------------------------------------------------------//
SqlDataReader owndr = op2.select_owner();
if (owndr.Read())
{
own_un = owndr["User_Name"].ToString();
if (un == own_un)
{
notifyIcon2.Icon = SystemIcons.Information;
notifyIcon2.Visible = true;
notifyIcon2.ShowBalloonTip(2000, "Owner Account", "Welcome to Mars ComputerSystem", ToolTipIcon.Info);
}
}
if (UT1 == "Administrator")
{
salaryAndTargrtToolStripMenuItem.Enabled = false;
receivedSalaryToolStripMenuItem.Enabled = false;
ownerAccountToolStripMenuItem.Enabled = false;
//backupDatabaseToolStripMenuItem.Enabled = false;
//restorDatabaseToolStripMenuItem.Enabled = false;
}
if (UT1 == "Standard User")
{
reportsToolStripMenuItem.Enabled = false;
payrollToolStripMenuItem.Enabled = false;
employersToolStripMenuItem.Enabled = false;
toolStripSplitButton_prol.Enabled = false;
toolStripButton9.Enabled = false;
backupDatabaseToolStripMenuItem.Enabled = false;
restorDatabaseToolStripMenuItem.Enabled = false;
}
panelMain.Controls.Clear();
New_invoice addinvoice = new New_invoice(un, UT1);
addinvoice.TopLevel = false;
addinvoice.Visible = true;
panelMain.Controls.Add(addinvoice);
p1 = panelMain;
firstlod = true;
now_yer = DateTime.Today.Year.ToString();
now_mon = DateTime.Today.Month.ToString();
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++check temp Table is Null++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++//
String emty = "SELECT*FROM tbl_Salary_Temp";
SqlDataAdapter iigemty = new SqlDataAdapter(emty, ConnectionDB.Connection());
DataTable iemty = new DataTable();
iigemty.Fill(iemty);
if (0 == iemty.Rows.Count) // does not exist
{
pay_op.Insert_Temp_data(now_yer, now_mon);
}
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SqlDataReader tmpdr = pay_op.select_Temp_data();
if (tmpdr.Read())
{
DB_yer = tmpdr["Year"].ToString();
DB_mon = tmpdr["Month"].ToString();
}
if (DB_yer != now_yer || DB_mon != now_mon)
{
if (Convert.ToDouble(DB_yer) < Convert.ToDouble(now_yer) || Convert.ToDouble(DB_mon) < Convert.ToDouble(now_mon))
{
if (MessageBox.Show("Accoding System Date Time This Is A New Month \nIf You Sure System Date time Correct Press \"OK\" To Complete Old Month Payroll Details", "Sharp Creation", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK)
{
//=+=+=+=+=+=+=+=+= Update payroll +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
String sql = "SELECT*FROM tbl_UserAccount";
SqlDataAdapter get = new SqlDataAdapter(sql, ConnectionDB.Connection());
DataTable ns = new DataTable();
get.Fill(ns);
for (int i = 0; i < ns.Rows.Count; i++)
{
string unme = ns.Rows[i]["User_Name"].ToString();
// MessageBox.Show(unme);
mon_sal = 0; mon_tgt = 0; arias = 0; reminig = 0; compt_tgt = 0; net_sal = 0; tot_sal = 0; etra_com_tgt = 0; tgt_rte = 0; etra_sal = 0; recevd_sal = 0; rest_sal = 0; additionl_sal = 0;
invo_yer = ""; invo_mon = ""; recev_yer = ""; recev_mon = "";
SqlDataReader htydr = pay_op.select_sal_tgt(unme);
if (htydr.Read())
{
mon_sal = Convert.ToDecimal(htydr["Monthly_Salary"].ToString());
mon_tgt = Convert.ToDecimal(htydr["Monthly_Trget"].ToString());
}
SqlDataReader blncdr = pay_op.select_sal_blnce(unme);
if (blncdr.Read())
{
arias = Convert.ToDecimal(blncdr["Arrears"].ToString());
reminig = Convert.ToDecimal(blncdr["Remaining"].ToString());
}
//____________________net month sal__________________________________________________________________________________________
net_sal = (mon_sal + reminig) - arias;
//___________________________________________________________________________________________________________________________
//_______________________________________get completed target_________________________________________________________________
String iisql = "SELECT Invoice_Date,Total_Price FROM tbl_Invoice WHERE Seals_ref='" + unme + "'";
SqlDataAdapter iiget = new SqlDataAdapter(iisql, ConnectionDB.Connection());
DataTable iins = new DataTable();
iiget.Fill(iins);
for (int ii = 0; ii < iins.Rows.Count; ii++)
{
decimal invo_tot = Convert.ToDecimal(iins.Rows[ii]["Total_Price"].ToString());
invo_dte = Convert.ToDateTime(iins.Rows[ii]["Invoice_Date"].ToString());
invo_yer = invo_dte.Year.ToString();
invo_mon = invo_dte.Month.ToString();
if (DB_yer == invo_yer && DB_mon == invo_mon)
{
compt_tgt += invo_tot;
}
}
//_____________________________________________________________________________________________________________________________
//_____________________Extra completed_________________________________________________________________________________________
if (compt_tgt > mon_tgt)
{
etra_com_tgt = compt_tgt - mon_tgt;
}
//_____________________________________________________________________________________________________________________________
//_____________________Extra salary _________________________________________________________________________________________
SqlDataReader rtedr = pay_op.select_tgt_rte(unme);
if (rtedr.Read())
{
tgt_rte = Convert.ToDecimal(rtedr["Target_rate"].ToString());
}
etra_sal = (Math.Round(etra_com_tgt) / 100) * tgt_rte;
//_____________________________________________________________________________________________________________________________
//_____________________Total salary ___________________________________________________________________________________________
tot_sal = net_sal + etra_sal;
//_____________________________________________________________________________________________________________________________
//_______________Received Salary_______________________________________________________________________________________________
String siisql = "SELECT * FROM tbl_Salary_Received WHERE User_Name='" + unme + "'";
SqlDataAdapter siiget = new SqlDataAdapter(siisql, ConnectionDB.Connection());
DataTable siins = new DataTable();
siiget.Fill(siins);
for (int sii = 0; sii < siins.Rows.Count; sii++)
{
decimal recevid_tot = Convert.ToDecimal(siins.Rows[sii]["Received_Salary"].ToString());
receive_date = Convert.ToDateTime(siins.Rows[sii]["Received_Date"].ToString());
recev_yer = receive_date.Year.ToString();
recev_mon = receive_date.Month.ToString();
if (DB_yer == recev_yer && DB_mon == recev_mon)
{
recevd_sal += recevid_tot;
}
}
//_____________________________________________________________________________________________________________________________
//______________________________Sal_rest_______________________________________________________________________________________
if (recevd_sal <= tot_sal)
{
rest_sal = tot_sal - recevd_sal;
}
//_____________________________________________________________________________________________________________________________
//______________________________Additional received_____________________________________________________________________________
if (recevd_sal > tot_sal)
{
additionl_sal = recevd_sal - tot_sal;
}
//_____________________________________________________________________________________________________________________________
//_________________________Insert sal Histry___________________________________________________________________________________
try
{
pay_op.Insert_sal_history(unme, DB_yer, DB_mon, mon_sal, arias, reminig, net_sal, mon_tgt, compt_tgt, etra_com_tgt, etra_sal, tot_sal, recevd_sal, additionl_sal, rest_sal);
}
catch (Exception) { }
//_____________________________________________________________________________________________________________________________
//_________________________Update sal Balance___________________________________________________________________________________
try
{
pay_op.Update_sal_blnce(unme, additionl_sal, rest_sal);
}
catch (Exception) { }
//_____________________________________________________________________________________________________________________________
}
//______________________Update temp data_______________________________________________________________________________________
try
{
pay_op.Update_temp_data(now_yer, now_mon);
}
catch (Exception) { }
//______________________________________________________________________________________________________________________________
//=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
notifyIcon1.Icon = SystemIcons.Information;
notifyIcon1.Visible = true;
notifyIcon1.ShowBalloonTip(2000, "Sharp Creation", "\"" + DB_yer + " / " + DB_mon + " \" Payroll Details Completed Sucessfully.\nAnd Start New Payroll " + "\"" + now_yer + " / " + now_mon + " \"", ToolTipIcon.Info);
}
}
else
{
MessageBox.Show("Your System Date is Wrong", "Sharp Creatuon", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
// rpottt = reportsToolStripMenuItem;
logoutToolStripMenuItem.Font = new Font(Font, Font.Style | FontStyle.Regular);
}
