public bool AddController(Model.ControllerModel controller) { int intEffectiveRows = 0; try { //StringBuilder sbControllerSQL = new StringBuilder("Replace into Controller(ID,PrimaryFlag,TypeID,DeviceAddressLength,Name,PortName,BaudRate,MachineNumber,Version,ProjectID) values("); //sbControllerSQL.Append(controller.ID + ",'"); //sbControllerSQL.Append(controller.PrimaryFlag + "',");//+ "',0);"); //sbControllerSQL.Append((int)controller.Type + ","); //sbControllerSQL.Append(controller.DeviceAddressLength + ",'"); //sbControllerSQL.Append(controller.Name + "','"); //sbControllerSQL.Append(controller.PortName + "',"); //sbControllerSQL.Append(controller.BaudRate + ",'"); //sbControllerSQL.Append(controller.MachineNumber + "',"); //sbControllerSQL.Append(controller.Version + ","); //sbControllerSQL.Append(controller.Project.ID + ")"); //intEffectiveRows = _databaseService.ExecuteBySql(sbControllerSQL); intEffectiveRows = _dbFileVersionService.AddController(controller); } catch { intEffectiveRows = 0; } if (intEffectiveRows > 0) { return(true); } else { return(false); } }