示例#1
0
        private void updateButton_Click(object sender, EventArgs e)
        {
            // faciliytid from another form
            Facility f = ctx.Facilities.Where(x => x.FacilityID == facilityid).FirstOrDefault();
            // the facility select

            int    flag      = 0;
            string inputname = FacilityNameTextB.Text;

            if (inputname == "")
            {
                MessageBox.Show("Please input the Facility Name.");
            }
            else
            {
                foreach (Facility f1 in ctx.Facilities)
                {
                    if (f1.Name == inputname)
                    {
                        flag++; break;
                    }
                }
                if (flag > 0 && inputname.ToLower() != f.Name.ToLower())
                {
                    MessageBox.Show("This Facility Name already exists. Please input a different one."); flag = 0;
                }
                else
                {
                    f.Name = inputname;
                    if (OpenTimeMaskT.MaskedTextProvider.AssignedEditPositionCount == 0)
                    {
                        MessageBox.Show("Please input the Opening Time.");
                    }
                    else if (Convert.ToDateTime(OpenTimeMaskT.Text.ToString()) >= Convert.ToDateTime(CloseTimeMaskT.Text.ToString()))
                    {
                        MessageBox.Show("Please input a closing time later than opening time!");
                    }

                    else
                    {
                        DateTime d1 = Convert.ToDateTime(OpenTimeMaskT.Text.ToString());
                        opentime = new DateTime(1900, 1, 1, d1.Hour, d1.Minute, d1.Second);//


                        if (CloseTimeMaskT.MaskedTextProvider.AssignedEditPositionCount == 0)
                        {
                            MessageBox.Show("Please input the Closing Time.");
                        }
                        else
                        {
                            DateTime d2 = Convert.ToDateTime(CloseTimeMaskT.Text.ToString());

                            closetime = new DateTime(1900, 01, 01, d2.Hour, d2.Minute, d2.Second);//


                            f.Location    = LocationTextB.Text;
                            f.Description = DescriptionTextB.Text;
                            f.Active      = 1;
                            f.OpeningTime = opentime;
                            f.ClosingTime = closetime;
                            ctx.SaveChanges();
                            MessageBox.Show("Successfully updated Facility.");
                        }
                    }
                }
            }
        }
        private void AddFacilityButton_Click(object sender, EventArgs e)
        {
            Facility f    = new Facility();
            int      flag = 0;
            DateTime opentime;
            DateTime closetime;

            string inputname = FacilityNameTxtB.Text;

            if (inputname == "")
            {
                MessageBox.Show("Please input the Facility Name.");
            }

            else
            {
                foreach (Facility f1 in ctx.Facilities)
                {
                    if (f1.Name.ToLower() == inputname.ToLower())
                    {
                        flag++; break;
                    }
                }
                if (flag > 0)
                {
                    MessageBox.Show("This Facility Name already exists. Please input a different one."); flag = 0;
                }
                else
                {
                    f.Name = inputname;

                    if (typename == "")
                    {
                        MessageBox.Show("Please choose a Facility Type.");
                    }
                    else
                    {
                        FacilityType ft = ctx.FacilityTypes.Where(x => x.Name == typename).FirstOrDefault(); //found selected facilitytype
                        f.TypeID = ft.TypeID;                                                                // set facility typeid

                        if (OpenHrsMskTxB.MaskedTextProvider.AssignedEditPositionCount == 0)
                        {
                            MessageBox.Show("Please input the Opening Time.");
                        }
                        else if (Convert.ToDateTime(OpenHrsMskTxB.Text.ToString()) >= Convert.ToDateTime(CloseHrsMskTxB.Text.ToString()))
                        {
                            MessageBox.Show("Please input a closing time later than opening time!");
                        }

                        else
                        {
                            DateTime d1 = Convert.ToDateTime(OpenHrsMskTxB.Text.ToString());

                            //OpenHrsMskTxB.value.hour
                            opentime = new DateTime(1900, 1, 1, d1.Hour, d1.Minute, d1.Second);//

                            if (CloseHrsMskTxB.MaskedTextProvider.AssignedEditPositionCount == 0)
                            {
                                MessageBox.Show("Please input the Closing Time.");
                            }
                            else
                            {
                                DateTime d2 = Convert.ToDateTime(CloseHrsMskTxB.Text.ToString());

                                closetime = new DateTime(1900, 01, 01, d2.Hour, d2.Minute, d2.Second);//

                                f.Location    = LocationTexB.Text;
                                f.Description = DescriptionTexB.Text;
                                f.Active      = 1;
                                f.OpeningTime = opentime;
                                f.ClosingTime = closetime;

                                ctx.Facilities.Add(f);
                                ctx.SaveChanges();
                                MessageBox.Show("Successfully added Facility.");
                            }
                        }
                    }
                }
            }
        }