public static List <UserMainInfo> ReadList(string whereStr)
{
List <UserMainInfo> list = new List <UserMainInfo>();
Database database = new Database();
DataView defaultView = database.RunProc("select * from UserMain " + whereStr).Tables[0].DefaultView;
for (int i = 0; i < defaultView.Count; i++)
{
list.Add(UserMainInfo.Read(int.Parse(defaultView[i]["id"].ToString())));
}
database.Dispose();
return(list);
}
public static UserMainInfo Read(int id)
{
UserMainInfo result = null;
Database database = new Database();
MySqlDataReader mySqlDataReader = database.RunProcGetReader("select * from UserMain where id=" + id);
while (mySqlDataReader.Read())
{
result = new UserMainInfo(int.Parse(mySqlDataReader.GetValue(0).ToString()), mySqlDataReader.GetValue(1).ToString(), mySqlDataReader.GetValue(2).ToString(), mySqlDataReader.GetValue(3).ToString(), short.Parse(mySqlDataReader.GetValue(4).ToString()), mySqlDataReader.GetValue(5).ToString(), mySqlDataReader.GetValue(6).ToString(), mySqlDataReader.GetValue(7).ToString(), mySqlDataReader.GetValue(8).ToString(), mySqlDataReader.GetValue(9).ToString(), mySqlDataReader.GetValue(10).ToString(), mySqlDataReader.GetValue(11).ToString(), mySqlDataReader.GetValue(12).ToString(), mySqlDataReader.GetValue(13).ToString(), mySqlDataReader.GetValue(14).ToString(), DateTime.Parse(mySqlDataReader.GetValue(15).ToString()), mySqlDataReader.GetValue(16).ToString(), mySqlDataReader.GetValue(17).ToString(), short.Parse(mySqlDataReader.GetValue(18).ToString()), mySqlDataReader.GetValue(19).ToString(), mySqlDataReader.GetValue(20).ToString(), mySqlDataReader.GetValue(21).ToString(), decimal.Parse(mySqlDataReader.GetValue(22).ToString()), decimal.Parse(mySqlDataReader.GetValue(23).ToString()), int.Parse(mySqlDataReader.GetValue(24).ToString()), int.Parse(mySqlDataReader.GetValue(25).ToString()), int.Parse(mySqlDataReader.GetValue(26).ToString()), short.Parse(mySqlDataReader.GetValue(27).ToString()), DateTime.Parse(mySqlDataReader.GetValue(28).ToString()), DateTime.Parse(mySqlDataReader.GetValue(29).ToString()), decimal.Parse(mySqlDataReader.GetValue(30).ToString()));
}
mySqlDataReader.Close();
database.Dispose();
return(result);
}
public async Task <IActionResult> ChangeMainInfoUser([FromRoute] string login, [FromBody] UserMainInfo userMainInfo)
{
var user = await db.Users.FirstOrDefaultAsync(u => u.Login == login);
user.FirstName = userMainInfo.first_name;
user.LastName = userMainInfo.last_name;
user.MiddleName = userMainInfo.middle_name;
user.Phone = userMainInfo.phone;
await db.SaveChangesAsync();
return(Ok());
}
