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));
}
}
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();
}
// 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);
}
