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."); } } } } } }