public HttpResponseMessage ExportGetUserSubmitsToExcel(int formId)
{
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
UserPrincipal loggedInUser = (UserPrincipal)HttpContext.Current.User;
List <UserFormSubmit> submits = UserFormSubmit.MapUserFormSubmits(
FormsAdminBLL.GetUserSubmits(formId, loggedInUser.AccountSession.ClubId), true);
DataTable dt = new DataTable();
foreach (var item in submits)
{
string[] values = new string[item.FormSubmits.Count];
int counter = 0;
foreach (var submit in item.FormSubmits)
{
if (!dt.Columns.Contains(submit.Name))
{
dt.Columns.Add(new DataColumn(submit.Name, typeof(string)));
}
values[counter] = submit.Value;
counter++;
}
dt.Rows.Add(values);
}
var form = FormsAdminBLL.GetForm(formId, loggedInUser.AccountSession.ClubId);
response.Content = new ObjectContent <string>(ExcelHelper.CreateExcelDocument(dt, form.Name, true, "Forms"), new JsonMediaTypeFormatter());
return(response);
}
public HttpResponseMessage SaveFormFieldItem(FormFieldModel formField)
{
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
FormsAdminBLL.SaveFormFieldItem(FormFieldModel.MapFormFieldDbModel(formField));
return(response);
}
public HttpResponseMessage DeleteForm(int id)
{
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
UserPrincipal loggedInUser = (UserPrincipal)HttpContext.Current.User;
FormsAdminBLL.DeleteForm(id, loggedInUser.AccountSession.ClubId);
return(response);
}
public HttpResponseMessage DeleteExternalFormAnswer(string batch)
{
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
UserPrincipal loggedInUser = (UserPrincipal)HttpContext.Current.User;
FormsAdminBLL.DeleteExternalFormAnswer(batch, loggedInUser.AccountSession.ClubId);
return(response);
}
//[ObjectChangeFilter(IdentifierProperty = "Id", ChangeType = ChangeType.Get)]
public HttpResponseMessage GetForm(int id)
{
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
UserPrincipal loggedInUser = (UserPrincipal)HttpContext.Current.User;
response.Content = new ObjectContent <FormModel>(FormModel.MapFormModel(FormsAdminBLL.GetForm(id, loggedInUser.AccountSession.ClubId), true),
new JsonMediaTypeFormatter());
return(response);
}
public HttpResponseMessage GetUserSubmits(int formId)
{
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
UserPrincipal loggedInUser = (UserPrincipal)HttpContext.Current.User;
response.Content = new ObjectContent <List <UserFormSubmit> >(UserFormSubmit.MapUserFormSubmits(
FormsAdminBLL.GetUserSubmits(formId, loggedInUser.AccountSession.ClubId), true),
new JsonMediaTypeFormatter());
return(response);
}
public HttpResponseMessage GetAllForms()
{
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
UserPrincipal loggedInUser = (UserPrincipal)HttpContext.Current.User;
List <FormModel> forms = FormModel.MapFormModels(FormsAdminBLL.GetAllForms(loggedInUser.AccountSession.ClubId));
forms.ForEach(f => f.AnswerCount = FormsAdminBLL.GetFormAnswerCount(f.Id, f.IsExternal, loggedInUser.AccountSession.ClubId));
response.Content = new ObjectContent <List <FormModel> >(forms, new JsonMediaTypeFormatter());
return(response);
}
//[ObjectChangeFilter(IdentifierProperty = "Id", ChangeType = ChangeType.Save)]
public HttpResponseMessage SaveForm(FormModel form)
{
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
UserPrincipal loggedInUser = (UserPrincipal)HttpContext.Current.User;
form.ClubId = loggedInUser.AccountSession.ClubId;
if (form.Id <= 0)
{
form.CreatedByUserId = loggedInUser.AccountSession.AccountId;
form.CreatedDate = DateTime.Now;
}
SW.Forms.DAL.Form f = FormModel.MapModelToForm(form);
FormsAdminBLL.SaveForm(f);
return(response);
}
internal static void CreateNewsletterSendItems(int newsletterSendId, List <int> userIds, List <int> contactIds = null, int formFieldId = -1)
{
using (Vicdude_NewsletterEntities db = new Vicdude_NewsletterEntities())
{
foreach (int userId in userIds)
{
Newsletter_Send_Item item = new Newsletter_Send_Item()
{
IsRead = false,
IsSent = false,
Email = SW.Core.BLL.AccountBLL.GetUserEmail(userId),
NewsletterSendId = newsletterSendId,
NewsletterSendItemGUID = Guid.NewGuid().ToString(),
SendDate = DateTime.Now,
SendToUserId = userId,
ReadDate = DateTime.Now.AddYears(-10),
HasUnsubscribed = false,
SendType = "USER"
};
db.Newsletter_Send_Item.Add(item);
}
if (contactIds != null && contactIds.Count > 0)
{
foreach (int contactId in contactIds)
{
Newsletter_Send_Item item = new Newsletter_Send_Item()
{
IsRead = false,
IsSent = false,
Email = SW.Core.BLL.ContactBLL.GetContact(contactId).Email,
NewsletterSendId = newsletterSendId,
NewsletterSendItemGUID = Guid.NewGuid().ToString(),
SendDate = DateTime.Now,
SendToContactId = contactId,
ReadDate = DateTime.Now.AddYears(-10),
HasUnsubscribed = false,
SendType = "CONTACT"
};
db.Newsletter_Send_Item.Add(item);
}
}
if (formFieldId > 0)
{
List <string> emails = FormsAdminBLL.GetExternalSubmitValues(formFieldId);
foreach (var email in emails)
{
Newsletter_Send_Item item = new Newsletter_Send_Item()
{
IsRead = false,
IsSent = false,
Email = email,
NewsletterSendId = newsletterSendId,
NewsletterSendItemGUID = Guid.NewGuid().ToString(),
SendDate = DateTime.Now,
ReadDate = DateTime.Now.AddYears(-10),
HasUnsubscribed = false,
SendType = "FORM"
};
db.Newsletter_Send_Item.Add(item);
}
}
db.SaveChanges();
}
}
