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