public bool SearchExistingUnit(CellDeviceModel model)
{
// 20190604 - Search Epec/Resident for the phone and equipId
// Fields: e.equip_phone,e.other_phone,r.phone_1,r.phone_2, r.phone_3
// Fields: e.equip_id
EpecLocationModel el = null;
//1. check the unit first
el = SearchHomeByUnit(model.UNIT_ID);
if (el != null)
{
return(true);
}
//2. search epec for phone
el = SearchHomeByPhone(model.MDN);
if (el != null)
{
return(true);
}
//3 Search resident phone fields
el = SearchResidentByPhone(model.MDN);
if (el != null)
{
return(true);
}
return(false);
}
public CellDeviceModel GetCellDeviceByUnitId(string unitId)
{
CellDeviceModel model = null;
StringBuilder sql = new StringBuilder();
sql.AppendFormat("SELECT * FROM CELL_DEVICE_ACTIVE WHERE UNIT_ID = {0}", unitId);
try
{
var data = _provider.GetData(sql.ToString(), null);
LogInfo(string.Format("Fetching cell device for unit Id {0}. QUERY: {1}", unitId, sql.ToString()));
if (data != null)
{
var row = data.Rows[0];
model = new CellDeviceModel(row);
LogInfo(string.Format("Creating cell device model for unit {0}", unitId));
}
}
catch (Exception e)
{
LogError(e);
}
return(model);
}
public List <CellDeviceModel> GetCellDevices()
{
List <CellDeviceModel> model = new List <CellDeviceModel>();
StringBuilder sql = new StringBuilder();
sql.AppendFormat("SELECT * FROM CELL_DEVICE_ACTIVE WHERE TEST = 'True'");
try
{
var data = _provider.GetData(sql.ToString(), null);
LogInfo(string.Format("Fetching all cell devices. QUERY: {0}", sql.ToString()));
if (data != null)
{
foreach (DataRow dr in data.Rows)
{
var item = new CellDeviceModel(dr);
model.Add(item);
}
LogInfo(string.Format("Fetching all cell device models"));
}
}
catch (Exception e)
{
LogError(e);
}
return(model);
}
public frmUpdatePhone(CellDeviceModel model)
{
InitializeComponent();
this.Load += FrmUpdatePhone_Load;
btnCancel.Click += BtnCancel_Click;
btnSave.Click += BtnSave_Click;
_selectedDevice = model;
}
private void _frmUpdatePhone_OnPhoneNumberUpdated(bool isCompleted, CellDeviceModel model)
{
if (isCompleted)
{
MessageBox.Show(string.Format("Successfully updated phone number to {0} for unit {1} ", model.MDN, model.UNIT_ID));
// clear search
txtUnitId.Clear();
txtUnitType.Clear();
txtIMEI.Clear();
txtSerialNum.Clear();
txtUnitId.Focus();
grdSearchResult.DataSource = null;
}
}
void SetUnitTestMode(CellDeviceModel cellDevice)
{
if (cellDevice != null)
{
//change the unit to the opposite of currnet status
var mode = TESTMODE.OFF;
switch (cellDevice.TEST)
{
case true:
mode = TESTMODE.OFF;
break;
case false:
mode = TESTMODE.ON;
var isExisting = HomeService.Instance.SearchExistingUnit(cellDevice);
if (isExisting)
{
return;
}
break;
}
bool isSuccess = false;
switch (cellDevice.OTHER.ToLower())
{
case "mytrex lte":
isSuccess = SendToMytrex(mode, cellDevice.UNIT_ID.ToString(), cellDevice.SERIALNO);
break;
case "anelto lte":
case "anelto otg":
isSuccess = SendToAnelto(mode, cellDevice.UNIT_ID.ToString());
break;
default:
break;
}
if (isSuccess)
{
CellDeviceService.Instance.UpdateCellDeviceStatus(cellDevice.ID, mode == TESTMODE.ON ? true : false);
}
}
}
public bool UpdateDevicePhone(CellDeviceModel model)
{
bool isUdpated = true;
string sql = string.Format("UPDATE CELL_DEVICE_ACTIVE SET MDN = '{0}' WHERE ID = {1}", model.MDN, model.ID);
try
{
_provider.ExecuteNonSPQuery(sql.ToString(), null);
LogInfo(string.Format("Updating cell device {0} phone number to {1}", model.UNIT_ID, model.MDN));
}
catch (Exception e)
{
LogError(e);
isUdpated = false;
}
return(isUdpated);
}
static void Main(string[] args)
{
//AneltoAPI api = new AneltoAPI();
//var table = FileHelper.ReadCSVFileToTable(@"e:\AneltoUpdate.csv",',', true);
//Parallel.ForEach(table.AsEnumerable(), row =>
//{
// var model = new AneltoSubscriberUpdateRequest();
// model.ani = row[0].ToString();
// model.account = row[1].ToString();
// var response = api.SubscriberCreateUpdate(model);
// Console.WriteLine(response);
//});
var cellDevice = new CellDeviceModel();
//cellDevice.UNIT_ID = 820001;
cellDevice.MDN = "4172313490";
var isExisting = HomeService.Instance.SearchExistingUnit(cellDevice);
Console.WriteLine(isExisting.ToString());
}
