public UserControlCompetitions()
{
InitializeComponent();
Dock = DockStyle.Fill;
_UserControlCompetitions = this;
gridControlCompetitions.DataSource = SqliteDbAccess.ReturnDataTable("SELECT * FROM Competitions", null);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!_UserControlCompetitors.gridViewCompetitors.IsDataRow(_UserControlCompetitors.gridViewCompetitors.FocusedRowHandle))
{
return;
}
var id = Convert.ToInt32(_UserControlCompetitors.gridViewCompetitors.GetFocusedRowCellValue("Id"));
if (txtName.Text == string.Empty || txtCity.Text == string.Empty || txtSchool.Text == string.Empty || txtPhone.Text == string.Empty || lookUpEditCompetitions.EditValue == null)
{
return;
}
SQLiteParameter[] prm = new SQLiteParameter[6];
prm[0] = new SQLiteParameter("@Id", id);
prm[1] = new SQLiteParameter("@Name", txtName.Text);
prm[2] = new SQLiteParameter("@City", txtCity.Text);
prm[3] = new SQLiteParameter("@School", txtSchool.Text);
prm[4] = new SQLiteParameter("@Phone", txtPhone.Text);
prm[5] = new SQLiteParameter("@CompetitionId", lookUpEditCompetitions.EditValue);
SqliteDbAccess.ExcuteData("UPDATE Competitors SET Name=@Name,City=@City,School=@School,Phone=@Phone,CompetitionId=@CompetitionId WHERE Id=@Id ", prm);
var sqlStr = "SELECT " +
"Competitors.Id,Competitors.Name,Competitors.City,Competitors.School, Competitors.Phone,Competitors.CompetitionId,Competitions.Name As CompetitionName " +
"FROM " +
"Competitors " +
"INNER JOIN " +
"Competitions " +
"ON " +
"Competitors.CompetitionId = Competitions.Id";
_UserControlCompetitors.gridControlCompetitors.DataSource = SqliteDbAccess.ReturnDataTable(sqlStr, null);
this.Close();
}
private void navBarItemDelCompetitors_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
{
if (!_UserControlCompetitors.gridViewCompetitors.IsDataRow(_UserControlCompetitors.gridViewCompetitors.FocusedRowHandle))
{
return;
}
var result = XtraMessageBox.Show("هل تريد الحذف فعلا؟", "تأكيد", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result != DialogResult.Yes)
{
return;
}
var id = _UserControlCompetitors.gridViewCompetitors.GetFocusedRowCellValue("Id").ToString();
var prm = new SQLiteParameter[1];
prm[0] = new SQLiteParameter("@Id", id);
SqliteDbAccess.ExcuteData("DELETE FROM Competitors WHERE Id=@Id", prm);
var sqlStr = "SELECT " +
"Competitors.Id,Competitors.Name,Competitors.City,Competitors.School, Competitors.Phone,Competitors.CompetitionId,Competitions.Name As CompetitionName " +
"FROM " +
"Competitors " +
"INNER JOIN " +
"Competitions " +
"ON " +
"Competitors.CompetitionId = Competitions.Id";
_UserControlCompetitors.gridControlCompetitors.DataSource = SqliteDbAccess.ReturnDataTable(sqlStr, null);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text == string.Empty || txtCity.Text == string.Empty || txtSchool.Text == string.Empty || txtPhone.Text == string.Empty || lookUpEditCompetitions.EditValue == null)
{
return;
}
SQLiteParameter[] prm = new SQLiteParameter[5];
prm[0] = new SQLiteParameter("@Name", txtName.Text);
prm[1] = new SQLiteParameter("@City", txtCity.Text);
prm[2] = new SQLiteParameter("@School", txtSchool.Text);
prm[3] = new SQLiteParameter("@Phone", txtPhone.Text);
prm[4] = new SQLiteParameter("@Competition", lookUpEditCompetitions.EditValue);
SqliteDbAccess.ExcuteData("INSERT INTO Competitors(Name,City,School,Phone,CompetitionId) VALUES (@Name,@City,@School,@Phone,@Competition)", prm);
var sqlStr = "SELECT " +
"Competitors.Id,Competitors.Name,Competitors.City,Competitors.School, Competitors.Phone,Competitors.CompetitionId,Competitions.Name As CompetitionName " +
"FROM " +
"Competitors " +
"INNER JOIN " +
"Competitions " +
"ON " +
"Competitors.CompetitionId = Competitions.Id";
_UserControlCompetitors.gridControlCompetitors.DataSource = SqliteDbAccess.ReturnDataTable(sqlStr, null);
this.Close();
}
/// <summary>
/// 初始化要使用的 Wunion.DataAdapter.NetCore 数据引擎。
/// </summary>
/// <param name="env">用于获到当前请求 Hotting 信息的对象。</param>
/// <param name="configuration">用于读取 appsettings.json 配置文件的对象。</param>
public static void UseDataEngine(IHostingEnvironment env, IConfiguration configuration)
{
IConfigurationSection Section = configuration.GetSection("ConnectionStrings");
SqliteDbAccess SqliteDBA = new SqliteDbAccess();
string wwwroot = env.WebRootPath;
if (wwwroot[wwwroot.Length - 1] != '\\')
{
wwwroot += "\\";
}
SqliteDBA.ConnectionString = Section.GetValue <string>("SQLite").Replace("{wwwroot}", wwwroot);
DataEngine.AppendDataEngine(SqliteDBA, new SqliteParserAdapter()); // 添加为默认引擎。
SqlServerDbAccess MsSqlDBA = new SqlServerDbAccess();
MsSqlDBA.ConnectionString = Section.GetValue <string>("SQLServer");
DataEngine.AppendDataEngine(MsSqlDBA, new SqlServerParserAdapter(), "SQLServer");
MySqlDBAccess MySqlDBA = new MySqlDBAccess();
MySqlDBA.ConnectionString = Section.GetValue <string>("MariaDB");
DataEngine.AppendDataEngine(MySqlDBA, new MySqlParserAdapter(), "MariaDB");
NpgsqlDbAccess NpgsqlDBA = new NpgsqlDbAccess();
NpgsqlDBA.ConnectionString = Section.GetValue <string>("PostgreSQL");
DataEngine.AppendDataEngine(NpgsqlDBA, new NpgsqlParserAdapter(), "PostgreSQL");
}
private void navBarItemDelCompetitions_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
{
if (!_UserControlCompetitions.gridViewCompetitions.IsDataRow(_UserControlCompetitions.gridViewCompetitions.FocusedRowHandle))
{
return;
}
var id = _UserControlCompetitions.gridViewCompetitions.GetFocusedRowCellValue("Id").ToString();
var prm1 = new SQLiteParameter[1];
prm1[0] = new SQLiteParameter("@Id", id);
var dtCheck = SqliteDbAccess.ReturnDataTable("SELECT * FROM Competitors WHERE CompetitionId=@Id", prm1);
if (dtCheck.Rows.Count > 0)
{
XtraMessageBox.Show("لايمكن الحذف المسابقة مرتبطة", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var result = XtraMessageBox.Show("هل تريد الحذف فعلا؟", "تأكيد", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result != DialogResult.Yes)
{
return;
}
var prm2 = new SQLiteParameter[1];
prm2[0] = new SQLiteParameter("@Id", id);
SqliteDbAccess.ExcuteData("DELETE FROM Competitions WHERE Id=@Id", prm2);
_UserControlCompetitions.gridControlCompetitions.DataSource = SqliteDbAccess.ReturnDataTable("SELECT * FROM Competitions", null);
}
public FrmCompetitorsAdd()
{
InitializeComponent();
lookUpEditCompetitions.Properties.Columns.Add(new LookUpColumnInfo("Id"));
lookUpEditCompetitions.Properties.Columns.Add(new LookUpColumnInfo("Name"));
lookUpEditCompetitions.Properties.Columns["Name"].Caption = @"الأسم";
lookUpEditCompetitions.Properties.Columns["Id"].Visible = false;
lookUpEditCompetitions.Properties.ValueMember = "Id";
lookUpEditCompetitions.Properties.DisplayMember = "Name";
lookUpEditCompetitions.Properties.NullText = @"الرجاء اختر مسابقة";
lookUpEditCompetitions.Properties.DataSource = SqliteDbAccess.ReturnDataTable("SELECT * FROM Competitions", null);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text == string.Empty)
{
return;
}
SQLiteParameter[] prm = new SQLiteParameter[1];
prm[0] = new SQLiteParameter("@Name", txtName.Text);
SqliteDbAccess.ExcuteData("INSERT INTO Gifts(Name) values (@Name)", prm);
_UserControlGifts.gridControlGifts.DataSource = SqliteDbAccess.ReturnDataTable("SELECT * FROM Gifts", null);
this.Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text == string.Empty || txtDate.Text == string.Empty)
{
return;
}
SQLiteParameter[] prm = new SQLiteParameter[2];
prm[0] = new SQLiteParameter("@Name", txtName.Text);
prm[1] = new SQLiteParameter("@Date", txtDate.DateTime.ToString("yyyy-MM-dd"));
SqliteDbAccess.ExcuteData("INSERT INTO Competitions(Name,Date) VALUES (@Name,@Date)", prm);
_UserControlCompetitions.gridControlCompetitions.DataSource = SqliteDbAccess.ReturnDataTable("SELECT * FROM Competitions", null);
this.Close();
}
public UserControlCompetitors()
{
InitializeComponent();
this.Dock = DockStyle.Fill;
_UserControlCompetitors = this;
var sqlStr = "SELECT " +
"Competitors.Id,Competitors.Name,Competitors.City,Competitors.School, Competitors.Phone,Competitors.CompetitionId,Competitions.Name As CompetitionName " +
"FROM " +
"Competitors " +
"INNER JOIN " +
"Competitions " +
"ON " +
"Competitors.CompetitionId = Competitions.Id";
gridControlCompetitors.DataSource = SqliteDbAccess.ReturnDataTable(sqlStr, null);
}
static void Main(string[] args)
{
IConfiguration config = GetConfiguration();
ISqlDbAccess db = new SqliteDbAccess(config);
IPasswordCrypto crypto = new PasswordCrypto();
SqliteUserService userService = new SqliteUserService(db, crypto);
SqliteMessageService messageService = new SqliteMessageService(db);
UserInputValidator validator = new UserInputValidator();
LoginRoutine loginRoutine = new LoginRoutine(userService, validator);
//Console.WriteLine("Logging in");
//Console.Write("username: "******"Your password: "******"Signing up result: { confirmed }");
//Console.ReadLine();
//MessageRoutine messageRoutine = new MessageRoutine(messageService, userService);
////MessageModel message = new MessageModel()
////{
//// Message = "This is the first message.",
//// FromUserId = 1
////};
////messageRoutine.SendMessage(message, "juusvali");
//List<MessageFullModel> newMessages = messageRoutine.GetNewMessages(2);
//foreach (var item in newMessages)
//{
// Console.WriteLine($"To: { item.ToUserId }, from: { item.UserName }");
// Console.WriteLine(item.Message);
//}
}
private void lookUpEditCompetitions_EditValueChanged(object sender, EventArgs e)
{
SQLiteParameter[] prm = new SQLiteParameter[1];
prm[0] = new SQLiteParameter("@CompetitionId", lookUpEditCompetitions.EditValue);
var dtCount = SqliteDbAccess.ReturnDataTable("SELECT COUNT(*) FROM Competitors WHERE GiftId=0 AND CompetitionId=@CompetitionId", prm);
if (Convert.ToInt32(dtCount.Rows[0][0]) == 0)
{
lookUpEditGifts.Properties.Enabled = false;
spinEditLottery.Properties.Enabled = false;
btnSave.Enabled = false;
return;
}
lookUpEditGifts.Properties.Enabled = true;
spinEditLottery.Properties.Enabled = true;
btnSave.Enabled = true;
spinEditLottery.Value = Convert.ToInt32(dtCount.Rows[0][0]);
spinEditLottery.Properties.MaxValue = Convert.ToInt32(dtCount.Rows[0][0]);
}
protected DataEngine GetDbContext(string dbtype, bool useConnectionPool = true)
{
DbAccess dba = null;
ParserAdapter adapter = null;
switch (dbtype?.ToLower())
{
case "ms-sql":
dba = new SqlServerDbAccess();
dba.ConnectionString = "Server=(local);Database=Wunion.DataAdapter.NetCore.Demo;User ID=sa;Password=ms-sql@(*~-^*);";
adapter = new SqlServerParserAdapter();
break;
case "mysql":
dba = new MySqlDBAccess();
dba.ConnectionString = "Data Source=192.168.1.106;Database=ksdatab;User ID=cnzhnet;Password=mysql@(*~-^*);";
adapter = new MySqlParserAdapter();
break;
case "npgsql":
dba = new NpgsqlDbAccess();
dba.ConnectionString = "Host=192.168.1.106;Username=postgres;Password=npgsql@(*~-^*);Database=Wunion.DataAdapter.NetCore.Demo;";
adapter = new NpgsqlParserAdapter();
break;
case "sqlite3":
dba = new SqliteDbAccess();
dba.ConnectionString = @"Data Source=E:\SQLiteStudio\wdak.sqlite3;";
adapter = new SqliteParserAdapter();
break;
}
if (dba == null || adapter == null)
{
return(null);
}
DataEngine db = new DataEngine(dba, adapter);
if (useConnectionPool)
{
UseConnectionPool(db);
}
return(db);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!_UserControlGifts.gridViewGifts.IsDataRow(_UserControlGifts.gridViewGifts.FocusedRowHandle))
{
return;
}
var id = Convert.ToInt32(_UserControlGifts.gridViewGifts.GetFocusedRowCellValue("Id"));
if (txtName.Text == string.Empty)
{
return;
}
SQLiteParameter[] prm = new SQLiteParameter[2];
prm[0] = new SQLiteParameter("@Id", id);
prm[1] = new SQLiteParameter("@Name", txtName.Text);
SqliteDbAccess.ExcuteData("UPDATE Gifts SET Name=@Name WHERE Id=@Id ", prm);
_UserControlGifts.gridControlGifts.DataSource = SqliteDbAccess.ReturnDataTable("SELECT * FROM Gifts", null);
this.Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
SQLiteParameter[] prm = new SQLiteParameter[3];
if (lookUpEditCompetitions.EditValue == null || lookUpEditGifts.EditValue == null || spinEditLottery.Value == 0)
{
return;
}
this.Hide();
prm[0] = new SQLiteParameter("@CompetitionId", lookUpEditCompetitions.EditValue);
prm[1] = new SQLiteParameter("@GiftId", lookUpEditGifts.EditValue);
prm[2] = new SQLiteParameter("@Value", spinEditLottery.Value);
var sqlStr = "UPDATE Competitors SET GiftId=@GiftId WHERE Id IN(SELECT Id FROM Competitors WHERE CompetitionId=@CompetitionId AND GiftId=0 ORDER BY RANDOM() LIMIT @Value)";
SqliteDbAccess.ExcuteData(sqlStr, prm);
_FrmMain.navigationPageWinners.Controls.Clear();
_FrmMain.navigationPageWinners.Controls.Add(new UserControlWinners());
var frm = new FrmWait();
frm.ShowDialog(this);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!_UserControlCompetitions.gridViewCompetitions.IsDataRow(_UserControlCompetitions.gridViewCompetitions.FocusedRowHandle))
{
return;
}
var id = Convert.ToInt32(_UserControlCompetitions.gridViewCompetitions.GetFocusedRowCellValue("Id"));
if (txtName.Text == string.Empty || txtDate.Text == string.Empty)
{
return;
}
SQLiteParameter[] prm = new SQLiteParameter[3];
prm[0] = new SQLiteParameter("@Id", id);
prm[1] = new SQLiteParameter("@Name", txtName.Text);
prm[2] = new SQLiteParameter("@Date", txtDate.DateTime.ToString("yyyy-MM-dd"));
SqliteDbAccess.ExcuteData("UPDATE Competitions SET Name=@Name,Date=@Date where Id=@Id ", prm);
_UserControlCompetitions.gridControlCompetitions.DataSource = SqliteDbAccess.ReturnDataTable("SELECT * FROM Competitions", null);
this.Close();
}
private void navBarItemEditWinners_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
{
var ids = "";
for (var i = 0; i < _UserControlWinners.gridViewWinners.SelectedRowsCount; i++)
{
if (_UserControlWinners.gridViewWinners.GetSelectedRows()[i] >= 0)
{
ids += "," + Convert.ToString(_UserControlWinners.gridViewWinners.GetDataRow(_UserControlWinners.gridViewWinners
.GetSelectedRows()[i])["Id"]);
}
}
if (ids.Length <= 0)
{
return;
}
ids = ids.Substring(1, ids.Length - 1);
var sqlStr1 = "UPDATE Competitors SET GiftId=0 WHERE Id IN(" + ids + ")";
SqliteDbAccess.ExcuteData(sqlStr1, null);
var sqlStr2 = "SELECT " +
"Competitors.Id,Competitors.Name,Competitors.City,Competitors.School, Competitors.Phone,Competitions.Name As CompetitionName, Gifts.Name As GiftName " +
"FROM " +
"Competitors " +
"INNER JOIN " +
"Competitions " +
"ON " +
"Competitors.CompetitionId = Competitions.Id " +
"INNER JOIN " +
"Gifts " +
"ON " +
"Competitors.GiftId = Gifts.Id ";
_UserControlWinners.gridControlWinners.DataSource = SqliteDbAccess.ReturnDataTable(sqlStr2, null);
}
private void simpleButton2_Click(object sender, EventArgs e)
{
if (dt == null || lookUpEditCompetitions.EditValue == null)
{
return;
}
if (!splashScreenManager.IsSplashFormVisible)
{
splashScreenManager.ShowWaitForm();
}
foreach (DataRow row in dt.Rows)
{
var prm = new SQLiteParameter[5];
prm[0] = new SQLiteParameter("@Name", row[0]);
prm[1] = new SQLiteParameter("@City", row[1]);
prm[2] = new SQLiteParameter("@School", row[2]);
prm[3] = new SQLiteParameter("@Phone", row[3]);
prm[4] = new SQLiteParameter("@CompetitionId", lookUpEditCompetitions.EditValue);
SqliteDbAccess.ExcuteData("INSERT INTO Competitors(Name,City,School,Phone,CompetitionId) VALUES (@Name,@City,@School,@Phone,@CompetitionId)", prm);
}
var sqlStr = "SELECT " +
"Competitors.Id,Competitors.Name,Competitors.City,Competitors.School, Competitors.Phone,Competitors.CompetitionId,Competitions.Name As CompetitionName " +
"FROM " +
"Competitors " +
"INNER JOIN " +
"Competitions " +
"ON " +
"Competitors.CompetitionId = Competitions.Id";
_UserControlCompetitors.gridControlCompetitors.DataSource = SqliteDbAccess.ReturnDataTable(sqlStr, null);
if (splashScreenManager.IsSplashFormVisible)
{
splashScreenManager.CloseWaitForm();
}
this.Close();
}
