private void btn_Alterar_Click(object sender, EventArgs e)
{
//Ticket ticket = new Ticket();
//ticket.NomePessoa = "Flávio";
//ticket.Assunto = "teste";
//ticket.CodigoPessoa = 1;
//ticket.CodigoStatus = 1;
//ticket.CodigoServico = 1;
//ticket.CodigoUrgencia = 1;
//ticket.CodigoResponsavel = 2;
//ticket.NomeResponsavel = "Matheus";
//ticket.PrevisaoTermico = DateTime.Now;
//List<Mensagem> aux = new List<Mensagem>();
//aux.Add(new Mensagem(1, 1, "Flávio", DateTime.Now, "Teste"));
//ticket.ListaAcoes = aux.AsEnumerable();
//ticket.ListaAcoes.Count();
try
{
string id = dataGridTicket.CurrentRow.Cells[0].Value.ToString();
Ticket t = TicketDAL.GetInstancia().LocarizarPorCodigo(int.Parse(id));
CadastroTicket c = CadastroTicket.GetInstancia(t);
c.incluir(this);
c.Show();
}
catch (Exception ex)
{
MessageBox.Show($"Erro!!!\nNão foi possivel abrir este Ticket. " + ex.Message, $"Lista de Chamados");
}
}
//Return All tickets page
public ActionResult AllTickets()
{
var TicketDAL = new TicketDAL();
List <Ticket> AllTickets = TicketDAL.getAllTickets();
return(View(AllTickets));
}
public ActionResult getReceipt(int id)
{
var TicketDAL = new TicketDAL();
var t = TicketDAL.getTicketByID(id);
return(View(t));
}
private void toolStripButton3_Click(object sender, EventArgs e)
{
Ticket model = new Ticket();
bool erro = false;
try
{
model.Id = (int.Parse(dataGridTicket.CurrentRow.Cells[0].Value.ToString()));
model = TicketDAL.GetInstancia().LocarizarPorCodigo(model.Id);
}
catch (Exception)
{
MessageBox.Show($"Erro!!!\nSelecione um Ticket para poder Deletar", $"Lista de Chamados");
erro = true;
}
if (erro == false)
{
try
{
TicketDAL.GetInstancia().Remover(model);
CarregarGrid(type);
}
catch (Exception ex)
{
MessageBox.Show("Erro ao tentar Deletar Ticket!!!\n" + ex.Message, $"Lista de Chamados");
}
}
}
/// <summary>
/// 填充数据网格
/// </summary>
void FillDataGirdView()
{
//清理数据源、清理列（防止列按钮不断增加）
dataGridView1.DataSource = null;
dataGridView1.Columns.Clear();
dataGridView1.DataSource = TicketDAL.FindList(null);
dataGridView1.Columns["movieName"].HeaderText = "电影名";
dataGridView1.Columns["date"].HeaderText = "上映日期";
dataGridView1.Columns["price"].HeaderText = "票价";
}
/// <summary>
/// 点击加载数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Btn_Click(object sender, EventArgs e)
{
Ticket model = TicketDAL.FindModel(new Ticket(Convert.ToInt32(textBox3.Text)), "id");
if (model != null)
{
textBox6.Text = model.movieName;
textBox7.Text = model.date;
textBox5.Text = model.price;
}
}
/// <summary>
/// 点击关键字查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button1_Click(object sender, EventArgs e)
{
//清理数据源、清理列（防止列按钮不断增加）
dataGridView1.DataSource = null;
dataGridView1.Columns.Clear();
//like模糊查询
dataGridView1.DataSource = TicketDAL.FindDataTable(string.Format("SELECT * FROM [ticket] WHERE [movieName] LIKE '%{0}%'", textBox1.Text));
dataGridView1.Columns["movieName"].HeaderText = "电影名";
dataGridView1.Columns["date"].HeaderText = "上映日期";
dataGridView1.Columns["price"].HeaderText = "票价";
}
public ActionResult getReceipt(Ticket t)
{
var TicketDAL = new TicketDAL();
int newTikcetID = TicketDAL.SaveTicket(t);
if (newTikcetID != 0)
{
return(Json(new { id = newTikcetID, newurl = Url.Action("getReceipt") }));
}
return(View());
}
/// <summary>
/// 点击新增按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button2_Click(object sender, EventArgs e)
{
Ticket model = new Ticket();
model.movieName = textBox2.Text;
model.date = dateTimePicker1.Text; //仅显示日期，XX年XX月XX日
model.price = textBox4.Text;
TicketDAL.Add(model);
//显示数据网格
FillDataGirdView();
}
private void btn_Imprimir_Click(object sender, EventArgs e)
{
try
{
string id = dataGridTicket.CurrentRow.Cells[0].Value.ToString();
Ticket t = TicketDAL.GetInstancia().LocarizarPorCodigo(int.Parse(id));
Util.EscreverPDF($"Ticket{t.Id}.pdf", t.Imprimir());
}
catch (Exception ex)
{
MessageBox.Show($"Erro!!!\nNão foi possivel imprimir este Ticket. " + ex.Message, $"Lista de Chamados");
}
}
/// <summary>
/// 点击删除按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button4_Click(object sender, EventArgs e)
{
if (textBox8.Text == "")
{
MessageBox.Show("ID不可为空"); return;
}
Ticket model = new Ticket();
model.Id = Convert.ToInt32(textBox8.Text);
if (TicketDAL.FindModel(new Ticket(model.Id), "id") == null)
{
MessageBox.Show("不存在此ID"); return;
}
if (TicketDAL.Drop(model, "id"))
{
FillDataGirdView(); MessageBox.Show("删除成功"); return;
}
}
void CarregarGrid(OrdenarTicketType type)
{
List <Ticket> tickets = null;
try
{
dataGridTicket.AutoGenerateColumns = false;
TicketDAL ticketDAL = TicketDAL.GetInstancia();
ticketDAL.OrdenarPor(type);
tickets = ticketDAL.ListarPorParametros(txt_Pesquisar.Text, dt_Inicio.Value, dt_Final.Value).ToList();
dataGridTicket.DataSource = null;
dataGridTicket.DataSource = tickets;
}
catch (Exception ex)
{
MessageBox.Show($"Erro!!!\nNão foi possivel buscar os Tickets no Banco de Dados. " + ex.Message, $"Lista de Chamados");
}
}
/// <summary>
/// 点击修改按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button3_Click(object sender, EventArgs e)
{
if (textBox3.Text == "")
{
MessageBox.Show("ID不可为空"); return;
}
Ticket model = new Ticket();
model.Id = Convert.ToInt32(textBox3.Text);
model.movieName = textBox6.Text;
model.date = textBox7.Text;
model.price = textBox5.Text;
if (TicketDAL.FindModel(new Ticket(model.Id), "id") == null)
{
MessageBox.Show("不存在此ID"); return;
}
if (TicketDAL.AlterByPK(model, "id"))
{
FillDataGirdView(); MessageBox.Show("修改成功"); return;
}
}
public static Int32 Insert(TicketDAL newIssue)
{
SqlCommand insertCommand = new SqlCommand("CREATE_TICKET_USER", Connection);
insertCommand.CommandType = CommandType.StoredProcedure;
insertCommand.Parameters.AddWithValue("@issuer", newIssue.issuer);
insertCommand.Parameters.AddWithValue("@email", newIssue.email);
insertCommand.Parameters.AddWithValue("@dept", newIssue.dept);
insertCommand.Parameters.AddWithValue("@system", newIssue.system);
insertCommand.Parameters.AddWithValue("@probDesc", newIssue.probDesc);
insertCommand.Parameters.AddWithValue("@assignedto", newIssue.assignedTo);
insertCommand.Parameters.AddWithValue("@priority", newIssue.priority);
insertCommand.Parameters.AddWithValue("@repeatIssue", newIssue.repeatIssue);
insertCommand.Parameters.AddWithValue("@division", newIssue.division);
insertCommand.Parameters.AddWithValue("@SubSystem", newIssue.subsystem);
SqlParameter ticketID = new SqlParameter("@ticketID", SqlDbType.Int);
ticketID.Direction = ParameterDirection.Output;
insertCommand.Parameters.Add(ticketID);
try
{
Connection.Open();
insertCommand.ExecuteNonQuery();
return(int.Parse(ticketID.Value.ToString()));
}
catch (Exception ex)
{
throw ex;
}
finally
{
Connection.Close();
}
}
public TicketBL()
{
ticketDAL = new TicketDAL();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string problem;
//Employee Validation
if (ddlEmployee.SelectedValue == "000")
{
lblEmployee.Visible = true;
lblTest.Text = "Please select your name";
return;
}
else
{
lblTest.Text = "";
lblEmployee.Visible = false;
}
//Email Validation
if (txtEmail.Text.Trim() == "" || txtEmail.Text == null)
{
lblEmail.Visible = true;
lblTest.Text = "We require you to confirm your email address so we can ensure you receive all communication surrounding this ticket.";
return;
}
else if (txtEmail.Text.IndexOf("@") == -1)
{
lblEmail.Visible = true;
lblTest.Text = "We require you to confirm your email address so we can ensure you receive all communication surrounding this ticket.";
return;
}
else
{
lblTest.Text = "";
lblEmail.Visible = false;
}
//Department Validation
if (ddlDepartment.SelectedValue == "000")
{
lblDepartment.Visible = true;
lblTest.Text = "Please select your department";
return;
}
else
{
lblTest.Text = "";
lblDepartment.Visible = false;
}
//Systems validation
if (ddlSystem.SelectedValue == "000")
{
lblTest.Text = "Please select system affected";
lblSystem.Visible = true;
return;
}
else
{
lblTest.Text = "";
lblSystem.Visible = false;
}
//Sub Systems validation
if (ddlSubSystem.SelectedItem.Value == "PLEASE SELECT")
{
lblTest.Text = "Please select Sub-System affected";
lblSubsystemError.Visible = true;
return;
}
else
{
lblTest.Text = "";
lblSubsystemError.Visible = false;
}
if (tblPriority.Visible == true)
{
//Priority Validation
if (ddlPriority.SelectedValue == "000")
{
lblTest.Text = "Please select priority";
lblPriority.Visible = true;
return;
}
else
{
lblTest.Text = "";
lblPriority.Visible = false;
}
}
//Problem Description Validation
if (txtProbDescription.Text.Trim() == "" || txtProbDescription.Text == null)
{
lblTest.Text = "Please specify problem description";
lblDescription.Visible = true;
return;
}
else
{
lblTest.Text = "";
lblDescription.Visible = false;
}
//Repeat issue Validation
if (ddlRepeatIssue.SelectedValue == "000")
{
lblTest.Text = "Please specify if this is a reapeated issue";
lblRepeat.Visible = true;
return;
}
else
{
lblTest.Text = "";
lblRepeat.Visible = false;
}
if (tbInfo.Visible == true)
{
//Check and verify other feilds
if (tbBOLNumber.Text.Length > 80)
{
lblBOLError.Visible = true;
lblTest.Text = "BOL Number Must be less then 80 Characters";
}
if (tbContactExtension.Text.Length > 50)
{
lblContactExtentionError.Visible = true;
lblTest.Text = "Contact Extention Must be less then 50 Characters";
}
problem = "BOL #: " + tbBOLNumber.Text + Environment.NewLine + Environment.NewLine + "Description: " + txtProbDescription.Text + Environment.NewLine + Environment.NewLine + "EXT: " + tbContactExtension.Text;
}
else
{
problem = txtProbDescription.Text;
}
EmployeeDAL.Insert(Int32.Parse(ddlEmployee.SelectedItem.Value), txtEmail.Text,
ddlPlant.SelectedItem.Value, Int32.Parse(ddlDepartment.SelectedValue), "", "", "", 1);
//Calling the TicketDAL Class insert method to insert the new data to the database. Please see TicketDAL
TicketDAL Insert = new TicketDAL();
Insert.Subsystem = Int32.Parse(ddlSubSystem.SelectedValue);
Insert.Issuer = Int32.Parse(ddlEmployee.SelectedItem.Value);
Insert.Email = txtEmail.Text;
Insert.Division = ddlPlant.SelectedItem.Value;
Insert.Dept = Int32.Parse(ddlDepartment.SelectedValue);
Insert.System = Int32.Parse(ddlSystem.SelectedValue);
Insert.ProbDesc = problem;
Insert.AssignedTo = 1;
if (tblPriority.Visible == true)
{
Insert.Priority = Int32.Parse(ddlPriority.SelectedValue);
}
else
{
Insert.Priority = 1; //High
}
Insert.RepeatIssue = Int32.Parse(ddlRepeatIssue.SelectedValue);
int ticketID = TicketDAL.Insert(Insert);
lblTicketNumber.Text = ticketID.ToString();
ticketEntry.Visible = false;
if (tbInfo.Visible == true) //This is always false. Update Panel is not firing.
{
Response.Redirect("~/ASNInstructions.aspx?ticketID=" + ticketID.ToString());
}
else
{
Splash.Visible = true;
Splash.Controls.Add(new LiteralControl("<img src='images/confirmation.jpg'><br>"));
}
Response.Redirect("~/DetailTicketView.aspx?ID=" + ticketID.ToString());
}
private void button1_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(this.lblMovieName.Text))
{
MessageBox.Show("您还没选择电影!", "提示");
return;
}
int hID = tbSeat.SelectedIndex + 1;
TreeNode node = tvMovies.SelectedNode;
if (node == null)
{
return;
}
if (node.Level != 1)
{
return;
}
int sID = int.Parse(node.Name);
double totalCost = 0;
List <Ticket> selectSeats = new List <Ticket>();
string confireInfo = "您选择的电影票信息如下，请确认：\n\n";
foreach (CheckBox cb in checkBoxs[hID].Values)
{
if (cb.Checked && cb.Enabled == true)
{
selectSeats.Add(new Ticket(sID, cb.Text));
confireInfo += "电影名：" + lblMovieName.Text + " 场次：" + lblTime.Text + " 大厅：" + hID + " 座位：" + cb.Text + "\n";
totalCost += double.Parse(lblCalcPrice.Text);
}
}
if (selectSeats.Count < 1)
{
MessageBox.Show("您没有选择任何座位！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
confireInfo += "\n总金额：" + totalCost.ToString() + " 元";
if (MessageBox.Show(confireInfo, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
PayIsSuccess = false;
PayForm pf = new PayForm(false);
pf.Owner = this;
pf.payMoney = totalCost;
pf.ShowDialog();
//支付成功
if (PayIsSuccess)
{
//保存到数据库成功
if (TicketDAL.AddTickets(selectSeats))
{
//生成取票码
//更新位置信息
foreach (Ticket t in selectSeats)
{
Seat s = null;
if (seats[hID].TryGetValue(t.DetailSeat, out s))
{
s.Color = Color.LightCoral;
}
}
//更新UI
UpdateSeats(hID);
TicketForm tf = new TicketForm();
tf.Owner = this;
tf.ticketCode = DateTime.Now.ToFileTimeUtc().ToString();
tf.ShowDialog();
}
}
}
}
private void tvMovies_AfterSelect(object sender, TreeViewEventArgs e)
{
/// <summary>
/// 选择一场电影事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
TreeNode node = tvMovies.SelectedNode;
if (node == null)
{
return;
}
if (node.Level != 1)
{
return;
}
int sID = int.Parse(node.Name);
Schedule s = null;
Movie m = null;
s = ScheduleDAL.GetScheduleByScheduleID(sID);
if (s == null)
{
MessageBox.Show("s should not be null");
return;
}
m = MovieDAL.GetMovieByMovieID(s.MovieID);
if (m == null)
{
MessageBox.Show("m should not be null");
return;
}
//将详细信息显示
this.lblMovieName.Text = m.MovieName;
this.lblDirector.Text = m.Director;
this.lblActor.Text = m.Actor;
this.lblPrice.Text = s.Price.ToString();
this.lblTime.Text = s.DateTime;
this.lblType.Text = m.MovieType;
this.picMovie.Image = Image.FromFile(m.Poster);
if (this.customerVIP != null)
{
this.lblCalcPrice.Text = (s.Price * 0.8).ToString();
}
else
{
this.lblCalcPrice.Text = lblPrice.Text;
}
otherHallIDs.Clear();
foreach (int hID in AllHallIDs)
{
if (hID == s.HallID)
{
continue;
}
otherHallIDs.Add(hID);
}
//清空座位
ReSetSeats(s.HallID);
//遍历该场电影的座位销售情况
foreach (Ticket t in TicketDAL.GetTicketsByScheduleID(sID))
{
foreach (Seat seat in seats[s.HallID].Values)
{
if (t.DetailSeat == seat.SeatNum)
{
seat.Color = Color.LightCoral;
}
}
}
UpdateSeats(s.HallID);
tbSeat.SelectedTab = tbSeat.TabPages[s.HallID - 1];
}
public List <Ticket> GetAllTicketPageWise(int pageIndex, ref int recordCount, int length /*, int VesselID*/)
{
TicketDAL dAL = new TicketDAL();
return(dAL.GetAllTicketPageWise(pageIndex, ref recordCount, length /*, VesselID*/));
}
public string SaveTicket(Ticket ticket, int userType)
{
TicketDAL ticketDal = new TicketDAL();
return(ticketDal.SaveTicket(ticket, userType));
}
private void btn_Salvar_Click(object sender, EventArgs e)
{
if (!txt_Assunto.Text.Equals(""))
{
if (comboBoxPessoas.Text.Equals("") || comboBoxPessoas.SelectedValue == null)
{
erro = true;
MessageBox.Show($"Erro ao Salvar Ticket\n Mensagem de erro: Deve Selecionar uma Pessoa", $"Cadastro de Ticket");
}
if (comboBoxUsuario.Text.Equals("") || comboBoxUsuario.SelectedValue == null)
{
erro = true;
MessageBox.Show($"Erro ao Salvar Ticket\n Mensagem de erro: Deve Selecionar um Responsável", $"Cadastro de Ticket");
}
if (erro == false)
{
int idPessoa = (int)comboBoxPessoas.SelectedValue;
int idUsuario = (int)comboBoxUsuario.SelectedValue;
int idSevicos = (int)comboBoxServicos.SelectedValue;
int idStatus = (int)comboBoxStatus.SelectedValue;
int idUrgencia = (int)comboBoxUrgencia.SelectedValue;
ticket.CodigoPessoa = idPessoa;
ticket.CodigoResponsavel = idUsuario;
ticket.CodigoServico = idSevicos;
ticket.CodigoStatus = idStatus;
ticket.CodigoUrgencia = idUrgencia;
ticket.Assunto = txt_Assunto.Text;
ticket.DataAlteracao = DateTime.Now;
ticket.PrevisaoTermico = dateTimePrevisao.Value;
ticket.ListaAcoes = itens_acoes.AsEnumerable();
if (novo)
{
ticket.DataInicio = DateTime.Now;
try
{
TicketDAL.GetInstancia().Inserir(ticket);
notificarObservador();
//cadastoSimplesDao.Inserir(model);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show($"Erro ao incluir Ticket\n Mensagem de erro: " + ex, $"Cadastro de Ticket");
}
}
else
{
try
{
//cadastoSimplesDao.Atualizar(model);
TicketDAL.GetInstancia().Atualizar(ticket);
notificarObservador();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show($"Erro ao alterar Ticket\n Mensagem de erro: " + ex, $"Cadastro de Ticket");
}
}
}
}
else
{
MessageBox.Show($"Erro!!!\nAssunto deve ser preecnido", $"Cadastro de Ticket");
}
}
public static List <Ticket> getAllTicketsForSpectacle(string spectacol)
{
List <Ticket> tickets = TicketDAL.getAllTicketsForSpectacle(spectacol);
return(tickets);
}
public static OperationResult.opResult addTicketForSpectacle(string code, string spectacol, int rand, int numar)
{
OperationResult.opResult result = TicketDAL.addTicketForSpectacle(code, spectacol, rand, numar);
return(result);
}
