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