public void TestThatConstructorInitializeFormClass()
{
var fixture = new Fixture();
var nameSource = fixture.CreateAnonymous <string>();
var nameTarget = fixture.CreateAnonymous <string>();
var description = fixture.CreateAnonymous <string>();
var formClass = new FormClass(nameSource, nameTarget, description);
Assert.That(formClass, Is.Not.Null);
Assert.That(formClass.NameSource, Is.Not.Null);
Assert.That(formClass.NameSource, Is.Not.Empty);
Assert.That(formClass.NameSource, Is.EqualTo(nameSource));
Assert.That(formClass.NameTarget, Is.Not.Null);
Assert.That(formClass.NameTarget, Is.Not.Empty);
Assert.That(formClass.NameTarget, Is.EqualTo(nameTarget));
Assert.That(formClass.Description, Is.Not.Null);
Assert.That(formClass.Description, Is.Not.Empty);
Assert.That(formClass.Description, Is.EqualTo(description));
Assert.That(formClass.FormClassName, Is.Not.Null);
Assert.That(formClass.FormClassName, Is.Not.Empty);
Assert.That(formClass.FormClassName, Is.EqualTo(nameTarget));
Assert.That(formClass.FormClassText, Is.Not.Null);
Assert.That(formClass.FormClassText, Is.Not.Empty);
Assert.That(formClass.FormClassText, Is.EqualTo(description));
}
private void Form1_Load(object sender, EventArgs e)
{
this.Resize += new EventHandler(FormClass.FormResize);
FormClass.setValues(this.Width, this.Height, this);
FormClass.setTag(this);
FormClass.FormResize(new object(), new EventArgs());
}
/// <summary>
/// 窗体刷新
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Form12_Load(object sender, EventArgs e)
{
comboBox1.Items.Clear();
comboBox1.Items.Add("未使用");
comboBox1.Items.Add("已过期");
comboBox1.Items.Add("已使用");
comboBox1.Items.Add("");
this.comboBox1.SelectedIndex = 3;
string ConStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
//刷新datagridview界面
string sqlSel1 = "SELECT Order_ID,Movie_Name,Seat_ID,Customer_ID,Order_Time,BeginTime,[Order].Timing_ID,Order_Price,Condition" +
" FROM dbo.[Order],dbo.Timing,dbo.Movie" +
" WHERE [Order].Timing_ID=Timing.Timing_ID AND Timing.Movie_ID=Movie.Movie_ID";
SqlConnection con = new SqlConnection(ConStr);
con.Open();
SqlCommand sc = new SqlCommand(sqlSel1, con);
SqlDataAdapter sda = new SqlDataAdapter(sc); //创建一个适配器
DataSet ds = new DataSet(); //创建一个DataSet来接受适配器的内容
sda.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
con.Close();
con.Dispose();
//在加载出datagridview后之后可以自动选定第一行
this.dataGridView1.Rows[0].Selected = true;
//在形成datagridview后给生成的列命名
dataGridView1.Columns[0].HeaderText = "订单号";
dataGridView1.Columns[1].HeaderText = "电影名称";
dataGridView1.Columns[2].HeaderText = "座位号";
dataGridView1.Columns[3].HeaderText = "用户名";
dataGridView1.Columns[4].HeaderText = "订单时间";
dataGridView1.Columns[5].HeaderText = "开始时间";
dataGridView1.Columns[6].HeaderText = "排片编号";
dataGridView1.Columns[7].HeaderText = "支付价格";
dataGridView1.Columns[8].HeaderText = "订单状态";
//让窗体中控件可以跟随着窗体大小变化而改变大小
this.Resize += new EventHandler(FormClass.FormResize);
FormClass.setValues(this.Width, this.Height, this);
FormClass.setTag(this);
FormClass.FormResize(new object(), new EventArgs());
//根据数据内容自动调整列宽
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
/// <summary>
/// 窗体加载函数
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Form13_Load(object sender, EventArgs e)
{
//用于最开始打开数据库就可以获取数据库的信息
string ConStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
SqlConnection conn = new SqlConnection(ConStr);
try
{
conn.Open();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString() + "打开数据库失败");
}
string sqlSel = "SELECT Customer_ID," +
"Customer_Password," +
"Customer_Name," +
"Customer_Contact," +
"Customer_Class," +
"Customer_LoginState" +
" FROM dbo.Customer WHERE Customer_isActive = 1"; //找出除了Customer_isActive外的所有属性的元组
SqlCommand sc = new SqlCommand(sqlSel, conn);
SqlDataAdapter sda = new SqlDataAdapter(sc);
DataSet ds = new DataSet();
sda.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
conn.Close();
conn.Dispose();
//在加载出datagridview后之后可以自动选定第一行
this.dataGridView1.Rows[0].Selected = true;
//在形成datagridview之后给生成的列进行编号
dataGridView1.Columns[0].HeaderText = "用户ID";
dataGridView1.Columns[1].HeaderText = "密码";
dataGridView1.Columns[2].HeaderText = "姓名";
dataGridView1.Columns[3].HeaderText = "联系方式";
dataGridView1.Columns[4].HeaderText = "VIP等级";
dataGridView1.Columns[5].HeaderText = "登录状态";
//让窗体中控件可以跟随着窗体大小变化而改变大小
this.Resize += new EventHandler(FormClass.FormResize);
FormClass.setValues(this.Width, this.Height, this);
FormClass.setTag(this);
FormClass.FormResize(new object(), new EventArgs());
//根据数据内容自动调整列宽
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
/// <summary>
/// 窗体刷新
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Form11_Load(object sender, EventArgs e)
{
string ConStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
//刷新datagridview界面
string sqlSel1 = "SELECT Timing_ID," +
"Hall_ID," +
"dbo.Timing.Movie_ID," +
"Movie_Name," +
"Timing_Price," +
"BeginTime," +
"convert(varchar, dateadd(minute,Movie_Time,BeginTime), 120) as EndTime" +
" FROM dbo.Timing,dbo.Movie" +
" WHERE Timing_isActive<>0 AND dbo.Timing.Movie_ID=dbo.Movie.Movie_ID";
SqlConnection con = new SqlConnection(ConStr);
con.Open();
SqlCommand sc = new SqlCommand(sqlSel1, con);
SqlDataAdapter sda = new SqlDataAdapter(sc); //创建一个适配器
DataSet ds = new DataSet(); //创建一个DataSet来接受适配器的内容
sda.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
con.Close();
con.Dispose();
//在加载出datagridview后之后可以自动选定第一行
this.dataGridView1.Rows[0].Selected = true;
//在选定了datagridview后给列命名
dataGridView1.Columns[0].HeaderText = "排片号";
dataGridView1.Columns[1].HeaderText = "影厅号";
dataGridView1.Columns[2].HeaderText = "电影编号";
dataGridView1.Columns[3].HeaderText = "电影名字";
dataGridView1.Columns[4].HeaderText = "排片价格";
dataGridView1.Columns[5].HeaderText = "开始时间";
dataGridView1.Columns[6].HeaderText = "结束时间";
//让窗体中控件可以跟随着窗体大小变化而改变大小
this.Resize += new EventHandler(FormClass.FormResize);
FormClass.setValues(this.Width, this.Height, this);
FormClass.setTag(this);
FormClass.FormResize(new object(), new EventArgs());
//根据数据内容自动调整列宽
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
private void Form14_Load(object sender, EventArgs e)
{
timer1.Start();
this.Resize += new EventHandler(FormClass.FormResize);
FormClass.setValues(this.Width, this.Height, this);
FormClass.setTag(this);
FormClass.FormResize(new object(), new EventArgs());
Form15 f = new Form15();
f.TopLevel = false;
f.FormBorderStyle = FormBorderStyle.None;
this.panel1.Controls.Clear();
this.panel1.Controls.Add(f);
//panel控件内显示窗体
f.Show();
}
/// <summary>
/// 窗体刷新
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Form10_Load(object sender, EventArgs e)
{
string ConStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
//刷新datagridview界面
string sqlSel1 = "SELECT Movie_ID, Movie_Name, Movie_Time, Movie_Actor, Movie_Director, Movie_Language, Movie_Type, Movie_Intro, Movie_Poster, ReleaseDate, DownDate FROM dbo.Movie WHERE Movie_isActive=1";
SqlConnection con = new SqlConnection(ConStr);
con.Open();
SqlCommand sc = new SqlCommand(sqlSel1, con);
SqlDataAdapter sda = new SqlDataAdapter(sc); //创建一个适配器
DataSet ds = new DataSet(); //创建一个DataSet来接受适配器的内容
sda.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
con.Close();
con.Dispose();
//在加载出datagridview后之后可以自动选定第一行
this.dataGridView1.Rows[0].Selected = true;
//给形成的datagridview中的列进行命名
dataGridView1.Columns[0].HeaderText = "电影编号";
dataGridView1.Columns[1].HeaderText = "电影名字";
dataGridView1.Columns[2].HeaderText = "电影时长";
dataGridView1.Columns[3].HeaderText = "电影主演";
dataGridView1.Columns[4].HeaderText = "电影导演";
dataGridView1.Columns[5].HeaderText = "电影语言";
dataGridView1.Columns[6].HeaderText = "电影类型";
dataGridView1.Columns[7].HeaderText = "电影简介";
dataGridView1.Columns[8].HeaderText = "电影海报";
dataGridView1.Columns[9].HeaderText = "上映时间";
dataGridView1.Columns[10].HeaderText = "下架时间";
//让窗体中控件可以跟随着窗体大小变化而改变大小
this.Resize += new EventHandler(FormClass.FormResize);
FormClass.setValues(this.Width, this.Height, this);
FormClass.setTag(this);
FormClass.FormResize(new object(), new EventArgs());
//根据数据内容自动调整列宽
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
public ActionResult Edit(FormClass f1, string status)
{
ServiceReference1.BlankettService1Client client = new ServiceReference1.BlankettService1Client();
//STATUS = ACCEPTED, PENDING OR DECLINED
ServiceReference1.Blankett b1 = new ServiceReference1.Blankett();
b1.FormId = f1.FormId;
b1.InmateSSN = f1.InmateSSN;
b1.VisitorFName = f1.VisitorFName;
b1.VisitorLName = f1.VisitorLName;
b1.PersonOfInterestFName = f1.PersonOfInterestFName;
b1.PersonOfInterestLName = f1.PersonOfInterestLName;
b1.PhoneNumber = f1.PhoneNumber;
b1.EMail = f1.EMail;
b1.Status = status;
client.ChangeStatusForm(b1, status);
return(RedirectToAction("Index", "Admin"));
}
public ActionResult Edit(FormClass f1, int id)
{
if (id == null)
{
return(RedirectToAction("Index", "Admin"));
}
ServiceReference1.BlankettService1Client client = new ServiceReference1.BlankettService1Client();
ServiceReference1.Blankett b1 = client.GetFormWithId(id);
f1.FormId = b1.FormId;
f1.InmateSSN = b1.InmateSSN;
f1.VisitorFName = b1.VisitorFName;
f1.VisitorLName = b1.VisitorLName;
f1.PersonOfInterestFName = b1.PersonOfInterestFName;
f1.PersonOfInterestLName = b1.PersonOfInterestLName;
f1.PhoneNumber = b1.PhoneNumber;
f1.EMail = b1.EMail;
f1.Status = b1.Status;
return(View(f1));
}
public ActionResult Form(FormClass form)
{
ServiceReference1.BlankettService1Client asd = new ServiceReference1.BlankettService1Client();
//form id status
form.FormId = 0;
form.Status = "";
ServiceReference1.Blankett asd1 = new ServiceReference1.Blankett();
asd1.FormId = form.FormId;
asd1.VisitorFName = form.VisitorFName;
asd1.VisitorLName = form.VisitorLName;
asd1.PersonOfInterestFName = form.PersonOfInterestFName;
asd1.PersonOfInterestLName = form.PersonOfInterestLName;
asd1.InmateSSN = form.InmateSSN;
asd1.PhoneNumber = form.PhoneNumber;
asd1.EMail = form.EMail;
asd1.Status = form.Status;
form.Status = asd.SaveForm(asd1);
return(View(form));
}
/// <summary>
/// 窗体刷新
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Form9_Load(object sender, EventArgs e)
{
string ConStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
//刷新datagridview界面
string sqlSel1 = "SELECT Hall_ID,Hall_Row,Hall_Column FROM dbo.Hall WHERE Hall_isActive=1";
SqlConnection con = new SqlConnection(ConStr);
con.Open();
SqlCommand sc = new SqlCommand(sqlSel1, con);
SqlDataAdapter sda = new SqlDataAdapter(sc); //创建一个适配器
DataSet ds = new DataSet(); //创建一个DataSet来接受适配器的内容
sda.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
con.Close();
con.Dispose();
//在加载出datagridview后之后可以自动选定第一行
this.dataGridView1.Rows[0].Selected = true;
//给形成的datagridview中的列进行命名
dataGridView1.Columns[0].HeaderText = "影厅编号";
dataGridView1.Columns[1].HeaderText = "影厅行号";
dataGridView1.Columns[2].HeaderText = "影厅列号";
//让窗体中控件可以跟随着窗体大小变化而改变大小
this.Resize += new EventHandler(FormClass.FormResize);
FormClass.setValues(this.Width, this.Height, this);
FormClass.setTag(this);
FormClass.FormResize(new object(), new EventArgs());
//根据数据内容自动调整列宽
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
public IActionResult Index(FormClass model)
{
return(View(model));
}
public ActionResult Index(FormClass model) // Post Action
{
Boolean error = false;
if ((model is null) || (model.Operation is null)) // Validating that the data is not empty
{
model.Error_Message = "Unvalid entry";
error = true;
}
if (!error)
{
Stack Numbers = new Stack(); // Stores the data I read from the chain in a stack
String temp = ""; // Temporarily save the character
Boolean insert = false; // Variable that authorizes saving on the stack
int i = 0; // Counter
while ((i < model.Operation.Length) && (!error))
{
if ((Char.IsNumber(model.Operation[i])) || // Validating allowed characters
(model.Operation[i] == 'S') ||
(model.Operation[i] == '+') ||
(model.Operation[i] == '-') ||
(model.Operation[i] == '/') ||
(model.Operation[i] == '*') ||
(model.Operation[i] == ',') ||
(model.Operation[i] == '.') ||
(model.Operation[i] == ' '))
{
if (model.Operation[i] == '+') // Sum
{
model.Text.Add(
Operations(
ref temp, ref Numbers, ref insert, "+"));
}
else if (model.Operation[i] == '-') // Subtraction
{
model.Text.Add(
Operations(
ref temp, ref Numbers, ref insert, "-"));
}
else if (model.Operation[i] == '*') // Multiplication
{
model.Text.Add(
Operations(
ref temp, ref Numbers, ref insert, "*"));
}
else if (model.Operation[i] == '/') // Division
{
model.Text.Add(
Operations(
ref temp, ref Numbers, ref insert, "/"));
}
else if (model.Operation[i] == 'S') // Square root
{
model.Text.Add(
Operations(
ref temp, ref Numbers, ref insert, "S"));
}
else if (model.Operation[i] != ' ') // Not a space and not operator, then a number
{
temp = temp + model.Operation[i]; // Creating the string with the number
insert = true;
}
else if (insert == true) // Blank space. After a number, insert.
{
Numbers.Push(Convert.ToDouble(temp)); // Inserting the number in the stack
temp = "";
insert = false;
}
i++;
}
else
{
model.Error_Message = "Unvalid entry"; // Feedback message
error = true;
}
}
}
return(View(model));
}
public ActionResult Index() // Get Action (For the first time)
{
FormClass model = new FormClass();
return(View(model));
}
private void AdminContainer_Load(object sender, EventArgs e)
{
//display logged in user
userFullNameLabel.Text = string.IsNullOrEmpty(AdminFullName) ? AdminFullName : "Logged in as " + AdminFullName;
//populate datagrid view with data
AdminConnect adminConnect = new AdminConnect();
insTbl = adminConnect.GetInstructors();
instructorDataGridView.DataSource = insTbl;
FormClass.AddDatagridButtons(instructorDataGridView, 3, true);
stuTbl = adminConnect.GetStudents();
studentDataGridView.DataSource = stuTbl;
FormClass.AddDatagridButtons(studentDataGridView, 3, true);
claTbl = adminConnect.GetClasses();
classDataGridView.DataSource = claTbl;
FormClass.AddDatagridButtons(classDataGridView, 3, true);
rubTbl = adminConnect.GetRubric();
rubricDataGridView.DataSource = rubTbl;
FormClass.AddDatagridButtons(rubricDataGridView, 3, true);
couTbl = adminConnect.GetCourse();
courseDataGridView.DataSource = couTbl;
FormClass.AddDatagridButtons(courseDataGridView, 3, true);
//bind views to datatable
#region BindInstructor
try
{
instructorBindingSrc = new BindingSource();
instructorBindingSrc.DataSource = adminConnect.GetInstructors();
IuserIdViewComboBox.Items.Clear();
IuserIdViewComboBox.DataSource = instructorBindingSrc;
IuserIdViewComboBox.ValueMember = "userId";
IuserIdViewComboBox.DisplayMember = "userId";
IuserIdViewComboBox.DataBindings.Add("Text", instructorBindingSrc, "userId", false);
if (!string.IsNullOrEmpty((string)IuserIdViewComboBox.SelectedValue) && !string.IsNullOrEmpty(IuserIdViewComboBox.Text))
{
//bind other controls
iPasswordViewtextBox.DataBindings.Add("Text", instructorBindingSrc, "password", false);
iFirstNameViewtextBox.DataBindings.Add("Text", instructorBindingSrc, "fName", false);
iLastNameViewTextBox.DataBindings.Add("Text", instructorBindingSrc, "lName", false);
iEmailViewTextBox.DataBindings.Add("Text", instructorBindingSrc, "email", false);
iPhoneViewTextBox.DataBindings.Add("Text", instructorBindingSrc, "phone", false);
}
else
{
errorProvider1.SetError(IuserIdViewComboBox, "Invalid selection");
return;
}
}
catch (Exception)
{
throw;
}
#endregion
#region BindStudent
try
{
studentBindingSrc = new BindingSource();
}
catch (Exception)
{
throw;
}
#endregion
#region BindClass
try
{
classBindingSrc = new BindingSource();
}
catch (Exception)
{
throw;
}
#endregion
#region BindCourse
try
{
courseBindingSrc = new BindingSource();
}
catch (Exception)
{
throw;
}
#endregion
#region BindRubric
try
{
rubricBindingSrc = new BindingSource();
}
catch (Exception)
{
throw;
}
#endregion
}
public IndirectClass(FormClass form)
{
_form = form;
}