private void PrepareTemplateList() { FlowInspectorApplication.CountryTemplateModel = new List <DataSet.CountryTemplateModel>(); List <Service> allServices = Service.CreateManager().Load(); List <Data.Merchant> addedMerchant = new List <Data.Merchant>(); foreach (Service s in allServices) { CountryTemplateModel countryTemplateModel = this.GetByCountry(s.FallbackCountry); if (countryTemplateModel == null) { countryTemplateModel = new DataSet.CountryTemplateModel(s.FallbackCountry); FlowInspectorApplication.CountryTemplateModel.Add(countryTemplateModel); } MerchantTemplateModel merchantTemplateModel = countryTemplateModel[s.Merchant.ID]; if (merchantTemplateModel == null) { merchantTemplateModel = new MerchantTemplateModel(s.Merchant); countryTemplateModel.Merchants.Add(merchantTemplateModel); } ServiceTemplateModel serviceTemplateModel = merchantTemplateModel[s.ID]; if (serviceTemplateModel == null) { serviceTemplateModel = new ServiceTemplateModel(s); merchantTemplateModel.Services.Add(serviceTemplateModel); } } }
public ActionResult ServiceFlowsView() { string sid = Request["sid"] != null ? Request["sid"].ToString() : string.Empty; int serviceID; if (!Int32.TryParse(sid, out serviceID)) { return(this.Content("Service id is not set")); } ServiceTemplateModel serviceTemplateModel = FlowInspectorApplication.GetServiceModelByString(sid); if (serviceTemplateModel == null) { return(this.Content("ServiceTemplateModel is empty")); } ServiceFlowsViewModel model = new ServiceFlowsViewModel(); model.Flows = serviceTemplateModel.Flows; return(PartialView("_ServiceFlow", model)); //return this.Json(new { status = true, url = Url.Action("_ServiceFlow", vm) }, JsonRequestBehavior.AllowGet); }
public static int InsertServiceTemplate(ServiceTemplateModel service) { string sql = @"INSERT OR IGNORE INTO ServiceTemplates (ServiceTemplateName, ServiceTemplateAbbreviation, ServiceTemplateDescription, ServiceType, ServiceDirectionId, CalculatedDuration, RouteId) VALUES(@ServiceTemplateName, @ServiceTemplateAbbreviation, @ServiceTemplateDescription, @ServiceType, @ServiceDirectionId, @CalculatedDuration, @RouteId);SELECT last_insert_rowid();"; return(SQLiteData.SaveData <dynamic>(sql, new { service.ServiceTemplateName, service.ServiceTemplateAbbreviation, service.ServiceTemplateDescription, service.ServiceType, service.ServiceDirectionId, service.CalculatedDuration, service.RouteId }, SQLiteData.GetConnectionString())); }
public ActionResult AddFlow() { string _title = Request["title"] != null ? Request["title"].ToString() : string.Empty; string _serviceID = Request["serviceID"] != null ? Request["serviceID"].ToString() : string.Empty; string _flowID = Request["flowID"] != null ? Request["flowID"].ToString() : string.Empty; ServiceTemplateModel serviceModel = FlowInspectorApplication.GetServiceModelByString(_serviceID); if (serviceModel == null) { return(this.Json(new { status = false, message = "Internal error. COuld not load serviceModel by id:" + _serviceID })); } if (string.IsNullOrEmpty(_title)) { return(this.Json(new { strus = false, message = "Title is not set!" })); } if (string.IsNullOrEmpty(_serviceID)) { return(this.Json(new { status = false, message = "ServiceID is not set" })); } int flowID; if (!Int32.TryParse(_flowID, out flowID)) { return(this.Json(new { status = false, message = "FlowID is not set" })); } if (flowID == -1) { TemplateServiceFlow ts = new TemplateServiceFlow(flowID, serviceModel.ServiceData, _title, DateTime.Now, DateTime.Now); ts.Insert(); serviceModel.Flows.Add(ts); return(this.Json(new { status = true, message = "Inserted", id = ts.ID })); } else { TemplateServiceFlow ts = TemplateServiceFlow.CreateManager().Load(flowID); ts.Title = _title; ts.Update(); return(this.Json(new { status = true, message = "Updated!", id = ts.ID })); } }
public static void UpdateServiceTemplate(ServiceTemplateModel service) { string sql = @"UPDATE OR IGNORE ServiceTemplates SET ServiceTemplateName=@ServiceTemplateName, ServiceTemplateAbbreviation=@ServiceTemplateAbbreviation, ServiceTemplateDescription=@ServiceTemplateDescription, ServiceType=@ServiceType, ServiceDirectionId=@ServiceDirectionId, CalculatedDuration=@CalculatedDuration, RouteId=@RouteId WHERE Id=@Id"; SQLiteData.SaveData <dynamic>(sql, new { service.ServiceTemplateName, service.ServiceTemplateAbbreviation, service.ServiceTemplateDescription, service.ServiceType, service.ServiceDirectionId, service.CalculatedDuration, service.RouteId, service.Id }, SQLiteData.GetConnectionString()); }
private void ImportServiceTemplates(string[] fields) { var serviceTemplate = new ServiceTemplateModel(); serviceTemplate.Id = int.Parse(fields[1]); serviceTemplate.ServiceTemplateName = fields[2]; serviceTemplate.ServiceTemplateAbbreviation = fields[3]; serviceTemplate.ServiceTemplateDescription = fields[4]; serviceTemplate.ServiceType = fields[5]; int oldServiceDirectionId = int.Parse(fields[6]); serviceTemplate.ServiceDirectionId = ServiceDirectionKeys.GetValueOrDefault(oldServiceDirectionId, 0); serviceTemplate.CalculatedDuration = int.Parse(fields[7]); serviceTemplate.RouteId = newRouteId; var newServiceTemplateId = ServiceTemplateDataAccess.InsertServiceTemplate(serviceTemplate); ServiceTemplateKeys.Add(serviceTemplate.Id, newServiceTemplateId); }
public void SaveServiceTemplate() { var newService = new ServiceTemplateModel(); newService.CalculatedDuration = CalculatedDuration; newService.ServiceTemplateAbbreviation = ServiceTemplateAbbreviation; newService.ServiceTemplateDescription = ServiceTemplateDescription; newService.ServiceTemplateName = ServiceTemplateName; newService.ServiceType = SelectedServiceClass.ServiceClassName; newService.ServiceDirectionId = ServiceDirectionId; newService.RouteId = RouteId; if (ServiceTemplateId <= 0) { ServiceTemplateDataAccess.InsertServiceTemplate(newService); } else { newService.Id = ServiceTemplateId; ServiceTemplateDataAccess.UpdateServiceTemplate(newService); } ServiceTemplateUI.ServiceTemplateList = new BindableCollection <ServiceTemplateModel>(ServiceTemplateDataAccess.GetServiceTemplatesPerRoute(RouteId)); ClearServiceTemplate(); }
public ServiceTemplateViewModel(ServiceTemplateModel storageServiceTemplate) { this.storageServiceTemplate = storageServiceTemplate; this.PropertyChanged += ServiceTemplateViewModel_PropertyChanged; }
public TemplateJobViewModel(ServiceTemplateModel service, JobModel job) { this.JobId = job.Id; this.JobName = job.Text; this.serviceParent = service; }
private void AddNewServiceTemplate() { this.AllServiceTemplates.Add(new ServiceTemplateViewModel(ServiceTemplateModel.CreateNewServiceTemplate(SelectedServiceTemplateGroup.Id))); Workspace.RegisterDataChanged(); SelectedSubIndex = this.AllServiceTemplates.Count - 1; }