public bool UpdateTowerMessage(AssetsViewDTO Tower)
{
//var client = new SmartTowerIntegrationServiceClient();
TowerMessageDTO towerMessage = new TowerMessageDTO
{
ArabicMessage = SelectedAction.MessageDescription,
EnableNotification = true,
MessageId = SelectedAction.MessageId,
MessageType = 1,
MyLastUpdate = DateTime.Now,
TowerId = SelectedAction.Location,
MixedMessage = "",
EnglishMessage = "",
IncidentImage = ""
};
//var result = client.UpdateTowerCurrentMessageAsync(towerMessage);
if (Tower.SelectedAction != null)
{
_client.UpdateAssetValueAsync(Tower.ItemId, Tower.SelectedAction.Description);
}
SmartTowerDAL smartTowerDAL = new SmartTowerDAL();
return(smartTowerDAL.UpdateTowerCurrentMessage(towerMessage)); //result.Result;
}
public bool UpdateTowerCurrentMessage(TowerMessageDTO TowerMessage)
{
SqlConnection connection = new SqlConnection(connectionString);
try {
connection.Open();
SqlCommand myCommand1 = new SqlCommand("UPDATE traffic_static SET NotificationEnabled = '0' " + "WHERE location = @location", connection);
myCommand1.Parameters.AddWithValue("@location", TowerMessage.TowerId);
var count1 = myCommand1.ExecuteNonQuery();
SqlCommand myCommand2 = new SqlCommand("UPDATE traffic_static SET NotificationEnabled = '1' " + "WHERE MessageID =@MessageID And location = @location", connection);
myCommand2.Parameters.AddWithValue("@location", TowerMessage.TowerId);
myCommand2.Parameters.AddWithValue("@MessageID", TowerMessage.MessageId);
var count2 = myCommand2.ExecuteNonQuery();
return(count2 > 0);
}
catch (Exception) {
return(false);
}
finally {
connection.Close();
}
}
public bool UpdateTowerCurrentMessage(TowerMessageDTO TowerMessage)
{
List <string> pUsers = new UsersDAL().GetActivePublicUsers().Select(x => x.NotificationToken).ToList();
if (pUsers != null)
{
new ServiceLayer().SendNotification(pUsers, TowerMessage.ArabicMessage);
}
SmartTowerDAL smartTowerDAL = new SmartTowerDAL();
return(smartTowerDAL.UpdateTowerCurrentMessage(TowerMessage));
}
public TowerMessageDTO GetTowerCurrentMessage(string TowerId)
{
var con = new SqlConnection(connectionString);
try
{
con.Open();
string strSql = "select * from traffic_static where location='" + TowerId + "' And NotificationEnabled = '1'";
SqlDataAdapter dadapter = new SqlDataAdapter {
SelectCommand = new SqlCommand(strSql, con)
};
DataSet dset = new DataSet();
dadapter.Fill(dset);
con.Close();
var table = dset.Tables[0];
TowerMessageDTO returnMsg = new TowerMessageDTO();
foreach (DataRow dataRow in table.Rows)
{
returnMsg = new TowerMessageDTO
{
TowerId = dataRow["location"].ToString(),
ArabicMessage = dataRow["MessageDescription"].ToString(),
MixedMessage = dataRow["MessageDescription"].ToString(),
EnglishMessage = dataRow["MessageDescription"].ToString(),
IncidentImage = "",
MessageId = dataRow["MessageID"].ToString(),
MessageType = 1,
MyLastUpdate = DateTime.Now,
EnableNotification = true
};
}
return(returnMsg);
}
catch (Exception e)
{
return(null);
}
finally
{
con.Close();
}
}