コード例 #1
0
ファイル: CenterService.cs プロジェクト: EvanSihab/C-Sharp
        public int AddNewCenter(CenterModel Emp)
        {
            SqlConnection connection = new SqlConnection("Server=Tanmoy-pc; Database=Wedding Management; User Id=sa; Password=1238628257");

            connection.Open();
            string     query = "INSERT INTO CenterList(CenterId, CenterName, capacity, location, cost, FoodCatering, Status ) VALUES('" + Emp.CenterId + "', '" + Emp.CenterName + "', '" + Emp.CenterCapacity + "', '" + Emp.CenterLocation + "','" + Emp.CenterCost + "','" + Emp.FoodCatering + "','" + "Available" + "')";
            SqlCommand cmd   = new SqlCommand(query, connection);
            int        i     = cmd.ExecuteNonQuery();

            connection.Close();
            return(i);
        }
コード例 #2
0
        private void Add_Button_Click_1(object sender, RoutedEventArgs e)
        {
            string centerName     = Convert.ToString(Center_Name_textBox.Text);
            string centerCapacity = Convert.ToString(Center_Capacity_textBox.Text);
            string centerLocation = Convert.ToString(Center_Location_textBox.Text);
            string centerCost     = Convert.ToString(Center_Cost_textBox.Text);
            string centerCatering = Convert.ToString(Center_Catering_textBox.Text);


            CenterJobs.CenterModel newCenter = new CenterJobs.CenterModel(CenterModel.id(), centerName, centerCapacity, centerLocation, centerCost, centerCatering);

            CenterJobs.CenterService cs = new CenterJobs.CenterService();
            int i = cs.AddNewCenter(newCenter);

            MainWindow mw = new MainWindow();

            mw.centerDataGrid.ItemsSource = cs.LoadData();
            this.Close();
        }