public void Adicionar(Comando comando)
{
using (var conn = new NpgsqlConnection(connString))
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO acesso.automacao_log (setor, equipamento, controle, comando) VALUES (@setor, @equipamento, @controle, @comando) RETURNING filedate, num";
cmd.Parameters.AddWithValue("setor", comando.Setor);
cmd.Parameters.AddWithValue("equipamento", comando.Equipamento);
cmd.Parameters.AddWithValue("controle", comando.Controle);
cmd.Parameters.AddWithValue("comando", comando.NomeComando);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
DataRow linha = NewRow();
linha["filedate"] = reader["filedate"].ToString();
linha["num"] = reader["num"].ToString();
linha["setor"] = comando.Setor;
linha["equipamento"] = comando.Equipamento;
linha["controle"] = comando.Controle;
Rows.Add(linha);
}
DefaultView.Sort = "num desc";
DefaultView.ToTable();
}
}
}
}
public TermsPopupPage()
{
BackgroundColor = Colors.BulletinPopupBackground;
var btnClose = DefaultView.CloseButton();
btnClose.HorizontalOptions = LayoutOptions.Center;
btnClose.VerticalOptions = LayoutOptions.End;
btnClose.Margin = new Thickness(20);
btnClose.AddTouch((sender, args) => { PopupNavigation.Instance.PopAsync(); });
Content = new Grid()
{
BackgroundColor = Colors.Background,
Children =
{
new TermsScrollView()
{
Padding = new Thickness(0, 0, 0, FooterHeight)
},
new GradientView(Colors.Background)
{
VerticalOptions = LayoutOptions.End,
Orientation = StackOrientation.Vertical,
HeightRequest = FooterHeight,
InputTransparent = true,
ScaleY = -1,
},
btnClose,
}
};
}
public DebugPopup(TestingViewModel testingViewModel)
{
BackgroundColor = Color.FromRgba(0, 0, 0, 0.5f);
var btnClose = DefaultView.CloseButton();
btnClose.HorizontalOptions = LayoutOptions.Center;
btnClose.VerticalOptions = LayoutOptions.End;
btnClose.Margin = new Thickness(20);
btnClose.AddTouch((sender, args) => { PopupNavigation.Instance.PopAsync(); });
var scrollView = new ScrollView
{
Orientation = ScrollOrientation.Vertical,
Content = new TestingView {
BindingContext = testingViewModel
},
};
Content = new Grid()
{
BackgroundColor = Colors.Background,
Children =
{
scrollView,
btnClose,
}
};
}
View IViewCreationCommand.CreateView(IServiceProvider serviceProvider)
{
if (this.Factory == null)
{
IViewFactory factory;
if (!this.extensionData.InstantiateFactory(this.TypeName, out factory))
{
return(null);
}
this.Factory = factory;
}
object viewOrContent = this.Factory.CreateView(this.RegisteredName, serviceProvider);
View view = viewOrContent as View;
if (view == null)
{
view = new DefaultView(viewOrContent);
}
view.ViewCreationCommand = this;
view.Initialize(serviceProvider);
return(view);
}
public DefaultController(DefaultView myView, DefaultModel myModel)
{
this.myView = myView;
this.myModel = myModel;
myView.myController = this;
}
public void TestInstance()
{
var userControl = new DefaultView();
Assert.IsInstanceOfType(userControl, typeof(DefaultView));
Assert.IsInstanceOfType(userControl, typeof(UserControl));
Assert.IsInstanceOfType(userControl, typeof(IUserControl));
}
public void TestPropertyCurrentPage()
{
TestViewModelProperties <MainViewModel>(
"CurrentPage", viewModel =>
{
var item = new DefaultView();
viewModel.CurrentPage = item;
Assert.AreEqual(item, viewModel.CurrentPage);
});
}
private void LoadViews()
{
_defaultView = new DefaultView(_detector);
_defaultView.Dock = DockStyle.Fill;
this.panelOfDefaultView.Controls.Add(_defaultView);
_paramView = new ParamView(_detector.ProductManager);
_paramView.Dock = DockStyle.Fill;
this.panelOfParamView.Controls.Add(_paramView);
this.panelOfParamView.Hide();
return;
}
/// <summary>
/// 获取指定序号的医嘱对应的医嘱视图
/// </summary>
/// <param name="serialNo"></param>
/// <returns></returns>
public OrderView GetOrderViewBySerialNo(int serialNo)
{
int index = DefaultView.IndexOf(serialNo);
if (index > -1)
{
return(DefaultView[index]);
}
else
{
return(null);
}
}
public ActionResult Register(RegisterViewModel model)
{
if (DefaultView.GetRandomCapcha() != model.CaptchaCode)
{
ViewBag.message = "Mã xác minh không đúng.";
return(View());
}
if (model.ConfirmPassword != model.Password)
{
ViewBag.message = "Mật khẩu xác nhận không giống.";
return(View());
}
//get internal user with email & code
IDbConnection dbConn = new OrmliteConnection().openConn();
var user = AuthUser.GetByCode(model.Email, LoginType.InternalLogin, null, false);
if (user != null)
{
ViewBag.message = "Tài khoản đã tồn tại";
return(View());
}
//create user internal
user = new AuthUser();
user.password = SqlHelper.GetMd5Hash(model.Password);
user.createdat = DateTime.Now;
user.updatedat = DateTime.Now;
user.entrycode = model.Email;
user.entryname = model.Email;
user.fullname = model.Email;
user.email = model.Email;
user.logintype = (int)LoginType.InternalLogin;
user.loginprovider = "";
user.isactive = true;
user.entryid = user.AddOrUpdate(user.entryid);
var identity = new ClaimsIdentity(new[] {
new Claim(ClaimTypes.Name, user.fullname),
new Claim(ClaimTypes.Email, string.IsNullOrEmpty(user.email)?"":user.email),
new Claim(ClaimTypes.PrimarySid, user.entryid.ToString())
},
"ApplicationCookie");
var ctx = Request.GetOwinContext();
var authManager = ctx.Authentication;
authManager.SignIn(identity);
return(RedirectToAction("Index", "Home"));
}
public void UpdateValue(int seriesIndex, DateTime t, object value, string flag)
{
if (this.DefaultView.Sort == "")
{
this.DefaultView.Sort = this.Columns[0].ColumnName;
this.DefaultView.ApplyDefaultSort = true;
}
int rowIndex = DefaultView.Find(t);
//int idxSeries = m_seriesIndexList.IndexOf(seriesIndex);
//if (idxSeries < 0)
// throw new InvalidOperationException("Internal Error: SeriesIndex :" + seriesIndex);
//DefaultView[rowIndex].Row[idxSeries + 1] = value;
}
//Bill checkout
public ActionResult SaveBill(FE_Delivery Item)
{
//valid
if (DefaultView.GetRandomCapcha() != Item.CaptchaCode)
{
return(Json(new { success = false, message = "Mã xác minh không đúng." }));
}
var userID = ViewData["AuthUser"] == null ? 0 : ((AuthUser)ViewData["AuthUser"]).entryid;
DefaultView.FE_Bill.BindFullBill(userID, Item);
int resutl = FE_Bill.SaveBill(userID);
return(Json(new { success = resutl > 0 }));
}
public ActionResult Login(LogOnModel model, string returnUrl)
{
returnUrl = string.IsNullOrEmpty(returnUrl) ? "" : returnUrl;
if (DefaultView.GetRandomCapcha() != model.CaptchaCode)
{
ViewBag.message = "Mã xác minh không đúng.";
return(View());
}
if (ModelState.IsValid)
{
IDbConnection dbConn = new OrmliteConnection().openConn();
var user = SSKD.Areas.Admin.Models.AuthUser.GetByCode(model.UserName, null, false);
if (new AccountMembershipService().ValidateUser(model.UserName, model.Password))
{
//FormsAuthentication.SetAuthCookie(model.UserName, true);
//FormsAuthentication.SetAuthCookie(user.Id.ToString(), true);
var identity = new ClaimsIdentity(new[] {
new Claim(ClaimTypes.Name, user.entrycode),
new Claim(ClaimTypes.Email, string.IsNullOrEmpty(user.email)?"":user.email),
new Claim(ClaimTypes.PrimarySid, user.entryid.ToString())
},
"ApplicationCookie");
var ctx = Request.GetOwinContext();
var authManager = ctx.Authentication;
authManager.SignIn(identity);
if (Url.IsLocalUrl(returnUrl) &&
returnUrl.Length > 1 &&
returnUrl.StartsWith("/") &&
!returnUrl.StartsWith("//") &&
!returnUrl.StartsWith("/\\"))
{
return(Redirect(returnUrl));
}
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", "Tên đăng nhập hoặc mật khẩu không đúng.");
}
}
return(View(model));
}
private void OnSearch()
{
DefaultView = CollectionViewSource.GetDefaultView(DefaultView);
if (TextVisiblity == Visibility.Visible)
{
if (SelectedFilter.Equals("Šifri"))
{
DefaultView.Filter =
w => ((Drink)w).SifraPica.ToUpper().Contains(TextSearch.ToUpper());
}
else if (SelectedFilter.Equals("Nazivu"))
{
DefaultView.Filter =
w => ((Drink)w).NazivPica.ToUpper().Contains(TextSearch.ToUpper());
}
}
else if (DigitVisibility == Visibility.Visible)
{
try
{
Double kolicina = Double.Parse(NumberSearch);
DefaultView.Filter =
w => ((Drink)w).AcutelPrice == kolicina;
}
catch (Exception ex)
{
Console.WriteLine($"Greska : {ex.Message}");
}
}
else if (ComboVisiblity == Visibility.Visible)
{
if (SelectedFilter.Equals("Tipu"))
{
DefaultView.Filter =
w => ((Drink)w).TipPica.ToString().Contains(SelectedEnum);
}
else
{
DefaultView.Filter =
w => ((Drink)w).Poreklo.ToString().Contains(SelectedEnum);
}
}
DefaultView.Refresh();
}
public FrontPageViewModel()
{
TBlockTitle = "Euston Leisure Message Filtering Service";
BtnSMSContent = "Add SMS";
BtnStandardEmailContent = "Add Email";
BtnSIREmailContent = "Add Incident Report";
BtnTweetContent = "Add Tweet";
BtnExitContent = "Exit Application";
BtnListDisplay = "Display Lists";
BtnSMSCommand = new RelayCommand(BtnSMSButtonClick);
BtnStandardEmailCommand = new RelayCommand(BtnStandardEmailButtonClick);
BtnSIREmailCommand = new RelayCommand(BtnSIREmailButtonClick);
BtnTweetCommand = new RelayCommand(BtnTweetButtonClick);
BtnListDisplayCommand = new RelayCommand(BtnListDisplayClick);
ContentControlBinding = new DefaultView();
}
//Bill checkout
public async Task <ActionResult> SaveContactRequest(FE_ContactRequest Item)
{
//valid
if (DefaultView.GetRandomCapcha() != Item.CaptchaCode)
{
return(Json(new { success = false, message = "Mã xác minh không đúng." }));
}
var userID = ViewData["AuthUser"] == null ? 0 : ((AuthUser)ViewData["AuthUser"]).entryid;
int resutl = FE_ContactRequest.SaveContactRequest(userID, Item);
//send email
string subject = "[sskd] - vừa có 1 đơn hàng mới";
//send ContactEmail
await sendContactEmail(new List <string>() { ConfigurationManager.AppSettings.Get("EmailContact").ToString() }, subject, Item);
return(Json(new { success = resutl > 0 }));
}
public CardView(View content)
{
HeightRequest = 200;
CornerRadius = Sizes.CornerRadius;
BackgroundColor = Colors.InfoPopupBackground;
HasShadow = true;
BorderColor = Device.RuntimePlatform == Device.Android
? Color.FromRgba(0, 0, 0, 0.3f)
: Color.Transparent;
var btnClose = DefaultView.CloseButton();
btnClose.HorizontalOptions = LayoutOptions.Center;
btnClose.VerticalOptions = LayoutOptions.End;
btnClose.Margin = new Thickness(0, 0, 0, 20);
btnClose.AddTouch((sender, args) => OnClose());
Padding = 0;
content.Margin = new Thickness(
content.Margin.Left,
content.Margin.Top,
content.Margin.Right,
Math.Max(CornerRadius, content.Margin.Bottom));
Content = new Grid()
{
Padding = 0,
Children =
{
content,
new GradientView(Colors.InfoPopupBackground)
{
VerticalOptions = LayoutOptions.End,
HeightRequest = FooterHeight,
Orientation = StackOrientation.Vertical,
InputTransparent = true,
ScaleY = -1,
Margin = new Thickness(2, CornerRadius),
},
btnClose,
}
};
}
public bool Check()
{
if (Rows.Count > 2)
{
var newMarking = DefaultView.ToTable();
for (var i = 1; i < newMarking.Rows.Count; i++)
{
var previousRow = newMarking.Rows[i - 1];
var currentRow = newMarking.Rows[i];
if ((previousRow[_beginColumn.ColumnName] is DBNull) && (previousRow[_endColumn.ColumnName] is DBNull))
{
return(false);
}
var begin = Convert.ToInt32(previousRow[_beginColumn.ColumnName]);
var end = Convert.ToInt32(previousRow[_endColumn.ColumnName]);
if (begin - end > 0)
{
return(false);
}
if (currentRow[_endColumn.ColumnName] is DBNull)
{
return(false);
}
begin = Convert.ToInt32(currentRow[_beginColumn.ColumnName]);
end = Convert.ToInt32(previousRow[_endColumn.ColumnName]);
if ((begin - end) != 1)
{
return(false);
}
}
}
else
{
var begin = Convert.ToInt32(Rows[0][_beginColumn.ColumnName]);
int end = Convert.ToInt32(Rows[0][_endColumn.ColumnName]);
if (begin - end > 0)
{
return(false);
}
}
return(true);
}
public async Task <ActionResult> SaveContactRequest(FE_ContactRequest Item)
{
//valid
if (DefaultView.GetRandomCapcha() != Item.CaptchaCode)
{
return(Json(new { success = false, message = "Mã xác minh không đúng." }));
}
var userID = ViewData["AuthUser"] == null ? 0 : ((AuthUser)ViewData["AuthUser"]).entryid;
Item.Address = Item.Address ?? "";
int resutl = FE_ContactRequest.SaveContactRequest(userID, Item);
//string subject = "[Contact] Thông tin liên hệ";
string subject = "[" + ((TopicContact)Item.TopicContact).DescriptionAttr().ToString() + "]";
subject += " - " + Item.EntryName ?? "";
//send ContactEmail
await sendContactEmail(new List <string>() { ConfigurationManager.AppSettings.Get("EmailContact").ToString() }, subject, Item);
return(Json(new { success = resutl > 0 }));
}
public void Visit(Element element)
{
EmisijaRasporeda emisija = element as EmisijaRasporeda;
if (emisija.VrstaEmisije.MaksTrajanjeReklame >= 1)
{
if (Controller.trenutniPogled == 2)
{
BrojivView.IspisiPocetniBroj();
}
emisija.Ispisi();
suma = emisija.VrstaEmisije.MaksTrajanjeReklame + suma;
if (Controller.trenutniPogled == 2)
{
BrojivView.IspisiPrihodEmisije("Prihodi od emisija: " + suma);
}
if (Controller.trenutniPogled == 1)
{
DefaultView.IspisiPrihodEmisije("Prihodi od emisija: " + suma);
}
}
}
public SelectListViewModel()
{
TBlockTitle = "Select List to View";
BtnSMSContent = "View SMS'";
BtnStandardEmailContent = "View Standard Emails";
BtnSIREmailContent = "View Incident Reports";
BtnTweetContent = "View Tweets";
BtnTrendingListContent = "View Trending List";
BtnMentionListContent = "View Mentions List";
BtnSIRListContent = "View SIR List";
BtnSMSCommand = new RelayCommand(BtnSMSViewButtonClick);
BtnStandardEmailCommand = new RelayCommand(BtnEMailViewButtonClick);
BtnSIREmailCommand = new RelayCommand(BtnIncidentReportViewButtonClick);
BtnTweetCommand = new RelayCommand(BtnTweetViewButtonClick);
BtnTrendingListCommand = new RelayCommand(BtnTrendingListViewButtonClick);
BtnMentionListCommand = new RelayCommand(BtnMentionListViewButtonClick);
BtnSIRListCommand = new RelayCommand(BtnSIRListViewButtonClick);
ContentControlBinding = new DefaultView();
}
public override void LoadSettings()
{
try
{
if (Page.IsPostBack == false)
{
var portalTabs = TabController.GetPortalTabs(PortalId, Null.NullInteger, false, true);
//Add host tabs
if (UserInfo != null && UserInfo.IsSuperUser)
{
var hostTabs = new TabController().GetTabsByPortal(Null.NullInteger);
portalTabs.AddRange(hostTabs.Values);
}
ParentTab.Items.Clear();
foreach (var t in portalTabs)
{
if ((TabPermissionController.CanViewPage(t)))
{
ParentTab.AddItem(t.IndentedTabName, t.TabID.ToString(CultureInfo.InvariantCulture));
//ParentTab.Items.Add(new ListItem(t.IndentedTabName, t.TabID.ToString(CultureInfo.InvariantCulture)));
}
}
//ParentTab.Items.Insert(0, "");
ParentTab.InsertItem(0, "", "");
SelectDropDownListItem(ref ParentTab, "ParentTabID");
foreach (string val in ConsoleController.GetSizeValues())
{
//DefaultSize.Items.Add(new ListItem(Localization.GetString(val, LocalResourceFile), val));
DefaultSize.AddItem(Localization.GetString(val, LocalResourceFile), val);
}
SelectDropDownListItem(ref DefaultSize, "DefaultSize");
SelectDropDownListItem(ref modeList, "Mode");
if (Settings.ContainsKey("AllowSizeChange"))
{
AllowResize.Checked = Convert.ToBoolean(Settings["AllowSizeChange"]);
}
foreach (var val in ConsoleController.GetViewValues())
{
//DefaultView.Items.Add(new ListItem(Localization.GetString(val, LocalResourceFile), val));
DefaultView.AddItem(Localization.GetString(val, LocalResourceFile), val);
}
SelectDropDownListItem(ref DefaultView, "DefaultView");
if (Settings.ContainsKey("IncludeParent"))
{
IncludeParent.Checked = Convert.ToBoolean(Settings["IncludeParent"]);
}
if (Settings.ContainsKey("AllowViewChange"))
{
AllowViewChange.Checked = Convert.ToBoolean(Settings["AllowViewChange"]);
}
if (Settings.ContainsKey("ShowTooltip"))
{
ShowTooltip.Checked = Convert.ToBoolean(Settings["ShowTooltip"]);
}
if (Settings.ContainsKey("OrderTabsByHierarchy"))
{
OrderTabsByHierarchy.Checked = Convert.ToBoolean(Settings["OrderTabsByHierarchy"]);
}
if (Settings.ContainsKey("ConsoleWidth"))
{
ConsoleWidth.Text = Convert.ToString(Settings["ConsoleWidth"]);
}
SwitchMode();
}
}
catch (Exception exc) //Module failed to load
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}
public int Insert()
{
Hashtable empty = new Hashtable();
return(DefaultView.Insert(empty));
}
public int Delete()
{
Hashtable empty = new Hashtable();
return(DefaultView.Delete(empty, null));
}
public int Update()
{
Hashtable empty = new Hashtable();
return(DefaultView.Update(empty, empty, null));
}
public IEnumerable Select()
{
return(DefaultView.Select(DataSourceSelectArguments.Empty));
}
public DefaultView()
{
this.InitializeComponent();
View = this;
}
public DefaultView()
{
InitializeComponent();
View = this;
}
public override void LoadSettings()
{
try
{
if (Page.IsPostBack == false)
{
if (Settings.ContainsKey("ParentTabId") && !string.IsNullOrEmpty(Convert.ToString(Settings["ParentTabId"])))
{
var tabId = Convert.ToInt32(Settings["ParentTabId"]);
ParentTab.SelectedPage = TabController.Instance.GetTab(tabId, PortalId);
}
foreach (string val in ConsoleController.GetSizeValues())
{
//DefaultSize.Items.Add(new ListItem(Localization.GetString(val, LocalResourceFile), val));
DefaultSize.AddItem(Localization.GetString(val, LocalResourceFile), val);
}
SelectDropDownListItem(ref DefaultSize, "DefaultSize");
SelectDropDownListItem(ref modeList, "Mode");
if (Settings.ContainsKey("AllowSizeChange"))
{
AllowResize.Checked = Convert.ToBoolean(Settings["AllowSizeChange"]);
}
foreach (var val in ConsoleController.GetViewValues())
{
//DefaultView.Items.Add(new ListItem(Localization.GetString(val, LocalResourceFile), val));
DefaultView.AddItem(Localization.GetString(val, LocalResourceFile), val);
}
SelectDropDownListItem(ref DefaultView, "DefaultView");
if (Settings.ContainsKey("IncludeParent"))
{
IncludeParent.Checked = Convert.ToBoolean(Settings["IncludeParent"]);
}
if (Settings.ContainsKey("AllowViewChange"))
{
AllowViewChange.Checked = Convert.ToBoolean(Settings["AllowViewChange"]);
}
if (Settings.ContainsKey("ShowTooltip"))
{
ShowTooltip.Checked = Convert.ToBoolean(Settings["ShowTooltip"]);
}
if (Settings.ContainsKey("OrderTabsByHierarchy"))
{
OrderTabsByHierarchy.Checked = Convert.ToBoolean(Settings["OrderTabsByHierarchy"]);
}
if (Settings.ContainsKey("IncludeHiddenPages"))
{
IncludeHiddenPages.Checked = Convert.ToBoolean(Settings["IncludeHiddenPages"]);
}
if (Settings.ContainsKey("ConsoleWidth"))
{
ConsoleWidth.Text = Convert.ToString(Settings["ConsoleWidth"]);
}
SwitchMode();
}
}
catch (Exception exc) //Module failed to load
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}
public void MoveNext()
{
DefaultView.MoveCurrentToNext();
}
public void MoveLast()
{
DefaultView.MoveCurrentToLast();
}
