protected override void OnNavigatedTo(System.Windows.Navigation.NavigationEventArgs e)
{
// turn on antilock screen
PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled;
//Set BackGround
Random rand = new Random();
int n = rand.Next(1, 48);
// while (n == 6 || n == 13 || n == 45) { n = rand.Next(1, 51); }
String bgpath = "/Images/Backgrounds/bg" + n + ".jpg/";
BitmapImage bitmapImage = new BitmapImage(new Uri(bgpath, UriKind.Relative));
ImageBrush imageBrush = new ImageBrush();
imageBrush.ImageSource = bitmapImage;
imageBrush.Stretch = Stretch.UniformToFill;
imageBrush.AlignmentX = 0;
imageBrush.AlignmentY = 0;
bghandler.Background = imageBrush;
//Query Database
mRace = NavigationContext.QueryString["race"];
Debug.WriteLine("Race is " + mRace);
DB_Helper.connect();
built_in.ItemsSource = DB_Helper.get_Index_Built_In(mRace);
custom.ItemsSource = DB_Helper.get_Index_By_Author("Custom", mRace);
}
public void BuyCreditsDB(double amount_money, int credits, int id_user)
{
DB_Helper db = new DB_Helper();
db.Execute("exec BUY_CREDITS " + id_user + "," + amount_money + "," + credits);
MyUtils.RefreshUserRow();
}
public Olymps(DB_Connector connection, ApplicationEdit parent)
{
InitializeComponent();
_DB_Connection = connection;
_DB_Helper = new DB_Helper(_DB_Connection);
_Parent = parent;
cbDiplomaType.Items.AddRange(_DB_Helper.GetDictionaryItems(FIS_Dictionary.DIPLOMA_TYPE).Values.ToArray());
cbClass.SelectedItem = "10";
cbDiscipline.Items.AddRange(_DB_Helper.GetDictionaryItems(FIS_Dictionary.SUBJECTS).Values.ToArray());
cbCountry.Items.AddRange(_DB_Helper.GetDictionaryItems(FIS_Dictionary.COUNTRY).Values.ToArray());
Forms.ApplicationEdit.ODoc loadedDocument = _Parent.OlympicDoc;
if ((loadedDocument.olympType != null) && (loadedDocument.olympType != ""))
{
cbOlympType.SelectedItem = loadedDocument.olympType;
tbDocNumber.Text = loadedDocument.olympDocNumber.ToString();
if ((loadedDocument.diplomaType != null) && (loadedDocument.diplomaType != ""))
{
cbDiplomaType.SelectedItem = loadedDocument.diplomaType;
}
if (loadedDocument.olympID != 0)
{
tbOlympID.Text = loadedDocument.olympID.ToString();
cbOlympName.SelectedIndex = cbOlympName.FindString(_DB_Connection.Select(DB_Table.DICTIONARY_19_ITEMS, new string[] { "olympic_name" }, new System.Collections.Generic.List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("olympic_id", Relation.EQUAL, loadedDocument.olympID)
})[0][0].ToString());
cbOlympProfile.SelectedIndex = cbOlympProfile.FindString(loadedDocument.olympProfile);
}
else
{
if (loadedDocument.olympName != null)
{
cbOlympName.Text = loadedDocument.olympName;
}
cbOlympProfile.SelectedItem = loadedDocument.olympProfile;
}
if (loadedDocument.olympClass != 0)
{
cbClass.SelectedItem = loadedDocument.olympClass.ToString();
}
if ((loadedDocument.olympDist != null) && (loadedDocument.olympDist != ""))
{
cbDiscipline.SelectedItem = loadedDocument.olympDist;
}
if ((loadedDocument.country != null) && (loadedDocument.country != ""))
{
cbCountry.SelectedItem = loadedDocument.country;
}
}
}
public void BuyCreditsDB(double amount_money, int credits, int id_user)
{
DB_Helper db = new DB_Helper();
db.Execute("exec BUY_CREDITS " + id_user + "," + amount_money + "," + credits);
MyUtils.RefreshUserRow();
}
public static string GetUsersPage(int pageIndex, string filter)
{
filter = HttpUtility.UrlDecode(filter);
DB_Helper db = new DB_Helper();
string sql;
DataSet d = GetUsers(pageIndex, filter,out sql);
return d.GetXml();
}
public static string GetUsersPage(int pageIndex, string filter)
{
filter = HttpUtility.UrlDecode(filter);
DB_Helper db = new DB_Helper();
string sql;
DataSet d = GetUsers(pageIndex, filter, out sql);
return(d.GetXml());
}
public Campaigns(DB_Connector connection)
{
InitializeComponent();
_DB_Connection = connection;
_DB_Helper = new DB_Helper(_DB_Connection);
UpdateTableAndCombobox();
}
public DirectionsProfiles(DB_Connector connection)
{
InitializeComponent();
_DB_Connection = connection;
_DB_Helper = new DB_Helper(_DB_Connection);
UpdateTable();
cbDirections.ValueMember = "Value";
}
public Constants(DB_Connector connection, uint campaignID)
{
InitializeComponent();
_DB_Connection = connection;
_DB_Helper = new DB_Helper(_DB_Connection);
_CurrCampaignID = campaignID;
lbCurrentCampaign.Text = _DB_Connection.Select(DB_Table.CAMPAIGNS, new string[] { "name" }, new List <Tuple <string, Relation, object> >
{
new Tuple <string, Relation, object>("id", Relation.EQUAL, _CurrCampaignID)
})[0][0].ToString();
UpdateTable();
}
protected override void OnNavigatedTo(System.Windows.Navigation.NavigationEventArgs e)
{
// turn on antilock screen
PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled;
//Set BackGround
Random rand = new Random();
int n = rand.Next(1, 48);
// while (n == 6 || n == 13 || n == 45) { n = rand.Next(1, 51); }
String bgpath = "/Images/Backgrounds/bg" + n + ".jpg/";
BitmapImage bitmapImage = new BitmapImage(new Uri(bgpath, UriKind.Relative));
ImageBrush imageBrush = new ImageBrush();
imageBrush.ImageSource = bitmapImage;
LayoutRoot.Background = imageBrush;
//Current Build Panel
bgpath = "/Images/Backgrounds/bg_translucent.png/";
bitmapImage = new BitmapImage(new Uri(bgpath, UriKind.Relative));
imageBrush = new ImageBrush();
imageBrush.ImageSource = bitmapImage;
currentbuild_panel.Background = imageBrush;
//Query Database
mRace = NavigationContext.QueryString["race"];
buildname = NavigationContext.QueryString["buildname"];
index_id = Int16.Parse(NavigationContext.QueryString["index_id"]);
PageTitle.Text = buildname;
DB_Helper.connect();
builds = DB_Helper.get_Build_Order_By_Index_Id(index_id);
for (int i = 0; i < builds.Count; i++)
{
current_build_order.Add(DB_Helper.get_Object_SC_by_Obj_Id(builds.ElementAt <Build_Order>(i).Obj_Id).ElementAt <Object_SC>(0));
}
build.ItemsSource = current_build_order;
if (build.Items.Any())
{
selectedIndex = 0;
build.SelectedIndex = selectedIndex;
Object_SC item = (Object_SC)build.SelectedItem;
//items.Background = new SolidColorBrush(Colors.Orange);
Debug.WriteLine("Initial selected index is " + build.SelectedIndex);
Debug.WriteLine("selected name is " + item.Name);
Uri uri = new Uri(item.Imagesource, UriKind.Relative);
ImageSource imgSource = new BitmapImage(uri);
current_icon.Source = imgSource;
current_name.Text = item.Name;
current_mineral.Text = item.Mineral + "";
current_gas.Text = item.Gas + "";
current_food.Text = item.Food + "";
current_time.Text = item.Time + "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Form.Attributes["data-form"] = "message";
note.Visible = MyUtils.IsMale;
ID_USER = (int)MyUtils.GetUserField("ID_USER"); //will redirect to login page if not logged in
ID_USER_CHATWITH = Convert.ToInt32(Request.QueryString["id"]);
DB_Helper db = new DB_Helper();
int id_offer = db.ExecuteScalarInt("exec CAN_MESSAGE_WITH " + ID_USER + "," + ID_USER_CHATWITH, 0);
if (id_offer == 0)
{
id_offer = db.ExecuteScalarInt("select id_offer from offers where id_offer_state=404 and (id_user_from=" + ID_USER_CHATWITH + " and id_user_to=" + MyUtils.ID_USER + ") or (id_user_from=" + MyUtils.ID_USER + " and id_user_to=" + ID_USER_CHATWITH + ")", 0);
if (id_offer > 0)
{
Response.Redirect("/Account/Messages#" + id_offer, true);
return;
}
Response.Clear();
Response.Write("You don't have permission to send messages to this user.");
Response.End();
}
R = db.GetRow("exec GET_USER_PROFILE " + ID_USER + "," + ID_USER_CHATWITH);
if (R == null)
{
Response.Clear();
Response.Write("This user doesn't exist.");
Response.End();
}
Offer = db.GetRow("select amount from offers where (id_user_to=" + ID_USER + " and id_user_from=" + ID_USER_CHATWITH + ") or (id_user_to=" + ID_USER_CHATWITH + " and id_user_from=" + ID_USER + ")");
//do some magic here with ID_USER and ID_USER_CHATWITH
//.......................................................
//Example on how to insert message to DB
//SaveMessage2DB(10002, 10003, "testing.... ", "1,2,3,4");
//Example on how to get messages for user pair
//DataTable T = GetMessagesForUser(10002, 10003);
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (MyUtils.authenticate(LoginUser.UserName, LoginUser.Password, out membership) && !Utils.IsUserBan())
{
bool CreatePersistentCookie = this.LoginUser.RememberMeSet; //even if you close browser the account will stay logged in
if (!MyUtils.IsUserAdmin())
{
DB_Helper db = new DB_Helper();
db.Execute(string.Format("update Users set [lastlogin_time] = getdate(), ip_address={1} where id_user = {0}", MyUtils.ID_USER,MyUtils.safe(MyUtils.GetIP())));
}
FormsAuthentication.RedirectFromLoginPage(LoginUser.UserName, CreatePersistentCookie);
}
}
/// <summary>
/// Creates and adds a few ItemViewModel objects into the Items collection.
/// </summary>
public void LoadData(String mRace)
{
// Sample data; replace with real data
//this.Items.Add(new ItemViewModel() { Name = "runtime one", Mineral = 50, Vespene = 0, Supply = 2, BuildTime = 30 });
//this.Items.Add(new ItemViewModel() { Name = "runtime one", Mineral = 50, Vespene = 0, Supply = 2, BuildTime = 30 });
//this.Items.Add(new ItemViewModel() { Name = "runtime one", Mineral = 50, Vespene = 0, Supply = 2, BuildTime = 30 });
//this.Items.Add(new ItemViewModel() { Name = "runtime one", Mineral = 50, Vespene = 0, Supply = 2, BuildTime = 30 });
//this.Items.Add(new ItemViewModel() { Name = "runtime one", Mineral = 50, Vespene = 0, Supply = 2, BuildTime = 30 });
//this.Items.Add(new ItemViewModel() { Name = "runtime one", Mineral = 50, Vespene = 0, Supply = 2, BuildTime = 30 });
//Object_SC_Table = DB_Helper.get_Object_SC_by_Type(DB_Helper.UNIT);
//// List<Pushpin> pushpin = new List<Pushpin>();
//for (int i = 0; i < Object_SC_Table.Count; i++)
//{
// this.Items.Add(new ItemViewModel() { Name = Object_SC_Table[i].Name, Mineral = Object_SC_Table[i].Mineral, Vespene = Object_SC_Table[i].Gas, Supply = Object_SC_Table[i].Food, BuildTime = Object_SC_Table[i].Time });
//}
DB_Helper.connect();
//Load Units
Object_SC_Table = DB_Helper.get_Object_SC_by_Type_and_Race(mRace, DB_Helper.UNIT);
foreach (Object_SC obj in Object_SC_Table)
{
this.Units.Add(new ItemViewModel()
{
ObjId = obj.Obj_Id, Name = obj.Name, Mineral = obj.Mineral, Vespene = obj.Gas, Supply = obj.Food, BuildTime = obj.Time
});
}
//Load Buildings
Object_SC_Table.Clear();
Object_SC_Table = DB_Helper.get_Object_SC_by_Type_and_Race(mRace, DB_Helper.BUILDING);
foreach (Object_SC obj in Object_SC_Table)
{
this.Buildings.Add(new ItemViewModel()
{
ObjId = obj.Obj_Id, Name = obj.Name, Mineral = obj.Mineral, Vespene = obj.Gas, Supply = obj.Food, BuildTime = obj.Time
});
}
//Load Upgardes
Object_SC_Table.Clear();
Object_SC_Table = DB_Helper.get_Object_SC_by_Type_and_Race(mRace, DB_Helper.UPGRADE);
foreach (Object_SC obj in Object_SC_Table)
{
this.Upgrades.Add(new ItemViewModel()
{
ObjId = obj.Obj_Id, Name = obj.Name, Mineral = obj.Mineral, Vespene = obj.Gas, Supply = obj.Food, BuildTime = obj.Time
});
}
this.IsDataLoaded = true;
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (MyUtils.authenticate(LoginUser.UserName, LoginUser.Password, out membership) && !Utils.IsUserBan())
{
bool CreatePersistentCookie = this.LoginUser.RememberMeSet; //even if you close browser the account will stay logged in
if (!MyUtils.IsUserAdmin())
{
DB_Helper db = new DB_Helper();
db.Execute(string.Format("update Users set [lastlogin_time] = getdate(), ip_address={1} where id_user = {0}", MyUtils.ID_USER, MyUtils.safe(MyUtils.GetIP())));
}
FormsAuthentication.RedirectFromLoginPage(LoginUser.UserName, CreatePersistentCookie);
}
}
protected void Page_Load(object sender, EventArgs e)
{
DB_Helper db = new DB_Helper();
int v = db.ExecuteScalarInt("select email_verified from users where id_user="******"/Account/");
return;
}
if (!IsPostBack) txtEmail.Text = MyUtils.GetUserField("email").ToString();
}
public void LoadData(String mRace)
{
Units.Clear();
DB_Helper.connect();
//Load Units
Object_SC_Table = DB_Helper.get_Object_SC_by_Type_and_Race(mRace, DB_Helper.UNIT);
foreach (Object_SC obj in Object_SC_Table)
{
Units.Add(new ItemViewModel()
{
ObjId = obj.Obj_Id, Name = obj.Name, Path = obj.Imagesource, Strong1 = obj.Strong1, Strong2 = obj.Strong2, Strong3 = obj.Strong3, Weak1 = obj.Weak1, Weak2 = obj.Weak2, Weak3 = obj.Weak3
});
}
}
protected void Page_Load(object sender, EventArgs e)
{
DB_Helper db = new DB_Helper();
int id = Convert.ToInt32(Request.QueryString["id"]);
DataSet ds= db.GetDataSet("select dbo.CalculateCredits2Unlock(amount) as credits from offers where (id_user_from=" + id + " and id_user_to=" + MyUtils.ID_USER + ") or (id_user_from=" + MyUtils.ID_USER + " and id_user_to=" + id + ");select username from users where id_user=" + id);
cr = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
user = Convert.ToString(ds.Tables[1].Rows[0][0]);
bool not_enough_credits = cr > MyUtils.Credits;
nocredits.Visible = not_enough_credits;
confirm.Visible = !nocredits.Visible;
}
public void BuyCreditsDB(double amount_money, int credits, int id_user)
{
DB_Helper db = new DB_Helper();
db.Execute("exec BUY_CREDITS " + id_user + "," + amount_money + "," + credits);
List<string> p = new List<string>();
p.Add("emailtitle:Credits were added");
p.Add("line:We added " + credits + " credits to your account.");
p.Add("credits:" + credits);
p.Add("cost:" + amount_money.ToString("c2"));
p.Add("date:" + DateTime.Now.ToString("MM/dd/yyyy"));
p.Add("package:" + credits + " credit package");
RWorker.AddToEmailQueue("EMAIL_PAYMENT", MyUtils.ID_USER, null, false, p);
MyUtils.RefreshUserRow();
}
static DataTable GetMessagesForUser(int id_user, int id_user_with, int start_with_id = 0)
{
//IsFromMe gives 1 if the message was sent my me.
DB_Helper db = new DB_Helper();
string sql = "select " +
"(SELECT top 1 [username] FROM [dbo].[Users] where [id_user] = m.id_user_from) FromUser," +
"(SELECT top 1 [username] FROM[dbo].[Users] where[id_user] = m.id_user_to) ToUser, " +
"case when id_user_from=" + id_user +
" then 1 else 0 end as IsFromMe, * from messages m where ((id_user_from=" +
id_user + " and id_user_to=" + id_user_with + ") or (id_user_to=" + id_user + " and id_user_from=" + id_user_with + ")) and m.[id_message] >= " + start_with_id + " order by [time] desc";
sql += "; update messages set is_new = 0 where id_user_to =" + id_user + " and id_user_from = " + id_user_with + " and is_new = 1 and [id_message] >= " + start_with_id;
return(db.GetDataSet(sql).Tables[0]);
}
protected void Page_Load(object sender, EventArgs e)
{
DB_Helper db = new DB_Helper();
int id = Convert.ToInt32(Request.QueryString["id"]);
DataSet ds = db.GetDataSet("select dbo.CalculateCredits2Unlock(amount) as credits from offers where (id_user_from=" + id + " and id_user_to=" + MyUtils.ID_USER + ") or (id_user_from=" + MyUtils.ID_USER + " and id_user_to=" + id + ");select username from users where id_user=" + id);
cr = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
user = Convert.ToString(ds.Tables[1].Rows[0][0]);
bool not_enough_credits = cr > MyUtils.Credits;
nocredits.Visible = not_enough_credits;
confirm.Visible = !nocredits.Visible;
}
public InstitutionAchievementsEdit(DB_Connector connection)
{
InitializeComponent();
_DB_Connection = connection;
_DB_Helper = new DB_Helper(_DB_Connection);
foreach (var campaign in _DB_Connection.Select(DB_Table.CAMPAIGNS, "name"))
{
cbCampaign.Items.Add(campaign[0]);
}
cbAchievementType.DataSource = new BindingSource(_DB_Helper.GetDictionaryItems(FIS_Dictionary.IND_ACH_CATEGORIES), null);
cbAchievementType.DisplayMember = "Value";
cbAchievementType.ValueMember = "Value";
}
public Examinations(DB_Connector connection)
{
#region Components
InitializeComponent();
// Для отображения без компонента времени:
dataGridView_Date.ValueType = typeof(DateTime);
dataGridView_RegStartDate.ValueType = typeof(DateTime);
dataGridView_RegEndDate.ValueType = typeof(DateTime);
#endregion
_DB_Connection = connection;
_DB_Helper = new DB_Helper(_DB_Connection);
UpdateTable();
}
protected override void OnNavigatedTo(System.Windows.Navigation.NavigationEventArgs e)
{
// turn on antilock screen
PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled;
//Set BackGround
Random rand = new Random();
int n = rand.Next(1, 48);
// while (n == 6 || n == 13 || n == 45) { n = rand.Next(1, 51); }
String bgpath = "/Images/Backgrounds/bg" + n + ".jpg/";
BitmapImage bitmapImage = new BitmapImage(new Uri(bgpath, UriKind.Relative));
ImageBrush imageBrush = new ImageBrush();
imageBrush.ImageSource = bitmapImage;
bghandler.Background = imageBrush;
//Current Build Panel
bgpath = "/Images/Backgrounds/bg_translucent_darker.png/";
bitmapImage = new BitmapImage(new Uri(bgpath, UriKind.Relative));
imageBrush = new ImageBrush();
imageBrush.ImageSource = bitmapImage;
LayoutRoot.Background = imageBrush;
//Query Database
mRace = NavigationContext.QueryString["race"];
buildname = NavigationContext.QueryString["buildname"];
index_id = Int16.Parse(NavigationContext.QueryString["index_id"]);
PageTitle.Text = buildname;
DB_Helper.connect();
builds = DB_Helper.get_Build_Order_By_Index_Id(index_id);
for (int i = 0; i < builds.Count; i++)
{
Build_Order current_step = builds.ElementAt <Build_Order>(i);
Object_SC unit = DB_Helper.get_Object_SC_by_Obj_Id(current_step.Obj_Id).ElementAt <Object_SC>(0);
current_build_order.Add(new unitforBuildOrder(unit.Name, unit.Food, unit.Mineral, unit.Gas, unit.Time, unit.Imagesource, "@" + current_step.When, current_step.Note));
}
build.ItemsSource = current_build_order;
Before.Text = NavigationContext.QueryString["note"];
if (Before.Text == "")
{
Before_Button.Visibility = Visibility.Collapsed;
}
After.Text = NavigationContext.QueryString["notefooter"];
if (After.Text == "")
{
After_Button.Visibility = Visibility.Collapsed;
}
}
private static void EnsureFilterIsSaved(Filter f)
{
string user_filter = MyUtils.GetUserField("filter") as string;
string current_filter = f.ToString();
if (user_filter != current_filter)
{
DB_Helper db = new DB_Helper();
int id_user = MyUtils.ID_USER; //currently logged in user
if (f.IsDefault())
{
current_filter = "DEFAULT";
}
db.Execute("update users set filter=" + MyUtils.safe(current_filter) + " where id_user=" + id_user);
MyUtils.RefreshUserRow();
}
}
static DataTable SaveMessage2DBAndSelect(int id_user_from, int id_user_to, string message, string gift_list, int id_offer)
{
DB_Helper db = new DB_Helper();
string s = "";
if (MyUtils.IsFemale)
{
s = "select female_sent_msg from offers where id_offer=" + id_offer;
int female_sent_msg = db.ExecuteScalarIntCache(s, 0, 5);
if (female_sent_msg == 0)
{
db.Execute("update offers set female_sent_msg=1 where isnull(female_sent_msg,0)=0 and id_offer=" + id_offer + "; ");
DB_Helper.InvalidateCache("SQL_" + s);
}
}
return(db.GetDataSet("insert into messages (id_user_from,id_user_to,text,gift_list,id_offer) OUTPUT inserted.* values (" + id_user_from + "," + id_user_to + "," + MyUtils.safe(message) + "," + MyUtils.safe(gift_list) + "," + id_offer + ");").Tables[0]);
}
public void BuyCreditsDB(double amount_money, int credits, int id_user)
{
DB_Helper db = new DB_Helper();
db.Execute("exec BUY_CREDITS " + id_user + "," + amount_money + "," + credits);
List <string> p = new List <string>();
p.Add("emailtitle:Credits were added");
p.Add("line:We added " + credits + " credits to your account.");
p.Add("credits:" + credits);
p.Add("cost:" + amount_money.ToString("c2"));
p.Add("date:" + DateTime.Now.ToString("MM/dd/yyyy"));
p.Add("package:" + credits + " credit package");
RWorker.AddToEmailQueue("EMAIL_PAYMENT", MyUtils.ID_USER, null, false, p);
MyUtils.RefreshUserRow();
}
protected void Page_Load(object sender, EventArgs e)
{
DB_Helper db = new DB_Helper();
int v = db.ExecuteScalarInt("select email_verified from users where id_user="******"/Account/");
return;
}
if (!IsPostBack)
{
txtEmail.Text = MyUtils.GetUserField("email").ToString();
}
}
public DirectionSelect(DB_Connector connection, List <string> filters)
{
InitializeComponent();
_DB_Connection = connection;
_DB_Helper = new DB_Helper(_DB_Connection);
foreach (object[] item in _DB_Connection.Select(DB_Table.DIRECTIONS, "direction_id", "faculty_short_name"))
{
Tuple <string, string> dirData = _DB_Helper.GetDirectionNameAndCode((uint)item[0]);
foreach (string v in filters)
{
if (dirData.Item2.Split('.')[1] == v)
{
dgvDirectionSelection.Rows.Add(item[0], dirData.Item2, dirData.Item1, item[1]);
}
}
}
}
private static DataSet GetUsers(int index, string filter, out string sql)
{
//index = 1;
DB_Helper db = new DB_Helper();
int id_user = (int)MyUtils.GetUserField("id_user"); //currently logged in user
if (string.IsNullOrEmpty(filter))
{
filter = db.ExecuteScalarString("select isnull(filter,'DEFAULT') from users where id_user="******"mainphoto_");
d.Tables[0].Columns.Add("online");
d.Tables[0].Columns.Add("button_switch");
foreach (DataRow r in d.Tables[0].Rows)
{
r["button_switch"] = GetButtonSwitch(r);
r["mainphoto_"] = MyUtils.GetImageUrl(r, MyUtils.ImageSize.MEDIUM);
r["online"] = MyUtils.IsOnline((int)r["id_user"]) ? "1" : "0";// ..GetImageUrl(r, MyUtils.ImageSize.MEDIUM);
}
d.Tables[0].Columns.Remove("mainphoto");
d.Tables[0].Columns["mainphoto_"].ColumnName = "MainPhoto";
d.Tables[0].TableName = "U";
DataTable t = new DataTable();
t.TableName = "filter";
t.Columns.Add("json");
t.Rows.Add(t.NewRow());
t.Rows[0]["json"] = f.ToString();
d.Tables.Add(t);
return(d);
}
protected void btnSendCode_Click(object sender, EventArgs e)
{
if (regexEmailValid.IsValid && RequiredFieldValidator1.IsValid)
{
DB_Helper db = new DB_Helper();
string em = txtEmail.Text;
if (em.StartsWith("ACTIVATE"))
{
db.Execute(string.Format("update Users set email_verified=1 where id_user = {0}", MyUtils.ID_USER));
MyUtils.RefreshUserRow();
}
else
{
int id_user = db.ExecuteScalarInt("select id_user from users where email=" + MyUtils.safe(em), 0);
if (id_user > 0 && id_user != MyUtils.ID_USER)
{
Session["message"] = "ERROR: This email is already used by a different user.";
return;
}
db.Execute("update users set email=" + MyUtils.safe(em) + " where id_user="******"EMAIL_ACTIVATE", MyUtils.ID_USER);
Session["message"] = "OK: Activation email was sent. Please check your inbox.";
}
}
else
{
Session["message"] = "ERROR: Invalid email.";
}
bool needtoverify = Convert.ToUInt32(MyUtils.GetUserField("email_verified")) == 0;
if (!needtoverify)
{
Response.Redirect("/Account/");
Session["message"] = "Account is active.";
}
}
public MainForm()
{
InitializeComponent();
//_DB_Connection = new DB_Connector("server = localhost; port = 3306; database = pk_db;"/*Properties.Settings.Default.pk_db_CS*/, "administrator", "adm1234");
_DB_Connection = new DB_Connector("server = serv-priem; port = 3306; database = pk_db;" /*Properties.Settings.Default.pk_db_CS*/, "administrator", "adm1234");
_DB_Helper = new DB_Helper(_DB_Connection);
Dictionary <uint, string> campaigns = new Dictionary <uint, string>();
foreach (object[] campaign in _DB_Connection.Select(DB_Table.CAMPAIGNS, new string[] { "id", "name" }))
{
if (_DB_Helper.GetCampaignType((uint)campaign[0]) == DB_Helper.CampaignType.BACHELOR_SPECIALIST)
{
campaigns.Add((uint)campaign[0], campaign[1].ToString());
}
}
cbCampaigns.DataSource = campaigns.ToList();
cbCampaigns.ValueMember = "Key";
cbCampaigns.DisplayMember = "Value";
cbAdress.SelectedIndex = 0;
cbAdress.Enabled = cbPost.Checked;
cbUnits.SelectedIndex = 1;
for (int i = 1; i <= 60; i++)
{
cbInterval.Items.Add(i);
}
cbInterval.SelectedItem = 15;
_SubjectsCodes = new Dictionary <uint, string>
{
{ _DB_Helper.GetDictionaryItemID(FIS_Dictionary.SUBJECTS, DB_Helper.SubjectMath), "Math" },
{ _DB_Helper.GetDictionaryItemID(FIS_Dictionary.SUBJECTS, DB_Helper.SubjectPhis), "Phis" },
{ _DB_Helper.GetDictionaryItemID(FIS_Dictionary.SUBJECTS, DB_Helper.SubjectRus), "Rus" },
{ _DB_Helper.GetDictionaryItemID(FIS_Dictionary.SUBJECTS, DB_Helper.SubjectObsh), "Obsh" },
{ _DB_Helper.GetDictionaryItemID(FIS_Dictionary.SUBJECTS, DB_Helper.SubjectForen), "Foren" }
};
}
private void gotoPage()
{
if (mTo != "Surprise")
{
String path = "/" + mTo + ".xaml?race=" + mRace;
NavigationService.Navigate(new Uri(path, UriKind.RelativeOrAbsolute));
}
else
{
DB_Helper.connect();
ObservableCollection <Index> Built_in = new ObservableCollection <Index>();
ObservableCollection <Index> Custom = new ObservableCollection <Index>();
ObservableCollection <Index> All = new ObservableCollection <Index>();
Random mRand = new Random();
Built_in = DB_Helper.get_Index_Built_In(mRace);
Custom = DB_Helper.get_Index_By_Author("Custom", mRace);
All = Built_in;
foreach (Index build in Custom)
{
All.Add(build);
}
if (All.Count == 0)
{
MessageBox.Show("There is no build order for this race");
RaceDialog.Visibility = Visibility.Collapsed;
PageTitle.Visibility = Visibility.Visible;
onRaceChoser = false;
}
else
{
int chosen = mRand.Next(All.Count);
Index chosenBuild = All[chosen];
String path = "/BuiltInOrder.xaml?index_id=" + chosenBuild.Id + "&race=" + mRace + "&buildname=" + chosenBuild.Name + "¬e=" + chosenBuild.Note + "¬efooter=" + chosenBuild.Note_Footer;
NavigationService.Navigate(new Uri(path, UriKind.RelativeOrAbsolute));
}
}
}
public Main(string userRole, string usersLogin)
{
InitializeComponent();
_DB_Connection = new DB_Connector(Properties.Settings.Default.pk_db_CS, userRole,
new DB_Connector(Properties.Settings.Default.pk_db_CS, "initial", "1234").Select(
DB_Table.ROLES_PASSWORDS,
new string[] { "password" },
new List <Tuple <string, Relation, object> > {
new Tuple <string, Relation, object>("role", Relation.EQUAL, userRole)
}
)[0][0].ToString());
_DB_UpdateConnection = new DB_Connector(Properties.Settings.Default.pk_db_CS, userRole,
new DB_Connector(Properties.Settings.Default.pk_db_CS, "initial", "1234").Select(
DB_Table.ROLES_PASSWORDS,
new string[] { "password" },
new List <Tuple <string, Relation, object> > {
new Tuple <string, Relation, object>("role", Relation.EQUAL, userRole)
}
)[0][0].ToString());
_DB_Helper = new DB_Helper(_DB_Connection);
_UserLogin = usersLogin;
_UserRole = userRole;
SetUserRole();
dgvApplications.Sort(dgvApplications_LastName, System.ComponentModel.ListSortDirection.Ascending);
System.IO.Directory.CreateDirectory(Classes.Settings.TempPath);
dtpRegDate.Value = dtpRegDate.MinDate;
SetCurrentCampaign();
rbNew.Checked = true;
lFilter.BackColor = toolStrip.BackColor;
rbAdm.BackColor = toolStrip.BackColor;
rbNew.BackColor = toolStrip.BackColor;
rbWithdraw.BackColor = toolStrip.BackColor;
}
public DictionaryUpdater(DB_Connector dbConnection, string address, string fisLogin, string fisPassword)
{
#region Contracts
if (dbConnection == null)
{
throw new System.ArgumentNullException(nameof(dbConnection));
}
if (string.IsNullOrWhiteSpace(fisLogin))
{
throw new System.ArgumentException("Некорректный логин.", nameof(fisLogin));
}
if (string.IsNullOrWhiteSpace(fisPassword))
{
throw new System.ArgumentException("Некорректный пароль.", nameof(fisPassword));
}
#endregion
_DB_Connection = dbConnection;
_FIS_Address = address;
_FIS_Login = fisLogin;
_FIS_Password = fisPassword;
_DB_Helper = new DB_Helper(_DB_Connection);
}
protected void btnSendCode_Click(object sender, EventArgs e)
{
if (regexEmailValid.IsValid && RequiredFieldValidator1.IsValid)
{
DB_Helper db = new DB_Helper();
string em =txtEmail.Text;
if (em.StartsWith("ACTIVATE"))
{
db.Execute(string.Format("update Users set email_verified=1 where id_user = {0}", MyUtils.ID_USER));
MyUtils.RefreshUserRow();
}
else
{
int id_user = db.ExecuteScalarInt("select id_user from users where email=" + MyUtils.safe(em), 0);
if (id_user > 0 && id_user != MyUtils.ID_USER)
{
Session["message"] = "ERROR: This email is already used by a different user.";
return;
}
db.Execute("update users set email=" + MyUtils.safe(em) + " where id_user="******"EMAIL_ACTIVATE", MyUtils.ID_USER);
Session["message"] = "OK: Activation email was sent. Please check your inbox.";
}
}
else Session["message"] = "ERROR: Invalid email.";
bool needtoverify = Convert.ToUInt32(MyUtils.GetUserField("email_verified")) == 0;
if (!needtoverify)
{
Response.Redirect("/Account/");
Session["message"] = "Account is active.";
}
}
void input_name_Completed(object sender, PopUpEventArgs <string, PopUpResult> e)
{
name = e.Result;
DB_Helper.connect();
ObservableCollection <Index> test = DB_Helper.get_Index_By_Name(name);
if (test.Count == 0)
{
mAuthor = "Custom";
DB_Helper.createIndex(name, desc, mRace, mAuthor, "", "");
ObservableCollection <Index> result = DB_Helper.get_Index_By_Name(name);
int index_id = result[0].Id;
for (int i = 0; i < BuildOrder.Count; i++)
{
DB_Helper.insertBuild(index_id, i, BuildOrder[i].ObjId, "", "");
}
NavigationService.Navigate(new Uri("/MainMenu.xaml", UriKind.RelativeOrAbsolute));
}
else
{
MessageBox.Show("Name is used. Please choose other name.");
}
}
public QuotDocs(DB_Connector connection, Forms.ApplicationEdit.QDoc loadedDocument)
{
InitializeComponent();
_DB_Connection = connection;
DB_Helper dbHelper = new DB_Helper(_DB_Connection);
cbCause.SelectedIndex = 0;
cbMedCause.SelectedIndex = 0;
cbOrphanhoodDocType.DataSource = dbHelper.GetDictionaryItems(FIS_Dictionary.ORPHAN_DOC_TYPE).Values.ToArray();
cbOrphanhoodDocType.SelectedIndex = 0;
cbDisabilityGroup.DataSource = dbHelper.GetDictionaryItems(FIS_Dictionary.DISABILITY_GROUP).Values.ToArray();
cbDisabilityGroup.SelectedIndex = 0;
_Document = loadedDocument;
if (loadedDocument.cause == "Медицинские показатели")
{
cbCause.SelectedItem = loadedDocument.cause;
cbMedCause.SelectedItem = loadedDocument.medCause;
tbMedDocSeries.Text = loadedDocument.medDocSerie;
tbMedDocNumber.Text = loadedDocument.medDocNumber;
cbDisabilityGroup.SelectedItem = loadedDocument.disabilityGroup;
tbConclusionNumber.Text = loadedDocument.conclusionNumber;
dtpConclusionDate.Value = loadedDocument.conclusionDate;
}
else if (loadedDocument.cause == "Сиротство")
{
cbOrphanhoodDocType.SelectedItem = loadedDocument.orphanhoodDocType;
tbOrphanhoodDocName.Text = loadedDocument.orphanhoodDocName;
dtpOrphanhoodDocDate.Value = loadedDocument.orphanhoodDocDate;
tbOrphanhoodDocOrg.Text = loadedDocument.orphanhoodDocOrg;
}
}
private static void EnsureFilterIsSaved(Filter f)
{
string user_filter = MyUtils.GetUserField("filter") as string;
string current_filter = f.ToString();
if (user_filter != current_filter)
{
DB_Helper db = new DB_Helper();
int id_user = MyUtils.ID_USER; //currently logged in user
if (f.IsDefault()) current_filter = "DEFAULT";
db.Execute("update users set filter=" + MyUtils.safe(current_filter) + " where id_user=" + id_user);
MyUtils.RefreshUserRow();
}
}
private static DataSet GetUsers(int index, string filter, out string sql)
{
//index = 1;
DB_Helper db = new DB_Helper();
int id_user = (int) MyUtils.GetUserField("id_user"); //currently logged in user
if (string.IsNullOrEmpty(filter)) filter = db.ExecuteScalarString("select isnull(filter,'DEFAULT') from users where id_user="******"mainphoto_");
d.Tables[0].Columns.Add("online");
d.Tables[0].Columns.Add("button_switch");
foreach (DataRow r in d.Tables[0].Rows)
{
r["button_switch"] = GetButtonSwitch(r);
r["mainphoto_"] = MyUtils.GetImageUrl(r, MyUtils.ImageSize.MEDIUM);
r["online"] = MyUtils.IsOnline((int)r["id_user"]) ? "1" : "0";// ..GetImageUrl(r, MyUtils.ImageSize.MEDIUM);
}
d.Tables[0].Columns.Remove("mainphoto");
d.Tables[0].Columns["mainphoto_"].ColumnName = "MainPhoto";
d.Tables[0].TableName = "U";
DataTable t = new DataTable();
t.TableName = "filter";
t.Columns.Add("json");
t.Rows.Add(t.NewRow());
t.Rows[0]["json"] = f.ToString();
d.Tables.Add(t);
return d;
}