private void Edit_reqst_odr_Load(object sender, EventArgs e)
{
String sql = "SELECT*FROM tbl_AddS_Supplier";
SqlDataAdapter get = new SqlDataAdapter(sql, ConnectionDB.Connection());
DataTable ns = new DataTable();
get.Fill(ns);
for (int i = 0; i < ns.Rows.Count; i++)
{
cbxSupplier.Items.Add(ns.Rows[i]["Business_Name"]);
}
String csql = "SELECT*FROM tbl_catogory";
SqlDataAdapter cget = new SqlDataAdapter(csql, ConnectionDB.Connection());
DataTable cdt = new DataTable();
cget.Fill(cdt);
for (int i = 0; i < cdt.Rows.Count; i++)
{
cbx_qty_ctgy.Items.Add(cdt.Rows[i]["catogory"]);
}
String bsql = "SELECT*FROM tbl_brande";
SqlDataAdapter bget = new SqlDataAdapter(bsql, ConnectionDB.Connection());
DataTable bdt = new DataTable();
bget.Fill(bdt);
for (int i = 0; i < bdt.Rows.Count; i++)
{
cbx_qty_Brand.Items.Add(bdt.Rows[i]["Brande"]);
}
String tsql = "SELECT*FROM tbl_itype";
SqlDataAdapter tget = new SqlDataAdapter(tsql, ConnectionDB.Connection());
DataTable tdt = new DataTable();
tget.Fill(tdt);
for (int i = 0; i < tdt.Rows.Count; i++)
{
cbx_itmtype.Items.Add(tdt.Rows[i]["Item_type"]);
}
cbx_qty_ctgy.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
cbx_qty_ctgy.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbx_qty_ctgy.AutoCompleteSource = AutoCompleteSource.ListItems;
cbx_qty_Brand.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
cbx_qty_Brand.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbx_qty_Brand.AutoCompleteSource = AutoCompleteSource.ListItems;
lblOrderNo.Text = View_Requst_Order.dgv_rqet.CurrentRow.Cells["Order_No"].Value.ToString();
DateTime Odt = DateTime.Parse(View_Requst_Order.dgv_rqet.CurrentRow.Cells["Order_Date"].Value.ToString());
dp_rest_odr.Text = Odt.ToShortDateString();
txtMobile.Text = View_Requst_Order.dgv_rqet.CurrentRow.Cells["Mobile"].Value.ToString();
txt_email.Text = View_Requst_Order.dgv_rqet.CurrentRow.Cells["Email"].Value.ToString();
txtDiscription.Text = View_Requst_Order.dgv_rqet.CurrentRow.Cells["Discription"].Value.ToString();
cbx_qty_ctgy.Text = View_Requst_Order.dgv_rqet.CurrentRow.Cells["Catogory"].Value.ToString();
cbxSupplier.Text = View_Requst_Order.dgv_rqet.CurrentRow.Cells["Supplier"].Value.ToString();
cbx_qty_S_ctgy.Text = View_Requst_Order.dgv_rqet.CurrentRow.Cells["Sub_Catogory"].Value.ToString();
cbx_qty_Brand.Text = View_Requst_Order.dgv_rqet.CurrentRow.Cells["Brande"].Value.ToString();
cbx_itmtype.Text = View_Requst_Order.dgv_rqet.CurrentRow.Cells["Item_Type"].Value.ToString();
txt_inme.Text = View_Requst_Order.dgv_rqet.CurrentRow.Cells["Name"].Value.ToString();
numericUpDown1.Value = Convert.ToDecimal(View_Requst_Order.dgv_rqet.CurrentRow.Cells["Quntity"].Value.ToString());
}
private void btn_ok_Click(object sender, EventArgs e)
{
ep_iname.SetError(txtAddItemItemName, "");
ep_isupp.SetError(cbxAddItemItemType, "");
ep_ibrnd.SetError(cbxAddItemBrande, "");
ep_ictogry.SetError(cbxAddItemCatogory, "");
ep_isubCotory.SetError(cbxAddItemSubCatogory, "");
SqlDataReader cdr = wrty.select_cusNo(Warranty_Details.dgvw.CurrentRow.Cells["Invoice_No"].Value.ToString());
if (cdr.Read())
{
ccno = cdr["Coustomer_No"].ToString();
InvDt = Convert.ToDateTime(cdr["Invoice_Date"]);
ipmthd = cdr["Payment_Method"].ToString();
}
//try
//{
if (txtAddItemBarcode.Text != "" || txtAddItemSerial.Text != "")
{
if (txtAddItemItemName.Text != "" && cbxAddItemCatogory.Text != "" && cbxAddItemSubCatogory.Text != "" && cbxAddItemBrande.Text != "")
{
if (txtAddItemSerial.Text == "")
{
txtAddItemSerial.Text = txtAddItemBarcode.Text;
}
SqlDataReader ddr = wrty.select_invo_backI(Warranty_Details.dgvw.CurrentRow.Cells["Item_No"].Value.ToString(), Warranty_Details.dgvw.CurrentRow.Cells["Invoice_No"].Value.ToString());
if (ddr.Read())
{
inom = ddr["Item_No"].ToString();
inme = ddr["Item_Name"].ToString();
iserial = ddr["Serial_No"].ToString();
iselpiz = ddr["Sales_Price"].ToString();
ipurpiz = ddr["Purchase_Price"].ToString();
ictgry = ddr["Catogory"].ToString();
isubctgry = ddr["Sub_Catogory"].ToString();
ibrnd = ddr["Brande"].ToString();
ibcode = ddr["Barcode"].ToString();
iwrrty = ddr["Warranty"].ToString();
isuppl = ddr["Supplier"].ToString();
itpe = ddr["Item_Type"].ToString();
idescri = ddr["Discription"].ToString();
wrty.insert_retn_itm(inom, iserial, inme, Convert.ToDecimal(iselpiz), Convert.ToDecimal(ipurpiz), Convert.ToDecimal("0"), ibcode, ictgry, isubctgry, ibrnd, itpe, isuppl, iwrrty, idescri);
//MessageBox.Show("add to return item");
}
decimal pfit = (Convert.ToDecimal(iselpiz)) - (Convert.ToDecimal(ipurpiz));
Invo.insert_Invoice_detalis(iNo.ToString(), InvDt, lbl_itNo.Text, txtAddItemSerial.Text, txtAddItemItemName.Text, Convert.ToDecimal(iselpiz), Convert.ToDecimal(ipurpiz), txtAddItemBarcode.Text, cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text, iwrrty, isuppl, cbxAddItemItemType.Text, txtAddItemDiscription.Text, pfit, "Ok", "1");
// MessageBox.Show("new itttttttttmss changgggg");
Invo.insert_Invoice(iNo.ToString(), InvDt, Convert.ToDecimal(iselpiz), (Convert.ToDecimal(iselpiz)), Convert.ToDecimal("0"), ipmthd, "*" + txtAddItemItemName.Text, New_invoice.sref.Text, ccno, Convert.ToDecimal(iselpiz), Convert.ToDecimal("0"), Convert.ToDecimal("0"), "Ok");
//MessageBox.Show("ADd new invo");
wrty.update_item_status(Warranty_Details.dgvw.CurrentRow.Cells["Invoice_No"].Value.ToString(), Warranty_Details.dgvw.CurrentRow.Cells["Item_No"].Value.ToString(), "Return");
//MessageBox.Show("update oled invo");
wrty.addWary_foundItm(Warranty_Details.dgvw.CurrentRow.Cells["Warranty_No"].Value.ToString(), Warranty_Details.dgvw.CurrentRow.Cells["Invoice_No"].Value.ToString(), lbl_itNo.Text, txtAddItemItemName.Text, txtAddItemSerial.Text, txtAddItemBarcode.Text, cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text, cbxAddItemItemType.Text, txtAddItemDiscription.Text);
// MessageBox.Show("warranty found item");
wty_dtail_inconplete.anorItm = true;
if (MessageBox.Show("Warranty complted by another Item", "Sharp creation", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
if (cb_printi.Checked == true)
{
//==========================================================================================================================
SqlDataReader ziddr = Invo.select_invoNo(iNo.ToString());
if (ziddr.Read())
{
invodate = Convert.ToDateTime(ziddr["Invoice_Date"].ToString());
total = ziddr["Total_Price"].ToString();
paid = ziddr["Paid_Price"].ToString();
blnc = ziddr["Balance"].ToString();
cusnom = ziddr["Coustomer_No"].ToString();
paymethd = ziddr["Payment_Method"].ToString();
grantota = ziddr["Grande_total"].ToString();
disc = ziddr["Discount"].ToString();
tax = ziddr["Tax"].ToString();
}
SqlDataReader zdrcus = Invo.select_incus(cusnom);
if (zdrcus.Read())
{
fname = zdrcus["First_Name"].ToString();
lnme = zdrcus["Last_Name"].ToString();
add1 = zdrcus["Address_Line1"].ToString();
add2 = zdrcus["Address_Line2"].ToString();
mobl = zdrcus["Mobile"].ToString();
}
else
{
fname = "N/A";
lnme = "N/A";
add1 = "N/A";
add2 = "N/A";
mobl = "N/A";
}
String ibsql = "SELECT*FROM tbl_Invoice_details WHERE Invoice_No='" + iNo + "'";
SqlDataAdapter ibget = new SqlDataAdapter(ibsql, ConnectionDB.Connection());
DataTable ibns = new DataTable();
ibget.Fill(ibns);
for (int ib = 0; ib < ibns.Rows.Count; ib++)
{
itmno = ibns.Rows[ib]["Item_No"].ToString();
itmNme = ibns.Rows[ib]["Item_Name"].ToString();
itmseril = ibns.Rows[ib]["Serial_No"].ToString();
itsalepriz = ibns.Rows[ib]["Sales_Price"].ToString();
itmctgy = ibns.Rows[ib]["Catogory"].ToString();
itmsbctgy = ibns.Rows[ib]["Sub_Catogory"].ToString();
itmbrnd = ibns.Rows[ib]["Brande"].ToString();
itmwarrty = ibns.Rows[ib]["Warranty"].ToString();
iqty = ibns.Rows[ib]["Quntity"].ToString();
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ check- is bill table Null...? ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++//
String emty_ibl = "SELECT*FROM tbl_Invoice_bill";
SqlDataAdapter iigemty_bil = new SqlDataAdapter(emty_ibl, ConnectionDB.Connection());
DataTable iemty_bil = new DataTable();
iigemty_bil.Fill(iemty_bil);
if (0 != iemty_bil.Rows.Count) // does not exist
{
//___________________________________________________________________________________________________________________________
SqlDataReader slct_billDR = Invo.select_invtmp_bil(itmctgy, itmsbctgy, itmbrnd);
if (slct_billDR.Read())
{
string bsril, bqtyy, u_piz; decimal n_qty;
bsril = slct_billDR["Serial_No"].ToString();
bqtyy = slct_billDR["Quantity"].ToString();
u_piz = slct_billDR["Unit_Price"].ToString();
n_qty = Convert.ToDecimal(bqtyy) + Convert.ToDecimal(iqty);
Invo.Updte_invc_bill(itmctgy, itmsbctgy, itmbrnd, n_qty, (Convert.ToDecimal(u_piz) * n_qty), bsril + "," + itmseril);
//MessageBox.Show("update_Dtail");
}
else
{
try
{
Invo.insert_Invoice_Bill(iNo.ToString(), invodate, fname + " " + lnme, add1 + " " + add2, mobl, Convert.ToDecimal(grantota), Convert.ToDecimal(disc), Convert.ToDecimal(tax), Convert.ToDecimal(total), Convert.ToDecimal(paid), paymethd, Convert.ToDecimal(blnc), itmseril, itmctgy, itmsbctgy, itmbrnd, itmbrnd + " " + itmNme + " " + itmctgy + " " + itmsbctgy + " \nWarranty- " + itmwarrty, Convert.ToDecimal(Convert.ToDecimal(itsalepriz) / Convert.ToDecimal(iqty)), Convert.ToDecimal(iqty), Convert.ToDecimal(itsalepriz));
//MessageBox.Show("Invoice bill add");
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
//___________________________________________________________________________________________________________________________
}
else
{
try
{
Invo.insert_Invoice_Bill(iNo.ToString(), invodate, fname + " " + lnme, add1 + " " + add2, mobl, Convert.ToDecimal(grantota), Convert.ToDecimal(disc), Convert.ToDecimal(tax), Convert.ToDecimal(total), Convert.ToDecimal(paid), paymethd, Convert.ToDecimal(blnc), itmseril, itmctgy, itmsbctgy, itmbrnd, itmbrnd + " " + itmNme + " " + itmctgy + " " + itmsbctgy + " \nWarranty- " + itmwarrty, Convert.ToDecimal(Convert.ToDecimal(itsalepriz) / Convert.ToDecimal(iqty)), Convert.ToDecimal(iqty), Convert.ToDecimal(itsalepriz));
//MessageBox.Show("Invoice bill add");
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
}
Bill invoBil = new Bill();
invoBil.ShowDialog();
//============================================================================================================================
//============================================================================================================================
}
//============================================================================================================================
wty_dtail_inconplete.bt_save = true;
this.Close();
}
}
else
{
if (txtAddItemItemName.Text == "")
{
ep_iname.SetError(txtAddItemItemName, "Enter Item name");
}
if (cbxAddItemItemType.Text == "")
{
ep_isupp.SetError(cbxAddItemItemType, "Choose type");
}
if (cbxAddItemBrande.Text == "")
{
ep_ibrnd.SetError(cbxAddItemBrande, "Choose Item Brande");
}
if (cbxAddItemCatogory.Text == "")
{
ep_ictogry.SetError(cbxAddItemCatogory, "Choose Item Catogary");
}
if (cbxAddItemSubCatogory.Text == "")
{
ep_isubCotory.SetError(cbxAddItemSubCatogory, "Choose Item sub Catogary");
}
tp_required.Show("Fill Require fileds", btn_ok, 5000);
}
}
else
{
tp_seril_barcobe.Show("Must Enter Serial or Barcode For Iditify Items", txtAddItemSerial, 4000);
}
//}
//catch (Exception ee)
//{ MessageBox.Show(ee.Message); }
}
private void cbx_month_SelectedIndexChanged(object sender, EventArgs e)
{
errorProvider_Unme.SetError(cbx_usernn, "");
errorProvider_yer.SetError(cbx_year, "");
errorProvider_mon.SetError(cbx_month, "");
lbl_tot_sal.Text = "N/A";
lbl_reced_sal.Text = "N/A";
lbl_rest.Text = "N/A";
lbl_adition_reced.Text = "N/A";
if (cbx_usernn.Text != "" && cbx_year.Text != "" && cbx_month.Text != "")
{
string sql = "SELECT * FROM tbl_Salary_Received WHERE User_Name='" + cbx_usernn.Text + "' AND Year='" + cbx_year.Text + "' ";
SqlDataAdapter da = new SqlDataAdapter(sql, ConnectionDB.Connection());
dtbl = new DataTable();
da.Fill(dtbl);
BindingSource bnsue = new BindingSource();
bnsue.DataSource = dtbl;
dgv_get_histry.DataSource = bnsue;
da.Update(dtbl);
DataView dv = new DataView(dtbl);
dv.RowFilter = "Month like '%" + cbx_month.Text + "%' ";
dgv_get_histry.DataSource = dv;
SqlDataReader hsdr = pay_op.select_sal_histy(cbx_usernn.Text, cbx_year.Text, cbx_month.Text);
if (hsdr.Read())
{
lbl_tot_sal.Text = hsdr["Total_Salary"].ToString();
lbl_reced_sal.Text = hsdr["Received_Salary"].ToString();
lbl_rest.Text = hsdr["Rest_Salary"].ToString();
lbl_adition_reced.Text = hsdr["Additional_Received"].ToString();
}
if (cbx_year.Text == DB_yer && cbx_month.Text == DB_mon)
{
lbl_tot_sal.Text = "N/A";
lbl_reced_sal.Text = "N/A";
lbl_rest.Text = "N/A";
lbl_adition_reced.Text = "N/A";
}
}
else
{
if (cbx_usernn.Text == "")
{
errorProvider_Unme.SetError(cbx_usernn, "Plese Select Uesr Name");
}
if (cbx_year.Text == "")
{
errorProvider_yer.SetError(cbx_year, "Plese Select Year");
}
if (cbx_month.Text == "")
{
errorProvider_mon.SetError(cbx_month, "Plese Select Month");
}
}
}
private void btnCreateAccount_Click(object sender, EventArgs e)
{
alrady = false;
errorProvider_fnme.SetError(txt_FirstName, "");
errorProvider_lnme.SetError(txt_LastName, "");
errorProvider_add1.SetError(txt_AddLine1, "");
errorProvider_add2.SetError(txt_AddLine2, "");
errorProvider_mob.SetError(txt_Mobile, "");
errorProvider_pass.SetError(txtPassword, "");
errorProvider_conform.SetError(txtConfirmPassword, "");
errorProvider_ans.SetError(txt_sec_answer, "");
errorProvider_qus.SetError(cbx_security_q, "");
errorProvider_utype.SetError(cbxUserType, "");
errorProvider_unme.SetError(txtUserName, "");
errorProvider_email.SetError(txt_Email, "");
errorProvider_nic.SetError(txt_NIC, "");
if (txt_FirstName.Text != "" && txt_LastName.Text != "" && txt_Mobile.Text != "" && txt_AddLine1.Text != "" && txt_AddLine2.Text != "" && txtUserName.Text != "" && cbxUserType.Text != "" && cbx_security_q.Text != "" && txt_sec_answer.Text != "" && txt_NIC.Text != "" && txt_Email.Text != "")
{
if (reg_email.IsMatch(txt_Email.Text) && reg_NIC.IsMatch(txt_NIC.Text))
{
String iisql = "SELECT User_Name FROM tbl_UserAccount";
SqlDataAdapter iiget = new SqlDataAdapter(iisql, ConnectionDB.Connection());
DataTable iins = new DataTable();
iiget.Fill(iins);
for (int ii = 0; ii < iins.Rows.Count; ii++)
{
string uun = iins.Rows[ii]["User_Name"].ToString();
if (uun == txtUserName.Text)
{
alrady = true;
}
}
String oiisql = "SELECT User_Name FROM tbl_Admin_Accounts";
SqlDataAdapter oiiget = new SqlDataAdapter(oiisql, ConnectionDB.Connection());
DataTable oiins = new DataTable();
oiiget.Fill(oiins);
for (int oii = 0; oii < oiins.Rows.Count; oii++)
{
string ouun = oiins.Rows[oii]["User_Name"].ToString();
if (ouun == txtUserName.Text)
{
alrady = true;
}
}
if (alrady == false)
{
if (txtPassword.Text == txtConfirmPassword.Text)
{
if (checkBoxPolicy.Checked == true)
{
try
{
//__________________________________________________________________________________________________________________________________________________________________
DB_Op.insert(txt_FirstName.Text, txt_LastName.Text, txt_NIC.Text, txt_Mobile.Text, txt_AddLine1.Text, txt_AddLine2.Text, txt_Email.Text, DateTime.Now.ToString(), cbxUserType.Text, txtUserName.Text, txtPassword.Text, txtConfirmPassword.Text, cbx_security_q.Text, txt_sec_answer.Text);
//_______________________set sal and target____________________________________________________________________________________________________________________
DB_Op.set_sal_tgt(txtUserName.Text, m_sal, m_targt);
//____________________________________________________________________________________________________________________________________________________________
//_______________________Sat sal Balance______________________________________________________________________________________________________________________
pay_op.Insert_sal_blnce(txtUserName.Text, 0, 0);
//______________________________________________________________________________________________________________________________________________________________
if (MessageBox.Show("Account Created Sussesful.", "Sharp Creations", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
this.Close();
}
//__________________________________________________________________________________________________________________________________________________________________
}
catch (Exception) { }
}
else
{
toolTip_pas.Show("Plese Acsept Mars Privacy Policy", checkBoxPolicy);
}
}
else
{
toolTip_pas.Show("Password does not Match", txtConfirmPassword, 1000);
}
}
else
{
toolTip_unm.Show("User name alrady exits", txtUserName, 1000);
}
}
else
{
if (!reg_email.IsMatch(txt_Email.Text))
{
toolTip_mail.Show("Invalid Email Address", txt_Email, 1000);
}
if (!reg_NIC.IsMatch(txt_NIC.Text))
{
toolTip_Nic.Show("NIC Number is not correct format", txt_NIC, 1000);
}
}
}
else
{
if (txt_FirstName.Text == "")
{
errorProvider_fnme.SetError(txt_FirstName, "Enter First Name");
}
if (txt_LastName.Text == "")
{
errorProvider_lnme.SetError(txt_LastName, "Enter Last Name");
}
if (txt_AddLine1.Text == "")
{
errorProvider_add1.SetError(txt_AddLine1, "Enter Address line 1");
}
if (txt_AddLine2.Text == "")
{
errorProvider_add2.SetError(txt_AddLine2, "Enter Address line 2");
}
if (txt_Mobile.Text == "")
{
errorProvider_mob.SetError(txt_Mobile, "Enter Mobile");
}
if (txtPassword.Text == "")
{
errorProvider_pass.SetError(txtPassword, "Enter Passward");
}
if (txtConfirmPassword.Text == "")
{
errorProvider_conform.SetError(txtConfirmPassword, "Conform passward");
}
if (txt_sec_answer.Text == "")
{
errorProvider_ans.SetError(txt_sec_answer, "Enter Awnser");
}
if (cbx_security_q.Text == "")
{
errorProvider_qus.SetError(cbx_security_q, "Enter Question");
}
if (cbxUserType.Text == "")
{
errorProvider_utype.SetError(cbxUserType, "Select user type");
}
if (txtUserName.Text == "")
{
errorProvider_unme.SetError(txtUserName, "Enter User Name");
}
if (txt_Email.Text == "")
{
errorProvider_email.SetError(txt_Email, "Enter Email");
}
if (txt_NIC.Text == "")
{
errorProvider_nic.SetError(txt_NIC, "Enter NIC Number");
}
}
}
// 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);
}
private void cbx_usernn_SelectedIndexChanged(object sender, EventArgs e)
{
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 usdr = pay_op.select_User_Acc(cbx_usernn.Text);
if (usdr.Read())
{
lbl_fulnm.Text = usdr["First_Name"].ToString() + " " + usdr["Last_Name"].ToString() + " , " + usdr["Address_Line1"].ToString() + " " + usdr["Address_Line2"].ToString();;
}
SqlDataReader htydr = pay_op.select_sal_tgt(cbx_usernn.Text);
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(cbx_usernn.Text);
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='" + cbx_usernn.Text + "'";
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(cbx_usernn.Text);
if (rtedr.Read())
{
tgt_rte = Convert.ToDecimal(rtedr["Target_rate"].ToString());
}
etra_sal = Math.Round((etra_com_tgt / 100) * tgt_rte, 2);
//_____________________________________________________________________________________________________________________________
//_____________________Total salary ___________________________________________________________________________________________
tot_sal = net_sal + etra_sal;
//_____________________________________________________________________________________________________________________________
//_______________Received Salary_______________________________________________________________________________________________
String siisql = "SELECT * FROM tbl_Salary_Received WHERE User_Name='" + cbx_usernn.Text + "'";
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;
}
//_____________________________________________________________________________________________________________________________
//________________________Lable Display_________________________________________________________________________________________
lbl_mon_sal.Text = mon_sal.ToString();
lbl_mon_tgt.Text = mon_tgt.ToString();
lbl_reming.Text = reminig.ToString();
lbl_arias.Text = arias.ToString();
lbl_net_sal.Text = net_sal.ToString();
lbl_com_tgt.Text = compt_tgt.ToString();
lbl_extr_com_tgt.Text = etra_com_tgt.ToString();
lbl_etra_sal.Text = etra_sal.ToString();
lbl_tot_sal.Text = tot_sal.ToString();
lbl_totsal1.Text = tot_sal.ToString();
lbl_recevd_sal.Text = recevd_sal.ToString();
lbl_sal_rest.Text = rest_sal.ToString();
lbl_aditionl_receved.Text = additionl_sal.ToString();
//_____________________________________________________________________________________________________________________________
}
private void cbx_usernn_SelectedIndexChanged(object sender, EventArgs e)
{
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 = "";
string sql = "SELECT * FROM tbl_Salary_Received WHERE Month='" + DB_mon + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, ConnectionDB.Connection());
dtbl = new DataTable();
da.Fill(dtbl);
BindingSource bnsue = new BindingSource();
bnsue.DataSource = dtbl;
dgv_get_Month.DataSource = bnsue;
da.Update(dtbl);
DataView dv = new DataView(dtbl);
dv.RowFilter = "User_Name like '%" + cbx_usernn.Text + "%' ";
dgv_get_Month.DataSource = dv;
//______________________________________________________________________________________________________________________________
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SqlDataReader htydr = pay_op.select_sal_tgt(cbx_usernn.Text);
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(cbx_usernn.Text);
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='" + cbx_usernn.Text + "'";
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(cbx_usernn.Text);
if (rtedr.Read())
{
tgt_rte = Convert.ToDecimal(rtedr["Target_rate"].ToString());
}
etra_sal = Math.Round((etra_com_tgt / 100) * tgt_rte, 2);
//_____________________________________________________________________________________________________________________________
//_____________________Total salary ___________________________________________________________________________________________
tot_sal = net_sal + etra_sal;
//_____________________________________________________________________________________________________________________________
//_______________Received Salary_______________________________________________________________________________________________
String siisql = "SELECT * FROM tbl_Salary_Received WHERE User_Name='" + cbx_usernn.Text + "'";
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;
}
//_____________________________________________________________________________________________________________________________
lbl_tot_sal.Text = tot_sal.ToString();
lbl_recevd_sal.Text = recevd_sal.ToString();
lbl_sal_rest.Text = rest_sal.ToString();
lbl_aditionl_reced.Text = additionl_sal.ToString();
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
//___________________________________________________________________________________________________________________________
}
private void Edti_Items_Load(object sender, EventArgs e)
{
lbl_itemNo.Text = itup.no;
txtAddItemBarcode.Text = itup.barcode;
txtAddItemDiscription.Text = itup.discrip;
txtAddItemItemName.Text = itup.name;
txtAddItemPurchasePrice.Text = itup.purchPiz;
txtAddItemSalesPrice.Text = itup.selsPiz;
txtAddItemSerial.Text = itup.serial;
txtAddItemTaxRate.Text = itup.tax;
cbxAddItemBrande.Text = itup.Brande;
cbxAddItemCatogory.Text = itup.catogy;
cbxAddItemItemType.Text = itup.typ;
cbxAddItemSubCatogory.Text = itup.subCatogy;
cbxAddItemSupplier.Text = itup.supp;
if (itup.wranty != "No Warranty")
{
string wrny = itup.wranty;
string[] warray = wrny.Split(' ');
string wtyNo = warray[0].ToString();
string wtyDu = warray[1].ToString();
cb_warnty.Checked = true;
cbx_wrty_number.Text = wtyNo;
cbx_wrty_duretion.Text = wtyDu;
}
else
{
cbx_wrty_number.Enabled = false;
cbx_wrty_duretion.Enabled = false;
}
String sql = "SELECT*FROM tbl_AddS_Supplier";
SqlDataAdapter get = new SqlDataAdapter(sql, ConnectionDB.Connection());
DataTable ns = new DataTable();
get.Fill(ns);
for (int i = 0; i < ns.Rows.Count; i++)
{
cbxAddItemSupplier.Items.Add(ns.Rows[i]["Business_Name"]);
}
String csql = "SELECT*FROM tbl_catogory";
SqlDataAdapter cget = new SqlDataAdapter(csql, ConnectionDB.Connection());
DataTable cdt = new DataTable();
cget.Fill(cdt);
for (int i = 0; i < cdt.Rows.Count; i++)
{
cbxAddItemCatogory.Items.Add(cdt.Rows[i]["catogory"]);
}
//String scsql = "SELECT*FROM tbl_sub_catogory";
//SqlDataAdapter scget = new SqlDataAdapter(scsql, ConnectionDB.Connection());
//DataTable scdt = new DataTable();
//scget.Fill(scdt);
//for (int i = 0; i < scdt.Rows.Count; i++)
//{
// cbxAddItemSubCatogory.Items.Add(scdt.Rows[i]["sub_catogory"]);
//}
String bsql = "SELECT*FROM tbl_brande";
SqlDataAdapter bget = new SqlDataAdapter(bsql, ConnectionDB.Connection());
DataTable bdt = new DataTable();
bget.Fill(bdt);
for (int i = 0; i < bdt.Rows.Count; i++)
{
cbxAddItemBrande.Items.Add(bdt.Rows[i]["Brande"]);
}
String tsql = "SELECT*FROM tbl_itype";
SqlDataAdapter tget = new SqlDataAdapter(tsql, ConnectionDB.Connection());
DataTable tdt = new DataTable();
tget.Fill(tdt);
for (int i = 0; i < tdt.Rows.Count; i++)
{
cbxAddItemItemType.Items.Add(tdt.Rows[i]["Item_type"]);
}
cbxAddItemCatogory.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
cbxAddItemCatogory.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbxAddItemCatogory.AutoCompleteSource = AutoCompleteSource.ListItems;
cbxAddItemBrande.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
cbxAddItemBrande.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbxAddItemBrande.AutoCompleteSource = AutoCompleteSource.ListItems;
}
private void button1_Click(object sender, EventArgs e)
{
ep_iname.SetError(txtAddItemItemName, "");
ep_isalePrz.SetError(txtAddItemSalesPrice, "");
ep_ipuchsPriz.SetError(lbl_p_piz, "");
ep_isupp.SetError(cbxAddItemSupplier, "");
ep_ictogry.SetError(cbxAddItemCatogory, "");
ep_isubCotory.SetError(cbxAddItemSubCatogory, "");
ep_ibrnd.SetError(cbxAddItemBrande, "");
tp_required.Show("", btnAddItemAddItem, 5000);
//-----------------clear all textbox.text-----------------------
Action <Control.ControlCollection> func = null;
func = (controls) =>
{
foreach (Control control in controls)
{
if (control is TextBox)
{
(control as TextBox).Clear();
}
else
{
func(control.Controls);
}
}
};
func(Controls);
cbxAddItemBrande.Text = "";
cbxAddItemCatogory.Text = "";
cbxAddItemSubCatogory.Text = "";
cbxAddItemSupplier.Text = "";
cbxAddItemItemType.Text = "";
string rNo = itemdb.Itemno();
string sql = "SELECT * FROM tbl_Add_Items WHERE Item_No='" + rNo + "'";
SqlCommand com = new SqlCommand(sql, ConnectionDB.Connection());
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
string itName = dr["Item_Name"].ToString();
string itSelspriz = dr["Sales_Price"].ToString();
string itPurpriz = dr["Purchase_Price"].ToString();
string itSupp = dr["Supplier"].ToString();
string itTax = dr["Tax_Rate"].ToString();
string itCtgry = dr["Catogory"].ToString();
string itSubctgry = dr["Sub_Catogory"].ToString();
string itBrnd = dr["Brande"].ToString();
string itType = dr["Item_Type"].ToString();
string itDiscp = dr["Discription"].ToString();
if (dr["Warranty"].ToString() != "No Warranty")
{
string wrny = dr["Warranty"].ToString();
string[] warray = wrny.Split(' ');
string wtyNo = warray[0].ToString();
string wtyDu = warray[1].ToString();
cbx_wrty_number.Text = "";
cbx_wrty_duretion.Text = "";
cb_warnty.Checked = true;
cbx_wrty_number.Text = wtyNo;
cbx_wrty_duretion.Text = wtyDu;
}
else
{
cbx_wrty_number.Enabled = false;
cbx_wrty_duretion.Enabled = false;
cb_warnty.Checked = false;
}
txtAddItemItemName.Text = itName;
txtAddItemSalesPrice.Text = itSelspriz;
lbl_p_piz.Text = itPurpriz;
txtAddItemTaxRate.Text = itTax;
txtAddItemDiscription.Text = itDiscp;
cbxAddItemBrande.Text = itBrnd;
cbxAddItemCatogory.Text = itCtgry;
cbxAddItemSubCatogory.Text = itSubctgry;
cbxAddItemSupplier.Text = itSupp;
cbxAddItemItemType.Text = itType;
}
txtAddItemBarcode.Focus();
}
private void button1_Click(object sender, EventArgs e)
{
if (cbx_usernn.Text != "" && txt_getSal.Text != "")
{
try
{
pay_op.Insert_Received_Salary(cbx_usernn.Text, Convert.ToDecimal(txt_getSal.Text), DateTime.Now, now_yer, now_mon);
MessageBox.Show("\"" + cbx_usernn.Text + "\" Received \"Rs." + txt_getSal.Text + "\"" + " Sucessfully", "Sharp Creation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception) { }
DataSet rds = pay_op.user_receved_sal(cbx_usernn.Text, now_yer, now_mon);
dgv_get_Month.DataSource = rds.Tables["tbl_Salary_Received"];
//______________________________________________________________________________________________________________________________
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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(cbx_usernn.Text);
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(cbx_usernn.Text);
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='" + cbx_usernn.Text + "'";
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(cbx_usernn.Text);
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='" + cbx_usernn.Text + "'";
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;
}
//_____________________________________________________________________________________________________________________________
lbl_tot_sal.Text = tot_sal.ToString();
lbl_recevd_sal.Text = recevd_sal.ToString();
lbl_sal_rest.Text = rest_sal.ToString();
lbl_aditionl_reced.Text = additionl_sal.ToString();
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
//___________________________________________________________________________________________________________________________
txt_getSal.Clear();
}
else
{
if (cbx_usernn.Text == "")
{
toolTip1.Show("Select User name", cbx_usernn, 1000);
}
if (txt_getSal.Text == "")
{
toolTip2.Show("Enter Value", txt_getSal, 1000);
}
}
}
private void Add_Items_Load(object sender, EventArgs e)
{
tx_brcde = txtAddItemBarcode;
//==================================================From Item Table==========================================================//
string rNo = itemdb.Itemno();
if (rNo.Equals("") || rNo == null)
{
iNo = 001000;
}
else
{
iNo = Convert.ToInt32(rNo);
iNo = iNo + 1;
//MessageBox.Show(iNo.ToString());
}
//==============================================================================================================================//
string rcNo = itemdb.getCusno();
if (rcNo.Equals("") || rcNo == null)
{
cNo = 001000;
}
else
{
cNo = Convert.ToInt32(rcNo);
cNo = cNo + 1;
//MessageBox.Show(cNo.ToString());
}
int[] numbers = new[] { iNo, cNo };
int max = numbers.Max();
lbl_itemNo.Text = Convert.ToString(max);
String sql = "SELECT*FROM tbl_AddS_Supplier";
SqlDataAdapter get = new SqlDataAdapter(sql, ConnectionDB.Connection());
DataTable ns = new DataTable();
get.Fill(ns);
for (int i = 0; i < ns.Rows.Count; i++)
{
cbxAddItemSupplier.Items.Add(ns.Rows[i]["Business_Name"]);
}
String csql = "SELECT*FROM tbl_catogory";
SqlDataAdapter cget = new SqlDataAdapter(csql, ConnectionDB.Connection());
DataTable cdt = new DataTable();
cget.Fill(cdt);
for (int i = 0; i < cdt.Rows.Count; i++)
{
cbxAddItemCatogory.Items.Add(cdt.Rows[i]["catogory"]);
}
//String scsql = "SELECT*FROM tbl_sub_catogory";
//SqlDataAdapter scget = new SqlDataAdapter(scsql, ConnectionDB.Connection());
//DataTable scdt = new DataTable();
//scget.Fill(scdt);
//for (int i = 0; i < scdt.Rows.Count; i++)
//{
// cbxAddItemSubCatogory.Items.Add(scdt.Rows[i]["sub_catogory"]);
//}
String bsql = "SELECT*FROM tbl_brande";
SqlDataAdapter bget = new SqlDataAdapter(bsql, ConnectionDB.Connection());
DataTable bdt = new DataTable();
bget.Fill(bdt);
for (int i = 0; i < bdt.Rows.Count; i++)
{
cbxAddItemBrande.Items.Add(bdt.Rows[i]["Brande"]);
}
String tsql = "SELECT*FROM tbl_itype";
SqlDataAdapter tget = new SqlDataAdapter(tsql, ConnectionDB.Connection());
DataTable tdt = new DataTable();
tget.Fill(tdt);
for (int i = 0; i < tdt.Rows.Count; i++)
{
cbxAddItemItemType.Items.Add(tdt.Rows[i]["Item_type"]);
}
tp_ad_details.Show("Add Catogaty, Subcatogary, Brande, Type", btn_add_details, 5000);
cbxAddItemCatogory.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
cbxAddItemCatogory.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbxAddItemCatogory.AutoCompleteSource = AutoCompleteSource.ListItems;
cbxAddItemBrande.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
cbxAddItemBrande.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbxAddItemBrande.AutoCompleteSource = AutoCompleteSource.ListItems;
}
private void txt_Search_TextChanged(object sender, EventArgs e)
{
chose = cbx_choose.SelectedItem.ToString();
if (chose == "Catogory")
{
string sql = "SELECT * FROM tbl_catogory";
SqlDataAdapter da = new SqlDataAdapter(sql, ConnectionDB.Connection());
dtbl = new DataTable();
da.Fill(dtbl);
BindingSource bnsue = new BindingSource();
bnsue.DataSource = dtbl;
dgv_item_details.DataSource = bnsue;
da.Update(dtbl);
DataView dv = new DataView(dtbl);
dv.RowFilter = "catogory like '%" + txt_Search.Text + "%' ";
dgv_item_details.DataSource = dv;
}
if (chose == "Sub catogory")
{
string sql = "SELECT * FROM tbl_sub_catogory";
SqlDataAdapter da = new SqlDataAdapter(sql, ConnectionDB.Connection());
dtbl = new DataTable();
da.Fill(dtbl);
BindingSource bnsue = new BindingSource();
bnsue.DataSource = dtbl;
dgv_item_details.DataSource = bnsue;
da.Update(dtbl);
DataView dv = new DataView(dtbl);
dv.RowFilter = "sub_catogory like '%" + txt_Search.Text + "%' ";
dgv_item_details.DataSource = dv;
}
if (chose == "Brande")
{
string sql = "SELECT * FROM tbl_brande";
SqlDataAdapter da = new SqlDataAdapter(sql, ConnectionDB.Connection());
dtbl = new DataTable();
da.Fill(dtbl);
BindingSource bnsue = new BindingSource();
bnsue.DataSource = dtbl;
dgv_item_details.DataSource = bnsue;
da.Update(dtbl);
DataView dv = new DataView(dtbl);
dv.RowFilter = "Brande like '%" + txt_Search.Text + "%' ";
dgv_item_details.DataSource = dv;
}
if (chose == "Item type")
{
string sql = "SELECT * FROM tbl_itype";
SqlDataAdapter da = new SqlDataAdapter(sql, ConnectionDB.Connection());
dtbl = new DataTable();
da.Fill(dtbl);
BindingSource bnsue = new BindingSource();
bnsue.DataSource = dtbl;
dgv_item_details.DataSource = bnsue;
da.Update(dtbl);
DataView dv = new DataView(dtbl);
dv.RowFilter = "Item_type like '%" + txt_Search.Text + "%' ";
dgv_item_details.DataSource = dv;
}
}
private void btn_print_Click(object sender, EventArgs e)
{
try
{
invoNo = dgv_Invoice.CurrentRow.Cells["Invoice_No"].Value.ToString();
SqlDataReader iddr = Invo.select_invoNo(invoNo);
if (iddr.Read())
{
invodate = Convert.ToDateTime(iddr["Invoice_Date"].ToString());
total = iddr["Total_Price"].ToString();
paid = iddr["Paid_Price"].ToString();
blnc = iddr["Balance"].ToString();
cusnom = iddr["Coustomer_No"].ToString();
paymethd = iddr["Payment_Method"].ToString();
grantota = iddr["Grande_total"].ToString();
disc = iddr["Discount"].ToString();
tax = iddr["Tax"].ToString();
}
SqlDataReader drcus = Invo.select_incus(cusnom);
if (drcus.Read())
{
fname = drcus["First_Name"].ToString();
lnme = drcus["Last_Name"].ToString();
add1 = drcus["Address_Line1"].ToString();
add2 = drcus["Address_Line2"].ToString();
mobl = drcus["Mobile"].ToString();
}
else
{
fname = "N/A";
lnme = "N/A";
add1 = "N/A";
add2 = "N/A";
mobl = "N/A";
}
String ibsql = "SELECT*FROM tbl_Invoice_details WHERE Invoice_No='" + invoNo + "'";
SqlDataAdapter ibget = new SqlDataAdapter(ibsql, ConnectionDB.Connection());
DataTable ibns = new DataTable();
ibget.Fill(ibns);
for (int ib = 0; ib < ibns.Rows.Count; ib++)
{
itmno = ibns.Rows[ib]["Item_No"].ToString();
itmNme = ibns.Rows[ib]["Item_Name"].ToString();
itmseril = ibns.Rows[ib]["Serial_No"].ToString();
itsalepriz = ibns.Rows[ib]["Sales_Price"].ToString();
itmctgy = ibns.Rows[ib]["Catogory"].ToString();
itmsbctgy = ibns.Rows[ib]["Sub_Catogory"].ToString();
itmbrnd = ibns.Rows[ib]["Brande"].ToString();
itmwarrty = ibns.Rows[ib]["Warranty"].ToString();
iqty = ibns.Rows[ib]["Quntity"].ToString();
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ check- is bill table Null...? ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++//
String emty_ibl = "SELECT*FROM tbl_Invoice_bill";
SqlDataAdapter iigemty_bil = new SqlDataAdapter(emty_ibl, ConnectionDB.Connection());
DataTable iemty_bil = new DataTable();
iigemty_bil.Fill(iemty_bil);
if (0 != iemty_bil.Rows.Count) // does not exist
{
//___________________________________________________________________________________________________________________________
SqlDataReader slct_billDR = Invo.select_invtmp_bil(itmctgy, itmsbctgy, itmbrnd);
if (slct_billDR.Read())
{
string bsril, bqtyy, u_piz; decimal n_qty;
bsril = slct_billDR["Serial_No"].ToString();
bqtyy = slct_billDR["Quantity"].ToString();
u_piz = slct_billDR["Unit_Price"].ToString();
n_qty = Convert.ToDecimal(bqtyy) + Convert.ToDecimal(iqty);
Invo.Updte_invc_bill(itmctgy, itmsbctgy, itmbrnd, n_qty, (Convert.ToDecimal(u_piz) * n_qty), bsril + "," + itmseril);
//MessageBox.Show("update_Dtail");
}
else
{
try
{
Invo.insert_Invoice_Bill(invoNo, invodate, fname + " " + lnme, add1 + " " + add2, mobl, Convert.ToDecimal(grantota), Convert.ToDecimal(disc), Convert.ToDecimal(tax), Convert.ToDecimal(total), Convert.ToDecimal(paid), paymethd, Convert.ToDecimal(blnc), itmseril, itmctgy, itmsbctgy, itmbrnd, itmbrnd + " " + itmNme + " " + itmctgy + " " + itmsbctgy + " \nWarranty- " + itmwarrty, Convert.ToDecimal(Convert.ToDecimal(itsalepriz) / Convert.ToDecimal(iqty)), Convert.ToDecimal(iqty), Convert.ToDecimal(itsalepriz));
//MessageBox.Show("Invoice bill add");
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
//___________________________________________________________________________________________________________________________
}
else
{
try
{
Invo.insert_Invoice_Bill(invoNo, invodate, fname + " " + lnme, add1 + " " + add2, mobl, Convert.ToDecimal(grantota), Convert.ToDecimal(disc), Convert.ToDecimal(tax), Convert.ToDecimal(total), Convert.ToDecimal(paid), paymethd, Convert.ToDecimal(blnc), itmseril, itmctgy, itmsbctgy, itmbrnd, itmbrnd + " " + itmNme + " " + itmctgy + " " + itmsbctgy + " \nWarranty- " + itmwarrty, Convert.ToDecimal(Convert.ToDecimal(itsalepriz) / Convert.ToDecimal(iqty)), Convert.ToDecimal(iqty), Convert.ToDecimal(itsalepriz));
//MessageBox.Show("Invoice bill add");
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
}
Bill invoBil = new Bill();
invoBil.Show();
}
catch (Exception) { }
// else { toolTip_Invoice.Show("Plese Select Invoice For Print", dgv_Invoice, 1500); }
}
private void warranty_newItem_Load(object sender, EventArgs e)
{
//-------------------------------------------Auto Invoice Number--------------------------------------------------------//
string rNo = Invo.InvoiceNo();
if (rNo.Equals("") || rNo == null)
{
iNo = 001000;
}
else
{
iNo = Convert.ToInt32(rNo);
iNo = iNo + 1;
}
//---------------------------------------------Auto Itm No------------------------------------------------------------------------//
string riNo = itemdb.Itemno();
if (riNo.Equals("") || riNo == null)
{
iiNo = 001000;
}
else
{
iiNo = Convert.ToInt32(rNo);
iiNo = iiNo + 1;
//MessageBox.Show(iiNo.ToString());
}
string rcNo = itemdb.getCusno();
if (rcNo.Equals("") || rcNo == null)
{
cNo = 001000;
}
else
{
cNo = Convert.ToInt32(rcNo);
cNo = cNo + 1;
// MessageBox.Show(cNo.ToString());
}
int[] numbers = new[] { iiNo, cNo };
int max = numbers.Max();
lbl_itNo.Text = max.ToString();
//---------------------------------------------------------------------------------------------------------------------//
String sql = "SELECT*FROM tbl_brande";
SqlDataAdapter get = new SqlDataAdapter(sql, ConnectionDB.Connection());
DataTable ns = new DataTable();
get.Fill(ns);
for (int i = 0; i < ns.Rows.Count; i++)
{
cbxAddItemBrande.Items.Add(ns.Rows[i]["Brande"]);
}
String csql = "SELECT*FROM tbl_catogory";
SqlDataAdapter cget = new SqlDataAdapter(csql, ConnectionDB.Connection());
DataTable cdt = new DataTable();
cget.Fill(cdt);
for (int i = 0; i < cdt.Rows.Count; i++)
{
cbxAddItemCatogory.Items.Add(cdt.Rows[i]["catogory"]);
}
String tsql = "SELECT*FROM tbl_itype";
SqlDataAdapter tget = new SqlDataAdapter(tsql, ConnectionDB.Connection());
DataTable tdt = new DataTable();
tget.Fill(tdt);
for (int i = 0; i < tdt.Rows.Count; i++)
{
cbxAddItemItemType.Items.Add(tdt.Rows[i]["Item_type"]);
}
cbxAddItemCatogory.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
cbxAddItemCatogory.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbxAddItemCatogory.AutoCompleteSource = AutoCompleteSource.ListItems;
cbxAddItemBrande.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
cbxAddItemBrande.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbxAddItemBrande.AutoCompleteSource = AutoCompleteSource.ListItems;
}
private void btn_chnge_Click(object sender, EventArgs e)
{
errorProvider2.SetError(txt_paid, "");
errorProvider3.SetError(txt_balnce, "");
errorProvider1.SetError(cbx_payMethord, "");
//-------------------------------------------Auto Invoice Number--------------------------------------------------------//
string rNo = Invo.InvoiceNo();
if (rNo.Equals("") || rNo == null)
{
iNo = 001000;
}
else
{
iNo = Convert.ToInt32(rNo);
iNo = iNo + 1;
}
//MessageBox.Show(iNo.ToString());
//---------------------------------------------------------------------------------------------------------------------//
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++check tablen is Null++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++//
String emty = "SELECT*FROM tbl_Invoice_Item";
SqlDataAdapter iigemty = new SqlDataAdapter(emty, ConnectionDB.Connection());
DataTable iemty = new DataTable();
iigemty.Fill(iemty);
if (0 != iemty.Rows.Count) // does not exist
{
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++//
if (cbx_payMethord.Text != "" && txt_paid.Text != "")
{
if (txt_balnce.Text != "Invalaid payment..!")
{
SqlDataReader cdr = wrty.select_cusNo(Warranty_Details.dgvw.CurrentRow.Cells["Invoice_No"].Value.ToString());
if (cdr.Read())
{
ccno = cdr["Coustomer_No"].ToString();
InvDt = Convert.ToDateTime(cdr["Invoice_Date"]);
}
//====================================================================================================================================//
String iisql = "SELECT*FROM tbl_Invoice_Item";
SqlDataAdapter iiget = new SqlDataAdapter(iisql, ConnectionDB.Connection());
DataTable iins = new DataTable();
iiget.Fill(iins);
for (int ii = 0; ii < iins.Rows.Count; ii++)
{
inom = iins.Rows[ii]["Item_No"].ToString();
inme = iins.Rows[ii]["Item_Name"].ToString();
iserial = iins.Rows[ii]["Serial_No"].ToString();
iselpiz = iins.Rows[ii]["Sales_Price"].ToString();
ipurpiz = iins.Rows[ii]["Purchase_Price"].ToString();
ictgry = iins.Rows[ii]["Catogory"].ToString();
isubctgry = iins.Rows[ii]["Sub_Catogory"].ToString();
ibrnd = iins.Rows[ii]["Brande"].ToString();
ibcode = iins.Rows[ii]["Barcode"].ToString();
iwrrty = iins.Rows[ii]["Warranty"].ToString();
isuppl = iins.Rows[ii]["Supplier"].ToString();
itpe = iins.Rows[ii]["Item_Type"].ToString();
descri = iins.Rows[ii]["Discription"].ToString();
decimal pfit = (Convert.ToDecimal(iselpiz)) - (Convert.ToDecimal(ipurpiz));
try
{
Invo.insert_Invoice_detalis(iNo.ToString(), InvDt, inom, iserial, inme, Convert.ToDecimal(iselpiz), Convert.ToDecimal(ipurpiz), ibcode, ictgry, isubctgry, ibrnd, iwrrty, isuppl, itpe, descri, pfit, "Ok", "1");
// MessageBox.Show("new itttttttttmss changgggg");
wrty.addWary_foundItm(Warranty_Details.dgvw.CurrentRow.Cells["Warranty_No"].Value.ToString(), Warranty_Details.dgvw.CurrentRow.Cells["Invoice_No"].Value.ToString(), inom, inme, iserial, ibcode, ictgry, isubctgry, ibrnd, itpe, descri);
//MessageBox.Show("warranty found item");
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
//===================================================================================================================================//
//-----------------------------------------------for description-------------------------------------------------------------//
String sql = "SELECT DISTINCT Catogory FROM tbl_Invoice_Item";
SqlDataAdapter get = new SqlDataAdapter(sql, ConnectionDB.Connection());
DataTable ns = new DataTable();
get.Fill(ns);
for (int i = 0; i < ns.Rows.Count; i++)
{
iqqqty = 0;
icty = ns.Rows[i]["Catogory"].ToString();
String idsql = "SELECT Quntity FROM tbl_Invoice_Item WHERE Catogory='" + icty + "'";
SqlDataAdapter idget = new SqlDataAdapter(idsql, ConnectionDB.Connection());
DataTable idns = new DataTable();
idget.Fill(idns);
for (int idi = 0; idi < idns.Rows.Count; idi++)
{
decimal qttt = Convert.ToDecimal(idns.Rows[idi]["Quntity"].ToString());
iqqqty += qttt;
}
ides += icty + iqqqty.ToString() + " ";
}
//---------------------------------------------------------------------------------------------------------------------------//
//===============================================================================================================================//
if (txt_balnce.Text == "0.00")
{
pymnt = "Ok";
}
else
{
pymnt = "Not Complete";
}
//================================================================================================================================//
try
{
Invo.insert_Invoice(iNo.ToString(), InvDt, Convert.ToDecimal(txt_Total.Text), (Convert.ToDecimal(txt_paid.Text)) + (Convert.ToDecimal(lbl_CurrentMoney.Text)), Convert.ToDecimal(txt_balnce.Text), cbx_payMethord.Text, ides, New_invoice.sref.Text, ccno, Convert.ToDecimal(txt_granTotal.Text), Convert.ToDecimal(txt_discount.Text), Convert.ToDecimal(txt_tax.Text), pymnt);
// MessageBox.Show("ADd new invo");
wrty.update_item_status(Warranty_Details.dgvw.CurrentRow.Cells["Invoice_No"].Value.ToString(), Warranty_Details.dgvw.CurrentRow.Cells["Item_No"].Value.ToString(), "Return");
// MessageBox.Show("update oled invo");
}
catch (Exception eee)
{
MessageBox.Show(eee.Message);
}
//--------------------------------------------------Remove Invoiced items From tbl_Add_Items Table---------------------------------//
String dsql = "SELECT*FROM tbl_Invoice_Item";
SqlDataAdapter dget = new SqlDataAdapter(dsql, ConnectionDB.Connection());
DataTable dns = new DataTable();
dget.Fill(dns);
for (int di = 0; di < dns.Rows.Count; di++)
{
SqlDataReader drm = itemdb.select_to_Qntity(dns.Rows[di]["Catogory"].ToString(), dns.Rows[di]["Sub_Catogory"].ToString(), dns.Rows[di]["Brande"].ToString());
if (drm.Read())
{
string qqt = drm["Quntity"].ToString();
int qq1 = int.Parse(qqt);
int qq2 = qq1 - 1;
string qty = qq2.ToString();
itemdb.update_Quntity(qty, dns.Rows[di]["Catogory"].ToString(), dns.Rows[di]["Sub_Catogory"].ToString(), dns.Rows[di]["Brande"].ToString());
itemdb.delete_item(dns.Rows[di]["Item_No"].ToString());
// MessageBox.Show("Quntity Updated");
}
}
//---------------------------------------------------------------------------------------------------------------------------------//
//========================================Add old item to return_item table & qty updated================================================//
try
{
SqlDataReader bdr = wrty.select_invo_backI(Warranty_Details.dgvw.CurrentRow.Cells["Item_No"].Value.ToString(), Warranty_Details.dgvw.CurrentRow.Cells["Invoice_No"].Value.ToString());
if (bdr.Read())
{
iinme = bdr["Item_Name"].ToString();
iiserial = bdr["Serial_No"].ToString();
iiselpiz = bdr["Sales_Price"].ToString();
iipurpiz = bdr["Purchase_Price"].ToString();
iictgry = bdr["Catogory"].ToString();
iisubctgry = bdr["Sub_Catogory"].ToString();
iibrnd = bdr["Brande"].ToString();
iibcode = bdr["Barcode"].ToString();
iiwrrty = bdr["Warranty"].ToString();
iisuppl = bdr["Supplier"].ToString();
iitpe = bdr["Item_Type"].ToString();
iidescri = bdr["Discription"].ToString();
//////
wrty.insert_retn_itm(Warranty_Details.dgvw.CurrentRow.Cells["Item_No"].Value.ToString(), iiserial, iinme, Convert.ToDecimal(iiselpiz), Convert.ToDecimal(iipurpiz), Convert.ToDecimal("0"), iibcode, iictgry, iisubctgry, iibrnd, iitpe, iisuppl, iiwrrty, iidescri);
// MessageBox.Show("add to return item");
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
//=========================================================================================================================================//
wty_dtail_inconplete.newItm = true;
if (MessageBox.Show("Retun By Stock Item", "Sharp Creation", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
if (cb_printi.Checked == true)
{
//==========================================================================================================================
SqlDataReader ziddr = Invo.select_invoNo(iNo.ToString());
if (ziddr.Read())
{
invodate = Convert.ToDateTime(ziddr["Invoice_Date"].ToString());
total = ziddr["Total_Price"].ToString();
paid = ziddr["Paid_Price"].ToString();
blnc = ziddr["Balance"].ToString();
cusnom = ziddr["Coustomer_No"].ToString();
paymethd = ziddr["Payment_Method"].ToString();
grantota = ziddr["Grande_total"].ToString();
disc = ziddr["Discount"].ToString();
tax = ziddr["Tax"].ToString();
}
SqlDataReader zdrcus = Invo.select_incus(cusnom);
if (zdrcus.Read())
{
fname = zdrcus["First_Name"].ToString();
lnme = zdrcus["Last_Name"].ToString();
add1 = zdrcus["Address_Line1"].ToString();
add2 = zdrcus["Address_Line2"].ToString();
mobl = zdrcus["Mobile"].ToString();
}
else
{
fname = "N/A";
lnme = "N/A";
add1 = "N/A";
add2 = "N/A";
mobl = "N/A";
}
String ibsql = "SELECT*FROM tbl_Invoice_details WHERE Invoice_No='" + iNo + "'";
SqlDataAdapter ibget = new SqlDataAdapter(ibsql, ConnectionDB.Connection());
DataTable ibns = new DataTable();
ibget.Fill(ibns);
for (int ib = 0; ib < ibns.Rows.Count; ib++)
{
itmno = ibns.Rows[ib]["Item_No"].ToString();
itmNme = ibns.Rows[ib]["Item_Name"].ToString();
itmseril = ibns.Rows[ib]["Serial_No"].ToString();
itsalepriz = ibns.Rows[ib]["Sales_Price"].ToString();
itmctgy = ibns.Rows[ib]["Catogory"].ToString();
itmsbctgy = ibns.Rows[ib]["Sub_Catogory"].ToString();
itmbrnd = ibns.Rows[ib]["Brande"].ToString();
itmwarrty = ibns.Rows[ib]["Warranty"].ToString();
iqty = ibns.Rows[ib]["Quntity"].ToString();
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ check- is bill table Null...? ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++//
String emty_ibl = "SELECT*FROM tbl_Invoice_bill";
SqlDataAdapter iigemty_bil = new SqlDataAdapter(emty_ibl, ConnectionDB.Connection());
DataTable iemty_bil = new DataTable();
iigemty_bil.Fill(iemty_bil);
if (0 != iemty_bil.Rows.Count) // does not exist
{
//___________________________________________________________________________________________________________________________
SqlDataReader slct_billDR = Invo.select_invtmp_bil(itmctgy, itmsbctgy, itmbrnd);
if (slct_billDR.Read())
{
string bsril, bqtyy, u_piz; decimal n_qty;
bsril = slct_billDR["Serial_No"].ToString();
bqtyy = slct_billDR["Quantity"].ToString();
u_piz = slct_billDR["Unit_Price"].ToString();
n_qty = Convert.ToDecimal(bqtyy) + Convert.ToDecimal(iqty);
Invo.Updte_invc_bill(itmctgy, itmsbctgy, itmbrnd, n_qty, (Convert.ToDecimal(u_piz) * n_qty), bsril + "," + itmseril);
//MessageBox.Show("update_Dtail");
}
else
{
try
{
Invo.insert_Invoice_Bill(iNo.ToString(), invodate, fname + " " + lnme, add1 + " " + add2, mobl, Convert.ToDecimal(grantota), Convert.ToDecimal(disc), Convert.ToDecimal(tax), Convert.ToDecimal(total), Convert.ToDecimal(paid), paymethd, Convert.ToDecimal(blnc), itmseril, itmctgy, itmsbctgy, itmbrnd, itmbrnd + " " + itmNme + " " + itmctgy + " " + itmsbctgy + " \nWarranty- " + itmwarrty, Convert.ToDecimal(Convert.ToDecimal(itsalepriz) / Convert.ToDecimal(iqty)), Convert.ToDecimal(iqty), Convert.ToDecimal(itsalepriz));
//MessageBox.Show("Invoice bill add");
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
//___________________________________________________________________________________________________________________________
}
else
{
try
{
Invo.insert_Invoice_Bill(iNo.ToString(), invodate, fname + " " + lnme, add1 + " " + add2, mobl, Convert.ToDecimal(grantota), Convert.ToDecimal(disc), Convert.ToDecimal(tax), Convert.ToDecimal(total), Convert.ToDecimal(paid), paymethd, Convert.ToDecimal(blnc), itmseril, itmctgy, itmsbctgy, itmbrnd, itmbrnd + " " + itmNme + " " + itmctgy + " " + itmsbctgy + " \nWarranty- " + itmwarrty, Convert.ToDecimal(Convert.ToDecimal(itsalepriz) / Convert.ToDecimal(iqty)), Convert.ToDecimal(iqty), Convert.ToDecimal(itsalepriz));
//MessageBox.Show("Invoice bill add");
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
}
Bill invoBil = new Bill();
invoBil.ShowDialog();
//============================================================================================================================
//============================================================================================================================
}
btn_warrtySave = true;
wty_dtail_inconplete.bt_save = true;
this.Close();
}
//=========================================================================================================================================//
}
else
{
errorProvider2.SetError(txt_paid, "Invalid payment");
errorProvider3.SetError(txt_balnce, "Invalid payment");
}
}
else
{
if (cbx_payMethord.Text == "")
{
errorProvider1.SetError(cbx_payMethord, "Complete warranty");
}
if (txt_paid.Text == "")
{
toolTipselect.Show("No Payment Enter", txt_paid, 1000);
}
}
}
else
{
toolTipselect.Show("Select items to Change", button_SearchItem, 0, 75, 2500);
}
}
private void Edit_Receive_Stock_Load(object sender, EventArgs e)
{
//--------------------------------Supplier_Account Close-----------------------------------//
for (int index = Application.OpenForms.Count - 1; index >= 0; index--)
{
if (Application.OpenForms[1].Name == "Supplier_Account")
{
Application.OpenForms[1].Close();
}
}
//---------------------------------------------------------------------------------//
lbl_s_no.Text = supA.stNo;
dtp_AccUp.Text = supA.stDate;
txtDiscription.Text = supA.st_descrip;
txtPurchasePrice.Text = supA.purchPriz;
lbl_totPaid.Text = supA.paid;
txt_paid.Text = supA.paid;
cbx_supp.Text = supA.stSup;
cbx_pymetd.Text = supA.payMethd;
txt_inme.Text = supA.nme;
cbx_qty_ctgy.Text = supA.catgy;
cbx_qty_S_ctgy.Text = supA.subcgy;
cbx_qty_Brand.Text = supA.brand;
cbx_itmtype.Text = supA.itype;
txt_u_p_priz.Text = supA.un_piz;
txt_u_s_priz.Text = supA.un_sal;
numericUpDown1.Value = Convert.ToDecimal(supA.qqty);
String sql = "SELECT*FROM tbl_AddS_Supplier";
SqlDataAdapter get = new SqlDataAdapter(sql, ConnectionDB.Connection());
DataTable ns = new DataTable();
get.Fill(ns);
for (int i = 0; i < ns.Rows.Count; i++)
{
cbx_supp.Items.Add(ns.Rows[i]["Business_Name"]);
}
//////////////////////////////////////////////////////////////////////////////////////
SqlDataReader dr = supOp.selectB(lbl_s_no.Text);
if (dr.Read())
{
string tot, paid, balnce;
decimal tot1, paid1, balnce1;
tot = dr["Purchase_Price"].ToString();
paid = dr["Payment"].ToString();
tot1 = decimal.Parse(tot);
paid1 = decimal.Parse(paid);
balnce1 = (tot1 - paid1);
balnce = balnce1.ToString();
lbl_old_blnc.Text = balnce;
lbl_Balance.Text = "Rs : " + balnce;
lblNew_paid.Text = "Rs : " + paid;
if (balnce1 == 0)
{
groupBox_pay.Enabled = false;
lbl_completed.Visible = true;
}
}
String csql = "SELECT*FROM tbl_catogory";
SqlDataAdapter cget = new SqlDataAdapter(csql, ConnectionDB.Connection());
DataTable cdt = new DataTable();
cget.Fill(cdt);
for (int i = 0; i < cdt.Rows.Count; i++)
{
cbx_qty_ctgy.Items.Add(cdt.Rows[i]["catogory"]);
}
//String scsql = "SELECT*FROM tbl_sub_catogory";
//SqlDataAdapter scget = new SqlDataAdapter(scsql, ConnectionDB.Connection());
//DataTable scdt = new DataTable();
//scget.Fill(scdt);
//for (int i = 0; i < scdt.Rows.Count; i++)
//{
// cbxAddItemSubCatogory.Items.Add(scdt.Rows[i]["sub_catogory"]);
//}
String bsql = "SELECT*FROM tbl_brande";
SqlDataAdapter bget = new SqlDataAdapter(bsql, ConnectionDB.Connection());
DataTable bdt = new DataTable();
bget.Fill(bdt);
for (int i = 0; i < bdt.Rows.Count; i++)
{
cbx_qty_Brand.Items.Add(bdt.Rows[i]["Brande"]);
}
String tsql = "SELECT*FROM tbl_itype";
SqlDataAdapter tget = new SqlDataAdapter(tsql, ConnectionDB.Connection());
DataTable tdt = new DataTable();
tget.Fill(tdt);
for (int i = 0; i < tdt.Rows.Count; i++)
{
cbx_itmtype.Items.Add(tdt.Rows[i]["Item_type"]);
}
}
private void btnAddItemAddItem_Click(object sender, EventArgs e)
{
ep_iname.SetError(txtAddItemItemName, "");
ep_isalePrz.SetError(txtAddItemSalesPrice, "");
ep_ipuchsPriz.SetError(txtAddItemPurchasePrice, "");
ep_isupp.SetError(cbxAddItemSupplier, "");
ep_ictogry.SetError(cbxAddItemCatogory, "");
ep_isubCotory.SetError(cbxAddItemSubCatogory, "");
ep_ibrnd.SetError(cbxAddItemBrande, "");
string warrty;
if (cb_warnty.Checked == true)
{
string wtyNo = cbx_wrty_number.Text;
string wtydu = cbx_wrty_duretion.Text;
warrty = wtyNo + " " + wtydu;
}
else
{
warrty = "No Warranty";
}
try
{
if (txtAddItemBarcode.Text != "" || txtAddItemSerial.Text != "")
{
if (txtAddItemItemName.Text != "" && txtAddItemSalesPrice.Text != "" && txtAddItemPurchasePrice.Text != "" && cbxAddItemCatogory.Text != "" && cbxAddItemSubCatogory.Text != "" && cbxAddItemBrande.Text != "" && cbxAddItemSupplier.Text != "")
{
if (cb_warnty.Checked == true)
{
if (cbx_wrty_number.Text != "" && cbx_wrty_duretion.Text != "")
{
string sql = "UPDATE tbl_Add_Items SET Serial_No='" + txtAddItemSerial.Text + "',Item_Name='" + txtAddItemItemName.Text + "',Sales_Price='" + Convert.ToDecimal(txtAddItemSalesPrice.Text) + "',Purchase_Price='" + Convert.ToDecimal(txtAddItemPurchasePrice.Text) + "',Tax_Rate='" + Convert.ToDecimal(txtAddItemTaxRate.Text) + "',Barcode='" + txtAddItemBarcode.Text + "',Catogory='" + cbxAddItemCatogory.Text + "',Sub_Catogory='" + cbxAddItemSubCatogory.Text + "',Brande='" + cbxAddItemBrande.Text + "',Item_Type='" + cbxAddItemItemType.Text + "',Supplier='" + cbxAddItemSupplier.Text + "',Warranty='" + warrty + "',Discription='" + txtAddItemDiscription.Text + "' WHERE Item_No='" + lbl_itemNo.Text + "'";
SqlCommand com = new SqlCommand(sql, ConnectionDB.Connection());
com.ExecuteNonQuery();
// MessageBox.Show("Item Added");
//SqlDataReader dr = itemdb.select_to_Qntity(cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text);
//if (dr.Read())
//{
// string qt = dr["Quntity"].ToString();
// int q1 = int.Parse(qt);
// int q2 = q1 + 1;
// string qty = q2.ToString();
// itemdb.update_Quntity(qty, cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text);
// // MessageBox.Show("Quntity Updated");
//}
//else
//{
// itemdb.Quntity(txtAddItemItemName.Text,cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text, "1",txtAddItemPurchasePrice.Text,txtAddItemSalesPrice.Text);
// // MessageBox.Show("quntity Added");
//}
//SqlDataReader drm = itemdb.select_to_Qntity(itup.catogy, itup.subCatogy, itup.Brande);
//if (drm.Read())
//{
// string qqt = drm["Quntity"].ToString();
// int qq1 = int.Parse(qqt);
// int qq2 = qq1 - 1;
// string qty = qq2.ToString();
// itemdb.update_Quntity(qty, itup.catogy, itup.subCatogy, itup.Brande);
// // MessageBox.Show("Quntity Updated");
//}
if (MessageBox.Show("Item Updated Successfuly.", "Update Item", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
this.Close();
Main.p1.Controls.Clear();
Find_item d1 = new Find_item();
d1.TopLevel = false;
d1.Visible = true;
Main.p1.Controls.Add(d1);
}
}
else
{
ep_warrnty.SetError(cbx_wrty_duretion, "Complete warranty");
}
}
else
{
string sql = "UPDATE tbl_Add_Items SET Serial_No='" + txtAddItemSerial.Text + "',Item_Name='" + txtAddItemItemName.Text + "',Sales_Price='" + txtAddItemSalesPrice.Text + "',Purchase_Price='" + txtAddItemPurchasePrice.Text + "',Tax_Rate='" + txtAddItemTaxRate.Text + "',Barcode='" + txtAddItemBarcode.Text + "',Catogory='" + cbxAddItemCatogory.Text + "',Sub_Catogory='" + cbxAddItemSubCatogory.Text + "',Brande='" + cbxAddItemBrande.Text + "',Item_Type='" + cbxAddItemItemType.Text + "',Supplier='" + cbxAddItemSupplier.Text + "',Warranty='" + warrty + "',Discription='" + txtAddItemDiscription.Text + "' WHERE Item_No='" + lbl_itemNo.Text + "'";
SqlCommand com = new SqlCommand(sql, ConnectionDB.Connection());
com.ExecuteNonQuery();
// MessageBox.Show("Item Added");
SqlDataReader dr = itemdb.select_to_Qntity(cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text);
if (dr.Read())
{
string qt = dr["Quntity"].ToString();
int q1 = int.Parse(qt);
int q2 = q1 + 1;
string qty = q2.ToString();
itemdb.update_Quntity(qty, cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text);
// MessageBox.Show("Quntity Updated");
}
else
{
itemdb.Quntity(txtAddItemItemName.Text, cbxAddItemCatogory.Text, cbxAddItemSubCatogory.Text, cbxAddItemBrande.Text, "1", txtAddItemPurchasePrice.Text, txtAddItemSalesPrice.Text);
// MessageBox.Show("quntity Added");
}
SqlDataReader drm = itemdb.select_to_Qntity(itup.catogy, itup.subCatogy, itup.Brande);
if (drm.Read())
{
string qqt = drm["Quntity"].ToString();
int qq1 = int.Parse(qqt);
int qq2 = qq1 - 1;
string qty = qq2.ToString();
itemdb.update_Quntity(qty, itup.catogy, itup.subCatogy, itup.Brande);
// MessageBox.Show("Quntity Updated");
}
if (MessageBox.Show("Item Updated Successfuly.", "Update Item", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
this.Close();
Main.p1.Controls.Clear();
Find_item d1 = new Find_item();
d1.TopLevel = false;
d1.Visible = true;
Main.p1.Controls.Add(d1);
}
}
}
else
{
if (txtAddItemItemName.Text == "")
{
ep_iname.SetError(txtAddItemItemName, "Enter Item name");
}
if (txtAddItemSalesPrice.Text == "")
{
ep_isalePrz.SetError(txtAddItemSalesPrice, "Enter Item Sales Price");
}
if (txtAddItemPurchasePrice.Text == "")
{
ep_ipuchsPriz.SetError(txtAddItemPurchasePrice, "Enter Item Purchas Price");
}
if (cbxAddItemSupplier.Text == "")
{
ep_isupp.SetError(cbxAddItemSupplier, "Choose Supplier name");
}
if (cbxAddItemCatogory.Text == "")
{
ep_ictogry.SetError(cbxAddItemCatogory, "Choose Item Catogary");
}
if (cbxAddItemSubCatogory.Text == "")
{
ep_isubCotory.SetError(cbxAddItemSubCatogory, "Choose Item sub Catogary");
}
if (cbxAddItemBrande.Text == "")
{
ep_ibrnd.SetError(cbxAddItemBrande, "Choose Item Brande");
}
tp_required.Show("Fill Require fileds", btnAddItemAddItem, 5000);
}
}
else
{
tp_seril_barcobe.Show("Must Enter Serial or Barcode For Iditify Items", lbl_tp, 4000);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}