public static SurveyScoreCard GetSurveyScoreCard(string pstrList, Guid pguidScoreCard)
{
SurveyScoreCard sscThis = null;
SPWeb web = SPContext.Current.Web;
{
try
{
SPList lst = web.Lists.TryGetList(pstrList);
if (lst != null)
{
SPListItem lsi = null;
lsi = lst.GetItemByUniqueId(pguidScoreCard);
JavaScriptSerializer ser = new JavaScriptSerializer();
sscThis = ser.Deserialize <SurveyScoreCard>(lsi["ScoreCardData"].ToString());
}
}
catch (Exception ex)
{
throw ex;
}
}
return(sscThis);
}
public void PopulateScoreDisplay(int pintScore)
{
SurveyScoreCardRange rngMatch = new SurveyScoreCardRange();
SurveyScoreCard sscThis = new SurveyScoreCard(); // FTKHandler.GetScoreCard();
foreach (SurveyScoreCardRange rngThis in sscThis.Ranges)
{
//From x --> infinity
if (pintScore >= rngThis.LowerBound && rngThis.UpperBound == null)
{
rngMatch = rngThis;
break;
}
//From x --> -infinity
else if (pintScore <= rngThis.UpperBound && rngThis.LowerBound == null)
{
rngMatch = rngThis;
break;
}
else if (pintScore >= rngThis.LowerBound && pintScore <= rngThis.UpperBound)
{
rngMatch = rngThis;
break;
}
}
//ScoreDescription = rngMatch.Message;
//ScoreColor = rngMatch.RAGRating.ToString();
RAGRating = rngMatch.RAGRating;
}
public void PopulateScoreDisplay(int pintScore)
{
SurveyScoreCardRange rngMatch = new SurveyScoreCardRange();
SurveyScoreCard sscThis = new SurveyScoreCard(); // FTKHandler.GetScoreCard();
foreach (SurveyScoreCardRange rngThis in sscThis.Ranges)
{
//From x --> infinity
if (pintScore >= rngThis.LowerBound && rngThis.UpperBound == null)
{
rngMatch = rngThis;
break;
}
//From x --> -infinity
else if (pintScore <= rngThis.UpperBound && rngThis.LowerBound == null)
{
rngMatch = rngThis;
break;
}
else if (pintScore >= rngThis.LowerBound && pintScore <= rngThis.UpperBound)
{
rngMatch = rngThis;
break;
}
}
//ScoreDescription = rngMatch.Message;
//ScoreColor = rngMatch.RAGRating.ToString();
RAGRating = rngMatch.RAGRating;
}
public static SurveyScoreCard GetScoreCard()
{
SurveyScoreCard scdReturn = new SurveyScoreCard();
scdReturn.ID = Guid.NewGuid();
scdReturn.Name = "Fraud Toolkit";
scdReturn.Ranges.Add(new SurveyScoreCardRange {
ID = Guid.NewGuid(), LowerBound = 0, UpperBound = 1, RAGRating = SurveyScore.RAGRating.Red, Message = "One to Settle"
});
scdReturn.Ranges.Add(new SurveyScoreCardRange {
ID = Guid.NewGuid(), LowerBound = 2, UpperBound = 3, RAGRating = SurveyScore.RAGRating.Red, Message = "Weak Case, Likely to Settle"
});
scdReturn.Ranges.Add(new SurveyScoreCardRange {
ID = Guid.NewGuid(), LowerBound = 4, UpperBound = 5, RAGRating = SurveyScore.RAGRating.Amber, Message = "Investigation Warranted, may be One To Settle"
});
scdReturn.Ranges.Add(new SurveyScoreCardRange {
ID = Guid.NewGuid(), LowerBound = 6, UpperBound = 7, RAGRating = SurveyScore.RAGRating.Amber, Message = "Investigation Warranted,50:50 Prospects"
});
scdReturn.Ranges.Add(new SurveyScoreCardRange {
ID = Guid.NewGuid(), LowerBound = 8, UpperBound = 9, RAGRating = SurveyScore.RAGRating.Amber, Message = "Investigation Warranted, Looks Like One To Fight"
});
scdReturn.Ranges.Add(new SurveyScoreCardRange {
ID = Guid.NewGuid(), LowerBound = 10, UpperBound = 100, RAGRating = SurveyScore.RAGRating.Green, Message = "Good Case One To Fight"
});
return(scdReturn);
}
private SurveyScoreCard SaveScoreCard(HttpContext context)
{
string strList = context.Request["List"] == null ? mcstrScoreCardList : context.Request["List"];
SurveyScoreCard sscReturn = new SurveyScoreCard();
try
{
if (context.Request["ScoreCardData"] != null)
{
JavaScriptSerializer ser = new JavaScriptSerializer();
sscReturn = ser.Deserialize <SurveyScoreCard>(context.Request["ScoreCardData"]);
using (SPWeb web = SPContext.Current.Web)
{
SPList lst = web.Lists.TryGetList(strList);
if (lst != null)
{
SPListItem lsi;
if (sscReturn.ID == Guid.Empty)
{
lsi = lst.Items.Add();
}
else
{
lsi = lst.GetItemByUniqueId(sscReturn.ID);
}
lsi["Title"] = sscReturn.Name;
lsi["ScoreCardData"] = ser.Serialize(sscReturn);
web.AllowUnsafeUpdates = true;
lsi.Update();
web.AllowUnsafeUpdates = false;
}
else
{
context.Response.StatusCode = 500;
context.Response.StatusDescription = "DWF Survey: Scorecard List not found";
}
}
}
else
{
context.Response.StatusCode = 500;
context.Response.StatusDescription = "DWF Survey: Scorecard data not found";
}
}
catch (Exception ex)
{
context.Response.StatusCode = 500;
context.Response.StatusDescription = "DWF Survey: " + ex.Message;
}
return(sscReturn);
}
public int Score(SurveyTemplate pstTemplate, SurveyScoreCard sscScoreCard)
{
int intAnswerCount = 0;
int intAnswerTotal = 0;
int intReturnScore = 0;
TemplateID = pstTemplate.TemplateID;
ScoreCard = sscScoreCard;
foreach (SurveyAnswer ansThis in ResponseData)
{
if (ansThis.Type == QuestionType.Radio || ansThis.Type == QuestionType.DropDown)
{
int? intValue = pstTemplate.GetResponseValue(ansThis.ResponseID);
if (intValue != null)
{
intAnswerCount++;
Guid[] strReversibleAnswers = { };
if (AlternateScore && strReversibleAnswers.Contains(ansThis.ID))
{
intAnswerTotal += 10 - intValue.Value;
}
else
{
intAnswerTotal += intValue.Value;
}
}
}
}
if (intAnswerCount != 0)
{
intReturnScore = intAnswerTotal / intAnswerCount;
}
else
{
intReturnScore = 0;
}
PopulateScoreDisplay(intReturnScore, sscScoreCard);
return intReturnScore;
}
public SurveyResponse(SPListItem lsi)
{
ID = lsi.UniqueId;
ResponseName = lsi["ResponseName"].ToString();
TemplateID = new Guid(lsi["TemplateID"].ToString());
if (lsi["ResponseData"] != null)
{
JavaScriptSerializer ser = new JavaScriptSerializer(new SimpleTypeResolver());
ResponseData = ser.Deserialize <List <SurveyAnswer> >(lsi["ResponseData"].ToString());
}
DateCreated = (DateTime)lsi[SPBuiltInFieldId.Created];
DateModified = (DateTime)lsi[SPBuiltInFieldId.Modified];
ScoreCard = new SurveyScoreCard(); // FTKHandler.GetScoreCard();
PopulateScoreDisplay(Int32.Parse(lsi["Score"].ToString()), ScoreCard);
}
public int Score(SurveyTemplate pstTemplate, SurveyScoreCard sscScoreCard)
{
int intAnswerCount = 0;
int intAnswerTotal = 0;
int intReturnScore = 0;
TemplateID = pstTemplate.TemplateID;
ScoreCard = sscScoreCard;
foreach (SurveyAnswer ansThis in ResponseData)
{
if (ansThis.Type == QuestionType.Radio || ansThis.Type == QuestionType.DropDown)
{
int?intValue = pstTemplate.GetResponseValue(ansThis.ResponseID);
if (intValue != null)
{
intAnswerCount++;
Guid[] strReversibleAnswers = { };
if (AlternateScore && strReversibleAnswers.Contains(ansThis.ID))
{
intAnswerTotal += 10 - intValue.Value;
}
else
{
intAnswerTotal += intValue.Value;
}
}
}
}
if (intAnswerCount != 0)
{
intReturnScore = intAnswerTotal / intAnswerCount;
}
else
{
intReturnScore = 0;
}
PopulateScoreDisplay(intReturnScore, sscScoreCard);
return(intReturnScore);
}
private SurveyScoreCard GetScoreCard(HttpContext context)
{
SurveyScoreCard scdReturn = new SurveyScoreCard();
string strList = context.Request["List"] == null ? mcstrScoreCardList : context.Request["List"];
scdReturn.ID = Guid.NewGuid();
scdReturn.Name = "Fraud Toolkit";
scdReturn.Ranges.Add(new SurveyScoreCardRange {
ID = Guid.NewGuid(), LowerBound = 0, UpperBound = 1, RAGRating = SurveyScore.RAGRating.Red, Message = "One to Settle"
});
scdReturn.Ranges.Add(new SurveyScoreCardRange {
ID = Guid.NewGuid(), LowerBound = 2, UpperBound = 3, RAGRating = SurveyScore.RAGRating.Red, Message = "Weak Case, Likely to Settle"
});
scdReturn.Ranges.Add(new SurveyScoreCardRange {
ID = Guid.NewGuid(), LowerBound = 4, UpperBound = 5, RAGRating = SurveyScore.RAGRating.Amber, Message = "Investigation Warranted, may be One To Settle"
});
scdReturn.Ranges.Add(new SurveyScoreCardRange {
ID = Guid.NewGuid(), LowerBound = 6, UpperBound = 7, RAGRating = SurveyScore.RAGRating.Amber, Message = "Investigation Warranted,50:50 Prospects"
});
scdReturn.Ranges.Add(new SurveyScoreCardRange {
ID = Guid.NewGuid(), LowerBound = 8, UpperBound = 9, RAGRating = SurveyScore.RAGRating.Amber, Message = "Investigation Warranted, Looks Like One To Fight"
});
scdReturn.Ranges.Add(new SurveyScoreCardRange {
ID = Guid.NewGuid(), LowerBound = 10, UpperBound = 100, RAGRating = SurveyScore.RAGRating.Green, Message = "Good Case One To Fight"
});
//using (SPWeb web = SPContext.Current.Web)
//{
// try
// {
// SPList lst = web.Lists.TryGetList(context.Request["List"]);
// if (lst != null)
// {
// SPListItem lsi = null;
// if (context.Request["ScoreCardID"] == null)
// {
// SPQuery qry = new SPQuery();
// qry.RowLimit = 1;
// qry.Query = @"<OrderBy><FieldRef Name='Created' Ascending='False' /></OrderBy>";
// SPListItemCollection lic = lst.GetItems(qry);
// if (lic.Count == 1)
// {
// lsi = lic[0];
// }
// }
// else
// {
// lsi = lst.GetItemByUniqueId(new Guid(context.Request["TemplateID"]));
// }
// if (lsi != null)
// {
// JavaScriptSerializer ser = new JavaScriptSerializer(new SimpleTypeResolver());
// scdReturn = ser.Deserialize<SurveyScoreCard>(lsi["ScoreCardData"].ToString());
// }
// else
// {
// context.Response.StatusCode = 500;
// context.Response.StatusDescription = "DWF Survey: Scorecard Not Found";
// }
// }
// else
// {
// context.Response.StatusCode = 500;
// context.Response.StatusDescription = "DWF Survey: Specified List Not Found";
// }
// }
// catch (Exception ex)
// {
// context.Response.StatusCode = 500;
// context.Response.StatusDescription = "DWF Survey: " + ex.Message;
// }
return(scdReturn);
}
private SurveyScoreCard SaveScoreCard(HttpContext context)
{
string strList = context.Request["List"] == null ? mcstrScoreCardList : context.Request["List"];
SurveyScoreCard sscReturn = new SurveyScoreCard();
try
{
if (context.Request["ScoreCardData"] != null)
{
JavaScriptSerializer ser = new JavaScriptSerializer();
sscReturn = ser.Deserialize<SurveyScoreCard>(context.Request["ScoreCardData"]);
using (SPWeb web = SPContext.Current.Web)
{
SPList lst = web.Lists.TryGetList(strList);
if (lst != null)
{
SPListItem lsi;
if (sscReturn.ID == Guid.Empty)
{
lsi = lst.Items.Add();
}
else
{
lsi = lst.GetItemByUniqueId(sscReturn.ID);
}
lsi["Title"] = sscReturn.Name;
lsi["ScoreCardData"] = ser.Serialize(sscReturn);
web.AllowUnsafeUpdates = true;
lsi.Update();
web.AllowUnsafeUpdates = false;
}
else
{
context.Response.StatusCode = 500;
context.Response.StatusDescription = "DWF Survey: Scorecard List not found";
}
}
}
else
{
context.Response.StatusCode = 500;
context.Response.StatusDescription = "DWF Survey: Scorecard data not found";
}
}
catch (Exception ex)
{
context.Response.StatusCode = 500;
context.Response.StatusDescription = "DWF Survey: " + ex.Message;
}
return sscReturn;
}
private SurveyScoreCard GetScoreCard(HttpContext context)
{
SurveyScoreCard scdReturn = new SurveyScoreCard();
string strList = context.Request["List"] == null ? mcstrScoreCardList : context.Request["List"];
scdReturn.ID = Guid.NewGuid();
scdReturn.Name = "Fraud Toolkit";
scdReturn.Ranges.Add(new SurveyScoreCardRange { ID = Guid.NewGuid(), LowerBound = 0, UpperBound = 1, RAGRating = SurveyScore.RAGRating.Red, Message = "One to Settle" });
scdReturn.Ranges.Add(new SurveyScoreCardRange { ID = Guid.NewGuid(), LowerBound = 2, UpperBound = 3, RAGRating = SurveyScore.RAGRating.Red, Message = "Weak Case, Likely to Settle" });
scdReturn.Ranges.Add(new SurveyScoreCardRange { ID = Guid.NewGuid(), LowerBound = 4, UpperBound = 5, RAGRating = SurveyScore.RAGRating.Amber, Message = "Investigation Warranted, may be One To Settle" });
scdReturn.Ranges.Add(new SurveyScoreCardRange { ID = Guid.NewGuid(), LowerBound = 6, UpperBound = 7, RAGRating = SurveyScore.RAGRating.Amber, Message = "Investigation Warranted,50:50 Prospects" });
scdReturn.Ranges.Add(new SurveyScoreCardRange { ID = Guid.NewGuid(), LowerBound = 8, UpperBound = 9, RAGRating = SurveyScore.RAGRating.Amber, Message = "Investigation Warranted, Looks Like One To Fight" });
scdReturn.Ranges.Add(new SurveyScoreCardRange { ID = Guid.NewGuid(), LowerBound = 10, UpperBound = 100, RAGRating = SurveyScore.RAGRating.Green, Message = "Good Case One To Fight" });
//using (SPWeb web = SPContext.Current.Web)
//{
// try
// {
// SPList lst = web.Lists.TryGetList(context.Request["List"]);
// if (lst != null)
// {
// SPListItem lsi = null;
// if (context.Request["ScoreCardID"] == null)
// {
// SPQuery qry = new SPQuery();
// qry.RowLimit = 1;
// qry.Query = @"<OrderBy><FieldRef Name='Created' Ascending='False' /></OrderBy>";
// SPListItemCollection lic = lst.GetItems(qry);
// if (lic.Count == 1)
// {
// lsi = lic[0];
// }
// }
// else
// {
// lsi = lst.GetItemByUniqueId(new Guid(context.Request["TemplateID"]));
// }
// if (lsi != null)
// {
// JavaScriptSerializer ser = new JavaScriptSerializer(new SimpleTypeResolver());
// scdReturn = ser.Deserialize<SurveyScoreCard>(lsi["ScoreCardData"].ToString());
// }
// else
// {
// context.Response.StatusCode = 500;
// context.Response.StatusDescription = "DWF Survey: Scorecard Not Found";
// }
// }
// else
// {
// context.Response.StatusCode = 500;
// context.Response.StatusDescription = "DWF Survey: Specified List Not Found";
// }
// }
// catch (Exception ex)
// {
// context.Response.StatusCode = 500;
// context.Response.StatusDescription = "DWF Survey: " + ex.Message;
// }
return scdReturn;
}
public static SurveyScoreCard GetScoreCard()
{
SurveyScoreCard scdReturn = new SurveyScoreCard();
scdReturn.ID = Guid.NewGuid();
scdReturn.Name = "Fraud Toolkit";
scdReturn.Ranges.Add(new SurveyScoreCardRange { ID = Guid.NewGuid(), LowerBound = 0, UpperBound = 1, RAGRating = SurveyScore.RAGRating.Red, Message = "One to Settle" });
scdReturn.Ranges.Add(new SurveyScoreCardRange { ID = Guid.NewGuid(), LowerBound = 2, UpperBound = 3, RAGRating = SurveyScore.RAGRating.Red, Message = "Weak Case, Likely to Settle" });
scdReturn.Ranges.Add(new SurveyScoreCardRange { ID = Guid.NewGuid(), LowerBound = 4, UpperBound = 5, RAGRating = SurveyScore.RAGRating.Amber, Message = "Investigation Warranted, may be One To Settle" });
scdReturn.Ranges.Add(new SurveyScoreCardRange { ID = Guid.NewGuid(), LowerBound = 6, UpperBound = 7, RAGRating = SurveyScore.RAGRating.Amber, Message = "Investigation Warranted,50:50 Prospects" });
scdReturn.Ranges.Add(new SurveyScoreCardRange { ID = Guid.NewGuid(), LowerBound = 8, UpperBound = 9, RAGRating = SurveyScore.RAGRating.Amber, Message = "Investigation Warranted, Looks Like One To Fight" });
scdReturn.Ranges.Add(new SurveyScoreCardRange { ID = Guid.NewGuid(), LowerBound = 10, UpperBound = 100, RAGRating = SurveyScore.RAGRating.Green, Message = "Good Case One To Fight" });
return scdReturn;
}
public SurveyResponse(SPListItem lsi)
{
ID = lsi.UniqueId;
ResponseName = lsi["ResponseName"].ToString();
TemplateID = new Guid(lsi["TemplateID"].ToString());
if (lsi["ResponseData"] != null)
{
JavaScriptSerializer ser = new JavaScriptSerializer(new SimpleTypeResolver());
ResponseData = ser.Deserialize<List<SurveyAnswer>>(lsi["ResponseData"].ToString());
}
DateCreated = (DateTime)lsi[SPBuiltInFieldId.Created];
DateModified = (DateTime)lsi[SPBuiltInFieldId.Modified];
ScoreCard = new SurveyScoreCard(); // FTKHandler.GetScoreCard();
PopulateScoreDisplay(Int32.Parse(lsi["Score"].ToString()), ScoreCard);
}
