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;
}
