public static List <TrackingItemModel> Get_Searchcol(string Searchcol) { List <TrackingItemModel> _Value = new List <TrackingItemModel>(); //SqlConnection _SQLConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["DentalAppConn"].ConnectionString); SqlConnection _SQLConnection = SQLConnectionString.BuildConnection(); using (SqlConnection _DBConnection = _SQLConnection) { SqlCommand _SQLCommand = new SqlCommand(); _SQLCommand.CommandType = System.Data.CommandType.StoredProcedure; _SQLCommand.CommandTimeout = 0; using (_SQLCommand) { try { _SQLCommand.Connection = _DBConnection; _SQLCommand.CommandText = "Get_SearchCol"; _SQLCommand.Parameters.AddWithValue("@Searchcol", Searchcol); _DBConnection.Open(); SqlDataReader _SQLDataReader = _SQLCommand.ExecuteReader(); TrackingItemModel _result; while (_SQLDataReader.Read()) { _result = new TrackingItemModel(); _result.TrackItem = _SQLDataReader["TrackItem"].ToString(); _result.TrackID = _SQLDataReader["TrackID"].ToString(); _result.AccountNo = _SQLDataReader["AccountNo"].ToString(); _Value.Add(_result); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { _DBConnection.Close(); } } } return(_Value); }
public static List <TrackingItemModel> Get_TrackingItem(string AccountNo) { List <TrackingItemModel> _Value = new List <TrackingItemModel>(); //SqlConnection _SQLConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["DentalAppConn"].ConnectionString); SqlConnection _SQLConnection = SQLConnectionString.BuildConnection(); using (SqlConnection _DBConnection = _SQLConnection) { SqlCommand _SQLCommand = new SqlCommand(); _SQLCommand.CommandType = System.Data.CommandType.StoredProcedure; _SQLCommand.CommandTimeout = 0; using (_SQLCommand) { try { _SQLCommand.Connection = _DBConnection; _SQLCommand.CommandText = "Get_TrackingItem"; _SQLCommand.Parameters.AddWithValue("@AccountNo", AccountNo); _DBConnection.Open(); SqlDataReader _SQLDataReader = _SQLCommand.ExecuteReader(); TrackingItemModel _result; while (_SQLDataReader.Read()) { _result = new TrackingItemModel(); _result.ID = Convert.ToInt32(_SQLDataReader["ID"].ToString()); _result.AccountNo = _SQLDataReader["AccountNo"].ToString(); _result.GPSSimNumber = _SQLDataReader["GPSSimNumber"].ToString(); _result.TrackID = _SQLDataReader["TrackID"].ToString(); _result.DeviceID = _SQLDataReader["DeviceID"].ToString(); _result.TrackItemType = _SQLDataReader["TrackItemType"].ToString(); _result.TrackItem = _SQLDataReader["TrackItem"].ToString(); _result.GPSModel = _SQLDataReader["GPSModel"].ToString(); _result.Interval = _SQLDataReader["Interval"].ToString(); _result.CreatedDate = _SQLDataReader["CreatedDate"].ToString(); _result.CreatedBy = _SQLDataReader["CreatedBy"].ToString(); _result.ModifiedDate = _SQLDataReader["ModifiedDate"].ToString(); _result.ModifiedBy = _SQLDataReader["ModifiedBy"].ToString(); _result.TrackingMode = _SQLDataReader["TrackingMode"].ToString(); _result.Status = _SQLDataReader["Status"].ToString(); _result.ExpiredDate = _SQLDataReader["ExpiredDate"].ToString(); _result.Term = _SQLDataReader["Term"].ToString(); _result.Sex = _SQLDataReader["Sex"].ToString(); _result.Risk = _SQLDataReader["Risk"].ToString(); _result.Age = _SQLDataReader["Age"].ToString(); ////_result.Picture = _SQLDataReader["Picture"].ToString(); _result.Spare1 = _SQLDataReader["Spare1"].ToString(); _result.Spare2 = _SQLDataReader["Spare2"].ToString(); _result.Spare3 = _SQLDataReader["Spare3"].ToString(); _result.Spare4 = _SQLDataReader["Spare4"].ToString(); _result.Spare5 = _SQLDataReader["Spare5"].ToString(); _result.Spare6 = _SQLDataReader["Spare6"].ToString(); _result.Spare7 = _SQLDataReader["Spare7"].ToString(); _result.Spare8 = _SQLDataReader["Spare8"].ToString(); _result.Spare9 = _SQLDataReader["Spare9"].ToString(); _result.Spare10 = _SQLDataReader["Spare10"].ToString(); _result.Spare11 = _SQLDataReader["Spare11"].ToString(); _result.Spare12 = _SQLDataReader["Spare12"].ToString(); _Value.Add(_result); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { _DBConnection.Close(); } } } return(_Value); }