private static bool AssertLetterDetailsIncludedIn(string receivedHtml, LetterTemplate parsedHtml) { return(receivedHtml.Contains(parsedHtml.RightSideOfHeader) && parsedHtml.AddressLines.TrueForAll(receivedHtml.Contains) && receivedHtml.Contains(parsedHtml.MainBody) && receivedHtml.Contains(parsedHtml.TemplateSpecificCss)); }
/// <summary> /// Gets the letter template by identifier. /// </summary> /// <param name="letterTemplate">The letter template.</param> /// <returns></returns> public LetterTemplate GetLetterTemplateById(LetterTemplate letterTemplate) { // Initialize the Stored Procedure _databaseCommandObj = _databaseObj.GetStoredProcCommand("GetLetterTemplateById"); // Pass parameters to Stored Procedure(i.e., @ParamName), add values for _databaseObj.AddInParameter(_databaseCommandObj, "@LetterTemplateID ", DbType.Int64, letterTemplate.LetterTemplateId); _databaseObj.AddInParameter(_databaseCommandObj, "@UserName ", DbType.String, letterTemplate.UserName); // Retrieve the results of the Stored Procedure in Dataset DataSet letterTemplateDataSet = _databaseObj.ExecuteDataSet(_databaseCommandObj); if (letterTemplateDataSet != null && letterTemplateDataSet.Tables.Count > 0) { //populating LetterTemplate data if (letterTemplateDataSet.Tables[0] != null && letterTemplateDataSet.Tables[0].Rows != null && letterTemplateDataSet.Tables[0].Rows.Count > 0) { LetterTemplate letterTemplateResult = new LetterTemplate { LetterTemplateId = GetValue <long>(letterTemplateDataSet.Tables[0].Rows[0]["LetterTemplateID"], typeof(long)), Name = GetStringValue(letterTemplateDataSet.Tables[0].Rows[0]["Name"]), TemplateText = GetStringValue(letterTemplateDataSet.Tables[0].Rows[0]["TemplateText"]), FacilityId = GetValue <int>(letterTemplateDataSet.Tables[0].Rows[0]["FacilityId"], typeof(int)) }; return(letterTemplateResult); } } return(null); }
public bool DeleteLetterTemplate( LetterTemplate letterTemplate) { if (letterTemplate == null) return false; _unitOfWork. LetterTemplateRepository.Delete(letterTemplate); _unitOfWork.Save(); return true; }
public ActionResult Create(LetterTemplate model) { model.LetterTemplateId = Guid.NewGuid(); model.ModifiedBy = model.OwnerID; model.OwningBusinessUnit = new Guid(Convert.ToString(Session["BusinessUnitID"])); return(SubmitForm(model, ActionType.Create)); }
// // GET: /LetterTemplate/Create public ActionResult Create() { LetterTemplate template = new LetterTemplate(); //template.Template = new Helpers.LetterTemplateHelper().GetDefaultGiftDetail(); return(View(template)); }
public UpdateLetterTemplateCommand(LetterTemplate template, Guid id, string userName) { _template = template; _id = id; _userName = userName; }
public async Task <string> UpdateTemplate(LetterTemplate letterTemplate, Guid id, string userName) { await _letterService.UpdateTemplate(letterTemplate, id, userName); return("Ok"); }
// // GET: /LetterTemplate/Edit/5 public ActionResult Edit(int id) { LetterTemplate lettertemplate = _letterTemplateService.FindById(id); lettertemplate.Template = Server.HtmlDecode(lettertemplate.Template); return(View(lettertemplate)); }
private void SetOwnerDBPart(MyProjectEntities projectContext, LetterTemplate owner, LetterTemplateDTO message) { owner.TableDrivedEntityID = message.TableDrivedEntityID; owner.Name = message.Name; owner.EntityListViewID = message.EntityListViewID; while (owner.LetterTemplatePlainField.Any()) { projectContext.LetterTemplatePlainField.Remove(owner.LetterTemplatePlainField.First()); } foreach (var item in message.PlainFields) { LetterTemplatePlainField dbField = new DataAccess.LetterTemplatePlainField(); dbField.FieldName = item.FieldName; dbField.EntityListViewColumnsID = (item.EntityListViewColumnsID == 0) ? (int?)null : item.EntityListViewColumnsID; dbField.FormulaID = (item.FormulaID == 0) ? (int?)null : item.FormulaID; owner.LetterTemplatePlainField.Add(dbField); } while (owner.LetterTemplateRelationshipField.Any()) { projectContext.LetterTemplateRelationshipField.Remove(owner.LetterTemplateRelationshipField.First()); } foreach (var item in message.RelationshipFields) { LetterTemplateRelationshipField dbField = new DataAccess.LetterTemplateRelationshipField(); dbField.FieldName = item.FieldName; dbField.EntityRelationshipTailID = item.RelationshipTailID; //dbField.NextLine = item.NextLine; dbField.IsRow = item.IsRow; //dbField.EntityPreDefinedSearchID = (item.EntityPreDefinedSearchID == 0) ? (int?)null : item.EntityPreDefinedSearchID; dbField.PartialLetterTemplateID = item.PartialLetterTemplateID; owner.LetterTemplateRelationshipField.Add(dbField); } }
public void Save(LetterTemplate letterTemplate) { this._db.OpenConnection(); MySqlCommand command = this._db.CreateCommand(); command.CommandText = "UPDATE letter_template SET kenmerk=?kenmerk, contactpersonen=?contactpersonen, telefoon=?telefoon, email=?email, avans_adres=?avans_adres, avans_locatie=?avans_locatie, begin_kern=?begin_kern, reis_informatie=?reis_informatie, verdere_informatie=?verdere_informatie, afzenders=?afzenders, bijlagen=?bijlagen, voettekst_links=?voettekst_links, voettekst_center=?voettekst_center, voettekst_rechts=?voettekst_rechts WHERE id = ?id"; command.Parameters.Add(new MySqlParameter("?id", MySqlDbType.Int32)).Value = letterTemplate.Id; command.Parameters.Add(new MySqlParameter("?kenmerk", MySqlDbType.String)).Value = letterTemplate.Kenmerk; command.Parameters.Add(new MySqlParameter("?contactpersonen", MySqlDbType.String)).Value = letterTemplate.Contactpersonen; command.Parameters.Add(new MySqlParameter("?telefoon", MySqlDbType.String)).Value = letterTemplate.Telefoon; command.Parameters.Add(new MySqlParameter("?email", MySqlDbType.String)).Value = letterTemplate.Email; command.Parameters.Add(new MySqlParameter("?avans_adres", MySqlDbType.String)).Value = letterTemplate.AvansAdres; command.Parameters.Add(new MySqlParameter("?avans_locatie", MySqlDbType.String)).Value = letterTemplate.AvansLocatie; command.Parameters.Add(new MySqlParameter("?begin_kern", MySqlDbType.Text)).Value = letterTemplate.BeginKern; command.Parameters.Add(new MySqlParameter("?reis_informatie", MySqlDbType.LongText)).Value = letterTemplate.ReisInformatie; command.Parameters.Add(new MySqlParameter("?verdere_informatie", MySqlDbType.Text)).Value = letterTemplate.VerdereInformatie; command.Parameters.Add(new MySqlParameter("?afzenders", MySqlDbType.String)).Value = letterTemplate.Afzenders; command.Parameters.Add(new MySqlParameter("?bijlagen", MySqlDbType.Text)).Value = letterTemplate.Bijlagen; command.Parameters.Add(new MySqlParameter("?voettekst_links", MySqlDbType.Text)).Value = letterTemplate.VoettekstLinks; command.Parameters.Add(new MySqlParameter("?voettekst_center", MySqlDbType.Text)).Value = letterTemplate.VoettekstCenter; command.Parameters.Add(new MySqlParameter("?voettekst_rechts", MySqlDbType.Text)).Value = letterTemplate.VoettekstRechts; this._db.ExecuteCommand(command); this._db.CloseConnection(); }
public ActionResult SubmitForm(LetterTemplate model, ActionType actionType) { List <string> errorMessage = new List <string>(); string successMessage = Resources.LetterTemplate.Alert_Success; if (ModelState.IsValid) { KeyValuePair <int, string> results = new KeyValuePair <int, string>(1, string.Empty); model.ModifiedBy = new Guid(Convert.ToString(Session["CurrentUserID"])); switch (actionType) { case ActionType.Create: results = db.LetterTemplate_Insert(model); break; case ActionType.Edit: results = db.LetterTemplate_Update(model); break; case ActionType.Delete: results = db.LetterTemplate_Delete(model); break; case ActionType.ChangeStatus: results = db.LetterTemplate_ChangeStatus(model); break; default: break; } if (results.Key == 0 || results.Key == 16 || results.Key == 6) { UrlHelper u = new UrlHelper(this.ControllerContext.RequestContext); string url = u.Action("Edit", "LetterTemplate", new { id = model.LetterTemplateId, success = successMessage }); string urlNew = u.Action("Create", "LetterTemplate"); var jsonData = new { flag = true, Message = url, urlNew = urlNew }; return(Json(jsonData)); } else { var jsonData = new { flag = false, Message = results.Value.ToString() }; return(Json(jsonData)); } } else { foreach (var key in ModelState.Keys) { var error = ModelState[key].Errors.FirstOrDefault(); if (error != null) { errorMessage.Add(error.ErrorMessage); } } var jsonData = new { flag = false, Message = errorMessage.First() }; return(Json(jsonData)); } }
// GET: LetterTemplate/Details/5 public ActionResult Details(int id) { IDbRepoInstantiator factory = HttpContext.RequestServices.GetService(typeof(IDbRepoInstantiator)) as IDbRepoInstantiator; LetterTemplate template = factory.GetLetterTemplateRepo().GetLetterTemplateInHtmlForm(id); ViewBag.Excuse = "Flu"; return(View(template)); }
public ActionResult MakeLetter(int id, string excuseName) { IDbRepoInstantiator factory = HttpContext.RequestServices.GetService(typeof(IDbRepoInstantiator)) as IDbRepoInstantiator; LetterTemplate template = factory.GetLetterTemplateRepo().GetLetterTemplateInHtmlForm(id); ViewBag.Excuse = excuseName; return(View(nameof(Details), template)); }
public async Task <string> UpdateLetterTemplate(LetterType type, [FromBody] LetterTemplate template) { template.Type = type; await _masterService.UpdateLetterTemplate(template); return("Ok"); }
public void BriefMakenClicked(List <SessionRow> sessions) { LetterTemplate letterTemplate = LetterTemplateMapper.Find(1); LetterWindow letterWindow = new LetterWindow(sessions, letterTemplate); letterWindow.ShowDialog(); }
private static string CompileCss(LetterTemplate htmlInput) { return($@"@media print {{ body {{ font-family: Helvetica, sans-serif; }} .header-table {{ width: 180mm; min-height: 90mm; table-layout:fixed; }} .header-table tr td:nth-child(1) {{ width: 110mm; min-height: 90mm; }} .header-table tr td:nth-child(2) {{ width: 70mm; min-height: 90mm; }} .header-table table tr td:nth-child(1) {{ height: 5mm !important; }} .header-table table tr td:nth-child(2) {{ height: 5mm !important; }} .header-table table tr:nth-child(5) td {{ height: 5mm !important; }} .header-table table tr:nth-child(7) td {{ height: 5mm !important; }} .header-right {{ width: 70mm; min-height: 90mm; }} .header-right p {{ margin-block-end: 1mm; margin-block-start: 0; }} .header-right p:last-of-type {{ margin-block-end: 5mm; }} .header-right table {{ border-spacing: 0; }} #address {{ x-overflow: hidden; width: 110mm; position: absolute; top: 34.5mm; left: 9.6mm; padding: 2mm; font-size: 8pt; }} {htmlInput.TemplateSpecificCss} }}"); }
public Task <string> UpdateTemplate(LetterTemplate template) { return(_requestProvider.BuildUpon(_url) .Uri($"/api/letter/template") .Method(HttpMethod.Put) .AddInterceptor(new JsonDeserializerInterceptor()) .Content(new JsonContent(template)) .Execute <string>()); }
private LetterTemplateDTO ToLetterTemplateDTO(LetterTemplate item) { LetterTemplateDTO result = new LetterTemplateDTO(); result.Name = item.Name; result.TableDrivedEntityID = item.TableDrivedEntityID; result.ID = item.ID; return(result); }
/// <summary> /// Gets the appeal templates. /// </summary> /// <returns></returns> public JsonResult GetAppealTemplates() { LetterTemplate appealLetterInfo = new LetterTemplate { FacilityId = GetCurrentFacilityId() }; List <LetterTemplate> letterTemplates = PostApiResponse <List <LetterTemplate> >(Constants.AppealLetter, Constants.GetAppealTemplates, appealLetterInfo); return(Json(new { letterTemplates }, JsonRequestBehavior.AllowGet)); }
// // GET: /LetterTemplate/Details/5 public ViewResult Details(int id) { LetterTemplate lettertemplate = _letterTemplateService.FindById(id); lettertemplate.Template = Server.HtmlDecode(lettertemplate.Template); return(View(lettertemplate)); //LetterTemplate lettertemplate = repositories.LetterTemplate.FindById(id); //lettertemplate.Template = Server.HtmlDecode(lettertemplate.Template); //return View(lettertemplate); }
public bool DeleteLetterTemplate(LetterTemplate letterTemplate) { if (letterTemplate == null) { return(false); } _unitOfWork.LetterTemplateRepository.Delete(letterTemplate); _unitOfWork.Save(); return(true); }
public ActionResult Edit(LetterTemplate lettertemplate) { if (ModelState.IsValid) { _letterTemplateService.EditLetterTemplate(lettertemplate); return(RedirectToAction("Index")); } return(View(lettertemplate)); }
public LetterWindow(List <SessionRow> sessions, LetterTemplate letterTemplate) { InitializeComponent(); tbKenmerk.Text = letterTemplate.Kenmerk; tbContactpersonen.Text = letterTemplate.Contactpersonen; tbTelefoon.Text = letterTemplate.Telefoon; tbEmail.Text = letterTemplate.Email; tbAvansAdres.Text = letterTemplate.AvansAdres; tbAvansLocatie.Text = letterTemplate.AvansLocatie; tbBeginKern.Text = letterTemplate.BeginKern; tbReisInformatie.Text = letterTemplate.ReisInformatie; tbVerdereInformatie.Text = letterTemplate.VerdereInformatie; tbAfzenders.Text = letterTemplate.Afzenders; tbBijlagen.Text = letterTemplate.Bijlagen; tbVoettekstLinks.Text = letterTemplate.VoettekstLinks; tbVoettekstMidden.Text = letterTemplate.VoettekstCenter; tbVoettekstRechts.Text = letterTemplate.VoettekstRechts; _experts = new List <Expert>(); _receivers = new Dictionary <int, Expert>(); _sessions = sessions; // Note: Dit ziet er misschien klote uit, maar een List.Contains check schijnt niet te werken(mogelijk zijn er dubbele expert objecten?) Dictionary <int, Expert> experts = new Dictionary <int, Expert>(); foreach (SessionRow session in sessions) { Session sessionModel = session.GetSessionModel(); foreach (KeyValuePair <int, Expert> keyValuePair in sessionModel.Experts) { if (!experts.ContainsKey(keyValuePair.Key)) { experts.Add(keyValuePair.Key, keyValuePair.Value); } } } // En nu weer naar een List omdat Dictionary faalt en niet kan sorten foreach (KeyValuePair <int, Expert> keyValuePair in experts) { _experts.Add(keyValuePair.Value); } _experts.Sort(); ExpertsToevoegen(); _controller = PAZController.GetInstance(); _ini = _controller.IniReader; _letterTemplate = letterTemplate; btnSave.IsEnabled = false; }
public ActionResult Create(LetterTemplate lettertemplate) { if (ModelState.IsValid) { _letterTemplateService.AddLetterTemplate(lettertemplate); // repositories.LetterTemplate.Add(lettertemplate); return RedirectToAction("Index"); } return View(lettertemplate); }
public ActionResult Create(LetterTemplate lettertemplate) { if (ModelState.IsValid) { _letterTemplateService.AddLetterTemplate(lettertemplate); // repositories.LetterTemplate.Add(lettertemplate); return(RedirectToAction("Index")); } return(View(lettertemplate)); }
private void SetOwnerPart(DR_Requester requester, LetterTemplateDTO result, LetterTemplate ownerDbItem, bool withDetails) { result.TableDrivedEntityID = ownerDbItem.TableDrivedEntityID; result.Name = ownerDbItem.Name; result.EntityListViewID = ownerDbItem.EntityListViewID; if (withDetails) { BizEntityListView bizEntityListView = new BizEntityListView(); result.EntityListView = bizEntityListView.GetEntityListView(requester, ownerDbItem.EntityListViewID); if (result.EntityListView == null) { throw new Exception("عدم دسترسی به لیست نمایش به شناسه" + " " + ownerDbItem.EntityListViewID); } BizFormula bizFormula = new BizFormula(); foreach (var item in ownerDbItem.LetterTemplatePlainField) { LetterTemplatePlainFieldDTO field = new LetterTemplatePlainFieldDTO(); field.FieldName = item.FieldName; field.EntityListViewColumnsID = (item.EntityListViewColumnsID == null) ? 0 : item.EntityListViewColumnsID.Value; if (field.EntityListViewColumnsID != 0) { field.EntityListViewColumns = result.EntityListView.EntityListViewAllColumns.First(x => x.ID == item.EntityListViewColumnsID); } field.FormulaID = (item.FormulaID == null) ? 0 : item.FormulaID.Value; field.ID = item.ID; //if (item.ColumnID != null) // field.Type = LetterTemplateFieldType.Column; //else if (item.ParameterID != null) // field.Type = LetterTemplateFieldType.Parameter; //if (item.RelationshipID != null) // field.Type = LetterTemplateFieldType.RangeRelationship; result.PlainFields.Add(field); } BizEntityRelationshipTail bizEntityRelationshipTail = new MyModelManager.BizEntityRelationshipTail(); foreach (var item in ownerDbItem.LetterTemplateRelationshipField) { LetterTemplateRelationshipFieldDTO field = new LetterTemplateRelationshipFieldDTO(); field.RelationshipTailID = item.EntityRelationshipTailID; //field.EntityPreDefinedSearchID = (item.EntityPreDefinedSearchID == null) ? 0 : item.EntityPreDefinedSearchID.Value; field.ID = item.ID; field.RelationshipTail = bizEntityRelationshipTail.ToEntityRelationshipTailDTO(item.EntityRelationshipTail); //field.NextLine = item.NextLine==true; field.IsRow = item.IsRow == true; field.FieldName = item.FieldName; field.PartialLetterTemplateID = item.PartialLetterTemplateID; field.PartialLetterTemplate = ToPartialLetterTemplateDTO(requester, item.PartialLetterTemplate, true); //field.PartialLetterTemplate = ToPartialLetterTemplate(item.PartialLetterTemplate, true); result.RelationshipFields.Add(field); } } }
/// <summary> /// Deletes the specified identifier. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public JsonResult Delete(long id) { LetterTemplate letterTemplate = new LetterTemplate { LetterTemplateId = id, UserName = GetCurrentUserName() }; bool isSuccess = PostApiResponse <bool>(Constants.LetterTemplate, Constants.DeleteLetter, letterTemplate); return(Json(new { sucess = isSuccess })); }
public void GetLetterTemplateById() { var mockLetterTemplateLogic = new Mock <ILetterTemplateRepository>(); LetterTemplate result = new LetterTemplate(); mockLetterTemplateLogic.Setup(f => f.GetLetterTemplateById(It.IsAny <LetterTemplate>())).Returns(result); LetterTemplateLogic target = new LetterTemplateLogic(mockLetterTemplateLogic.Object); LetterTemplate actual = target.GetLetterTemplateById(new LetterTemplate()); Assert.AreEqual(result, actual); }
public void BriefMakenBevestigingClicked(Dictionary <int, Expert> receivers, LetterTemplate letterTemplate) { // dit zorgt ervoor dat er geen filters worden toegepast in de PDF uitdraai MainWindow.textboxSearch.Text = ""; string fileName; if (MainWindow.OpenNewSaveDialog("Bevestigingsbrieven PAZ", ".pdf", "PDF (.pdf)|*.pdf", out fileName) == true) { // maak en exporteer als pdf PDFexporter.CreateLetterPDF(fileName, receivers, letterTemplate); } }
public async Task UpdateTemplate(LetterTemplate template, Guid id, string userName) { var param = new DynamicParameters(); param.Add("@ID", template.ID); param.Add("@Body", template.Body); await SqlMapper.ExecuteAsync(_unitOfWork.Connection, "UpdateLetterTemplate", param, commandType : CommandType.StoredProcedure, transaction : _unitOfWork.Transaction); }
private void InsertToLetterTemplate(string name, int templateType) { name = name.Substring(3); var letter = new LetterTemplate() { Name = name, FileName = name, TemplateType = templateType }; var client = new TemplateManagerClient(); client.InsertToLetterTemplate(letter); }
public ActionResult Create() { var businessunitid = new Guid(Convert.ToString(Session["BusinessUnitID"])); var systemuserid = new Guid(Convert.ToString(Session["CurrentUserID"])); var types = db.pickList.ToList() .Where(a => a.EntityName.Equals("lettertemplate") && a.AttributeName.Equals("type")) .OrderBy(a => a.DisplayOrder) .GroupBy(p => new { p.EntityName, p.AttributeName, p.DisplayOrder, p.AttributeValue, p.label }) .Select(p => new SelectListItem { Text = p.Key.label, Value = p.Key.AttributeValue.ToString() }) .ToList(); var languages = db.pickList.ToList() .Where(a => a.EntityName.Equals("lettertemplate") && a.AttributeName.Equals("language")) .OrderBy(a => a.DisplayOrder) .GroupBy(p => new { p.EntityName, p.AttributeName, p.DisplayOrder, p.AttributeValue, p.label }) .Select(p => new SelectListItem { Text = p.Key.label, Value = p.Key.AttributeValue.ToString() }) .ToList(); var userid = db.systemUser.Single(p => p.SystemUserId == systemuserid); ViewData["ddl_types"] = types; ViewData["ddl_languages"] = languages; LetterTemplate model = new LetterTemplate(); model.OwnerID = systemuserid; model.OwnerName = userid.FullName; return(View(model)); }
public bool EditLetterTemplate( LetterTemplate letterTemplate) { _unitOfWork. LetterTemplateRepository.Edit(letterTemplate); _unitOfWork.Save(); return true; }
private void InsertToLetterTemplate(string name,int templateType) { name = name.Substring(3); var letter = new LetterTemplate() { Name = name, FileName = name, TemplateType = templateType }; var client= new TemplateManagerClient(); client.InsertToLetterTemplate(letter); }
public ActionResult Edit(LetterTemplate lettertemplate) { if (ModelState.IsValid) { _letterTemplateService.EditLetterTemplate(lettertemplate); return RedirectToAction("Index"); } return View(lettertemplate); }
// // GET: /LetterTemplate/Create public ActionResult Create() { LetterTemplate template = new LetterTemplate(); //template.Template = new Helpers.LetterTemplateHelper().GetDefaultGiftDetail(); return View(template); }