コード例 #1
0
 private void MetroWindow_Loaded(object sender, RoutedEventArgs e)
 {
     if (SystemClass.CheckConnection())
     {
         ImusCityHallEntities db = new ImusCityHallEntities();
         if (db.SystemSettings.Count() >= 1)
         {
             ImusCityGovernmentSystem.Model.SystemSetting systemSetting = db.SystemSettings.FirstOrDefault();
             userstb.Text = systemSetting.NumberOfUser.ToString();
         }
     }
     else
     {
         MessageBox.Show(SystemClass.DBConnectionErrorMessage);
     }
 }
コード例 #2
0
 private void acceptbtn_Click(object sender, RoutedEventArgs e)
 {
     if (SystemClass.CheckConnection())
     {
         ImusCityHallEntities db = new ImusCityHallEntities();
         if (db.SystemSettings.Count() >= 1)
         {
             int numberUsers = Convert.ToInt32(userstb.Text);
             ImusCityGovernmentSystem.Model.SystemSetting systemSetting = db.SystemSettings.FirstOrDefault();
             systemSetting.NumberOfUser = numberUsers;
             db.SaveChanges();
             MessageBox.Show("System setting updated successfully!");
         }
         else
         {
             if (String.IsNullOrEmpty(userstb.Text))
             {
                 MessageBox.Show("Please input number of users field");
             }
             else
             {
                 int numberUsers = Convert.ToInt32(userstb.Text);
                 ImusCityGovernmentSystem.Model.SystemSetting systemSetting = new SystemSetting
                 {
                     NumberOfUser = numberUsers
                 };
                 db.SystemSettings.Add(systemSetting);
                 db.SaveChanges();
                 MessageBox.Show("System setting updated successfully!");
             }
         }
     }
     else
     {
         MessageBox.Show(SystemClass.DBConnectionErrorMessage);
     }
 }