public static int Update(int DeptID, int CriteriaID, int UserId, int NotificationRuleId, CriteriaType ctype, string CriteriaName, CriteriaState cstate)
{
SqlParameter _pRVAL = new SqlParameter("@RETURN_VALUE", SqlDbType.Int);
_pRVAL.Direction = ParameterDirection.ReturnValue;
SqlParameter _pCriteriaId = new SqlParameter("@Id", SqlDbType.Int);
_pCriteriaId.Direction = ParameterDirection.InputOutput;
if (CriteriaID != 0) _pCriteriaId.Value = CriteriaID;
else _pCriteriaId.Value = DBNull.Value;
SqlParameter _pUserId = new SqlParameter("@UserId", SqlDbType.Int);
if (UserId != 0) _pUserId.Value = UserId;
else _pUserId.Value = DBNull.Value;
SqlParameter _pNotificationRuleId = new SqlParameter("@NotificationRuleId", SqlDbType.Int);
if (NotificationRuleId != 0) _pNotificationRuleId.Value = NotificationRuleId;
else _pNotificationRuleId.Value = DBNull.Value;
SqlParameter _pBitLimitToAssignedTkts = new SqlParameter("@btLimitToAssignedTkts", SqlDbType.Bit);
SqlParameter _pBitDisabledReports = new SqlParameter("@btDisabledReports", SqlDbType.Bit);
SqlParameter _pBitNoFilter = new SqlParameter("@btNoFilter", SqlDbType.Bit);
switch (cstate)
{
case CriteriaState.DisabledReports:
_pBitDisabledReports.Value = true;
_pBitLimitToAssignedTkts.Value = false;
_pBitNoFilter.Value = true;
break;
case CriteriaState.FilterEnabled:
_pBitDisabledReports.Value = false;
_pBitLimitToAssignedTkts.Value = false;
_pBitNoFilter.Value = false;
break;
case CriteriaState.LimitToAssignedTickets:
_pBitDisabledReports.Value = false;
_pBitLimitToAssignedTkts.Value = true;
_pBitNoFilter.Value = false;
break;
case CriteriaState.NoFilter:
_pBitDisabledReports.Value = false;
_pBitLimitToAssignedTkts.Value = false;
_pBitNoFilter.Value = true;
break;
}
UpdateData("sp_UpdateTicketCriteria", new SqlParameter[] { _pRVAL, new SqlParameter("@DId", DeptID), _pCriteriaId, _pUserId, _pNotificationRuleId, new SqlParameter("@CriteriaType", (byte)ctype), new SqlParameter("@CriteriaName", CriteriaName), _pBitLimitToAssignedTkts, _pBitDisabledReports, _pBitNoFilter });
if ((int)_pRVAL.Value < 0) return (int)_pRVAL.Value;
else return (int)_pCriteriaId.Value;
}
public static string ToCssClass(CriteriaState state)
{
string css = string.Empty;
switch (state)
{
case CriteriaState.Red:
css = "danger";
break;
case CriteriaState.Amber:
css = "warning";
break;
case CriteriaState.Green:
css = "success";
break;
}
return css;
}
public TicketCriteria(int DeptID, int TicketCriteriaID)
{
m_DeptID = DeptID;
if (TicketCriteriaID == 0)
{
return;
}
DataRow _row = SelectOne(DeptID, TicketCriteriaID);
if (_row == null)
{
return;
}
m_ID = TicketCriteriaID;
m_UserID = _row.IsNull("UserId") ? 0 : (int)_row["UserId"];
m_NotificationRuleID = _row.IsNull("NotificationRuleId") ? 0 : (int)_row["NotificationRuleId"];
m_Name = _row["CriteriaName"].ToString();
m_CriteriaType = (CriteriaType)((byte)_row["CriteriaType"]);
if (!(bool)_row["btNoFilter"])
{
m_CriteriaState = CriteriaState.FilterEnabled;
}
else if ((bool)_row["btDisabledReports"])
{
m_CriteriaState = CriteriaState.DisabledReports;
}
else if ((bool)_row["btLimitToAssignedTkts"])
{
m_CriteriaState = CriteriaState.LimitToAssignedTickets;
}
DataTable _dt = SelectCriteriaDataByType(DeptID, FilterType.CommonFilter, TicketCriteriaID);
foreach (DataRow _r in _dt.Rows)
{
m_FilterTypeStates[(int)_r["ID"]] = (bool)_r["State"];
}
}
public TicketCriteria(int DeptID, int TicketCriteriaID)
{
m_DeptID = DeptID;
if (TicketCriteriaID == 0) return;
DataRow _row = SelectOne(DeptID, TicketCriteriaID);
if (_row == null) return;
m_ID = TicketCriteriaID;
m_UserID = _row.IsNull("UserId") ? 0 : (int)_row["UserId"];
m_NotificationRuleID = _row.IsNull("NotificationRuleId") ? 0 : (int)_row["NotificationRuleId"];
m_Name = _row["CriteriaName"].ToString();
m_CriteriaType = (CriteriaType)((byte)_row["CriteriaType"]);
if (!(bool)_row["btNoFilter"]) m_CriteriaState = CriteriaState.FilterEnabled;
else if ((bool)_row["btDisabledReports"]) m_CriteriaState = CriteriaState.DisabledReports;
else if ((bool)_row["btLimitToAssignedTkts"]) m_CriteriaState = CriteriaState.LimitToAssignedTickets;
DataTable _dt=SelectCriteriaDataByType(DeptID, FilterType.CommonFilter, TicketCriteriaID);
foreach (DataRow _r in _dt.Rows) m_FilterTypeStates[(int)_r["ID"]]=(bool)_r["State"];
}
public static int Update(int DeptID, int CriteriaID, int UserId, int NotificationRuleId, CriteriaType ctype, string CriteriaName, CriteriaState cstate)
{
SqlParameter _pRVAL = new SqlParameter("@RETURN_VALUE", SqlDbType.Int);
_pRVAL.Direction = ParameterDirection.ReturnValue;
SqlParameter _pCriteriaId = new SqlParameter("@Id", SqlDbType.Int);
_pCriteriaId.Direction = ParameterDirection.InputOutput;
if (CriteriaID != 0)
{
_pCriteriaId.Value = CriteriaID;
}
else
{
_pCriteriaId.Value = DBNull.Value;
}
SqlParameter _pUserId = new SqlParameter("@UserId", SqlDbType.Int);
if (UserId != 0)
{
_pUserId.Value = UserId;
}
else
{
_pUserId.Value = DBNull.Value;
}
SqlParameter _pNotificationRuleId = new SqlParameter("@NotificationRuleId", SqlDbType.Int);
if (NotificationRuleId != 0)
{
_pNotificationRuleId.Value = NotificationRuleId;
}
else
{
_pNotificationRuleId.Value = DBNull.Value;
}
SqlParameter _pBitLimitToAssignedTkts = new SqlParameter("@btLimitToAssignedTkts", SqlDbType.Bit);
SqlParameter _pBitDisabledReports = new SqlParameter("@btDisabledReports", SqlDbType.Bit);
SqlParameter _pBitNoFilter = new SqlParameter("@btNoFilter", SqlDbType.Bit);
switch (cstate)
{
case CriteriaState.DisabledReports:
_pBitDisabledReports.Value = true;
_pBitLimitToAssignedTkts.Value = false;
_pBitNoFilter.Value = true;
break;
case CriteriaState.FilterEnabled:
_pBitDisabledReports.Value = false;
_pBitLimitToAssignedTkts.Value = false;
_pBitNoFilter.Value = false;
break;
case CriteriaState.LimitToAssignedTickets:
_pBitDisabledReports.Value = false;
_pBitLimitToAssignedTkts.Value = true;
_pBitNoFilter.Value = false;
break;
case CriteriaState.NoFilter:
_pBitDisabledReports.Value = false;
_pBitLimitToAssignedTkts.Value = false;
_pBitNoFilter.Value = true;
break;
}
UpdateData("sp_UpdateTicketCriteria", new SqlParameter[] { _pRVAL, new SqlParameter("@DId", DeptID), _pCriteriaId, _pUserId, _pNotificationRuleId, new SqlParameter("@CriteriaType", (byte)ctype), new SqlParameter("@CriteriaName", CriteriaName), _pBitLimitToAssignedTkts, _pBitDisabledReports, _pBitNoFilter });
if ((int)_pRVAL.Value < 0)
{
return((int)_pRVAL.Value);
}
else
{
return((int)_pCriteriaId.Value);
}
}
