public override void DeleteItem()
{
if (form.gameObject.activeSelf)
{
form.gameObject.SetActive(false);
addButton.gameObject.SetActive(true);
removeButton.gameObject.SetActive(false);
}
else
{
// Delete any seleted item from list.
List <SurveyItem> toRemove = new List <SurveyItem>();
for (int i = 0; i < contentRect.childCount; i++)
{
SurveyItem t = contentRect.GetChild(i).GetComponent <SurveyItem> ();
if (t.toggle.isOn)
{
toRemove.Add(t);
}
}
foreach (SurveyItem tt in toRemove)
{
AppController.instance.allSurveys.Remove(tt.item);
DestroyImmediate(tt.gameObject);
}
Show(AppController.instance.allSurveys);
}
}
public async Task <ActionResult <SurveyItem> > PostSurveyItem(SurveyItem surveyItem)
{
_context.SurveyItems.Add(surveyItem);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSurveyItem", new { id = surveyItem.Id }, surveyItem));
}
/// <summary>
///
/// </summary>
private void PopulateForm()
{
if (!string.IsNullOrEmpty(SurveyIdField.Value))
{
int surveyId = int.Parse(SurveyIdField.Value);
Survey biz = new Survey();
biz.Get(surveyId);
base.PopulateForm(biz);
// populate survey items
DataView surveyItems = SurveyItem.GetByParentAsDataView <SurveyItem>(surveyId);
SurveyItemsGrid.DataSource = surveyItems;
SurveyItemsGrid.DataBind();
// set related record if exists
int patientItemId = int.Parse(base.DecrypyValue(PatientItemId.Value));
DataTable relatedRecords = RelatedRecordsDa.GetRecord("ProtocolMgr_PatientItems", patientItemId, "Surveys", surveyId);
if (relatedRecords.Rows.Count > 0)
{
RelatedRecordId.Value = relatedRecords.Rows[0][RelatedRecord.RelatedRecordId].ToString();
}
}
else
{
// show empty grid by builing empty data table
DataTable dt = new DataTable();
dt.Columns.AddRange((from col in new SurveyItem().FieldNames
select new DataColumn(col)).ToArray());
SurveyItemsGrid.DataSource = dt.DefaultView;
SurveyItemsGrid.DataBind();
}
SurveyPluginControl.SetSurveyIdField(SurveyIdField.Value);
}
public Task <SurveyItem> UpdateSurveyItemAsync(SurveyItem objExistingSurveyItem)
{
try
{
var ExistingSurveyItem = _context.SurveyItem
.Where(x => x.Id == objExistingSurveyItem.Id)
.Include(x => x.SurveyItemOption)
.FirstOrDefault();
ExistingSurveyItem.ItemLabel = objExistingSurveyItem.ItemLabel;
ExistingSurveyItem.ItemType = objExistingSurveyItem.ItemType;
ExistingSurveyItem.ItemValue = objExistingSurveyItem.ItemValue;
ExistingSurveyItem.Required = objExistingSurveyItem.Required;
ExistingSurveyItem.SurveyItemOption = objExistingSurveyItem.SurveyItemOption;
_context.SaveChanges();
return(Task.FromResult(ExistingSurveyItem));
}
catch (Exception ex)
{
DetachAllEntities();
throw ex;
}
}
public async Task <ActionResult <apple.Survey> > PostSurveyItem(SurveyItem surveyItem)
{
if (SurveyItemExists(surveyItem.Id))
{
await PutSurveyItem(surveyItem.Id, surveyItem);
return(Ok(surveyItem));
}
else
{
_context.SurveyItems.Add(surveyItem);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (SurveyItemExists(surveyItem.Id))
{
// This shouldn't really be hit, given the previous check.
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetSurveyItem", new { id = surveyItem.Id }, surveyItem));
}
}
private Models.SurveyItem ConvertToSurveyItem(OqtaneSurveyItem objOqtaneSurveyItem)
{
if (objOqtaneSurveyItem == null)
{
return(new Models.SurveyItem());
}
// Create new Object
Models.SurveyItem objSurveyItem = new SurveyItem();
objSurveyItem.Id = objOqtaneSurveyItem.Id;
objSurveyItem.ItemLabel = objOqtaneSurveyItem.ItemLabel;
objSurveyItem.ItemType = objOqtaneSurveyItem.ItemType;
objSurveyItem.ItemValue = objOqtaneSurveyItem.ItemValue;
objSurveyItem.Position = objOqtaneSurveyItem.Position;
objSurveyItem.Required = objOqtaneSurveyItem.Required;
objSurveyItem.SurveyChoiceId = objOqtaneSurveyItem.SurveyChoiceId;
// Create new Collection
objSurveyItem.SurveyItemOption = new List <SurveyItemOption>();
foreach (OqtaneSurveyItemOption objOqtaneSurveyItemOption in objOqtaneSurveyItem.OqtaneSurveyItemOption)
{
// Create new Object
Models.SurveyItemOption objAddSurveyItemOption = new SurveyItemOption();
objAddSurveyItemOption.Id = objOqtaneSurveyItemOption.Id;
objAddSurveyItemOption.OptionLabel = objOqtaneSurveyItemOption.OptionLabel;
// Add to Collection
objSurveyItem.SurveyItemOption.Add(objAddSurveyItemOption);
}
return(objSurveyItem);
}
public async Task <IActionResult> PutSurveyItem(int id, SurveyItem surveyItem)
{
if (id != surveyItem.Id)
{
return(BadRequest());
}
_context.Entry(surveyItem).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SurveyItemExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(CreatedAtAction("GetSurveyItem", new { id = surveyItem.Id }, surveyItem));
}
public override void AddItem(string date, string title, string comments)
{
Survey survey = new Survey()
{
date = date, title = title, comments = comments, manager = new Manager(), store = new Store()
};
GameObject go = (GameObject)Instantiate(prefab);
go.transform.SetParent(contentRect.transform);
go.name = "Survey " + contentRect.childCount.ToString();
go.transform.localScale = new Vector3(1f, 1f, 1f);
go.SetActive(true);
if (survey.title.IsNullOrEmpty())
{
survey.title = go.name;
}
SurveyItem item = go.GetComponent <SurveyItem> ();
item.Setup(survey);
if (AppController.instance.allSurveys != null)
{
AppController.instance.allSurveys.Add(survey);
}
updateContentRect();
form.gameObject.SetActive(false);
addButton.gameObject.SetActive(true);
removeButton.gameObject.SetActive(false);
}
public SurveyItem SearchItemsByDescription(string itemDescription)
{
SurveyItem surveyItem = new SurveyItem();
surveyItem = databaseContext.GetSurveyItemByDescription(itemDescription);
return(surveyItem);
}
private Models.Survey ConvertToSurvey(OqtaneSurvey objOqtaneSurvey)
{
if (objOqtaneSurvey == null)
{
return(new Models.Survey());
}
// Create new Object
Models.Survey objAddSurvey = new Models.Survey();
objAddSurvey.SurveyId = objOqtaneSurvey.SurveyId;
objAddSurvey.ModuleId = objOqtaneSurvey.ModuleId;
objAddSurvey.SurveyName = objOqtaneSurvey.SurveyName;
objAddSurvey.CreatedBy = objOqtaneSurvey.CreatedBy;
objAddSurvey.CreatedOn = objOqtaneSurvey.CreatedOn;
objAddSurvey.ModifiedBy = objOqtaneSurvey.ModifiedBy;
objAddSurvey.ModifiedOn = objOqtaneSurvey.ModifiedOn;
if (objOqtaneSurvey.UserId != null)
{
objAddSurvey.UserId = objOqtaneSurvey.UserId.Value;
}
// Create new Collection
objAddSurvey.SurveyItem = new List <SurveyItem>();
foreach (OqtaneSurveyItem objOqtaneSurveyItem in objOqtaneSurvey.OqtaneSurveyItem)
{
// Create new Object
Models.SurveyItem objAddSurveyItem = new SurveyItem();
objAddSurveyItem.Id = objOqtaneSurveyItem.Id;
objAddSurveyItem.ItemLabel = objOqtaneSurveyItem.ItemLabel;
objAddSurveyItem.ItemType = objOqtaneSurveyItem.ItemType;
objAddSurveyItem.ItemValue = objOqtaneSurveyItem.ItemValue;
objAddSurveyItem.Position = objOqtaneSurveyItem.Position;
objAddSurveyItem.Required = objOqtaneSurveyItem.Required;
objAddSurveyItem.SurveyChoiceId = objOqtaneSurveyItem.SurveyChoiceId;
// Create new Collection
objAddSurveyItem.SurveyItemOption = new List <SurveyItemOption>();
foreach (OqtaneSurveyItemOption objOqtaneSurveyItemOption in objOqtaneSurveyItem.OqtaneSurveyItemOption)
{
// Create new Object
Models.SurveyItemOption objAddSurveyItemOption = new SurveyItemOption();
objAddSurveyItemOption.Id = objOqtaneSurveyItemOption.Id;
objAddSurveyItemOption.OptionLabel = objOqtaneSurveyItemOption.OptionLabel;
// Add to Collection
objAddSurveyItem.SurveyItemOption.Add(objAddSurveyItemOption);
}
// Add to Collection
objAddSurvey.SurveyItem.Add(objAddSurveyItem);
}
return(objAddSurvey);
}
public SurveyItem GetSurveyItemByDescription(string description)
{
SurveyItem item = new SurveyItem();
DynamicParameters dataParams = new DynamicParameters();
dataParams.Add("@description", description);
item = DBContext.ExecuteReturnScalar <SurveyItem>("sp_GetItemByDescription", dataParams);
return(item);
}
public async Task <SurveyItem> UpdateSurveyItemAsync(SurveyItem objExistingSurveyItem)
{
SurveyItem dtoSurveyItem = GetDTOItemCopy(objExistingSurveyItem);
HttpResponseMessage response = await _client.PutAsJsonAsync(API_PREFIX + "/items/" + dtoSurveyItem.Id, dtoSurveyItem);
response.EnsureSuccessStatusCode();
return(await response.Content.ReadFromJsonAsync <SurveyItem>());
}
public async Task <ActionResult> DeleteSurveyItem(int key)
{
try
{
int surveyId = int.Parse(Request.Headers.GetValues("SurveyId")[0]);
var survey = await _prepareService.GetSurveys(surveyId);
var surveyDelete = survey.FirstOrDefault();
if (surveyDelete != null)
{
surveyDelete.StartTracking();
if (surveyDelete.SurveyItems.Any(i => i.Number == key))
{
surveyDelete.SurveyItems.FirstOrDefault(i => i.Number == key).MarkAsDeleted();
}
Survey[] deleteSurveyItem = new[] { surveyDelete };
await _prepareService.SaveSurveys(deleteSurveyItem);
//Reorder
List <SurveyItem> surveyItemsTemp = new List <SurveyItem>();
var countReorder = 1;
foreach (var item in surveyDelete.SurveyItems.ToList())
{
var temp = new SurveyItem {
SurveyId = item.SurveyId,
Number = countReorder,
Query = item.Query
};
surveyItemsTemp.Add(temp);
countReorder++;
}
//Delete all survey items
surveyDelete.StartTracking();
foreach (var tempItem in surveyDelete.SurveyItems.ToList())
{
surveyDelete.SurveyItems.ToList().FirstOrDefault(i => i.Number == tempItem.Number).MarkAsDeleted();
}
//Reenter from temporary
surveyDelete.StartTracking();
foreach (var item in surveyItemsTemp)
{
surveyDelete.SurveyItems.Add(item);
}
Survey[] editSurvey = new[] { surveyDelete };
await _prepareService.SaveSurveys(editSurvey);
return(Json(surveyDelete.SurveyItems.Any(i => i.Number == key), JsonRequestBehavior.AllowGet));
}
return(Json(survey, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, ex.Message));
}
}
public async Task <SurveyItem> CreateSurveyItemAsync(SurveyItem newSurveyItem)
{
newSurveyItem.SurveyId = newSurveyItem.Survey.Id;
newSurveyItem.Position = newSurveyItem.Survey.SurveyItems.Count;
SurveyItem dtoSurveyItem = GetDTOItemCopy(newSurveyItem);
HttpResponseMessage response = await _client.PostAsJsonAsync <SurveyItem>(API_PREFIX + "/items", dtoSurveyItem);
response.EnsureSuccessStatusCode();
return(await response.Content.ReadFromJsonAsync <SurveyItem>());
}
private SurveyItem GetDTOItemCopy(SurveyItem itemToCopy)
{
SurveyItem dtoSurveyItem = new SurveyItem();
dtoSurveyItem.Id = itemToCopy.Id;
dtoSurveyItem.SurveyId = itemToCopy.SurveyId;
dtoSurveyItem.Position = itemToCopy.Position;
dtoSurveyItem.ItemLabel = itemToCopy.ItemLabel;
dtoSurveyItem.ItemType = itemToCopy.ItemType;
dtoSurveyItem.ItemValue = itemToCopy.ItemValue;
dtoSurveyItem.Required = itemToCopy.Required;
dtoSurveyItem.SurveyItemOptions = itemToCopy.SurveyItemOptions;
return(dtoSurveyItem);
}
public async Task <bool> DeleteSurveyItemAsync(SurveyItem objExistingSurveyItem)
{
try
{
HttpResponseMessage response = await _client.DeleteAsync(API_PREFIX + "/items/" + objExistingSurveyItem.Id);
response.EnsureSuccessStatusCode();
}
catch (Exception e)
{
return(false);
}
return(true);
}
private void OnSurveyGather(SurveyCharge survey, Item item)
{
Hash <int, SurveyItem> surveyItems = _activeSurveyCharges[survey.GetInstanceID()].Items;
int itemId = item.info.itemid;
if (surveyItems[itemId] != null)
{
surveyItems[itemId].Amount += item.amount;
}
else
{
surveyItems[itemId] = new SurveyItem(item.info.displayName.translated, item.amount);
}
}
public Task <SurveyItem> CreateSurveyItemAsync(SurveyItem NewSurveyItem)
{
try
{
SurveyItem objSurveyItem = new SurveyItem();
objSurveyItem.SurveyAnswer = new List <SurveyAnswer>();
objSurveyItem.SurveyNavigation =
_context.Survey
.Where(x => x.Id == NewSurveyItem.SurveyNavigation.Id)
.FirstOrDefault();
objSurveyItem.Id = 0;
objSurveyItem.ItemLabel = NewSurveyItem.ItemLabel;
objSurveyItem.ItemType = NewSurveyItem.ItemType;
objSurveyItem.ItemValue = NewSurveyItem.ItemValue;
objSurveyItem.Required = NewSurveyItem.Required;
objSurveyItem.Position = 0;
if (NewSurveyItem.SurveyItemOption != null)
{
objSurveyItem.SurveyItemOption = NewSurveyItem.SurveyItemOption;
}
_context.SurveyItem.Add(objSurveyItem);
_context.SaveChanges();
// Set position
int CoutOfSurveyItems =
_context.SurveyItem
.Where(x => x.SurveyNavigation.Id == NewSurveyItem.SurveyNavigation.Id)
.Count();
objSurveyItem.Position = CoutOfSurveyItems;
_context.SaveChanges();
return(Task.FromResult(objSurveyItem));
}
catch (Exception ex)
{
DetachAllEntities();
throw ex;
}
}
public Task <bool> DeleteSurveyItemAsync(SurveyItem objExistingSurveyItem)
{
var ExistingSurveyItem =
_context.SurveyItem
.Where(x => x.Id == objExistingSurveyItem.Id)
.FirstOrDefault();
if (ExistingSurveyItem != null)
{
_context.SurveyItem.Remove(ExistingSurveyItem);
_context.SaveChanges();
}
else
{
return(Task.FromResult(false));
}
return(Task.FromResult(true));
}
private void btnSaveItem_Click(object sender, EventArgs e)
{
SurveyItem surveyItem = new SurveyItem();
surveyItem.ItemDescription = txtCaptureItem.Text;
if (double.TryParse(txtCaptureMaterialPrice.Text, out double materialPrice))
{
surveyItem.MaterialPrice = materialPrice;
}
if (double.TryParse(txtCaptureLabourRate.Text, out double labourRate))
{
surveyItem.LabourPrice = labourRate;
}
proccessing.AddItemDatabase(surveyItem);
}
public async static Task Run([QueueTrigger("surveydata"), StorageAccount("AzureWebJobsStorage")] SurveyItem mySurveyItem,
[Table("surveydata"), StorageAccount("AzureWebJobsStorage")] CloudTable table, ILogger log)
{
log.LogInformation($"C# Queue trigger function processed: {mySurveyItem}");
// create a new row in a table for the queue item
// create table entry
var item = new SurveyData()
{
PartitionKey = mySurveyItem.zip,
RowKey = mySurveyItem.id,
id = mySurveyItem.id,
filling_out_for = mySurveyItem.filling_out_for,
zip = mySurveyItem.zip,
puma = mySurveyItem.puma,
age = mySurveyItem.age,
sex = mySurveyItem.sex,
symptoms_binary = mySurveyItem.symptoms_binary,
symptoms_specific = mySurveyItem.symptoms_specific,
symptoms_all = mySurveyItem.symptoms_all,
housing = mySurveyItem.housing,
shared_space = mySurveyItem.shared_space,
covid_contact = mySurveyItem.covid_contact,
work_from_home = mySurveyItem.work_from_home,
industry = mySurveyItem.industry,
industry_other = mySurveyItem.industry_other,
behavior_change_sufaces = mySurveyItem.behavior_change_sufaces,
behavior_change_cough = mySurveyItem.behavior_change_cough,
behavior_change_distance = mySurveyItem.behavior_change_distance,
behavior_change_hands = mySurveyItem.behavior_change_hands,
behavior_change_mask = mySurveyItem.behavior_change_mask,
screener = mySurveyItem.screener
};
var operation = TableOperation.Insert(item);
await table.ExecuteAsync(operation);
}
public void AddSurveyItemsToDatabase(string jobCardNumber, List <SurveyItem> items, bool ProvidedMaterial)
{
foreach (SurveyItem item in items)
{
DynamicParameters dataParams = new DynamicParameters();
SurveyItem newsurveyItem = GetSurveyItemByDescription(item.ItemDescription);
if (ProvidedMaterial)
{
newsurveyItem.MaterialPrice = 0;
}
double charge = newsurveyItem.LabourPrice + newsurveyItem.MaterialPrice;
dataParams.Add("@ItemDescription", item.ItemDescription);
dataParams.Add("@JobCardNumber", jobCardNumber);
dataParams.Add("@Quantity", item.Quantity);
dataParams.Add("@LabourPrice", newsurveyItem.LabourPrice);
dataParams.Add("@MaterialPrice", newsurveyItem.MaterialPrice);
dataParams.Add("@Total", item.Quantity * charge);
DBContext.ExecuteWithoutReturn("sp_AddSurveyItem", dataParams);
}
}
public async Task <ActionResult> InsertSurveyItem(CRUDModel <SurveyItemViewModel> surveyItem)
{
try
{
int surveyId = int.Parse(Request.Headers.GetValues("SurveyId")[0]);
if (!ModelState.IsValid)
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, message));
}
var surveys = await _prepareService.GetSurveys(surveyId);
var survey = surveys.FirstOrDefault();
var newSurveyItem = new SurveyItem
{
SurveyId = surveyId,
Number = surveyItem.Value.Number,
Query = surveyItem.Value.Query
};
survey.SurveyItems.Add(newSurveyItem);
Survey[] addSurvey = new[] { survey };
await _prepareService.SaveSurveys(addSurvey);
return(Json(surveyItem.Value, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, ex.Message));
}
}
public override void ItemSelected()
{
int howManySelected = 0;
for (int i = 0; i < contentRect.childCount; i++)
{
SurveyItem t = contentRect.GetChild(i).GetComponent <SurveyItem> ();
if (t.toggle.isOn)
{
howManySelected++;
}
}
if (howManySelected > 0)
{
addButton.gameObject.SetActive(false);
removeButton.gameObject.SetActive(true);
}
else
{
addButton.gameObject.SetActive(true);
removeButton.gameObject.SetActive(false);
}
}
private void Btn_AddSurveyItem_Click(object sender, EventArgs e)
{
SurveyItem surveyItem = new SurveyItem();
string description = String.Empty;
description = cbo_SurveyItems.SelectedItem.ToString();
surveyItem = proccessing.SearchItemsByDescription(description);
if (int.TryParse(txt_SurveyItemQuantity.Text, out int surveyItemQuantity) == true)
{
surveyItem.Quantity = surveyItemQuantity;
}
if (surveyItem.Quantity > 0)
{
CurrentSurveyItems.Add(surveyItem);
dgv_SurveyItems.DataSource = new List <SurveyItem>();
dgv_SurveyItems.DataSource = CurrentSurveyItems;
}
else
{
MessageBox.Show("Please Enter a valid Quantity");
}
}
public List <SurveyItem> SurveyResultsData(int SelectedSurveyId, LoadDataArgs args)
{
// Get Survey Items
// Don't include "Text Area"
var query = _db.OqtaneSurveyItem
.Where(x => x.Survey == SelectedSurveyId)
.Where(x => x.ItemType != "Text Area")
.Include(x => x.OqtaneSurveyItemOption)
.OrderBy(x => x.Position).AsQueryable();
if (!string.IsNullOrEmpty(args.Filter))
{
query = query.Where(args.Filter);
}
if (!string.IsNullOrEmpty(args.OrderBy))
{
query = query.OrderBy(args.OrderBy);
}
var Results = query.Skip(args.Skip.Value).Take(args.Top.Value).ToList();
List <SurveyItem> SurveyResultsCollection = new List <SurveyItem>();
foreach (var SurveyItem in Results)
{
SurveyItem NewDTOSurveyItem = new SurveyItem();
NewDTOSurveyItem.Id = SurveyItem.Id;
NewDTOSurveyItem.ItemLabel = SurveyItem.ItemLabel;
NewDTOSurveyItem.ItemType = SurveyItem.ItemType;
NewDTOSurveyItem.Position = SurveyItem.Position;
NewDTOSurveyItem.Required = SurveyItem.Required;
List <AnswerResponse> ColAnswerResponse = new List <AnswerResponse>();
if ((SurveyItem.ItemType == "Date") || (SurveyItem.ItemType == "Date Time"))
{
var TempColAnswerResponse = _db.OqtaneSurveyAnswer
.Where(x => x.SurveyItemId == SurveyItem.Id)
.GroupBy(n => n.AnswerValueDateTime)
.Select(n => new AnswerResponse
{
OptionLabel = n.Key.Value.ToString(),
Responses = n.Count()
}
).OrderBy(n => n.OptionLabel).ToList();
foreach (var item in TempColAnswerResponse)
{
string ShortDate = item.OptionLabel;
try
{
DateTime dtTempDate = Convert.ToDateTime(item.OptionLabel);
ShortDate = dtTempDate.ToShortDateString();
}
catch
{
// use original string
}
ColAnswerResponse.Add(
new AnswerResponse
{
OptionLabel = ShortDate,
Responses = item.Responses
}
);
}
}
else
{
ColAnswerResponse = _db.OqtaneSurveyAnswer
.Where(x => x.SurveyItemId == SurveyItem.Id)
.GroupBy(n => n.AnswerValue)
.Select(n => new AnswerResponse
{
OptionLabel = n.Key,
Responses = n.Count()
}
).OrderBy(n => n.OptionLabel).ToList();
}
if (ColAnswerResponse.Count > 10)
{
// Only take top 10
NewDTOSurveyItem.AnswerResponses = ColAnswerResponse
.OrderByDescending(x => x.Responses)
.Take(10).ToList();
// Put remaining items in "Other"
var ColOtherItems = ColAnswerResponse.OrderByDescending(x => x.Responses).Skip(10).ToList();
var SumOfOther = ColOtherItems.Sum(x => x.Responses);
NewDTOSurveyItem.AnswerResponses.Add(new AnswerResponse()
{
OptionLabel = "Other", Responses = SumOfOther
});
}
else
{
NewDTOSurveyItem.AnswerResponses = ColAnswerResponse;
}
SurveyResultsCollection.Add(NewDTOSurveyItem);
}
int SurveyResultsCount = _db.OqtaneSurveyItem
.Where(x => x.Survey == SelectedSurveyId)
.Where(x => x.ItemType != "Text Area")
.Count();
return(SurveyResultsCollection);
}
/// <summary>
/// 作者：Kylin
/// 时间：2014.1.23
/// 描述：添加问卷详情
/// </summary>
/// <param name="branchId"></param>
/// <param name="subject"></param>
/// <param name="platformtype"></param>
/// <param name="beginTime"></param>
/// <param name="endTime"></param>
/// <param name="surveyItems"></param>
/// <param name="remark"></param>
/// <returns></returns>
public static bool CreateSurvey(string branchId, string subject, int? platformtype, bool isPopup, DateTime beginTime, DateTime endTime, List<SurveyItemsModel> surveyItems, string remark, int loginUserId)
{
using (var tran = new TransactionScope())
{
using (var edb = new EmeEntities())
{
try
{
var survey = new Survey()
{
PlatformType = platformtype,
IsPopup = isPopup,
Subject = subject,
IsRights = true,
BeginTime = beginTime,
EndTime = endTime,
Remark = remark,
Status = ConvertEnum.StatusTypeForActive,
UpdateTime = DateTime.Now
};
edb.Entry(survey).State = EntityState.Added;
edb.SaveChanges();
foreach (var addItem in surveyItems)
{
var surveyItem = new SurveyItem()
{
Title = addItem.title,
Status = ConvertEnum.StatusTypeForActive,
SurveyId = survey.Id,
IsMultiple = addItem.IsMulti,
CreateTime = DateTime.Now
};
edb.Entry(surveyItem).State = EntityState.Added;
edb.SaveChanges();
foreach (var addOption in addItem.Options)
{
var surveyItemOption = new SurveyItemOption()
{
Title = addOption.title,
Status = ConvertEnum.StatusTypeForActive,
SurveyItemId = surveyItem.Id,
CreateTime = DateTime.Now
};
edb.Entry(surveyItemOption).State = EntityState.Added;
}
}
if (branchId.Trim() != "")
{
var branchIdList = branchId.Split(',');
foreach (var bid in branchIdList)
{
var surveyRights = new SurveyRights()
{
SurveyId = survey.Id,
BranchId = Convert.ToInt32(bid),
Status = ConvertEnum.StatusTypeForActive,
CreateTime = DateTime.Now
};
edb.Entry(surveyRights).State = EntityState.Added;
}
}
var result = edb.SaveChanges() > 0;
tran.Complete();
return result;
}
catch (Exception ex)
{
tran.Dispose();
Common.MSMQ.QueueManager.AddExceptionLog(new ExceptionLogs()
{
ExceptionType = CommonHelper.To<int>(ExceptionType.Message),
Message = string.Format("SurveyBLL-CreateSurvey:{0};{1};{2}", ex.Message, ex.InnerException, ex.HelpLink),
IsTreat = false,
CreateBy = loginUserId,
CreateTime = DateTime.Now
});
return false;
}
}
}
}
/// <summary>
/// 作者：Kylin
/// 时间：2014.1.14
/// 描述：添加问卷详情
/// -------------------------------------
/// 作者：Vincen
/// 时间：2014.04.01
/// 描述：更新调查问卷
/// </summary>
/// <param name="surveyId"></param>
/// <param name="subject"></param>
/// <param name="platformtype"></param>
/// <param name="beginTime"></param>
/// <param name="endTime"></param>
/// <param name="surveyItems"></param>
/// <param name="remark"></param>
public static bool UpdateSurvey(int surveyId, string subject, int? platformtype, DateTime beginTime, DateTime endTime, List<SurveyItemsModel> surveyItems, string remark, int loginUserId)
{
using (var edb = new EmeEntities())
{
using (var tran = new TransactionScope())
{
try
{
// 更新 Survey
var model = edb.Survey.SingleOrDefault(p => p.Id == surveyId);
if (model != null)
{
model.PlatformType = platformtype;
model.BeginTime = beginTime;
model.EndTime = endTime;
model.Subject = subject;
model.Remark = remark;
model.UpdateTime = DateTime.Now;
edb.Entry(model).State = EntityState.Modified;
}
var surveyItemList = edb.SurveyItem.Where(p => p.SurveyId == surveyId);
// 删除原有 SurveyItem
foreach (var item in surveyItemList)
{
item.Status = ConvertEnum.StatusTypeForDelete;
foreach (var option in item.SurveyItemOption)
{
option.Status = ConvertEnum.StatusTypeForDelete;
edb.Entry(option).State = EntityState.Modified;
}
edb.Entry(item).State = EntityState.Modified;
}
// 新增更改 SurveyItem
foreach (var item in surveyItems)
{
var surveyItem = new SurveyItem()
{
Title = item.title,
Status = ConvertEnum.StatusTypeForActive,
SurveyId = surveyId,
IsMultiple = item.IsMulti,
CreateTime = DateTime.Now,
};
edb.Entry(surveyItem).State = EntityState.Added;
edb.SaveChanges();
foreach (var option in item.Options)
{
var surveyItemOption = new SurveyItemOption()
{
Title = option.title,
Status = ConvertEnum.StatusTypeForActive,
SurveyItemId = surveyItem.Id,
CreateTime = DateTime.Now
};
edb.Entry(surveyItemOption).State = EntityState.Added;
}
}
var result = edb.SaveChanges() > 0;
tran.Complete();
return result;
}
catch (Exception ex)
{
tran.Dispose();
Common.MSMQ.QueueManager.AddExceptionLog(new ExceptionLogs()
{
ExceptionType = CommonHelper.To<int>(ExceptionType.Message),
Message = string.Format("SurveyBLL-UpdateSurvey:{0};{1};{2}", ex.Message, ex.InnerException, ex.HelpLink),
IsTreat = false,
CreateBy = loginUserId,
CreateTime = DateTime.Now
});
return false;
}
}
}
}
public AuditItem(SurveyItem surveyItem)
{
_surveyItem = surveyItem;
Number = _surveyItem.Number;
}
/// <summary>
/// 作者：Kylin
/// 时间：2014.01.26
/// 描述：获取问卷项信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult GetSurveyItemsInfo(SurveyItem model)
{
return PartialView("_SurveyItem", model);
}
public async Task <ActionResult> RowDropHandler(List <SurveyItemViewModel> changed, int dropIndex)
{
try
{
JavaScriptSerializer ser = new JavaScriptSerializer();
var count = 0;
if (changed != null)
{
var surveys = await _prepareService.GetSurveys(changed.FirstOrDefault().SurveyId);
var survey = surveys.FirstOrDefault();
var surveyTemp = survey;
List <SurveyItem> surveyItemsTemp = survey.SurveyItems.ToList();
surveyTemp.StartTracking();
//Firstly delete all surveyItem to avoid bug as Number also a primary key
foreach (var tempItem in surveyTemp.SurveyItems.ToList())
{
surveyTemp.SurveyItems.ToList().FirstOrDefault(i => i.Number == tempItem.Number).MarkAsDeleted();
}
Survey[] deleteSurveyItem = new[] { surveyTemp };
await _prepareService.SaveSurveys(deleteSurveyItem);
foreach (var item in changed)
{
SurveyItem changeItem = new SurveyItem
{
SurveyId = item.SurveyId,
Number = dropIndex,
Query = item.Query
};
surveyItemsTemp.RemoveWhere(i => i.Number == item.Number);
surveyItemsTemp.Insert(dropIndex + count, changeItem);
}
survey.StartTracking();
var countReorder = 1;
foreach (var item in surveyItemsTemp)
{
survey.SurveyItems.Add(new SurveyItem
{
Number = countReorder,
Query = item.Query,
SurveyId = item.SurveyId
});
countReorder++;
}
Survey[] editSurvey = new[] { survey };
await _prepareService.SaveSurveys(editSurvey);
}
else
{
throw new ArgumentException(LocalizedStrings.GetString("AskSelectLineChangePosition") /*"Veuillez sélectionner une ligne avant de changer de position"*/);
}
return(Json(changed, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, ex.Message));
}
}
public async Task <ActionResult <SurveyDetailResponse> > GetQuestionary(int id, string user_id)
{
var item = await _surveyRepository.GetAsync(id);
//var au = Request.Headers.FirstOrDefault(o => o.Key == "Authorization");
//var aus = au.Value.ToString().Replace("Bearer ", "");
//var userId = user_id;// GetUserId();
User user = null;
if (!string.IsNullOrEmpty(user_id) && Int32.TryParse(user_id, out int _user_id))
{
user = await _userRepository.GetAsync(_user_id);
}
if (item == null)
{
return(NotFound());
}
//var comments = new List<Comment>();
//item?.Survey?.SurveyComment?.ToList().ForEach(
// c => comments.Add(
// new Comment
// {
// Id = c.Id,
// IsMine = c.User?.Email == GetUserId(),
// CommentAt = c.CreatedAt,
// Nick = c.User?.Nick,
// Text = c.Text
// })
//);
var questionaries = new List <Dto.Survey.Questionary>();
//var answers = item.Survey.SurveyUser;
List <UserQuestionAnswer> answers = null;
if (user != null && user.SurveyUsers != null && user.SurveyUsers.FirstOrDefault(p => p.SurveyId == id) != null)
{
answers = await _userQuestionRepository.GetAsync(user.SurveyUsers.FirstOrDefault(p => p.SurveyId == id).Id);
}
item?.Survey?.Questionary?.ToList().ForEach(
c => questionaries.Add(
new Dto.Survey.Questionary
{
Id = c.Id,
Question = c.Question,
Answer = c.RightAnswer,
IsAnswered = answers?.Any(p => p.QuestionaryID == c.Id)
//user?.SurveyUsers?.First(p => p.SurveyId == id).UserQuestionAnswer.Any(p => p.QuestionaryID == c.Id)
//item.Survey.Questionary.Any( p => p.Id == c.Id && answers.Any(s => s.QuestionaryID == p.Id))
})
);
var users = new List <UserResponse>();
item?.SurveyUsers?.ToList().ForEach(
c => users.Add(
new UserResponse
{
Id = c.UserId,
CompletedAt = c.FinishDate,
Nickname = c.User.Nick,
Surname = c.User.Surname,
Name = c.User.Name
})
);
var videoLink = item.Survey?.AdditionalInfo?.LinkToVideo;
bool is_video_watched = false;
if (!string.IsNullOrEmpty(videoLink) && user != null)
{
var user_id2 = user.Id;
var video_id = Youtube.ExtractVideoIdFromUri(new Uri(videoLink));
if (!string.IsNullOrEmpty(video_id))
{
var videoViewPercentage = await _generalSettingsRepository.GetVideoViewPercentage();
is_video_watched = await _videoTimelineRepository.IsSawAsync(user_id2, video_id, videoViewPercentage);
}
}
var surveyItem = new SurveyItem
{
Id = item.Survey.Id,
Title = item.Survey.Title,
Description = item.Survey.Text,
TimeForCompleting = item.Survey.NeedToBeFinishedFor,
TimeForCompletingStart = item.Survey.NeedToBeFinishedForStart,
IsLiked = item.Survey.Likes != null &&
item.Survey.Likes.FirstOrDefault(m => m.User?.Email == user?.Email) != null,
Score = item.Survey.Score,
CurrentCnt = item.Survey.NumberOfUser,
LimitCnt = item.Survey.Limit,
link = item.Survey?.AdditionalInfo?.LinkToSite,
linkVideo = videoLink,
IsVideoWatched = is_video_watched,
};
var detail = new SurveyDetailResponse
{
//Comments = comments,
Questionaries = questionaries,
SurveyItem = surveyItem,
Users = users,
};
return(detail);
}
