/// <summary>
/// 网站公告
/// </summary>
/// <returns></returns>
public ActionResult HelpList(string path1 = "Login_register", int p = 1, int pageSize = 10)
{
StringBuilder str = new StringBuilder();
string TableName = "V_type_news";
string strFields = "newid,web_Type_menu_id,News_title,News_Key,news_Des,context,createtime,menu_name,path1,topmenuname,listcomm ";
string fldName = " newid desc";
string Sort = "desc";
string strWhere = " path1='" + path1 + "'";
DataTable dt = new DataTable();
B_PublicPageList o = new B_PublicPageList();
var RecordCount = 0;
dt = o.GetListByPage(TableName, strFields, fldName, pageSize, p, strWhere, out RecordCount);
string srtitle = "注册与登录";
if (dt.Rows.Count > 0)
{
srtitle = dt.Rows[0]["menu_name"].ToString();
}
ResponsePage rp = new ResponsePage();
rp.dataBody = dt;
rp.pageSize = pageSize;
rp.recordCount = RecordCount;
rp.pageCount = (RecordCount + pageSize - 1) / pageSize;
rp.currentCount = p;
ViewBag.srtitle = srtitle;
ViewBag.path1 = path1;
return(View(rp));
}
/// <summary>
/// 网站公告
/// </summary>
/// <returns></returns>
public ActionResult NoticeList(int p = 1, int pageSize = 10)
{
StringBuilder str = new StringBuilder();
string TableName = "V_type_news";
string strFields = "newid,web_Type_menu_id,News_title,News_Key,news_Des,context,createtime,menu_name,path1,topmenuname,listcomm ";
string fldName = " newid desc";
string Sort = "desc";
string strWhere = "web_Type_menu_id=17";
DataTable dt = new DataTable();
B_PublicPageList o = new B_PublicPageList();
var RecordCount = 0;
dt = o.GetListByPage(TableName, strFields, fldName, pageSize, p, strWhere, out RecordCount);
ResponsePage rp = new ResponsePage();
rp.dataBody = dt;
rp.pageSize = pageSize;
rp.recordCount = RecordCount;
rp.pageCount = (RecordCount + pageSize - 1) / pageSize;
rp.currentCount = p;
return(View(rp));
}
public static ResponsePage <List <Client> > Get(int size, int page, string search)
{
var res = new ResponsePage <List <Client> >();
res.data = new List <Client>();
try
{
using MySqlConnection connection = new MySqlConnection("server=localhost; Database=expenses; uid=admin; Pwd=database123;");
connection.Open();
MySqlCommand command = connection.CreateCommand();
MySqlTransaction transaction = connection.BeginTransaction();
command.Connection = connection;
command.Transaction = transaction;
var sql = $"select * from clients where identification like '%{search}%' limit {size} OFFSET {page-1}";
command.CommandText = sql;
var dr = command.ExecuteReader();
while (dr.Read())
{
if (dr != null)
{
var client = new Client();
client.id_client = Convert.ToInt32(dr["id_client"]);
client.name = Convert.ToString(dr["name"]);
client.identification = Convert.ToInt32(dr["identification"]);
client.phone = Convert.ToString(dr["phone"]);
client.loan = Convert.ToSingle(dr["loan"]);
client.time_limit = Convert.ToInt32(dr["time_limit"]);
client.interest_rate = Convert.ToSingle(dr["interest_rate"]);
client.payment_type = Convert.ToInt16(dr["payment_type"]);
client.days_added = Convert.ToInt16(dr["days_added"]);
client.created_on = Convert.ToDateTime(dr["created_on"]);
res.data.Add(client);
}
}
res.success = true;
res.size = size;
res.total = Count(search);
res.pages = (int)Math.Ceiling((decimal)res.total / (decimal)size);
dr.Close();
transaction.Commit();
}
catch (Exception ex)
{
res.errors.Add(ex.Message);
res.errors.Add(ex.StackTrace);
}
return(res);
}
private async Task <ResponsePage <ApiKey> > ListGroupApiKeysFunc(QueryOptions options)
{
try
{
var resp = await DeveloperApi.GetApiKeysOfGroupAsync(groupID : options.Id, limit : options.Limit, after : options.After, order : options.Order, include : options.Include);
var responsePage = new ResponsePage <ApiKey>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount);
responsePage.MapData <ApiKeyInfoResp>(resp.Data, ApiKey.Map);
return(responsePage);
}
catch (device_directory.Client.ApiException e)
{
throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent);
}
}
private async System.Threading.Tasks.Task <ResponsePage <QuotaHistory> > ListQuotaHistoryFunc(QueryOptions options)
{
try
{
var resp = await api.GetServicePackageQuotaHistoryAsync(limit : options.Limit, after : options.After);
var responsePage = new ResponsePage <QuotaHistory>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount);
responsePage.MapData <ServicePackageQuotaHistoryItem>(resp.Data, mapper.Map <ServicePackageQuotaHistoryItem, QuotaHistory>);
return(responsePage);
}
catch (billing.Client.ApiException e)
{
throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent);
}
}
private async Task <ResponsePage <PreSharedKey> > ListPreSharedKeysFunc(QueryOptions options)
{
try
{
var resp = await api.ListPreSharedKeysAsync(limit : options.Limit, after : options.After);
var responsePage = new ResponsePage <PreSharedKey>(after: resp.ContinuationMarker, hasMore: resp.HasMore, totalCount: null);
responsePage.MapData <connector_bootstrap.Model.PreSharedKeyWithoutSecret>(resp.Data, PreSharedKey.Map);
return(responsePage);
}
catch (connector_bootstrap.Client.ApiException e)
{
throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent);
}
}
public static ResponsePage <List <Expense> > Get(int size, int page)
{
var res = new ResponsePage <List <Expense> >();
res.data = new List <Expense>();
try
{
using MySqlConnection connection = new MySqlConnection("server=localhost; Database=expenses; uid=admin; Pwd=database123;");
connection.Open();
MySqlCommand command = connection.CreateCommand();
MySqlTransaction transaction = connection.BeginTransaction();
command.Connection = connection;
command.Transaction = transaction;
var sql = $"select * from expenses.expenses limit {size} OFFSET {page - 1}";
command.CommandText = sql;
var dr = command.ExecuteReader();
while (dr.Read())
{
if (dr != null)
{
var expense = new Expense();
expense.id_expense = Convert.ToInt32(dr["id_expense"]);
expense.description = Convert.ToString(dr["description"]);
expense.value = Convert.ToInt32(dr["value"]);
expense.date = Convert.ToDateTime(dr["date"]);
res.data.Add(expense);
}
}
res.success = true;
res.size = size;
res.total = Count();
res.pages = (int)Math.Ceiling((decimal)res.total / (decimal)size);
dr.Close();
transaction.Commit();
}
catch (Exception ex)
{
res.errors.Add(ex.Message);
res.errors.Add(ex.StackTrace);
}
return(res);
}
private async Task <ResponsePage <ConnectedDevice> > ListConnectedDevicesFunc(QueryOptions options)
{
try
{
var resp = await DeviceDirectoryApi.DeviceListAsync(limit : options.Limit, order : options.Order, after : options.After, filter : options.Filter?.FilterString, include : options.Include);
var respDevices = new ResponsePage <ConnectedDevice>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount);
foreach (var device in resp.Data)
{
respDevices.Add(ConnectedDevice.Map(device, this));
}
return(respDevices);
}
catch (device_directory.Client.ApiException e)
{
throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent);
}
}
private async Task <ResponsePage <ApiKey> > ListApiKeysFuncAsync(QueryOptions options = null)
{
if (options == null)
{
options = new QueryOptions();
}
try
{
var resp = await DeveloperApi.GetAllApiKeysAsync(limit : options.Limit, after : options.After, order : options.Order, include : options.Include, ownerEq : options.Filter.GetFirstValueByKey("owner_id"));
var responsePage = new ResponsePage <ApiKey>(after: resp.After, hasMore: resp.HasMore, resp.TotalCount);
responsePage.MapData <ApiKeyInfoResp>(resp.Data, ApiKey.Map);
return(responsePage);
}
catch (iam.Client.ApiException e)
{
throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent);
}
}
/// <summary>
/// Lists the device logs.
/// </summary>
/// <returns>The device logs.</returns>
/// <exception cref="CloudApiException">CloudApiException</exception>
/// <param name="options">Query options.</param>
private async Task <ResponsePage <DeviceEvent> > ListDeviceEventsFunc(QueryOptions options = null)
{
if (options == null)
{
options = new QueryOptions();
}
try
{
var resp = await Api.DeviceLogListAsync(limit : options.Limit, order : options.Order, after : options.After, filter : options.Filter?.FilterString, include : options.Include);
var responsePage = new ResponsePage <DeviceEvent>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount);
responsePage.MapData <DeviceEventData>(resp.Data, DeviceEvent.Map);
return(responsePage);
}
catch (device_directory.Client.ApiException e)
{
throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent);
}
}
private async Task <ResponsePage <Campaign> > ListCampaignsFunc(QueryOptions options = null)
{
if (options == null)
{
options = new QueryOptions();
}
try
{
var resp = await Api.UpdateCampaignListAsync(limit : options.Limit, order : options.Order, after : options.After, filter : options.Filter?.FilterString, include : options.Include);
var responsePage = new ResponsePage <Campaign>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount);
responsePage.MapData <UpdateCampaign>(resp.Data, Campaign.Map);
return(responsePage);
}
catch (update_service.Client.ApiException e)
{
throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent);
}
}
private async Task <ResponsePage <Group> > ListGroupsFunc(QueryOptions options = null)
{
if (options == null)
{
options = new QueryOptions();
}
try
{
var resp = await DeveloperApi.GetAllGroupsAsync(limit : options.Limit, after : options.After, order : options.Order, include : options.Include);
var responsePage = new ResponsePage <Group>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount);
responsePage.MapData(resp.Data, Group.Map);
return(responsePage);
}
catch (device_directory.Client.ApiException e)
{
throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent);
}
}
private async Task <ResponsePage <FirmwareManifest> > ListFirmwareManifestsFunc(QueryOptions options = null)
{
if (options == null)
{
options = new QueryOptions();
}
try
{
var resp = await Api.FirmwareManifestListAsync(limit : options.Limit, order : options.Order, after : options.After, filter : options.Filter?.FilterString, include : options.Include);
var responsePage = new ResponsePage <FirmwareManifest>(resp.After, resp.HasMore, resp.TotalCount);
responsePage.MapData <update_service.Model.FirmwareManifest>(resp.Data, FirmwareManifest.Map);
return(responsePage);
}
catch (update_service.Client.ApiException e)
{
throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent);
}
}
private async Task <ResponsePage <Metric> > ListMetricsFunc(MetricQueryOptions options)
{
try
{
var resp = await StatisticsApi.V3MetricsGetAsync(
include : options.Include,
interval : options.Interval,
start : options.Start,
end : options.End,
period : options.Period,
limit : options.Limit,
after : options.After,
order : options.Order);
var responsePage = new ResponsePage <Metric>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount);
responsePage.MapData <statistics.Model.Metric>(resp.Data, Metric.Map);
return(responsePage);
}
catch (statistics.Client.ApiException e)
{
throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent);
}
}
private async Task <ResponsePage <User> > ListUsersFunc(QueryOptions options = null)
{
if (options == null)
{
options = new QueryOptions();
}
try
{
var resp = await adminApi.GetAllUsersAsync(limit : options.Limit, order : options.Order, after : options.After, include : options.Include, statusEq : options.Filter.GetFirstValueByKey("status", FilterOperator.Equals), statusIn : options.Filter.GetFirstValueByKey("status", FilterOperator.In), statusNin : options.Filter.GetFirstValueByKey("status", FilterOperator.NotIn));
var responsePage = new ResponsePage <User>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount);
responsePage.MapData <UserInfoResp>(resp.Data, User.Map);
return(responsePage);
}
catch (device_directory.Client.ApiException e)
{
throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent);
}
catch (Exception)
{
throw;
}
}
public Home(UserData Userinfo, string uri)
{
InitializeComponent();
try
{
User = Userinfo;
this.uri = uri;
Loaded += Home_Loaded;
string NameChip = "Hi, " + User.Firstname + " " + User.Surname;
stat = new StatusModel
{
UserId = User.UserId,
Status = "Active"
};
connection = new HubConnectionBuilder()
.WithUrl(uri + "/updates")
.Build();
connection.Closed += async(error) =>
{
await Task.Delay(5000);
await ServerConnect();
await signalService.SendStatus(stat);
CloseHomeWindow?.Invoke();
};
this.StateChanged += Home_StateChanged;
signalService = new ConnService(connection);
signalService.StatusReceived += Cos_StatusReceived;
signalService.AlertReceived += CasesPage_AlertEvent;
Task.Run(async() =>
{
await ServerConnect();
});
persons = new PersonnelInfoViewModel();
schedule = new SchedulePage();
paypage = new PaymentPage();
loadingWindow = new LoadingWindow();
signalService.NewUserSync += async(string id) =>
{
await signalService.ConnectionSync(User.UserId);
};
signalService.DisconnectUser += (string obj) =>
{
Task.Run(async() =>
{
await signalService.SendStatus(stat);
await signalService.UpdateStatus(stat.Status, stat.UserId);
});
};
LoadMap();
HistoryPage.historyItem += (HistoryModel obj) =>
{
MainHolder.Visibility = Visibility.Visible;
browser.Visibility = Visibility.Collapsed;
Dispatcher.Invoke(() => MainHolder.NavigationService.Navigate(new CaseDetails(obj)));
};
this.Closing += MainWindow_Closing;
sService = signalService;
Respond += (string[] details) =>
{
Dispatcher.Invoke(() =>
{
ResponseView.Visibility = Visibility.Visible;
browser.Visibility = Visibility.Collapsed;
var rpage = new ResponsePage(User, signalService, details);
Response.NavigationService.Navigate(rpage);
rpage.BtnClicked += (string obj) =>
{
switch (obj)
{
case "Close":
ResponseView.Visibility = Visibility.Collapsed;
browser.Visibility = Visibility.Visible;
RestoreButton.Visibility = Visibility.Visible;
break;
case "restart":
CasesModel alert = new CasesModel()
{
DateTime = Convert.ToDateTime(details[5]),
Location = details[2],
VHTCode = details[4],
Description = details[6],
Village = details[3],
Status = "ongoing",
CaseId = details[0],
Category = details[7]
};
Dispatcher.Invoke(async() => {
await signalService.RestartResponse(details[0]);
});
break;
case "completed":
Dispatcher.Invoke(() => {
RadWindow.Confirm("Are you sure you want to mark case as completed?", async delegate
{
await signalService.CompletedCase(details[0]);
RadWindow.Alert("This case has been marked as completed.", MarkCaseCompleted);
});
});
break;
}
};
});
};
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static List <Property> GetPropertys(QueryRequest Query, out ResponsePage Page)
{
throw new Exception("接口未实现");
}
