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