public ItemClassDTO GetById(int id) { ItemClassDTO itemClassDTO = new ItemClassDTO(); SqlCommand cmd = new SqlCommand("select * from Inventory.TblItemClass where Id=@Id", DbConnector.Connect()); cmd.Parameters.AddWithValue("@Id", id); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet dataSet = new DataSet(); adapter.Fill(dataSet); DataTable dt = dataSet.Tables[0]; if (dt.Rows.Count > 0) { itemClassDTO = new ItemClassDTO() { Id = Convert.ToInt32(dt.Rows[0]["Id"]), Code = Convert.ToString(dt.Rows[0]["Code"]), Name = Convert.ToString(dt.Rows[0]["Name"]), CreatedOn = Convert.ToDateTime(dt.Rows[0]["CreatedOn"]), CreatedBy = Convert.ToInt32(dt.Rows[0]["CreatedBy"]), Active = Convert.ToBoolean(dt.Rows[0]["Active"]) }; if (dt.Rows[0]["ModifiedOn"] != DBNull.Value) { itemClassDTO.ModifiedOn = Convert.ToDateTime(dt.Rows[0]["ModifiedOn"]); } if (dt.Rows[0]["ModifiedBy"] != DBNull.Value) { itemClassDTO.ModifiedBy = Convert.ToInt32(dt.Rows[0]["ModifiedBy"]); } } return(itemClassDTO); }
public List <ItemClassDTO> GetAll() { List <ItemClassDTO> itemClassDTOs = new List <ItemClassDTO>(); SqlCommand cmd = new SqlCommand("select * from Inventory.TblItemClass", DbConnector.Connect()); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet dataSet = new DataSet(); adapter.Fill(dataSet); DataTable dt = dataSet.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { ItemClassDTO itemClassDTO = new ItemClassDTO() { Id = Convert.ToInt32(dt.Rows[i]["Id"]), Code = Convert.ToString(dt.Rows[i]["Code"]), Name = Convert.ToString(dt.Rows[i]["Name"]), CreatedOn = Convert.ToDateTime(dt.Rows[i]["CreatedOn"]), CreatedBy = Convert.ToInt32(dt.Rows[i]["CreatedBy"]), Active = Convert.ToBoolean(dt.Rows[i]["Active"]) }; if (dt.Rows[i]["ModifiedOn"] != DBNull.Value) { itemClassDTO.ModifiedOn = Convert.ToDateTime(dt.Rows[i]["ModifiedOn"]); } if (dt.Rows[i]["ModifiedBy"] != DBNull.Value) { itemClassDTO.ModifiedBy = Convert.ToInt32(dt.Rows[i]["ModifiedBy"]); } itemClassDTOs.Add(itemClassDTO); } return(itemClassDTOs); }