protected void SetInfo(out Model.MeterReading info, SqlDataReader reader) { try { info = new Model.MeterReading(); info.Id = CastDBNull.To <string>(reader["Id"], ""); info.SerialNumber = CastDBNull.To <string>(reader["SerialNumber"], ""); info.ReadingDate = CastDBNull.To <DateTime>(reader["ReadingDate"], DateTime.Now); info.ReadingValue = CastDBNull.To <string>(reader["ReadingValue"], ""); info.LowBatteryAlr = CastDBNull.To <int>(reader["LowBatteryAlr"], 0); info.LeakAlr = CastDBNull.To <int>(reader["LeakAlr"], 0); info.MagneticTamperAlr = CastDBNull.To <int>(reader["MagneticTamperAlr"], 0); info.MeterErrorAlr = CastDBNull.To <int>(reader["MeterErrorAlr"], 0); info.BackFlowAlr = CastDBNull.To <int>(reader["BackFlowAlr"], 0); info.BrokenPipeAlr = CastDBNull.To <int>(reader["BrokenPipeAlr"], 0); info.EmptyPipeAlr = CastDBNull.To <int>(reader["EmptyPipeAlr"], 0); info.SpecificErr = CastDBNull.To <int>(reader["SpecificErr"], 0); info.CreatedBy = CastDBNull.To <string>(reader["Createdby"], ""); info.EditedBy = CastDBNull.To <string>(reader["Editedby"], ""); info.DocDate = CastDBNull.To <DateTime>(reader["DocDate"], DateTime.Now); info.Show = CastDBNull.To <int>(reader["Show"], 1); info.LockCount = CastDBNull.To <int>(reader["LockCount"], 1); info.IsNew = false; info.IsDirty = true; } catch (Exception ex) { throw ex; } }
protected void SetInfo(out Model.Meter info, SqlDataReader reader) { try { info = new Model.Meter(); info.SerialNumber = CastDBNull.To <string>(reader["SerialNumber"], ""); info.X = CastDBNull.To <decimal>(reader["X"], 0.0m); info.Y = CastDBNull.To <decimal>(reader["Y"], 0.0m); info.Status = CastDBNull.To <string>(reader["Status"], ""); info.HCN = CastDBNull.To <string>(reader["HCN"], ""); info.InstallationDate = CastDBNull.To <DateTime>(reader["InstallationDate"], DateTime.Now); info.MaintenanceDate = CastDBNull.To <DateTime>(reader["MaintenanceDate"], DateTime.Now); info.MeterTypeId = CastDBNull.To <string>(reader["MeterTypeId"], ""); info.MeterSizeId = CastDBNull.To <string>(reader["MeterSizeId"], ""); info.MeterProtocolId = CastDBNull.To <string>(reader["MeterProtocolId"], ""); info.DMZId = CastDBNull.To <string>(reader["DMZId"], ""); info.CityId = CastDBNull.To <string>(reader["CityId"], ""); info.MacAddress = CastDBNull.To <string>(reader["MacAddress"], ""); info.CreatedBy = CastDBNull.To <string>(reader["Createdby"], ""); info.EditedBy = CastDBNull.To <string>(reader["Editedby"], ""); info.DocDate = CastDBNull.To <DateTime>(reader["DocDate"], DateTime.Now); info.Show = CastDBNull.To <int>(reader["Show"], 1); info.LockCount = CastDBNull.To <int>(reader["LockCount"], 1); info.IsNew = false; info.IsDirty = true; } catch (Exception ex) { throw ex; } }
protected override void OnSetValue(string fieldname, object value) { switch (fieldname.ToLower()) { case "id": this.Id = CastDBNull.To <int>(value, 0); break; case "username": this.UserName = CastDBNull.To <string>(value, ""); break; case "passwordhash": this.PasswordHash = CastDBNull.To <string>(value, ""); break; case "fullname": this.FullName = CastDBNull.To <string>(value, ""); break; case "role": this.Role = CastDBNull.To <string>(value, ""); break; case "locked": this.Locked = CastDBNull.To <string>(value, ""); break; default: //null; break; } }
protected override void OnSetValue(string fieldname, object value) { switch (fieldname.ToLower()) { case "city": City = CastDBNull.To <string>(value, ""); break; case "dmz": DMZ = CastDBNull.To <string>(value, ""); break; case "macaddress": MacAddress = CastDBNull.To <string>(value, ""); break; case "serilnumber": SerialNumber = CastDBNull.To <string>(value, ""); break; default: //null; break; } }
protected void SetInfo(out Model.Gateway info, SqlDataReader reader) { try { info = new Model.Gateway(); info.MacAddress = CastDBNull.To <string>(reader["MacAddress"], ""); info.SimCard = CastDBNull.To <string>(reader["SimCard"], ""); info.X = CastDBNull.To <decimal>(reader["X"], 0.0m); info.Y = CastDBNull.To <decimal>(reader["Y"], 0.0m); info.Description = CastDBNull.To <string>(reader["Description"], ""); info.InstallationDate = CastDBNull.To <DateTime>(reader["InstallationDate"], DateTime.Now); info.MaintenanceDate = CastDBNull.To <DateTime>(reader["MaintenanceDate"], DateTime.Now); info.Status = CastDBNull.To <string>(reader["Status"], ""); info.IPAddress = CastDBNull.To <string>(reader["IPAddress"], ""); info.DMZId = CastDBNull.To <string>(reader["DMZId"], ""); info.CityId = CastDBNull.To <string>(reader["CityId"], ""); info.CreatedBy = CastDBNull.To <string>(reader["Createdby"], ""); info.EditedBy = CastDBNull.To <string>(reader["Editedby"], ""); info.DocDate = CastDBNull.To <DateTime>(reader["DocDate"], DateTime.Now); info.Show = CastDBNull.To <int>(reader["Show"], 1); info.LockCount = CastDBNull.To <int>(reader["LockCount"], 1); info.IsNew = false; info.IsDirty = true; } catch (Exception ex) { throw ex; } }
protected override void OnSetValue(string fieldname, object value) { switch (fieldname.ToLower()) { case "id": this.Id = CastDBNull.To <string>(value, ""); break; case "rds": this.RDS = CastDBNull.To <int>(value, 0); break; case "oms": this.OMS = CastDBNull.To <int>(value, 0); break; case "gatewaymacaddress": this.GatewayMacAddress = CastDBNull.To <string>(value, ""); break; case "csvfilename": this.CSVFilename = CastDBNull.To <string>(value, ""); break; case "createdby": this.CreatedBy = CastDBNull.To <string>(value, ""); break; case "editedby": this.EditedBy = CastDBNull.To <string>(value, ""); break; case "docdate": this.DocDate = CastDBNull.To <DateTime>(value, DateTime.Now); break; case "show": this.Show = CastDBNull.To <int>(value, 0); break; case "lockcount": this.LockCount = CastDBNull.To <int>(value, 0); break; default: //null; break; } }
protected void SetInfo(out Model.Roles info, SqlDataReader reader) { try { info = new Model.Roles(); info.Id = CastDBNull.To <string>(reader["Id"], ""); info.Name = CastDBNull.To <string>(reader["Name"], ""); info.IsNew = false; info.IsDirty = true; } catch (Exception ex) { throw ex; } }
protected void SetInfo(out Model.NodeDTO info, SqlDataReader reader) { try { info = new Model.NodeDTO(); info.City = CastDBNull.To <string>(reader["City"], ""); info.DMZ = CastDBNull.To <string>(reader["DMZ"], ""); info.MacAddress = CastDBNull.To <string>(reader["MacAddress"], ""); info.SerialNumber = CastDBNull.To <string>(reader["SerialNumber"], ""); info.IsNew = false; info.IsDirty = true; } catch (Exception ex) { throw ex; } }
protected override void OnSetValue(string fieldname, object value) { switch (fieldname.ToLower()) { case "id": this.Id = CastDBNull.To <string>(value, ""); break; case "name": this.Name = CastDBNull.To <string>(value, ""); break; default: //null; break; } }
protected override void OnSetValue(string fieldname, object value) { switch (fieldname.ToLower()) { case "id": this.Id = CastDBNull.To <int>(value, 0); break; case "description": this.Description = CastDBNull.To <string>(value, ""); break; case "totalnumberofmeters": this.TotalNumberOfMeters = CastDBNull.To <int>(value, 0); break; case "cityid": this.CityId = CastDBNull.To <string>(value, ""); break; case "createdby": this.CreatedBy = CastDBNull.To <string>(value, ""); break; case "editedby": this.EditedBy = CastDBNull.To <string>(value, ""); break; case "docdate": this.DocDate = CastDBNull.To <DateTime>(value, DateTime.Now); break; case "show": this.Show = CastDBNull.To <int>(value, 0); break; case "lockcount": this.TotalNumberOfMeters = CastDBNull.To <int>(value, 0); break; default: //null; break; } }
protected void SetInfo(out Model.User info, SqlDataReader reader) { try { info = new Model.User(); info.Id = CastDBNull.To <int>(reader["Id"], 0); info.UserName = CastDBNull.To <string>(reader["UserName"], ""); info.PasswordHash = CastDBNull.To <string>(reader["PasswordHash"], ""); info.FullName = CastDBNull.To <string>(reader["FullName"], ""); info.Role = CastDBNull.To <string>(reader["Role"], ""); info.Locked = CastDBNull.To <string>(reader["Locked"], ""); info.IsNew = false; info.IsDirty = true; } catch (Exception ex) { throw ex; } }
protected void SetInfo(out Model.MeterType info, SqlDataReader reader) { try { info = new Model.MeterType(); info.Id = CastDBNull.To <int>(reader["Id"], 0); info.Description = CastDBNull.To <string>(reader["Description"], ""); info.CreatedBy = CastDBNull.To <string>(reader["Createdby"], ""); info.EditedBy = CastDBNull.To <string>(reader["Editedby"], ""); info.DocDate = CastDBNull.To <DateTime>(reader["DocDate"], DateTime.Now); info.Show = CastDBNull.To <int>(reader["Show"], 1); info.IsNew = false; info.IsDirty = true; } catch (Exception ex) { throw ex; } }
protected void SetInfo(out UserInfo info, SqlDataReader rdr) { try { info = new UserInfo(); info.Id = CastDBNull.To <string>(rdr["Id"], ""); info.Username = CastDBNull.To <string>(rdr["Username"], ""); info.Password = CastDBNull.To <string>(rdr["Password"], ""); info.Name = CastDBNull.To <string>(rdr["Name"], ""); info.Role = CastDBNull.To <string>(rdr["Role"], ""); info.SecurityQuestion = CastDBNull.To <string>(rdr["SecurityQuestion"], ""); info.SecurityAnswer = CastDBNull.To <string>(rdr["SecurityAnswer"], ""); info.IsActive = CastDBNull.To <bool>(rdr["IsActive"], false); } catch (Exception ex) { throw ex; } }
protected void SetInfo(out Model.GatewayLog info, SqlDataReader reader) { try { info = new Model.GatewayLog(); info.Id = CastDBNull.To <string>(reader["Id"], ""); info.RDS = CastDBNull.To <int>(reader["RDS"], 0); info.OMS = CastDBNull.To <int>(reader["OMS"], 0); info.GatewayMacAddress = CastDBNull.To <string>(reader["GatewayMacAddress"], ""); info.CSVFilename = CastDBNull.To <string>(reader["CSVFilename"], ""); info.CreatedBy = CastDBNull.To <string>(reader["Createdby"], ""); info.EditedBy = CastDBNull.To <string>(reader["Editedby"], ""); info.DocDate = CastDBNull.To <DateTime>(reader["DocDate"], DateTime.Now); info.Show = CastDBNull.To <int>(reader["Show"], 1); info.IsNew = false; info.IsDirty = true; } catch (Exception ex) { throw ex; } }
protected override void OnSetValue(string fieldname, object value) { switch (fieldname.ToLower()) { case "macaddress": this.MacAddress = CastDBNull.To <string>(value, ""); break; case "simcard": this.SimCard = CastDBNull.To <string>(value, ""); break; case "x": this.X = CastDBNull.To <decimal>(value, 0.0m); break; case "y": this.Y = CastDBNull.To <decimal>(value, 0.0m); break; case "description": this.Description = CastDBNull.To <string>(value, ""); break; case "installationdate": this.InstallationDate = CastDBNull.To <DateTime>(value, DateTime.Now); break; case "maintenancedate": this.MaintenanceDate = CastDBNull.To <DateTime>(value, DateTime.Now); break; case "status": this.Status = CastDBNull.To <string>(value, ""); break; case "ipaddress": this.IPAddress = CastDBNull.To <string>(value, ""); break; case "dmzid": this.DMZId = CastDBNull.To <string>(value, ""); break; case "cityid": this.CityId = CastDBNull.To <string>(value, ""); break; case "createdby": this.CreatedBy = CastDBNull.To <string>(value, ""); break; case "editedby": this.EditedBy = CastDBNull.To <string>(value, ""); break; case "docdate": this.DocDate = CastDBNull.To <DateTime>(value, DateTime.Now); break; case "show": this.Show = CastDBNull.To <int>(value, 0); break; case "lockcount": this.LockCount = CastDBNull.To <int>(value, 0); break; default: //null; break; } }
protected override void OnSetValue(string fieldname, object value) { switch (fieldname.ToLower()) { case "id": this.Id = CastDBNull.To <string>(value, ""); break; case "serialnumber": this.SerialNumber = CastDBNull.To <string>(value, ""); break; case "readingdate": this.ReadingDate = CastDBNull.To <DateTime>(value, DateTime.Now); break; case "readingvalue": this.ReadingValue = CastDBNull.To <string>(value, ""); break; case "lowbatteryalr": this.LowBatteryAlr = CastDBNull.To <int>(value, 0); break; case "leakalr": this.LeakAlr = CastDBNull.To <int>(value, 0); break; case "magnetictamperalr": this.MagneticTamperAlr = CastDBNull.To <int>(value, 0); break; case "metererroralr": this.MeterErrorAlr = CastDBNull.To <int>(value, 0); break; case "backflowalr": this.BackFlowAlr = CastDBNull.To <int>(value, 0); break; case "brokenpipealr": this.BrokenPipeAlr = CastDBNull.To <int>(value, 0); break; case "emptypipealr": this.EmptyPipeAlr = CastDBNull.To <int>(value, 0); break; case "specificerr": this.SpecificErr = CastDBNull.To <int>(value, 0); break; case "createdby": this.CreatedBy = CastDBNull.To <string>(value, ""); break; case "editedby": this.EditedBy = CastDBNull.To <string>(value, ""); break; case "docdate": this.DocDate = CastDBNull.To <DateTime>(value, DateTime.Now); break; case "show": this.Show = CastDBNull.To <int>(value, 0); break; case "lockcount": this.LockCount = CastDBNull.To <int>(value, 0); break; default: //null; break; } }
protected override void OnSetValue(string fieldname, object value) { switch (fieldname.ToLower()) { case "serialnumber": this.SerialNumber = CastDBNull.To <string>(value, ""); break; case "x": this.X = CastDBNull.To <decimal>(value, 0); break; case "y": this.Y = CastDBNull.To <decimal>(value, 0); break; case "status": this.Status = CastDBNull.To <string>(value, ""); break; case "hcn": this.HCN = CastDBNull.To <string>(value, ""); break; case "installationdate": this.InstallationDate = CastDBNull.To <DateTime>(value, DateTime.Now); break; case "maintenancedate": this.MaintenanceDate = CastDBNull.To <DateTime>(value, DateTime.Now); break; case "metertypeid": this.MeterTypeId = CastDBNull.To <string>(value, ""); break; case "metersizeid": this.MeterSizeId = CastDBNull.To <string>(value, ""); break; case "meterprotocolid": this.MeterProtocolId = CastDBNull.To <string>(value, ""); break; case "dmzid": this.DMZId = CastDBNull.To <string>(value, ""); break; case "cityid": this.CityId = CastDBNull.To <string>(value, ""); break; case "macaddress": this.MacAddress = CastDBNull.To <string>(value, ""); break; case "createdby": this.CreatedBy = CastDBNull.To <string>(value, ""); break; case "editedby": this.EditedBy = CastDBNull.To <string>(value, ""); break; case "docdate": this.DocDate = CastDBNull.To <DateTime>(value, DateTime.Now); break; case "show": this.Show = CastDBNull.To <int>(value, 0); break; case "lockcount": this.LockCount = CastDBNull.To <int>(value, 0); break; default: //null; break; } }