public static string GetProductVersionStatus(RestCommand command, int productVersionStatusID)
{
ProductVersionStatus productVersionStatus = ProductVersionStatuses.GetProductVersionStatus(command.LoginUser, productVersionStatusID);
if (productVersionStatus.OrganizationID != command.Organization.OrganizationID)
{
throw new RestException(HttpStatusCode.Unauthorized);
}
return(productVersionStatus.GetXml("ProductVersionStatus", true));
}
public static string GetProductVersionStatuses(RestCommand command, bool orderByDateCreated = false)
{
ProductVersionStatuses items = new ProductVersionStatuses(command.LoginUser);
if (orderByDateCreated)
{
items.LoadByOrganizationID(command.Organization.OrganizationID, "DateCreated DESC");
}
else
{
items.LoadByOrganizationID(command.Organization.OrganizationID);
}
return(items.GetXml("ProductVersionStatuses", "ProductVersionStatus", true, command.Filters));
}
public static string GetProductVersionStatuses(RestCommand command)
{
ProductVersionStatuses productVersionStatuses = new ProductVersionStatuses(command.LoginUser);
productVersionStatuses.LoadByOrganizationID(command.Organization.OrganizationID);
if (command.Format == RestFormat.XML)
{
return(productVersionStatuses.GetXml("ProductVersionStatuses", "ProductVersionStatus", true, command.Filters));
}
else
{
throw new RestException(HttpStatusCode.BadRequest, "Invalid data format");
}
}
private void LoadStatuses()
{
cmbStatus.Items.Clear();
ProductVersionStatuses statuses = new ProductVersionStatuses(UserSession.LoginUser);
statuses.LoadByOrganizationID(UserSession.LoginUser.OrganizationID);
foreach (ProductVersionStatus status in statuses)
{
cmbStatus.Items.Add(new RadComboBoxItem(status.Name, status.ProductVersionStatusID.ToString()));
}
if (cmbStatus.Items.Count > 0)
{
cmbStatus.SelectedIndex = 0;
}
}
private void LoadCustomProperty()
{
switch (_refType)
{
case ReferenceType.ActionTypes:
ActionType actionType = (ActionType)ActionTypes.GetActionType(LoginSession.LoginUser, _id);
textDescription.Text = actionType.Description;
textName.Text = actionType.Name;
break;
case ReferenceType.PhoneTypes:
PhoneType phoneType = (PhoneType)PhoneTypes.GetPhoneType(LoginSession.LoginUser, _id);
textDescription.Text = phoneType.Description;
textName.Text = phoneType.Name;
break;
case ReferenceType.ProductVersionStatuses:
ProductVersionStatus productVersionStatus = (ProductVersionStatus)ProductVersionStatuses.GetProductVersionStatus(LoginSession.LoginUser, _id);
textDescription.Text = productVersionStatus.Description;
textName.Text = productVersionStatus.Name;
cbDiscontinued.Checked = productVersionStatus.IsDiscontinued;
cbShipping.Checked = productVersionStatus.IsShipping;
break;
case ReferenceType.TicketSeverities:
TicketSeverity ticketSeverity = (TicketSeverity)TicketSeverities.GetTicketSeverity(LoginSession.LoginUser, _id);
textDescription.Text = ticketSeverity.Description;
textName.Text = ticketSeverity.Name;
break;
case ReferenceType.TicketStatuses:
TicketStatus ticketStatus = (TicketStatus)TicketStatuses.GetTicketStatus(LoginSession.LoginUser, _id);
textDescription.Text = ticketStatus.Description;
textName.Text = ticketStatus.Name;
cbClosed.Checked = ticketStatus.IsClosed;
break;
default:
break;
}
}
private void SaveCustomProperty()
{
switch (_refType)
{
case ReferenceType.ActionTypes:
ActionType actionType;
ActionTypes actionTypes = new ActionTypes(LoginSession.LoginUser);
if (_id < 0)
{
actionType = actionTypes.AddNewActionType();
actionType.OrganizationID = _organizationID;
actionType.Position = actionTypes.GetMaxPosition(_organizationID) + 1;
}
else
{
actionTypes.LoadByActionTypeID(_id);
actionType = actionTypes[0];
}
actionType.Description = textDescription.Text;
actionType.Name = textName.Text;
actionTypes.Save();
break;
case ReferenceType.PhoneTypes:
PhoneType phoneType;
PhoneTypes phoneTypes = new PhoneTypes(LoginSession.LoginUser);
if (_id < 0)
{
phoneType = phoneTypes.AddNewPhoneType();
phoneType.OrganizationID = _organizationID;
phoneType.Position = phoneTypes.GetMaxPosition(_organizationID) + 1;
}
else
{
phoneTypes.LoadByPhoneTypeID(_id);
phoneType = phoneTypes[0];
}
phoneType.Description = textDescription.Text;
phoneType.Name = textName.Text;
phoneTypes.Save();
break;
case ReferenceType.ProductVersionStatuses:
ProductVersionStatus productVersionStatus;
ProductVersionStatuses productVersionStatuses = new ProductVersionStatuses(LoginSession.LoginUser);
if (_id < 0)
{
productVersionStatus = productVersionStatuses.AddNewProductVersionStatus();
productVersionStatus.OrganizationID = _organizationID;
productVersionStatus.Position = productVersionStatuses.GetMaxPosition(_organizationID) + 1;
}
else
{
productVersionStatuses.LoadByProductVersionStatusID(_id);
productVersionStatus = productVersionStatuses[0];
}
productVersionStatus.Description = textDescription.Text;
productVersionStatus.Name = textName.Text;
productVersionStatus.IsDiscontinued = cbDiscontinued.Checked;
productVersionStatus.IsShipping = cbShipping.Checked;
productVersionStatuses.Save();
break;
case ReferenceType.TicketSeverities:
TicketSeverity ticketSeverity;
TicketSeverities ticketSeverities = new TicketSeverities(LoginSession.LoginUser);
if (_id < 0)
{
ticketSeverity = ticketSeverities.AddNewTicketSeverity();
ticketSeverity.OrganizationID = _organizationID;
ticketSeverity.Position = ticketSeverities.GetMaxPosition(_organizationID) + 1;
}
else
{
ticketSeverities.LoadByTicketSeverityID(_id);
ticketSeverity = ticketSeverities[0];
}
ticketSeverity.Description = textDescription.Text;
ticketSeverity.Name = textName.Text;
ticketSeverities.Save();
break;
case ReferenceType.TicketStatuses:
TicketStatus ticketStatus;
TicketStatuses ticketStatuses = new TicketStatuses(LoginSession.LoginUser);
if (_id < 0)
{
ticketStatus = ticketStatuses.AddNewTicketStatus();
ticketStatus.OrganizationID = _organizationID;
ticketStatus.TicketTypeID = _ticketTypeID;
ticketStatus.Position = ticketStatuses.GetMaxPosition(_ticketTypeID) + 1;
}
else
{
ticketStatuses.LoadByTicketStatusID(_id);
ticketStatus = ticketStatuses[0];
}
ticketStatus.Description = textDescription.Text;
ticketStatus.Name = textName.Text;
ticketStatus.IsClosed = cbClosed.Checked;
ticketStatuses.Save();
break;
default:
break;
}
}
private void LoadCustomProperties()
{
int oldID = GetSelectedPropertyID();
ReferenceType refType = GetSelectedPropertyType();
DataTable table = new DataTable();
table.Columns.Add("ID", System.Type.GetType("System.Int32"));
table.Columns.Add("Name");
table.Columns.Add("Description");
table.Columns.Add("IsClosed", System.Type.GetType("System.Boolean"));
table.Columns.Add("IsShipping", System.Type.GetType("System.Boolean"));
table.Columns.Add("IsDiscontinued", System.Type.GetType("System.Boolean"));
gridProperties.Columns["IsShipping"].IsVisible = false;
gridProperties.Columns["IsDiscontinued"].IsVisible = false;
gridProperties.Columns["IsClosed"].IsVisible = false;
switch (refType)
{
case ReferenceType.ActionTypes:
ActionTypes actionTypes = new ActionTypes(LoginSession.LoginUser);
actionTypes.LoadAllPositions(OrganizationID);
foreach (ActionType actionType in actionTypes)
{
DataRow row = table.NewRow();
row[0] = actionType.ActionTypeID;
row[1] = actionType.Name;
row[2] = actionType.Description;
row[3] = false;
row[4] = false;
row[5] = false;
table.Rows.Add(row);
}
break;
case ReferenceType.PhoneTypes:
PhoneTypes phoneTypes = new PhoneTypes(LoginSession.LoginUser);
phoneTypes.LoadAllPositions(OrganizationID);
foreach (PhoneType phoneType in phoneTypes)
{
DataRow row = table.NewRow();
row[0] = phoneType.PhoneTypeID;
row[1] = phoneType.Name;
row[2] = phoneType.Description;
row[3] = false;
row[4] = false;
row[5] = false;
table.Rows.Add(row);
}
break;
case ReferenceType.ProductVersionStatuses:
ProductVersionStatuses productVersionStatuses = new ProductVersionStatuses(LoginSession.LoginUser);
productVersionStatuses.LoadAllPositions(OrganizationID);
foreach (ProductVersionStatus productVersionStatus in productVersionStatuses)
{
DataRow row = table.NewRow();
row[0] = productVersionStatus.ProductVersionStatusID;
row[1] = productVersionStatus.Name;
row[2] = productVersionStatus.Description;
row[3] = false;
row[4] = productVersionStatus.IsShipping;
row[5] = productVersionStatus.IsDiscontinued;
table.Rows.Add(row);
}
gridProperties.Columns["IsShipping"].IsVisible = true;
gridProperties.Columns["IsDiscontinued"].IsVisible = true;
break;
case ReferenceType.TicketSeverities:
TicketSeverities ticketSeverities = new TicketSeverities(LoginSession.LoginUser);
ticketSeverities.LoadAllPositions(OrganizationID);
foreach (TicketSeverity ticketSeverity in ticketSeverities)
{
DataRow row = table.NewRow();
row[0] = ticketSeverity.TicketSeverityID;
row[1] = ticketSeverity.Name;
row[2] = ticketSeverity.Description;
row[3] = false;
row[4] = false;
row[5] = false;
table.Rows.Add(row);
}
break;
case ReferenceType.TicketStatuses:
TicketStatuses ticketStatuses = new TicketStatuses(LoginSession.LoginUser);
ticketStatuses.LoadAllPositions(GetSelectedTicketType());
foreach (TicketStatus ticketStatus in ticketStatuses)
{
DataRow row = table.NewRow();
row[0] = ticketStatus.TicketStatusID;
row[1] = ticketStatus.Name;
row[2] = ticketStatus.Description;
row[3] = ticketStatus.IsClosed;
row[4] = false;
row[5] = false;
table.Rows.Add(row);
}
gridProperties.Columns["IsClosed"].IsVisible = true;
break;
default:
break;
}
gridProperties.DataSource = table;
if (gridProperties.Rows.Count > 0)
{
gridProperties.Rows[0].IsCurrent = true;
}
SetSelectedPropertyID(oldID);
}
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));
}
public static TypeObject GetTypeObject(SelectedType type, int id)
{
TypeObject result = new TypeObject();
switch (type)
{
case SelectedType.ActionTypes:
ActionType actionType = ActionTypes.GetActionType(UserSession.LoginUser, id);
result.ID = actionType.ActionTypeID;
result.Name = actionType.Name;
result.Description = actionType.Description;
result.IsTimed = actionType.IsTimed;
break;
case SelectedType.PhoneTypes:
PhoneType phoneType = PhoneTypes.GetPhoneType(UserSession.LoginUser, id);
result.ID = phoneType.PhoneTypeID;
result.Name = phoneType.Name;
result.Description = phoneType.Description;
break;
case SelectedType.ProductVersionStatuses:
ProductVersionStatus productVersionStatus = ProductVersionStatuses.GetProductVersionStatus(UserSession.LoginUser, id);
result.ID = productVersionStatus.ProductVersionStatusID;
result.Name = productVersionStatus.Name;
result.Description = productVersionStatus.Description;
result.IsShipping = productVersionStatus.IsShipping;
result.IsDiscontinued = productVersionStatus.IsDiscontinued;
break;
case SelectedType.TicketSeverities:
TicketSeverity ticketSeverity = TicketSeverities.GetTicketSeverity(UserSession.LoginUser, id);
result.ID = ticketSeverity.TicketSeverityID;
result.Name = ticketSeverity.Name;
result.Description = ticketSeverity.Description;
result.IsVisibleOnPortal = ticketSeverity.VisibleOnPortal;
break;
case SelectedType.TicketStatuses:
TicketStatus ticketStatus = TicketStatuses.GetTicketStatus(UserSession.LoginUser, id);
result.ID = ticketStatus.TicketStatusID;
result.Name = ticketStatus.Name;
result.Description = ticketStatus.Description;
result.IsClosed = ticketStatus.IsClosed;
result.IsClosedEmail = ticketStatus.IsClosedEmail;
result.IsEmailResponse = ticketStatus.IsEmailResponse;
result.PauseSla = ticketStatus.PauseSLA;
break;
case SelectedType.TicketTypes:
TicketType ticketType = TicketTypes.GetTicketType(UserSession.LoginUser, id);
result.ID = ticketType.TicketTypeID;
result.Name = ticketType.Name;
result.Description = ticketType.Description;
result.IsVisibleOnPortal = ticketType.IsVisibleOnPortal;
result.IconUrl = ticketType.IconUrl;
result.IsActive = ticketType.IsActive;
result.ExcludeFromCDI = ticketType.ExcludeFromCDI;
if (ticketType.ProductFamilyID == null)
{
result.ProductFamilyID = -1;
}
else
{
result.ProductFamilyID = (int)ticketType.ProductFamilyID;
}
break;
case SelectedType.ActivityTypes:
ActivityType activityType = ActivityTypes.GetActivityType(UserSession.LoginUser, id);
result.ID = activityType.ActivityTypeID;
result.Name = activityType.Name;
result.Description = activityType.Description;
break;
default:
break;
}
return(result);
}
public static string ReplaceType(SelectedType type, int oldID, int newID, string arg)
{
if (!UserSession.CurrentUser.IsSystemAdmin)
{
return("");
}
switch (type)
{
case SelectedType.ActionTypes:
if (ActionTypes.GetActionType(UserSession.LoginUser, oldID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
if (ActionTypes.GetActionType(UserSession.LoginUser, newID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
(new Actions(UserSession.LoginUser)).ReplaceActionType(oldID, newID);
ActionTypes actionTypes = new ActionTypes(UserSession.LoginUser);
actionTypes.DeleteFromDB(oldID);
actionTypes.ValidatePositions(UserSession.LoginUser.OrganizationID);
break;
case SelectedType.PhoneTypes:
if (PhoneTypes.GetPhoneType(UserSession.LoginUser, oldID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
if (PhoneTypes.GetPhoneType(UserSession.LoginUser, newID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
(new PhoneNumbers(UserSession.LoginUser)).ReplacePhoneType(oldID, newID);
PhoneTypes phoneTypes = new PhoneTypes(UserSession.LoginUser);
phoneTypes.DeleteFromDB(oldID);
phoneTypes.ValidatePositions(UserSession.LoginUser.OrganizationID);
break;
case SelectedType.ProductVersionStatuses:
if (ProductVersionStatuses.GetProductVersionStatus(UserSession.LoginUser, oldID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
if (ProductVersionStatuses.GetProductVersionStatus(UserSession.LoginUser, newID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
(new ProductVersions(UserSession.LoginUser)).ReplaceProductVersionStatus(oldID, newID);
ProductVersionStatuses productVersionStatuses = new ProductVersionStatuses(UserSession.LoginUser);
productVersionStatuses.DeleteFromDB(oldID);
productVersionStatuses.ValidatePositions(UserSession.LoginUser.OrganizationID);
break;
case SelectedType.TicketSeverities:
if (TicketSeverities.GetTicketSeverity(UserSession.LoginUser, oldID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
if (TicketSeverities.GetTicketSeverity(UserSession.LoginUser, newID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
(new Tickets(UserSession.LoginUser)).ReplaceTicketSeverity(oldID, newID);
TicketSeverities ticketSeverities = new TicketSeverities(UserSession.LoginUser);
ticketSeverities.DeleteFromDB(oldID);
ticketSeverities.ValidatePositions(UserSession.LoginUser.OrganizationID);
break;
case SelectedType.TicketStatuses:
TicketStatus oldStatus = TicketStatuses.GetTicketStatus(UserSession.LoginUser, oldID);
if (oldStatus.OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
if (TicketStatuses.GetTicketStatus(UserSession.LoginUser, newID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
(new Tickets(UserSession.LoginUser)).ReplaceTicketStatus(oldID, newID);
TicketStatuses ticketStatuses = new TicketStatuses(UserSession.LoginUser);
ticketStatuses.DeleteFromDB(oldID);
ticketStatuses.ValidatePositions(oldStatus.TicketTypeID);
break;
case SelectedType.TicketTypes:
if (TicketTypes.GetTicketType(UserSession.LoginUser, oldID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
if (TicketTypes.GetTicketType(UserSession.LoginUser, newID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
(new Tickets(UserSession.LoginUser)).ReplaceTicketType(oldID, newID);
TicketTypes ticketTypes = new TicketTypes(UserSession.LoginUser);
CustomFields customFields = new CustomFields(UserSession.LoginUser);
customFields.LoadByTicketTypeID(UserSession.LoginUser.OrganizationID, oldID);
ticketTypes.DeleteFromDB(oldID);
ticketTypes.ValidatePositions(UserSession.LoginUser.OrganizationID);
int?crmLinkFieldId = null;
foreach (CustomField customField in customFields)
{
try
{
crmLinkFieldId = CRMLinkFields.FindIdByCustomFieldId(customField.CustomFieldID, UserSession.LoginUser);
}
catch (Exception ex)
{
crmLinkFieldId = null;
}
if (crmLinkFieldId != null && crmLinkFieldId > 0)
{
CRMLinkFields crmLinkFieldsDelete = new CRMLinkFields(UserSession.LoginUser);
crmLinkFieldsDelete.DeleteFromDB((int)crmLinkFieldId);
}
}
break;
case SelectedType.ActivityTypes:
if (ActivityTypes.GetActivityType(UserSession.LoginUser, oldID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
var types = Enum.GetValues(typeof(ActivityTypeEnum));
if (newID > types.Length)
{
if (ActivityTypes.GetActivityType(UserSession.LoginUser, newID).OrganizationID != UserSession.LoginUser.OrganizationID)
{
return("");
}
}
(new Notes(UserSession.LoginUser)).ReplaceActivityType(oldID, newID);
ActivityTypes activityTypes = new ActivityTypes(UserSession.LoginUser);
activityTypes.DeleteFromDB(oldID);
activityTypes.ValidatePositions(UserSession.LoginUser.OrganizationID);
break;
default:
break;
}
return(GetTypesHtml(type, arg));
}
public static string GetTypesHtml(SelectedType type, string arg)
{
Organization organization = Organizations.GetOrganization(UserSession.LoginUser, UserSession.LoginUser.OrganizationID);
DataTable table = new DataTable();
table.Columns.Add("ID");
table.Columns.Add("Name");
table.Columns.Add("Description");
string result = "";
switch (type)
{
case SelectedType.ActionTypes:
ActionTypes actionTypes = new ActionTypes(UserSession.LoginUser);
actionTypes.LoadAllPositions(UserSession.LoginUser.OrganizationID);
table.Columns.Add("Is Timed");
foreach (ActionType actionType in actionTypes)
{
table.Rows.Add(new string[] { actionType.ActionTypeID.ToString(), actionType.Name, actionType.Description, actionType.IsTimed.ToString() });
}
break;
case SelectedType.PhoneTypes:
PhoneTypes phoneTypes = new PhoneTypes(UserSession.LoginUser);
phoneTypes.LoadAllPositions(UserSession.LoginUser.OrganizationID);
foreach (PhoneType phoneType in phoneTypes)
{
table.Rows.Add(new string[] { phoneType.PhoneTypeID.ToString(), phoneType.Name, phoneType.Description });
}
break;
case SelectedType.ProductVersionStatuses:
ProductVersionStatuses productVersionStatuses = new ProductVersionStatuses(UserSession.LoginUser);
productVersionStatuses.LoadAllPositions(UserSession.LoginUser.OrganizationID);
table.Columns.Add("Is Shipping");
table.Columns.Add("Is Discontinued");
foreach (ProductVersionStatus productVersionStatus in productVersionStatuses)
{
table.Rows.Add(new string[] { productVersionStatus.ProductVersionStatusID.ToString(), productVersionStatus.Name, productVersionStatus.Description, productVersionStatus.IsShipping.ToString(), productVersionStatus.IsDiscontinued.ToString() });
}
break;
case SelectedType.TicketSeverities:
table.Columns.Add("Visible on Portal");
TicketSeverities ticketSeverities = new TicketSeverities(UserSession.LoginUser);
ticketSeverities.LoadAllPositions(UserSession.LoginUser.OrganizationID);
foreach (TicketSeverity ticketSeverity in ticketSeverities)
{
table.Rows.Add(new string[] { ticketSeverity.TicketSeverityID.ToString(), ticketSeverity.Name, ticketSeverity.Description, ticketSeverity.VisibleOnPortal.ToString() });
}
break;
case SelectedType.TicketStatuses:
TicketStatuses ticketStatuses = new TicketStatuses(UserSession.LoginUser);
ticketStatuses.LoadAllPositions(int.Parse(arg));
table.Columns.Add("Is Closed");
table.Columns.Add("Closed Email");
table.Columns.Add("Email Response");
table.Columns.Add("Pause SLA");
foreach (TicketStatus ticketStatus in ticketStatuses)
{
table.Rows.Add(new string[] { ticketStatus.TicketStatusID.ToString(), ticketStatus.Name, ticketStatus.Description, ticketStatus.IsClosed.ToString(), ticketStatus.IsClosedEmail.ToString(), ticketStatus.IsEmailResponse.ToString(), ticketStatus.PauseSLA.ToString() });
}
break;
case SelectedType.TicketTypes:
table.Columns.Add("Icon");
table.Columns.Add("Visible on Portal");
string icon = "<img src=\"../{0}\" />";
if (organization.UseProductFamilies)
{
TicketTypesView ticketTypes = new TicketTypesView(UserSession.LoginUser);
ticketTypes.LoadAllPositions(UserSession.LoginUser.OrganizationID);
table.Columns.Add("Product Line");
table.Columns.Add("Active");
foreach (TicketTypesViewItem ticketType in ticketTypes)
{
table.Rows.Add(new string[] { ticketType.TicketTypeID.ToString(), ticketType.Name, ticketType.Description, string.Format(icon, ticketType.IconUrl), ticketType.IsVisibleOnPortal.ToString(), ticketType.ProductFamilyName });
}
}
else
{
TicketTypes ticketTypes = new TicketTypes(UserSession.LoginUser);
ticketTypes.LoadAllPositions(UserSession.LoginUser.OrganizationID);
table.Columns.Add("Active");
foreach (TicketType ticketType in ticketTypes)
{
table.Rows.Add(new string[] { ticketType.TicketTypeID.ToString(), ticketType.Name, ticketType.Description, string.Format(icon, ticketType.IconUrl), ticketType.IsVisibleOnPortal.ToString() });
}
}
break;
case SelectedType.ActivityTypes:
ActivityTypes activityTypes = new ActivityTypes(UserSession.LoginUser);
activityTypes.LoadAllPositions(UserSession.LoginUser.OrganizationID);
foreach (ActivityType activityType in activityTypes)
{
table.Rows.Add(new string[] { activityType.ActivityTypeID.ToString(), activityType.Name, activityType.Description });
}
break;
default:
break;
}
return(BuildTable(table));
}
public static RadComboBoxItemData[] GetReplaceTypeComboData(int id, SelectedType type, int ticketTypeID)
{
//IDictionary<string, object> contextDictionary = (IDictionary<string, object>)context;
List <RadComboBoxItemData> list = new List <RadComboBoxItemData>();
/*string[] s = context["FilterString"].ToString().Split(',');
* SelectedType type = (SelectedType)int.Parse(s[0]);
* int ticketTypeID = int.Parse(s[1]);
* int id = int.Parse(s[2]);*/
BaseCollection collection = null;
string nameColName = "Name";
string idColName = "ID";
switch (type)
{
case SelectedType.ActionTypes:
ActionTypes actionTypes = new ActionTypes(UserSession.LoginUser);
actionTypes.LoadAllPositions(UserSession.LoginUser.OrganizationID);
collection = actionTypes;
idColName = "ActionTypeID";
break;
case SelectedType.PhoneTypes:
PhoneTypes phoneTypes = new PhoneTypes(UserSession.LoginUser);
phoneTypes.LoadAllPositions(UserSession.LoginUser.OrganizationID);
collection = phoneTypes;
idColName = "PhoneTypeID";
break;
case SelectedType.ProductVersionStatuses:
ProductVersionStatuses productVersionStatuses = new ProductVersionStatuses(UserSession.LoginUser);
productVersionStatuses.LoadAllPositions(UserSession.LoginUser.OrganizationID);
collection = productVersionStatuses;
idColName = "ProductVersionStatusID";
break;
case SelectedType.TicketSeverities:
TicketSeverities ticketSeverities = new TicketSeverities(UserSession.LoginUser);
ticketSeverities.LoadAllPositions(UserSession.LoginUser.OrganizationID);
collection = ticketSeverities;
idColName = "TicketSeverityID";
break;
case SelectedType.TicketStatuses:
TicketStatuses ticketStatuses = new TicketStatuses(UserSession.LoginUser);
TicketType ticketType = TicketTypes.GetTicketType(UserSession.LoginUser, ticketTypeID);
if (ticketType.OrganizationID == UserSession.LoginUser.OrganizationID)
{
ticketStatuses.LoadAllPositions(ticketTypeID);
collection = ticketStatuses;
idColName = "TicketStatusID";
}
break;
case SelectedType.TicketTypes:
TicketTypes ticketTypes = new TicketTypes(UserSession.LoginUser);
ticketTypes.LoadAllPositions(UserSession.LoginUser.OrganizationID);
collection = ticketTypes;
idColName = "TicketTypeID";
break;
case SelectedType.ActivityTypes:
ActivityTypes activityTypes = new ActivityTypes(UserSession.LoginUser);
activityTypes.LoadAllPositions(UserSession.LoginUser.OrganizationID);
//Load base items
//Get default activity types
foreach (ActivityTypeEnum activity in Enum.GetValues(typeof(ActivityTypeEnum)))
{
var value = Enum.Parse(typeof(ActivityTypeEnum), activity.ToString());
//results.Add(new ActivityTypesDropDown() { Name = activity.ToString(), Value = (int)value });
RadComboBoxItemData itemData = new RadComboBoxItemData();
itemData.Text = activity.ToString();
itemData.Value = ((int)value).ToString();
list.Add(itemData);
}
collection = activityTypes;
idColName = "ActivityTypeID";
break;
default:
break;
}
foreach (DataRow row in collection.Table.Rows)
{
int i = (int)row[idColName];
if (id != i)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
itemData.Text = row[nameColName].ToString();
itemData.Value = i.ToString();
list.Add(itemData);
}
}
if (list.Count < 1)
{
RadComboBoxItemData noData = new RadComboBoxItemData();
noData.Text = "[No types to display.]";
noData.Value = "-1";
list.Add(noData);
}
return(list.ToArray());
}
