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