コード例 #1
0
        public async Task <long> RegisterAsync([FromForm] DoctorsModel model)
        {
            try

            {
                var    ss   = model.PICTURE_2;
                string path = Path.Combine(@"E:\reactProjects\NEWAPP\components\Doctors\Admin\assets\img");

                string query = "INSERT INTO doctors(`NAME`, `FATHER_NAME`, `EMAIL`, `DESCRIPTION`, `EDUCATIONAL_INSTITUTE`, `AGE`, `GENDER`, `EXPERIENCE`, `D_PASSWORD`, `CONTACT`, `ADDRESS`, `PICTURE`, `SPECIALIZATION_ID`, `DISTRICT_ID`)" +
                               " VALUES('" + model.NAME + "','" + model.FATHER_NAME + "','" + model.EMAIL + "','" + model.DESCRIPTION + "'," +
                               "'" + model.EDUCATIONAL_INSTITUTE + "','" + model.AGE + "','" + model.GENDER + "','" + model.EXPERIENCE + "','" + model.PASSWORD + "','" + model.CONTACT + "','" + model.ADDRESS + "','" + ss.FileName.ToString() + "','" + model.SPECIALIZATION_ID + "','" + model.DISTRICT_ID + "')";


                connection.Open();
                MySqlCommand cmd    = new MySqlCommand(query, connection);
                int          result = cmd.ExecuteNonQuery();
                connection.Close();
                if (result != 0)
                {
                    var fs = new FileStream(Path.Combine(path, ss.FileName), FileMode.Create);
                    await ss.CopyToAsync(fs);

                    return(1);
                }
                return(0);
            }
            catch (Exception e)
            {
                return(0);
            }
        }
コード例 #2
0
 public int ForgotPassword([FromForm] DoctorsModel model)
 {
     try {
         string sql = "UPDATE DOCTORS SET DOCTORS.D_PASSWORD='******' WHERE  DOCTORS.EMAIL='" + model.EMAIL + "'";
         connection.Open();
         MySqlCommand cmd = new MySqlCommand(sql, connection);
         int          res = cmd.ExecuteNonQuery();
         connection.Close();
         return(res);
     }
     catch (Exception ex)
     {
         return(0);
     }
 }
コード例 #3
0
        public DoctorsModel Login([FromForm] string data)
        {
            DoctorsModel model = new DoctorsModel();

            try
            {
                var    login = data.Split(',');
                string query = "SELECT DOCTORS.*, DOCTORS_SPECIALIZATION.SPECIALIZATION, DISTRICTS.DISTRICT FROM DOCTORS " +
                               "INNER JOIN DOCTORS_SPECIALIZATION INNER JOIN DISTRICTS ON DOCTORS.SPECIALIZATION_ID=DOCTORS_SPECIALIZATION.ID AND DOCTORS.DISTRICT_ID=DISTRICTS.ID " +
                               "WHERE DOCTORS.EMAIL='" + login[0] + "' AND DOCTORS.D_PASSWORD='******'";
                connection.Open();
                MySqlCommand    cmd    = new MySqlCommand(query, connection);
                MySqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    model.ID                    = reader.GetInt16("ID");
                    model.NAME                  = reader.GetString("NAME");
                    model.FATHER_NAME           = reader.GetString("FATHER_NAME");
                    model.EMAIL                 = reader.GetString("EMAIL");
                    model.DESCRIPTION           = reader.GetString("DESCRIPTION");
                    model.EDUCATIONAL_INSTITUTE = reader.GetString("EDUCATIONAL_INSTITUTE");
                    model.AGE                   = reader.GetInt16("AGE");
                    model.GENDER                = reader.GetString("GENDER");
                    model.EXPERIENCE            = reader.GetInt16("EXPERIENCE");
                    model.PASSWORD              = reader.GetString("D_PASSWORD");
                    model.CONTACT               = reader.GetString("CONTACT");
                    model.ADDRESS               = reader.GetString("ADDRESS");
                    model.PICTURE               = reader.GetString("PICTURE");
                    model.SPECIALIZATION_ID     = reader.GetInt16("SPECIALIZATION_ID");
                    model.DISTRICT_ID           = reader.GetInt16("DISTRICT_ID");
                    model.SPECIALIZATION        = reader.GetString("SPECIALIZATION");
                    model.DISTRICT              = reader.GetString("DISTRICT");
                }
                connection.Close();
                return(model);
            }
            catch (Exception e) {
                return(model);
            }
        }