public List <Location> GetLocation() { DataTable dt = LocationData.GetLocation(); List <Location> lstLocation = new List <Location>(); Location location; foreach (DataRow dr in dt.Rows) { location = new Location(); location.LocationId = dr.IsNull("LocationId") ? 0 : int.Parse(dr["LocationId"].ToString()); location.LocationTypeId = dr.IsNull("LocationTypeId") ? 0 : int.Parse(dr["LocationTypeId"].ToString()); location.LocationName = dr.IsNull("Name") ? "" : dr["Name"].ToString(); location.BarCode = dr.IsNull("barCode") ? "" : dr["barCode"].ToString(); location.IsActive = dr.IsNull("IsActive") ? false : bool.Parse(dr["IsActive"].ToString()); location.IsAvailableToSell = dr.IsNull("IsAvailableToSell") ? false : bool.Parse(dr["IsAvailableToSell"].ToString()); location.IsTurnInLocation = dr.IsNull("IsTurnInLocation") ? false : bool.Parse(dr["IsTurnInLocation"].ToString()); location.AllowForMassUpdate = dr.IsNull("AllowForMassUpdate") ? false : bool.Parse(dr["AllowForMassUpdate"].ToString()); location.IsActive = dr.IsNull("IsStore") ? false : bool.Parse(dr["IsStore"].ToString()); location.CreatedBy = dr.IsNull("CreatedBy") ? "" : dr["CreatedBy"].ToString(); location.CreatedDate = dr.IsNull("CreatedDate") ? new DateTime() : Convert.ToDateTime(dr["CreatedDate"]); location.LastUpdatedBy = dr.IsNull("LastupdatedBy") ? "" : dr["LastupdatedBy"].ToString(); location.LastUpdatedDate = dr.IsNull("LastUpdatedDate") ? new DateTime() : Convert.ToDateTime(dr["LastUpdatedDate"]); lstLocation.Add(location); } return(lstLocation); }
public Location GetLocations(int locationid) { LocationData data = new LocationData(); Location location = new Location(); try { location = data.GetLocation(locationid); } catch (Exception ex) { log.Write(ex.Message, "GetLocations"); throw (ex); } finally { data = null; } return(location); }