public void DeleteByPollId(int pollId) { _repository.Delete(Q.Where(Attr.PollId, pollId)); FieldManager.ItemRepository.DeleteByPollId(pollId); FieldManager.ClearCache(pollId); }
public void DeleteByFormId(int formId) { _repository.Delete(Q.Where(Attr.FormId, formId)); FieldManager.ItemRepository.DeleteByFormId(formId); FieldManager.ClearCache(formId); }
public void Update(FieldInfo info, bool updateItems) { _repository.Update(info); if (updateItems) { FieldManager.ItemRepository.DeleteByFieldId(info.Id); FieldManager.ItemRepository.InsertItems(info.PollId, info.Id, info.Items); } FieldManager.ClearCache(info.PollId); }
public void Delete(int pollId, int fieldId) { if (fieldId == 0) { return; } _repository.Delete(fieldId); FieldManager.ItemRepository.DeleteByFieldId(fieldId); FieldManager.ClearCache(pollId); }
public static int Insert(int siteId, FieldInfo fieldInfo) { fieldInfo.Taxis = GetMaxTaxis(fieldInfo.FormId) + 1; var sqlString = $@"INSERT INTO {TableName} ( {nameof(FieldInfo.FormId)}, {nameof(FieldInfo.Taxis)}, {nameof(FieldInfo.Title)}, {nameof(FieldInfo.Description)}, {nameof(FieldInfo.PlaceHolder)}, {nameof(FieldInfo.FieldType)}, {nameof(FieldInfo.Validate)}, {nameof(FieldInfo.Settings)} ) VALUES ( @{nameof(FieldInfo.FormId)}, @{nameof(FieldInfo.Taxis)}, @{nameof(FieldInfo.Title)}, @{nameof(FieldInfo.Description)}, @{nameof(FieldInfo.PlaceHolder)}, @{nameof(FieldInfo.FieldType)}, @{nameof(FieldInfo.Validate)}, @{nameof(FieldInfo.Settings)} )"; var parameters = new [] { Context.DatabaseApi.GetParameter(nameof(FieldInfo.FormId), fieldInfo.FormId), Context.DatabaseApi.GetParameter(nameof(FieldInfo.Taxis), fieldInfo.Taxis), Context.DatabaseApi.GetParameter(nameof(FieldInfo.Title), fieldInfo.Title), Context.DatabaseApi.GetParameter(nameof(FieldInfo.Description), fieldInfo.Description), Context.DatabaseApi.GetParameter(nameof(FieldInfo.PlaceHolder), fieldInfo.PlaceHolder), Context.DatabaseApi.GetParameter(nameof(FieldInfo.FieldType), fieldInfo.FieldType), Context.DatabaseApi.GetParameter(nameof(FieldInfo.Validate), fieldInfo.Validate), Context.DatabaseApi.GetParameter(nameof(FieldInfo.Settings), fieldInfo.Settings) }; var id = Context.DatabaseApi.ExecuteNonQueryAndReturnId(TableName, nameof(FieldInfo.Id), Context.ConnectionString, sqlString, parameters); FieldItemDao.InsertItems(fieldInfo.FormId, id, fieldInfo.Items); var formInfo = FormManager.GetFormInfo(siteId, fieldInfo.FormId); var list = FormUtils.StringCollectionToStringList(formInfo.Additional.ListAttributeNames); list.Add(fieldInfo.Title); formInfo.Additional.ListAttributeNames = FormUtils.ObjectCollectionToString(list); FormDao.Update(formInfo); FieldManager.ClearCache(); return(id); }
private static void SetTaxis(int id, int taxis) { var sqlString = $"UPDATE {TableName} SET Taxis = @Taxis WHERE Id = @Id"; var parms = new [] { Context.DatabaseApi.GetParameter(nameof(FieldInfo.Taxis), taxis), Context.DatabaseApi.GetParameter(nameof(FieldInfo.Id), id) }; Context.DatabaseApi.ExecuteNonQuery(Context.ConnectionString, sqlString, parms); FieldManager.ClearCache(); }
public static void DeleteByFormId(int formId) { string sqlString = $"DELETE FROM {TableName} WHERE {nameof(FieldInfo.FormId)} = @{nameof(FieldInfo.FormId)}"; var parms = new[] { Context.DatabaseApi.GetParameter(nameof(FieldInfo.FormId), formId) }; Context.DatabaseApi.ExecuteNonQuery(Context.ConnectionString, sqlString, parms); FieldItemDao.DeleteByFormId(formId); FieldManager.ClearCache(); }
public void Insert(int siteId, FieldInfo fieldInfo) { fieldInfo.Taxis = GetMaxTaxis(fieldInfo.PollId) + 1; fieldInfo.Id = _repository.Insert(fieldInfo); FieldManager.ItemRepository.InsertItems(fieldInfo.PollId, fieldInfo.Id, fieldInfo.Items); var formInfo = PollManager.GetPollInfo(siteId, fieldInfo.PollId); var list = PollUtils.StringCollectionToStringList(formInfo.ListAttributeNames); list.Add(fieldInfo.Title); formInfo.ListAttributeNames = PollUtils.ObjectCollectionToString(list); PollManager.Repository.Update(formInfo); FieldManager.ClearCache(fieldInfo.PollId); }
public IHttpActionResult Delete() { try { var request = Context.AuthenticatedRequest; var formInfo = FormManager.GetFormInfoByGet(request); if (formInfo == null) { return(NotFound()); } if (!request.IsAdminLoggin || !request.AdminPermissions.HasSitePermissions(formInfo.SiteId, FormUtils.MenuFormsPermission)) { return(Unauthorized()); } var fieldId = request.GetQueryInt("fieldId"); FieldManager.Repository.Delete(formInfo.Id, fieldId); FieldManager.ClearCache(formInfo.Id); var list = new List <object>(); foreach (var fieldInfo in FieldManager.GetFieldInfoList(formInfo.Id)) { list.Add(new { fieldInfo.Id, fieldInfo.Title, InputType = FieldManager.GetFieldTypeText(fieldInfo.FieldType), fieldInfo.Validate, fieldInfo.Taxis }); } return(Ok(new { Value = list })); } catch (Exception ex) { return(InternalServerError(ex)); } }
public static void Update(FieldInfo info, bool updateItems) { var sqlString = $@"UPDATE {TableName} SET {nameof(FieldInfo.FormId)} = @{nameof(FieldInfo.FormId)}, {nameof(FieldInfo.Taxis)} = @{nameof(FieldInfo.Taxis)}, {nameof(FieldInfo.Title)} = @{nameof(FieldInfo.Title)}, {nameof(FieldInfo.Description)} = @{nameof(FieldInfo.Description)}, {nameof(FieldInfo.PlaceHolder)} = @{nameof(FieldInfo.PlaceHolder)}, {nameof(FieldInfo.FieldType)} = @{nameof(FieldInfo.FieldType)}, {nameof(FieldInfo.Validate)} = @{nameof(FieldInfo.Validate)}, {nameof(FieldInfo.Settings)} = @{nameof(FieldInfo.Settings)} WHERE {nameof(FieldInfo.Id)} = @{nameof(FieldInfo.Id)}"; var updateParms = new [] { Context.DatabaseApi.GetParameter(nameof(FieldInfo.FormId), info.FormId), Context.DatabaseApi.GetParameter(nameof(FieldInfo.Taxis), info.Taxis), Context.DatabaseApi.GetParameter(nameof(FieldInfo.Title), info.Title), Context.DatabaseApi.GetParameter(nameof(FieldInfo.Description), info.Description), Context.DatabaseApi.GetParameter(nameof(FieldInfo.PlaceHolder), info.PlaceHolder), Context.DatabaseApi.GetParameter(nameof(FieldInfo.FieldType), info.FieldType), Context.DatabaseApi.GetParameter(nameof(FieldInfo.Validate), info.Validate), Context.DatabaseApi.GetParameter(nameof(FieldInfo.Settings), info.Additional.ToString()), Context.DatabaseApi.GetParameter(nameof(FieldInfo.Id), info.Id) }; Context.DatabaseApi.ExecuteNonQuery(Context.ConnectionString, sqlString, updateParms); if (updateItems) { FieldItemDao.DeleteByFieldId(info.Id); FieldItemDao.InsertItems(info.FormId, info.Id, info.Items); } FieldManager.ClearCache(); }