public static Guid? StatusId(string status) { TicketsBLL bll = new TicketsBLL(); StatusesTableAdapter ta = new StatusesTableAdapter(); Guid? id = ta.GetId(status); return id; }
private void EliminarButton_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(TicketIdTextBox.Text)) { MessageBox.Show("LLena el campo con el numero de Ticket"); } else { var ticket = TicketsBLL.Buscar(Convert.ToInt32(TicketIdTextBox.Text)); if (ticket != null) { IdLoteriatextBox.Text = (ticket.IdLoteria).ToString(); NombreLoteriatextBox.Text = (ticket.NombreLoteria).ToString(); FechadateTimePicker.Text = (ticket.Fecha).ToString(); Usuariolabel.Text = ticket.Usuario.ToString(); TotaltextBox.Text = ticket.Total.ToString(); DatosdataGridView.DataSource = null; DatosdataGridView.DataSource = ticket.detalles; DatosdataGridView.Columns[0].Visible = false; DatosdataGridView.Columns[1].Visible = false; DatosdataGridView.Columns[2].Visible = false; DialogResult dialogo = MessageBox.Show("Desea Borrar el Ticket", "Borrarando Ticket", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dialogo == DialogResult.Yes) { int TicketId = Utilidades.ToInt(TicketIdTextBox.Text); TicketsBLL.Eliminar(TicketId); MontotextBox.Clear(); JugadatextBox.Clear(); IdLoteriatextBox.Clear(); NombreLoteriatextBox.Clear(); TotaltextBox.Clear(); TicketIdTextBox.Clear(); DatosdataGridView.DataSource = null; DatosdataGridView.Columns[0].Visible = true; DatosdataGridView.Columns[2].Visible = true; DatosdataGridView.Columns[1].Visible = true; TicketIdTextBox.Focus(); } } else { MessageBox.Show("Este Ticket no Existe"); MontotextBox.Clear(); JugadatextBox.Clear(); IdLoteriatextBox.Clear(); NombreLoteriatextBox.Clear(); TotaltextBox.Clear(); TicketIdTextBox.Clear(); DatosdataGridView.DataSource = null; DatosdataGridView.Columns[0].Visible = true; DatosdataGridView.Columns[2].Visible = true; DatosdataGridView.Columns[1].Visible = true; TicketIdTextBox.Focus(); } } }
protected void Yes_Click(object sender, EventArgs e) { TicketsBLL bll = new TicketsBLL(); try { bll.implementationDate = Convert.ToDateTime(ImplemenatationDate.Text); } catch { } bll.statusId = (Guid)Utility.StatusId("Complete"); bll.Id = m_ticketId; bll.Update(); GoBack(); }
protected void Yes_Click(object sender, EventArgs e) { TicketsBLL bll = new TicketsBLL(); bll.canceledBy = (Guid)Membership.GetUser().ProviderUserKey; bll.cancelComment = CancelComment.Text; bll.canceledOn = DateTime.Now; bll.Id = m_ticketId; bll.Update(); GoBack(); }
private void GuardarButton_Click_1(object sender, EventArgs e) { if (Utilidades.ToInt(TotaltextBox.Text) > 0) { int Id; int.TryParse(TicketIdTextBox.Text, out Id); ticket.IdLoteria = Utilidades.ToInt(IdLoteriatextBox.Text); ticket.Fecha = FechadateTimePicker.Value; ticket.Usuario = "Juan peres"; ticket.Nulo = false; ticket.Total = Utilidades.ToInt(TotaltextBox.Text); ticket.IdDetalle = 1; ticket.IdTicket = Id; ticket.NombreLoteria = NombreLoteriatextBox.Text; if (TicketsBLL.Guardar(ticket)) { MessageBox.Show("Guardado"); DatosdataGridView.DataSource = null; MontotextBox.Clear(); JugadatextBox.Clear(); IdLoteriatextBox.Clear(); NombreLoteriatextBox.Clear(); TotaltextBox.Clear(); TicketIdTextBox.Clear(); Usuariolabel.Text = ""; DatosdataGridView.DataSource = null; DatosdataGridView.Columns[0].Visible = true; DatosdataGridView.Columns[2].Visible = true; DatosdataGridView.Columns[1].Visible = true; IdLoteriatextBox.Focus(); } else { MessageBox.Show("Error hay Guardar el ticket"); IdLoteriatextBox.Focus(); } } else { MessageBox.Show("Tienes que insertar al menos una jugada..."); IdLoteriatextBox.Focus(); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Assign_Click(object sender, EventArgs e) { int count = Resources.Rows.Count; TicketsUsersTableAdapter trta = new TicketsUsersTableAdapter(); MembershipUser myObject = Membership.GetUser(); string UserID = myObject.ProviderUserKey.ToString(); bool atLeastOneChecked = false; foreach (GridViewRow row in Resources.Rows) { object name = row.FindControl("Username") as object; CheckBox cb = row.FindControl("SelectUser") as CheckBox; Label txt = row.FindControl("Id") as Label; Guid id = new Guid(txt.Text); int nRecords = (int)trta.DoesRecordExist(m_ticketId, id); if ((nRecords == 0) && cb.Checked) { // store data in database... trta.Insert(id, m_ticketId, DateTime.Now, new Guid(UserID)); atLeastOneChecked = true; } else if ((nRecords > 0) && !cb.Checked) { // delete record... trta.DeleteTicketByUserId(id, m_ticketId); } } Context.Items.Add("TicketId", m_ticketId); TicketsBLL bll = new TicketsBLL(); bll.statusId = (Guid)Utility.StatusId(atLeastOneChecked ? "In Progress" : "Pending"); bll.Id = new Guid(Request.QueryString["Id"]); bll.Update(); GoBack(); }
private void Buscarbutton_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(TicketIdTextBox.Text)) { MessageBox.Show("LLena el campo con el numero de Ticket"); } else { var ticket = TicketsBLL.Buscar(Convert.ToInt32(TicketIdTextBox.Text)); if (ticket != null) { IdLoteriatextBox.Text = (ticket.IdLoteria).ToString(); NombreLoteriatextBox.Text = (ticket.NombreLoteria).ToString(); FechadateTimePicker.Text = (ticket.Fecha).ToString(); Usuariolabel.Text = ticket.Usuario.ToString(); TotaltextBox.Text = ticket.Total.ToString(); DatosdataGridView.DataSource = null; DatosdataGridView.DataSource = ticket.detalles; DatosdataGridView.Columns[0].Visible = false; DatosdataGridView.Columns[1].Visible = false; DatosdataGridView.Columns[2].Visible = false; } else { MessageBox.Show("Este Ticket no Existe"); MontotextBox.Clear(); JugadatextBox.Clear(); IdLoteriatextBox.Clear(); NombreLoteriatextBox.Clear(); TotaltextBox.Clear(); TicketIdTextBox.Clear(); DatosdataGridView.DataSource = null; DatosdataGridView.Columns[0].Visible = true; DatosdataGridView.Columns[2].Visible = true; DatosdataGridView.Columns[1].Visible = true; TicketIdTextBox.Focus(); } } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Create_Click(object sender, EventArgs e) { if (PageValid()) { DropDownList dept = Panel1.FindControl("dept") as DropDownList; DropDownList group = Panel1.FindControl("Group") as DropDownList; DropDownList team = ((DropDownList)Panel1.FindControl("team")) as DropDownList; TicketsBLL bll = new TicketsBLL(); bll.deptId = GetId("Dept"); bll.groupId = GetId("Group"); bll.teamId = GetId("Team"); bll.projectId = GetId("Product"); bll.statusId = GetId("Status"); bll.priorityId = GetId("Priority"); bll.createdBy = GetId("Created_By"); bll.requestedBy = GetId("Requested_By"); bll.businessUnitRep = GetId("Business_Unit_Rep"); bll.summary = Summary.Text; bll.description = Description.Text; bll.actualCost = ToInt(Actual_Cost.Text); bll.actualHours = ToInt(Actual_Hours.Text); try { bll.receivedOn = Convert.ToDateTime(ReceivedDate.Text); } catch { } try { bll.qaStartDate = Convert.ToDateTime(DueToQADate.Text); } catch { } try { bll.qaCompleteDate = Convert.ToDateTime(QACompleteDate.Text); } catch { } try { bll.userTestDate = Convert.ToDateTime(UserTestDueDate.Text); } catch { } try { bll.userTestCompleteDate = Convert.ToDateTime(UserCompleteDate.Text); } catch { } try { bll.plannedImplementationDate = Convert.ToDateTime(ImplementationDate.Text); } catch { } switch (((Button)sender).Text) { case "Update": bll.Id = new Guid(TicketId.Text); bll.Update(); break; case "Create and Assign": bll.AddTicket(); goto case "Assign"; case "Create": bll.AddTicket(); break; case "Assign": Session.Add("TicketId", (Request.QueryString["Id"] == null) ? bll.Id.ToString() : Request.QueryString["Id"]); Redirect("Assign.aspx?Id=" + ((Request.QueryString["Id"] == null) ? bll.Id.ToString() : Request.QueryString["Id"])); break; } Redirect("Tickets.aspx"); } }