public static ContractTemplate[] GetTemplates() { using (var db = new PricingPortalEntities()) { return(db.ContractTemplates.ToArray()); } }
public static ContractTemplate[] GetTemplates() { using (var db = new PricingPortalEntities()) { return db.ContractTemplates.ToArray(); } }
public static ContractTemplateType[] GetTemplateTypes() { using (var db = new PricingPortalEntities()) { var query = from b in db.ContractTemplateTypes select b; return(query.ToArray()); } }
public static ContractTemplate[] GetTemplatesByType(int typeId) { using (var db = new PricingPortalEntities()) { var query = from b in db.ContractTemplates where b.ContractTemplateTypeId == typeId select b; return(query.ToArray()); } }
public static ContractTemplate GetTemplateByNameAndType(int typeId, string name) { using (var db = new PricingPortalEntities()) { var query = from b in db.ContractTemplates where b.ContractTemplateTypeId == typeId && b.TemplateName == name select b; return(query.First()); } }
public static ContractTemplate GetTemplateById(int id) { using (var db = new PricingPortalEntities()) { var query = from b in db.ContractTemplates where b.ContractTemplateId == id select b; return(query.First()); } }
public static void UpdateTemplate(int templateId, string templateHtml) { using (var db = new PricingPortalEntities()) { ContractTemplate template = db.ContractTemplates.First(c => c.ContractTemplateId == templateId); template.HtmlContent = templateHtml; db.SaveChanges(); } }
public static ContractTemplate[] GetTemplatesByType(int typeId) { using (var db = new PricingPortalEntities()) { var query = from b in db.ContractTemplates where b.ContractTemplateTypeId == typeId select b; return query.ToArray(); } }
public static ContractTemplate GetTemplateByNameAndType(int typeId, string name) { using (var db = new PricingPortalEntities()) { var query = from b in db.ContractTemplates where b.ContractTemplateTypeId == typeId && b.TemplateName == name select b; return query.First(); } }
public static ContractTemplate GetTemplateById(int id) { using (var db = new PricingPortalEntities()) { var query = from b in db.ContractTemplates where b.ContractTemplateId == id select b; return query.First(); } }
public static void CreateTemplatesType(string typeCode, string typeDesc) { using (var db = new PricingPortalEntities()) { ContractTemplateType newType = new ContractTemplateType() { TemplateTypeCode = typeCode, Description = typeDesc }; db.ContractTemplateTypes.Add(newType); db.SaveChanges(); } }
public static void CreateTemplatesType(string typeCode, string typeDesc) { using (var db = new PricingPortalEntities()) { ContractTemplateType newType = new ContractTemplateType() { TemplateTypeCode = typeCode, Description = typeDesc }; db.ContractTemplateTypes.Add(newType); db.SaveChanges(); } }
public static void CreateTemplate(string templateName, string templateHtml, int templateTypeId) { using (var db = new PricingPortalEntities()) { ContractTemplate newTemplate = new ContractTemplate() { CreateDate = DateTime.Now, CreateUserId = 16, EffectiveDate = DateTime.MinValue, EndDate = DateTime.MaxValue, TemplateName = templateName, HtmlContent = templateHtml, ContractTemplateTypeId = templateTypeId }; db.ContractTemplates.Add(newTemplate); db.SaveChanges(); } }
public static void CreateTemplate(string templateName, string templateHtml, int templateTypeId) { using (var db = new PricingPortalEntities()) { ContractTemplate newTemplate = new ContractTemplate() { CreateDate = DateTime.Now, CreateUserId = 16, EffectiveDate = DateTime.MinValue, EndDate = DateTime.MaxValue, TemplateName = templateName, HtmlContent = templateHtml, ContractTemplateTypeId = templateTypeId }; db.ContractTemplates.Add(newTemplate); db.SaveChanges(); } }
public static ContractTemplateType[] GetTemplateTypes() { using (var db = new PricingPortalEntities()) { var query = from b in db.ContractTemplateTypes select b; return query.ToArray(); } }
public static void UpdateTemplate(int templateId, string templateHtml) { using (var db = new PricingPortalEntities()) { ContractTemplate template = db.ContractTemplates.First(c => c.ContractTemplateId == templateId); template.HtmlContent = templateHtml; db.SaveChanges(); } }