public OPERATION Get_Query()
{
SqlParameter[] param = new SqlParameter[2];
Car car = new Car("", "");
string command = " SELECT * FROM Car where ID=@id And char=@char ";
try
{
DBAdapter.OPen();
param[0] = new SqlParameter("@id", SqlDbType.NVarChar, 50);
param[0].Value = this.Car_ID;
param[1] = new SqlParameter("@char", SqlDbType.NVarChar, 50);
param[1].Value = this.Car_Char;
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
DBAdapter.Close();
DataTable table = _do.getQuery(command, param);
if (table.Rows.Count > 0)
{
car.Car_ID = table.Rows[0][0].ToString();
car.Car_Char = table.Rows[0][1].ToString();
car.Date = table.Rows[0][2].ToString();
car.Time = table.Rows[0][3].ToString();
return(car);
}
else
{
return(null);
}
}
public List <Employee> GetAll()
{
List <Employee> all = new List <Employee>();
DataTable table;
string command = "SELECT * FROM Employee ";
try
{
DBAdapter.OPen();
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
DBAdapter.Close();
table = _do.getQuery(command, null);
for (int i = 0; i < table.Rows.Count; i++)
{
Employee emp = new Employee("", "");
emp.Name = table.Rows[i]["Emp_ID"].ToString();
emp.Code = table.Rows[i]["Emp_code"].ToString();
emp.Date = table.Rows[i]["Date"].ToString();
emp.power = table.Rows[i]["Power"].ToString();
emp.Phone = table.Rows[i]["Phone"].ToString();
emp.Time = table.Rows[i]["time"].ToString();
emp.Salary = table.Rows[i]["Salary"].ToString();
all.Add(emp);
}
return(all);
}
public void Set_Query()
{
string command = "insert into Car (ID,char,date,time) values (@id,@char,@date,@time) ";
try
{
DBAdapter.OPen();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@id", SqlDbType.NVarChar, 50);
param[0].Value = this.Car_ID;
param[1] = new SqlParameter("@char", SqlDbType.NVarChar, 50);
param[1].Value = this.Car_Char;
param[2] = new SqlParameter("@date", SqlDbType.NVarChar, 50);
param[2].Value = DateTime.Now.ToShortDateString();
param[3] = new SqlParameter("@time", SqlDbType.NVarChar, 50);
param[3].Value = DateTime.Now.ToLongTimeString();
_do.Execute_Query(command, param);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
DBAdapter.Close();
}
//-------
}
public void Reset_Query( )
{
string command = "Update Car set (ID=@id,char=@char,date=@date,time=@time) where ID=@id And char=@char ";
try
{
DBAdapter.OPen();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@id", SqlDbType.NVarChar, 50);
param[0].Value = this.Car_ID;
param[1] = new SqlParameter("@char", SqlDbType.NVarChar, 50);
param[1].Value = this.Car_Char;
param[2] = new SqlParameter("@date", SqlDbType.NVarChar, 50);
param[2].Value = this.Date;
param[3] = new SqlParameter("@time", SqlDbType.NVarChar, 50);
param[3].Value = this.Time;
_do.Execute_Query(command, param);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
DBAdapter.Close();
Alert.Show("Car Reset Successfuly");
}
}
