public IActionResult Post([FromBody] UserRegistration user, string Password)
{
IActionResult result;
// TODO: send the proper explanation for bad-request.
user.Password = DbTools.SanitizeString(user.Password);
user.Nickname = DbTools.SanitizeString(user.Nickname);
user.Email = DbTools.SanitizeString(user.Email);
if (!ModelState.IsValid ||
userRepository.IfNicknameExists(user.Nickname) ||
userRepository.IfEmailExists(user.Email))
{
result = BadRequest(ModelState);
}
else
{
var verify = new Verification();
verify.Email = user.Email;
verify.Token = Guid.NewGuid().ToString();
user.Email = verify.Token;
verify.EndVerifyDate = DateTime.Now.AddDays(3);
userRepository.Create(verify);
cleaner.TryToStart();
this.smtpClient.SendMail(verify.Email, "Register confirmation", "", verify.Token);
result = Ok(userRepository.Create(user));
}
return(result);
}
private static IEnumerable <DbParameter> GetParameters(CustomerFilter filter)
{
return(new List <DbParameter>
{
new DbParameter("customerId", filter.CustomerId),
new DbParameter("sex", GetSexFilter(filter.Sex)),
new DbParameter("dobMin", filter.DateOfBirth.Min),
new DbParameter("dobMax", filter.DateOfBirth.Max),
new DbParameter("timesPurchasedMin", filter.TimesPurchased.Min),
new DbParameter("timesPurchasedMax", filter.TimesPurchased.Max),
new DbParameter("count", filter.Count),
new DbParameter("start", GetStartingIndex(filter.Page)),
new DbParameter("monthOfBirth", filter.MonthOfBirth),
new DbParameter("nameKanji", filter.NameKanji),
new DbParameter("nameKana", filter.NameKana),
new DbParameter("email", filter.Email),
new DbParameter("emailMobile", filter.EmailMobile),
new DbParameter("phone", filter.Phone),
new DbParameter("productWarranty", filter.ProductWarranty),
new DbParameter("prefecture", filter.Prefecture),
new DbParameter("dateRegisteredMin", filter.DateRegistered.Min),
new DbParameter("dateRegisteredMax", filter.DateRegistered.Max),
new DbParameter("dateUpdatedMin", filter.DateUpdated.Min),
new DbParameter("dateUpdatedMax", filter.DateUpdated.Max),
new DbParameter("dateFirstPurchasedMin", filter.DateFirstPurchased.Min),
new DbParameter("dateFirstPurchasedMax", filter.DateFirstPurchased.Max),
new DbParameter("dateLastPurchasedMin", filter.DateLastPurchased.Min),
new DbParameter("dateLastPurchasedMax", filter.DateLastPurchased.Max),
new DbParameter("ecSubscriptionType", filter.EC_SubscriptionType),
new DbParameter("ecEmailTarget", filter.EC_EmailTarget),
new DbParameter("tvEmailAccept", filter.TV_EmailAccept),
new DbParameter("extractPattern", filter.ExtractPattern),
DbTools.StringToInts("shops", filter.Shops)
});
}
protected void btnLoadDrivers_Click(object sender, EventArgs e)
{
DbTools db = new DbTools();
GridView1.DataSource = db.GetDrivers().Values;
GridView1.DataBind();
}
private void FormMain_Load(object sender, EventArgs e)
{
db = new DbTools();
teams = new BindingList <Team>(db.LoadTeams());
listBoxTeam.DataSource = teams;
// listBoxTeam.SelectedIndex = -1;
}
///<summary>
///Maps properties from EntityORM object to UseConnectionrDb object
///</summary>
public static void Map(EntityORM entity, out UsersConnectionDb userConnection)
{
userConnection = new UsersConnectionDb();
foreach (KeyValuePair <string, object> aV in entity.attributeValue)
{
switch (aV.Key) // attribute
{
case "ID":
userConnection.Id = Convert.ToInt64(aV.Value);
break;
case "IDUSER1":
userConnection.IdUser1 = Convert.ToInt64(aV.Value);
break;
case "IDUSER2":
userConnection.IdUser2 = Convert.ToInt64(aV.Value);
break;
case "AREFRIENDS":
userConnection.AreFriends = DbTools.ProcessBoolean(aV.Value);
break;
case "BLACKLISTED":
userConnection.BlackListed = DbTools.ProcessBoolean(aV.Value);
break;
default:
break;
}
}
}
public IActionResult Login([FromBody] Login login)
{
IActionResult result;
if (login == null)
{
result = BadRequest("Invalid client request");
}
else
{
login.Username = DbTools.SanitizeString(login.Username);
login.Password = DbTools.SanitizeString(login.Password);
bool authValid = userRepository.CheckCredentials(login.Username, login.Password);
//TODO: Add error: please verify your account
if (!authValid || !userRepository.CheckVerifyByNickname(login.Username))
{
result = Unauthorized();
}
else
{
string tokenString = new TokenFactory(login, configProvider).GetTokenString();
result = Ok(new { Token = tokenString });
}
}
return(result);
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
DbTools dbt = new DbTools();
GridViewTable.DataSource = dbt.GetData(DropDownList1.SelectedValue);
GridViewTable.DataBind();
}
// [Fact]
/// <summary>
/// Updates the customer.
/// </summary>
public void UpdateCustomer()
{
var objMan = new Mapper();
var guid = Guid.NewGuid();
// todo: there is a bug , In the callstack of DBTools and DataReaderToObjectMapper occur two times Reader.Read(); so..
using var ts = new TransactionScope();
using var connection = CreateConnection();
var customer = DbTools.ExecuteReader(
connection,
"select * from Customers limit 1 ",
null,
r => r.ToObject <Customer>());
customer.ShouldNotBeNull();
var tracker = new ObjectsChangeTracker();
tracker.RegisterObject(customer);
customer.Address = guid.ToString();
var result = DbTools.UpdateObject(
connection,
customer,
"Customers",
new[] { "CustomerID" },
tracker,
DbSettings.Mssql);
result.Result.ShouldBe(1);
}
/// <summary>
/// 退出按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
if (User.user != null)
{
DbTools.UpdateUserState(User.user.UserName, LoginUI.state);
}
Environment.Exit(0);
}
protected void cmbDb_SelectedIndexChanged(object sender, EventArgs e)
{
if (!cmbDb.Text.StartsWith("-"))
{
GridViewDati.DataSource = DbTools.GetDaTa(cmbDb.Text);
GridViewDati.DataBind();
}
}
public static void Main()
{
DbTools.ResetDb();
Engine engine = new Engine(new CommandDispatcher());
engine.Run();
}
private void FormMain_Load(object sender, EventArgs e)
{
db = new DbTools();
db.GetCountries();
db.GetDrivers();
teams = new BindingList <Team>(db.LoadTeams());
listBoxTeam.DataSource = teams;
}
protected void btnLoadTeam_Click(object sender, EventArgs e)
{
DbTools db = new DbTools();
db.GetTeams();
GridView1.DataSource = db.Teams.Values;
//GridView1.data
GridView1.DataBind();
}
protected void btnLoadCountry_Click(object sender, EventArgs e)
{
DbTools db = new DbTools();
db.GetCountries();
GridView2.DataSource = db.Countries.Values;
//GridView1.data
GridView2.DataBind();
}
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
string sql2 = @"UPDATE [MapleQQ].[dbo].[UserInfo]
SET [lstatus] = 0
WHERE qq='" + QQ + "'";
DbTools db = new DbTools();
int h = db.zsg(sql2);
Application.Exit();
}
protected void btnLoadTeams_Click(object sender, EventArgs e)
{
DbTools db = new DbTools();
//Dictionary<string, List<object>> d = new Dictionary<string, List<object>>();
//d.Add(db.LoadTeamsTable()[0].ToString(), db.LoadTeamsTable());
//GridView1.DataSource = d.Values;
GridView1.DataSource = db.LoadTeamsTable();
GridView1.DataBind();
}
private async Task <IReportingDependencies> Init()
{
var options = new DbContextOptionsBuilder <FunctionUsageContext>()
.UseNpgsql(KnownConnectionStrings.ReadModel)
.EnableSensitiveDataLogging()
.Options;
await DbTools.ResetDatabases();
Sys.InitReportingExtension(new ReportingDependencies(options));
return(Sys.GetReportingExtension().GetDependencies());
}
public IEnumerable <Classroom> Get()
{
List <Classroom> classrooms = new List <Classroom>();
DbTools dBTools = new DbTools();
var data = dBTools.GetDataTable(@"SELECT * FROM Class").Rows;
foreach (DataRow item in data)
{
classrooms.Add(new Classroom(Convert.ToInt32(item["Id"]), Convert.ToInt32(item["Year"]), item["Section"].ToString(), item["Specialization"].ToString()));
}
return(classrooms);
}
private void btnExportCSV_Click(object sender, EventArgs e)
{
try
{
DbTools.SerializeToCsv(teams, @".\Teams.csv");
MessageBox.Show("Esportazione completata");
}
catch (Exception)
{
MessageBox.Show("Esportazione fallita");
}
}
public static void Main()
{
DbTools.ResetDb();
IReader reader = new ConsoleReader();
IWriter writer = new ConsoleWriter();
var serviceProvider = ConfigureServices();
var engine = new Engine(serviceProvider, reader, writer);
engine.Run();
}
public IEnumerable <StudentDetailDto> Get()
{
DbTools dBTools = new DbTools();
var data = dBTools.GetDataTable(@"SELECT * FROM Student s, Class c WHERE s.IdClass = c.Id;");
List <StudentDetailDto> students = new List <StudentDetailDto>();
foreach (DataRow item in data.Rows)
{
students.Add(ParseToStudent(item));
}
return(students);
}
public IEnumerable <Subject> Get()
{
List <Subject> subjects = new List <Subject>();
DbTools dBTools = new DbTools();
var data = dBTools.GetDataTable(@"SELECT * FROM Subject");
foreach (DataRow item in data.Rows)
{
Subject materia = new Subject(Convert.ToInt32(item["Id"]), item["Description"].ToString(), Convert.ToBoolean(item["IsPeculiar"]));
subjects.Add(materia);
}
return(subjects);
}
private void button1_Click(object sender, EventArgs e)
{
Team t = new Team(999, "Test", "Test di test", new Country("IT", "Italy"), "Ferrari", "Giaison", "Test chassis", null, null);
teams.Add(t);
teamsRes = new SerializableBindingList <Team>();
// probabilmente errore nella trasmissione dei dati
teams = teamsRes;
DbTools.SerializeToCsv(teamsRes, @".\Teams.csv");
/***** NON VA *****/
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
DbTools db = new DbTools();
db.GetTeams();
GridView table = (GridView)sender;
int rowIndex = Convert.ToInt32(table.SelectedRow.Cells[0].Text);
GridView2.DataSource = db.Teams[rowIndex].FirstDriver.ToDataTable();
GridView2.DataBind();
GridView3.DataSource = db.Teams[rowIndex].SecondDriver.ToDataTable();
GridView3.DataBind();
}
private void SendOneDatagram()
{
int maxLength = int.Parse(cb_MaxDatagramSize.Text) * 10240;
Random rnd = new Random();
int datagramLength = rnd.Next(1, maxLength);
//就这里，弄个类的序列化。
DbTools db = new DbTools();
ModelMember m = new ModelMember();
m.email = "赵钦@sina.com";
m.hdinfo = HardWare.getHardCode();
m.logintime = DateTime.Now;
string datagramText = db.ClasstoString(m, "VCDS");
datagramText = "<" + datagramText + ">";
//if (ck_ErrorDatagram.Checked && datagramLength < maxLength * 0.20) // 产生一个无 > 的包
//{
// datagramText = "<" + tb_ClientName.Text.Trim() + ",".PadRight(datagramLength, 'a');
//} else if (ck_ErrorDatagram.Checked && datagramLength > maxLength * 0.80) // 产生一个无 < 的包
//{
// datagramText = tb_ClientName.Text.Trim() + ",".PadRight(datagramLength, 'a') + ">";
//} else // 正常包
//{
// string header = "<" + tb_ClientName.Text.Trim() + ",";
// string tailer = ",".PadRight(datagramLength, 'a') + ">";
// datagramText = header + (header.Length + tailer.Length + 10).ToString("0000000000") + tailer; // 第二个字节是长度
//}
byte[] datagram = Encoding.ASCII.GetBytes(datagramText);
try {
m_socketClient.Client.Send(datagram);
this.RefreshSendCount();
this.AddInfo("send text len = " + datagramText.Length.ToString());
if (ck_AsyncReceive.Checked) // 异步接收回答
{
m_socketClient.Client.BeginReceive(m_receiveBuffer, 0, m_receiveBuffer.Length, SocketFlags.None, this.EndReceiveDatagram, this);
}
else
{
this.Receive();
}
} catch (Exception err) {
this.AddInfo("send exception: " + err.Message);
this.CloseClientSocket();
}
}
public List <TagRegistrationDto> GetAll()
{
MyDataSet ds = new MyDataSet();
ds.EnforceConstraints = false;
DbTools.SelectQuery(
FireBirdConnection.Connection,
ds.TagRegistration, UrgentAppQueries.TAGREGISTRATION_SELECT);
List <TagRegistrationDto> lst = baseMapper.BindDataList <TagRegistrationDto>(ds.TagRegistration);
return(lst);
}
public List <TagEventTypeDto> GetAll()
{
MyDataSet ds = new MyDataSet();
ds.EnforceConstraints = false;
DbTools.SelectQuery(
FireBirdConnection.Connection,
ds.TagEventType, Queries.TAGEVENTTYPE_SELECT);
List <TagEventTypeDto> lst = baseMapper.BindDataList <TagEventTypeDto>(ds.TagEventType);
return(lst);
}
public ActionResult <StudentDetailDto> Get(int id)
{
DbTools dBTools = new DbTools();
var data = dBTools.GetDataTable(@"SELECT * FROM Student s, Class c WHERE s.IdClass = c.Id AND s.Id = " + id);
if (data.Rows.Count > 0)
{
return(ParseToStudent(data.Rows[0]));
}
else
{
return(NotFound());
}
}
public TagEventTypeDto GetById(int Id)
{
MyDataSet ds = new MyDataSet();
ds.EnforceConstraints = false;
DbTools.SelectQuery(
FireBirdConnection.Connection,
ds.TagEventType, string.Format(UrgentAppQueries.TAGEVENTTYPE_SELECT_BYID, Id));
TagEventTypeDto result = baseMapper.BindData <TagEventTypeDto>(ds.Patient);
return(result);
}
public List <PatientDto> GetAll()
{
MyDataSet ds = new MyDataSet();
ds.EnforceConstraints = false;
DbTools.SelectQuery(
FireBirdConnection.Connection,
ds.Patient, UrgentAppQueries.PATIENT_SELECT);
List <PatientDto> lst = baseMapper.BindDataList <PatientDto>(ds.Patient);
return(lst);
}
