public void AddExpenses(Expensess expensess) { string command = "Insert Into T_Epenses (Emp_ID,Expenses,Descreption,Date) Values (@emp,@expenses,@descre,@date)"; SqlParameter[] param = new SqlParameter[4]; try { DBAdapter.OPen(); param[0] = new SqlParameter("@emp", SqlDbType.NVarChar, 50); param[0].Value = expensess.Employee_Name; param[1] = new SqlParameter("@expenses", SqlDbType.NVarChar, 50); param[1].Value = expensess.Cost; param[2] = new SqlParameter("@descre", SqlDbType.NVarChar, 50); param[2].Value = expensess.DESC; param[3] = new SqlParameter("@date", SqlDbType.Date, 50); param[3].Value = expensess.Date; _do.Execute_Query(command, param); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { DBAdapter.Close(); Alert.Show("Expensess Add Successfully"); } }
private void button11_Click(object sender, EventArgs e) { Expensess expensses = new Expensess(); expensses.Date = DateTime.Now.ToShortDateString(); expensses.DESC = txtdesc.Text; expensses.Cost = txtcost.Text; expensses.Employee_Name = Properties.Settings.Default.Logedin_Name; new DataAccess().AddExpenses(expensses); }
public List <Expensess> GetAllExpensess(string date1, string date2) { List <Expensess> all = new List <Expensess>(); SqlParameter[] param = new SqlParameter[2]; string command = "Select * from T_Epenses where Date between @date and @date2 "; try { DBAdapter.OPen(); param[0] = new SqlParameter("@date", SqlDbType.Date, 50); param[0].Value = date1; param[1] = new SqlParameter("@date2", SqlDbType.Date, 50); param[1].Value = date2; } catch (Exception ex) { MessageBox.Show(ex.Message); } DBAdapter.Close(); DataTable table = _do.getQuery(command, param); Expensess expensess = new Expensess(); if (table.Rows.Count > 0) { for (int i = 0; i < table.Rows.Count; i++) { expensess.Employee_Name = table.Rows[i]["Emp_ID"].ToString(); expensess.Cost = table.Rows[i]["Expenses"].ToString(); expensess.Date = table.Rows[i]["Date"].ToString(); expensess.DESC = table.Rows[i]["Descreption"].ToString(); all.Add(expensess); } } return(all); }