public IdentityDevice GetById(int Id) { var info = new IdentityDevice(); var sqlCmd = @"Device_GetById"; var parameters = new Dictionary <string, object> { { "@Id", Id } }; try { using (var conn = new SqlConnection(_connectionString)) { using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters)) { while (reader.Read()) { info = ExtractDeviceData(reader); } } } } catch (Exception ex) { var strError = "Failed to execute Device_GetById. Error: " + ex.Message; throw new CustomSQLException(strError); } return(info); }
public static int RegisterNewDevice(IdentityDevice deviceInfo, out bool isNew) { var newId = 0; isNew = false; try { var myStore = GlobalContainer.IocContainer.Resolve <IStoreDevice>(); if (deviceInfo != null) { newId = myStore.RegisterNewDevice(deviceInfo, out isNew); if (isNew) { //Clear cache CachingHelpers.ClearDeviceCache(); } } } catch (Exception ex) { logger.Error("Could not RegisterNewDevice: " + ex.ToString()); } return(newId); }
public bool Update(IdentityDevice identity) { //Common syntax var sqlCmd = @"Device_Update"; //For parameters var parameters = new Dictionary <string, object> { { "@Id", identity.Id }, { "@Name", identity.Name }, { "@Code", identity.Code }, //{"@LastUpdatedBy", identity.LastUpdatedBy}, { "@Status", identity.Status } }; try { using (var conn = new SqlConnection(_connectionString)) { MsSqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, sqlCmd, parameters); } } catch (Exception ex) { var strError = "Failed to execute Device_Update. Error: " + ex.Message; throw new CustomSQLException(strError); } return(true); }
public int Insert(IdentityDevice identity) { //Common syntax var sqlCmd = @"Device_Insert"; var newId = 0; //For parameters var parameters = new Dictionary <string, object> { { "@Name", identity.Name }, { "@Code", identity.Code } }; try { using (var conn = new SqlConnection(_connectionString)) { var returnObj = MsSqlHelper.ExecuteScalar(conn, CommandType.StoredProcedure, sqlCmd, parameters); newId = Convert.ToInt32(returnObj); } } catch (Exception ex) { var strError = "Failed to execute Device_Insert. Error: " + ex.Message; throw new CustomSQLException(strError); } return(newId); }
public int RegisterNewDevice(IdentityDevice identity, out bool isNew) { //Common syntax var sqlCmd = @"Device_RegisterNewDevice"; var newId = 0; var hasInserted = 0; isNew = false; //For parameters var parameters = new Dictionary <string, object> { { "@Name", identity.Name }, { "@Code", identity.Code } }; try { using (var conn = new SqlConnection(_connectionString)) { var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters); if (reader.Read()) { newId = Convert.ToInt32(reader[0]); } if (reader.NextResult()) { if (reader.Read()) { hasInserted = Utils.ConvertToInt32(reader[0]); if (hasInserted == 1) { isNew = true; } else { isNew = false; } } } } } catch (Exception ex) { var strError = "Failed to execute RegisterNewDevice. Error: " + ex.Message; throw new CustomSQLException(strError); } return(newId); }
private IdentityDevice ExtractDeviceData(IDataReader reader) { var record = new IdentityDevice(); //Seperate properties record.Id = Utils.ConvertToInt32(reader["Id"]); record.Name = reader["Name"].ToString(); record.Code = reader["Code"].ToString(); //record.CreatedBy = reader["CreatedBy"].ToString(); record.CreatedDate = reader["CreatedDate"] == DBNull.Value ? null : (DateTime?)reader["CreatedDate"]; //record.LastUpdated = reader["LastUpdated"] == DBNull.Value ? null : (DateTime?)reader["LastUpdated"]; //record.LastUpdatedBy = reader["LastUpdatedBy"].ToString(); record.Status = Utils.ConvertToInt32(reader["Status"]); return(record); }
private int RegisterNewDevice() { var deviceId = 0; var isNew = false; try { var deviceInfo = new IdentityDevice(); deviceInfo.Name = System.Environment.MachineName; deviceId = CommonHelpers.RegisterNewDevice(deviceInfo, out isNew); } catch (Exception ex) { logger.Error("Failed to RegisterNewDevice because: " + ex.ToString()); } return(deviceId); }
public List <IdentityDevice> GetByPage(IdentityDevice filter, int currentPage, int pageSize) { //Common syntax var sqlCmd = @"Device_GetByPage"; List <IdentityDevice> listData = null; //For paging int offset = (currentPage - 1) * pageSize; //For parameters var parameters = new Dictionary <string, object> { { "@Keyword", filter.Keyword }, { "@Status", filter.Status }, { "@Offset", offset }, { "@PageSize", pageSize }, }; try { using (var conn = new SqlConnection(_connectionString)) { using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters)) { listData = ParsingListDeviceFromReader(reader); } } } catch (Exception ex) { var strError = "Failed to execute Device_GetByPage. Error: " + ex.Message; throw new CustomSQLException(strError); } return(listData); }
public bool Update(IdentityDevice identity) { return(myRepository.Update(identity)); }
public int RegisterNewDevice(IdentityDevice identity, out bool isNew) { return(myRepository.RegisterNewDevice(identity, out isNew)); }
public int Insert(IdentityDevice identity) { return(myRepository.Insert(identity)); }
public List <IdentityDevice> GetByPage(IdentityDevice filter, int currentPage, int pageSize) { return(myRepository.GetByPage(filter, currentPage, pageSize)); }