private void LoadStatuses(int ticketTypeID)
{
cmbStatuses.Items.Clear();
TicketStatuses statuses = new TicketStatuses(UserSession.LoginUser);
statuses.LoadByTicketTypeID(ticketTypeID);
foreach (TicketStatus status in statuses)
{
cmbStatuses.Items.Add(new RadComboBoxItem(status.Name, status.TicketStatusID.ToString()));
}
if (cmbStatuses.Items.Count > 0)
{
cmbStatuses.SelectedIndex = 0;
}
}
public static string UpdateType(SelectedType type,
string arg,
int?id,
string name,
string description,
bool isTimed,
bool isClosed,
bool isClosedEmail,
bool isEmailResponse,
bool pauseSla,
bool isShipping,
bool isDiscontinued,
string productFamilyID,
string iconUrl,
bool isVisibleOnPortal,
bool isActive,
bool ExcludeFromCDI)
{
if (!UserSession.CurrentUser.IsSystemAdmin)
{
return("");
}
switch (type)
{
case SelectedType.ActionTypes:
ActionType actionType = id == null ? (new ActionTypes(UserSession.LoginUser)).AddNewActionType() : ActionTypes.GetActionType(UserSession.LoginUser, (int)id);
actionType.IsTimed = isTimed;
actionType.Name = name;
actionType.Description = description;
if (id == null)
{
actionType.Position = actionType.Collection.GetMaxPosition(UserSession.LoginUser.OrganizationID) + 1;
}
if (id == null)
{
actionType.OrganizationID = UserSession.LoginUser.OrganizationID;
}
actionType.Collection.Save();
actionType.Collection.ValidatePositions(UserSession.LoginUser.OrganizationID);
break;
case SelectedType.PhoneTypes:
PhoneType phoneType = id == null ? (new PhoneTypes(UserSession.LoginUser)).AddNewPhoneType() : PhoneTypes.GetPhoneType(UserSession.LoginUser, (int)id);
phoneType.Name = name;
phoneType.Description = description;
if (id == null)
{
phoneType.Position = phoneType.Collection.GetMaxPosition(UserSession.LoginUser.OrganizationID) + 1;
}
if (id == null)
{
phoneType.OrganizationID = UserSession.LoginUser.OrganizationID;
}
phoneType.Collection.Save();
phoneType.Collection.ValidatePositions(UserSession.LoginUser.OrganizationID);
break;
case SelectedType.ProductVersionStatuses:
ProductVersionStatus productVersionStatus = id == null ? (new ProductVersionStatuses(UserSession.LoginUser)).AddNewProductVersionStatus() : ProductVersionStatuses.GetProductVersionStatus(UserSession.LoginUser, (int)id);
productVersionStatus.IsDiscontinued = isDiscontinued;
productVersionStatus.IsShipping = isShipping;
productVersionStatus.Name = name;
productVersionStatus.Description = description;
if (id == null)
{
productVersionStatus.Position = productVersionStatus.Collection.GetMaxPosition(UserSession.LoginUser.OrganizationID) + 1;
}
if (id == null)
{
productVersionStatus.OrganizationID = UserSession.LoginUser.OrganizationID;
}
productVersionStatus.Collection.Save();
productVersionStatus.Collection.ValidatePositions(UserSession.LoginUser.OrganizationID);
break;
case SelectedType.TicketSeverities:
TicketSeverity ticketSeverity = id == null ? (new TicketSeverities(UserSession.LoginUser)).AddNewTicketSeverity() : TicketSeverities.GetTicketSeverity(UserSession.LoginUser, (int)id);
ticketSeverity.Name = name;
ticketSeverity.Description = description;
if (id == null)
{
ticketSeverity.Position = ticketSeverity.Collection.GetMaxPosition(UserSession.LoginUser.OrganizationID) + 1;
}
if (id == null)
{
ticketSeverity.OrganizationID = UserSession.LoginUser.OrganizationID;
}
ticketSeverity.VisibleOnPortal = isVisibleOnPortal;
ticketSeverity.Collection.Save();
ticketSeverity.Collection.ValidatePositions(UserSession.LoginUser.OrganizationID);
break;
case SelectedType.TicketStatuses:
if (isEmailResponse == true)
{
TicketStatuses statuses = new TicketStatuses(UserSession.LoginUser);
statuses.LoadByTicketTypeID(int.Parse(arg));
foreach (TicketStatus status in statuses)
{
status.IsEmailResponse = false;
}
statuses.Save();
}
TicketStatus ticketStatus = id == null ? (new TicketStatuses(UserSession.LoginUser)).AddNewTicketStatus() : TicketStatuses.GetTicketStatus(UserSession.LoginUser, (int)id);
ticketStatus.TicketTypeID = int.Parse(arg);
ticketStatus.IsClosed = isClosed;
ticketStatus.IsClosedEmail = isClosedEmail;
ticketStatus.IsEmailResponse = isEmailResponse;
ticketStatus.PauseSLA = pauseSla;
ticketStatus.Name = name;
ticketStatus.Description = description;
if (id == null)
{
ticketStatus.Position = ticketStatus.Collection.GetMaxPosition(UserSession.LoginUser.OrganizationID) + 1;
}
if (id == null)
{
ticketStatus.OrganizationID = UserSession.LoginUser.OrganizationID;
}
ticketStatus.Collection.Save();
ticketStatus.Collection.ValidatePositions(UserSession.LoginUser.OrganizationID);
break;
case SelectedType.TicketTypes:
TicketType ticketType = id == null ? (new TicketTypes(UserSession.LoginUser)).AddNewTicketType() : TicketTypes.GetTicketType(UserSession.LoginUser, (int)id);
ticketType.Name = name;
ticketType.Description = description;
ticketType.IconUrl = iconUrl;
ticketType.IsVisibleOnPortal = isVisibleOnPortal;
ticketType.IsActive = isActive;
ticketType.ExcludeFromCDI = ExcludeFromCDI;
if (id == null)
{
ticketType.Position = ticketType.Collection.GetMaxPosition(UserSession.LoginUser.OrganizationID) + 1;
}
if (id == null)
{
ticketType.OrganizationID = UserSession.LoginUser.OrganizationID;
}
if (productFamilyID == "-1")
{
ticketType.ProductFamilyID = null;
}
else
{
ticketType.ProductFamilyID = Convert.ToInt32(productFamilyID);
}
ticketType.Collection.Save();
ticketType.Collection.ValidatePositions(UserSession.LoginUser.OrganizationID);
if (id == null)
{
try
{
System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand();
command.CommandText = "UPDATE Users SET MenuItems = MenuItems + ',mniTicketType_" + ticketType.TicketTypeID.ToString() + "' WHERE UserID IN (SELECT UserID WHERE OrganizationID = @OrganizationID)";
command.Parameters.AddWithValue("OrganizationID", UserSession.LoginUser.OrganizationID);
SqlExecutor.ExecuteNonQuery(UserSession.LoginUser, command);
}
catch (Exception ex)
{
ExceptionLogs.LogException(UserSession.LoginUser, ex, "Ticket Type Creation - menu item");
}
TicketStatuses ticketStatuses = new TicketStatuses(UserSession.LoginUser);
ticketStatus = ticketStatuses.AddNewTicketStatus();
ticketStatus.Name = "New";
ticketStatus.Description = "New";
ticketStatus.Position = 0;
ticketStatus.OrganizationID = UserSession.LoginUser.OrganizationID;
ticketStatus.TicketTypeID = ticketType.TicketTypeID;
ticketStatus.IsClosed = false;
ticketStatus.IsClosedEmail = false;
ticketStatus = ticketStatuses.AddNewTicketStatus();
ticketStatus.Name = "Closed";
ticketStatus.Description = "Closed";
ticketStatus.Position = 30;
ticketStatus.OrganizationID = UserSession.LoginUser.OrganizationID;
ticketStatus.TicketTypeID = ticketType.TicketTypeID;
ticketStatus.IsClosed = true;
ticketStatus.IsClosedEmail = false;
ticketStatus.Collection.Save();
ticketStatus.Collection.ValidatePositions(UserSession.LoginUser.OrganizationID);
/* TicketNextStatuses ticketNextStatuses = new TicketNextStatuses(UserSession.LoginUser);
* ticketNextStatuses.AddNextStatus(ticketStatuses[0], ticketStatuses[1], 0);
* ticketNextStatuses.AddNextStatus(ticketStatuses[1], ticketStatuses[0], 1);
* ticketNextStatuses.Save();*/
}
break;
case SelectedType.ActivityTypes:
ActivityType activityType = id == null ? (new ActivityTypes(UserSession.LoginUser)).AddNewActivityType() : ActivityTypes.GetActivityType(UserSession.LoginUser, (int)id);
activityType.Name = name;
activityType.Description = description;
if (id == null)
{
activityType.Position = activityType.Collection.GetMaxPosition(UserSession.LoginUser.OrganizationID) + 1;
}
if (id == null)
{
activityType.OrganizationID = UserSession.LoginUser.OrganizationID;
}
activityType.Collection.Save();
activityType.Collection.ValidatePositions(UserSession.LoginUser.OrganizationID);
break;
default:
break;
}
return(GetTypesHtml(type, arg));
}
