public List <Unites> GetByFloorID(int _FloorID)
{
SqlConnection Connection = DBGate.GetConnection();
string SelectAll = " select * from Unites where FloorID = @FloorID ";
SqlCommand cmd = new SqlCommand(SelectAll, Connection);
cmd.Parameters.AddWithValue("@FloorID", _FloorID);
List <Unites> lst = new List <Unites>();
try
{
Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Unites _obj = new Unites();
_obj.ID = int.Parse(reader["ID"].ToString());
_obj.UnitTypeID = int.Parse(reader["UnitTypeID"].ToString());
_obj.FloorID = int.Parse(reader["FloorID"].ToString());
_obj.StatusID = int.Parse(reader["StatusID"].ToString());
_obj.UnitName = reader["UnitName"].ToString();
_obj.StatusReason = reader["StatusReason"].ToString();
lst.Add(_obj);
}
}
catch (SqlException ex)
{
frmDone frmerror = new frmDone(ex.ToString());
frmerror.ShowDialog();
}
finally { Connection.Close(); }
return(lst);
}
public List <Unites> GetUnitName()
{
SqlConnection Connection = DBGate.GetConnection();
string SelectAll = " select Unites.id , UniteType.UniteName as TypeName , Unites.UnitName as UnitName ";
SelectAll += " from Unites join UniteType on UniteType.ID = Unites.UnitTypeID ";
SqlCommand cmd = new SqlCommand(SelectAll, Connection);
List <Unites> lst = new List <Unites>();
try
{
Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Unites _obj = new Unites();
_obj.ID = int.Parse(reader["ID"].ToString());
_obj.TypeName = reader["TypeName"].ToString();
_obj.UnitName = reader["UnitName"].ToString();
lst.Add(_obj);
}
}
catch (SqlException ex)
{
frmDone frmerror = new frmDone(ex.ToString());
frmerror.ShowDialog();
}
finally { Connection.Close(); }
return(lst);
}
public DAL.Unites GetByID(int ID)
{
SqlConnection Connection = DBGate.GetConnection();
string SelectByID = "Select * from Unites where ID = @ID ";
SqlCommand cmd = new SqlCommand(SelectByID, Connection);
cmd.Parameters.AddWithValue("@ID", ID);
Unites _obj = new Unites();
try
{
Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
_obj.ID = int.Parse(reader["ID"].ToString());
_obj.UnitTypeID = int.Parse(reader["UnitTypeID"].ToString());
_obj.FloorID = int.Parse(reader["FloorID"].ToString());
_obj.StatusID = int.Parse(reader["StatusID"].ToString());
_obj.UnitName = reader["UnitName"].ToString();
_obj.StatusReason = reader["StatusReason"].ToString();
}
}
catch (SqlException ex)
{
frmDone frmerror = new frmDone(ex.ToString());
frmerror.ShowDialog();
}
finally
{
Connection.Close();
}
return(_obj);
}
