public void DecodeFromString(string ticketString)
{
string[] recvTickets;
recvTickets = ticketString.Split(';');
string[] recvFields;
for (int i = 0; i < recvTickets.Length - 1; i++)//todo
{
recvFields = recvTickets[i].Split(',');
if (recvFields.Length != 4)
MessageBox.Show("missing ticket field");
else
{
ticket myticket = new ticket(HexToBytes(recvFields[0]), HexToBytes(recvFields[1]), HexToBytes(recvFields[2]), HexToBytes(recvFields[3]));
ticketlist.Add(myticket);
}
}
}
public static ticket Add(dbDataContext db, string title, string details, int assign_to_group, int _priority, int submitter, int originating_group)
{
ticket newTicket = new ticket();
newTicket.title = title;
newTicket.details = details;
newTicket.closed = DateTime.Parse("1/1/2001");
newTicket.submitter = submitter;
newTicket.submitted = DateTime.Now;
newTicket.last_action = DateTime.Now;
newTicket.priority = _priority;
newTicket.assigned_to_group = assign_to_group;
newTicket.ticket_status = 1; // 1=new
newTicket.originating_group = originating_group;
newTicket.active = true;
db.tickets.InsertOnSubmit(newTicket);
db.SubmitChanges();
return newTicket;
}
partial void Deleteticket(ticket instance);
partial void Updateticket(ticket instance);
partial void Insertticket(ticket instance);
private void detach_tickets(ticket entity)
{
this.SendPropertyChanging();
entity.user = null;
}
private void attach_tickets(ticket entity)
{
this.SendPropertyChanging();
entity.user = this;
}
private void detach_tickets2(ticket entity)
{
this.SendPropertyChanging();
entity.sub_unit2 = null;
}
private void attach_tickets1(ticket entity)
{
this.SendPropertyChanging();
entity.sub_unit1 = this;
}
protected void populateTicket(string ticketID)
{
try
{
bool userCanEditThisTicket = true;
user me = Users.Get(db, userName);
t = Tickets.Get(db, Int32.Parse(ticketID));
////populate comments
IEnumerable<comment> comments = Tickets.Comments.List(db, t.id);
StringBuilder sb = new StringBuilder();
foreach (comment c in comments)
buildComments(c);
if (sb.Length > 0)
lblComments.Text = sb.ToString();
//only do the user is at the right level... if not, read only
user_group ugAccessLevel = Utils.AccessLevel();
int intToPopATG = ugAccessLevel.security_level;
accessLevel = intToPopATG;
if (ugAccessLevel.security_level < t.sub_unit.access_level)
{
intToPopATG = 10; //if the user has too low a level to change this ticket, thi s is set to 10;
userCanEditThisTicket = false;
}
if (!IsPostBack)
{
btnOpen.Visible = (t.ticket_status == 5);
btnClose.Visible = !(t.ticket_status == 5);
if (userCanEditThisTicket) // full edit privs
{
foreach (priority p in Dbi.Priorities.List(db, 10)) ddlPriority.Items.Add(new ListItem(p.priority_name, p.id.ToString()));
foreach (statuse s in Dbi.Statuses.List(db)) ddlStatus.Items.Add(new ListItem(s.status_name, s.id.ToString()));
ddlStatus.set(t.ticket_status.ToString());
ddlPriority.set(t.priority.ToString());
var units = Groups.List(db, accessLevel);
foreach (unit u in units.OrderBy(p => p.unit_name))
ddlUnit.Items.Add(new ListItem(u.unit_name, u.id.ToString()));
ddlUnit.set(t.sub_unit.unit.id.ToString());
Utils.PopulateSubUnits(db, ddlUnit, ddlSubUnit, accessLevel);
ddlSubUnit.set(t.assigned_to_group.ToString());
}
else //user can not edit anything but comments
{
ddlUnit.Items.Add(new ListItem(t.sub_unit.unit.unit_name, t.sub_unit.unit.ToString()));
ddlSubUnit.Items.Add(new ListItem(t.sub_unit.sub_unit_name, t.assigned_to_group.ToString()));
ddlPriority.Items.Add(new ListItem(t.priority1.priority_name, t.priority.ToString()));
ddlStatus.Items.Add(new ListItem(t.statuse.status_name, t.statuse.id.ToString()));
ddlSubUnit.Enabled = false;
ddlUnit.Enabled = false;
ddlPriority.Enabled = false;
ddlStatus.Enabled = false;
if (me.sub_unit == t.user.sub_unit || Tickets.Comments.CommentingGroups(db, t.id).Contains(me.sub_unit))
lblReport.report(false, GetLocalResourceObject("CommentAttachClose").ToString(), null);
else
{
pnlComment.Style.Add(HtmlTextWriterStyle.Display, "none");
lblReport.report(false, GetLocalResourceObject("ViewOnly").ToString(), null);
}
}
}
pnlShowTicket.Style.Clear();
pnlShowTicket.Style.Add(HtmlTextWriterStyle.Display, "block");
pnlDisplay.Visible = true;
pnlNoQuery.Visible = false;
}
catch (Exception ex)
{
lblTopReport.report(false, Resources.Common.Error + " - " + GetLocalResourceObject("NoTicket").ToString() + Request.QueryString["ticketID"].ToString(), ex);
pnlDisplay.Visible = false;
}
}
public void UpdateTicket(ref OperationResult _pobjOperationResult, ticketDto objticketDto, List <ticketdetalleDto> _ticketdetalleDTOAdd, List <ticketdetalleDto> _ticketdetalleDTOUpdate, List <ticketdetalleDto> _ticketdetalleDTODelete, List <string> ClientSession)
{
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
#region Actualizar ticket
var objEntitySource = (from a in dbContext.ticket
where a.v_TicketId == objticketDto.v_TicketId
select a).FirstOrDefault();
objticketDto.d_UpdateDate = DateTime.Now;
if (objEntitySource.d_InsertDate == null || objEntitySource.i_InsertUserId == null)
{
objticketDto.d_InsertDate = DateTime.Now;
objticketDto.i_InsertUserId = Int32.Parse(ClientSession[2]);
}
else
{
objticketDto.d_InsertDate = objEntitySource.d_InsertDate;
objticketDto.i_InsertUserId = objEntitySource.i_InsertUserId;
}
objticketDto.i_UpdateUserId = Int32.Parse(ClientSession[2]);
objticketDto.i_IsDeleted = 0;
ticket objStrongEntity = ticketAssembler.ToEntity(objticketDto);
dbContext.ticket.ApplyCurrentValues(objStrongEntity);
dbContext.SaveChanges();
#endregion
int intNodeId = int.Parse(ClientSession[0]);
#region add detalle
foreach (var item in _ticketdetalleDTOAdd)
{
ticketdetalle objEntity1 = ticketdetalleAssembler.ToEntity(item);
objEntity1.d_InsertDate = DateTime.Now;
objEntity1.i_InsertUserId = Int32.Parse(ClientSession[2]);
objEntity1.i_IsDeleted = 0;
var NewId1 = Common.Utils.GetNewId(intNodeId, Utils.GetNextSecuentialId(intNodeId, 346), "KD");
objEntity1.v_TicketDetalleId = NewId1;
objEntity1.v_TicketId = objticketDto.v_TicketId;
dbContext.AddToticketdetalle(objEntity1);
dbContext.SaveChanges();
}
#endregion
#region upd detalle
if (_ticketdetalleDTOUpdate != null)
{
foreach (var item in _ticketdetalleDTOUpdate)
{
var updatedetalleticket = (from a in dbContext.ticketdetalle
where a.v_TicketDetalleId == item.v_TicketDetalleId
select a).FirstOrDefault();
//objEntitySource1.v_ComponentId = item.v_ComponentId;
updatedetalleticket.d_Cantidad = item.d_Cantidad;
updatedetalleticket.i_EsDespachado = item.i_EsDespachado;
updatedetalleticket.d_SaldoAseguradora = item.d_SaldoAseguradora;
updatedetalleticket.d_SaldoPaciente = item.d_SaldoPaciente;
updatedetalleticket.i_IsDeleted = 0;
updatedetalleticket.d_UpdateDate = DateTime.Now;
updatedetalleticket.i_UpdateUserId = Int32.Parse(ClientSession[2]);
dbContext.SaveChanges();
}
}
#endregion
#region del detalle
if (_ticketdetalleDTODelete != null)
{
foreach (var item in _ticketdetalleDTODelete)
{
var objEntitySource1 = (from a in dbContext.ticketdetalle
where a.v_TicketDetalleId == item.v_TicketDetalleId
select a).FirstOrDefault();
objEntitySource1.d_UpdateDate = DateTime.Now;
objEntitySource1.i_UpdateUserId = Int32.Parse(ClientSession[2]);
objEntitySource1.i_IsDeleted = 1;
dbContext.SaveChanges();
}
}
#endregion
//dbContext.SaveChanges();
_pobjOperationResult.Success = 1;
LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "TICKET / DETALLE", "v_TicketId=" + objticketDto.v_TicketId.ToString(), Success.Ok, null);
return;
}
catch (Exception ex)
{
_pobjOperationResult.Success = 0;
_pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex);
LogBL.SaveLog(ClientSession[0], ClientSession[1], ClientSession[2], LogEventType.ACTUALIZACION, "TICKET / DETALLE", "v_TicketId=" + objticketDto.v_TicketId.ToString(), Success.Failed, _pobjOperationResult.ExceptionMessage);
return;
}
}
public void AddToList(ticket _ticket)
{
ticketlist.Add(_ticket);
}
public void AddToList(byte[] senderIDdata, byte[] senderIDsign, byte[] receiverIDdata, byte[] receiverIDsign)
{
ticket myticket = new ticket(senderIDdata, senderIDsign, receiverIDdata, receiverIDsign);
ticketlist.Add(myticket);
}
